mysql error

I'm not at all certain that this problem is a vbseo one or not but I thought I'd throw it out there just in case.

2 weeks ago I moved my site to a new server. Right away I started getting hundreds of emails indicating various sql errors.

I reinstalled the vbseo xml file and MOST of these errors went away.
Now I get maybe a dozen a day. I'd like to get none.

Here's one of the emails;

Database error in vBulletin 3.7.0 Beta 3:

Invalid SQL:

INSERT INTO regimage
(regimagehash, imagestamp, dateline)
VALUES
('ed117f340587992828aff9aebb745d26', 'nW9W8z', 1204999489);

MySQL Error : Table 'shottal_forum.regimage' doesn't exist
Error Number : 1146
Date : Saturday, March 8th 2008 @ 12:04:50 PM
Script : Shot Talk - Golf Forum Database Error
Referrer :
IP Address : 74.6.21.208
Username : Unregistered
Classname : vb_database
MySQL Version :

Any thoughts on this??

Thanks.

Unfortunately vBSEO doesn't have any query like this. You must check this error with vBulletin.com

I believe you are a missing a table. What does the database show?

Regards Jason

Originally Posted by Jason Amison

I believe you are a missing a table. What does the database show?

Regards Jason

Good question.

To be honest, the database is something I never mess around with so I have only the vaguest idea of where to look.... phpmyadmin I suppose?

Yes, you can use phpMYAdmin.

Do you have any hacks/mods? If so, please list them.

Regards Jason

Enhanced Captcha Image Verification

Forum Home gallery images (currently disabled as it doesn't work with 3.7, my prime suspect)

ibProArcade

Members who have visited the forum

Miserable users

Multiple Login Detector

No Links or Images Allowed for People with Fewer than 15 posts

vBadvanced CMPS

vBadvanced Links Directory

PhotoPost vBGallery 2.4

vBulletin SEO

vbseo sitemap generator

Webforumz :: Adsense in Archive

Welcome Headers

ZH_Meta Tags

Could be anyone of them. I believe that table doesn't exist in BETA 6.

To troubleshoot this, first reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. Also be sure to upload the admincp files to whichever directory you have set in your config.php file. Then run 'Suspect File Versions' in Diagnostics to make sure you have all the original files for your version and that none show 'File does not contain expected contents':

Admin CP -> Maintenance -> Diagnostics -> Suspect File Versions

[Note: In some cases you may also need to remove any of the listed .xml files in the includes/xml directory.]

Next, disable all plugins.

Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

Then if you still have this problem, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you change to the new style and view your forums with it.

Regards Jason

Running the diagnostics I find that all of the vbseo files say this....

functions_vbseo_cache.php File does not contain expected contents functions_vbseo_createurl.php File does not contain expected contents functions_vbseo_crr.php File does not contain expected contents

Should I disable vbseo or upload a different version
Or ignore it?

Which version of vBSEO are you running? Upload all the latest files and see if you get the same. Also keep in mind that it can take a few times for it too read the files.

However, this is not caused by vBSEO. You are using an hack that isn't made for vB 3.7.0 and it's trying to call that table when it doesn't exist in 3.7.0.

Regards Jason

I'm running 3.1

I'm deleting suspect hacks. I have a couple of them that do not work so maybe that's the problem. Fingers crossed.

Thanks for the help.

Yes, my instructions above should help you. This is definitely caused by an hack.

Regards Jason

regimage = captcha script.

kill that first plugin you mention. its probably the cluprit

That is a vB Blog bug: SQL Error - Send to Friend - vBulletin Community Forum - Project Tools

Yes, your right. The captcha script is calling a table that was dropped in BETA 1. I knew it was one of the hacks, anyway.

Regards Jason