Need help with Joomla? We are available for hire to help with Joomla customization, upgrades, maintenance, and custom development.
Explore our services

Recurring event changes the time on day 11 onwards

More
11 years 10 months ago #51872 by Marcus
i succeeded with the MySQL Statement:

UPDATE `[DB_PREFIX]_eb_events` SET `event_date` = DATE_ADD(`event_date`, INTERVAL 1 HOUR)

if you want to go in the other direction, use DATE_SUB() Function, This adds one hour to every event - in case you dont like it, you have to limit the query.

USE ON OWN RISK - BACKUP FIRST. :-)

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc