vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   Database problem with "Image Settings" option (https://vborg.vbsupport.ru/showthread.php?t=201383)

gim 01-11-2009 02:47 AM
Database problem with "Image Settings" option
 
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:

Code:
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.


All times are GMT. The time now is 11:17 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01405 seconds
  • Memory Usage 1,721KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (7)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete