By krutium on

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 ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /usr/home/drupal/public_html/includes/menu.inc on line 315.
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 ') ORDER BY fit DESC LIMIT 0, 1' at line 1 query: SELECT * FROM menu_router WHERE path IN () ORDER BY fit DESC LIMIT 0, 1 in /usr/home/drupal/public_html/includes/menu.inc on line 315.

edited by silverwing - moved to post installation forum

⋅ Categories: Drupal 6.x

Comments

suvasishm’s picture

suvasishm commented

would you please write the actual query that you wrote in your code?

But generally, you need to put something within quotation inside IN()....for example IN('admin')....for more than one args use IN('arg1', 'arg2', ...).

$query = "SELECT * FROM menu_router WHERE path IN ('admin') ORDER BY fit DESC LIMIT 0, 1";
print_r(db_fetch_array(db_query($query)));