I installed Zoints SEO, but since I installed it I have been getting emails from the server saying that there is an error. Here's the error:
Code:
Database error in vBulletin 3.6.1:
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 > 1161230427 AND suspended = 0 AND valid = 1;
MySQL Error : Column: 'valid' in where clause is ambiguous
Error Number : 1052
Date : Friday, October 20th 2006 @ 07:06:27 PM
Script : http://www.mysite.com/community/cron.php?&rand=688347
Referrer : http://www.mysite.com/community/index.php
IP Address : xxx.xx.xxx.xxx
Username : Unregistered
Classname : vb_database
I asked about this at vBulletin, but they said:
Quote:
Those are plugins and they modify the vB code and database. The 'ambiguous' error is either due to a MySQL alpha version (which you are not running) or a change made to the database by one of your plugins. Namely one of them created an extra 'valid' field.
You need to find out which plugin cause this and remove that plugin and the changes it made to the db.
|
So, I want to know how I can uninstall the software and repair my database.