CODEWITHSUNDEEP
magento-1.7magento
Tim Sajt
Tim Sajt

Reputation: 117

Magento: Item (Mage_Sales_Model_Order) with the same id "1" already exist

After I migrate my Magento shop from one hosting provider to another one. Before I start to migrate a delete all my test orders and put counter of order number to 0. I have big problem. When I want to go in back office into sales->order I get an error "There has been an error processing your request Exception printing is disabled by default for security reasons. Error log record number: 213759415"

If I go into var/report and open file "213759415" I see 36 lines the first one are:

a:5:{i:0;s:64:"Item (Mage_Sales_Model_Order) with the same id "1" already exist";i:1;s:5345:"#0 /usr/home/xxx/domains/xxx.com/public_html/lib/Varien/Data/Collection/Db.php(576): Varien_Data_Collection->addItem(Object(Mage_Sales_Model_Order))

I have Magento 1.7.0.2

Any ideas?

Many thanks!

Upvotes: 0

Views: 4708

Answers (2)

Tim Sajt
Tim Sajt

Reputation: 117

I found in db, tabel called "onestepcheckout" where I forgot to delete test orders.

Upvotes: 1

pzirkind
pzirkind

Reputation: 2338

Make sure you properly deleted all test orders.

You can use the following module to do this:

http://www.magentocommerce.com/magento-connect/asperience-deleteorders.html

Upvotes: 0

Related Questions