When installing on PostgreSQL Drupal 6.19 following error occurs:

warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for integer: "" in /samsung1/apache/deehost4.dnet/htdocs/erp/includes/database.pgsql.inc on line 139.
user warning: query: CREATE TABLE dru_erp_audit ( audit_date int default '', computer_name varchar(30) NOT NULL default '', main_user varchar(60) NOT NULL default '', location varchar(60) NOT NULL default '', branch varchar(30) NOT NULL default '', cpu varchar(20) NOT NULL default '', ram varchar(20) NOT NULL default '', hdd varchar(10) NOT NULL default '', video varchar(40) NOT NULL default '', pc_label varchar(20) NOT NULL default '', ip_address varchar(16) NOT NULL default '', subnet_mask varchar(16) NOT NULL default '', gateway varchar(16) NOT NULL default '', dns1 varchar(16) NOT NULL default '', dns2 varchar(16) NOT NULL default '', workgroup varchar(30) NOT NULL default '', logon_password varchar(30) NOT NULL default '', email varchar(5) NOT NULL default '', email_account varchar(30) NOT NULL default '', email_password varchar(30) NOT NULL default '', mazda_email varchar(5) NOT NULL default '', mazda_email_account varchar(50) NOT NULL default '', mazda_email_password varchar(30) NOT NULL default '', other_email varchar(5) NOT NULL default '', other_email_settings varchar(10) NOT NULL default '', proxy varchar(5) NOT NULL default '', reynolds varchar(10) NOT NULL default '', reynolds_sw varchar(30) NOT NULL default '', internet_access varchar(5) NOT NULL default '', mail_access varchar(5) NOT NULL default '', operating_system varchar(30) NOT NULL default '', operating_system_license varchar(30) NOT NULL default '', operating_system_key varchar(50) NOT NULL default '', antivirus varchar(5) NOT NULL default '', antivirus_version varchar(20) NOT NULL default '', antivirus_registration varchar(50) NOT NULL default '', antivirus_expiry varchar(20) NOT NULL default '', periphals text NOT NULL, software text NOT NULL, network_data_point varchar(10) NOT NULL default '', reynolds_data_point varchar(10) NOT NULL default '', telephone_data_point varchar(10) NOT NULL default '', other_data_point varchar(10) NOT NULL default '' ) in /samsung1/apache/deehost4.dnet/htdocs/erp/includes/database.inc on line 555.
warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "`" LINE 1: INSERT INTO dru_erp_pricing_levels (`pid`,`markup`,`level`) ... ^ in /samsung1/apache/deehost4.dnet/htdocs/erp/includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO dru_erp_pricing_levels (`pid`,`markup`,`level`) VALUES ('1', '1.2', 'Standard') in /samsung1/apache/deehost4.dnet/htdocs/erp/modules/erp/erp_pricing/erp_pricing.install on line 7.
warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "`" LINE 1: INSERT INTO dru_erp_pricing_levels (`pid`,`markup`,`level`) ... ^ in /samsung1/apache/deehost4.dnet/htdocs/erp/includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO dru_erp_pricing_levels (`pid`,`markup`,`level`) VALUES ('2', '1.15', 'Support Contract') in /samsung1/apache/deehost4.dnet/htdocs/erp/modules/erp/erp_pricing/erp_pricing.install on line 8.
warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "`" LINE 1: INSERT INTO dru_erp_pricing_levels (`pid`,`markup`,`level`) ... ^ in /samsung1/apache/deehost4.dnet/htdocs/erp/includes/database.pgsql.inc on line 139.
user warning: query: INSERT INTO dru_erp_pricing_levels (`pid`,`markup`,`level`) VALUES ('3', '1.1', 'Reseller') in /samsung1/apache/deehost4.dnet/htdocs/erp/modules/erp/erp_pricing/erp_pricing.install on line 9.

I can fix these and submit to CVS if you can provide me access.

Comments

singularo’s picture

Hi there, we don't use postfix, so not surprised it didn't work.

However, I'm more than happy to accept patches using cvs diff -ubr

I will not provide commit access until I see some code examples, and can be assured that what you may deliver is of good quality.

You can't expect to signup 11 hours ago, and get commit access to two projects immediately (erp & calendar I see).

singularo’s picture

argh postgres not postfix ;-)

singularo’s picture

Status: Active » Closed (won't fix)

I have no plans to update for postgres, all future dev will be for Drupal 7, which should support it natively.