Database Query Error

I am trying to add Quotes from Admin Section. I have already added around 210 quotes. But now when I am trying to add more it gives me an error "Database query error". Rest all sections are working fine like I can add the Articles perfectly.

Another Thing I would like to know how many quotes I can add, is there any limit.

Thanks

The quotes ID field is of type unsigned tinyint which means the maximum value of the ID can be 255. So my guess is you have hit that limit. Because it is a auto incremented field with a index, when a quote is deleted, it does not free up the ID. So even if you only have 210 quotes, the ID may still be at it's maximum due to previously deleted records.

You should be able to increase it by running the following query in phpMyAdmin

ALTER TABLE `bx_quotes_units` CHANGE `ID` `ID` INT UNSIGNED NOT NULL AUTO_INCREMENT ;

That should allow for the max unsigned int value of 4294967295 which should be more than enough.


I am sure boonex set such a low limit as i don't think anyone has ever exceeded it before. Even i cannot understand why you would need so many.

Thanks for the solution.

Well I do have a collection of Great Quotes given by Great people, which they observed, experienced in thier life. I just want to share them with the people on my site. Have a look at helpmyindia.com

Thank you for pointing this out:

http://www.boonex.com/trac/dolphin/ticket/3465