(solved) Cain't connect to back office when ps mode dev set on true?

[David Dotou]

Hello I recently messed up my backups I'm learninthe hard way, I had password problem that I though I fixed but now I still cain't connect to the back office when i set define('_PS_MODE_DEV_', true

what can I do to fix this?

 

Unknown column 'last_connection_date' in 'where clause'
 

			UPDATE `ps_employee`			SET `last_connection_date` = CURRENT_DATE()			WHERE `id_employee` = 1 AND `last_connection_date`< CURRENT_DATE()		

at line 639 in file classes/db/Db.php

634. 			WebserviceRequest::getInstance()->setError(500, '[SQL Error] '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);635. 		}636. 		elseif (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))637. 		{638. 			if ($sql)639. 				throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');640. 			throw new PrestaShopDatabaseException($this->getMsgError());641. 		}642. 	}643. 644. 	/**

• DbCore->displayError - [line 333 - classes/db/Db.php] - [1 Arguments]
• DbCore->query - [line 473 - classes/db/Db.php] - [1 Arguments]
• DbCore->execute - [line 460 - classes/Employee.php] - [1 Arguments]
• EmployeeCore::setLastConnectionDate - [line 2445 - classes/controller/AdminController.php] - [1 Arguments]
• AdminControllerCore->init - [line 163 - classes/controller/Controller.php]
• ControllerCore->run - [line 374 - classes/Dispatcher.php]
• DispatcherCore->dispatch - [line 54 - admin/index.php]

Edited February 23, 2015 by David Dotou (see edit history)

[FullCircles]

Doesn't sound good, but I'd first try just going into the database and adding the missing column to the table

 

You'll want to run something like:

ALTER TABLE `ps_employee` ADD COLUMN `last_connection_date` date DEFAULT '0000-00-00'

[David Dotou]

Thank you for your answer FullCircles I was looking exactly for that ^^ unfortunatly i won't try it, i copied the tables I needed to keep and I started over th a fresh install this morning happy it wasn't live shop. Hope it helps others i'll mark it solved.