Posted on: 03/01/06 02:48pm
By: lgriffin
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
Comments error
Posted on: 03/01/06 03:10pm
By: Anonymous (troy14)
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.
Comments error
Posted on: 03/01/06 03:42pm
By: Dirk
Comments error
Posted on: 03/02/06 08:24am
By: lgriffin
Thanks, you guys are great
Larry
Comments error
Posted on: 03/03/06 11:32am
By: lgriffin
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
Comments error
Posted on: 03/03/06 02:33pm
By: Dirk
It's in system/lib-comment.php
bye, Dirk
Comments error
Posted on: 03/03/06 04:09pm
By: bjudson
I've posted a fix for this before (note the line #'s may have changed by a few lines):
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');
As a side note I recently switched from GoDaddy ($3.95 per month) to
1&1[*2] ($2.99 per month) and this is no longer a problem!
Comments error
Posted on: 03/05/06 10:33am
By: lgriffin
Thanks for the help, that worked. Also I will look into 1&1
Again Thanks
Larry
Comments error
Posted on: 03/07/06 01:35pm
By: Anonymous (Deirdre)
Thanks, I was having the same problems as well, again with GoDaddy...
I guess I'll be looking into 1and1 as well.
YAY!