erreur inattendue sur CLIENT

[ach34]

Bonjour,
Lorsque je clic sur "CLIENTS" (voir erreur ci-dessous). Je viens de mettre à jour ma version de prestashop en 1.7.7.5 mais ça corrige pas le problème.

Merci pour votre aide

Rapport debug :
 

PDOException
PDOException
TableNotFoundException
HTTP 500 Internal Server Error
An exception occurred while executing 'SELECT c.id_customer, c.firstname, c.lastname, c.email, c.active, c.newsletter, c.optin, c.date_add, gl.name as social_title, s.name as shop_name, c.company, (SELECT SUM(total_paid_real / conversion_rate) FROM psvd_orders o WHERE (o.id_customer = c.id_customer) AND (o.id_shop IN (?)) AND (o.valid = 1)) as total_spent, (SELECT con.date_add FROM psvd_guest g LEFT JOIN psvd_connections con ON con.id_guest = g.id_guest WHERE g.id_customer = c.id_customer ORDER BY con.date_add DESC LIMIT 1) as connect FROM psvd_customer c LEFT JOIN psvd_gender_lang gl ON c.id_gender = gl.id_gender AND gl.id_lang = ? LEFT JOIN psvd_shop s ON c.id_shop = s.id_shop WHERE (c.deleted = 0) AND (c.id_shop IN (?)) ORDER BY c.date_add DESC LIMIT 50' with params [1, 2, 1]:

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'atd_presta1.psvd_guest' doesn't exist

 

 

 

 

[Eolia]

il vous manque la table psvd_guest

CREATE TABLE IF NOT EXISTS `psvd_guest` (
  `id_guest` int(10) unsigned NOT NULL auto_increment, 
  `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', 
  PRIMARY KEY (`id_guest`), 
  KEY `id_customer` (`id_customer`), 
  KEY `id_operating_system` (`id_operating_system`), 
  KEY `id_web_browser` (`id_web_browser`)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

 

[ach34]

Ok merci je vais installer.

 

[ach34]

J'ai encore une erreur :

 

An exception occurred while executing 'SELECT c.id_customer, c.firstname, c.lastname, c.email, c.active, c.newsletter, c.optin, c.date_add, gl.name as social_title, s.name as shop_name, c.company, (SELECT SUM(total_paid_real / conversion_rate) FROM psvd_orders o WHERE (o.id_customer = c.id_customer) AND (o.id_shop IN (?)) AND (o.valid = 1)) as total_spent, (SELECT con.date_add FROM psvd_guest g LEFT JOIN psvd_connections con ON con.id_guest = g.id_guest WHERE g.id_customer = c.id_customer ORDER BY con.date_add DESC LIMIT 1) as connect FROM psvd_customer c LEFT JOIN psvd_gender_lang gl ON c.id_gender = gl.id_gender AND gl.id_lang = ? LEFT JOIN psvd_shop s ON c.id_shop = s.id_shop WHERE (c.deleted = 0) AND (c.id_shop IN (?)) ORDER BY c.date_add DESC LIMIT 50' with params [1, 2, 1]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'atd_presta1.psvd_connections' doesn't exist

[Doctrine\DBAL\Exception\TableNotFoundException 0]

 

[ach34]

C'est bon j'ai rajouté la table connections, j'ai trouvé le lien vers ma version https://github.com/PrestaShop/PrestaShop/blob/1.7.7.x/install-dev/data/db_structure.sql
ça semble fonctionner.
Merci pour l'aide ça m'a permis de comprendre comme résoudre ce type de problème

CREATE TABLE IF NOT EXISTS `psvd_connections` (
  `id_connections` int(10) unsigned NOT NULL auto_increment,
  `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 NULL DEFAULT NULL,
  `date_add` datetime NOT NULL,
  `http_referer` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id_connections`),
  KEY `id_guest` (`id_guest`),
  KEY `date_add` (`date_add`),
  KEY `id_page` (`id_page`)
) ENGINE=INNODB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

 

[Eolia]

donc en fait vous avez du réaliser un transfert de bdd qui crashait donc vous avez viré les tables trop lourdes et forcément elles manquent^^

Dans ce cas on transfère la structure mais pas les données^^

 

Pour info:

https://shop.devcustom.net/tables.php