Issue status update for http://drupal.org/node/28274 Post a follow up: http://drupal.org/project/comments/add/28274 Project: Drupal Version: cvs Component: base system Category: bug reports Priority: critical Assigned to: Anonymous Reported by: plj Updated by: plj Status: patch (code needs work) Attachment: http://drupal.org/files/issues/bootstrap.inc_5.patch (1.46 KB) Actually, it seems there are two such problems (LOCK TABLES) in bootstrap.inc. Here is a better patch, that fixes them both. Same limitations apply as above, though. plj Previous comments: ------------------------------------------------------------------------ Fri, 05 Aug 2005 15:06:08 +0000 : plj Attachment: http://drupal.org/files/issues/bootstrap.inc_4.patch (986 bytes) Just cheked out today's HEAD, installed, and attempted to access main page. Results: [client 10.10.59.23] PHP Notice: Undefined variable: _SESSION in /var/www/drupal_HEAD/includes/bootstrap.inc on line 771 [client 10.10.59.23] PHP Notice: Undefined variable: _SESSION in /var/www/drupal_HEAD/includes/bootstrap.inc on line 771 [client 10.10.59.23] PHP Notice: Undefined variable: _SESSION in /var/www/drupal_HEAD/includes/bootstrap.inc on line 771 [client 10.10.59.23] PHP Warning: pg_query(): Query failed: ERROR: syntax error at or near "cache" at character 13 in /var/www/drupal_HEAD/includes/database.pgsql.inc on line 69 [client 10.10.59.23] PHP Fatal error: ERROR: syntax error at or near "cache" at character 13\nquery: LOCK TABLES cache WRITE in /var/www/drupal_HEAD/includes/database.pgsql.inc on line 86 [client 10.10.59.23] PHP Notice: Undefined property: cache in /var/www/drupal_HEAD/includes/session.inc on line 45 [client 10.10.59.23] PHP Warning: pg_query(): Query failed: ERROR: syntax error at or near "cache" at character 13 in /var/www/drupal_HEAD/includes/database.pgsql.inc on line 69 [client 10.10.59.23] PHP Fatal error: ERROR: syntax error at or near "cache" at character 13\nquery: LOCK TABLES cache WRITE in /var/www/drupal_HEAD/includes/database.pgsql.inc on line 86 [client 10.10.59.23] PHP Warning: pg_query(): Query failed: ERROR: syntax error at or near "cache" at character 13 in /var/www/drupal_HEAD/includes/database.pgsql.inc on line 69 [client 10.10.59.23] PHP Fatal error: ERROR: syntax error at or near "cache" at character 13\nquery: LOCK TABLES cache WRITE in /var/www/drupal_HEAD/includes/database.pgsql.inc on line 86 This is because bootstap.inc uses LOCK/UNLOCK TABLES, but PostgreSQL does not support this syntax. I've attached a patch that fixes the problem on pgsql, but this probably still needs work as it most likely won't work on MySQL as such.