Magento: Cannot add or update a child row: a foreign key constraint fails

I am in the stage of migrating my local database of magento to public when I have encountered this error.

How did it happen:
1.) I use phpmyadmin3.2 to export the sql statements.
2.) In my host mysql's phpmyadmin, I have executed the dump statements.

Leggi tutto...

Magento : errore importazione da db ad un'altro (USING BTREE)

Tonight I was setting up a staging environment for a client of ours so they would have the ability to “visually” interact with the recent data migration our team has performed (OSCommerce to Magento, in case anyone was wondering).

Here’s the error I was receiving:

ERROR 1064 (42000) at line 382: 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 ‘USING BTREE,
 KEY `FK_ATTRIBUTE_VARCHAR_ENTITY` (`entity_id`),
 KEY `FK_CATALO’ at line 9

Leggi tutto...

Magento : installazione ok ma non carica niente nell'admin

Semplicemente cambiare nel php.ini il memory_limit e metterlo a 64M o più.

Magento : cambiare il base_url in seguito a errori da copia del sistema in un altra cartella