Re: [Phplib-users] parse error in session.inc

[Peter C. <li...@kr...>]

Hello again

At 22:10 11/02/03 +0100, Achim Daiber wrote:
>> >I get the following problem when I am dealing with really large session 
>> >variables. 
>> >Parse error: parse error in /home/phplib/php/session.inc(329) : eval()'d 
>> >code on line 418 
>
>> Your default session container isnt big enough for the data you're holding
>> in your session. Switch $sess->that_class from ct_sql to ct_split_sql and
>> your problem should go away. 
>> 
>> Peter
>> 
>thanx, it works this way, but unfortunately I now get a mysql-error-message
>I don't know how to interpret:
>
>Database error: Invalid SQL: BEGIN TRANSACTION
>MySQL Error: 1064 (You have an error in your SQL syntax near 'TRANSACTION'
>at line 1)
>Session halted.
>
>The SQL-statement is created in ct_split_sql.inc but I can't see what's
>wrong there.
>
>Any idea?

It's been a while since I had to use ct_split_sql. I think I just commented out the TRANSACTION stuff in ct_split_sql. Normal (myISAM) mySQL tables dont support transactions - see http://www.mysql.com/doc/en/COMMIT.html. A better way would be to have a rewritten ac_store in your local extension of ct_split_sql.

No doubt someone else in the list has a better/more elegant solution. It would be nice if there was a flag in the class that indicated whether the database supports transactions.

Peter