Problem with creating new Product 1.5.3.1

[Karmahacker]

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 - 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();

  
  

[benjamin utterback]

Hello, what version did you update from? How did you proceed with the update?

[Karmahacker]

Hi i've install new 1.5.3 then update by 1click module to 1.5.3.1

Edited January 30, 2013 by Karmahacker (see edit history)

[benjamin utterback]

Hey, thanks for the information. If you are just starting, then I recommend to install a fresh install of 1.5.3.1. Would this be possible for your store?

[Karmahacker]

ok ill try it