Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
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
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 16,289
Likes: 115
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,289
Likes: 115
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.
Do you need Forum Install or Upgrade Services?
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!
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
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
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 16,289
Likes: 115
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,289
Likes: 115
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.
Do you need Forum Install or Upgrade Services?
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!
Joined: Apr 2004
Posts: 1,945
Likes: 145
UBB.threads Developer
UBB.threads Developer
Joined: Apr 2004
Posts: 1,945
Likes: 145


Current developer of UBB.threads PHP Forum Software
Current Release: UBBT 7.7.5 // Preview: UBBT 8.0.0
isaac @ id242.com // my forum @ CelicaHobby.com
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
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
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
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/2018 8:17 AM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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/2018 8:27 AM.

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
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
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
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/2018 8:34 AM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
I don't follow you there ( query in say the html includes ) where is it located?


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
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
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 987
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 987
Likes: 24
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/2018 9:10 AM.

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

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Forum Privacy Policy
by ECNet - 02/26/2024 11:58 AM
Who's Online Now
1 members (domspeak), 337 guests, and 176 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)