id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc	blockedby	blocking
626	Fehler im Installer	Torsten Riemer	somebody	"Hier das Log dazu:

{{{
22/08/2015 15:36:13 E_USER_WARNING - 1146 - Table 'test_db.ones_to_geo_zones' doesn't exist<br/><br/>SHOW COLUMNS FROM ones_to_geo_zones in File: /var/www/.../.../.../.../.../inc/db_functions_mysql.inc.php on Line: 151
22/08/2015 15:36:13 Backtrace #0 - /var/www/.../.../.../.../.../_installer/includes/functions.php called at Line 135
22/08/2015 15:36:13 Backtrace #1 - /var/www/.../.../.../.../.../_installer/update.php called at Line 78
22/08/2015 15:36:14 E_USER_WARNING - 1146 - Table 'test_db.ones' doesn't exist<br/><br/>SHOW COLUMNS FROM ones in File: /var/www/.../.../.../.../.../inc/db_functions_mysql.inc.php on Line: 151
22/08/2015 15:36:14 Backtrace #0 - /var/www/.../.../.../.../.../_installer/includes/functions.php called at Line 135
22/08/2015 15:36:14 Backtrace #1 - /var/www/.../.../.../.../.../_installer/update.php called at Line 78
}}}

Die ""/_installer/includes/functions.php"" scheint hier das ""z"" abzuschneiden:

{{{
    if (preg_match(""|[\z\s]?(?:ALTER TABLE?){1}[\z\s]+([^ ]*)[\z\s]+(?:ADD?){1}[\z\s]+([^ ]*)[\z\s]+([^ ]*)|"", $sql, $matches)) {
      if ($matches[2] == strtoupper('INDEX')) {
        $check_query = xtc_db_query(""SHOW KEYS FROM "".$matches[1]."" WHERE Key_name='"".$matches[3].""'"");
        if (xtc_db_num_rows($check_query)>0) {
          xtc_db_query(""ALTER TABLE "".$matches[1]."" DROP INDEX "".$matches[3]);
        }
      } else {
        $check_query = xtc_db_query(""SHOW COLUMNS FROM "" . $matches[1]);
        while ($check = xtc_db_fetch_array($check_query)) {
          if ($check['Field']==$matches[2]) { 
            $exists = true;
          }
        }
      }
    }
}}}

Ein weiterer Fehler tritt auf, wenn die Datenbank auf InnoDB steht, da hier der FULLTEXT Index nicht unterstützt wird. Das kann beispielsweise beim Update von folgenden Shopversionen vorkommen, da wir hier noch keine Angabe von ENGINE=MyISAM drin hatten:
1.00
1.01
1.02

{{{
23/08/2015 12:03:27 E_USER_WARNING - 1214 - The used table type doesn't support FULLTEXT indexes<br/><br/>

ALTER TABLE `content_manager` ADD FULLTEXT (
`content_meta_title` ,
`content_meta_description` ,
`content_meta_keywords`
) in File: /var/www/.../.../.../.../.../inc/db_functions_mysql.inc.php on Line: 151
23/08/2015 12:03:27 Backtrace #0 - /var/www/.../.../.../.../.../_installer/includes/functions.php called at Line 147
23/08/2015 12:03:27 Backtrace #1 - /var/www/.../.../.../.../.../_installer/update.php called at Line 78
23/08/2015 12:04:20 E_USER_WARNING - 1091 - Can't DROP 'content_meta_title'; check that column/key exists<br/><br/>
ALTER TABLE content_manager DROP INDEX content_meta_title in File: /var/www/.../.../.../.../.../inc/db_functions_mysql.inc.php on Line: 151
23/08/2015 12:04:20 Backtrace #0 - /var/www/.../.../.../.../.../_installer/includes/functions.php called at Line 147
23/08/2015 12:04:20 Backtrace #1 - /var/www/.../.../.../.../.../_installer/update.php called at Line 78
}}}"	Bug/Fehler	closed	hoch	modified-shop-2.0.0.0	Installer	2.0.0.0	fixed