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

Kann der Fulltext-Index nicht weg? Mir fällt keine Stelle ein, die den überhaupt nutzt. Dann ist der Fehler natürlich auch weg.

comment:3 Changed 5 years ago by GTB

  • Resolution set to fixed
  • Status changed from new to closed

In 9630:

fix #626

Add Comment

Modify Ticket

Action
as closed
The resolution will be deleted. Next status will be 'reopened'
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.