fedexcarrier will not install

[ticasport]

I am trying to install the fedexcarrier module for the first time and get this error:

 

 

The following module(s) were not installed properly:

• - fedexcarrier :
  

Any help getting this resolved would be excellent.

[thoneycutt]

Same problem for me as well. Running 1.5.4.1.

Hope someone can figure this out.

[ticasport]

Turned on Error Reporting and got this:

 

[PrestaShopDatabaseException]

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 ') ENGINE=InnoDB DEFAULT CHARSET=utf8' at line 13
 

CREATE TABLE IF NOT EXISTS `ps_fedex_cache` (
             `id_fedex_cache` int(10) NOT NULL AUTO_INCREMENT,
             `id_cart` int(10) NOT NULL,
             `id_carrier` int(10) NOT NULL,
             `hash` varchar(32) NOT NULL,
             `id_currency` int(10) NOT NULL,
             `total_charges` double(10,2) NOT NULL,
             `is_available` tinyint(1) NOT NULL,
             `date_add` datetime NOT NULL,
             `date_upd` datetime NOT NULL,
             PRIMARY KEY (`id_fedex_cache`),
             KEY `id_cart` (`id_cart`,`id_carrier`,`hash`),
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
at line 613 in file classes/db/Db.php

 

607.             WebserviceRequest::getInstance()->setError(500, '

 '.$this->getMsgError().'. From '.(isset($dbg[3]['class']) ? $dbg[3]['class'] : '').'->'.$dbg[3]['function'].'() Query was : '.$sql, 97);
608.         }
609.         else if (_PS_DEBUG_SQL_ && $errno && !defined('PS_INSTALLATION_IN_PROGRESS'))
610.         {
611.             if ($sql)
612.                 throw new PrestaShopDatabaseException($this->getMsgError().'<br /><br /><pre>'.$sql.'</pre>');
613.             throw new PrestaShopDatabaseException($this->getMsgError());
614.         }
615.     }
616.
617.     /**

• DbCore->displayError - [line 313 - classes/db/Db.php] - [1 Arguments]
  Argument [0]
  CREATE TABLE IF NOT EXISTS `ps_fedex_cache` (
               `id_fedex_cache` int(10) NOT NULL AUTO_INCREMENT,
               `id_cart` int(10) NOT NULL,
               `id_carrier` int(10) NOT NULL,
               `hash` varchar(32) NOT NULL,
               `id_currency` int(10) NOT NULL,
               `total_charges` double(10,2) NOT NULL,
               `is_available` tinyint(1) NOT NULL,
               `date_add` datetime NOT NULL,
               `date_upd` datetime NOT NULL,
               PRIMARY KEY (`id_fedex_cache`),
               KEY `id_cart` (`id_cart`,`id_carrier`,`hash`),
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
• DbCore->query - [line 453 - classes/db/Db.php] - [1 Arguments]
  447.     public function execute($sql, $use_cache = true)
  448.     {
  449.         if ($sql instanceof DbQuery)
  450.             $sql = $sql->build();
  451.
  452.         $this->result = $this->query($sql);
  453.         if ($use_cache && $this->is_cache_enabled)
  454.             Cache::getInstance()->deleteQuery($sql);
  455.         return (bool)$this->result;
  456.     }
  457.
  Argument [0]
  CREATE TABLE IF NOT EXISTS `ps_fedex_cache` (
               `id_fedex_cache` int(10) NOT NULL AUTO_INCREMENT,
               `id_cart` int(10) NOT NULL,
               `id_carrier` int(10) NOT NULL,
               `hash` varchar(32) NOT NULL,
               `id_currency` int(10) NOT NULL,
               `total_charges` double(10,2) NOT NULL,
               `is_available` tinyint(1) NOT NULL,
               `date_add` datetime NOT NULL,
               `date_upd` datetime NOT NULL,
               PRIMARY KEY (`id_fedex_cache`),
               KEY `id_cart` (`id_cart`,`id_carrier`,`hash`),
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
• DbCore->execute - [line 188 - modules/fedexcarrier/fedexcarrier.php] - [1 Arguments]
  Argument [0]
  CREATE TABLE IF NOT EXISTS `ps_fedex_cache` (
               `id_fedex_cache` int(10) NOT NULL AUTO_INCREMENT,
               `id_cart` int(10) NOT NULL,
               `id_carrier` int(10) NOT NULL,
               `hash` varchar(32) NOT NULL,
               `id_currency` int(10) NOT NULL,
               `total_charges` double(10,2) NOT NULL,
               `is_available` tinyint(1) NOT NULL,
               `date_add` datetime NOT NULL,
               `date_upd` datetime NOT NULL,
               PRIMARY KEY (`id_fedex_cache`),
               KEY `id_cart` (`id_cart`,`id_carrier`,`hash`),
          ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
• FedexCarrier->install - [line 675 - controllers/admin/AdminModulesController.php] - [0 Argument]
  669.                         // We check if method of module exists
  670.                             if (!method_exists($module, $method))
  671.                                 throw new PrestaShopException('Method of module can\'t be found');
  672.
  673.                             // Get the return value of current method
  674.                             $echo = $module->{$method}();
  675.
  676.                             // After a successful install of a single module that has a configuration method, to the configuration page
  677.                             if ($key == 'install' && $echo === true && strpos(Tools::getValue('install'), '|') === false && method_exists($module, 'getContent'))
  678.                                 Tools::redirectAdmin(self::$currentIndex.'&token='.$this->token.'&configure='.$module->name.'&conf=12');
  679.                         }
• AdminModulesControllerCore->postProcessCallback - [line 801 - controllers/admin/AdminModulesController.php] - [0 Argument]
  795.                     $ppmReturn = $this->$ppm();
  796.             }
  797.
  798.         // Call appropriate module callback
  799.         if (!isset($ppmReturn))
  800.             $this->postProcessCallback();
  801.
  802.         if ($back = Tools::getValue('back'))
  803.             Tools::redirectAdmin($back);    
  804.     }
  805.
• AdminModulesControllerCore->postProcess - [line 158 - classes/controller/Controller.php] - [0 Argument]
• ControllerCore->run - [line 348 - classes/Dispatcher.php] - [0 Argument]
• DispatcherCore->dispatch - [line 50 - admin-1377027751/index.php] - [0 Argument]