Cron error
| Project: | Event Repeat |
| Version: | 5.x-2.x-dev |
| Component: | Miscellaneous |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
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!
#1
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
#2
going to assume it was a 1 time thing. Marking this as fixed.
Thanks
Robert
#3
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...
#4
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.
#5
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
#6
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
#7
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"
#8