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

You have to go to your DB and enter in the core_config_data table.

Under this table you have to find under the path column

web/unsecure/base_url and web/secure/base_url

and edit the value column with the correct url {{base url}} or with the Url of your magento (ex. http://www.yoursite.com)

Oppure cambiarli nell'admin sotto "Sistema > Configurazione > Web" in "Sicuro" e in "Insicuro"

Site Search

Who's Online

Abbiamo 15 visitatori e nessun utente online

Stats

Visite agli articoli
167724
banner mym
banner mym