[Phpgroupware-tracker] [bug #5068] Database error with db sessions & sitemgr

[nobody]

=================== BUG #5068: LATEST MODIFICATIONS ==================
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=5068&group_id=509

Changes by: Dave Hall <address@hidden>
Date: Thu 10/09/03 at 18:34 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
          Resolution | None                      | Later
             Summary | Database error at http://www.phpgroupware.org/requests | 
Database error with db sessions & sitemgr


------------------ Additional Follow-up Comments ----------------------------
I have spent some time looking at this code, and can;t work out why it is doing 
this.  Will mark it as a later.



=================== BUG #5068: FULL BUG SNAPSHOT ===================


Submitted by: powerstat               Project: phpGroupWare                 
Submitted on: Fri 09/05/03 at 05:32
Category:  sitemgr                    Bug Group:  0.9.16RC1                 
Severity:  5 - Major                  Priority:  Normal                     
Resolution:  Later                    Assigned to:  skwashd                 
Status:  Open                         Component Version:  None              
Platform Version:  None               Reproducibility:  Intermittent        

Summary:  Database error with db sessions & sitemgr

Original Submission:  I found the link http://www.phpgroupware.org/requests

someone on the phpgroupware.org webiste - maybe on the irc page.



Clicking on the link results in:



Database error: Invalid SQL: INSERT INTO phpgw_sessions VALUES 
('d43a3ccc680e7b98879c0e489fc64c1e','visitor','80.134.22.70','1062757999','1062757999','/index.php','A')

MySQL Error: 1062 (Duplicate entry 'd43a3ccc680e7b98879c0e489fc64c1e' for key 1)



File: /home/phpgw/https/phpgwapi/inc/class.sessions_db.inc.php

Line: 60



Session halted.



Follow-up Comments
*******************

-------------------------------------------------------
Date: Thu 10/09/03 at 18:34         By: skwashd
I have spent some time looking at this code, and can;t work out why it is doing 
this.  Will mark it as a later.

-------------------------------------------------------
Date: Wed 09/10/03 at 17:06         By: powerstat
I just tried something else - I walked around in the wiki, and would like to 
send an interesting page to a collegue.

So I modified the url - removing the sessionid etc. etc. from it to:



http://docs.phpgroupware.org/wiki/index.php?page=How+to+hook+into+Admin+and+Preferences



which also results into the above database error.

But only the first time!

By calling the URL a second time and empty wiki page appears.



-------------------------------------------------------
Date: Wed 09/10/03 at 11:50         By: skwashd
Ok, will look into it more

-------------------------------------------------------
Date: Wed 09/10/03 at 04:12         By: powerstat
No I have not returned by a bookmark or so.

-------------------------------------------------------
Date: Tue 09/09/03 at 17:15         By: skwashd
This is an intermittent problem I have found with sitemgr.  Did you use a 
bookmark or return to a session after a few hours when you received this error?



I will mark it as a sitemge bug for now, but it may be the API.



Just trying to work it out.


CC list is empty


No files currently attached


For detailed info, follow this link:
http://savannah.gnu.org/bugs/?func=detailbug&bug_id=5068&group_id=509

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