[Phpgroupware-tracker] [bugs #9201] Chat disabled due to Database error:

[Mark Kidd]

This mail is an automated notification from the bugs tracker
 of the project: phpGroupWare.




/**************************************************************************/
[bugs #9201] Full Item Snapshot:

URL: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=9201>
Project: phpGroupWare
Submitted by: Mark Kidd
On: Thu 06/03/2004 at 13:44

Category:  chat
Item Group:  0.9.16.000 release
Severity:  5 - Average
Priority:  5 - Normal
Resolution:  None
Assigned to:  None
Status:  Open
Component Version:  TGZ
Platform Version:  GNU/Linux - Mandrake
Reproducibility:  Every Time


Summary:  Chat disabled due to Database error:

Original Submission:  patch file submitted for 

phpgroupware-0.9.16.000-1

Linux Mandrake 9.1 Community Edition

Apache-AdvancedExtranetServer/2.0.47 (Mandrake Linux/1.3.91mdk) 
mod_perl/1.99_08 Perl/v5.8.0 mod_ssl/2.0.47 OpenSSL/0.9.7a PHP/4.3.1

php-mysql-4.3.0-2mdk

mysql 4.0.11a-gamma

Database error: Invalid SQL: select * from phpgw_sessions where session_flags 
!= 'A' order by ASC session_lid LIMIT 15
MySQL Error: 1064 (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 'ASC 
session_lid LIMIT 15' at line 1)

File: /var/www/html/phpgroupware/phpgwapi/inc/class.sessions_db.inc.php
Line: 186
Session halted.





File Attachments
-------------------

-------------------------------------------------------
Date: Thu 06/03/2004 at 13:44  Name: patchfile.diff  Size: 954KB   By: 
cmon_stoke
patch to switch $sort and $order variables
http://savannah.gnu.org/bugs/download.php?item_id=9201&amp;item_file_id=1368






For detailed info, follow this link:
<http://savannah.gnu.org/bugs/?func=detailitem&item_id=9201>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/