Problemas con SQL?

[sobrinofsky]

Buenas noches.
Estoy intentando configurar la tienda online, concretamente en el backoffice.
Cuando hago click en el Menú "Clientes", me sale un error Internal Server 500.

He activado el reporte de bugs con el archivo define.inc.php

Me da un error de base de datos. Concretamente me da este 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 prstshp_orders o WHERE (o.id_customer = c.id_customer) AND (o.id_shop IN (?)) AND (o.valid = 1)) as total_spent, (SELECT c.date_add FROM prstshp_guest g LEFT JOIN prstshp_connections con ON con.id_guest = g.id_guest WHERE g.id_customer = c.id_customer ORDER BY c.date_add DESC LIMIT 1) as connect FROM prstshp_customer c LEFT JOIN prstshp_gender_lang gl ON c.id_gender = gl.id_gender AND gl.id_lang = ? LEFT JOIN prstshp_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 OFFSET 0' with params [1, 1, 1]:

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

¿Qué ocurre? ¿Se puede solucionar?

Necesito ayuda.

Gracias de antemano.

[Luisejo]

Hola @sobrinofsky

Ejecuta esto en tu base de datos...

DROP TABLE IF EXISTS `ps_guest`;
CREATE TABLE IF NOT EXISTS `ps_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;

Y vuelve a hacer click en el menú
Ya me cuentas.

Saludos.

[pablorangel5081]

Buenos dias estimados. a mi me esta sucediendo lo mismo en la seccion de clientres. ya crer la tabla ps_guest como lo indicaste pero ahora me arroja el siguiente 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 p17_orders o WHERE (o.id_customer = c.id_customer) AND (o.id_shop IN (?)) AND (o.valid = 1)) as total_spent, (SELECT c.date_add FROM p17_guest g LEFT JOIN p17_connections con ON con.id_guest = g.id_guest WHERE g.id_customer = c.id_customer ORDER BY c.date_add DESC LIMIT 1) as connect FROM p17_customer c LEFT JOIN p17_gender_lang gl ON c.id_gender = gl.id_gender AND gl.id_lang = ? LEFT JOIN p17_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 OFFSET 0' with params [1, 2, 1]:

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