DB Error from Old Plug-in

[Mike Bucy]

Recently I have upgraded to 4.1.10

Went through the normal upgrade process. Removed all plug-ins and products. Checked to be sure all templetes were reverted back to default. Ran the upgrade scripts successfully without any errors.

I have this database error from an old uninstalled plug-in call VBClassifieds:

Any help would be appreciated. :)

Database error in vBulletin 4.1.10:

Invalid SQL:

SELECT active, classifiedid, categoryid, title, userid
FROM vbclassified
WHERE enddateline < 1328144342 AND active != 0;

MySQL Error : Table 'v8buick_v8buickdb.vbclassified' doesn't exist
Error Number : 1146
Request Date : Wednesday, February 1st 2012 @ 06:59:02 PM
Error Date : Wednesday, February 1st 2012 @ 06:59:02 PM
Script : http://www.v8buick.com/cron.php?rand=1328144340
Referrer : http://www.v8buick.com/forumdisplay.php?45-Cars-for-sale/page2&order=desc
IP Address : 72.66.43.11
Username : Unregistered
Classname : vB_Database_MySQLi
MySQL Version :


Also I get this alot:

Database error in vBulletin 4.1.10:

Invalid SQL:
UPDATE userfield SET
field1 = '',
field2 = 'chicago ridge, IL',
field3 = '60s-70s rock/punk, pontiacs, gms',
field4 = '',
field50 = ''
WHERE userid = 12812;

MySQL Error : Unknown column 'field50' in 'field list'
Error Number : 1054
Request Date : Wednesday, February 1st 2012 @ 09:09:27 PM
Error Date : Wednesday, February 1st 2012 @ 09:09:27 PM
Script : http://www.v8buick.com/profile.php?do=updateprofile
Referrer : http://www.v8buick.com/profile.php?do=editprofile
IP Address : 98.223.83.242
Username : dedsleds
Classname : vB_Database_MySQLi
MySQL Version :


Thanks Everyone.

[kh99]

The first one comes from a scheduled task. It could be a leftover plugin or a separate task. I'm not sure about the second one.

[Mike Bucy]

Thanks!!

Yes that task was still in there.

[Videx]

The lesson to be learned here is that when you uninstall a product you must also delete all the files you uploaded with it.

[Mike Bucy]

Hey Folks,

I'm stll having problems with the following database error when I try to change a user to a different usergroup.

Database error in vBulletin 4.1.10:

Invalid SQL:
UPDATE userfield SET
field43 = '',
field1 = '',
field2 = 'Newport MI',
field3 = 'Hot Rods',
field4 = 'Retired',
field50 = ''
WHERE userid = 25980;

MySQL Error : Unknown column 'field50' in 'field list'
Error Number : 1054
Request Date : Friday, February 3rd 2012 @ 09:38:16 PM
Error Date : Friday, February 3rd 2012 @ 09:38:16 PM
Script : http://www.v8buick.com/admincp/user.php?do=update
Referrer : http://www.v8buick.com/admincp/user.php?do=edit&u=25980
IP Address : 67.4.222.38
Username : Mike Bucy
Classname : vB_Database_MySQLi
MySQL Version : 5.0.90

Thanks!

[Videx]

Like I said - it sounds like you still have bits left over from some old modification. Did you install this forum yourself or inherit it from someone else?

[Mike Bucy]

Found it. It was a missing column out of the custom user profile fields. I just recreated the user profile field in the manager of the ACP.

:up:

Thanks for your response.