Load Balancing and Sessions with MySQL

[Guest]

I have had a shop running for some time now and am very impressed with OSC. However, I have run into a snag. My host has implemented load balancing on the server farm. In order to have the sessions work properly I now have to use MySQL to save the sessions. No problem, I went to configure.php and set the sessions setting to 'mysql'. Now I get the following:

 

1054 - Unknown column 'value' in 'field list'

 

select value from sessions where sesskey = 'f9725a91bf917d781b177fe8eccc3c11' and expiry > '1037916015'

 

[TEP STOP]

 

1054 - Unknown column 'sesskey' in 'where clause'

 

select count(*) as total from sessions where sesskey = 'f9725a91bf917d781b177fe8eccc3c11'

 

[TEP STOP]

 

I have no idea how to fix this. Any help would be appreciated.