Makingware安装提出错,缺少一个表directory_country_area_name

macgroup 发布于 2011/03/23 14:48
阅读 489
收藏 1

系统 win7 64位,apache2.2.17+php5.2.17+Mysql 5.5.9

 

建表时就提示:

There has been an error processing your request

Exception printing is disabled by default for security reasons.

Error log record number: 1438673921

 

打开var/report/1438673921文件,内容如下:

 

a:5:{i:0;s:221:"Error in file: "F:\web\markingware\app\code\core\Mage\Directory\sql\directory_setup\mysql4-install-0.8.0.php" - SQLSTATE[HY000]: General error: 1005 Can't create table 'makingware.directory_country_area_name' (errno: 150)";i:1;s:902:"#0 F:\web\markingware\app\code\core\Mage\Core\Model\Resource\Setup.php(374): Mage::exception('Mage_Core', 'Error in file: ...')
#1 F:\web\markingware\app\code\core\Mage\Core\Model\Resource\Setup.php(260): Mage_Core_Model_Resource_Setup->_modifyResourceDb('install', '', '0.8.10')
#2 F:\web\markingware\app\code\core\Mage\Core\Model\Resource\Setup.php(224): Mage_Core_Model_Resource_Setup->_installResourceDb('0.8.10')
#3 F:\web\markingware\app\code\core\Mage\Core\Model\Resource\Setup.php(153): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 F:\web\markingware\app\code\core\Mage\Core\Model\App.php(363): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 F:\web\markingware\app\code\core\Mage\Core\Model\App.php(295): Mage_Core_Model_App->_initModules()
#6 F:\web\markingware\app\Mage.php(600): Mage_Core_Model_App->run(Array)
#7 F:\web\markingware\index.php(78): Mage::run('', 'store')
#8 {main}";s:3:"url";s:48:"/markingware/index.php/install/wizard/installDb/";s:11:"script_name";s:22:"/markingware/index.php";s:4:"skin";s:7:"default";}

 

应该是少一张表。
phpmyadmin中也看不到这张表



加载中
0
FLYING
FLYING

是新安装还是重新安装?

0
0
蟋蟀哥哥
蟋蟀哥哥

重新安装..

   更改php.ini  把max time的时间设置大点.

可能是安装的时候表不全

0
FLYING
FLYING

安装过程中有没有超时?

我这里安装没有出现这个情况……

0
WickyHe
WickyHe

我也出现同样问题。。。

0
WickyHe
WickyHe

打开mysql4-install-0.8.0.php 发现

 

 

 DROP TABLE IF EXISTS `{$installer->getTable('directory_country_area_name')}`;

CREATE TABLE `{$installer->getTable('directory_country_area_name')}` (

  `locale` varchar(8) NOT NULL default '',

  `area_id` mediumint(8) unsigned NOT NULL default '0',

  `name` varchar(64) NOT NULL default '',

  PRIMARY KEY  (`locale`,`area_id`),

  KEY `FK_DIRECTORY_AREA_NAME_AREA` (`area_id`),

  CONSTRAINT `FK_DIRECTORY_AREA_NAME_AREA` FOREIGN KEY (`area_id`) REFERENCES {$installer->getTable('directory_country_area_name')} (`area_id`) ON DELETE CASCADE ON UPDATE CASCADE

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Areas names';

 

 

REFERENCES {$installer->getTable('directory_country_area_name')} (`area_id`) 晕倒。。。。
OSCHINA
登录后可查看更多优质内容
返回顶部
顶部