Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
3 registered members (JAISP, Zarzal, isaac), 70 guests, and 231 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
QSS Tim
QSS Tim
Oroville, CA
Posts: 98
Joined: October 2004
Show All Member Profiles 
Top Posters(30 Days)
isaac 22
Gizmo 17
TheBrit 14
Zarzal 12
SteveS 8
jorb 4
Ruben 4
Latest Photos
Test
Testing to drag photos
Comfortable Cats
Test
BSA photos
Previous Thread
Next Thread
Print Thread
Forum database - Table prefix question #261345
04/15/18 05:45 AM
04/15/18 05:45 AM
Morgan  Offline
OP
Addict
Joined: Jun 2006
Posts: 609
Sweden
Hi

I am annoyed by the fact I changed settings for the forum database - Table prefix when I created the forum many years ago.
everytime I read instructions how to change things I need to remember to add three letters to the sql queries
like this

original example
Quote
truncate table ubbt_SHOUT_BOX


my setting
Quote
truncate table ubbt_bbfSHOUT_BOX


My question is there a possibility to remove the "ubbt_bbf" from the table prefix and set it as standard "ubbt_" if so how would i be able to do it?

Thanks for your input smile


Morgan Johansson
BritBike Forum
http://www.britbike.com/forums/ubbthreads.php?
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
Re: Forum database - Table prefix question [Re: Morgan] #261347
04/15/18 12:04 PM
04/15/18 12:04 PM
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 17,016
Portland, OR; USA
Close your forums, then go in via PHPMyAdmin and rename all of the databases with the new prefix, then change the prefix in the config file.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Forum database - Table prefix question [Re: Morgan] #261359
04/16/18 03:55 AM
04/16/18 03:55 AM
Morgan  Offline
OP
Addict
Joined: Jun 2006
Posts: 609
Sweden
Hi Gizmo,
I opened CP for my website >> PHPMyAdmin >> and looked at the database but don't know how to rename the tables.
Is that an easy and secure fix or what can I expect?
I understand I will have to do it manually with each tables.


Morgan Johansson
BritBike Forum
http://www.britbike.com/forums/ubbthreads.php?
Re: Forum database - Table prefix question [Re: Morgan] #261360
04/16/18 04:00 AM
04/16/18 04:00 AM
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 17,016
Portland, OR; USA
When viewing a table the rename option will be under operations. Nothing is really easy and fast, it's slow and steady as you're making huge changes to container names that house your forum data.

You can expect your forum to continue trying to write data as you are changing the table names, so be sure that you both close your forums and back up the data before make any changes.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Need to Upgrade?
Forums: A Gardeners Forum Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Re: Forum database - Table prefix question [Re: Morgan] #261361
04/16/18 04:03 AM
04/16/18 04:03 AM
isaac  Online Splat
UBB.threads Developer
Joined: Apr 2004
Posts: 1,251
California


isaac @ id242.com // my forum @ CelicaHobby.com
a current developer of UBB.threads php forum software // 7.6.2 Released
Re: Forum database - Table prefix question [Re: Morgan] #261362
04/16/18 04:21 AM
04/16/18 04:21 AM
Morgan  Offline
OP
Addict
Joined: Jun 2006
Posts: 609
Sweden
Thank you for your input that is one step closer.

So open ea table and go to operations, change name and hit go.

My database is 1,3 GB and what would be the best way to do a backup?
I believe i tried before to Gzip but it failed.
I am running daily website backups thru my host interservers whm would that be enought?

Thanks


Morgan Johansson
BritBike Forum
http://www.britbike.com/forums/ubbthreads.php?
Re: Forum database - Table prefix question [Re: Morgan] #261363
04/16/18 07:16 AM
04/16/18 07:16 AM
Morgan  Offline
OP
Addict
Joined: Jun 2006
Posts: 609
Sweden
OK here is the status, I-
- closed the forum
- did back up on the database
- in PHPAdmin I changed (removed "bbf") from each table name
- downloaded a new backup
- removed "bbf" from the table prefix in the config.inc.php file. now it reads "ubbt_"

I could login as admin and checked the Control Panel / Database & Paths >> and table prefix reads ubbt_
I can see various topics and replies

I then went to Control Panel / Cache Manager and clicked on update cache and got this
Control Panel Message

Quote
Script: /XXXX/CCCCC/public_html/forums/cache_builders/custom/portal_box_46.php
Line#: 9
SQL Error: Table 'britbike_com.ubbt_bbfFILES' doesn't exist
SQL Error #: 1146
Query: select POST_ID,FILE_DIR,FILE_NAME from ubbt_bbfFILES where FILE_DIR <> '' order by rand() limit 1


Is there something to be worried about or do I need to alter any other files???
I have not turned on the forum yet and awaits your input while you are a sleep. That's the beauty with 9 hours diferences in timezones.

Thanks

Last edited by Morgan; 04/16/18 07:17 AM.

Morgan Johansson
BritBike Forum
http://www.britbike.com/forums/ubbthreads.php?
Re: Forum database - Table prefix question [Re: Morgan] #261364
04/16/18 07:17 AM
04/16/18 07:17 AM
R
Ruben  Offline

Joined: Dec 2003
Posts: 5,952
Lutz,FL
Originally Posted by Morgan

My database is 1,3 GB and what would be the best way to do a backup?
I believe i tried before to Gzip but it failed.
I am running daily website backups thru my host interservers whm would that be enought?

Thanks

When you say website backups you mean just the folders and files correct.?
If so that does not include databases.
See if you have a option on whm to backup and restore databases.
I know cpanel does.

PHPadmin is okay for small databases but it usually has a very small kb limit to import back to restore.
Which means even if it works to export it probably will fail if you need to restore your database.
of course the best way is if they provide you command line access to your server.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Forum database - Table prefix question [Re: Morgan] #261365
04/16/18 07:24 AM
04/16/18 07:24 AM
R
Ruben  Offline

Joined: Dec 2003
Posts: 5,952
Lutz,FL
portalbox46 is one of your islands that has a query in it.
You need to figure out which one it is.
Because it would be one of your custom islands try to edit it in the control panel.
The numbers on the left side would be 46.
if notthe quick way would be to ftp to the site and view the file and edit it if needed.

Last edited by Ruben; 04/16/18 07:27 AM.

Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Forum database - Table prefix question [Re: Morgan] #261366
04/16/18 07:28 AM
04/16/18 07:28 AM
Morgan  Offline
OP
Addict
Joined: Jun 2006
Posts: 609
Sweden
Ruben the VWM is doing backups on all and yes one can choose
I will go to ftp and check portalbox46


Morgan Johansson
BritBike Forum
http://www.britbike.com/forums/ubbthreads.php?
Re: Forum database - Table prefix question [Re: Morgan] #261367
04/16/18 07:32 AM
04/16/18 07:32 AM
Morgan  Offline
OP
Addict
Joined: Jun 2006
Posts: 609
Sweden
Ruben I found portalbox46 in the admin cp it was in a Random Gallery photo script and removed "bbf" and tested.
it worked fine to clear the cashe. Thanks alot for your input smile

I wonder if I need to test anything else before I turn on the forum again?

Last edited by Morgan; 04/16/18 07:34 AM.

Morgan Johansson
BritBike Forum
http://www.britbike.com/forums/ubbthreads.php?
Re: Forum database - Table prefix question [Re: Morgan] #261368
04/16/18 07:46 AM
04/16/18 07:46 AM
R
Ruben  Offline

Joined: Dec 2003
Posts: 5,952
Lutz,FL
Only thing I can think of is another custom island or if you used a query in say the html includes.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers
Re: Forum database - Table prefix question [Re: Morgan] #261369
04/16/18 07:51 AM
04/16/18 07:51 AM
Morgan  Offline
OP
Addict
Joined: Jun 2006
Posts: 609
Sweden
I don't follow you there ( query in say the html includes ) where is it located?


Morgan Johansson
BritBike Forum
http://www.britbike.com/forums/ubbthreads.php?
Re: Forum database - Table prefix question [Re: Morgan] #261370
04/16/18 08:05 AM
04/16/18 08:05 AM
Morgan  Offline
OP
Addict
Joined: Jun 2006
Posts: 609
Sweden
Since I fixed the portalbox46 I have had no errors in the log so I guess I could turn it on again. smile fingers crossed knock on wood


Morgan Johansson
BritBike Forum
http://www.britbike.com/forums/ubbthreads.php?
Re: Forum database - Table prefix question [Re: Morgan] #261371
04/16/18 08:09 AM
04/16/18 08:09 AM
Morgan  Offline
OP
Addict
Joined: Jun 2006
Posts: 609
Sweden
Its now open, i posted a thread and posted a reply, it seems to work. puh.. Thanks for all input folks!

Last edited by Morgan; 04/16/18 08:10 AM.

Morgan Johansson
BritBike Forum
http://www.britbike.com/forums/ubbthreads.php?

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Calendar Function
by TheBrit. 12/17/18 10:05 PM
Speaking of Http to https, complaints from user
by PianoWorld. 12/16/18 03:40 PM
update multilanguage site problem
by Zarzal. 12/15/18 04:20 PM
Char coding utf-8 and older forums
by Zarzal. 12/15/18 03:59 PM
table issue
by TheBrit. 12/13/18 06:05 PM
Forum Statistics
Forums36
Topics35,182
Posts191,701
Members12,122
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.2