vBulletin database error email sent during upgrade to beta 4

[sweeps78]

Hi,

I just recently upgraded from beta 3 to beta 4. My forums seem to be working great, but during the upgrade I received the attach database error in an email. I'm not sure what this error means, so I was hoping that someone here could explain it to me.

thanks

[Lynne]

It helps if you just copy/paste the error rather than attaching it ( removed your IP):

Database error in vBulletin 3.7.0 Beta 4:

Invalid SQL:

        INSERT INTO regimage
            (regimagehash, imagestamp, dateline)
        VALUES
            ('6bdbaee2a22b10093644a91d5af559af', 'npBHSm', 1201014873);

MySQL Error   : Table 'trossen_forum.regimage' doesn't exist
Error Number  : 1146
Date          : Tuesday, January 22nd 2008 @ 09:14:33 AM
Script        : http://forums.trossenrobotics.com/blog.php?do=sendtofriend&b=22
Referrer      : 
IP Address    : xx.xx.xx.xx
Username      : Unregistered
Classname     : vb_database
MySQL Version :

It is trying to insert something into a table called "regimage" that doesn't seem to exist. Have you looked at your database and seen if a table called "regimage" exists? Or do you normally need a table prefix perhaps?

[sweeps78]

Thanks U2Lynne, I removed my previous attachment.

no, I don't have that table in my database. It looks to me like someone in my forums tried to either send something either before or after I shut down the forums. Either way, the blog looks like it has an error in it when it is trying to send things to "friends".

thoughts? Should I repost this in the blog forums?

[Wayne Luke]

In the upgrade to beta 2 a new table called humanverify was created and the regimage table was dropped. humanverify replaces regimage in all aspects.

Going by the error, it appears that you have not upgraded to vB Blog 1.0.3 which is required for compatibility with 3.7.0.

[sweeps78]

I thought I did upgrade to 1.0.3... Is there any way that I can check? I remember having a hard time with that (finding the version I'm running) when I did the upgrade.

[beishe8]

I thought I did upgrade to 1.0.3... Is there any way that I can check? I remember having a hard time with that when I did the upgrade.

Admin > Plugins & Products

Title.................. Version
vBulletin Blog ......1.0.x

[sweeps78]

Never mind, I figured out how to find the version (EDIT: strange, looks like I was updating this thread at the same time as beishe8, thanks for the reply though):

http://www.vbulletin.com/forum/showthread.php?t=254992&highlight=version

Wayne - I am running 1.0.3 according to my plugin & products. Is there anything else I can look at?

[Wayne Luke]

Make sure all of your blog files are up-to-date. They should show under Suspect File Versions if they are not.

[sweeps78]

Thanks Wayne.

Quite a few came up. Here are the files that I got that came up under Suspect File Versions (if you notice anything non related to this, I'd appreciate a PM or something ):


./
google93bf3f03ff93b553.html File not recognized as part of vBulletin
googleaec418755288e950.html File not recognized as part of vBulletin
index.php File not recognized as part of vBulletin
vb_index.php File version mismatch: found 3.7.0 Beta 3, expected 3.7.0 Beta 4

./admincp

vba_cmps_admin.php File not recognized as part of vBulletin
vba_gallery_admin.php File not recognized as part of vBulletin
vbacmps_install.php File not recognized as part of vBulletin

./clientscript

activecell.htc File not recognized as part of vBulletin
vba_cmps_admin.js File not recognized as part of vBulletin
vbulletin_quick_comment_vm.js File not recognized as part of vBulletin

./clientscript/yui

animation-min.js File not recognized as part of vBulletin
treeview-min.js File not recognized as part of vBulletin
treeview.js File not recognized as part of vBulletin
yahoo-dom-event-min.js File not recognized as part of vBulletin


./includes

adminfunctions_gallery.php File not recognized as part of vBulletin
class_akismet.php File does not contain expected contents
datastore_cache.php File not recognized as part of vBulletin
functions_gallery.php File not recognized as part of vBulletin
functions_gallery_imageedit.php File not recognized as part of vBulletin
functions_regimage.php File not recognized as part of vBulletin
vba_cmps_adminfunctions.php File not recognized as part of vBulletin
vba_cmps_error.php File not recognized as part of vBulletin
vba_cmps_global.php File not recognized as part of vBulletin
vba_cmps_include_bottom.php File not recognized as part of vBulletin
vba_cmps_include_output.php File not recognized as part of vBulletin
vba_cmps_include_template.php File not recognized as part of vBulletin
vba_cmps_include_top.php File not recognized as part of vBulletin
vba_cmps_plugin_newpost.php File not recognized as part of vBulletin

./includes/cron

gallery_ecard.php File not recognized as part of vBulletin
gallery_search.php File not recognized as part of vBulletin
gallery_stats.php File not recognized as part of vBulletin
gallery_subscriptions.php File not recognized as part of vBulletin
gallery_totals.php File not recognized as part of vBulletin

./includes/xml

bitfield_vbgallery.xml File not recognized as part of vBulletin
cpnav_impex.xml File not recognized as part of vBulletin
cpnav_vbacmps.xml File not recognized as part of vBulletin
cpnav_vbagallery.xml File not recognized as part of vBulletin
hooks_vbacmps.xml File not recognized as part of vBulletin
hooks_vbgallery.xml File not recognized as part of vBulletin


./modcp

vba_gallery.php File not recognized as part of vBulletin

[Freddie Bingham]

Upgrade to vBulletin Blog 1.0.4

[Wayne Luke]

Those are all third-party modifications except the ImpEx files.

However vB Blog 1.0.4 was just released and it should fix your problem.

[sweeps78]

thanks! I'll try it out