Karmahacker Posted January 30, 2013 Share Posted January 30, 2013 (edited) Доброго времени суток! Обновился до 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 - admin@/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(); Вот что мне выдает Edited January 30, 2013 by Karmahacker (see edit history) Link to comment Share on other sites More sharing options...
mazapura Posted January 30, 2013 Share Posted January 30, 2013 ... Unknown column 'redirect_type' in 'field list'INSERT INTO `ps_product` ... нет нужной колонки в таблице - как-то не коректно обновились 1 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now