Is the install of Erpal tested on a Postgresql 9.3.5 database? I am trying, but am plagued with errors like duplicate tables, missing indexes and the inability to create "sites/default/files/private".
Anybody?

Comments

manuelBS’s picture

manuelBS commented

You are testing ERPAL Core as module or a distribution like ERPAL Platform or ERPAL for Service Providers?

jrr_cn’s picture

jrr_cn commented

I downloaded erpal-7.x-2.0-core.tar.gz. Then did tar -zxvf erpal-7.x-2.0-core.tar.gz. Copied the whole thing to the home directory of my server and ran install.php into a Postgresql database.

It looks like installing a Drupal-distribution.

andrewsizz’s picture

andrewsizz commented

Hey jrr_no,
Just want to ask if you saw this article http://pgedit.com/install_drupal?

jrr_cn’s picture

jrr_cn commented

hello AndrewsizZ
there is no problem installing Drupal in a PostgreSQL database. I have done that many times.
What I suspect is that somewhere in the Erpal package there is some syntax that is functional for MySQL, but not for PostgreSQL, so I was wondering if the makers of Erpal also tried an install into PostgreSQL. If they succeeded than I must be doing something wrong.

Kr

Jan

jrr_cn’s picture

jrr_cn commented

Any developments regarding installing Erpal into Drupal on a PostgreSQL database?

andrewsizz’s picture

andrewsizz commented

Hey Jan,
Currently I not have time to do this, if I will find several minutes I will try to help.
And as always patches are welcome!

jrr_cn’s picture

jrr_cn commented

Hello Andrew,
Thank you for your time. I am looking forward for your opinion and I bet "Bright Solutions GmbH" will also be very happy.
I focus on PostgreSQL, because I prefer open source and Mysql is owned by Oracle.

kr

Jan

terenteml’s picture

terenteml commented

Same grateful request to test the installation on Postgresql here...

andrewsizz’s picture

andrewsizz commented
Status: Active » Postponed (maintainer needs more info)

Ok, guys I download ERPAL core module, add added to clear drupal 7.34. After "drush en erpal_output_ui -y" all modules of ERPAL core installed correctly. PostgreSQL 9.3.5

terenteml’s picture

terenteml commented

Hello,

I confirm the installation of erpal core module over Postgresql following the comment of AndrewsizZ.
However, e fresh install of erpal_platform or erpal distribution with drush site-install on a Postgresql database is unsuccesfull. For reference, the result of:

drush site-install erpal_platform [...] --clean-url=0 -v -d

is

WD system: commerce_line_item module enabled. [73.87 sec, 25.16 MB]                                                                                                                                                               [info]
WD php: Notice: Array to string conversion in DatabaseSchema_pgsql->createTableSql() (line 131 of /srv/www/htdocs/erpal/includes/database/pgsql/schema.inc). [74.43 sec, 25.54 MB]                                           [notice]
WD php: Notice: Array to string conversion in DatabaseSchema_pgsql->createTableSql() (line 131 of /srv/www/htdocs/erpal/includes/database/pgsql/schema.inc). [74.43 sec, 25.55 MB]                                           [notice]
WD php: PDOException: SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "Array"                                                                                                                               [error]
LINE 14: ...ONSTRAINT commerce_order_order_number_key UNIQUE (Array, Arr...
                                                              ^: CREATE TABLE {commerce_order} (
        order_id serial CHECK (order_id >= 0),
        order_number varchar(255) NULL,
        revision_id bigint CHECK (revision_id >= 0) NULL,
        type varchar(255) NOT NULL default '',
        uid int NOT NULL default 0,
        mail varchar(255) NOT NULL default '',
        status varchar(255) NOT NULL,
        created int NOT NULL default 0,
        changed int NOT NULL default 0,
        hostname varchar(128) NOT NULL default '',
        data bytea NULL,
        PRIMARY KEY (order_id),
        CONSTRAINT commerce_order_order_number_key UNIQUE (Array, Array),
        CONSTRAINT commerce_order_revision_id_key UNIQUE (revision_id)
); Array
(
)
 in db_create_table() (line 2720 of /srv/www/htdocs/erpal/includes/database/database.inc). [74.43 sec, 25.47 MB]
WD php: Warning: Cannot modify header information - headers already sent by (output started at /usr/share/drush/includes/output.inc:38) in drupal_send_headers() (line 1233 of                                               [warning]
/srv/www/htdocs/erpal/includes/bootstrap.inc). [74.44 sec, 25.49 MB]
PDOException: SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near "Array"
LINE 14: ...ONSTRAINT commerce_order_order_number_key UNIQUE (Array, Arr...
                                                              ^: CREATE TABLE {commerce_order} (
        order_id serial CHECK (order_id >= 0),
        order_number varchar(255) NULL,
        revision_id bigint CHECK (revision_id >= 0) NULL,
        type varchar(255) NOT NULL default '',
        uid int NOT NULL default 0,
        mail varchar(255) NOT NULL default '',
        status varchar(255) NOT NULL,
        created int NOT NULL default 0,
        changed int NOT NULL default 0,
        hostname varchar(128) NOT NULL default '',
        data bytea NULL,
        PRIMARY KEY (order_id),
        CONSTRAINT commerce_order_order_number_key UNIQUE (Array, Array),
        CONSTRAINT commerce_order_revision_id_key UNIQUE (revision_id)
); Array
(
)
 in db_create_table() (line 2720 of /srv/www/htdocs/erpal/includes/database/database.inc).
Drush command terminated abnormally due to an unrecoverable error. [74.44 sec, 25.47 MB]

A similar error was reported here and the workaround was a patch applied to the .install file of that module (scald) which tuned the settings for the installation over Postgresql.

Thanks,
Mihai

jrr_cn’s picture

jrr_cn commented

No progress.
Tried to install erpal_platform through Drush. No luck:

drush site-install erpal_platform [...] --clean-url=0 -v -d
Bootstrap to phase 0. [0 sec, 1.04 MB] [bootstrap]
Drush bootstrap phase : _drush_bootstrap_drush() [0.01 sec, 1.11 MB] [bootstrap]
Cache HIT cid: 5.10.0-commandfiles-0-8d199c88fe617ca82094b7a70a9727db [0.02 sec, 1.12 MB] [debug]
Bootstrap to phase 0. [0.06 sec, 2.52 MB] [bootstrap]
Bootstrap to phase 1. [0.08 sec, 2.53 MB] [bootstrap]
Drush bootstrap phase : _drush_bootstrap_drupal_root() [0.08 sec, 2.53 MB] [bootstrap]
Initialized Drupal 7.34 root directory at /var/www/html/drupal [0.11 sec, 3.02 MB] [notice]
Found command: site-install (commandfile=core) [0.11 sec, 3.02 MB] [bootstrap]
Drush bootstrap phase : _drush_bootstrap_drupal_site() [0.15 sec, 3.06 MB] [bootstrap]
Initialized Drupal site default at sites/default [0.15 sec, 3.06 MB] [notice]
Cache HIT cid: 5.10.0-commandfiles-2-1c82782e4f0daa661b06df029df9c6f1 [0.15 sec, 3.06 MB] [debug]
Drush bootstrap phase : _drush_bootstrap_drupal_configuration() [0.16 sec, 3.17 MB] [bootstrap]
Cache HIT cid: 5.10.0-commandfiles-3-b1688d6758c80974582e66226c34b21e [0.16 sec, 3.17 MB] [debug]
Executing: psql --dbname=template1 --host=localhost --port=5432 --username=drupaladmin -t -c "SELECT 1 AS result FROM pg_database WHERE datname='drupal'"
Password for user drupaladmin:
1

You are about to DROP all tables in your 'drupal' database. Do you want to continue? (y/n): y
Sites directory sites/default already exists - proceeding. [10.3 sec, 3.17 MB] [notice]
Executing: psql --dbname=template1 --host=localhost --port=5432 --username=drupaladmin -t -c "SELECT 1 AS result FROM pg_database WHERE datname='drupal'"
Password for user drupaladmin:
1

Executing: psql -q --dbname=drupal --host=localhost --port=5432 --username=drupaladmin --no-align --field-separator=' ' --pset footer=off --file /tmp/drush_0rqCh8
Password for user drupaladmin:
tablename
Calling system(psql -q --dbname=drupal --host=localhost --port=5432 --username=drupaladmin --no-align --field-separator=' ' --pset footer=off --file /tmp/drush_XcCQKJ);
Password for user drupaladmin:
psql:/tmp/drush_XcCQKJ:1: ERROR: syntax error at end of input
LINE 1: DROP TABLE
^
Undefined offset: 1 site_install.drush.inc:147 [24.1 sec, 3.18 MB] [notice]
Starting Drupal installation. This takes a few seconds ... [24.11 sec, 3.33 MB] [ok]
WD php: Exception: Sorry, the profile you have chosen cannot be loaded. in install_load_profile() (line 1372 of /var/www/html/drupal/includes/install.core.inc). [24.27 [error]
sec, 5.68 MB]
Cannot modify header information - headers already sent by (output started at /usr/share/php/drush/includes/output.inc:37) bootstrap.inc:1233 [24.27 sec, 5.68 MB] [warning]
Exception: Sorry, the profile you have chosen cannot be loaded. in install_load_profile() (line 1372 of /var/www/html/drupal/includes/install.core.inc).
Drush command terminated abnormally due to an unrecoverable error. [24.27 sec, 5.68 MB] [error]

I guess Erpal should not be dependent of MySQL. Anybody better results?

andrewsizz’s picture

andrewsizz commented

Oh, so issue not in ERPAL core but in ERPAL platform? Am I right? in this case issue should be created for https://www.drupal.org/project/erpal_platform project and this should be closed

Drupa1ish’s picture

Drupa1ish commented
Related issues: +#2503485: [Meta] Make ERPAL for Service Providers work with PostgreSQL