Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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
Comment #1
darklrd CreditAttribution: darklrd commentedHi,
The correct link would be drupalchat/messages i.e. http://www.mwsadispatches.com/drupalchat/messages.
Thanks!
Comment #2
drupalycious CreditAttribution: drupalycious commentedHello,
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
Comment #3
morybel CreditAttribution: morybel commentedSame 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
Comment #4
darklrd CreditAttribution: darklrd commentedmory,
The error means that the drupalchat module failed to install properly.
Which database are you using? Did you get any error while installing?
Thanks
Comment #5
morybel CreditAttribution: morybel commentedI 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
Comment #6
darklrd CreditAttribution: darklrd commentedThanks for the info. Please let me know the database server you are using (described here - http://drupal.org/requirements/database). Thanks.
Comment #7
darklrd CreditAttribution: darklrd commentedAlso, was this first time installation or were you upgrading from a previous version?
Comment #8
darklrd CreditAttribution: darklrd commentedComment #9
morybel CreditAttribution: morybel commentedOk, 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.
Comment #10
E_Stew CreditAttribution: E_Stew commentedI get the same error, chat works but message inbox says
Notice: Undefined variable: ouput in drupalchat_get_messages() (line 1126 of /home/midwe143/public_html/test_site/sites/all/modules/drupalchat/drupalchat.module).
I feel like it's probably something obvious, help much appreciated
Comment #11
apadernoThe 7.x-1.x branch is not supported. Is the bug still present in the 7.x-2.x branch?