Hallo,
wollte kurz meine Probleme schildern um indirekt nachzufragen ob ich was falsch gemacht habe bzw. vielleicht auf etwas aufpassen muss. Denn ich hatte mit der normalen Standardinstallationsprozedere Schwierigkeiten.
Hoster: All-Inkl
PHP Version: 7.1
SSL: ja
DB Persistent: nein
Modified Version: Vollversion 2.0.4.2 rev 11374
Die Installation ist ohne Probleme durchgegangen (ohne sichtlichen Fehler) beim Login ist mir aufgefallen das meine Kundengruppe nicht da stand. Ein Blick in die Loggs brachte zum Vorschein das einige INSERTS in die customer_status nicht durchgegangen sind.
Habe zum fixen die fehlenden Einträge lt. logs nachgeholt und jetzt passt alles. Nur bin ich mir jetzt unsicher ob ich "falsche" Einstellungen verwende oder sonstige Probleme übersehen habe um einen stabilen Betrieb in Zukunft zu gewährleisten...
Hier die logs:
[21-03-2019 08:45:52] E_USER_WARNING : LoggingManager: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TRUNCATE `customers_status`;
INSERT INTO `customers_status` (`customers_statu' at line 1<br/><br/>INSERT INTO `customers_status` (`customers_status_id`,`language_id`,`customers_status_name`,`customers_status_public`,`customers_status_min_order`,`customers_status_max_order`,`customers_status_image`,`customers_status_discount`,`customers_status_ot_discount_flag`,`customers_status_ot_discount`,`customers_status_graduated_prices`,`customers_status_show_price`,`customers_status_show_price_tax`,`customers_status_show_tax_total`,`customers_status_add_tax_ot`,`customers_status_payment_unallowed`,`customers_status_shipping_unallowed`,`customers_status_discount_attributes`,`customers_fsk18`,`customers_fsk18_display`,`customers_status_write_reviews`,`customers_status_read_reviews`,`customers_status_reviews_status`,`customers_status_specials`) VALUES TRUNCATE `customers_status`;
INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_min_order`, `customers_status_max_order`, `customers_status_image`,`customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_graduated_prices`, `customers_status_show_price`, `customers_status_show_price_tax`,`customers_status_show_tax_total`, `customers_status_add_tax_ot`, `customers_status_payment_unallowed`, `customers_status_shipping_unallowed`,`customers_status_discount_attributes`, `customers_fsk18`, `customers_fsk18_display`, `customers_status_write_reviews`, `customers_status_read_reviews`,`customers_status_reviews_status`, `customers_status_specials`) VALUES (0, 2, 'Admin', 1, NULL, NULL, 'admin_status.gif', 0.00, '1', 0.00, '1', 1, 1, 150, 0, '', '', 0, 1, 1, 1, 1, 1, 1);; in File: /www/htdocs/xxxx/xxxx/inc/db_functions_mysqli.inc.php on Line: 161
[21-03-2019 08:45:52] E_USER_WARNING : LoggingManager: Backtrace #0 - /www/htdocs/xxxx/xxxx/xxxx/includes/db_actions.php called at Line 285
[21-03-2019 08:45:52] E_USER_WARNING : LoggingManager: Backtrace #1 - /www/htdocs/xxxx/xxxx/_installer/install_step1.php called at Line 166
[21-03-2019 08:45:52] E_WARNING : LoggingManager: mysqli_errno() expects parameter 1 to be mysqli, null given in File: /www/htdocs/xxxx/xxxx/xxxx/includes/db_actions.php on Line: 288
[21-03-2019 08:45:52] E_WARNING : LoggingManager: Backtrace #0 - /www/htdocs/xxxx/xxxx/_installer/install_step1.php called at Line 166
[21-03-2019 08:45:52] E_WARNING : LoggingManager: mysqli_error() expects parameter 1 to be mysqli, null given in File: /www/htdocs/xxxx/xxxx/xxxx/includes/db_actions.php on Line: 288
[21-03-2019 08:45:52] E_WARNING : LoggingManager: Backtrace #0 - /www/htdocs/xxxx/xxxx/_installer/install_step1.php called at Line 166
[21-03-2019 08:45:52] E_USER_WARNING : LoggingManager: - <br/><br/> in File: /www/htdocs/xxxx/xxxx/inc/db_functions_mysqli.inc.php on Line: 161
[21-03-2019 08:45:52] E_USER_WARNING : LoggingManager: Backtrace #0 - /www/htdocs/xxxx/xxxx/xxxx/includes/db_actions.php called at Line 288
[21-03-2019 08:45:52] E_USER_WARNING : LoggingManager: Backtrace #1 - /www/htdocs/xxxx/xxxx/_installer/install_step1.php called at Line 166
[21-03-2019 08:45:52] E_USER_WARNING : LoggingManager: 1062 - Duplicate entry 'H-2' for key 'idx_customers_status_name'<br/><br/>INSERT INTO `customers_status` (`customers_status_id`, `language_id`, `customers_status_name`, `customers_status_public`, `customers_status_min_order`, `customers_status_max_order`, `customers_status_image`, `customers_status_discount`, `customers_status_ot_discount_flag`, `customers_status_ot_discount`, `customers_status_graduated_prices`, `customers_status_show_price`, `customers_status_show_price_tax`, `customers_status_show_tax_total`, `customers_status_add_tax_ot`, `customers_status_payment_unallowed`, `customers_status_shipping_unallowed`, `customers_status_discount_attributes`, `customers_fsk18`, `customers_fsk18_display`, `customers_status_write_reviews`, `customers_status_read_reviews`, `customers_status_reviews_status`, `customers_status_specials`) VALUES (4, 2, 'Händler EU', 1, NULL, NULL, 'merchant_status.gif', 0.00, '0', 0.00, '1', 1, 0, 150, 0, '', '', 0, 1, 1, 1, 1, 1, 0); in File: /www/htdocs/xxxx/xxxx/inc/db_functions_mysqli.inc.php on Line: 161
[21-03-2019 08:45:52] E_USER_WARNING : LoggingManager: Backtrace #0 - /www/htdocs/xxxx/xxxx/xxxx/includes/db_actions.php called at Line 285
[21-03-2019 08:45:52] E_USER_WARNING : LoggingManager: Backtrace #1 - /www/htdocs/xxxx/xxxx/_installer/install_step1.php called at Line 166
[21-03-2019 08:48:21] E_WARNING : LoggingManager: file_get_contents(https://www.modified-shop.org/feed/?v=2.0.4.1): failed to open stream: HTTP request failed! in File: /www/htdocs/xxxx/xxxx/inc/get_external_content.inc.php on Line: 32
[21-03-2019 08:48:21] E_WARNING : LoggingManager: Backtrace #0 - /www/htdocs/xxxx/xxxx/inc/get_newsfeed.inc.php called at Line 20
[21-03-2019 08:48:21] E_WARNING : LoggingManager: Backtrace #1 - /www/htdocs/xxxx/xxxx/templates/tpl_modified/source/boxes/admin.php called at Line 24
[21-03-2019 08:48:21] E_WARNING : LoggingManager: Backtrace #2 - /www/htdocs/xxxx/xxxx/templates/tpl_modified/source/boxes.php called at Line 104
[21-03-2019 08:48:21] E_WARNING : LoggingManager: Backtrace #3 - /www/htdocs/xxxx/xxxx/index.php called at Line 31
[21-03-2019 08:48:26] E_WARNING : LoggingManager: fopen(https://www.modified-shop.org/feed/?v=2.0.4.1): failed to open stream: HTTP request failed! in File: /www/htdocs/xxxx/xxxx/inc/get_external_content.inc.php on Line: 39
[21-03-2019 08:48:26] E_WARNING : LoggingManager: Backtrace #0 - /www/htdocs/xxxx/xxxx/inc/get_newsfeed.inc.php called at Line 20
[21-03-2019 08:48:26] E_WARNING : LoggingManager: Backtrace #1 - /www/htdocs/xxxx/xxxx/templates/tpl_modified/source/boxes/admin.php called at Line 24
[21-03-2019 08:48:26] E_WARNING : LoggingManager: Backtrace #2 - /www/htdocs/xxxx/xxxx/templates/tpl_modified/source/boxes.php called at Line 104
[21-03-2019 08:48:26] E_WARNING : LoggingManager: Backtrace #3 - /www/htdocs/xxxx/xxxx/index.php called at Line 31
Vielen Dank!
Linkback: https://www.modified-shop.org/forum/index.php?topic=40119.0