After enabling the module every cron run results in a Database error:
pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "," at character 281 i /mnt/data/www-data/laksegruppen.dk/includes/database.pgsql.inc på linje 84.
As far as I can tell the problem is that the query is using a single INSERT statement to insert multiple rows (something which postgresql 8.1 does not support), instead of either inserting one row at a time or inserting multiple rows through some SELECT statement.
Here is the start of the query:
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('2006-09-10', 1157932799,'SU','2SU','-3SU','10','-21','9','253','-113','36','-17'),('2006-09-11', 1158019199,'MO','2MO','-3MO','11','-20','9','254','-112','37','-16'),('2006-09-12', 1158105599,'TU','2TU','-3TU','12','-19','9','255','-111','37','-16'),('2006-09-13', 1158191999,'WE','2WE','-3WE','13','-18','9','256','-110','37','-16'),('2006-09-14', 1158278399,'TH','2TH','-3TH','14','-17','9','257','-109','37','-16'),('2006-09-15', 1158364799,'FR','3FR','-3FR','15','-16','9','258','-108','37','-16'),('2006-09-16', 1158451199,'SA','3SA','-3SA','16','-15','9','259','-107','37','-16'),('2006-09-17', 1158537599,'SU','3SU','-2SU','17','-14','9','260','-106','37','-16').
| Comment | File | Size | Author |
|---|---|---|---|
| #1 | eventrepeat_cron.patch | 1.14 KB | seanbfuller |
Comments
Comment #1
seanbfuller commentedHere's a patch that should fix this for cvs. You should be able to also manually apply it for 4.7. I don't currently have access to a postgresql setup to test it.
Comment #2
seanbfuller commentedComment #3
gathond commentedThanks, this seems to solve the issue.
However I ran into several more later, I'll look into those when I get a chance.
Comment #4
seanbfuller commentedCommitted to HEAD
Comment #5
(not verified) commented