Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By jeffd-1 on
After enabling modules like mail api and webmail plus (forgive, I forget which one these first occurred at) I received messages like:
g_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "default" LINE 20: default int NOT NULL default '0', ^ in /home/tsweb/public_html/includes/database.pgsql.inc on line 139.
query: CREATE TABLE mail_api_servers ( id serial, name varchar(64) NOT NULL default '', protocol text NOT NULL, protocol_module text NOT NULL, hostname text, port int_unsigned, encryption text NOT NULL, domain text, folder_prefix varchar(128) default '', hide_folder_prefix smallint default 0, inbox_folder varchar(128) default '', trash_folder varchar(128) default '', sent_folder varchar(128) default '', drafts_folder varchar(128) default '', outbox_folder varchar(128) default '', options varchar(128) default '', login_suffix varchar(128) default '', suspended int NOT NULL default '0', default int NOT NULL default '0', PRIMARY KEY (id) ) in /home/tsweb/public_html/includes/database.inc on line 515.
pg_query() [function.pg-query]: Query failed: ERROR: relation "mail_api_servers" does not exist in /home/tsweb/public_html/includes/database.pgsql.inc on line 139.
query: CREATE INDEX mail_api_servers_id_idx ON mail_api_servers (id) in /home/tsweb/public_html/includes/database.inc on line 515.
These were all copied from the log, so they may have somewhat different appearance.
So as mentioned, I am using drupal 6.9, mail api 1.0, webmail plus 1.4 with pgsql. How might I troubleshoot this problem, and if I manage to fix the issue, how can I get the database entries it tries to create recreated?
