Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Load Balancing and Sessions with MySQL


Recommended Posts

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'




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


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




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

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...