Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Recommended Posts

Posted

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.

 

orders.png

 

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:

orders1.png

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?

Posted

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

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.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...