Well, we continued onward. Ran into another MySQL error. "Help!" ;-)

Here goes...


    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, me query: SELECT id, message, type, sender, recipient, room FROM ajaxim_messages WHERE (recipient=2 OR recipient IN (SELECT room FROM ajaxim_chats WHERE uid=2)) GROUP BY sender, message, recipient ORDER BY id ASC in /home2/recovery/christians-in-recovery-www/includes/database.mysql.inc on line 172.

Yup... ALL of that!

Here is the status page again...

Drupal	5.1
Configuration file	Protected
Cron maintenance tasks	Last run 48 min 5 sec ago
You can run cron manually.
Database schema	Up to date
File system	Writable (private download method)
GD library	bundled (2.0.28 compatible)
MySQL database	4.0.26
PHP	4.4.4
Unicode library	PHP Mbstring Extension
Web server	Apache/1.3.35 (Unix) ApacheJServ/1.1.2 PHP/4.4.4 FrontPage/5.0.2.2635 Rewrit/1.1a

Comments

changlin’s picture

changlin commented
Title: Another MySQL Error » I met the same question. The reason is the low mysql version.

After mysql 4.1, it began to support 'IN' in the sql command. That's why the issue occured. I think we need rephrase the sql command by ourselves, unless these guys could provide us a version supporting mysql 4.0.*.

changlin’s picture

changlin commented
Title: I met the same question. The reason is the low mysql version. » rewrite the query without a subquery

From MySQL Reference Manual for version 4.0.15......

You can often rewrite the query without a subquery:

SELECT * FROM table1 WHERE id IN (SELECT id FROM table2);

This can be rewritten as:

SELECT table1.* FROM table1,table2 WHERE table1.id=table2.id;

The queries:

SELECT * FROM table1 WHERE id NOT IN (SELECT id FROM table2);
SELECT * FROM table1 WHERE NOT EXISTS (SELECT id FROM table2
WHERE table1.id=table2.id);

Can be rewritten as:

SELECT table1.* FROM table1 LEFT JOIN table2 ON table1.id=table2.id
WHERE table2.id IS NULL;

Using a LEFT [OUTER] JOIN is generally much faster than an equivalent subquery because the server can optimise it better, a fact that is not specific to MySQL Server alone. Prior to SQL-92, outer joins did not exist, so subqueries were the only way to do certain things in those bygone days. But that is no longer the case, MySQL Server and many other modern database systems offer a whole range of outer joins types.

mdlueck’s picture

mdlueck commented

changlin: Thanks much for looking into this. This module is not a burning issue for us right now, but may be in the future. So I do not think I will jump right in and recoding the queries.

Yes, it would be nice if the developers provided support for MySQL 4.0.x

changlin’s picture

changlin commented

I rewrote these sql sentences for mysql 4.0.*. Just in case somebody may need it. Please test the code in your website.

About line 135:
/* mysql4.0 doesn't support IN. Rewrite the sql by changlin 20070731 */
// $query = db_query("SELECT id, message, type, sender, recipient, room FROM {ajaxim_messages} WHERE (recipient=%d OR recipient IN (SELECT room FROM {ajaxim_chats} WHERE uid=%d)) GROUP BY sender, message, recipient ORDER BY id ASC", $user->uid, $user->uid);
$query = db_query("SELECT msgs.id, msgs.message, msgs.type, msgs.sender, msgs.recipient, msgs.room FROM {ajaxim_messages} msgs, {ajaxim_chats} chats WHERE (msgs.recipient=%d OR (msgs.recipient=chats.room and chats.uid=%d)) GROUP BY msgs.sender, msgs.message, msgs.recipient ORDER BY msgs.id ASC", $user->uid, $user->uid);
// end

About Line 169:
/* mysql4.0 doesn't support IN. Rewrite the sql by changlin 20070731 */
// db_query("DELETE FROM {ajaxim_messages} WHERE id IN (%s)", implode(',', $to_delete));
$tempstr = implode(" OR id=", $to_delete);
$tempstr = "id=".$tempstr;
db_query("DELETE FROM {ajaxim_messages} WHERE (%s)", $tempstr);
//end

About Line 428:
/* mysql4.0 doesn't support IN. Rewrite the sql by changlin 20070731 */
// $query = db_query("SELECT aj.uid, u.name, aj.status FROM {ajaxim_status} aj LEFT JOIN {users} u ON u.uid=aj.uid WHERE u.name IN ('%s') AND u.name!='%s' AND aj.status > 0 ORDER BY u.name ASC", implode("','", $users), $from);
$tempstr="0";
if (count($users) > 0) {
$tempstr = implode("' AND u.name<> '", $users);
$tempstr = "u.name<>'".$tempstr."'";
}

$query = db_query("SELECT aj.uid, u.name, aj.status FROM {ajaxim_status} aj LEFT JOIN {users} u ON u.uid=aj.uid WHERE (%s) AND u.name!='%s' AND aj.status > 0 ORDER BY u.name ASC", $tempstr, $from);
//end

About line 466:
/* mysql4.0 doesn't support IN. Rewrite the sql by changlin 20070731 */
// $query = db_query("SELECT b.uid, u.name, aj.status FROM {buddylist} b LEFT JOIN {users} u ON u.uid=b.uid LEFT JOIN {ajaxim_status} aj ON aj.uid = b.uid WHERE b.buddy=%d AND b.uid NOT IN (SELECT buddy FROM {buddylist} WHERE uid=%d)", $fuser->uid, $fuser->uid);
$query = db_query("SELECT buddy FROM {buddylist} WHERE uid=%d", $fuser->uid);
$temp1 = array();
while ($row = db_fetch_array($query)) {
$temp1[] = $row['buddy'];
}
$tempstr="1";
if (count($temp1) > 0) {
$tempstr = implode(" AND b.uid<>", $temp1);
$tempstr = "b.uid<>".$tempstr;
}

$query = db_query("SELECT b.uid, u.name, aj.status FROM {buddylist} b LEFT JOIN {users} u ON u.uid=b.uid LEFT JOIN {ajaxim_status} aj ON aj.uid = b.uid WHERE b.buddy=%d AND (%s)", $fuser->uid, $tempstr);
//end

About line 511:
/* mysql4.0 doesn't support IN. Rewrite the sql by changlin 20070731 */
// $query1 = db_query("SELECT b.uid, u.name , aj.status FROM {buddylist} b LEFT JOIN {users} u ON u.uid=b.uid LEFT JOIN {ajaxim_status} aj ON aj.uid=b.uid WHERE b.buddy=%d AND b.uid NOT IN ('%s')", $fuser->uid, implode("','", $tmp_users));

$tempstr="1";
if (count($tmp_users) > 0) {
$tempstr = implode(" AND b.uid<>", $tmp_users);
$tempstr = "b.uid<>".$tempstr;
}

$query1 = db_query("SELECT b.uid, u.name , aj.status FROM {buddylist} b LEFT JOIN {users} u ON u.uid=b.uid LEFT JOIN {ajaxim_status} aj ON aj.uid=b.uid WHERE b.buddy=%d AND (%s)", $fuser->uid, $tempstr);
//end

akhodakovskiy’s picture

akhodakovskiy commented

Thank you for a work, but it will be greater that such kind of changes will be provided as a patch