Geeklog Forums

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.

I wish I knew why that happens to some people ...

Can you try enable verbose logging in system/lib-security.php by setting (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

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

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=)***************

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 '' 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 '' 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