Database reporting errors
 

I think I deleted a userprofile field (One I inserted) in admincp as it was made redundant by a hack. Now the database is reporting the following error via e-mail.

nvalid SQL:
SELECT mydbuser.userid, mydbuser.lastvisit, mydbuser.posts, mydbuserfield.field10 FROM `mydbuserfield` LEFT JOIN `mydbuser` ON mydbuserfield.userid = mydbuser.userid WHERE mydbuser.posts >= '0' AND mydbuserfield.field10 != '';

MySQL Error : Unknown column 'mydbuserfield.field10' in 'field list'
Error Number : 1054

Request Date : Wednesday, June 4th 2008 @ 11:03:23 AM
Error Date : Wednesday, June 4th 2008 @ 11:03:24 AM
Script : http://www.mywebsite.co.uk/cron.php?&rand=726150
Referrer : http://www.mywebsite.co.uk/
IP Address : 86.129.213.98
Username : Unregistered
Classname : vB_Database
MySQL Version :

I have confirmed in phpadmin that field10 does not exist and would like to know if anyone has any ideas for this newbie so that he can sort it all out.

Thank you for any help you can offer in advance.



--------------- Added [DATE]1212656108[/DATE] at [TIME]1212656108[/TIME] ---------------

Anybody?

--------------- Added [DATE]1212656306[/DATE] at [TIME]1212656306[/TIME] ---------------

Anybody?

You have a Scheduled Task still running that is trying to use the removed field.

Many thanks.

The errors were popping up and random intervals which sort of went agaisnt it being a cron job generating the error.

I did a search in phpmyadmin for field10 and found an entry in a user database, I deleted it but still the srror came up. I have altered the database and added field 10 back into the database until I get time to investigate further.

Many thanks for your help.