Page 1 of 1

CGCalendar Category Limit?

Posted: Wed Jul 16, 2014 6:23 pm
by cpansewicz
Hi,

Is there a limit on the number of categories that you can add in CGCalendar? I have 30 categories, and would like to add several more, but am unable to.

Thank you,
Camille

Re: CGCalendar Category Limit?

Posted: Wed Jul 16, 2014 7:17 pm
by chandra
Normally there should be no limit.

Activate debug option inside config.php. So you will get a lot of information and the trouble maker too.

Re: CGCalendar Category Limit?

Posted: Wed Jul 16, 2014 7:59 pm
by cpansewicz
Thank you. When I run debug mode, I get a list of all my categories in the format of:

"Debug: (0.171054) - (usage: 12897124) - (peak: 12979548)
(mysql): UPDATE cms_module_cgcalendar_categories
SET category_name = 'Young Alumni', category_order = 31
WHERE category_id = 5"

>>>etc<<<

With the last category saying:

"Debug: (0.171984) - (usage: 12898144) - (peak: 12980316)

(mysql): INSERT INTO cms_module_cgcalendar_categories
(category_id, category_name, category_order)
VALUES (30,'RSVP',32)
Error (1062): Duplicate entry '30' for key 'PRIMARY'"

How would I go about fixing this?

Thank you,
Camille

SOLVED: CGCalendar Category Limit?

Posted: Wed Jul 16, 2014 8:07 pm
by cpansewicz
Thank you for your response. I am not sure why this fixed the issue, but I deleted all the values in the "Order" column, and clicked on "Update Categories". This reset all the order values to "0", and I am now able to add Categories again.