massimoperini Posted April 30, 2008 Posted April 30, 2008 Hi everyone! I had a problem with some orders recently. I try to explain: A customer orders something, but the billing and/or the shipping address is assigned to another customer (it appens automatically, it's not a request of the customer to ship to another address). An example (in the admin - orders): Customer: John Smith Shipping Address: Mario Rossi Billing Address: Mario Rossi I'm running an old version (don't know which, it's of the year 2003) with MySql 4.1.11. This happens only sometimes, not everytime, I really don't know what it could be, maybe an error in the database or a bug of some old releases? If anyone knows what it could be, please help me! Many thanks!!! Max
jaybee1960 Posted April 30, 2008 Posted April 30, 2008 Hi everyone!I had a problem with some orders recently. I try to explain: A customer orders something, but the billing and/or the shipping address is assigned to another customer (it appens automatically, it's not a request of the customer to ship to another address). An example (in the admin - orders): Customer: John Smith Shipping Address: Mario Rossi Billing Address: Mario Rossi I'm running an old version (don't know which, it's of the year 2003) with MySql 4.1.11. This happens only sometimes, not everytime, I really don't know what it could be, maybe an error in the database or a bug of some old releases? If anyone knows what it could be, please help me! Many thanks!!! Max Has this only started to happen recently ? How long has your store been online ?
massimoperini Posted April 30, 2008 Author Posted April 30, 2008 Has this only started to happen recently ?How long has your store been online ? yes, it started about 2 weeks ago... uhm I think 2-3 years (I'm trying to solve this for a friend) he told me that recently he had an increase of the orders... I've just read another post with the same problem... it may depend on the db? Too many connections or soemthing like that? Max.
massimoperini Posted April 30, 2008 Author Posted April 30, 2008 I've found something around the forum, it may be due to the http sessions... could it be the right way for the solution? Max.
Guest Posted April 30, 2008 Posted April 30, 2008 I've found something around the forum, it may be due to the http sessions... could it be the right way for the solution?Max. Could be, also if you are on a shared server it can cause problems.
Guest Posted April 30, 2008 Posted April 30, 2008 if on a shared server make sure your tmp settings point to your own area, ie instead of /tmp use /home/yourname/tmp or something along those lines, depending upon what your host gave you
massimoperini Posted April 30, 2008 Author Posted April 30, 2008 if on a shared server make sure your tmp settings point to your own area, ie instead of /tmp use /home/yourname/tmp or something along those lines, depending upon what your host gave you hi, many thanks But I'm using the STORE_SESSIONS var to 'mysql', so I think the tmp dir is not used, isn't it? I'm quite new to oscommerce, sorry and thanks for the help Max.
Guest Posted May 1, 2008 Posted May 1, 2008 hi, many thanksBut I'm using the STORE_SESSIONS var to 'mysql', so I think the tmp dir is not used, isn't it? I'm quite new to oscommerce, sorry and thanks for the help Max. Best to change it as suggested by Mibble.
sizzlax Posted June 16, 2008 Posted June 16, 2008 Hi, I have had the same problem. It started when i had around 250 orders. I solved the problem by removing all orders. Now i could have more than 250 orders a day so i don't want to happen it again. Did the suggested solution worked? My sessions are stored in the mysql on a shared server (one.com) I have these options: MySQL 5.0.32-Debian_7etch5-log PHP 4.4.8 osCommerce 2.2-MS2 Sessions-directory /customers/....../httpd.www/osc/tmp chmod 777 Force cookies True Controleer SSL sessie-ID False Controleer browser user False Controleer IP-adres user False Block spiders False Recreate session True Thank you!
sizzlax Posted June 18, 2008 Posted June 18, 2008 I have found this blog where this problem is beeing solved. http://mysqldatabaseadministration.blogspo...p-sessions.html But i have no sessions in the url (oscsid links). i still don't see what i have to do.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.