[MrLeN]

I installed Zoints SEO, but it started causing conflicts with other software that I am using with the forums and unfortunately, I had to remove it. I came here for instructions how to remove it and I was told to use the uninstall via the product manager and remove the files from the installation.

I did this, but I am still getting database errors in my email. It says:

Database error in vBulletin 3.6.2:

Invalid SQL:

SELECT linkid, name, links.catid, userid, username, dateline, links.lastpostdateline, title
FROM wgreen_adv_links AS links
LEFT JOIN wgreen_adv_links_categories AS categories USING (catid)
WHERE links.dateline > 1162098001 AND suspended = 0 AND valid = 1;

MySQL Error : Column: 'valid' in where clause is ambiguous
Error Number : 1052
Date : Monday, October 30th 2006 @ 12:59:01 AM
Script : http://www.mysite.com/community/cron.php?rand=801531
Referrer : http://www.mysite.com/community/
IP Address : 211.28.xxx.xxx
Username : Unregistered
Classname : vb_database

How can I repair my vBulletin database to get it working without errors, before the Zoints SEO installation altered it? Or, what did Zoints SEO do to alter my database?

Any advice/direction appreciated.