[drupal-devel] [bug] Bootstrap totally broken with PostgreSQL

[plj]

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.