You may ask why do you want to delete profiles.? Well a few funny people registered profiles with a lot of crab in it and I want to remove it. I did try and now after upgrading sit with this error and I cant manage to fix it. I have tried everything I could. I think it could be the subs mod that have installed but I cant say it because it wont be the right thing to insult a fine mod programmer. This is my error... Please give me some advice if you can. Tx.. Remember this is the email i've received from the site due to the database error.
Database error in SA Profiles
Query:
SELECT `cmt_id`, `cmt_parent_id` FROM [db_prefix]_cmts WHERE `cmt_author_id` = '10' AND `cmt_replies` = 0
Mysql error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[db_prefix]_cmts WHERE `cmt_author_id` = '10' AND `cmt_replies` = 0' at line 1
Found error in the file '/home/auctionb/public_html/saprofiles.co.za/inc/classes/BxDolCmtsQuery.php' at line 167.
Called 'getAll' function with erroneous argument #0.