Bug #23276 See Comments

Exception Caught SQLSTATE[42000]

Version: 3.5.12 Reporter: alma

Exception Caught

SQLSTATE[42000]: Syntax error or access violation: 1064 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 ''null' ) ) ) LIMIT 18446744073709551615' at line 11:
SELECT calendar_m_Event_calendar_events.id as calendar_m_Event__id, calendar_m_Event_calendar_events.entry_id as calendar_m_Event__entry_id, calendar_m_Event_calendar_events.calendar_id as calendar_m_Event__calendar_id, calendar_m_Event_calendar_events.field_id as calendar_m_Event__field_id, calendar_m_Event_calendar_events.rrule as calendar_m_Event__rrule, calendar_m_Event_calendar_events.start_date as calendar_m_Event__start_date, calendar_m_Event_calendar_events.end_date as calendar_m_Event__end_date, calendar_m_Event_calendar_events.all_day as calendar_m_Event__all_day, calendar_m_Event_calendar_events.until_date as calendar_m_Event__until_date FROM (`exp_calendar_events` as calendar_m_Event_calendar_events) WHERE ( `calendar_m_Event_calendar_events`.`calendar_id` IN (5, 2, 4, 3, 33, 39, 6, 10, 27, 14, 11, 13, 29, 30, 15, 24, 17, 16, 28, 38, 18, 37, 19, 20, 22, 21, 26, 23, 25, 32, 7, 8, 31, 35, 34, 9, 12) AND ( ( `calendar_m_Event_calendar_events`.`start_date` >= '2017-10-26 00:00:00' AND `calendar_m_Event_calendar_events`.`start_date` <= '2017-12-06 00:00:00' ) OR ( `calendar_m_Event_calendar_events`.`rrule` IS NOT NULL 'null' ) ) ) LIMIT 18446744073709551615

ee/legacy/database/drivers/mysqli/mysqli_connection.php:122

Stack Trace: hide details

#0 ee/legacy/database/drivers/mysqli/mysqli_driver.php(137): CI_DB_mysqli_connection->query('SELECT calendar...')
#1 ee/legacy/database/DB_driver.php(297): CI_DB_mysqli_driver->_execute('SELECT calendar...')
#2 ee/legacy/database/DB_driver.php(203): CI_DB_driver->simple_query('SELECT calendar...')
#3 ee/legacy/database/DB_active_rec.php(1219): CI_DB_driver->query('SELECT calendar...')
#4 ee/EllisLab/ExpressionEngine/Service/Model/Query/Select.php(45): CI_DB_active_record->get()
#5 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(294): EllisLab\ExpressionEngine\Service\Model\Query\Select->run()
#6 ee/EllisLab/ExpressionEngine/Service/Model/DataStore.php(240): EllisLab\ExpressionEngine\Service\Model\DataStore->runQuery('Select', Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#7 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(156): EllisLab\ExpressionEngine\Service\Model\DataStore->selectQuery(Object(EllisLab\ExpressionEngine\Service\Model\Query\Builder))
#8 ee/EllisLab/ExpressionEngine/Service/Model/Query/Builder.php(75): EllisLab\ExpressionEngine\Service\Model\Query\Builder->fetch()
#9 user/addons/calendar/Repositories/EventRepository.php(106): EllisLab\ExpressionEngine\Service\Model\Query\Builder->all()
#10 user/addons/calendar/mcp.calendar.php(622): Solspace\Addons\Calendar\Repositories\EventRepository->getFromCalendars(Object(EllisLab\ExpressionEngine\Service\Model\Collection), Object(Solspace\Addons\Calendar\Library\Carbon\Carbon), Object(Solspace\Addons\Calendar\Library\Carbon\Carbon))
#11 user/addons/calendar/mcp.calendar.php(91): Solspace\Addons\Calendar\Calendar_mcp->getMonthView(Object(EllisLab\ExpressionEngine\Service\Model\Collection), Object(Solspace\Addons\Calendar\Library\Carbon\Carbon))
#12 [internal function]: Solspace\Addons\Calendar\Calendar_mcp->index('month')
#13 user/addons/calendar/mcp.calendar.php(126): call_user_func_array(Array, Array)
#14 [internal function]: Solspace\Addons\Calendar\Calendar_mcp->month()
#15 ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php(1660): call_user_func_array(Array, Array)
#16 ee/EllisLab/ExpressionEngine/Controller/Addons/Addons.php(920): EllisLab\ExpressionEngine\Controller\Addons\Addons->getModuleSettings('calendar', 'month', Array)
#17 [internal function]: EllisLab\ExpressionEngine\Controller\Addons\Addons->settings('calendar', 'month')
#18 ee/EllisLab/ExpressionEngine/Core/Core.php(189): call_user_func_array(Array, Array)
#19 ee/EllisLab/ExpressionEngine/Core/Core.php(94): EllisLab\ExpressionEngine\Core\Core->runController(Array)
#20 ee/EllisLab/ExpressionEngine/Boot/boot.php(151): EllisLab\ExpressionEngine\Core\Core->run(Object(EllisLab\ExpressionEngine\Core\Request))
#21 index.php(148): require_once('...')
#21 index.php(148): require_once('...')
  • #14 [internal function]: Solspace\Addons\Calendar\Calendar_mcp->month()

    Calendar is a third-party add-on and not a native component of ExpressionEngine, please contact the add-on vendor (Solspace) for assistance.

    Derek Jones
    08th November, 2017 at 11:28am

You must be signed in to comment on a bug report.

ExpressionEngine News

#eecms, #events, #releases