bugphpGroupWare - Bugs: bug #8541, SQL Error in rightmost chat frame...

 
 

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

bug #8541: SQL Error in rightmost chat frame (suggested fix listed)

Submitted by:  None
Submitted on:  Mon 12 Apr 2004 02:26:07 PM UTC  
 
Item Group: 0.9.16.000 releaseCategory: chat
Severity: 3 - NormalPriority: 7 - High
Status: FixedPrivacy: Public
Assigned to: Mark A Peters <skeeter>Open/Closed: Closed
Component Version: TGZOperating System: GNU/Linux - RedHat/Fedora
Reproducibility: Every TimePlanned Release: None
Fixed Release: 

Mon 10 May 2004 03:45:55 PM UTC, comment #2:

I also found this bug and applied and investigated this fix (before I found this bug report). I'm not an SQL guru but I tried the syntax of the error and found it incorrect. The correct syntax is:- SELECT * FROM phpgw_sessions limit WHERE session_flags != 'A' ORDER BY session_lid ASC
Which in the code I believe is "select * from phpgw_sessions where session_flags != 'A' order by $order $sort"
Perhaps the confusion is in the variable names. I would have had the ASC being the "order" not the "sort".
Either way, when I fixed it, it did not break the admin.

Anonymous
Mon 12 Apr 2004 03:50:59 PM UTC, comment #1:

It turns out that the "fix" I listed above breaks session administration (and who knows what else), so I changed it back. Any other suggestions on how to get this working properly???

<<<Brian

Anonymous
Mon 12 Apr 2004 02:26:07 PM UTC, original submission:

Using:
MySQL Server Version: 3.23.58
PHP Version 4.3.4

The rightmost frame produces an SQL error resulting from a syntax error on line 186 of .../class.sessions_db.inc.php'. I suspect this problem is SQL version specific - my particular version doesn't find ordering ASC before session_lid to be palatable. After some experimenting, I have found that switching '$sort' and '$order' on line 186 fixed the problem.

Anonymous

 

No files currently attached

 

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 3 latest changes.

Date Changed By Updated Field Previous Value => Replaced By
Tue 11 May 2004 04:58:20 AM UTCskwashdStatusNone=>Fixed
  Assigned toNone=>skeeter
  Open/ClosedOpen=>Closed

Back to the top


Powered by Savane 3.1-cleanup1