SebboKleine Posted November 21, 2007 Posted November 21, 2007 Hello Hope my english is good enough, so you can understand my problems. I live in Germany and sometimes help a few people with osCommerce. Mostly it's installing a few contributions. Now I've a really big problem. Hope this is the right forum to post the problem. The shop is running quite a while with not a lot orders. At the end of last month there was an order from a foreign country. And here the problems startet. When you take a look at the orders in the administration it looks very weird. As you can see, the last orders all get listet twice with different values. The lower one is correct. The other one is total nonsense. The first (bottom) order on the pic is correct (and so are all previous orders). All others have the problem. The one from Jakob is the first order ever from a country other than Germany. I guess the problem has to do with this. Lets have a look at one order: This is one order I made for test-purposes. And the country is always Germany. But in the lower right area there is shipping to spain? When I made the test-order it always showed me correct values and also the email I got show correct values. But when you look into the administration area, you have this weird values. It also has to do with the orders_total db table. The hightes orders_id in the orders table is 28. In the orders_total table the orders_id goes up to 1110. It seems that something is writing weird values in the orders_total table. But I do not know where this happens. I've checked the checkout_process.php. There the right orders_id is used for the orders_total table. It has to happen somewhere else. There are a lot of contribs used. But I didn't found anything there. Any ideas? Where should I start to look any further? Quote
SebboKleine Posted November 26, 2007 Author Posted November 26, 2007 Seems like nobody has any idea ... In the meantime I was able to find a quick solution. I deleted every row in the orders_total table with orders_id higher than 28. This does not correct exisiting orders but new orders are correct. At least at the moment. Because I still do not know, where these entries in orders_total came from. And they might come back... Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.