By faruk 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 'user)' at line 1 query: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN (authenticated user) in /home/*********/public_html/includes/database.mysql.inc on line 120.

hi, I get this error on my page. and I have no idea how to fix it.

thank you very much.

faruk.

⋅ Categories: Drupal 4.7.x

Comments

faruk’s picture

faruk commented

now someone entereded a comment to that page and the warning is now like this:


* 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 'user)' at line 1 query: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN (authenticated user) in /home/********/public_html/includes/database.mysql.inc on line 120.
* warning: array_keys() [function.array-keys]: The first argument should be an array in /home/********/public_html/modules/user.module on line 348.
* warning: implode() [function.implode]: Bad arguments. in /home/********/public_html/modules/user.module on line 348.
* 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 ')' at line 1 query: SELECT DISTINCT(p.perm) FROM role r INNER JOIN permission p ON p.rid = r.rid WHERE r.rid IN () in /home/********/public_html/includes/database.mysql.inc on line 120.

dziemecki’s picture

dziemecki commented

I get this too.

Dan Ziemecki
Mangling other people's code since 1997.

irwin’s picture

irwin commented

I posted this in the upgrade forum. http://drupal.org/node/67178

-- Irwin
* Drupal at work -> http://suikoden.mine.nu (Suikoden-themed Role-playing Game.)
* My other Drupal site -> http://scrapped.mine.nu (Video-game & Anime-themed Blog)

saratraverz’s picture

saratraverz commented

# user warning: Table './wall/cache_menu' is marked as crashed and should be repaired query: SELECT data, created, headers, expire FROM cache_menu WHERE cid = '1:en' in /Applications/MAMP/htdocs/drupal_5_5/includes/database.mysql.inc on line 172.
# user warning: Table './wall/cache_menu' is marked as crashed and should be repaired query: LOCK TABLES cache_menu WRITE in /Applications/MAMP/htdocs/drupal_5_5/includes/database.mysql.inc on line 172.
# user warning: Table './wall/cache_menu' is marked as crashed and should be repaired query: UPDATE cache_menu SET data = 'a:4:{s:10:\"path index\";a:133:{s:17:\"admin/build/block\";s:2:\"14\";s:22:\"admin/build/block/list\";i:-2;s:27:\"admin/build/block/configure\";i:-3;s:24:\"admin/build/block/delete\";i:-4;s:21:\"admin/build/block/add\";i:-5;s:33:\"admin/build/block/list/pushbutton\";i:-6;s:31:\"admin/build/block/list/minnelli\";i:-7;s:29:\"admin/build/block/list/marvin\";i:-8;s:30:\"admin/build/block/list/garland\";i:-9;s:33:\"admin/build/block/list/bluemarine\";i:-10;s:30:\"admin/build/block/list/artists\";i:-11;s:32:\"admin/build/block/list/chameleon\";i:-12;s:33:\"admin/build/block/list/artistsC01\";i:-13;s:21:\"admin/content/comment\";s:2:\"15\";s:26:\"admin/content/comment/list\";i:-15;s:30:\"admin/content/comment/list/new\";i:-16;s:35:\"admin/content/comment/list/approval\";i:-17;s:30:\"admin/content/comment/settings\";i:-18;s:14:\"comment/delete\";i:-19;s:12:\"comment/edit\";i:-20;s:22:\"admin/settings/filters\";s:2:\"16\";s:27:\"admin/settings/filters/list\";i:-22;s:26:\"admin/settings/filters/add\";i:-23;s:29:\"admin/settings/filters/delete\";i:-24;s:11:\"filter/tips\";s:1:\"3\";s:10:\"admin/help\";s:1:\"7\";s:16:\"admin/help/block\";i:-27;s:16:\"admin/help/color\";i:-28;s:18:\"admin/help/comment\";i:-29;s:17:\"admin/help/filter\";i:-30;s:15:\"admin/help/help\";i:-31;s:15:\"admin/help/menu\";i:-32;s:15:\"admin/help/node\";i:-33;s:17:\"admin/help/system\";i:-34;s:19:\"admin/help/taxonomy\";i:-35;s:15:\"admin/help/user\";i:-36;s:19:\"admin/help/watchdog\";i:-37;s:16:\"admin/build/menu\";s:2:\"17\";s:21:\"admin/build/menu/list\";i:-39;s:25:\"admin/build/menu/item/add\";i:-40;s:26:\"admin/build/menu/item/edit\";i:-41;s:27:\"admin/build/menu/item/reset\";i:-42;s:29:\"admin/build/menu/item/disable\";i:-43;s:28:\"admin/build/menu/item/delete\";i:-44;s:25:\"admin/build/menu/menu/add\";i:-45;s:26:\"admin/build/menu/menu/edit\";i:-46;s:28:\"admin/build/menu/menu/delete\";i:-47;s:25:\"admin/build/menu/settings\";i:-48;s:13:\"admin/content\";s:1:\"8\";s:18:\"admin/content/node\";s:2:\"18\";s:27:\"admin/content/node/overview\";i:-51;s:27:\"admin/content/node-settings\";s:2:\"19\";s:35:\"admin/content/node-settings/rebuild\";i:-53;s:19:\"admin/content/types\";s:2:\"20\";s:24:\"admin/content/types/list\";i:-55;s:23:\"admin/content/types/add\";i:-56;s:4:\"node\";s:1:\"4\";s:8:\"node/add\";s:1:\"9\";s:7:\"rss.xml\";i:-59;s:14:\"node/add/index\";s:2:\"46\";s:13:\"node/add/page\";s:2:\"21\";s:13:\"node/add/post\";s:2:\"45\";s:14:\"node/add/story\";s:2:\"22\";s:12:\"system/files\";i:-64;s:5:\"admin\";s:1:\"5\";s:13:\"admin/compact\";i:-66;s:13:\"admin/by-task\";i:-67;s:15:\"admin/by-module\";i:-68;s:14:\"admin/settings\";s:2:\"10\";s:11:\"admin/build\";s:2:\"11\";s:20:\"admin/settings/admin\";s:2:\"23\";s:18:\"admin/build/themes\";s:2:\"24\";s:25:\"admin/build/themes/select\";i:-73;s:27:\"admin/build/themes/settings\";i:-74;s:34:\"admin/build/themes/settings/global\";i:-75;s:38:\"admin/build/themes/settings/pushbutton\";i:-76;s:35:\"admin/build/themes/settings/artists\";i:-77;s:37:\"admin/build/themes/settings/chameleon\";i:-78;s:19:\"admin/build/modules\";s:2:\"25\";s:24:\"admin/build/modules/list\";i:-80;s:32:\"admin/build/modules/list/confirm\";i:-81;s:29:\"admin/build/modules/uninstall\";i:-82;s:37:\"admin/build/modules/uninstall/confirm\";i:-83;s:31:\"admin/settings/site-information\";s:2:\"26\";s:30:\"admin/settings/error-reporting\";s:2:\"27\";s:26:\"admin/settings/performance\";s:2:\"28\";s:26:\"admin/settings/file-system\";s:2:\"29\";s:28:\"admin/settings/image-toolkit\";s:2:\"30\";s:28:\"admin/content/rss-publishing\";s:2:\"31\";s:24:\"admin/settings/date-time\";s:2:\"32\";s:31:\"admin/settings/site-maintenance\";s:2:\"33\";s:25:\"admin/settings/clean-urls\";s:2:\"34\";s:10:\"admin/logs\";s:2:\"12\";s:17:\"admin/logs/status\";s:2:\"35\";s:26:\"admin/logs/status/run-cron\";i:-95;s:21:\"admin/logs/status/php\";i:-96;s:21:\"admin/logs/status/sql\";i:-97;s:22:\"admin/content/taxonomy\";s:2:\"36\";s:27:\"admin/content/taxonomy/list\";i:-99;s:37:\"admin/content/taxonomy/add/vocabulary\";i:-100;s:38:\"admin/content/taxonomy/edit/vocabulary\";i:-101;s:32:\"admin/content/taxonomy/edit/term\";i:-102;s:13:\"taxonomy/term\";i:-103;s:21:\"taxonomy/autocomplete\";i:-104;s:4:\"user\";i:-105;s:17:\"user/autocomplete\";i:-106;s:10:\"user/login\";i:-107;s:13:\"user/register\";i:-108;s:13:\"user/password\";i:-109;s:10:\"user/reset\";i:-110;s:9:\"user/help\";i:-111;s:10:\"admin/user\";s:2:\"13\";s:15:\"admin/user/user\";s:2:\"37\";s:20:\"admin/user/user/list\";i:-114;s:22:\"admin/user/user/create\";i:-115;s:19:\"admin/user/settings\";s:2:\"38\";s:17:\"admin/user/access\";s:2:\"39\";s:16:\"admin/user/roles\";s:2:\"40\";s:21:\"admin/user/roles/edit\";i:-119;s:16:\"admin/user/rules\";s:2:\"41\";s:21:\"admin/user/rules/list\";i:-121;s:20:\"admin/user/rules/add\";i:-122;s:22:\"admin/user/rules/check\";i:-123;s:21:\"admin/user/rules/edit\";i:-124;s:23:\"admin/user/rules/delete\";i:-125;s:6:\"user/1\";i:-126;s:6:\"logout\";s:1:\"6\";s:19:\"admin/logs/watchdog\";s:2:\"42\";s:25:\"admin/logs/page-not-found\";s:2:\"43\";s:24:\"admin/logs/access-denied\";s:2:\"44\";s:16:\"admin/logs/event\";i:-131;s:42:\"http://localhost:8888/drupal_5_5/?q=node/3\";s:2:\"51\";s:33:\"http://localhost:8888/drupal_5_5/\";s:2:\"52\";}s:5:\"items\";a:136:{i:0;a:5:{s:4:\"path\";s:0:\"\";s:5:\"title\";s:0:\"\";s:4:\"type\";i:1;s:3:\"pid\";i:1;s:8:\"children\";a:2:{i:0;i:1;i:1;i:50;}}i:1;a:7:{s:3:\"pid\";i:0;s:4:\"path\";s:0:\"\";s:5:\"title\";s:10:\"Navigation\";s:6:\"weight\";i:-50;s:6:\"access\";b:1;s:4:\"type\";i:3;s:8:\"children\";a:11:{i:0;i:-19;i:1;i:-20;i:2;i:-59;i:3;i:-64;i:4;i:-103;i:5;i:-104;i:6;i:-105;i:7;i:3;i:8;i:4;i:9;i:5;i:10;i:6;}}i:-2;a:6:{s:4:\"path\";s:22:\"admin/build/block/list\";s:5:\"title\";s:4:\"List\";s:4:\"type\";i:640;s:6:\"weight\";i:-10;s:3:\"pid\";s:2:\"14\";s:8:\"children\";a:8:{i:0;i:-6;i:1;i:-7;i:2;i:-8;i:3;i:-9;i:4;i:-10;i:5;i:-11;i:6;i:-12;i:7;i:-13;}}i:-3;a:6:{s:4:\"path\";s:27:\"admin/build/block/configure\";s:5:\"title\";s:15:\"Configure

it doesn't make sense!!
please might i have a help?
is there anyone knows how i can fix this kind of error?
I'm not working in remote, just in local..if it is useful to know...
thanks to evreyone!
Sara