Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options not deleted user 27229

Questions related to Magento's MySQL database, for example, the table schema, plain SQL queries or database configuration. For questions about the Magento database access layer, use other tags, like: eav, model, resource-model, collections, install-script. For questions about SQL queries in particular, the SQL tag is appropriate too.

0 votes
1 answer
308 views

Indexer Issue // DB CONSTRAINT

I am getting following Error on reindexing: Product Attributes index process unknown error: exception 'PDOException' with message 'SQLSTATE[23000]: Integrity constraint violation: 1452 Ca …
Bernhard Prange's user avatar
0 votes
1 answer
214 views

MYSQL Syntax Error [closed]

On Magento 1.9.2.4 I'm using a plugin wich pulls ekomi ratings. On some articles I throws follwoing exception: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your S …
Bernhard Prange's user avatar
2 votes
1 answer
770 views

Trouble reindexing - forgein key constrain fails

catalog_product_index_eav`, CONSTRAINT `FK_CAT_PRD_IDX_EAV_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCA)' How can I repiar the database
Bernhard Prange's user avatar
1 vote

Trouble reindexing - forgein key constrain fails

I was looking around a litte - not so easy to find but here is a solution: https://stackoverflow.com/questions/8111889/cant-re-index-new-products-after-upgrading-to-version-1-6/19837851#19837851
Bernhard Prange's user avatar
0 votes

Importing Products to New Magento Installation - Help

Copy your current database for testing purposes Set you local.xml in the new location for the copied database See what happens? …
Bernhard Prange's user avatar
1 vote
2 answers
200 views

Workflow for Magento Database

But how to manage Database modifications? While on the live server there is new customer data I have new configuration & product data in the staging system. …
Bernhard Prange's user avatar