Linkback DB error on updating to 3.1.0

Also posted as a support ticket..I uploaded fine, but on importing the product I got the following DB error.

Database error in vBulletin 3.5.4:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'vBSEO Moderator Admin', 'admin_moderator_form', '\r\n print_description_row($vbphrase[\'vbseo_options\'], false, 2, \'thead\');\r\n print_yes_no_row($vbphrase[\'vbseo_can_moderate_linkbacks\'], \'modperms[vbseo_linkbacks]\', $moderator[\'vbseo_linkbacks\']);\r\n', 'crawlability_vbseo');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Saturday, November 17th 2007 @ 04:05:06 AM
Script : http://www.ajarnforum.net/vb/ajarnacp/plugin.php
Referrer : http://www.ajarnforum.net/vb/ajarnac...?do=productadd
IP Address : 125.25.163.42
Username : LDMA
Classname : vb_database

Additionally, the following appear in my microstats

Uncached templates: vbseo_linkbackmenu (1)Uncached templates: vbseo_linkbackmenu_entry (1)Uncached templates: vbseo_linkbacks (1)

It all basically works CPVBSEOCP etc but there is no linkbacks menu for threads anymore.

I assume it would be best to uninstall and reinstall the product perhaps, but I don't want to risk it without some advice from here...

Resolved via support ticket, a special xml product file provided.

Originally Posted by Oleg Ignatiuk

Resolved via support ticket, a special xml product file provided.

Hi,

Can you provide me with instructions to resolve the above error as i'm experiencing the same except that mine is a fresh installation. Thanks.

Hello,

you can get it here: http://www.vbseo.com/attachments/f24...vbseo-vb35.xml

Originally Posted by Oleg Ignatiuk

Hello,

you can get it here: http://www.vbseo.com/attachments/f24...vbseo-vb35.xml

Hi,

I'm using 3.6.1 vbulletin and i've already got the crawlability_vbseo plugin installed. How is this different from the given link above?

You should not do anything in this case, that product file is for vB3.5.x only.

Originally Posted by Oleg Ignatiuk

You should not do anything in this case, that product file is for vB3.5.x only.

Ok. So how can I resolve the error without doing anything?

That is only for the 3.5.x series of vbulletin.

EDIT: someone delete this as it was answered before I went afk

Do you get a database error as described in initial post?

Originally Posted by Oleg Ignatiuk

Do you get a database error as described in initial post?

This is what i got and I've amended my domain for security reasons.

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT tb.*,t.* FROM linkback tb
LEFT JOIN thread t on tb.t_threadid=t.threadid
WHERE t_approve>0 AND t_incoming=1 and t_deleted=0
ORDER by t_time DESC;

MySQL Error : Unknown column 't_approve' in 'where clause'
Error Number : 1054
Date : Monday, November 26th 2007 @ 12:06:48 AM
Script : http://www.mydomain.com/forum/modcp/vbseo_moderate.php?do=linkbackslist
Referrer : http://www.mydomain.com/forum/admincp/index.php?do=nav
IP Address : 116.15.20.211
Username : lionelng
Classname : vb_database

This is not the same error that is reported in this thread. You should uninstall and then reinstall vBSEO xml product file in vB admincp.

Originally Posted by Oleg Ignatiuk

This is not the same error that is reported in this thread. You should uninstall and then reinstall vBSEO xml product file in vBulletin admincp.

I've uninstalled and reinstalled but still, it didn't worked out. Should I post a new thread on this then?

Please open a support ticket with admincp access for troubleshooting.