Super Gau ... 500 Internal Server Error - Verkauf Kunden

[see_k]

Gau ... wenn ich auf Verkauf/Kunden gehe bekomme ich diese schöne Meldung

Uff wo muss ich da ansetzten mit Fehler suche ...

/index.php/sell/customers/?_token=aB-ILc1Oyhc4f_SrIXC5xUOcwD2Zsshf_Om22lOcGT4

 

Oops! An Error Occurred

The server returned a "500 Internal Server Error".

Something is broken. Please let us know what you were doing when this error occurred. We will fix it as soon as possible. Sorry for any inconvenience caused.

[see_k]

sorry nachtrag 1.7.6.2 PHP 7.2 (7.3)

Debug modus (dafür gibt es ihn ja)

 

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 ps_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 ps_guest g LEFT JOIN ps_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 ps_customer c LEFT JOIN ps_gender_lang gl ON c.id_gender = gl.id_gender AND gl.id_lang = ? LEFT JOIN ps_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 'presta_zz.ps_guest' doesn't exist

 

[see_k]

Hier noch ein Link (ist testumfeld)

https://www.art-outdoor.ch/shop_61/admin427mkcmkl/index.php/sell/customers/?_token=aB-ILc1Oyhc4f_SrIXC5xUOcwD2Zsshf_Om22lOcGT4

Jetzt sehe ich nur Bahnhof ...

[see_k]

hier noch mehr Fehler

 

[see_k]

Habe was gelesen das es die ps_connections braucht

die habe ich nicht

 

Ich habe hier = Ahnung was ich mache ...

[Wuschel]

3 minutes ago, see_k said:

Habe was gelesen das es die ps_connections braucht

die habe ich nicht

Da deutet wohl einiges darauf hin, dass deine Datenbank nicht vollständig ist und eine Reihe von Tabellen fehlen. So wird das nichts.

[see_k]

Hier fehlt was 

 

 

Habe das gefunden 

 

 

Please check table in your database with name ps_shop_group.

Default cloumns of this table are

1) id_shop_group

2) name

3) share_customer

4) share_order

5) share_stock

6) active

7) deleted

 

If there is haven't any table with this name then you need to run this sql query in your database

 

CREATE TABLE IF NOT EXISTS `ps_shop_group` (
  `id_shop_group` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL,
  `share_customer` tinyint(1) NOT NULL,
  `share_order` tinyint(1) NOT NULL,
  `share_stock` tinyint(1) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `deleted` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id_shop_group`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

 

INSERT INTO `ps_shop_group` (`id_shop_group`, `name`, `share_customer`, `share_order`, `share_stock`, `active`, `deleted`) VALUES
(1, 'Default', 0, 0, 0, 1, 0);

 

[see_k]

sorry vielleicht ist da dir richtige spur

 

ps_guest does not exist

 

 

[see_k]

Lösung gefunden (aber keine Ahnung was ich gemacht hatte aber jetzt geht es wieder)

 

Ich musste diese Tabelle neu erstellen (phpmyAdmin)

 

CREATE TABLE `ps_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 CHARSET=utf8

 

und diese aus thanks to Playklicky

 

 

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;