Primary index of jevents_repetition out of range
By xvb201 on Thursday, 14 December 2023
Posted in JEvents (Free Access)
Replies 3
Likes 0
Views 453
Votes 0
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.
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



ALTER TABLE XXXXX_jevents_repetition MODIFY COLUMN rp_id BIGINT NOT NULL auto_increment


replacing XXXXX with your prefix
geraint
·
11 months ago
·
0 Likes
·
1 Votes
·
0 Comments
·
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?
xvb201
·
11 months ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Big int covers you up to 2^63-1 which is > 9,000,000,000,000,000,000 - you should be safe
geraint
·
11 months ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post