id summary reporter owner description type status priority milestone component version resolution keywords cc blockedby blocking
875 Fehler bei Datenbankstruktur-Update Torsten Riemer Gerhard Waldemair "Es gibt hier mehrere Probleme:
1.) Folgende Fehler habe ich erhalten:
{{{
[03-05-2016 21:53:19] 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 ')' at line 1
ALTER TABLE campaigns ADD KEY () in File: /.../.../.../.../.../.../shoproot/inc/db_functions_mysql.inc.php on Line: 151
[03-05-2016 21:53:19] E_USER_WARNING : LoggingManager: Backtrace #0 - /.../.../.../.../.../.../shoproot/_installer/includes/update_action.php called at Line 156
[03-05-2016 21:53:19] E_USER_WARNING : LoggingManager: Backtrace #1 - /.../.../.../.../.../.../shoproot/_installer/update.php called at Line 100
[03-05-2016 21:53:21] 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 '-00-00 00:00:00 NOT NULL AFTER carrier_sort_order' at line 1
ALTER TABLE carriers ADD carrier_date_added datetime DEFAULT 0000-00-00 00:00:00 NOT NULL AFTER carrier_sort_order in File: /.../.../.../.../.../.../shoproot/inc/db_functions_mysql.inc.php on Line: 151
[03-05-2016 21:53:21] E_USER_WARNING : LoggingManager: Backtrace #0 - /.../.../.../.../.../.../shoproot/_installer/includes/update_action.php called at Line 105
[03-05-2016 21:53:21] E_USER_WARNING : LoggingManager: Backtrace #1 - /.../.../.../.../.../.../shoproot/_installer/update.php called at Line 100
[03-05-2016 21:53:21] 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 '-00-00 00:00:00 NOT NULL AFTER carrier_date_added' at line 1
ALTER TABLE carriers ADD carrier_last_modified datetime DEFAULT 0000-00-00 00:00:00 NOT NULL AFTER carrier_date_added in File: /.../.../.../.../.../.../shoproot/inc/db_functions_mysql.inc.php on Line: 151
[03-05-2016 21:53:21] E_USER_WARNING : LoggingManager: Backtrace #0 - /.../.../.../.../.../.../shoproot/_installer/includes/update_action.php called at Line 105
[03-05-2016 21:53:21] E_USER_WARNING : LoggingManager: Backtrace #1 - /.../.../.../.../.../.../shoproot/_installer/update.php called at Line 100
[03-05-2016 21:53:23] 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 ')' at line 1
ALTER TABLE categories_description ADD KEY () in File: /.../.../.../.../.../.../shoproot/inc/db_functions_mysql.inc.php on Line: 151
[03-05-2016 21:53:23] E_USER_WARNING : LoggingManager: Backtrace #0 - /.../.../.../.../.../.../shoproot/_installer/includes/update_action.php called at Line 156
[03-05-2016 21:53:23] E_USER_WARNING : LoggingManager: Backtrace #1 - /.../.../.../.../.../.../shoproot/_installer/update.php called at Line 100
[03-05-2016 21:53:36] 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 '-00-00 00:00:00 AFTER password_request_key' at line 1
ALTER TABLE customers ADD password_request_time datetime DEFAULT 0000-00-00 00:00:00 AFTER password_request_key in File: /.../.../.../.../.../.../shoproot/inc/db_functions_mysql.inc.php on Line: 151
[03-05-2016 21:53:36] E_USER_WARNING : LoggingManager: Backtrace #0 - /.../.../.../.../.../.../shoproot/_installer/includes/update_action.php called at Line 105
[03-05-2016 21:53:36] E_USER_WARNING : LoggingManager: Backtrace #1 - /.../.../.../.../.../.../shoproot/_installer/update.php called at Line 100
[03-05-2016 21:53:36] 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 '-00-00 00:00:00 AFTER customers_login_tries' at line 1
ALTER TABLE customers ADD customers_login_time datetime DEFAULT 0000-00-00 00:00:00 AFTER customers_login_tries in File: /.../.../.../.../.../.../shoproot/inc/db_functions_mysql.inc.php on Line: 151
[03-05-2016 21:53:36] E_USER_WARNING : LoggingManager: Backtrace #0 - /.../.../.../.../.../.../shoproot/_installer/includes/update_action.php called at Line 105
[03-05-2016 21:53:36] E_USER_WARNING : LoggingManager: Backtrace #1 - /.../.../.../.../.../.../shoproot/_installer/update.php called at Line 100
[03-05-2016 21:53:51] 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 '-00-00 00:00:00 NOT NULL AFTER ip_date_added' at line 1
ALTER TABLE newsletter_recipients ADD date_confirmed datetime DEFAULT 0000-00-00 00:00:00 NOT NULL AFTER ip_date_added in File: /.../.../.../.../.../.../shoproot/inc/db_functions_mysql.inc.php on Line: 151
[03-05-2016 21:53:51] E_USER_WARNING : LoggingManager: Backtrace #0 - /.../.../.../.../.../.../shoproot/_installer/includes/update_action.php called at Line 105
[03-05-2016 21:53:51] E_USER_WARNING : LoggingManager: Backtrace #1 - /.../.../.../.../.../.../shoproot/_installer/update.php called at Line 100
[03-05-2016 21:53:51] E_USER_WARNING : LoggingManager: 1054 - Unknown column 'date_confirmed' in 'newsletter_recipients'
ALTER TABLE newsletter_recipients ADD ip_date_confirmed varchar(32) AFTER date_confirmed in File: /.../.../.../.../.../.../shoproot/inc/db_functions_mysql.inc.php on Line: 151
[03-05-2016 21:53:51] E_USER_WARNING : LoggingManager: Backtrace #0 - /.../.../.../.../.../.../shoproot/_installer/includes/update_action.php called at Line 105
[03-05-2016 21:53:51] E_USER_WARNING : LoggingManager: Backtrace #1 - /.../.../.../.../.../.../shoproot/_installer/update.php called at Line 100
[03-05-2016 21:53:57] E_USER_WARNING : LoggingManager: 1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key
ALTER TABLE orders DROP INDEX orders_id in File: /.../.../.../.../.../.../shoproot/inc/db_functions_mysql.inc.php on Line: 151
[03-05-2016 21:53:57] E_USER_WARNING : LoggingManager: Backtrace #0 - /.../.../.../.../.../.../shoproot/_installer/includes/update_action.php called at Line 129
[03-05-2016 21:53:57] E_USER_WARNING : LoggingManager: Backtrace #1 - /.../.../.../.../.../.../shoproot/_installer/update.php called at Line 100
[03-05-2016 21:54:32] E_USER_WARNING : LoggingManager: 1062 - Duplicate entry '204-JU' for key 'idx_country_code'
ALTER TABLE zones ADD UNIQUE idx_country_code (zone_country_id, zone_code) in File: /.../.../.../.../.../.../shoproot/inc/db_functions_mysql.inc.php on Line: 151
[03-05-2016 21:54:32] E_USER_WARNING : LoggingManager: Backtrace #0 - /.../.../.../.../.../.../shoproot/_installer/includes/update_action.php called at Line 156
[03-05-2016 21:54:32] E_USER_WARNING : LoggingManager: Backtrace #1 - /.../.../.../.../.../.../shoproot/_installer/update.php called at Line 100
}}}
2.) Hat der Shopbetreiber in der Datenbank des alten Shops ""EMAIL_SQL_ERRORS"" auf ""true"" stehen, dann bricht die ""update.php"" bei Fehlern mit folgendem Fehler ab:
{{{
[03-05-2016 21:52:23] E_ERROR : LoggingManager: Call to undefined function xtc_php_mail() in File: /.../.../.../.../.../.../shoproot/inc/db_functions_mysql.inc.php on Line: 148
}}}" Bug/Fehler closed hoch modified-shop-2.0.1.0 Installer 2.0.0.0 fixed