so I tried a install since when I uploaded all the files inside the 1.7.6.7 zip then copied my image and config dir it seemed to continue the install at the database loading point. I just finished it and vilia I had a working site.. now to get my data in it I took my phpmyadmin datababase and tried to import it.. had to drop the tables and import now I get this
i had some employees in this 1.7.6.4 data did the data base change in 1.7.6.7? clearly it has and they have added some tables .. I wish some one could explain the differences . can I just create this missing data.
Whoops, looks like something went wrong. (1/1) PrestaShopDatabaseException Table 'c1store.ps_employee_session' doesn't exist<br /><br /><pre>SELECT * FROM `ps_employee_session` a WHERE (a.`id_employee_session` = 1) LIMIT 1</pre> in Db.php line 769 at DbCore->displayError('SELECT *FROM `ps_employee_session` aWHERE (a.`id_employee_session` = 1) LIMIT 1')in Db.php line 385 at DbCore->query('SELECT *FROM `ps_employee_session` aWHERE (a.`id_employee_session` = 1) LIMIT 1')in Db.php line 663 at DbCore->getRow('SELECT *FROM `ps_employee_session` aWHERE (a.`id_employee_session` = 1) LIMIT 1')in EntityMapper.php line 75 at EntityMapper->load('1', null, object(EmployeeSession), array('table' => 'employee_session', 'primary' => 'id_employee_session', 'fields' => array('id_employee' => array('type' => 1, 'validate' => 'isUnsignedId', 'required' => true), 'token' => array('type' => 3, 'validate' => 'isSha1', 'size' => 40, 'copy_post' => false)), 'classname' => 'EmployeeSession'), null, true)in ObjectModel.php line 264 at ObjectModelCore->__construct('1')in Cookie.php line 535 at CookieCore->getSession('1')in Cookie.php line 514 at CookieCore->isSessionAlive()in Employee.php line 486 at EmployeeCore->isLoggedBack()in AdminController.php line 2916 at AdminControllerCore->initShopContext()in AdminController.php line 531 at AdminControllerCore->__construct()in LegacyContext.php line 85 at LegacyContext->getContext()in UserLocaleListener.php line 39 at UserLocaleListener->__construct(object(LegacyContext))in appDevDebugProjectContainer.php line 2396 at appDevDebugProjectContainer->getPrestashop_UserLocale_ListenerService()in appDevDebugProjectContainer.php line 2883 at appDevDebugProjectContainer->ContainerJiamxls\{closure}()in EventDispatcher.php line 229 at EventDispatcher->sortListeners('kernel.request')in EventDispatcher.php line 61 at EventDispatcher->getListeners('kernel.request')in ContainerAwareEventDispatcher.php line 128 at ContainerAwareEventDispatcher->getListeners('kernel.request')in TraceableEventDispatcher.php line 262 at TraceableEventDispatcher->preProcess('kernel.request')in TraceableEventDispatcher.php line 137 at TraceableEventDispatcher->dispatch('kernel.request', object(GetResponseEvent))in HttpKernel.php line 127 at HttpKernel->handleRaw(object(Request), 1)in HttpKernel.php line 68 at HttpKernel->handle(object(Request), 1, false)in Kernel.php line 200 at Kernel->handle(object(Request), 1, false)in index.php line 86
So I look at the different database and I see it is missing ps_employee_session so I add it with code below (I hide the value data for safety/privacy) I
now do not get the error and get a proper login .. But my login does not work
CREATE TABLE `ps_employee_session` (
`id_employee_session` int(11) UNSIGNED NOT NULL,
`id_employee` int(10) UNSIGNED DEFAULT NULL,
`token` varchar(40) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `ps_employee_session` (`id_employee_session`, `id_employee`, `token`) VALUES
(1, 1, 'xxxxxxxthexxdataxxxxgoesxxxhere');
So now I get the admin login screen but it will not let me login and my main page it gives me a
[PrestaShopException]
No template found for index
more because I use a template and have not been able to login to install that. login literately does nothing but just refresh . does not give a invalid or anything just reloads ready for me to login. I can see my login in the database if I manually select the SELECT * FROM `ps_employee`