[Phplib-trackers] [ phplib-Bugs-657822 ] ct_sql, ac_store

[SourceForge.net <no...@so...>]

Bugs item #657822, was opened at 2002-12-23 06:00
Message generated for change (Comment added) made by chaska
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=403611&aid=657822&group_id=31885

Category: DB_SQL
Group: current CVS
>Status: Closed
Resolution: Wont Fix
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Chris Johnson (chaska)
Summary: ct_sql, ac_store

Initial Comment:
i have an error where i use a frameset in which each 

frame uses the phplib : (in french)

<<

 Erreur de traitement dans la base de données :

Invalid SQL: insert into active_sessions ( sid, name, val, 

changed ) values 

('ad3ebd1806933e185137b158eecf8430', 'ST_Session', 'U

1Rf...7IA==', '20021223125357')

Erreur SQL : 1062 (Duplicate 

entry 'ad3ebd1806933e185137b158eecf8430-

ST_Session' for key 1)

Merci de contacter votre hébergeur.



Session terminée.

>>

i traced the problem and it seems to come from function 

ac_store in ct_sql.inc : (original code)

<<

    if ( $this->db->affected_rows() == 0

        && $this->db->query($squery)

        && $this->db->f(1) == 0

        && !$this->db->query($iquery)) {



        $ret = false;

    }

>>

and modified it with :

<<

if ( $this->db->affected_rows() == 0 &&

  $this->db->query($squery) )

{

  $this->db->next_record();

  if ( $this->db->f(0) == 0 &&

      !$this->db->query($iquery) )

  {

    $ret = false;

  }

}

>>



My question is : Is this a problem coming from my 

MySql version ?



----------------------------------------------------------------------

>Comment By: Chris Johnson (chaska)
Date: 2003-09-09 22:31

Message:
Logged In: YES 
user_id=279065

User misunderstanding.  It appears page_close() was called

in multiple frames.  This is not correct usage.

----------------------------------------------------------------------

Comment By: Nobody/Anonymous (nobody)
Date: 2002-12-23 15:39

Message:
Logged In: NO 

If you are using framesets, you can not call page_close() in each 

frame.  You must call it only in one frame.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=403611&aid=657822&group_id=31885