Hello,

i am getting a warning.

user warning: 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 '* FROM cache_content' at line 1 query: DELETE * FROM cache_content in /home/cmswebsi/public_html/webserver9/lstwtnew/includes/database.mysql.inc on line 172.

i found that it is appearing due to the line code in mysite.module


 $data[$item->position][$i]['output'] = module_invoke('mysite_type', $item->type .'_data', $item->type_id, $settings);

if i place @ operator, this warning gets disappear.


 $data[$item->position][$i]['output'] = @module_invoke('mysite_type', $item->type .'_data', $item->type_id, $settings);

Please tell me what is the reason behind this and provide the solution(it's urgent :( ).

Thanks in advance,
sweetie

Comments

agentrickard’s picture

Status: Active » Postponed (maintainer needs more info)

That is actually not an error native to MySite. It is a SQL error caused by a badly formed DELETE query in another module. The code you cite would not generate this query. It looks like a CCK module is trying to clear its cache while loading data.

On my test server, the string DELETE * is not present in any code, so I can't really give you any further help.

Try searching all your Drupal files for the line:

DELETE * FROM

and see if there are any results. That's the culprit here.

agentrickard’s picture

Status: Postponed (maintainer needs more info) » Closed (fixed)