Posted by spydmobile on July 15, 2009 at 2:37pm
4 followers
Jump to:
| Project: | Instant messenger |
| Version: | 6.x-1.x-dev |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
Hi, Installed the IM module on my PG powered d6.13 and got:
warning: pg_query() [function.pg-query]: Query failed: ERROR: column "sent_time" is of type timestamp without time zone but default expression is of type integer HINT: You will need to rewrite or cast the expression. in /var/www/sandbox/includes/database.pgsql.inc on line 139.
user warning: query: CREATE TABLE im_msg ( mid serial, suid int NOT NULL default 0, sname varchar(60) NOT NULL default '', ruid int NOT NULL default 0, rname varchar(60) NOT NULL default '', msg varchar(255) NOT NULL default '', sent_time timestamp without time zone NOT NULL default 0, received_time timestamp without time zone NOT NULL default 0, PRIMARY KEY (mid) ) in /var/www/sandbox/includes/database.inc on line 517.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "im_msg" does not exist in /var/www/sandbox/includes/database.pgsql.inc on line 139.
user warning: query: CREATE INDEX im_msg_sender_uid_idx ON im_msg (suid) in /var/www/sandbox/includes/database.inc on line 517.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "im_msg" does not exist in /var/www/sandbox/includes/database.pgsql.inc on line 139.
user warning: query: CREATE INDEX im_msg_recipient_uid_idx ON im_msg (ruid) in /var/www/sandbox/includes/database.inc on line 517.
Comments
#1
ooops ... i was hoping no one was using PG anymore ... ;-)
I'll have to look up the syntax. shouldn't take too long...
#2
oops again ... i forgot I'm working in Drupal 6 ...; where you supposedly don't need to know the postgres syntax for building the DB - you just define the schema as per the Drupal Core Schema module and it does the work.
Unfortunately, there are some issues that may take me a little screwing around to get working. See http://drupal.org/node/426334
So .. it looks like I'm going to need to look at each of your errors and, figure out what's different between MySQl & PG, and then also figure out how do I deal with Schema module / install file in terms of hook_install vs hook_updates, etc, etc.
guess it won't be as quick as i thought. sorry. please feel free to do any research on the specific errors you are getting and see if anyone has already figured out how to deal in Drupal 6. I'll do the same.
#3
Hi, i'm having something similar with postgres :-) it seems the table isn't created at all.
This is the error message:
* warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "im_msg" does not exist in /var/www/drupal/includes/database.pgsql.inc on line 139.
* user warning: query: SELECT suid, sname, COUNT(*) AS num_waiting FROM im_msg WHERE ruid=1 AND suid != -1 AND received_time = '0000-00-00 00:00:00' GROUP BY suid in /var/www/drupal/sites/all/modules/im/im.module on line 1057.
#4
Is there any light in the future for this module to work with Postgres?