Error when install two Drupal 6.2 with PGSQL and table prefix (and patch)
Hi,
Today, i've tried to install two sets of datas into a drupal 6.2
database (with pgsql). With a table prefix i've take an error like :
Warning: pg_query() [function.pg-query]: Query failed: ERROR: type
"int_unsigned" already exists in
/var/www/xxxxxx/drupal-6.2/includes/database.pgsql.inc on line 138
Warning: ERROR: type "int_unsigned" already exists query: CREATE DOMAIN
int_unsigned integer CHECK (VALUE >= 0) in
/var/www/xxxxxx/drupal-6.2/includes/database.pgsql.inc on line 159
Warning: pg_query() [function.pg-query]: Query failed: ERROR: type
"smallint_unsigned" already exists in
/var/www/xxxxxx/drupal-6.2/includes/database.pgsql.inc on line 138
Warning: ERROR: type "smallint_unsigned" already exists query: CREATE
DOMAIN smallint_unsigned smallint CHECK (VALUE >= 0) in
/var/www/xxxxxx/drupal-6.2/includes/database.pgsql.inc on line 159
Warning: pg_query() [function.pg-query]: Query failed: ERROR: type
"bigint_unsigned" already exists in
/var/www/xxxxxx/drupal-6.2/includes/database.pgsql.inc on line 138
Warning: ERROR: type "bigint_unsigned" already exists query: CREATE
DOMAIN bigint_unsigned bigint CHECK (VALUE >= 0) in
/var/www/xxxxxx/drupal-6.2/includes/database.pgsql.inc on line 159
Ok ... Drupal try to create data types two times ... and crash :(
If anyone else has the same error, this patch can solve this problem :
--=={ snip }==--
--- drupal-6.2-ref/modules/system/system.install 2008-06-19
10:19:36.000000000 +0200
+++ drupal-6.2/modules/system/system.install 2008-06-19
15:53:28.000000000 +0200
@@ -302,9 +302,15 @@
function system_install() {
if ($GLOBALS['db_type'] == 'pgsql') {
// Create unsigned types.
- db_query("CREATE DOMAIN int_unsigned integer CHECK (VALUE >= 0)");
- db_query("CREATE DOMAIN smallint_unsigned smallint CHECK (VALUE >=
0)");
- db_query("CREATE DOMAIN bigint_unsigned bigint CHECK (VALUE >= 0)");
+ if (!db_result(db_query("SELECT COUNT(*) FROM pg_type WHERE typname
= 'int_unsigned'"))) {
+ db_query("CREATE DOMAIN int_unsigned integer CHECK (VALUE >= 0)");
+ }
+ if (!db_result(db_query("SELECT COUNT(*) FROM pg_type WHERE typname
= 'smallint_unsigned'"))) {
+ db_query("CREATE DOMAIN smallint_unsigned smallint CHECK (VALUE
>= 0)");
+ }
+ if (!db_result(db_query("SELECT COUNT(*) FROM pg_type WHERE typname
= 'bigint_unsigned'"))) {
+ db_query("CREATE DOMAIN bigint_unsigned bigint CHECK (VALUE >= 0)");
+ }
// Create functions.
db_query('CREATE OR REPLACE FUNCTION "greatest"(numeric, numeric)
RETURNS numeric AS
--=={ snip }==--
Gwen
--
Gwenael Saint-Genest
MAKINA CORPUS - www.makina-corpus.com
44 boulevard des Pas Enchantés FR-44230 Saint Sébastien sur Loire
Tel : +33 (0) 2 40 94 96 08
Gwen, Please review existing issues for postgresql [1] and submit your patch to one if appropriate, or if not, create an issue and attach it there [2]. Nat 1. http://drupal.org/project/issues/drupal?text=postgresql&projects=3060&states... 2. http://drupal.org/node/add/project-issue/drupal On Thu, Jun 19, 2008 at 3:13 PM, Saint-Genest Gwenael < gwenael.saint-genest@makina-corpus.com> wrote:
Hi,
Today, i've tried to install two sets of datas into a drupal 6.2 database (with pgsql). With a table prefix i've take an error like :
Warning: pg_query() [function.pg-query]: Query failed: ERROR: type "int_unsigned" already exists in /var/www/xxxxxx/drupal-6.2/includes/database.pgsql.inc on line 138 Warning: ERROR: type "int_unsigned" already exists query: CREATE DOMAIN int_unsigned integer CHECK (VALUE >= 0) in /var/www/xxxxxx/drupal-6.2/includes/database.pgsql.inc on line 159 Warning: pg_query() [function.pg-query]: Query failed: ERROR: type "smallint_unsigned" already exists in /var/www/xxxxxx/drupal-6.2/includes/database.pgsql.inc on line 138 Warning: ERROR: type "smallint_unsigned" already exists query: CREATE DOMAIN smallint_unsigned smallint CHECK (VALUE >= 0) in /var/www/xxxxxx/drupal-6.2/includes/database.pgsql.inc on line 159 Warning: pg_query() [function.pg-query]: Query failed: ERROR: type "bigint_unsigned" already exists in /var/www/xxxxxx/drupal-6.2/includes/database.pgsql.inc on line 138 Warning: ERROR: type "bigint_unsigned" already exists query: CREATE DOMAIN bigint_unsigned bigint CHECK (VALUE >= 0) in /var/www/xxxxxx/drupal-6.2/includes/database.pgsql.inc on line 159
Ok ... Drupal try to create data types two times ... and crash :(
If anyone else has the same error, this patch can solve this problem :
--=={ snip }==-- --- drupal-6.2-ref/modules/system/system.install 2008-06-19 10:19:36.000000000 +0200 +++ drupal-6.2/modules/system/system.install 2008-06-19 15:53:28.000000000 +0200 @@ -302,9 +302,15 @@ function system_install() { if ($GLOBALS['db_type'] == 'pgsql') { // Create unsigned types. - db_query("CREATE DOMAIN int_unsigned integer CHECK (VALUE >= 0)"); - db_query("CREATE DOMAIN smallint_unsigned smallint CHECK (VALUE >= 0)"); - db_query("CREATE DOMAIN bigint_unsigned bigint CHECK (VALUE >= 0)"); + if (!db_result(db_query("SELECT COUNT(*) FROM pg_type WHERE typname = 'int_unsigned'"))) { + db_query("CREATE DOMAIN int_unsigned integer CHECK (VALUE >= 0)"); + } + if (!db_result(db_query("SELECT COUNT(*) FROM pg_type WHERE typname = 'smallint_unsigned'"))) { + db_query("CREATE DOMAIN smallint_unsigned smallint CHECK (VALUE
= 0)");
+ } + if (!db_result(db_query("SELECT COUNT(*) FROM pg_type WHERE typname = 'bigint_unsigned'"))) { + db_query("CREATE DOMAIN bigint_unsigned bigint CHECK (VALUE >= 0)"); + }
// Create functions. db_query('CREATE OR REPLACE FUNCTION "greatest"(numeric, numeric) RETURNS numeric AS --=={ snip }==--
Gwen
-- Gwenael Saint-Genest MAKINA CORPUS - www.makina-corpus.com 44 boulevard des Pas Enchantés FR-44230 Saint Sébastien sur Loire Tel : +33 (0) 2 40 94 96 08
participants (2)
-
Nathaniel Catchpole -
Saint-Genest Gwenael