search

tzyganu / m2-sample-data

Magento2SamepleData
MIT License
20 stars 7 forks source link

Column not found: 1054 Unknown column 'main_table.website_id' in 'where clause' #3

Closed PrakashThapa closed 9 years ago

PrakashThapa commented 9 years ago

I got issue after using this sample data Column not found: 1054 Unknown column 'main_table.website_id' in 'where clause' What can be the causes? thanks.

tzyganu commented 9 years ago

@PrakashThapa. Thanks for the report. To help me solve this issue please answer these questions:

quynhvv commented 9 years ago

@tzyganu: I have take the same issue, when i try edit a product in back-end.

tzyganu commented 9 years ago

@quynhvv @PrakashThapa. I've identified the problem. The fix will be available soon.

tzyganu commented 9 years ago

@PrakashThapa @quynhvv This should be fixed in the new version. Thanks for your help. If you spot other errors throw them in here.

quynhvv commented 9 years ago

@tzyganu : I have download the latest m2sample.sql, when i import to my database, i get a error: [Err] 1065 - Query was empty [Err] ; [Msg] Finished - Unsuccessfully I have detect & see a issue at line 2104, you are wrong with two ';' at end of SQL command. Please check it again. Thanks.

tzyganu commented 9 years ago

@quynhvv. Thanks. I fixed it. It seams that the tool I'm using for restoring the db ignores these double semicolons.

quynhvv commented 9 years ago

@tzyganu: You are well come! My Skype id is "quynh.vv" can we chat more via Skype?

quynhvv commented 9 years ago

@tzyganu: When i try edit information of a Product in back-end and come back to Products list page, i get a error as bellow: a:4:{i:0;s:85:"Item (Magento\Catalog\Model\Product\Interceptor) with the same id "166" already exist";i:1;s:7689:"#0 C:\wamp\www\mage2\app\code\Magento\Eav\Model\Entity\Collection\AbstractCollection.php(306): Magento\Framework\Data\Collection->addItem(Object(Magento\Catalog\Model\Product\Interceptor))

1 C:\wamp\www\mage2\app\code\Magento\Eav\Model\Entity\Collection\AbstractCollection.php(1100): Magento\Eav\Model\Entity\Collection\AbstractCollection->addItem(Object(Magento\Catalog\Model\Product\Interceptor))

2 C:\wamp\www\mage2\app\code\Magento\Eav\Model\Entity\Collection\AbstractCollection.php(904): Magento\Eav\Model\Entity\Collection\AbstractCollection->_loadEntities(false, false)

3 C:\wamp\www\mage2\app\code\Magento\Backend\Block\Widget\Grid\Extended.php(476): Magento\Eav\Model\Entity\Collection\AbstractCollection->load()

4 C:\wamp\www\mage2\app\code\Magento\Catalog\Block\Adminhtml\Product\Grid.php(204): Magento\Backend\Block\Widget\Grid\Extended->_prepareCollection()

5 C:\wamp\www\mage2\app\code\Magento\Backend\Block\Widget\Grid.php(409): Magento\Catalog\Block\Adminhtml\Product\Grid->_prepareCollection()

6 C:\wamp\www\mage2\app\code\Magento\Backend\Block\Widget\Grid\Extended.php(503): Magento\Backend\Block\Widget\Grid->_prepareGrid()

7 C:\wamp\www\mage2\app\code\Magento\Backend\Block\Widget\Grid.php(470): Magento\Backend\Block\Widget\Grid\Extended->_prepareGrid()

8 C:\wamp\www\mage2\lib\internal\Magento\Framework\View\Element\AbstractBlock.php(651): Magento\Backend\Block\Widget\Grid->_beforeToHtml()

9 C:\wamp\www\mage2\lib\internal\Magento\Framework\View\Layout.php(468): Magento\Framework\View\Element\AbstractBlock->toHtml()

10 C:\wamp\www\mage2\lib\internal\Magento\Framework\View\Layout.php(444): Magento\Framework\View\Layout->_renderBlock('product.grid')

Can you tell me, how to resolve it? Thanks.

tzyganu commented 9 years ago

@quynhvv This should be fixed now.

quynhvv commented 9 years ago

@tzyganu Thank you so much!