vBSEO fields missing in Forums table after install?

[Quarterbore]

I can't fully debug this tonight but I got an ugly SQL error when I tried to add a new forum in my site after installing vBSEO just over a week ago.

The error indicates my database is missing some fields...

Here is the error:

Database error in vBulletin 3.6.0:
Invalid SQL:
INSERT INTO ts4msforum
(title_clean, title, description_clean, description, link, displayorder, parentid, daysprune, defaultsortfield, defaultsortorder, showprivate, newpostemail, newthreademail, options, styleid, password, vbbux_perview, vbbux_perthread, vbbux_perreply, vbpforumoptions, vbp_cangetaccesscost, vbp_cangiveaccesscost, vbp_candenyaccesscost, vbp_cangetpasswordcost, vbseo_moderatepingbacks, vbseo_moderatetrackbacks, vbseo_moderaterefbacks)
VALUES
('VRI Exchange Opportunities', 'VRI Exchange Opportunities', '', '', '', 1, 44, -1, 'lastpost', 'desc', 0, '', '', 89799, 0, '', 1, 15, 5, 0, 0, 0, 0, 0, 1, 1, 1);
MySQL Error : Unknown column 'vbseo_moderatepingbacks' in 'field list'
Error Number : 1054
Date : Tuesday, February 20th 2007 @ 11:23:31 PM
Script : Timeshare Forums - Timeshare Forums at TimeshareForums.com....
Referrer : http://www.timeshareforums.com/forums......
IP Address : ..............
Username : Quarterbore
Classname : vb_database

The error does reproduce...

I looked at my install code and the vrsion 3.0.0. RC3 code is there and includes the following:

PHP Code:

if (!$db->query_first("SHOW COLUMNS FROM " . TABLE_PREFIX . "forum LIKE 'vbseo_moderatepingbacks'"))
 $db->query_write("ALTER TABLE " . TABLE_PREFIX . "forum ADD COLUMN vbseo_moderatepingbacks INT UNSIGNED NOT NULL DEFAULT '1'"); 


I looked in my database and it does NOT have any of the vBSEO fileds in this table including:

• vbseo_moderatepingbacks
• vbseo_moderatetrackbacks
• vbseo_moderaterefbacks

Funny, vBSEO seems to be working without them but I have no idea why they didn't install with the script but I will manually add the fields when I get a chance but it's after midnight and I need to work tomorrow so tomorrow is another day... I figured I would report this in case there is some strange server quark that caused this and I hope to figure that out...

[Keith Cohen]

Install the latest vBSEO, RC8. RC3 is quite outdated.

[Quarterbore]

The version I have installed is: 3.0.0 RC8 The install code that adds these fields (in thr product file) is the RC3 install code!

I need to work on this mre tonight but this is on a live site so I need to make sure I have time to deal with any surprises if I go to reinstall

The easiest for me would be to just add the tables from the install code as that way I know it will not cause my site issues but I have no idea why it wasn't there in the first place?

I will work on it tonight...

[Keith Cohen]

You should be able to uninstall and reinstall the XML product file to correct it.

[Quarterbore]

Well, uninstalling will also remove all my settings and my site has really taken off with this on there... I don't mind spending a little time and my report here was in case there was something strange with teh download but I traced the XML file and it looks fins so it must have just been a server burp.

My forums database is quite huge so who knows but I play things very carefully with a live community and this is my biggest one that has the issue!

[Keith Cohen]

Uninstalling the XML product won't remove any settings. Your settings are stored in the config_vbseo.php file and your site's datastore.