Errror when sending CONTACT US form (PS1.6.0.13)

[dformica]

This shop was upgraded from .11 version.

While testing I realized the contact us form doesn't work.  Please advice.

[PrestaShopDatabaseException]
Unknown column 'date_upd' in 'field list'
INSERT INTO `ps_customer_message` (`id_employee`, `id_customer_thread`, `ip_address`, `message`, `file_name`, `user_agent`, `private`, `date_add`, `date_upd`, `read`) VALUES ('0', '16', '1290281811', 'GENERAL MESSAGE TEST', '', 'Mozilla/5.0 (Windows NT 6.1; WOW64; rv:36.0) Gecko/20100101 Firefox/36.0', '0', '2015-03-12 06:23:24', '2015-03-12 06:23:24', '0')

at line 646 in file classes/db/Db.php
641. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
642. 		}
643. 		elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
644. 		{
645. 			if ($sql)
646. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
647. 			throw new PrestaShopDatabaseException($this->getMsgError());
648. 		}
649. 	}
650. 
651. 	/**
•	DbCore->displayError - [line 340 - classes/db/Db.php] - [1 Arguments]
•	DbCore->query - [line 620 - classes/db/Db.php] - [1 Arguments]
•	DbCore->q - [line 405 - classes/db/Db.php] - [2 Arguments]
•	DbCore->insert - [line 486 - classes/ObjectModel.php] - [3 Arguments]
•	ObjectModelCore->add - [line 153 - controllers/front/ContactController.php]
•	ContactControllerCore->postProcess - [line 171 - classes/controller/Controller.php]
•	ControllerCore->run - [line 373 - classes/Dispatcher.php]
•	DispatcherCore->dispatch - [line 28 - index.php]

Edited March 12, 2015 by dformica (see edit history)

[SLiCK_303]

Sound like you are missing 'date_upd' in your 'ps_customer_message' table, it should look like this...

Edited March 13, 2015 by SLiCK_303 (see edit history)

[dformica]

Thanks that solved the problem!

 I just don't know how that field went magically missing from the table.

My shop was a 1.6.011 upgraded to .13