3.7 RC1 database errors

[Joe Siegler]

After I upgraded to rc1 (and turned on the forums for some live traffic), I got three database errors - all within three minutes of themselves. It appears related to trying to email a blog entry. This is what I got:


Database error in vBulletin 3.7.0 Release Candidate 1:

Invalid SQL:

INSERT INTO regimage
(regimagehash, imagestamp, dateline)
VALUES
('5ff64a594178dba0cc59959d51f3ecc2', 'k6B2TY', 1206026721);

MySQL Error : Table 'vb.regimage' doesn't exist
Error Number : 1146
Date : Thursday, March 20th 2008 @ 10:25:21 AM
Script : http://www.myserver.com/vb/blog.php?do=sendtofriend&b=85
Referrer :
IP Address : 66.249.73.57
Username : Unregistered
Classname : vB_Database
MySQL Version :


The other two are quite similar - the only differences are the specific blog entry send, and the "VALUES" in the sql query. As I post this message here, the three errors were about 40 minutes ago. I have not seen any since, and I've tried the three links in the error msgs myself, and they worked fine. Not sure what to do about this.

Anyone else see this?

EDIT: I ran through the upgrade like any other upgrade. I've done a boatload of vb upgrading, so it's upload files, run upgrader, hit next. Not a lot that can be screwed up there. Not sure what could possibly be "missed" (on my end) if there's a table not there.

[Wayne Luke]

This is a table that was removed in the 3.7.0 series. It was part of 3.6.X. It appears you have an addon that needs to be updated to be compatible with the new Human Verification features in 3.7.0. You will need to remove this addon and contact the author for an update before reinstalling it.

[Joe Siegler]

This is a table that was removed in the 3.7.0 series. It was part of 3.6.X. It appears you have an addon that needs to be updated to be compatible with the new Human Verification features in 3.7.0. You will need to remove this addon and contact the author for an update before reinstalling it.

I don't suppose you have any idea where to look?

The link it's cropping up in is the blog. So I just assumed it was Jelsoft stuff.

The products I have on this board seem totally unrelated to what's listed in the error message. According to my product manager, I have five installed ones. Two of which are Jelsoft (vb itself, & Blog). The others are "Separate sticky & Normal Threads", "Allow usergroup HTML", & "vb Microstats".

Now I'm no expert, and I'm not claiming they can't be at fault, but they seem unrelated to the "send to friend via blog" that is in the error report.

[Wayne Luke]

You need to upgrade your blog to 1.0.3 or higher. Latest version is 1.0.4

[Joe Siegler]

You need to upgrade your blog to 1.0.3 or higher. Latest version is 1.0.4

I'm using 1.04 already.

[Steve Machol]

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 or remove all non-vB official plugins and product..

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. Do you have the same problem?

[Joe Siegler]

The problem is that the errors have only happened three times, and I didn't create them.

Users did that (unless it was a searchbot). The couple of times I've tried replicating that, I can't get it to happen. Even if I did all that, I don't know what to do 100% of the time to generate the error.

[Steve Machol]

Well something is still calling a table that no longer exists in 3.7:

MySQL Error : Table 'vb.regimage' doesn't exist

This is from old code somewhere.

[Joe Siegler]

I ran the suspect files thing. It's telling me there are nine files that are "File not recongized as part of vBulletin".

./
picturecomment_inlinemod.php

./admincp
advedit_users.php

./clientscript
activecell.htc
resizeall.js

./includes
class_visitormessageparser.php
datastore_cache.php
functions_regimage.php

./includes/xml
bitfield_allowhtml.xml
cpnav_advedit.xml

Should I just delete these?

[Mike Sullivan]

Joe, keep an eye on this issue and the one linked to from it:
http://www.vbulletin.com/forum/project.php?issueid=24955

The link has a fix for this issue.

[Joe Siegler]

Joe, keep an eye on this issue and the one linked to from it:
http://www.vbulletin.com/forum/project.php?issueid=24955

The link has a fix for this issue.

I made the fix, and as of yet have not seen any more database errors.

[joomlajon]

I have the exact same problem, this is when a unreg try to e-mail a blog post.

I can reproduce it.

I have updated with the blogfix and still the e-mail blog post does not work for unreg. Will try with the fix described above later, if you don't find the problem.?

[joomlajon]

Well the trouble remains,

I have updated to RC2 and the blog is 1.0.4

I have fixed the blogtab so I have it, via the fix suggested. I have created a new style and no luck.

When running diagnostics I find these files as unrecognized

./
picturecomment_inlinemod.php

./clientscript
vbulletin_ajax_userfieldedit.js

./includes
class_visitormessageparser.php
functions_regimage.php

The mail contains this
Database error in vBulletin 3.7.0 Release Candidate 2:

Invalid SQL:

INSERT INTO vb_regimage
(regimagehash, imagestamp, dateline)
VALUES
('4b8e1201bcad4bce4f7c7ca837a6484c', 'zeGG6z', 1207093641);

MySQL Error : Table '....vb_regimage' doesn't exist
Error Number : 1146
Date : Wednesday, April 2nd 2008 @ 01:47:21 AM
Script : .../forum/blog.php?do=sendtofriend&b=12
Referrer : .../forum/blog.php?b=12
IP Address : xx.xxx.xx.xx
Username : Oregistrerade
Classname : vB_Database_MySQLi
MySQL Version :

This happens when a guest tries to send a blogpost to a friend via email.

What should I do with the unrecognized files? Delete them?
Yes or No, didnt understand the answer to the same question above.

Is this a blog bug??? Should I post it as a bug there?

/Jon

[Steve Machol]

Please report this in the Bug Tracker.

[joomlajon]

Everything works now after all fixes :)

But what shold I do with all the non recognized files, erase???

http://www.vbulletin.com/forum/project.php?issueid=24953 is the link to the fix for this by the way.

[Steve Machol]

That depends on what those files are and if they are required for add-ons or other applications. Rather than deleting them, you can move them to a temporary directory first just in case.