Mod_simplecalendar update fails with an sql-error

  • IT-grufti
  • IT-grufti's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
4 years 3 months ago #279 by IT-grufti
IT-grufti created the topic: Mod_simplecalendar update fails with an sql-error
Hi Fabrizio,
I just installed the actual update to Mod_simplecalendar. Starting the frontend failed with the following error-message (The Module is placed at the homepage):

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY a.start_dt ASC, a.start_time ASC LIMIT 5' at line 5 SQL=SELECT a.*,CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END AS catslug FROM qcpwr_simplecalendar AS a LEFT JOIN qcpwr_categories AS c ON c.id = a.catid WHERE ( a.state = 1 and a.start_dt >= CURDATE() ) AND a.state = 1 AND a.access IN (1,5) AND c.access IN ( 1,5) AND ORDER BY a.start_dt ASC, a.start_time ASC LIMIT 5 (http://localhost/intranet3/)

When I made a rollback to the older version all works well.

Rolf

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

Time to create page: 0.285 seconds
Powered by Kunena Forum