0
Undo
Votes
When importing repeated events (via iCal) it creates a new entry in the table jevents_repetition. With this the primary key is auto incremented. Eventually this value reached the limit of the INT value and gives the error "167 Out of range value for column 'rp_id' at row 1". Can this be fixed, because no new repeated events can be created because of this.
xvb201
set the post as Critical priority — 11 months ago
I'll increase this to a bigint in the next release - you must have a LOT of repeats on your site to hit that limit!
In the meantime you can apply this SQL fix in PhpMyAdmin on your webhost
replacing XXXXX with your prefix
In the meantime you can apply this SQL fix in PhpMyAdmin on your webhost
ALTER TABLE XXXXX_jevents_repetition MODIFY COLUMN rp_id BIGINT NOT NULL auto_increment
replacing XXXXX with your prefix
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
Thank you for the reply. This solutions works. 
My feeling is that this will only work till the max value of this BIGINT is reached.
What is important to know is that a new 'rp_id' is created when I update a iCal calendar which contains a repeated event. Because is update this every 5 minutes (to keep everything in sync), eventually the 'rp_id' will reach it limit. Is there a way to "reuse" unused rp_id's?
My feeling is that this will only work till the max value of this BIGINT is reached.
What is important to know is that a new 'rp_id' is created when I update a iCal calendar which contains a repeated event. Because is update this every 5 minutes (to keep everything in sync), eventually the 'rp_id' will reach it limit. Is there a way to "reuse" unused rp_id's?
Big int covers you up to 2^63-1 which is > 9,000,000,000,000,000,000 - you should be safe
JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!
- Page :
- 1
There are no replies made for this post yet.