nexgenappliances

I have the same cart being listed over and over again in my abandoned carts list. It's been going on for a week. Has anyone else seen this behavior?

at line 635 in file classes/db/Db.php 629. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 630. } 631. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 632. { 633. if ($sql) 634. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 635. throw new PrestaShopDatabaseException($this->getMsgError()); 636. } 637. } 638. 639. /** DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments]319. if ($sql instanceof DbQuery) 320. $sql = $sql->build(); 321. 322. $this->result = $this->_query($sql); 323. if (_PS_DEBUG_SQL_) 324. $this->displayError($sql); 325. return $this->result; 326. } 327. 328. /** 329. * Execute an INSERT query DbCore->query - [line 501 - classes/db/Db.php] - [1 Arguments]495. { 496. $this->last_cached = true; 497. return $result; 498. } 499. 500. $this->result = $this->query($sql); 501. 502. if (!$this->result) 503. $result = false; 504. else 505. { DbCore->executeS - [line 1717 - classes/module/Module.php] - [2 Arguments]1711. { 1712. $exceptionsCache = array(); 1713. $sql = 'SELECT * FROM `'._DB_PREFIX_.'hook_module_exceptions` 1714. WHERE `id_shop` IN ('.implode(', ', Shop::getContextListShopID()).')'; 1715. $db = Db::getInstance(); 1716. $result = $db->executeS($sql, false); 1717. while ($row = $db->nextRow($result)) 1718. { 1719. if (!$row['file_name']) 1720. continue; 1721. $key = $row['id_hook'].'-'.$row['id_module']; ModuleCore->getExceptions - [line 469 - classes/Hook.php] - [1 Arguments]463. continue; 464. 465. // Check permissions 466. if ($check_exceptions) 467. { 468. $exceptions = $moduleInstance->getExceptions($array['id_hook']); 469. 470. $controller = Dispatcher::getInstance()->getController(); 471. $controller_obj = Context::getContext()->controller; 472. 473. //check if current controller is a module controller HookCore::exec - [line 2278 - classes/controller/AdminController.php] - [2 Arguments]2272. 'host_mode' => defined('_PS_HOST_MODE_') ? 1 : 0, 2273. 'stock_management' => (int)Configuration::get('PS_STOCK_MANAGEMENT') 2274. )); 2275. 2276. if ($this->display_header) 2277. $this->context->smarty->assign('displayBackOfficeHeader', Hook::exec('displayBackOfficeHeader', array())); 2278. 2279. $this->context->smarty->assign(array( 2280. 'displayBackOfficeTop' => Hook::exec('displayBackOfficeTop', array()), 2281. 'submit_form_ajax' => (int)Tools::getValue('submitFormAjax') 2282. )); AdminControllerCore->init - [line 163 - classes/controller/Controller.php]157. /** 158. * Start controller process (this method shouldn't be overriden !) 159. */ 160. public function run() 161. { 162. $this->init(); 163. if ($this->checkAccess()) 164. { 165. // setMedia MUST be called before postProcess 166. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) 167. $this->setMedia(); ControllerCore->run - [line 373 - classes/Dispatcher.php]367. // Execute hook dispatcher 368. if (isset($params_hook_action_dispatcher)) 369. Hook::exec('actionDispatcher', $params_hook_action_dispatcher); 370. 371. // Running controller 372. $controller->run(); 373. } 374. catch (PrestaShopException $e) 375. { 376. $e->displayMessage(); 377. } DispatcherCore->dispatch - [line 54 - admin/index.php]48. $_POST['controller'] = strtolower($_POST['tab']); 49. if (!isset($_REQUEST['controller']) && isset($_REQUEST['tab'])) 50. $_REQUEST['controller'] = strtolower($_REQUEST['tab']); 51. 52. // Prepare and trigger admin dispatcher 53. Dispatcher::getInstance()->dispatch();

So after learning that the connect to fedex module does not support international shipping, I have uninstalled it, and installed the Fedex module from presto chango. After configuring the fedex module, no new carriers were created. So no fedex carriers are available in shipping. When I click the "add carrier" button in carriers, it generates an error page as follows: [PrestaShopDatabaseException]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 2 SELECT * FROM `ps16_hook_module_exceptions` WHERE `id_shop` IN () at line 635 in file classes/db/Db.php 629. WebserviceRequest::getInstance()->setError(500, ' '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 630. } 631. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 632. { 633. if ($sql) 634. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 635. throw new PrestaShopDatabaseException($this->getMsgError()); 636. } 637. } 638. 639. /** DbCore->displayError - [line 325 - classes/db/Db.php] - [1 Arguments] DbCore->query - [line 501 - classes/db/Db.php] - [1 Arguments] DbCore->executeS - [line 1717 - classes/module/Module.php] - [2 Arguments] ModuleCore->getExceptions - [line 469 - classes/Hook.php] - [1 Arguments] HookCore::exec - [line 2278 - classes/controller/AdminController.php] - [2 Arguments] AdminControllerCore->init - [line 163 - classes/controller/Controller.php] ControllerCore->run - [line 373 - classes/Dispatcher.php] DispatcherCore->dispatch - [line 54 - admin/index.php]

emailed you

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

nevermind I figured it out.

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

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?

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

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.

dramatic improvement! Thanks El Patron

Perfect, thanks!

Crushed it! Thank you so much for your help!!!

That's generally not helpful at all. The product features are generally worthless. They are ugly, you can't edit the layout, and for some stupid reason they are positioned on top of the freaking product description. If you have products that have a ton of features, and you want to make any use of filtered navigation or search, you have to define features. Being able to hide these features from the product page but still make use of filtered nav would be great.

I have no idea why features belong above the product description, but I would like to move them to below the product description where they belong. Any help would be appreciated.