MySQL table prefixes of vb3_ is making life difficult

[sim tech]

I purcahsed vBulletin about 2 months ago (currently running on 3.0.7) and I'm finding a lot of headaces when doing mods because of the prefix in placed on all the MySQL tables.

I have about 10 or so mods done... nothing too severe (like vbadvanced) but I do have the arcade abd vbookie, as well as several additions to the "store" of ucash & ushop.

Everytime I do a mod it always seems to not go by default... because of when I originally installed vBulletin it assigned a "vb3_" to all of the MySQL tables.

I do not want to dump everything and start from scratch, as I have about 200 users signed up and several hundred good posts. Is there any way that I can just rename all of the tables, or would that really screw things up? I don't know much about queries but now I see that every time a mod comes out where there's database queries I have to be careful to make sure I change the line of the table name!

[Zachery]

Originally Posted by sim tech

I purcahsed vBulletin about 2 months ago (currently running on 3.0.7) and I'm finding a lot of headaces when doing mods because of the prefix in placed on all the MySQL tables.

I have about 10 or so mods done... nothing too severe (like vbadvanced) but I do have the arcade abd vbookie, as well as several additions to the "store" of ucash & ushop.

Everytime I do a mod it always seems to not go by default... because of when I originally installed vBulletin it assigned a "vb3_" to all of the MySQL tables.

I do not want to dump everything and start from scratch, as I have about 200 users signed up and several hundred good posts. Is there any way that I can just rename all of the tables, or would that really screw things up? I don't know much about queries but now I see that every time a mod comes out where there's database queries I have to be careful to make sure I change the line of the table name!

Almost every modification on this forum should be using table prefixes (unless the coders name is Brian Gunter) otherwise. Theres no problem.

I've been using table prefixes since the beginign.

However you have two choices if you REALLY don't want them.

A. There is, or was a file, in one of the folders called tableprefixes.php (or somthing similiar) open it up and read how it works, then change config.php

B. via ssh make a database dump (there are howto docs at vBulletin.com). Then if your file isn't too large( under 50 mb~) open it up in your prefered text editor (not wordpad, not notepad, get somthing like EditPad Lite, great too btw) and do a find a replace for the prefix vb3_ and remove it

[sim tech]

Originally Posted by Zachery

Almost every modification on this forum should be using table prefixes (unless the coders name is Brian Gunter) otherwise. Theres no problem

:laugh: Hope that was a friendly jab on whoever Brian is!

Thanks for the fast reply. I did find the tableprefix.php in the forum/install/ directory. I also saw where the prefix needed to be changed in the config.php.

I have about 100 tables and my whole MySQL is only about 7mb... so I downloaded EditPal-LT and removed all references to vb3_. I had to use the VB admin page to download the database. But uploading it seems to be a whole different ball of wax! I looked into the IMPEX program offered on vbulletin.com, but it made my brain hurt trying to understand how to use it.

Would it work if I just used the RENAME vb3_xxx TO xxx commands on every MySQL table? The big headache seems to be in the vBarcade mods (mainly where I added the custom sorting mod, gamerate mod, and A-Z mod. )

[Marco van Herwaarden]

I think you can follow Zachery's first advise and use ./install/tableprefix.php I just tested it on my testboard, and it ran without any problems.

Make sure to close your board before you start this and that you have a backup woithout errors.

Also make sure you have FTP access to the includes/config.php file, because once you have run the script your board will not function until you set the new $tableprefix in your config.

The whole process can bel run in less then a minute.

[Zachery]

Originally Posted by sim tech

:laugh: Hope that was a friendly jab!

Thanks for the fast reply. I did find the tableprefix.php in the forum/install/ directory. I also saw where the prefix needed to be changed in the config.php.

I have about 100 tables and my whole MySQL is only about 7mb... so I downloaded EditPal-LT and removed all references to vb3_. I had to use the VB admin page to download the database. But uploading it seems to be a whole different ball of wax! I looked into the IMPEX program offered on vbulletin.com, but it made my brain hurt trying to understand how to use it.

Would it work if I just used the RENAME vb3_xxx TO xxx commands on every MySQL table? The big headache seems to be in the vBarcade mods (mainly where I added the custom sorting mod, gamerate mod, and A-Z mod. )

Impex which be a much longer process, with Edit Pad, or Table Prefixes, it will be much faster and less long winded.

With Impex you need to reimport. then Rebuild, alot of data.

[sim tech]

Aha! Most sweet! That tableprefix looks just like what the doctor ordered. I had tried running it last night and it just gave me errors. I was too brain dead to understand why but this morning I saw where line 34/35 of tableprefix.php stated the admin's CP directory as the default "admincp". My control-panel directory is labeled different for security reasons. Once I fixed that I saw where it's so easy to rename everything.

I'll try this later today - thanks again everyone for the great help and promptness! You guys are the best!

Update - the tableprefix running was great! It did it all in about 20 seconds. And after a quick config.php mod the board was back up.

Renaming did fix a bunch of problems I was having... now I just have to go thru some of the modded files and find the ones that I entered the prefix in.

Thanks again!