PDA

View Full Version : Database problem with "Image Settings" option


gim
01-11-2009, 02:47 AM
Hi to everybody from Italy, orry for my english ;-)

I have recently upgrade to vBulletin 3.7.3 Patch Level 1 and I love this new version, all work fine but I have a problem with the "Image Settings" option, when I click it I get an error like this below:

Database error
The XXXXX Forum database has encountered a problem.

Database error in vBulletin 3.7.3:

Invalid SQL:

INSERT INTO vb_regimage
(regimagehash, imagestamp, dateline)
VALUES
('XXXXXX', 'XXXXXX', XXXXXXXX);

MySQL Error : Table 'XXXX_forum3.vb_regimage' doesn't exist
Error Number : 1146
Request Date : Sunday, January 11th 2009 @ 05:43:47 AM
Error Date : Sunday, January 11th 2009 @ 05:43:47 AM
Script : http://www.XXXXXX.it/forum/admincp/options.php?do=options&dogroup=imagesettings
Referrer : http://www.XXXXXXX.it/forum/admincp/options.php?null=0
IP Address : XXXX
Username : XXXX
Classname : vB_Database
MySQL Version : 5.0.37


All other options work fine. Can you please hel me in any mode or you have any idea?

Thank a lot :-)



PS.
I have put "X" for protect data ;)

markbolyard
01-11-2009, 03:08 AM
Exactly what the error reads, Table does not exist. Rerun your upgrade to see if it creates the correct tables. Go into phpmyadmin and verify that vb_regimage table exists.

Or better yet, upgrade to the latest release of vBulletin.

gim
01-11-2009, 03:23 AM
Hi markbolyard, thank you for your help. I think that the upgrade have not created the table, is possible to create with a query the tables? Or do you think that if I re-run the upgrade process the system create the table for me? I'm not an mysql or phpmyadmin expert and a pre-made query is welcome ;)

Thanks a lot :)

Dismounted
01-11-2009, 04:00 AM
AFAIK, the regimage table was removed in 3.7. Make sure all files are uploaded and overwritten.

gim
01-12-2009, 06:56 AM
Dismounted, we have upload an all-new files on our FTP space. Do you think that the "Image Settings" option is not longer available on VB 3.7?

Marco van Herwaarden
01-12-2009, 07:11 AM
This table is not used in vBulletin 3.7. If you have replaced all vBulletin files and still get this error, then it is caused by a modification you have installed.

Dismounted
01-12-2009, 07:12 AM
Not that the option is not available, but the tables that it uses have changed. It was removed in 3.7.0 Beta 3. Try disabling any modifications you have running.