On our VPS, we have an online store running Magento 1.6.1.0. On this same Magento, two additional stores were created, making a total of three stores created on the same Magento. Each store has a mobile version.
All stores use rEvolution Mobile theme by aheadWorks, even though front design template for the desktop version of each store is different. All stores are up and running and can be viewed on desktops, as well as iPhones and Blackberry mobile phones.
Each of the stores has multiple currencies activated and a customer can change the display currency using the default currency converter which is a standard feature of Magento.
Issues affecting all three Desktop Sites
A customer can login to the front end, add items to their cart and checkout without any problem.
If however a customer logs in to the front end, adds items to their cart and tries to change the display currency, the site will crash.
If a customer is NOT logged in, he can change currency of display without any problem, and the site will not crash.
If a customer is NOT logged in, and he adds items to the shopping cart and changes the currency of display the site will crash.
Issues affecting all three Mobile Sites
They experience all the issues mentioned above.
Also, if a customer logs in to the front end, add items to their cart and tries to checkout, the site will crash.
This happens even when a customer is NOT logged in, and tries to checkout; the site will crash.
If a customer is not logged in, and nothing has been added to the shopping cart, currency can be changed successfully and the site will not crash.
Solution Required
We need our customers to be able to login to the front end, add items to their carts, be able to change the currency at any stage during the transaction as they so desire, and checkout successfully without the site crashing, on both the desktop versions and the mobile versions.
Notes
All the sites are on one Magento installation
Extensions by webshopapps, aheadWorks and SweetTooth are installed
Host has indicated as follows:
Removing the session files from public_html/var/session/ will cause the internal server error to stop for you. This seems to be failing at the same point every time:
5719 12:26:31 write(3, "1\1\0\0\3SELECT `mag_customer_entity_varchar`.* FROM `mag_customer_entity_varchar` WHERE (entity_id ='3') UNION ALL SELECT `mag_customer_entity_int`.* FROM `mag_customer_entity_int` WHERE (entity_id ='3') UNION ALL SELECT `mag_customer_entity_datetime`.* FROM "..., 309) = 309
Host has also said, 'I've increased the MySQL timeouts and PHP max execution times and the process continues to error on the same line which leads me to believe that this is an issue within the database.'
Host ran an strace and the file is attached as additional information.