Magento

I cannot seem to complete a clean install. I could install and run when I inserted the demo store, but I don’t want all that in my site.
I am using MAMP Php version 5.2.5
I am getting this at the end of the error file.
Any insights?

[12] => Array
(
[file] => /Applications/MAMP/htdocs/shop/shop/index.php
[line] => 46
[function] => run
[class] => Mage
[type] => ::
[args] => Array
(
)

)

)

[errorInfo] => Array
(
[0] => HY000
[1] => 1005
[2] => Can’t create table ‘./shop_shop/#sql-9df_38.frm’ (errno: 121)
)

)

Error in file: “/Applications/MAMP/htdocs/shop/shop/app/code/core/Mage/Core/sql/core_setup/mysql4-install-0.8.0.php” - SQLSTATE[HY000]: General error: 1005 Can’t create table ‘./shop_shop/#sql-9df_38.frm’ (errno: 121)

#0 /Applications/MAMP/htdocs/shop/shop/app/code/core/Mage/Core/Model/Resource/Setup.php(280): Mage::exception(’Mage_Core’, ‘Error in file: ...’)
#1 /Applications/MAMP/htdocs/shop/shop/app/code/core/Mage/Core/Model/Resource/Setup.php(160): Mage_Core_Model_Resource_Setup->_modifyResourceDb(’install’, ‘’, ‘0.8.8’)
#2 /Applications/MAMP/htdocs/shop/shop/app/code/core/Mage/Core/Model/Resource/Setup.php(148): Mage_Core_Model_Resource_Setup->_installResourceDb(’0.8.8’)
#3 /Applications/MAMP/htdocs/shop/shop/app/code/core/Mage/Core/Model/Resource/Setup.php(114): Mage_Core_Model_Resource_Setup->applyUpdates()
#4 /Applications/MAMP/htdocs/shop/shop/app/code/core/Mage/Core/Model/Config.php(209): Mage_Core_Model_Resource_Setup::applyAllUpdates()
#5 /Applications/MAMP/htdocs/shop/shop/app/code/core/Mage/Core/Model/App.php(230): Mage_Core_Model_Config->init(Array)
#6 /Applications/MAMP/htdocs/shop/shop/app/Mage.php(397): Mage_Core_Model_App->init(’’, ‘store’, Array)
#7 /Applications/MAMP/htdocs/shop/shop/app/Mage.php(416): Mage::app(’’, ‘store’, Array)
#8 /Applications/MAMP/htdocs/shop/shop/index.php(46): Mage::run()
#9 {main}

I ran the magento-check.php. I don’t understand why it is telling me I need 4.1.2 or greater when I am running 5.2

Your server does not meet the following requirements in order to install Magento.
The following requirements failed, please contact your hosting provider in order to receive assistance with meeting the system requirements for Magento:

* You need MySQL 4.1.20 (or greater)

The following requirements were successfully met:

* You have PHP 5.2.0 (or greater)
* Safe Mode is off
* You have the curl extension
* You have the dom extension
* You have the gd extension
* You have the hash extension
* You have the iconv extension
* You have the mcrypt extension
* You have the pcre extension
* You have the pdo extension
* You have the pdo_mysql extension
* You have the simplexml extension

I had a similar problem on an install. It turns out I did not have php-mhash installed.

Just for grins, here are my notes for getting an ubuntu 8.10 system configured.
YMMV…

Inside ‘/etc/php5/apache2/php.ini’, at the bottom, add the following lines:

I gues it somethik like described here: Magento SQL exception problem

@kurtb : Thanks! These were the packages I needed (at least to get further through the install process)

Now I’m just getting a blank page at http://mypc/magento/index.php/install/wizard/configPost/ Last I installed Magento, i didn’t run into nearly so many obstacles…

I’ve got exactly the same issues with Magento.
Does anybody know, which of the versions before worked fine without these annoying problems from the install on?

I’m a novice to Magento and not sure if this is the right place to reply and haven’t got it figured exactly yet, but there were two things wrong for me with Magento for running upgrade

/app/code/core/Mage/Core/sql/core_setup/mysql4-upgrade-0.8.12-0.8.13.php

1.) It seems to me there’s small errors --that are probably taken care of before this actually matters-- in

/app/code/core/Mage/Core/Model/Resource/Setup.php->startSetup() and
/app/code/core/Mage/Core/Model/Resource/Setup.php->endSetup()

startSetup() should begin

endsetUp() should always set ‘FOREIGN_KEY_CHECKS’ to 1 (not 0), so that should read

2.) Most importantly, the install-script ‘magento_sample_data_for_1.1.2.sql’ delivers plain tables (without prefix!) >> you can’t use a table-prefix in the install-procedure, if you used the install-sample-script to setup the database (...).
However; I deleted the database, made a new one without samples and re-called [my-magento-site]/install.php and the tables where created from scratch with the prefix and all worked out. (no samples though...)
I’m not sure how and why this half-worked; probably the install-parameters were already stored somewhere, and Magento can install without the sample-data SQL? (contrary to what the install-guidelines made me believe ;/ )

anyway: I’m up-n-running now, so hope this helps somebody.

come to think: there might very well be something wrong with the way the last upgrade in

/app/code/core/Mage/Core/sql/core_setup/

is handled in the initial Magento-install… I had the exact same error with clean install for upgrade to ‘0.8.13’ (currently the last upgrade) that cathyka had with ‘0.8.8’.
My bet is that ‘0.8.8’ was the last upgrade there aswell ...?

Had same problem here and found the solution only by doing the following:

Before running the install.php wizard,
download the sample_data sql file and dump it into your database.
This creates all needed tables without error. it seems that the error above appears only if the database migration is performed by the provided php scripts.

this approach does not allow to use prefixes for your tables. so do not enter anything into the prefix field in the wizard.

greetings

Really nice answer is here:
http://www.magentocommerce.com/boards/main.php/viewreply/233742/

And I have nothing to add

You can also check the following thread:
http://www.magentocommerce.com/boards/viewthread/13074/

I’ve moved a fresh magento install from local computer to remote server and worked fine.