Errors after restoring backup database - customers and shopping carts not visible

[Tim Eyselbergs]

Hello, 

I recently had to restore a backup of my database (after having problems with version 1.7.8.0). Currently i have updated again to version 1.7.8.1 but still experiencing the problem. When i hit customers or shopping carts i get the 2 errors you can see in the screenshot. I did some digging and it looks like something with the "connections" table? However, no idea on how to solve this. Can anyone help me out?

[Tim Eyselbergs]

13 minutes ago, ndiaga said:

Hi,

Please  click  on   "Enable  debug  mode"    and  then  report  to  us  the  error   you  have.

Hello,

Thanks for that. The 2 errors i get you can see in the screenshots. Let me know if you need anything else!

 

[Tim Eyselbergs]

32 minutes ago, ndiaga said:

Hi,

There  is   a  missing   table  zokw_guest   .

any recommendation on how to solve this? I am not that familiar with prestashop or sql. 

[Tim Eyselbergs]

20 hours ago, ndiaga said:

You  can  create   that  table  again.

Use  the  phpMyadmin    and  run  this  query :

CREATE TABLE `zokw_guest` (
  `id_guest` int(10) UNSIGNED NOT NULL,
  `id_operating_system` int(10) UNSIGNED DEFAULT NULL,
  `id_web_browser` int(10) UNSIGNED DEFAULT NULL,
  `id_customer` int(10) UNSIGNED DEFAULT NULL,
  `javascript` tinyint(1) DEFAULT '0',
  `screen_resolution_x` smallint(5) UNSIGNED DEFAULT NULL,
  `screen_resolution_y` smallint(5) UNSIGNED DEFAULT NULL,
  `screen_color` tinyint(3) UNSIGNED DEFAULT NULL,
  `sun_java` tinyint(1) DEFAULT NULL,
  `adobe_flash` tinyint(1) DEFAULT NULL,
  `adobe_director` tinyint(1) DEFAULT NULL,
  `apple_quicktime` tinyint(1) DEFAULT NULL,
  `real_player` tinyint(1) DEFAULT NULL,
  `windows_media` tinyint(1) DEFAULT NULL,
  `accept_language` varchar(8) DEFAULT NULL,
  `mobile_theme` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

ok, thanks for that. I got a bit further, but still not working. So i executed your query, then i tried again and i basically got the same error but now for the ZOKW_connections table. I then ran your query again but not to make the zokw_connections table. Then that error went away but now i get the following one (see screenshot). any idea on how to proceed now?

[JBW]

It's usually only guest and connection tables as you can exclude them from backup (statistical data) - anyway looks like a bug if they do not get created at all at restore.