Welcome to Geeklog, Anonymous Saturday, November 09 2024 @ 08:18 am EST
Geeklog Forums
SQL error when posting comments
Richard
Anonymous
Hi, I recently installed Geeklog version 1.3.11sr2 on my site and I'm getting this error message after posting a comment on anything, whether i'm logged in as admin, or as a guest user, or as a test account i made........
An SQL error has occured. Please see error.log for details.
you can see the error yourself by trying to post a comment at RichardsDomain.Com News 'n' Blog
I checked the error.log file and this is the error ....
Wed Nov 30 20:36:49 2005 - 1044: Access denied for user: 'dbusername@IP%' to database 'databasename'. SQL in question: LOCK TABLES gl_comments WRITE
everything else is working fine so far and i've checked and all files and directories are CHMOD as suggested, so i'm lost.
I've only edited the Style Sheet for the 'Proffessional Theme' and also did a timezone hack edit to show my timezone.
Does anyone have any idea of what the problem could be ? is there a setting somewhere within the Admin console, or a line that needs changing somewhere in one of the files?
I haven't installed any addons/plugins and when i try to post a comment it's in plain text mode that i get that error message, i enter comment, then preview it, and when click on 'Submit' is when error page appears.
Thanks in advance i hope to get this working.
An SQL error has occured. Please see error.log for details.
you can see the error yourself by trying to post a comment at RichardsDomain.Com News 'n' Blog
I checked the error.log file and this is the error ....
Wed Nov 30 20:36:49 2005 - 1044: Access denied for user: 'dbusername@IP%' to database 'databasename'. SQL in question: LOCK TABLES gl_comments WRITE
everything else is working fine so far and i've checked and all files and directories are CHMOD as suggested, so i'm lost.
I've only edited the Style Sheet for the 'Proffessional Theme' and also did a timezone hack edit to show my timezone.
Does anyone have any idea of what the problem could be ? is there a setting somewhere within the Admin console, or a line that needs changing somewhere in one of the files?
I haven't installed any addons/plugins and when i try to post a comment it's in plain text mode that i get that error message, i enter comment, then preview it, and when click on 'Submit' is when error page appears.
Thanks in advance i hope to get this working.
7
5
Quote
Richard
Anonymous
Hiya
Thanks for that. I just checked on another blog and also a cms that i have installed on my site and the Comments work fine on those. So ima take a look at db with phpMyAdmin. It's either something in there or something in Geeklog file somewhere that's stopping it.
Thanks again for putting me onto that link . cheers
Thanks for that. I just checked on another blog and also a cms that i have installed on my site and the Comments work fine on those. So ima take a look at db with phpMyAdmin. It's either something in there or something in Geeklog file somewhere that's stopping it.
Thanks again for putting me onto that link . cheers
9
9
Quote
Richard
Anonymous
I'm lost. I'm new to working with mySQL and phpMyAdmin. So can someone please guide me as to how to do that SQL as mentioned in that link above ? lol ... i need sleep
Thanks in advance, and if i do find a way to fix this, or when someone helps me i'll post when i've atleast got it working.
Thanks in advance, and if i do find a way to fix this, or when someone helps me i'll post when i've atleast got it working.
7
5
Quote
All times are EST. The time is now 08:18 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