Geeklog Forums

hi
have searched the forums but havent found a identical issue

I am running Geeklog 1.3.10. When a clicks on a link for a comment on a comment a page is displayed with "An SQL error has occurred, please see error.log for details." This happens in every case logged-in or not logged in at all admin or user. The error log displayed this message:
Fri Mar 11 00:28:11 2005 - 1044: Access denied for user: 'user@localhost' to database 'name_db'. SQL in question: LOCK TABLES gl_comments WRITE

Thanks in advance.
Ron

Are you sure it is not this FAQ and you do have the LOCK privilige ?

Greetz,
Boris

---

Vanrillaer.com - our Family Portal

Thanks for apprecciate answer.. I haven't so much experience in this and also my english isn't so good ;-)

I read the FAQ now.. so I ask what is better for beginn:
- speak whit my hosting provider and tell him I want "LOCK TABLE" priveleges?
- I have a low traffice site now.. but this should be a risk maybe in future ;-)
- for upgrade to InnoDB tables.. how I can do it?

thanks in advance
Ron

Unless you are planning to get a lot of simultaneous comments at the same time, I suggest you go for option 1 now while you send at the same time a friendly email to your hosting provider and ask them if they can grant you the lock privilige.

Most probably their answer will be no, but asking never hurts.

So my for this is, just remove all the "LOCK TABLE" "UNLOCK TABLE" SQL calls from comment.php.

Just look for


and


and comment them out.

Best Regards,
Boris

---

Vanrillaer.com - our Family Portal

This is great.. for now I have comment with 2 slash "//" the line where there is write "LOCK TABLE" or "UNLOCK TABLE" in comment.php and I can put comment now.
Next time I ask to my provider for "LOCK TABLE" priveleges.

Thanks Boris
Best Regards,
Ron