Welcome to Geeklog, Anonymous Saturday, November 09 2024 @ 07:30 am EST
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.
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.
8
10
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
$_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
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;
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
7
8
Quote
my-reunion
Anonymous
thanks, i just delete the whole site and now i use fantastico sript from the hosting. and it working well.
8
8
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
$_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
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;
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=)***************
9
7
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 '' 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
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
7
8
Quote
All times are EST. The time is now 07:30 am.
- 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