Opened 10 years ago

Last modified 10 years ago

#626 closed Bug/Fehler

Fehler im Installer — at Initial Version

Reported by: Torsten Riemer Owned by: somebody
Priority: hoch Milestone: modified-shop-2.0.0.0
Component: Installer Version: 2.0.0.0
Keywords: Cc:
Blocked By: Blocking:

Description

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;
          }
        }
      }
    }

Change History (0)

Note: See TracTickets for help on using tickets.