Jump to content

Karmahacker

Members
  • Posts

    8
  • Joined

  • Last visited

Profile Information

  • Location
    Bangkok
  • Activity
    Project Owner

Karmahacker's Achievements

Newbie

Newbie (1/14)

0

Reputation

  1. good day ! after update to 1.5.3.1 got an issue when i try create new product anyone have an idea obout tthat case? Thank You! [PrestaShopDatabaseException] Unknown column 'redirect_type' in 'field list'INSERT INTO `ps_product` (`id_shop_default`, `id_manufacturer`, `id_supplier`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `quantity_discount`, `ean13`, `upc`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `id_category_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ecotax`, `minimal_quantity`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `customizable`, `text_fields`, `uploadable_files`, `active`, `redirect_type`, `id_product_redirected`, `available_for_order`, `available_date`, `condition`, `show_price`, `indexed`, `visibility`, `cache_default_attribute`, `advanced_stock_management`, `date_add`, `date_upd`) VALUES ('1', '0', '0', '', '', '', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '2', '1', '0', '0', '0', '1', '0', '0', '', '0', '0', '0', '0', '0', '1', '404', '0', '1', '0000-00-00', 'new', '1', '0', 'both', '0', '0', '2013-01-30 21:28:52', '2013-01-30 21:28:52') at line 605 in file classes/db/Db.php 599. WebserviceRequest::getInstance()->setError(500, '[sql Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 600. } 601. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 602. { 603. if ($sql) 604. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 605. throw new PrestaShopDatabaseException($this->getMsgError()); 606. } 607. } 608. 609. /** 342. // Execute hook dispatcher 343. if (isset($params_hook_action_dispatcher)) 344. Hook::exec('actionDispatcher', $params_hook_action_dispatcher); 345. 346. // Running controller 347. $controller->run(); 348. } 349. catch (PrestaShopException $e) 350. { 351. $e->displayMessage(); 352. } DbCore->displayError - [line 307 - classes/db/Db.php] - [1 Arguments] 301. if ($sql instanceof DbQuery) 302. $sql = $sql->build(); 303. 304. $this->result = $this->_query($sql); 305. if (_PS_DEBUG_SQL_) 306. $this->displayError($sql); 307. return $this->result; 308. } 309. 310. /** 311. * Execute an INSERT query DbCore->query - [line 581 - classes/db/Db.php] - [1 Arguments] 575. { 576. if ($sql instanceof DbQuery) 577. $sql = $sql->build(); 578. 579. $this->result = false; 580. $result = $this->query($sql); 581. if ($use_cache && $this->is_cache_enabled) 582. Cache::getInstance()->deleteQuery($sql); 583. return $result; 584. } 585. DbCore->q - [line 372 - classes/db/Db.php] - [2 Arguments] 366. $keys_stringified = implode(', ', $keys); 367. $values_stringified[] = '('.implode(', ', $values).')'; 368. } 369. 370. $sql = $insert_keyword.' INTO `'.$table.'` ('.$keys_stringified.') VALUES '.implode(', ', $values_stringified); 371. return (bool)$this->q($sql, $use_cache); 372. } 373. 374. /** 375. * @param string $table Table name without prefix 376. * @param array $data Data to insert as associative array. If $data is a list of arrays, multiple insert will be done DbCore->insert - [line 464 - classes/ObjectModel.php] - [3 Arguments] 458. // Database insertion 459. if (isset($this->id) && !Tools::getValue('forceIDs')) 460. unset($this->id); 461. if (Shop::checkIdShopDefault($this->def['table'])) 462. $this->id_shop_default = min($id_shop_list); 463. if (!$result = ObjectModel::$db->insert($this->def['table'], $this->getFields(), $null_values)) 464. return false; 465. 466. // Get object id in database 467. $this->id = ObjectModel::$db->Insert_ID(); 468. ObjectModelCore->add - [line 477 - classes/Product.php] - [2 Arguments] 471. return $fields; 472. } 473. 474. public function add($autodate = true, $null_values = false) 475. { 476. if (!parent::add($autodate, $null_values)) 477. return false; 478. 479. if ($this->getType() == Product::PTYPE_VIRTUAL) 480. StockAvailable::setProductOutOfStock((int)$this->id, 1); 481. else ProductCore->add - [line 1584 - controllers/admin/AdminProductsController.php] - [0 Argument] 1578. 1579. $this->object = new $this->className(); 1580. $this->_removeTaxFromEcotax(); 1581. $this->copyFromPost($this->object, $this->table); 1582. 1583. if ($this->object->add()) 1584. { 1585. $this->addCarriers(); 1586. $this->updateAccessories($this->object); 1587. $this->updatePackItems($this->object); 1588. $this->updateDownloadProduct($this->object); AdminProductsControllerCore->processAdd - [line 629 - classes/controller/AdminController.php] - [0 Argument] 623. { 624. $this->object = $this->loadObject(); 625. return $this->processUpdate(); 626. } 627. else 628. return $this->processAdd(); 629. } 630. 631. /** 632. * Object creation 633. */ AdminControllerCore->processSave - [line 541 - classes/controller/AdminController.php] - [0 Argument] 535. { 536. // Hook before action 537. Hook::exec('actionAdmin'.ucfirst($this->action).'Before', array('controller' => $this)); 538. Hook::exec('action'.get_class($this).ucfirst($this->action).'Before', array('controller' => $this)); 539. // Call process 540. $return = $this->{'process'.Tools::toCamelCase($this->action)}(); 541. // Hook After Action 542. Hook::exec('actionAdmin'.ucfirst($this->action).'After', array('controller' => $this, 'return' => $return)); 543. Hook::exec('action'.get_class($this).ucfirst($this->action).'After', array('controller' => $this, 'return' => $return)); 544. 545. return $return; AdminControllerCore->postProcess - [line 1171 - controllers/admin/AdminProductsController.php] - [0 Argument] 1165. * @return void 1166. */ 1167. public function postProcess() 1168. { 1169. if (!$this->redirect_after) 1170. parent::postProcess(); 1171. 1172. if ($this->display == 'edit' || $this->display == 'add') 1173. { 1174. $this->addjQueryPlugin(array( 1175. 'autocomplete', AdminProductsControllerCore->postProcess - [line 158 - classes/controller/Controller.php] - [0 Argument] [*] [size=3]152. // setMedia MUST be called before postProcess 153. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) 154. $this->setMedia(); 155. 156. // postProcess handles ajaxProcess 157. $this->postProcess(); 158. 159. if (!empty($this->redirect_after)) 160. $this->redirect(); 161. 162. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) [/size] [*] ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument] DispatcherCore->dispatch - [line 50 - [email protected]/index.php] - [0 Argument] 44. $_POST['controller'] = strtolower($_POST['tab']); 45. if (!isset($_REQUEST['controller']) && isset($_REQUEST['tab'])) 46. $_REQUEST['controller'] = strtolower($_REQUEST['tab']); 47. 48. // Prepare and trigger admin dispatcher 49. Dispatcher::getInstance()->dispatch();
  2. Доброго времени суток! Обновился до 1.5.3.1 при попытке создать новый продукт выдает следующую ошибуку что делать незнаю кто встречал подобное и с чем это может быть связано ? Спасибо! PrestaShopDatabaseException] Unknown column 'redirect_type' in 'field list'INSERT INTO `ps_product` (`id_shop_default`, `id_manufacturer`, `id_supplier`, `reference`, `supplier_reference`, `location`, `width`, `height`, `depth`, `weight`, `quantity_discount`, `ean13`, `upc`, `cache_is_pack`, `cache_has_attachments`, `is_virtual`, `id_category_default`, `id_tax_rules_group`, `on_sale`, `online_only`, `ecotax`, `minimal_quantity`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `customizable`, `text_fields`, `uploadable_files`, `active`, `redirect_type`, `id_product_redirected`, `available_for_order`, `available_date`, `condition`, `show_price`, `indexed`, `visibility`, `cache_default_attribute`, `advanced_stock_management`, `date_add`, `date_upd`) VALUES ('1', '0', '0', '', '', '', '0', '0', '0', '0', '0', '', '', '0', '0', '0', '2', '1', '0', '0', '0', '1', '0', '0', '', '0', '0', '0', '0', '0', '1', '404', '0', '1', '0000-00-00', 'new', '1', '0', 'both', '0', '0', '2013-01-30 21:28:52', '2013-01-30 21:28:52') at line 605 in file classes/db/Db.php 599. WebserviceRequest::getInstance()->setError(500, '[sql Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97); 600. } 601. else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS')) 602. { 603. if ($sql) 604. throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>'); 605. throw new PrestaShopDatabaseException($this->getMsgError()); 606. } 607. } 608. 609. /** 342. // Execute hook dispatcher 343. if (isset($params_hook_action_dispatcher)) 344. Hook::exec('actionDispatcher', $params_hook_action_dispatcher); 345. 346. // Running controller 347. $controller->run(); 348. } 349. catch (PrestaShopException $e) 350. { 351. $e->displayMessage(); 352. } DbCore->displayError - [line 307 - classes/db/Db.php] - [1 Arguments] 301. if ($sql instanceof DbQuery) 302. $sql = $sql->build(); 303. 304. $this->result = $this->_query($sql); 305. if (_PS_DEBUG_SQL_) 306. $this->displayError($sql); 307. return $this->result; 308. } 309. 310. /** 311. * Execute an INSERT query DbCore->query - [line 581 - classes/db/Db.php] - [1 Arguments] 575. { 576. if ($sql instanceof DbQuery) 577. $sql = $sql->build(); 578. 579. $this->result = false; 580. $result = $this->query($sql); 581. if ($use_cache && $this->is_cache_enabled) 582. Cache::getInstance()->deleteQuery($sql); 583. return $result; 584. } 585. DbCore->q - [line 372 - classes/db/Db.php] - [2 Arguments] 366. $keys_stringified = implode(', ', $keys); 367. $values_stringified[] = '('.implode(', ', $values).')'; 368. } 369. 370. $sql = $insert_keyword.' INTO `'.$table.'` ('.$keys_stringified.') VALUES '.implode(', ', $values_stringified); 371. return (bool)$this->q($sql, $use_cache); 372. } 373. 374. /** 375. * @param string $table Table name without prefix 376. * @param array $data Data to insert as associative array. If $data is a list of arrays, multiple insert will be done DbCore->insert - [line 464 - classes/ObjectModel.php] - [3 Arguments] 458. // Database insertion 459. if (isset($this->id) && !Tools::getValue('forceIDs')) 460. unset($this->id); 461. if (Shop::checkIdShopDefault($this->def['table'])) 462. $this->id_shop_default = min($id_shop_list); 463. if (!$result = ObjectModel::$db->insert($this->def['table'], $this->getFields(), $null_values)) 464. return false; 465. 466. // Get object id in database 467. $this->id = ObjectModel::$db->Insert_ID(); 468. ObjectModelCore->add - [line 477 - classes/Product.php] - [2 Arguments] 471. return $fields; 472. } 473. 474. public function add($autodate = true, $null_values = false) 475. { 476. if (!parent::add($autodate, $null_values)) 477. return false; 478. 479. if ($this->getType() == Product::PTYPE_VIRTUAL) 480. StockAvailable::setProductOutOfStock((int)$this->id, 1); 481. else ProductCore->add - [line 1584 - controllers/admin/AdminProductsController.php] - [0 Argument] 1578. 1579. $this->object = new $this->className(); 1580. $this->_removeTaxFromEcotax(); 1581. $this->copyFromPost($this->object, $this->table); 1582. 1583. if ($this->object->add()) 1584. { 1585. $this->addCarriers(); 1586. $this->updateAccessories($this->object); 1587. $this->updatePackItems($this->object); 1588. $this->updateDownloadProduct($this->object); AdminProductsControllerCore->processAdd - [line 629 - classes/controller/AdminController.php] - [0 Argument] 623. { 624. $this->object = $this->loadObject(); 625. return $this->processUpdate(); 626. } 627. else 628. return $this->processAdd(); 629. } 630. 631. /** 632. * Object creation 633. */ AdminControllerCore->processSave - [line 541 - classes/controller/AdminController.php] - [0 Argument] 535. { 536. // Hook before action 537. Hook::exec('actionAdmin'.ucfirst($this->action).'Before', array('controller' => $this)); 538. Hook::exec('action'.get_class($this).ucfirst($this->action).'Before', array('controller' => $this)); 539. // Call process 540. $return = $this->{'process'.Tools::toCamelCase($this->action)}(); 541. // Hook After Action 542. Hook::exec('actionAdmin'.ucfirst($this->action).'After', array('controller' => $this, 'return' => $return)); 543. Hook::exec('action'.get_class($this).ucfirst($this->action).'After', array('controller' => $this, 'return' => $return)); 544. 545. return $return; AdminControllerCore->postProcess - [line 1171 - controllers/admin/AdminProductsController.php] - [0 Argument] 1165. * @return void 1166. */ 1167. public function postProcess() 1168. { 1169. if (!$this->redirect_after) 1170. parent::postProcess(); 1171. 1172. if ($this->display == 'edit' || $this->display == 'add') 1173. { 1174. $this->addjQueryPlugin(array( 1175. 'autocomplete', AdminProductsControllerCore->postProcess - [line 158 - classes/controller/Controller.php] - [0 Argument] [*] [size=3]152. // setMedia MUST be called before postProcess 153. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) 154. $this->setMedia(); 155. 156. // postProcess handles ajaxProcess 157. $this->postProcess(); 158. 159. if (!empty($this->redirect_after)) 160. $this->redirect(); 161. 162. if (!$this->content_only && ($this->display_header || (isset($this->className) && $this->className))) [/size] [*] ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument] DispatcherCore->dispatch - [line 50 - [email protected]/index.php] - [0 Argument] 44. $_POST['controller'] = strtolower($_POST['tab']); 45. if (!isset($_REQUEST['controller']) && isset($_REQUEST['tab'])) 46. $_REQUEST['controller'] = strtolower($_REQUEST['tab']); 47. 48. // Prepare and trigger admin dispatcher 49. Dispatcher::getInstance()->dispatch(); Вот что мне выдает
  3. Всем привет, поиск по форуму не помог.. сильно не пинайте... Вопрос следующий: куда нужно добавлять коды для счетчиков яндекс метрика и прочих Google analytics... Спасибо
  4. У Меня тоже один сайт на mochahst тариф бизнес но качество ужасное. перехал на другой все отлично сорри за оффтоп
  5. The same problem i facing now : 12% Create settings.inc file Create database tables SQL error on query Table 'prs_access' already exists An error occured during installation... You can use the links on the left column to go back to the previous steps, or restart the installation process by
×
×
  • Create New...