Opened 6 years ago
Closed 5 years ago
#626 closed Bug/Fehler (fixed)
Fehler im Installer
Reported by: | Tomcraft | Owned by: | somebody |
---|---|---|---|
Priority: | hoch | Milestone: | modified-shop-2.0.0.0 |
Component: | Installer | Version: | 2.0.0.0 |
Description (last modified by Tomcraft)
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
Attachments (0)
Change History (3)
comment:1 Changed 6 years ago by Tomcraft
- Description modified (diff)
comment:2 Changed 5 years ago by webald
comment:3 Changed 5 years ago by GTB
- Resolution set to fixed
- Status changed from new to closed
In 9630:
Note: See
TracTickets for help on using
tickets.
Kann der Fulltext-Index nicht weg? Mir fällt keine Stelle ein, die den überhaupt nutzt. Dann ist der Fehler natürlich auch weg.