Jump to content

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


Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Hier fehlt was 

 

image.thumb.png.f7eefeaef7c5c321f52915841afdc680.png

 

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);

 

Share this post


Link to post
Share on other sites

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;

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More