Orders without status and/or products.

[Jeet Kune Do 2]

Hello,

some customers orders are ok, but unfortunately some orders doesn’t have assigned any status and the list of products is less than the total amount or there are even no products. For example the order have one product which cost 3,99 € but the order total is 46,99 €. When I take a look at the customer last cart I can find 5 products with a total of 46,99 €. The order clearly left out the other 4 products. Sometimes the order has no status and when I opened it, I cannot find any products but only the order total and shipping.

Have a fresh install of Prestashop which is version 1.6.0.8

 

Server information: Linux #1 SMP Thu Jul 10 04:59:56 CDT 2014 x86_64

Server software version: Apache

PHP version: 5.4.29

Memory limit: 256M

Max execution time: 30

 

MySQL version: 5.5.37-35.1

MySQL engine: InnoDB

Tables prefix: ps_

 

Current theme in use: default-bootstrap

Required parameters: OK

Optional parameters: OK

[Jeet Kune Do 2]

I tryed to make the same order on localhost in FO as my customer and I get the following error when I want to confirm my order:

 

500 Server Error

Oops, something went wrong.

Try to refresh this page or feel free to contact us if the problem persists.

[Jeet Kune Do 2]

For sure the problem reacuring with some product only. I tryed to change the product information and re-order the same product over and over again. I find that the field EAN-13 or JAN barcode is triggering the problem. The EAN is like this 00700078 / 05.

 

How can I work around this problem?

I need the EAN field for supplier code, how can I turn off error checking or something like this?

[fernavrod 0]

Hi, did you find a solution?

I have same problem but I do not use EAN codes at all.

Cheers

[jopabe 3]

anyone? No hints? I have the same problem.

[Nabbolo 5]

Same problem here on PS 1.6.0.6. Orders paid with Paypal get a status "---" (not assigned) and in the order details I cannot see any product, I have to check manually from the last chart of the customer to guess what's the product.

With bank transfer the status is set correctly but still no product in order details.

 

I didn't change anything and everything used to work fine before the Paypal problem you all know about. Then the orders disappeared, Paypal "solved" its problem and now I have this new problem :-(

[magali ferber 79]

Hi all,

 

I had this issue checked by our developers and they said it can come from a variety of different things, such as shipping provider, payment solution, etc..

 

The best thing to do is for each of you to check on your Back Office on the tab "Advanced Parameters" and then "Logs". Errors should appear there.

 

As for the PayPal issue, that could be the cause of your problem, but then again, it is PayPal who can fix it. You can try contacting their support to see what is going on.

 

All the best,

 

Maggie

[fernavrod 0]

Hi Magali,

 

thanks for taking care. Just addition 5 cents:

 

Paying option should not be the reason, as I have tested Credit Car, Cheque, bank transfer and paypal and they all do the same:

presta send the money to your accoung (no complain), but the customer gets blocked after payment confirmation or even blank page (cheque).

 

I will cheque the shipping provider...

 

Additional clue: I have restored a backup form Oct 10th, and it work much better 90%.

• I mean, orders have products and money appears in Back office
• order has state: OK
• the money arrives to seller account
• confirmation mails arrive to seller and customer
• BUT after the confirmation page (paying with credit card) the page gets block and buttons do no do anything

 

I'm considering "backing" up my DB (1), restore oct-10th back, upload my BD (2) in my old (oct-10) presta and keep on alive until the next crash. do you think it can work?

 

Any way I wish we can find a real solution, as we are not alone

[Nabbolo 5]

Hi Magali, and thanks for your support, unfortunately it's a very annoying problem

 

I have checked on "Advanced parameters -> Logs" and in correspondance of two Paypal orders I get:

Il carrello non può essere caricato o un ordine è già stato creato con questo carrello Cart 8769 0x 1

Which in english means

The cart cannot be loaded or an order has already been created with this cart Cart 8769 0x 1

 

I do have the same problem with Bank Transfer as well (not only with Paypal, even if the problem started with the Paypal bug), but in this case I have no line corresponding in the log.

[jopabe 3]

Hey guys!

 

I also had this problem, and I went to the Portuguese forum for help. 

 

A guy told me to uninstall the module Wishlist , and install it again... and i worked!! Now my store is acting as it should.

 

I can't understand why, but it does. Try it!

 

Best of luck!

[Nabbolo 5]

Hey guys!

 

I also had this problem, and I went to the Portuguese forum for help. 

 

A guy told me to uninstall the module Wishlist , and install it again... and i worked!! Now my store is acting as it should.

 

I can't understand why, but it does. Try it!

 

Best of luck!

Thank you very much for your contribution

I had that module uninstalled, now I install it and I will tell tomorrow if the new orders are fixed.

[fernavrod 0]

Hey guys!

 

I also had this problem, and I went to the Portuguese forum for help. 

 

A guy told me to uninstall the module Wishlist , and install it again... and i worked!! Now my store is acting as it should.

 

I can't understand why, but it does. Try it!

 

Best of luck!

 

Bad news from myside.

I have deleted blockwishlist

I have installed from a fresh source

But same error

 

I have disabled it, but same error

 

I have update it to 1.1.5, but same error

 

I have deleted it, but same error

 

Jopape, could you please post your prestashop version and you blockwishlit version?

 

Thanks

[Nabbolo 5]

I'm not sure but I think that I had uninstalled that module some weeks ago, because I noticed that I have never used it, but I'm sure that the problem started after the Paypal bug (13-16 oct).

 

Now I have installed the module and updated it since it was out of date, let's see tomorrow (I have few orders a day)

[jopabe 3]

Ola fernavrod,

 

Both the latest versions, 1.6.0.9 and 1.1.5

[Nabbolo 5]

Problem not fixed by reinstalling the Wishlist module even tough I think that this module could be related in some way.

[magali ferber 79]

Hi all,

 

Our development team is doing some tests right now, to try to find the reason why you are all having this issue. I will come back to you once I get an update from them.

 

I'll keep you all posted as soon as I get any news.

 

Maggie

[magali ferber 79]

Hello Everyone,

 

Apparently most issues come from the Ebay Module.. So for those of you who are still looking for a solution, try deactivating the Ebay Module and see if everything goes back to normal.

 

Both of these cases were solved by disabling the Ebay Module. 

http://forge.prestashop.com/browse/PNM-2807

http://forge.prestashop.com/browse/PNM-2806

 

Just so you know, anything related to Ebay or PayPal issues can be sent for support to:  support@202-ecommerce.com

 

Hope this helped! 

 

All the best

 

Maggie

[fernavrod 0]

Thanks also here Magali,

 

I unistalled Ebay module, and every this works well again!!!

[Nabbolo 5]

Hello Everyone,

 

Apparently most issues come from the Ebay Module.. So for those of you who are still looking for a solution, try deactivating the Ebay Module and see if everything goes back to normal.

 

Both of these cases were solved by disabling the Ebay Module. 

http://forge.prestashop.com/browse/PNM-2807

http://forge.prestashop.com/browse/PNM-2806

 

Just so you know, anything related to Ebay or PayPal issues can be sent for support to:  support@202-ecommerce.com

 

Hope this helped! 

 

All the best

 

Maggie

Thank you very much Maggie for your support, you have been very helpful

 

I have now disabled my eBay module (since I'm not selling for a month on eBay) and I will tell if this will solve the problem.

By the way, can you confirm that this problem occurs only when eBay module is installed and there is no eBay account syncronized? Next week I will have to sync eBay again and I hope that with an account into the module, everything will work again.

 

EDIT: I confirm, the problem was eBay module. Very soon I will need to use it and I will tell if the problem disappears with module activated and configured.

Edited October 26, 2014 by Nabbolo (see edit history)

[jopabe 3]

Definitely a problem with the payment modules!

 

Mine was working fine, at last (!) but I had to install the Cash-on-delivery for a customer, and there was the problem, again!!

 

I got this error message: 

Notice na linha 361 do ficheiro /home/pintalo1/public_html/cache/smarty/compile/90/c2/ce/90c2cedff189c1b4ae55c086e5eacacc04e1b22c.file.view.tpl.php

[8] Trying to get property of non-object

 

 I don't have Paypal nor Ebay modules installed.

[magali ferber 79]

Hi Everyone,

 

The agency in charge of the Ebay module has fixed the issue.

 

Cheers!

 

Maggie

[bethoven 0]

In my opinion problem isn't related with the ebay module and wish list. I use Prestashop 1.5.5.0., I haven't installed ebay module and wish list. ‏I read thread and problem exist in different versions and configurations.
In my opinion probem exist in module which is default installed for everyone (for example in statsdata) or Web Hosting - I use 1and1.co.uk‏‏

[magali ferber 79]

Well, now that the Ebay module is working properly, if you still have these issues, I can advice you to create a ticket in the Forge and our developers will take a look at what is going on...

 

Here is the link to the Forge: http://forge.prestashop.com/

 

Hope you get to solve it.

 

Cheers!

[pureorganic 0]

Jpabe: If you find a sollution, please post it. I got the same problem with no Ebay module ect. Its like I have have updated some standard module between the 10th and 21th and something have broken.

 

I use version 1.6.9 with Quickpay module.

 

[sOLUTION FOUND] - It was an error in the translation of the email confirmation mail, that caused the server 500 error in the validation call from my payment gateway. Because of this no mails was send and the order status was not updated... I simply just deleted the whole directrory in the email dir of my theme. 

 

 

/Thomas 

Edited October 30, 2014 by pureorganic (see edit history)

[sitamet 0]

Hi,

 

is this problem solved?

- I'm on Prestashop 1.6.0.11

- no eBay module

- PayPal, Stripe, and wire transfer: in our case random problems with all.

- no registered log errors.

 

joan

[Pete78 42]

Hi, had this problem as well. In the end it was a missing column in ps_orders_detail table:

 

Please check, if you have an id_tax_rules_group column, if not, this statement can create it.

 

This is valid for a PS 1.6.014 store...no guarantee that this helps of course.

 

 

 

ALTER TABLE `ps_order_detail` ADD `id_tax_rules_group` INT NOT NULL AFTER `tax_computation_method`;

 

 

 

Cheers,

Peter

[BobPour 2]

Hi Pete,

Thanks for suggestion

I do have the id_tax_rules_group column but iu might be missing some other table?? (i hope at least...)

I have total of 44 tables in ps_order)detail; is that sound bout right?

And the id_tax_rules_group is unsigned and Default value is set to 0?

 

 

[sitte 8]

I had the same problem, mine was about "<br/>" tag in title in some products because they was imported via integration program.

 

Errors not always show in shop admin interface (advenced>log). If problem occurs You can sometimes find details in file on server:

/log/201XXXXX_exception.log 

[amimoto_eu 0]

Hi.

I am using PS 1.1.1.12 in a live shop and still have this issue! I tried all solutions I could find here, but none applies or helps.

As we have real orders from real customers it is getting us into trouble. Some orders go through without a problem.

Others have no status, no products and no confirmation email is sent. This happened with either bankwire or paypal payment selected.

In the backend log I find errors  "Frontcontroller::init - Cart cannot be loaded or an order has already been placed using this cart"

I tried to find solutions for this one, too, but without success.

What else can I do??