Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

orders not showing up


newrev

Recommended Posts

I have osCommerce 2.2 installed on a Linux RedHat server... It is newly installed and I've run a couple of test orders. The problem is that the number of orders are showing on the administration homepage in the left column under "Pending Orders" just as they should... But, when I actually go to the Pending Orders screen, which should list each specific order, the information is not there. It says that I have 0 of 0 pending orders.

 

Could someone PLEASE lend a helping hand. Thanks!

Link to comment
Share on other sites

  • 2 years later...
I have osCommerce 2.2 installed on a Linux RedHat server... It is newly installed and I've run a couple of test orders. The problem is that the number of orders are showing on the administration homepage in the left column under "Pending Orders" just as they should... But, when I actually go to the Pending Orders screen, which should list each specific order, the information is not there. It says that I have 0 of 0 pending orders.

Could someone PLEASE lend a helping hand. Thanks!

 

I've got the same problem... don't know why. my orders are not even logged in the database 'orders' table. Who here knows what might be going on?

Link to comment
Share on other sites

  • 3 months later...
I've got the same problem... don't know why.  my orders are not even logged in the database 'orders' table.  Who here knows what might be going on?

 

Yes, me too. After I placed some test orders, everything's shown up, perfectly. Later I added some contribs. Maybe this has something to do with that?

 

Which contribs do you have installed?

Link to comment
Share on other sites

But all orders are showing in the admin overview page:

 

/catalog/admin/index.php

 

Pending / processing / delivered: all orders are counted, but if I click on the links,

no order is showing up.

 

Except if I ask for a specific oder number. This is possible. Strange, since it worked

before.

Link to comment
Share on other sites

But all orders are showing in the admin overview page:

 

/catalog/admin/index.php

 

Pending / processing / delivered: all orders are counted, but if I click on the links,

no order is showing up.

 

Except if I ask for a specific oder number. This is possible. Strange, since it worked

before.

 

Danny,

 

That is my problem too, except I never tested the order process b4 adding a couple contributuions. My orders show up in MYSQL and if I type in a specific order number on the order page. But like you, they do not show up on the order page, just 0 of 0 orders.

 

I added a tiered pricing contrib and a cvv credit card contrib. I do not have SSL enabled yet. Do you think this might be the problem?

Link to comment
Share on other sites

I had this same problem and I think it was due to a PayPal contribution. I did get it fixed, but now it has happened again and the same fix isn't working.

 

Here is my original fix found at:

 

http://www.oscommerce.com/forums/index.php?sho...ndpost&p=513831

 

Basically had to change orders.php to read ot.class = 'ot_subtotal' instead of ot.class = 'ot_total' in 3 different locations in that file. Worked fine after that.

 

Hope it helps some of you....now, if anyone can help me?

 

Karim

Link to comment
Share on other sites

Hi all.

My paypal module was working fine up to this week.

Now orders are being accepted by paypal and im receiving an e mail notification.

The orders are not showing on the orders list or customer list.

I have no idea what the customer has ordered.

 

I don?t know enough about sql to look in the database.

Has anyone else noticed this error lately and is there a fix.

All and any help greatly appreciated.

 

Colin

Link to comment
Share on other sites

  • 4 weeks later...
I had this same problem and I think it was due to a PayPal contribution. I did get it fixed, but now it has happened again and the same fix isn't working.

 

Here is my original fix found at:

 

http://www.oscommerce.com/forums/index.php?sho...ndpost&p=513831

 

Basically had to change orders.php to read ot.class = 'ot_subtotal' instead of ot.class = 'ot_total' in 3 different locations in that file. Worked fine after that.

 

Hope it helps some of you....now, if anyone can help me?

 

Karim

 

does anyone happen to have the correct link to the fix?

Link to comment
Share on other sites

Hi,

 

I have been struggling with this sessions error for some time now

 

1062 - Duplicate entry '9085c0f986182c4b1d074de86a38f56c' for key 1

 

and have not found an answer in the forums. I am using a viaKLIX gateway and all works well, but at the moment of transaction, the customer will be directed to the viaKLIX gateway and upon return to my shopping cart has been logged out.

 

The problem was that I had no record in my data base about the transaction.

 

The above error with a lot more info will show at the bottom of that login page.

The money transfer proceeds flawless, and the client gets an email from viaKLIX the way I set it up.

 

I found a great work around until this is solved either by me or some one else in these forums.

 

I fond the contribution 'held orders', which works well with the only exception that I still have to go into the MySQL data base and delete the content of the customers basket.

 

http://www.oscommerce.com/community/contri...rch,held+orders

 

 

Hope this will help somebody else, thanks David Howarth and Carine Bruyndoncx.?

 

 

Wolfgang

Link to comment
Share on other sites

This problem is not due to that PayPal contrib. At least, I don't have it installed and I got the same problem. My guess is that is has to do with some MySQL update.

 

When I ask to view all history orders I get none...and I noticed the page showing the NEXT link plus negative pagenumbers...like -5 -4 -3 -2 -1 NEXT>>

 

And indeed, if you ask for a specific id-number...you will get it. The order exists in the database and the emails get send, but, no orders in orders_history or the admin orders panel.

 

 

Hellluuuppp!!! Please!!

Edward Granville

 

"The strongest oak of the forest is not the one that is protected from the storm and hidden from the sun. It's the one that stands in the open where it is compelled to struggle for its existence against the winds and rains and the scorching sun. -Napoleon Hill"

 

Granville webdesign en promotie

Link to comment
Share on other sites

BUG?????

 

I found the solution to my instance of the problem and thought that maybe it could be of help to any of you.

 

The catalog I am developing is intended as a catalog and not a shop. So, the owners didn't want the prices to show up. In the admin>mudules>ordertotal, I turned off SUBTOTAL, TAX & TOTAL. So I just turned it back on and the orders I made since turning is back on are showing up again. The previous orders were contained in the database, but they aren't showing up.

 

This may not be the solution to your instance of the problem. But if you played around in the order totals mudule..you have just gotten lucky B)

 

Get your settings back to default.

Edward Granville

 

"The strongest oak of the forest is not the one that is protected from the storm and hidden from the sun. It's the one that stands in the open where it is compelled to struggle for its existence against the winds and rains and the scorching sun. -Napoleon Hill"

 

Granville webdesign en promotie

Link to comment
Share on other sites

  • 2 weeks later...

I'm getting the same thing with a shop I look after. The orders are in the database, but they do not show up in the customers area, nor the admin, except the customers show up, just not the order. But you look in the database, and the orders are there. Just started yesterday. I tried a couple suggestions from the other posts on this page, nothing helped. Still looking for a solution.

Link to comment
Share on other sites

I'm getting the same thing with a shop I look after. The orders are in the database, but they do not show up in the customers area, nor the admin, except the customers show up, just not the order. But you look in the database, and the orders are there. Just started yesterday. I tried a couple suggestions from the other posts on this page, nothing helped. Still looking for a solution.

 

OK, I reset all the order modules in the admin and removed one pending order from the MySQL and that seemed to correct it, but unfortunately I'm not sure what caused it.

Link to comment
Share on other sites

I had the same problem, copied knifeman's bit and mine was working to. great stuff.

 

 

OK, I reset all the order modules in the admin and removed one pending order from the MySQL and that seemed to correct it, but unfortunately I'm not sure what caused it.

Link to comment
Share on other sites

  • 2 months later...

Mine was caused by the shipping modules not being properly installed (!). I removed and reinstalled all of the shipping options in the admin tool. This fixed the problem for *new* orders.

 

The problem of old orders was solved by deleting the offending entries from *all* of the tables they appear in. Not the best, but it fixed order histories and such.

Link to comment
Share on other sites

Yeah, mine was working untill recently too - and I also use the PayPal module -

 

at least there's a few of us and may be able to get it working...

 

will get back once I try a few of the things as suggested...

Link to comment
Share on other sites

Okay, I just did a couple of tests (through PayPal) on these sites (2 of) that have been having unrecorded orders (all through PayPal) - and all orders I made have turned out okay. I checked the database and the orders that were claimed to not have been recorded are not recorded in the database either (scarey!). The orders ocurred over the last 7 weeks and there have been 7 of them and all were verifiable through Paypal accounts and did actually pay. I am baffeld as I can't recreate the issue... I hope that it is miraculously fixed but wonder why??? It appears there are enough others here to say there is a known issue. Could the issue have ocurred from the PayPal side of things - that would explain it fully - they do lapse sometimes???

 

Any suggestions or comments or further details and dates of your problem orders are most welcome as this scares me a bit...

 

Have a happy day to all!!! :-)

Link to comment
Share on other sites

A Quick important addition, sorry for mutliple posts but it wouldn't let me edit...

 

ADD NOTE: I have two separate sites this issue has occurred on and neither stored the details in the database - that really scares me. Also both sites use totally diferent shipping modules so I don't think that is the issue in my case...

Link to comment
Share on other sites

  • 2 months later...
Okay, I just did a couple of tests (through PayPal)  on these sites (2 of) that have been having unrecorded orders (all through PayPal) - and all orders I made have turned out okay. I checked the database and the orders that were claimed to not have been recorded are not recorded in the database either (scarey!). The orders ocurred over the last 7 weeks and there have been 7 of them and all were verifiable through Paypal accounts and did actually pay. I am baffeld as I can't recreate the issue...  I hope that it is miraculously fixed but wonder why???  It appears there are enough others here to say there is a known issue. Could the issue have ocurred from the PayPal side of things - that would explain it fully - they do lapse sometimes???

 

Any suggestions or comments or further details and dates of your problem orders are most welcome as this scares me a bit...

 

Have a happy day to all!!!  :-)

 

This problem is exactly the same as mine has just started doing in the last week. Again all was working sweet until a week ago. The last 3 orders have processed through paypal, no problem, and the customer account has been registered, but their order has dissappeared into the wireless abyss!!! No record in the sql database either. I have made no changes to code in the last 3 weeks, so I don't think its anything Iv'e done, but it does seem to be related with the decision by the customer when they have paid to either return to merchant or continue in the Paypal screen. Because when i register a ghost account and place an order and then return to merchant it processes correctly every time. Has anybody found a solution to this yet!!!

Link to comment
Share on other sites

Hi. I use Paystation Module in NZ .I have had no problems until a week ago. I have lost three creditcard orders. I can see there money but until they contact me I don't know anything about what they ordered. The goods stay in there shopping cart. I have had some process properly so the problem seems intermittent.

The only recent contributions i have loaded recently are "auto-logon" & "cool-menu".

Any help would be excellant.

Cheer's Col

I will resift through these earlier posts and I might notice something I can fix that isn't too scary.

Many thanks from down under

Link to comment
Share on other sites

Thanks Karim. I am very tempted to try that, but they mention they don't have P&P . I have a flatrate freight module loaded and I have a feeling that it may upset the totals and not charge for freight. Is this correct or do you think i should make the changes and see what happens.

My problem is intermittant. Some creditcard transactions come through and some don't. I just put my card through and it all went well. but another customer did half an hour before me. and no order shows and no order emails were sent.

Bloody annoying.

But nice to know some helpful people about willing tp help us dumbasses

Cheer's Col

Link to comment
Share on other sites

There are a few Contributions which allows you to recover the Shopping Cart of a customer whose order hasn't come through to you.. I suggest you look at those.

 

The first one is here:

 

http://www.oscommerce.com/community/contri...ch,Recover+Cart

 

The second one is here:

 

http://www.oscommerce.com/community/contri...ch,Recover+Cart

 

Vger

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...