Geeklog Forums

finally i was able to install geeklog and made a few changes thrugh css. Everything looks great expect for posting comment. When i try to post comment it seems to go through and actully gave me a message saying will take 45 seconds. But that comment is still not appearing and when i try to post second comment it game me this message
"An SQL error has occured. Please see error.log for details."

I checked error.log and this is what it says in the log -

*** dummy entry ***
Wed Nov 30 17:27:00 2005 - 1146: Table 'geeklog.gl_plugins' doesn't exist. SQL in question: SELECT pi_name FROM gl_plugins WHERE pi_enabled = 1
Fri Dec 2 11:08:15 2005 - Error, invalid username: 'bulldog'
Sat Dec 3 16:20:32 2005 - 1044: Access denied for user: 'geeklog@65.202.189.%' to database 'geeklog'. SQL in question: LOCK TABLES gl_comments WRITE
Sat Dec 3 16:25:14 2005 - 1044: Access denied for user: 'geeklog@65.202.189.%' to database 'geeklog'. SQL in question: LOCK TABLES gl_comments WRITE
Sat Dec 3 16:29:53 2005 - 1044: Access denied for user: 'geeklog@65.202.189.%' to database 'geeklog'. SQL in question: LOCK TABLES gl_comments WRITE


What does this mean? I don't know anything about sql?
Could someone explain me what to do and how to fix this problem?
I really appreciate any help i get.
thanks

Do other things work (e.g. creating new stories), i.e. it's only posting comments that is causing this error? If so, please see comment.php error: can not lock table gl_comments

The error message you quoted usually means that your MySQL information is wrong (wrong MySQL username, password, database, or database server name) - but then you shouldn't be able to change anything ...

bye, Dirk

Thanks Dirk i really appreciate your help.
Yes i can post stories and event calendar, and everything else is working great and i love it so far except for posting comments.
Posting comment is a must have on the website.

I am using godaddy hosting and ask them about locking and unlocking previleages -(Though i don't know what exactly it mean) They told me that i have to do it myself through control panel.

I don't know how to lock and unlock tables in mysql.

I need this to work so bad and it is must have.

Thanks

I am not an expert at this by any means but I think what Dirk is refereing to is the sql database that Geeklog constructed after you created that very database.

Basically you had to create a database in your mysql panel for your website right? Or else nohting would work, I think? So assuming you did this, at the time you named the database and probably created a password or the password for your website control panel has been assinged to your database.

Your database name and password must be inserted into the config file.

I would check to see if you have that info set right then see what happens. The godaddy thing is easy if you have to mess with that stuff. I think thats in the dns settings area of your account but try to look into the mysql stuff that Dirk spoke of first.


Good luck,
Jordy

You have to issue the GRANT LOCK TABLES ... command from the above FAQ entry from a MySQL prompt somewhere. Sorry, I don't know what interface to MySQL GoDaddy provides, so can't provide any detailed instructions.

bye, Dirk

Thanks Dirk and Jordy...

So i have to apply the following command some where in mysql?

GRANT LOCK TABLES ON .* to @

Does anyone know how to apply above command in mysql through Godaddy hosting? Simple instruction would be greatly appreciated.

Thanks

-bull

hey,

i have no idea what that means but I found a thread in Gl that refers to this here

I did not read it all but it may help you

It is confusing. I don't know much about sql so i don't know how to lock table. I am using 4.0.24 version of MYSQL and phpmyAdmin 2.4.0
through godaddy hosting.

Thanks

hey I don't pretend to know sql either but this is what i learned recently in phpmyAdmin. I fyou can figure out how to select your particular database then yo can click one of the sql icons. A box should open where you can put the SQL query in. I assume that would be what you spoole of before GRANT LOCK TABLES ON .* to @.

The box theat opens shoudl say "run sql query"

make soure yo backup your databases first before messing with this.

Regards,
Jordy

Hi Bull

This is easy to fix if you have phpMyAdmin and you are the owner of the mysql database.

Open up phpMyadmin an select Priviliges. Then press the edit picture of your geeklog DB-user (its a guy and a writer on the right). Now you see 3 Colums.
On the left "data" and middle "structure" you should have everything ticked.
On the right "Administration" you have to activate LOCK TABLES. Not more and not less on this collum. Now posting comments will work.

Cheers
Suvi

This is what i did i tried to insert -
GRANT LOCK TABLES ON glog. * TO user@mysql17.secureserver.net

and i get this error "Access denied for user: 'glog@64.202.189.%' to database 'glog'"

I don't know ...still confuse.

As you are using a hoster you probably don't have GRANT privileges.
(this would be wrong if you have it). Try phpMYAdmin on your home test setup, you will see it will work.

It's the easiest that you contact your webhoster and tell him that
you need the LOCK Tables privilege.

I am thinking of shifting from godaddy hosting.
Do you know of any hosting that provides GRANT privileges and i don't have to deal with this kind of situation? Thanks again.

bull

I am using opensourcehost.com. I think they are great. They have most excelent technical support, always very prompt. I have found them to be most helpful to me in situatiions where they really didn't have to help me but they did. They support all of the big opensource software like phpnuke,GL and Gallery. I even think that they will install some of that for you if you can't yourself.

Hope that helps.
Jordy

OR

If your hosting provider REFUSES to give you Grant access, as GoDaddy, Shieldhost, and a million others will do, and you can't or won't change providers then you can edit the following file.

(Note Dirk, you should make this a config option, discourage it's use, but make it an option the big cheap providers just don't care about independent sites)

/pathtogl/system/lib-comment.php

Line 837 add // to the front so:
// DB_query("LOCK TABLES {$_TABLES['comments']} WRITE");
Line 863 add // to the front so:
//DB_query('UNLOCK TABLES');

Line 968 add // to the front so:
// DB_query("LOCK TABLES {$_TABLES['comments']} WRITE");

Line 987 add // to the front so :
// DB_query('UNLOCK TABLES');