Welcome to Geeklog, Anonymous Sunday, December 22 2024 @ 10:51 pm EST
Geeklog Forums
Comments error
I have upgraded to geeklog 1.4.0. When I make a comment to a story, it gives the following error:
'gpdallas_geeklog@%' to database 'gpdallas_geeklog". SQL in Question: LOCK TABLES gl_comments WRITE
Any ideas what is wrong?
Thanks
Larry
'gpdallas_geeklog@%' to database 'gpdallas_geeklog". SQL in Question: LOCK TABLES gl_comments WRITE
Any ideas what is wrong?
Thanks
Larry
9
10
Quote
troy14
Anonymous
You need to contact your hosting provider and get LOCK permissions for your tables. Once that is set, the errors will go away. It is not a setting that was used in previous versions, and hosts do not have user accounts set up for those permissions by default.
It happened to me too.
It happened to me too.
10
11
Quote
Status: offline
Dirk
Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
For the sake of completeness, here's the FAQ entry: comment.php error: can not lock table gl_comments
bye, Dirk
bye, Dirk
11
11
Quote
Well the hosting house (GoDaddy) will not grant the lock table to me. There only reason is they don't want to.
I have looked thru the comment.php and i do not find where it is calling for lock table. Am I just overlooking it or is the lock table coming from some where else?
Thanks
Larry
I have looked thru the comment.php and i do not find where it is calling for lock table. Am I just overlooking it or is the lock table coming from some where else?
Thanks
Larry
12
10
Quote
Status: offline
bjudson
Forum User
Junior
Registered: 01/01/04
Posts: 34
I've posted a fix for this before (note the line #'s may have changed by a few lines):
As a side note I recently switched from GoDaddy ($3.95 per month) to 1&1 ($2.99 per month) and this is no longer a problem!
If your hosting provider REFUSES to give you Grant or LOCK 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 files.
(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');
(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');
As a side note I recently switched from GoDaddy ($3.95 per month) to 1&1 ($2.99 per month) and this is no longer a problem!
10
10
Quote
Deirdre
Anonymous
Thanks, I was having the same problems as well, again with GoDaddy...
I guess I'll be looking into 1and1 as well.
YAY!
I guess I'll be looking into 1and1 as well.
YAY!
10
11
Quote
All times are EST. The time is now 10:51 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