Black Cat
Total Posts: 686Joined: 2008-02-14
Hi.
File Attachments
Signature
Cerchi un Webdesigner o grafico per Magento? Contattami
Maintainer Traduzione Italiana
-------------My Blog --------------
Posted: March 20 2008
| top
UltraFlux
Total Posts: 38Joined: 2008-03-05
Well just by looking at the code it looks like something is wrong with MySQL
SQLSTATE[HY000]: General error: 1005 Can’t create table
Verify MySQL is setup properly, you have correct perms to create a table, enter the correct details into the config.
Posted: March 20 2008
| top
| # 1
Black Cat
Total Posts: 686Joined: 2008-02-14
I have already verified the data yet they are all correct ones..
Signature
Cerchi un Webdesigner o grafico per Magento? Contattami
Maintainer Traduzione Italiana
-------------My Blog --------------
Posted: March 20 2008
| top
| # 2
Garrone
Total Posts: 89Joined: 2007-11-03
I also got an PDOException Object on a fresh install.
Signature
La Compagnia del Cavatappi, Prodotti Tipici , vini e Vendita Vini .
Agriturismo in Italia visita Vacanze in Agriturismo .
Posted: March 20 2008
| top
| # 3
Black Cat
Total Posts: 686Joined: 2008-02-14
the problem is that there is not any database… and the installation more than 2-3 minutes +
Signature
Cerchi un Webdesigner o grafico per Magento? Contattami
Maintainer Traduzione Italiana
-------------My Blog --------------
Posted: March 20 2008
| top
| # 4
Rowd
Total Posts: 31Joined: 2007-12-08
@Black Cat
created an issue report about it. The fix is simple, you just need to change the order of the CREATE statements.
First open file ./app/code/core/Mage/Core/sql/core_setup/mysql4-install-0.8.0.php
Then change the order of the CREATE statements for the tables core_layout_link and core_layout_update so that core_layout_update is first.
Below is how those two statements should be.
-- DROP TABLE IF EXISTS ` {$installer -> getTable('core_layout_update')} `; CREATE TABLE ` {$installer -> getTable('core_layout_update')} ` ( layout_update_id ` int ( 10 ) unsigned NOT NULL auto_increment , handle ` varchar ( 255 ) default NULL , xml ` text , PRIMARY KEY (` layout_update_id `), KEY ` handle ` (` handle `) ENGINE = InnoDB DEFAULT CHARSET = utf8 ; DROP TABLE IF EXISTS ` {$installer -> getTable('core_layout_link')} `; CREATE TABLE ` {$installer -> getTable('core_layout_link')} ` ( layout_link_id ` int ( 10 ) unsigned NOT NULL auto_increment , store_id ` smallint ( 5 ) unsigned NOT NULL default '0' , package ` varchar ( 64 ) NOT NULL default '' , theme ` varchar ( 64 ) NOT NULL default '' , layout_update_id ` int ( 10 ) unsigned NOT NULL default '0' , PRIMARY KEY (` layout_link_id `), UNIQUE KEY ` store_id ` (` store_id `,` package `,` theme `,` layout_update_id `), KEY ` FK_core_layout_link_update ` (` layout_update_id `), CONSTRAINT ` FK_CORE_LAYOUT_LINK_STORE ` FOREIGN KEY (` store_id `) REFERENCES ` {$installer -> getTable('core_store')} ` (` store_id `) ON DELETE CASCADE ON UPDATE CASCADE , CONSTRAINT ` FK_core_layout_link_update ` FOREIGN KEY (` layout_update_id `) REFERENCES ` {$installer -> getTable('core_layout_update')} ` (` layout_update_id `) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE = InnoDB DEFAULT CHARSET = utf8 ;
That worked for me, let us know if it solves the issue for you too.
Posted: March 20 2008
| top
| # 5
Flowstack
Total Posts: 130Joined: 2008-01-30
Thanks Rowd.
Your fix worked for me. No idea why
Still strange why it was telling me a table existed in the database when it clearly didn’t.
EDIT: I Spoke too soon. It now says another table already exists :(.
Posted: March 20 2008
| top
| # 6
scend
Total Posts: 13Joined: 2008-02-20
I’ve had the same installation problem on Linux/Red Hat Enterprise, although mine appears to be with; app/code/core/Mage/Catalog/sql/catalog_setup/mysql4-upgrade-0.7.26-0.7.27.php
NOTES: Previously had 0.8x installed and running fine, I removed everything to start from scratch. I have now posted a bug report.
Posted: March 20 2008
| top
| # 7
Howard
Total Posts: 14Joined: 2008-03-21
I am getting a similar error when trying to install 0.9.17740 on fedora core. If you look, my error is referencing Syntax error or access violation. I am using mysql 5.0.45 and was able to install the previous version of Magenta without any issues. I appreciate any advice anyone might have about this issue.
Thanks,
File Attachments
Posted: March 21 2008
| top
| # 8
atlantide
Total Posts: 160Joined: 2008-02-16
I have the same error.
I tried to change the order of the CREATE statements for the tables core_layout_link and core_layout_update so that core_layout_update is first, but that didn’t work. Any idea ?
Posted: March 21 2008
| top
| # 9
Moshe
Total Posts: 1771Joined: 2007-08-07
@Howard: you are getting this error because you put invalid character into table prefix during install wizard. Please use underscore instead of dash.
@atlantide: need more details, such as the error message text.
Signature
- I would love to change the world, but they won’t give me the source code -
Howard
Total Posts: 14Joined: 2008-03-21
@Moshe - You were right on. I should have caught that. Thank you for the quick and kind reply.
Howard
atlantide
Total Posts: 160Joined: 2008-02-16
I tried again to reinstall. Here is my configuration :
php5.ini with :
php_flag short_open_tag on
.htaccess with added :
SetEnv DEFAULT_PHP_VERSION 5
CHMOD :
/Magento 755
mysql4-install-0.8.0.php :
-- DROP TABLE IF EXISTS `{$installer->getTable(’core_layout_update’)}`;
before
-- DROP TABLE IF EXISTS `{$installer->getTable(’core_layout_link’)}`;
After setting the database info, I get the PDOException Object error…
any idea ?
File Attachments
beau
Total Posts: 34Joined: 2008-02-03
I have the same error. I modified my install file like suggested but still get the error.
File Attachments
atlantide
Total Posts: 160Joined: 2008-02-16
Thank you for that answer, but how to proceed in phpMyAdmin ?
.
Sales: Call 800.374.8146 (N America)|757.278.0920 (International)
