Yesterday, I changed the repeat prefix from "[R]" to "* " and updated one or two repeated events "this occurrence only". This morning, I got the following cron error:

Warning: Duplicate entry '1379635199' for key 1
query: INSERT INTO event_repeat_calendar_map (day_stamp, date_stamp, day_of_week, day_in_month,
day_in_month_R, month_day ,month_day_R, month, year_day, year_day_R, week_number, week_number_R) VALUES('2013-09-19', 1379635199,'TH','3TH','-2TH','19','-12','9','262','-104','38','-15') in /home/username/public_html/subdir/includes/database.mysql.inc on line 121

No idea what that's all about? Any ideas? ("username" is my sign-on at HostGator and "subdir" is the drupal installation subdirectory. Running drupal 5.7. First line of module reads:
// $Id: eventrepeat.module,v 1.50.2.7 2007/06/06 22:55:30 seanfuller Exp $
)

Thanks!

Comments

seanbfuller’s picture

seanbfuller commented

Are you still getting these or was this a one time thing?

If it is still happening, you might want to try reseting the map at admin/settings/eventrepeat/reset

rmiddle’s picture

rmiddle commented
Status: Active » Fixed

going to assume it was a 1 time thing. Marking this as fixed.

Thanks
Robert

Rasputin Paracelsus’s picture

Rasputin Paracelsus commented

Actually... one can't necessarily conclude that. It happened last March, and coincidentally I have not used that feature since. So it is very unlikely that it was one-time-only or that it somehow "fixed" itself.

I have no real need to use it now either (as there are no events going on) so it's not pressing for me, though...

socialnicheguru’s picture

socialnicheguru commented
Version: 5.x-1.x-dev » 5.x-2.x-dev

i got this today:

user warning: Duplicate entry '2014-05-24 23:59:59' for key 1 query: INSERT INTO event_repeat_calendar_map (date, day_of_week, day_in_month, day_in_month_R, month_day ,month_day_R, month, year_day, year_day_R, week_number, week_number_R) VALUES('2014-05-24 23:59:59','SA','4SA','-2SA','24','-8','5','144','-222','21','-32') in /var/www/vhosts/mysite.com/httpdocs/drupal/includes/database.mysql.inc on line 174.

rmiddle’s picture

rmiddle commented
Status: Fixed » Postponed

Ok I will put this in queue of things to check. It sounds like a one time thing when you change so it shouldn't repeat itself.

Thanks
Robert

c4marcus’s picture

c4marcus commented

Hello - We are receiving the "Duplicate entry" 6 times everyday at 7:01 pm. It appears to try and add duplicate entries for 6 different days. For example, it is trying for 2000 days out and the errors are currently for October 2nd through October 6th.

Duplicate entry '2014-10-07 23:59:59' for key 1 query: INSERT INTO event_repeat_calendar_map (date, day_of_week, day_in_month, day_in_month_R, month_day ,month_day_R, month, year_day, year_day_R, week_number, week_number_R) VALUES('2014-10-07 23:59:59','TU','1TU','-4TU','7','-25','10','280','-86','41','-12') in /httpdocs/includes/database.mysql.inc on line 174.

Edit Note: I forgot to supply version numbers

Drupal 5.15
Event 5.x-2.x-dev
Event Repeat 5.x-2.x-dev

landike’s picture

landike commented

THE SAME. Drupal5.5 on PostgreSQL.

I've fixed it by changing in
eventrepeat_cron(){

if ($start['MAX(date_stamp)']) {
$start = $start['MAX(date_stamp)'];
}

to

if ($start['max']) {
$start = $start['max'];
}

}

Looks like on Mysql this is not issue, cause this database server return @MAX(date_stamp)'@ as in query and PostgreSQL return alias "max"

landike’s picture

landike commented
Status: Postponed » Active
oadaeh’s picture

oadaeh commented
Status: Active » Closed (won't fix)

This issue is being closed due to age and/or version. If this issue is still valid, please reopen it against the 6.x-1.x branch and update it. There will be no more follow ups against the 5.x branches.