We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 51280
    • 2 Posts
    I'm using Evo. After i try to create a new event it report this and nothing else

    « MODX Parse Error »
    MODX encountered the following error while attempting to parse the requested resource:
    « Execution of a query to the database failed - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'repeat``, `lastrepeat`, `event_occurance`, `_occurance_wkly`, `event_occurance_r' at line 1 »
    SQL > INSERT INTO `u844828361_con`.`modx_mxcalendar_events` (`title`, `description`, `category`, `restrictedwebusergroup`, `link`, `linkrel`, `linktarget`, `location`, `displayGoogleMap`, `start`, `startdate`, `starttime`, `end`, `enddate`, `endtime`, ``repeat``, `lastrepeat`, `event_occurance`, `_occurance_wkly`, `event_occurance_rep`, `_occurance_properties`, `customFields`) VALUES('Первый', '', '2', '', '9', '', '', 'moscow', '0', '2015-10-24 14:45', '2015-10-24', '14:45:00', '2015-10-25 14:45', '2015-10-25', '14:45:00', '2015-11-24,2015-12-24', '2015-12-27', 'm', '', '1', '0', '[]')
    Basic info
    REQUEST_URI : http://concertiny.96.lt/manager/index.php?a=112&id=3
    Manager action : 112 - Execute module
    Referer : http://concertiny.96.lt/manager/index.php?a=112&id=3
    User Agent : Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/46.0.2490.71 Safari/537.36
    IP : 134.17.24.97
    Benchmarks
    MySQL : 0,0092 s (7 Requests)
    PHP : 0,0276 s
    Total : 0,0368 s
    Memory : 2,3984146118164 mb

    Backtrace

    1 include_once()
    manager/index.php on line 561
    2 evalModule()
    manager/processors/execute_module.processor.php on line 69
    3 eval()
    manager/processors/execute_module.processor.php on line 82
    4 include_once()
    manager/processors/execute_module.processor.php(82) : eval()'d code on line 34
    5 mxCal_APP_CLASS->_mgrAddEdit()
    assets/modules/mxCalendar/mxCalendar.tpl.php on line 101
    6 mxCal_APP_CLASS->_saveEvent()
    assets/modules/mxCalendar/mxCalendar.class.php on line 265
    7 DBAPI->insert()
    assets/modules/mxCalendar/mxCalendar.class.php on line 1255
    8 DBAPI->query()
    manager/includes/extenders/dbapi.mysql.class.inc.php on line 282

    This question has been answered by dada-net. See the first response.

    • discuss.answer
      • 51280
      • 2 Posts
      OK. I've solve it. There is an error in file mx.calendar.class.php line 1244 extra quotes