Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 09:43 pm EDT

Geeklog Forums

sql error


my-reunion

Anonymous
hello,
my site working well yesterday, but when i try to update a story today, it said sql error, check logs file.. so, i check and found this:

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. SQL in question: SELECT DISTINCT ft_name FROM gl_access,gl_features WHERE ft_id = acc_ft_id AND acc_grp_id IN ()

help me. thank you.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
I wish I knew why that happens to some people ...

Can you try enable verbose logging in system/lib-security.php by setting
Text Formatted Code
// Turn this on go get various debug messages from the code in this library
$_SEC_VERBOSE = true;
 
(that's line 64 in that file).

Then try again and if it still fails, check your error.log file and quote all the extra lines it added there now (lots of lines starting with ***** etc.).

bye, Dirk
 Quote

my-reunion

Anonymous
thanks, i just delete the whole site and now i use fantastico sript from the hosting. and it working well.
 Quote

ajom

Anonymous
Quote by Dirk: I wish I knew why that happens to some people ...

Can you try enable verbose logging in system/lib-security.php by setting
Text Formatted Code
// Turn this on go get various debug messages from the code in this library
$_SEC_VERBOSE = true;

 
(that's line 64 in that file).

Then try again and if it still fails, check your error.log file and quote all the extra lines it added there now (lots of lines starting with ***** etc.).

bye, Dirk



Wed May 17 06:03:24 2006 - got 0 rows
Wed May 17 06:03:24 2006 - ****************leaving getusergroups(uid=1)***************
Wed May 17 06:03:24 2006 - **********inside SEC_getUserPermissions(grp_id=)**********
Wed May 17 06:03:24 2006 - ****************in getusergroups(uid=1,usergroups=,cur_grp_id=)***************
 Quote

Ajom

Anonymous
I need help to solve this error:-

Wed May 17 19:55:16 2006 - ****************in getusergroups(uid=,usergroups=,cur_grp_id=)***************
Wed May 17 19:55:16 2006 - got 0 rows
Wed May 17 19:55:16 2006 - ****************leaving getusergroups(uid=1)***************
Wed May 17 19:55:16 2006 - **********inside SEC_getUserPermissions(grp_id=)**********
Wed May 17 19:55:16 2006 - ****************in getusergroups(uid=1,usergroups=,cur_grp_id=)***************
Wed May 17 19:55:16 2006 - got 0 rows
Wed May 17 19:55:17 2006 - ****************leaving getusergroups(uid=1)***************
Wed May 17 19:55:17 2006 - 1064: 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 'Wink' at line 1. SQL in question: SELECT DISTINCT ft_name FROM gl_access,gl_features WHERE ft_id = acc_ft_id AND acc_grp_id IN ()
Wed May 17 19:55:17 2006 - _BLOCK_TEMPLATE[_msg_block] = blockheader-message.thtml,blockfooter-message.thtml
Wed May 17 19:55:17 2006 - Block template for the header of _msg_block is: blockheader-message.thtml
Wed May 17 19:55:17 2006 - _BLOCK_TEMPLATE[_msg_block] = blockheader-message.thtml,blockfooter-message.thtml
Wed May 17 19:55:17 2006 - Block template for the footer of _msg_block is: blockfooter-message.thtml
Wed May 17 19:55:19 2006 - ****************in getusergroups(uid=,usergroups=,cur_grp_id=)***************
Wed May 17 19:55:19 2006 - got 0 rows
Wed May 17 19:55:19 2006 - ****************leaving getusergroups(uid=1)***************
Wed May 17 19:55:19 2006 - **********inside SEC_getUserPermissions(grp_id=)**********
Wed May 17 19:55:19 2006 - ****************in getusergroups(uid=1,usergroups=,cur_grp_id=)***************
Wed May 17 19:55:19 2006 - got 0 rows
Wed May 17 19:55:19 2006 - ****************leaving getusergroups(uid=1)***************
Wed May 17 19:55:19 2006 - 1064: 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 'Wink' at line 1. SQL in question: SELECT DISTINCT ft_name FROM gl_access,gl_features WHERE ft_id = acc_ft_id AND acc_grp_id IN ()
Wed May 17 19:55:19 2006 - _BLOCK_TEMPLATE[_msg_block] = blockheader-message.thtml,blockfooter-message.thtml
Wed May 17 19:55:19 2006 - Block template for the header of _msg_block is: blockheader-message.thtml
Wed May 17 19:55:19 2006 - _BLOCK_TEMPLATE[_msg_block] = blockheader-message.thtml,blockfooter-message.thtml
Wed May 17 19:55:19 2006 - Block template for the footer of _msg_block is: blockfooter-message.thtml
 Quote

All times are EDT. The time is now 09:43 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content