phpBB.de

Code: Alles auswählen

Allgemeiner Fehler
SQL ERROR [ mysqli ]

Unknown column 'anniversary' in 'where clause' [1054]

SQL

SELECT * FROM plattform_calendar WHERE date_from = '2019-12-18' OR date_from <= '2019-12-18' AND date_to >= '2019-12-18' OR date_from <= '2019-12-18' AND date_to = '0000-00-00' AND calendar_repeat > 0 OR date_from LIKE '%-12-18' AND anniversary = 1 ORDER by event_id

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 997
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 196
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/hjw/calendar/includes/calendar_event.php
LINE: 83
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/hjw/calendar/event/main_listener.php
LINE: 443
CALL: include('[ROOT]/ext/hjw/calendar/includes/calendar_event.php')

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 184
CALL: hjw\calendar\event\main_listener->calendar_on_header()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 46
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 62
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()

FILE: [ROOT]/includes/functions.php
LINE: 4254
CALL: phpbb\event\dispatcher->trigger_event()

FILE: [ROOT]/index.php
LINE: 251
CALL: page_header()

Code: Alles auswählen

$sql = 'SELECT *
		FROM ' . CALENDAR_TABLE . "
		WHERE date_from = '" . $year . '-' . $month . '-' . $day . "'
			OR date_from <= '" . $year . '-' . $month . '-' . $day . "'
				AND date_to >= '" . $year . '-' . $month . '-' . $day . "'
			OR date_from <= '" . $year . '-' . $month . '-' . $day . "'
				AND date_to = '0000-00-00' AND calendar_repeat > 0
		  	OR date_from LIKE '%-" . $month . '-' . $day . "'
				AND anniversary = 1 
		ORDER by event_id";
$event_result = $this->db->sql_query($sql);