Error 500 Edit Customer

[NemesisNG 0]

Hi

Think I posted this in the wrong place first time...

Just starting out with PrestaShop and running 1.7.6.0, have purchased a module to migrate us from OpenCart 3 which has been installed and run.

Now on trying to view a customer to edit that person I'm getting a Error 500 page, but only on customers who have previously placed an order. If it's a customer whos registered and not ordered it will show the page no problem.

I've contacted the dev of the migration module and they have done a test migration of our current OpenCart shop to their server and it's worked fine so said it's our install or hosting which is the issue.

I've turned on debug mode and on clicking a customer to edit I get the following:

Level Channel Message

DEBUG18:23:41doctrineSELECT name FROM ps_module WHERE active = 1

INFO18:23:41requestMatched route "admin_customers_edit".

DEBUG18:23:41securityRead existing security token from the session.

DEBUG18:23:41securityUser was reloaded from a user provider.

INFO18:23:41phpUser Deprecated: Tools::displayPrice() is deprecated since version 1.7.6.0. Use PrestaShop\PrestaShop\Core\Localization\Locale::formatPrice() instead.

INFO18:23:41phpUser Deprecated: Implementing "Symfony\Component\HttpKernel\DataCollector\DataCollectorInterface" without the "reset()" method is deprecated since Symfony 3.4 and will be unsupported in 4.0 for class "Csa\Bundle\GuzzleBundle\DataCollector\GuzzleCollector".

CRITICAL18:23:41phpUncaught Notice: Undefined variable: customerForm

CRITICAL18:23:41requestUncaught PHP Exception Symfony\Component\Debug\Exception\ContextErrorException: "Notice: Undefined variable: customerForm" at /home/ttocco/public_html/prestatest/src/PrestaShopBundle/Controller/Admin/Sell/Customer/CustomerController.php line 203

DEBUG18:23:41phpWarning: highlight_file() has been disabled for security reasons

Any help on this or what to try next please?

Thanks

[NemesisNG 0]

Anyone? Is this software supported?

[JBW 76]

Hi, the error message shows only that something went wrong when creatin/loading  the customer edit form. As the issue seems to be related to your data migration I recommend to contact the developer of the migration module you used.

Edited August 12 by JBW (see edit history)

[NemesisNG 0]

Thanks for replying.

First thing I did was contact the developer of the migration package, they migrated our data to a local test shop of theirs and it seems to work fine, the sent a video to prove it, and said it was my shop setup not working correctly. But it's a brand new install of opencart 1.7.6.0 with no other mods or themes or anything installed or set up. I'm currently ignoring the GDPR issue of all of my shop data being on someone elses server!

Don't know what else to do really, I've got a shop to migrate and setup, I'm £100 down for a migration module which isn't working and no support from them, and don't seem to be getting anywhere.

[JBW 76]

Is the same issue happing if you edit a new customer for which you have placed an order? If not it is somehow related to the migrated data - you can try to compare this data on database to see what might cause the issue.

[NemesisNG 0]

To be fair, I've not tried that. I've not even set up payments or shipping or anything yet as thought it best to get all the data moved over first and then configure.

I'll try and run a test order through and see if I can edit that customer first, if not then it's clearly the migrated data.

Thanks

 

[rachel01 1]

Hi,

 

I've the same problem

Anyone have a solution ?
thanks

[FranckR 1]

Hi,

I had the same problem 

The issue was the column "convertion_rate" in the ps_orders table

I guess in prestashop prior to 1.7.6.0 if you had only one currency the conversion rate wasn't mandatory but now it is and should be > 0.000000

So I updated the column convertion_rate in table ps_orders with '1.000000' by using the following SQL request :

DO A BACKUP OF YOUR DATABASE BEFORE !!! 

AND IF YOUR USING MULTI CURRENCIES ON YOUR SHOP IT MIGHT MESS THINGS UP AND YOU SHOULD MAYBE ONLY UPDATE THE LINES WHERE IT'S 0,000000

UPDATE ps_orders SET conversion_rate = '1.000000'

Hope this can help

Edited September 27 by FranckR
typo (see edit history)

[rachel01 1]

3 minutes ago, FranckR said:

Hi,

I had the same problem 

The issue was the column "convertion_rate" in the ps_orders table

I guess in prestashop prior to 1.7.6.0 if you had only one currency the conversion rate wasn't mandatory but now it is and should be > 0.000000

So I updated the column convertion_rate in table ps_orders with '1.000000' by using the following SQL request :

DO A BACKUP OF YOUR DATABASE BEFORE !!! 

AND IF YOUR USING MULTI CURRENCIES ON YOUR SHOP IT MIGHT MESS THINGS UP AND YOU SHOULD MAYBE ONLY UPDATE THE LINES WHERE IT'S 0,000000

UPDATE ps_orders SET conversion_rate = '1.000000'

Hope this can help

Hi,

Thanks for your answer but I've a problem with the customers, not with the orders.
You had problem with customers too ?

 

[FranckR 1]

Yes the problem was for editing customers : Back office / customers / customers 

the error 500 on some customers ( that had old orders )

I know it doesn't display the orders on the customer form but I think prestashop is requesting them anyway 

 

[rachel01 1]

It's was the solution !

Many thanks for your help !

[NemesisNG 0]

On 9/25/2019 at 8:58 PM, rachel01 said:

Hi,

 

I've the same problem

Anyone have a solution ?
thanks

Are you using the same migration module? Migrating from OpenCart?

I never got this resolved and was fobbed off by the company making the module, basically said it was a problem in my old existing shop and on their test server it was fine.

I've just tried this fix and it most certainly does fix this issue! Can't quite believe it to be honest.

Now, I've also got an issue with missing category and product names after the migration too, the company making the module did actually fix this but didn't tell me what the fix was, so as I'm still in testing and not on a final live shop migration I need to them to either do it again or let me know how to sort it myself. 

Unless anyone else has any bright ideas?

Thanks

[NemesisNG 0]

9 hours ago, FranckR said:

Hi,

I had the same problem 

The issue was the column "convertion_rate" in the ps_orders table

I guess in prestashop prior to 1.7.6.0 if you had only one currency the conversion rate wasn't mandatory but now it is and should be > 0.000000

So I updated the column convertion_rate in table ps_orders with '1.000000' by using the following SQL request :

DO A BACKUP OF YOUR DATABASE BEFORE !!! 

AND IF YOUR USING MULTI CURRENCIES ON YOUR SHOP IT MIGHT MESS THINGS UP AND YOU SHOULD MAYBE ONLY UPDATE THE LINES WHERE IT'S 0,000000

UPDATE ps_orders SET conversion_rate = '1.000000'

Hope this can help

Absolutely amazing, many, many thanks for posting this!

[charlie404 0]

Hello,

I have the same problem.

I have a 500 error on some customers but not on all ...

Example of the url: https://mysite.com/index.php/sell/customers/9999

I really do not know why it works on some clients and not on others.

If someone has an idea.

Thank you

[boutik-fan 1]

Thank you for the help. In my ps_orders table the currency was ok everywhere. But I noticed that a customer has id_currency set to 0 (I have only one currency). So I replaced to 1 and no more error 500 on this customer !

 

[charlie404 0]

Thank you for your answer.

In my ps_orders table, all id_currency values are at 1.

I do not have the id_currency field in my ps_customer table ...

[FranckR 1]

In ps_orders check the value of convertion_rate column not id_currency

[charlie404 0]

In ps_orders table, all conversion_rate values are at 1.000000

[Lukas Truninger 1]

Similar issue here. I did just check database.
- id_currency reads either 1 or 2; no empty record nor value "0" ( I use EUR and USD)
- all conversion rates are either set to 1 or the the real conversion rate (for USD). No empty records.
Nevertheless I endup with error 500 when trying to edit most customers. But it looks like I can edit customers who did NOT place an order yet, and all the customers which I cannot edit already have placed an order. I have this issue also for recently new added customers who did create their account running PS 1.7.6.0 / 1.7.6.1
I also endup with error 500 if I try to set the order state to "payment accepted". Other order states work fine.

May be there is another field which causes this issue?

[ITIS-Commerce.com 11]

Hello

Yes, the solution is to place this SQL order :

UPDATE ps_orders SET conversion_rate = '1.000000'

Don't forget to backup your database before.

Great day!