Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Load Balancing and Sessions with MySQL


Guest

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'

 

[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.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...