Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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
Comment #1
agentrickardThat 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.
Comment #2
agentrickard