Navigation
Syndicate
Drupal and LOCK TABLES and me
I think Drupal is just great. Before deciding on a CMS I tried out Tikiwiki, Mambo, and Typo3, and a couple others. Drupal definitely wasn't the easiest to get going out of the box, but there are so many other advantages, that once you start to get your head around how things work, it's definitely a better system.
That being said, I'm hosted by a service that doesn't give me complete control over my databases. I run on MySQL, and the drupal code requires the use of LOCK TABLES. My host won't allow this, even after lots of emails. I'm not moving to another host because the cost is so low. So...what to do?
I'm not a database person. I know how to use PHPMyAdmin and that's about it. This is part of the Drupal code that kept me from being able to add users, images, etc. without LOCK TABLES permission. It's in includes/database.mysql.inc.
db_query('LOCK TABLES {sequences} WRITE&');
$id = db_result(db_query("SELECT id FROM {sequences} WHERE name ='%s'", $name)) + 1;
db_query("REPLACE INTO {sequences} VALUES ('%s', %d)", $name, $id); db_query('UNLOCK TABLES');I just commented out the top and bottom lines so that it looks like:
/**db_query('LOCK TABLES {sequences} WRITE');*/
$id = db_result(db_query("SELECT id FROM {sequences} WHERE name = '%s'", $name)) + 1;
db_query("REPLACE INTO {sequences} VALUES ('%s', %d)", $name, $id);
/**db_query('UNLOCK TABLES');*/ I can now add users, images, content, etc. into the database. WIth a small site, no problems yet. But this is definitely not recommended at all by the developers or me. YMMV.
UPDATE: I've since move the database somewhere where I can get them to do GRANT LOCK TABLE permissions. Drupal 4.7 is coming and I don't want to futz around with this stuff anymore.