bugphpGroupWare - Bugs: bug #9201, Chat disabled due to Database...

 
 

You are not allowed to post comments on this tracker with your current authentication level.

bug #9201: Chat disabled due to Database error:

Submitter:  Mark Kidd <cmon_stoke>
Submitted:  Thu 03 Jun 2004 01:44:47 PM UTC
   
 
Category:  chat Item Group:  0.9.16.000 release
Severity:  3 - Normal Priority:  5 - Normal
Status:  Fixed Privacy:  Public
Assigned to:  skwashd Open/Closed:  Closed
Component Version:  TGZ Operating System:  GNU/Linux - Mandrake
Reproducibility:  Every Time Planned Release:  None
Fixed Release: 

Sun 06 Jun 2004 10:44:04 PM UTC, comment #3: 

fixed in cvs

Sorry, I didn't see your patch until after I had fixed it :(

Dave Hall <skwashd>
Group administrator
Thu 03 Jun 2004 03:20:58 PM UTC, comment #2: 

Please ignore patchfile.diff.

Mark Kidd <cmon_stoke>
Thu 03 Jun 2004 03:18:20 PM UTC, comment #1: 

Requires further investigation as call parameter order appears to be the issue.

Mark Kidd <cmon_stoke>
Thu 03 Jun 2004 01:44:47 PM UTC, 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.

Mark Kidd <cmon_stoke>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attached Files
file #1376:  patchfile.diff added by cmon_stoke (954B - application/octet-stream - patch to switch $sort and $order variables)

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

 

Follow 4 latest changes.

Date Changed by Updated Field Previous Value => Replaced by
2004-06-06 skwashd StatusNone Fixed
    Assigned toNone skwashd
    Open/ClosedOpen Closed
2004-06-03 cmon_stoke Attached File- Added patchfile.diff, #1368

Back to the top

Powered by Savane 3.13-02a9.
Corresponding source code