Diagnosing mxCalendar SQL Errors When Creating Events

If mxCalendar creates categories and saves configuration correctly but fails the moment you add an event, the database insert statement is usually the real problem. In the original report, creating an event produced a syntax error around field names such as repeat and other occurrence-related columns.

That is a classic compatibility warning: a module field name or generated query is colliding with SQL parsing rules or with changes in the environment.

What to check

• inspect the full failing INSERT statement,
• look for reserved words such as repeat,
• check whether the module expects a slightly different table schema than the one currently installed,
• verify the database server version after a hosting move or VPS migration.

In these cases, the module may have worked on one host and then failed on another because the SQL parser is stricter or the schema was created by an older release. The right fix is to align table structure and query syntax, not to keep retrying the same broken insert.

As soon as you capture the exact query, mxCalendar problems become far easier to solve than they first appear.