Table not found

[Dartstempel_NL]

Dear Prestashop friends,

Today I encountered un unexpected 500 internal server error in the tab where I can see all of my customers. After enabling the debug mode I found a 'table or view not found' error. From what I suppect the table '.psia_guest' doesn't exist anymore somehow. Is there anyone with a screenshot of their  .psia_guest table with all the right settings so I can create a new one?

Edited January 7, 2021 by Dartstempel_NL (see edit history)

[ClassyDevs]

hello, you can run this code in your phpmyadmin and check it solved or not

 

CREATE TABLE `psia_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;

 

Hope it will resolve your issue

 

Thank you

[Dartstempel_NL]

  On 1/6/2021 at 5:09 AM, ClassyDevs said:

Hope it will resolve your issue

 

Thank you

Expand  

Thanks that one seems to work now. But table psia_connections is also missing. This all happend after I tried to upgrade from 1.7.6.7 to another version. The upgrade failed and when I restored the Prestashop made backup those 2 tables where gone. So do you also happen to have the code for the psia_connections table?

Edited January 6, 2021 by Dartstempel_NL (see edit history)

[ClassyDevs]

You can try this , it will resolve the issue

 

Thank you

 

CREATE TABLE `psia_connections` (
  `id_connections` int(10) UNSIGNED NOT NULL,
  `id_shop_group` int(11) UNSIGNED NOT NULL DEFAULT '1',
  `id_shop` int(11) UNSIGNED NOT NULL DEFAULT '1',
  `id_guest` int(10) UNSIGNED NOT NULL,
  `id_page` int(10) UNSIGNED NOT NULL,
  `ip_address` bigint(20) DEFAULT NULL,
  `date_add` datetime NOT NULL,
  `http_referer` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

 

[Dartstempel_NL]

Yess everything is back to normal, your a big hero! 😀😀