Jump to content

Ошибка при создании новго продукта 1.5.3.1


Recommended Posts

Доброго времени суток!

Обновился до 1.5.3.1 при попытке создать новый продукт выдает следующую ошибуку

что делать незнаю :mellow:

кто встречал подобное и с чем это может быть связано ?

 

Спасибо!

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 by Karmahacker (see edit history)

Share this post


Link to post
Share on other sites

...

Unknown column 'redirect_type' in 'field list'INSERT INTO `ps_product`

...

нет нужной колонки в таблице - как-то не коректно обновились

  • Like 1

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More