Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Weird Catalog Rules—only one entry in catalogrule_product_price
 
Orstio
Jr. Member
 
Total Posts:  16
Joined:  2010-11-25
 

Magento 1.6.1.0

When I add a new catalog rule, only the first product affected by the rule gets entered into the catalogrule_product_price table.  The catalogrule_product table has over 2000 rows in it, however.

Any idea as to what is going wrong in the entries?

 
Magento Community Magento Community
Magento Community
Magento Community
 
Orstio
Jr. Member
 
Total Posts:  16
Joined:  2010-11-25
 

I figured it out—The table auto-increment had reached 4294967295, which is the largest value for int(10).  Resetting it to 0 fixed the problem.

 
Magento Community Magento Community
Magento Community
Magento Community
 
christianjung
Jr. Member
 
Total Posts:  6
Joined:  2011-02-15
 
Orstio - 12 September 2012 05:53 PM

I figured it out—The table auto-increment had reached 4294967295, which is the largest value for int(10).  Resetting it to 0 fixed the problem.

Saved my life! Thanks!

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top