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?