Welcome to Geeklog, Anonymous Monday, December 23 2024 @ 08:33 pm EST
Geeklog Forums
Install HELP! MySQL
StStephen
Anonymous
I get this error after (new, clean) installation:
You have an error in your SQL syntax 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 ()
Running MySQL 3.23.58 on Apache 1.3.23, PHP 4.1.2
ANY HELP is appreciated!
You have an error in your SQL syntax 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 ()
Running MySQL 3.23.58 on Apache 1.3.23, PHP 4.1.2
ANY HELP is appreciated!
6
7
Quote
StStephen
Anonymous
Ok, apparently MySQL permissions were not set correctly, which caused empty values in the DB. Seems to work now!
Thanks!
Thanks!
9
5
Quote
Farfelue
Anonymous
You posted this error problem after a new installation...
I now have this very same message after a couple of weeks of trouble-free use...???
Can you please tell me how to modify the MySQL permissions... I guess they must be changed on the server
I now have this very same message after a couple of weeks of trouble-free use...???
Can you please tell me how to modify the MySQL permissions... I guess they must be changed on the server
23
8
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
For the permissions, see http://www.geeklog.net/docs/install.html#access-denied.
But I doubt that this will solve the problem. Please provide more information.
bye, Dirk
But I doubt that this will solve the problem. Please provide more information.
bye, Dirk
8
6
Quote
Farfelue
Anonymous
I was referring to the following log message, which StSteven began this thread with:
You have an error in your SQL syntax 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 ()
My Geeklog site was a charm to setup, I even added the forum plugin + the forum's french language file, and everything's been working just fine...
Today, however, after several days of Geeklog enchantment , while showing someone how easy it is to post a story comment, my admin fuctions began to give me error notices...
I therefore quit the site, unable to even log out, and have been getting error pages everytime I try to re-enter the site
And the log reports the above mentioned remark...
Now I've already tried a few things like deleting cookies, trying another browser, and even renaming the directory on the server (yes, I corrected all the paths, etc.)
Earlier in this thread, StSteven mentioned changing MySQL permissions on the server, to correct a blank space... If this was his solution, I'm not sure how to do it
Thanks, in advance, for your help
You have an error in your SQL syntax 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 ()
My Geeklog site was a charm to setup, I even added the forum plugin + the forum's french language file, and everything's been working just fine...
Today, however, after several days of Geeklog enchantment , while showing someone how easy it is to post a story comment, my admin fuctions began to give me error notices...
I therefore quit the site, unable to even log out, and have been getting error pages everytime I try to re-enter the site
And the log reports the above mentioned remark...
Now I've already tried a few things like deleting cookies, trying another browser, and even renaming the directory on the server (yes, I corrected all the paths, etc.)
Earlier in this thread, StSteven mentioned changing MySQL permissions on the server, to correct a blank space... If this was his solution, I'm not sure how to do it
Thanks, in advance, for your help
5
6
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
The error message means that the current user is not in any group - which shouldn't happen.
Can you create a new user account? If so, you can try creating a new root user and repair things with that account then.
bye, Dirk
P.S. And please don't post in bold, it's annoying ...
Can you create a new user account? If so, you can try creating a new root user and repair things with that account then.
bye, Dirk
P.S. And please don't post in bold, it's annoying ...
7
7
Quote
Farfelue
Anonymous
Sorry about the bold Dirk
Appreciate your answer, however, I cannot get into the site...
Even if I use another browser, or another dial-up!
That's "THE" problem.
Could I send you this site's URL privately, and ask you to try
I'm getting desperate, and about to pull out whatever hair I have left on my head
Appreciate your answer, however, I cannot get into the site...
Even if I use another browser, or another dial-up!
That's "THE" problem.
Could I send you this site's URL privately, and ask you to try
I'm getting desperate, and about to pull out whatever hair I have left on my head
8
6
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
Quote by Farfelue: however, I cannot get into the site...
Even if I use another browser, or another dial-up!
That's "THE" problem.
Even if I use another browser, or another dial-up!
That's "THE" problem.
Hmm. Did you have a look at your database? It's possible that the gl_groups or gl_group_assignments tables are empty or at least missing entries.
Do you have a database backup?
Quote by Farfelue: Could I send you this site's URL privately, and ask you to try
Sure, but I won't have the time to look into it until tomorrow.
bye, Dirk
8
6
Quote
All times are EST. The time is now 08:33 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