Instant Messenger Problem
Hi,
When I try to enable Instant Messenger module, I have the following error:
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "im_msg" does not exist in /opt/local/apache2/htdocs/intranet.cgcom.es/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 /opt/local/apache2/htdocs/intranet.cgcom.es/sites/all/modules/im/im.module on line 794.
warning: pg_query() [function.pg-query]: Query failed: ERROR: relation "im_msg" does not exist in /opt/local/apache2/htdocs/intranet.cgcom.es/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 /opt/local/apache2/htdocs/intranet.cgcom.es/sites/all/modules/im/im.module on line 794.
I've read in README.txt module that enabling the module, a new table called "im_msgs" is created but this table has not created ...
Any suggestion? I need a module like that :D.
Thanks for all ...
Álvaro.
nobody?
nobody?
module version =? when u
module version =?
when u installed the module, did u see any error message?
u are using pgsql ?
We go the drupal way. How about you?
http://www.drupalway.com
Hi
I have used same module and works properly, So you need to check the module version and drupal version as well, hope you will manage all stuff according. Wish you best of luck
I use drupal 6.12 and the
I use drupal 6.12 and the following version of the module:
Development snapshots Date Size Links Status
6.x-1.x-dev 2009-Jun-03 80.1 KB Download · Release notes Development snapshot
Yes ... I use pgsql ... it's only for mysql? I think no ...
nobody?
nobody?
up!
up!
here's how im create a table
here's how im create a table on mysql :
CREATE TABLE {im_msg} (`mid` INT NOT NULL auto_increment,
`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` DATETIME NOT NULL DEFAULT 0,
`received_time` DATETIME NOT NULL DEFAULT 0,
PRIMARY KEY (mid),
INDEX sender_uid (suid),
INDEX recipient_uid (ruid)
) /*!40100 DEFAULT CHARACTER SET UTF8 */
you can check that query and maybe found incompatibility with pg query. or if there's not found, you can try to build im_msg table by that query and see if the module can work properly.