Magento 1.9 – How to Solve SQLSTATE[42000]: Syntax Error or Access Violation: 1142 INSERT Error

The model object does not hold any data besides the ID. Magento does not expect this and still tries to build an update query, which is invalid as you can see in the error message:

UPDATE magic_test SET WHERE (order_id='8606')
                     ^
                    !!!

Further clarification: you specified the primary key order_id as "id column" in Magento. An object with a non empty ID is treated as an existing database entry which needs to be updated. An insert only happens if the ID is null.

You should add a second column "id" as artificial primary key which you specify as id column in your model class.

you have syntax error ' . $prodNameAttrId . '' try this query..

   $collection->getSelect()
                ->joinLeft(
                        array('prod' => 'catalog_product_entity'), 'prod.entity_id = main_table.product_id', array('sku')
                )->joinLeft(
                array('cpev' => 'catalog_product_entity_varchar'), 'cpev.entity_id=main_table.product_id AND cpev.attribute_id="' . $prodNameAttrId . '"', array('name' => 'value')
        );