Prestashop 1.6 data import gone horribly wrong

[nexgenappliances]

We have a 1.5 prestashop but have been developing a 1.6 store for the last two months. We're finally ready to launch, so the last step was to import customers and orders from the old store using cart2cart. So after putting down some cash on the import, I woke up this morning to an email saying the import was successful.

 

Upon logging into my management console, I find this message:

 

You are currently connected under the following domain name: devstore.nexgenappliances.com
This is different from the domain name set in the "SEO & URLs" tab. If this is your main domain, please change it now.

 

Clicking on the "change it now" link leads me to a page that says:

[PrestaShopException]

get list params is not valid
at line 2609 in file classes/controller/AdminController.php

2603.
2604.         /* Check params validity */
2605.         if (!Validate::isOrderBy($order_by) || !Validate::isOrderWay($order_way)
2606.             || !is_numeric($start) || !is_numeric($limit)
2607.             || !Validate::isUnsignedId($id_lang))
2608.             throw new PrestaShopException('get list params is not valid');
2609.
2610.         if (!isset($this->fields_list[$order_by]['order_key']) && isset($this->fields_list[$order_by]['filter_key']))
2611.             $this->fields_list[$order_by]['order_key'] = $this->fields_list[$order_by]['filter_key'];
2612.
2613.         if (isset($this->fields_list[$order_by]) && isset($this->fields_list[$order_by]['order_key']))

• AdminControllerCore->getList - [line 497 - controllers/admin/AdminMetaController.php] - [6 Arguments]
• AdminMetaControllerCore->getList - [line 1936 - classes/controller/AdminController.php] - [1 Arguments]
• AdminControllerCore->renderList - [line 505 - controllers/admin/AdminMetaController.php]
• AdminMetaControllerCore->renderList - [line 1759 - classes/controller/AdminController.php]
• AdminControllerCore->initContent - [line 180 - classes/controller/Controller.php]
• ControllerCore->run - [line 373 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 54 - admin/index.php]

http://devstore.nexgenappliances.com now resolves to a 500 error.

So the site I worked on for over 2 months is now dead. I looked in the PS_shop_url table in the database, which has no values. In the 1.5 database there are URL values in there. 

The throw new PrestaShopException('get list params is not valid'); 

seems to suggest the || !Validate::isUnsignedId($id_lang)) may be invalid. The old store does have languages where as the new store only has english. So would the orders that were imported with id_lang=1 in the ps_orders table cause this error? Should that value be 0? Anyone with any suggestions would be appreciated. The cart2cart people are "working on it" but I am not happy sitting around waiting for them to figure out what got screwed up.

 

 

[nexgenappliances]

Just found this log under /log/exceptionlog_mmddyy.log

 

*ERROR* 2014/06/04 - 05:31:36: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 06:20:01: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 07:35:43: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 11:30:05: get list params is not valid at line 2609 in file classes/controller/AdminController.php

*ERROR* 2014/06/04 - 08:30:05: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 11:30:23: get list params is not valid at line 2609 in file classes/controller/AdminController.php

*ERROR* 2014/06/04 - 11:31:41: get list params is not valid at line 2609 in file classes/controller/AdminController.php

*ERROR* 2014/06/04 - 11:31:49: get list params is not valid at line 2609 in file classes/controller/AdminController.php

*ERROR* 2014/06/04 - 11:33:30: get list params is not valid at line 2609 in file classes/controller/AdminController.php

*ERROR* 2014/06/04 - 11:33:59: get list params is not valid at line 2609 in file classes/controller/AdminController.php

*ERROR* 2014/06/04 - 11:34:13: get list params is not valid at line 2609 in file classes/controller/AdminController.php

*ERROR* 2014/06/04 - 08:51:31: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 08:51:59: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 12:01:04: get list params is not valid at line 2609 in file classes/controller/AdminController.php

*ERROR* 2014/06/04 - 12:08:03: get list params is not valid at line 2609 in file classes/controller/AdminController.php

*ERROR* 2014/06/04 - 12:10:01: get list params is not valid at line 2609 in file classes/controller/AdminController.php

*ERROR* 2014/06/04 - 09:11:28: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 12:24:33: get list params is not valid at line 2609 in file classes/controller/AdminController.php

*ERROR* 2014/06/04 - 09:24:44: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 09:24:46: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 09:24:47: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 09:24:47: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 09:24:48: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 09:24:48: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 09:24:48: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 09:24:49: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 09:24:50: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 09:24:50: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 12:25:54: get list params is not valid at line 2609 in file classes/controller/AdminController.php

*ERROR* 2014/06/04 - 12:26:25: get list params is not valid at line 2609 in file classes/controller/AdminController.php

*ERROR* 2014/06/04 - 12:26:35: get list params is not valid at line 2609 in file classes/controller/AdminController.php

*ERROR* 2014/06/04 - 09:27:04: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 09:27:06: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 09:27:09: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 09:27:11: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 09:27:12: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 12:45:57: get list params is not valid at line 2609 in file classes/controller/AdminController.php

*ERROR* 2014/06/04 - 09:45:57: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 10:07:18: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 10:49:22: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 10:49:23: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 11:23:05: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 11:42:18: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 12:38:53: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 13:54:40: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 15:10:27: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 15:55:23: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 18:55:48: get list params is not valid at line 2609 in file classes/controller/AdminController.php

*ERROR* 2014/06/04 - 18:56:39: get list params is not valid at line 2609 in file classes/controller/AdminController.php

*ERROR* 2014/06/04 - 19:06:03: get list params is not valid at line 2609 in file classes/controller/AdminController.php

*ERROR* 2014/06/04 - 16:19:02: Shop not found at line 396 in file classes/shop/Shop.php

*ERROR* 2014/06/04 - 16:25:05: Shop not found at line 396 in file classes/shop/Shop.php

[nexgenappliances]

Ok I was able to reinstall the USA language pack and the backend came back to life. Still getting the 

You are currently connected under the following domain name: devstore.nexgenappliances.com
This is different from the domain name set in the "SEO & URLs" tab. If this is your main domain, please change it now. error. 

 

I can now get to SEO and URL's part of the backend however the "Set shop URL" field is missing. Not there. Gone. No way to set the URL. So now what?

[Dh42]

I would set it manually in the database for the time being, that should get you up and running. This is what the data looks like for a shop on the domain neat42.com http://screencast.com/t/1JO1aC8yzMb  

[nexgenappliances]

How would I set that in phpmyadmin? I'm not too good with sql

[nexgenappliances]

nevermind I figured it out.

[Dh42]

Did it seem to fix the issue?

[nexgenappliances]

Still have a 500 error and its still displaying the warning in the back end about the url being wrong.

[Dh42]

If you want to send me access to it at [email protected] I can look into it. 

[nexgenappliances]

emailed you