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:

Submitted by:  Mark Kidd <cmon_stoke>
Submitted on:  Thu 03 Jun 2004 01:44:47 PM UTC  
 
Item Group: 0.9.16.000 releaseCategory: chat
Severity: 3 - NormalPriority: 5 - Normal
Status: FixedPrivacy: Public
Assigned to: Dave Hall <skwashd>Open/Closed: Closed
Component Version: TGZOperating System: GNU/Linux - Mandrake
Reproducibility: Every TimePlanned 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>
Project AdministratorIn charge of this item.
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>

 

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

 

Do you think this task is very important?
If so, you can click here to add your encouragement to it.
This task has 0 encouragements so far.

Only logged-in users can vote.

 

Please enter the title of George Orwell's famous dystopian book (it's a date):

 

 

Follow 4 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Sun 06 Jun 2004 10:44:04 PM UTCskwashdStatusNone=>Fixed
  Assigned toNone=>skwashd
  Open/ClosedOpen=>Closed
Thu 03 Jun 2004 01:44:48 PM UTCcmon_stokeAttached File-=>Added patchfile.diff, #1368

Back to the top


Powered by Savane 3.1-cleanup1