DROP TABLE IF EXISTS `uhpn_guest`;
CREATE TABLE IF NOT EXISTS `uhpn_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;
DROP TABLE IF EXISTS `uhpn_connections`;
CREATE TABLE `uhpn_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(20) 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;
En 13/5/2020 a las 9:44 PM, Kositas d Hermanas dijo:Hola:
Tengo el mismo problema me sale que la tabla ps_guest no existe tengo la version 1.7.7 y he realizado la consulta que indican pero me sigue saliendo el mismo error... alguien tiene alguna idea de lo que puedo hacer?...
Haz lo mismo que han comentado arriba los compañeros, pero cambia el prefijo de la tabla ps_guest por la tuya uhpn_guest
Ejecuta la consulta que a ti te haga falta...
Te lo he dejado cambiado para que copies y pegues 