After installing Drupal Chat, I tried to access the "Message Inbox" without any luck.

http://www.mwsadispatches.com/drupalchat/messages/inbox

Returns:

Error
The website encountered an unexpected error. Please try again later.

The chat does work, though.

Comments

darklrd’s picture

Status:Active» Fixed

Hi,

The correct link would be drupalchat/messages i.e. http://www.mwsadispatches.com/drupalchat/messages.

Thanks!

drupalycious’s picture

Status:Fixed» Active

Hello,

I installed the latest dev and I have the same problem:

If I go to drupalsite.xxx/drupalchat/messages or to drupalsite.xxx/drupalchat/messages/inbox (the later being the link indicated in the configuration page of drupalchat)

I receive for both the following error message:

PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dr_database.drupalchat_msg' doesn't exist: SELECT u.name as name, g.uid as uid, g.message as message, g.TIMESTAMP as timestamp FROM ( SELECT uid, message, TIMESTAMP FROM ( ( SELECT m1.uid1 AS uid, m1.timestamp AS TIMESTAMP, m1.message AS message FROM {drupalchat_msg} m1 INNER JOIN ( SELECT MAX( t1.timestamp ) AS TIMESTAMP, t1.uid1 FROM {drupalchat_msg} t1 WHERE t1.uid2 = :uid GROUP BY t1.uid1 ) recent ON recent.timestamp = m1.timestamp AND recent.uid1 = m1.uid1 ORDER BY TIMESTAMP DESC ) UNION ( SELECT m1.uid2 AS uid, m1.timestamp AS TIMESTAMP, m1.message AS message FROM {drupalchat_msg} m1 INNER JOIN ( SELECT MAX( t1.timestamp ) AS TIMESTAMP, t1.uid2 FROM drupalchat_msg t1 WHERE t1.uid1 = :uid GROUP BY t1.uid2 )recent ON recent.timestamp = m1.timestamp AND recent.uid2 = m1.uid2 ORDER BY TIMESTAMP DESC ) ) AS f ORDER BY 3 DESC ) AS g INNER JOIN {drupalchat_users} u ON (g.uid = u.uid AND u.uid!= 0) OR (u.uid = 0 AND g.uid = CONCAT('0-', u.session)) GROUP BY uid; Array ( [:uid] => 1 ) in drupalchat_get_messages() (line 874 of dr/sites/all/modules/drupalchat/drupalchat.module).

But the chat itself seems to be working.

Thanks

mory’s picture

Same here,
I experienced big problems with this module
Upon installation of Drupalchat my site was offline with error message " Error The website encountered an unexpected error. Please try again later"

I uninstalled DrupalChat and my site was working fine but every configuration I have done during the last month was not there. Just as if no theme was applied or some modules were not activated.

This is where I realised that 49 modules has been deactivated with DrupalChat installation within the same second it has been installed.

Error in my log report

PDOException : SQLSTATE[42S02]: Base table or view not found: 1146 Table 'xxx.drupalchat_users' doesn't exist: SELECT status FROM {drupalchat_users} WHERE uid = :uid; Array ( [:uid] => 1 ) dans drupalchat_init() (ligne 379 dans /var/aegir/platforms/drupal-7.x/sites/xxx.ca/modules/drupalchat/drupalchat.module).

7.x-1.0-beta11

Thanks

darklrd’s picture

mory,

The error means that the drupalchat module failed to install properly.

Which database are you using? Did you get any error while installing?

Thanks

mory’s picture

I did have a message telling that the module has not been properly installed. However when I went back to module listing, it was not installed, so I checked it back and installed it and this time it went good and I could see the chatbar at the bottom of the pages. However all my modules were gone.

This is the only message I got in my log event.

Not sure what you need with "Which database I'm using".
Thanks

darklrd’s picture

Thanks for the info. Please let me know the database server you are using (described here - http://drupal.org/requirements/database). Thanks.

darklrd’s picture

Also, was this first time installation or were you upgrading from a previous version?

darklrd’s picture

Status:Active» Postponed (maintainer needs more info)
mory’s picture

Ok, sorry for the delay,
It's a first time installation on:

Drupal 7.10
Web server Apache/2.2.14 (Ubuntu)
Database MySQL

and we are using Aegir to manage our sites.

Hope this help.