Fehler bei Datenbankstruktur-Update

[Torsten Riemer]

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<br/><br/>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<br/><br/>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<br/><br/>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<br/><br/>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<br/><br/>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<br/><br/>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<br/><br/>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'<br/><br/>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<br/><br/>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'<br/><br/>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

[Gerhard Waldemair]

In 9857:

fix #875