Re: [phplib] ct_split_sql question From: Arek \(James Potts\) (james <email protected>)
Date: 07/28/01

MySQL supports transactions, but only in the latest versions. If you're
using an ISP, chances are you've got 3.22.??, and transaction support only
appears in 3.23 and higher versions (It might even be only in the later
3.23.?? builds, I'm not sure...). Even if you ARE using 3.23 or higher, you
need to switch from the MyISAM table type to something else, as I don't
think that the MyISAM tables support transactions. (GEMINI would be a good
choice....)

I hope this helps...

Arek (James Potts)
(webmaster <email protected>)
(james <email protected>)

----- Original Message -----
From: "Jakob" <jakob <email protected>>
To: <phplib <email protected>>
Sent: Saturday, July 28, 2001 4:47 PM
Subject: [phplib] ct_split_sql question

>
> hi,
>
> I had to switch from using ct_sql to ct_split_sql as my
> container class, as I was getting session errors due to
> the size of my session.
>
> here's my question: I had to comment out the following
> two lines as they generated sql error messages:
>
> ct_split_sql.inc:
> $this->db->query("BEGIN TRANSACTION"); //(l. 67)
> // while loop saving the session into rows
> $this->db->query("END TRANSACTION"); // (l. 88)
>
> it does work now, but i am wondering about the
> implications of this modification.
>
> i should add that i am using mysql which, to my
> knowledge doesn't support transactions (yet).
>
> thanks for your advice,
>
> Jakob.
>
> --
> Abbestellen mit Mail an: phplib-unsubscribe <email protected>
> Kommandoliste mit Mail an: phplib-help <email protected>
> 

-- 
Abbestellen mit Mail an:   phplib-unsubscribe <email protected>
Kommandoliste mit Mail an: phplib-help <email protected>