Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
0 registered members (), 65 guests, and 219 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
Posts: 673
Joined: June 2006
Show All Member Profiles 
Top Posters(30 Days)
isaac 13
Ruben 6
Morgan 4
M4TT 4
fidel 1
Gizmo 1
Latest Photos
Trees
Retreats
Rooms
Big stuff
Test
Previous Thread
Next Thread
Print Thread
Forum database - Table prefix question #261345
04/15/18 06:45 AM
04/15/18 06:45 AM
Morgan  Offline OP
Addict
Joined: Jun 2006
Posts: 670
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
Re: Forum database - Table prefix question [Re: Morgan] #261347
04/15/18 01:04 PM
04/15/18 01:04 PM
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,809
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 04:55 AM
04/16/18 04:55 AM
Morgan  Offline OP
Addict
Joined: Jun 2006
Posts: 670
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 05:00 AM
04/16/18 05:00 AM
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 15,809
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 05:03 AM
04/16/18 05:03 AM
isaac  Offline
UBB.threads Developer
Joined: Apr 2004
Posts: 1,352


isaac @ id242.com // my forum @ CelicaHobby.com
a current developer of UBB.threads php forum software // 7.7.2 Progress Notes
Re: Forum database - Table prefix question [Re: Morgan] #261362
04/16/18 05:21 AM
04/16/18 05:21 AM
Morgan  Offline OP
Addict
Joined: Jun 2006
Posts: 670
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 08:16 AM
04/16/18 08:16 AM
Morgan  Offline OP
Addict
Joined: Jun 2006
Posts: 670
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 08: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 08:17 AM
04/16/18 08:17 AM
Ruben  Offline
Joined: Dec 2003
Posts: 5,871
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 08:24 AM
04/16/18 08:24 AM
Ruben  Offline
Joined: Dec 2003
Posts: 5,871
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 08: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 08:28 AM
04/16/18 08:28 AM
Morgan  Offline OP
Addict
Joined: Jun 2006
Posts: 670
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 08:32 AM
04/16/18 08:32 AM
Morgan  Offline OP
Addict
Joined: Jun 2006
Posts: 670
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 08: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 08:46 AM
04/16/18 08:46 AM
Ruben  Offline
Joined: Dec 2003
Posts: 5,871
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 08:51 AM
04/16/18 08:51 AM
Morgan  Offline OP
Addict
Joined: Jun 2006
Posts: 670
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 09:05 AM
04/16/18 09:05 AM
Morgan  Offline OP
Addict
Joined: Jun 2006
Posts: 670
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 09:09 AM
04/16/18 09:09 AM
Morgan  Offline OP
Addict
Joined: Jun 2006
Posts: 670
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 09:10 AM.

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

ShoutChat Box
Today's Birthdays
No Birthdays
Recent Topics
Geo Targeting Display of Custom Islands?
by PianoWorld - 04/15/19 01:08 PM
How-To Guides and Technical Articles
by Morgan - 04/06/19 08:46 AM
i am not a robot.
by Anonymous - 03/29/19 07:18 PM
What directory are avatar images saved in?
by CyberChild - 03/29/19 12:57 PM
EU Data Protection Notice
by M4TT - 03/27/19 09:23 PM
Forum Statistics
Forums35
Topics35,271
Posts192,336
Members12,157
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.7.2
(Snapshot build 20190326)