Page 1 of 1

SQL ERROR [ mysqli ] Unknown column 'a.ad_start_date' in 'where clause' [1054]

Posted: Sun May 26, 2019 10:23 pm
by grofstepe
can anyone help me how to solve this please

Code: Select all

SQL ERROR [ mysqli ]

Unknown column 'a.ad_start_date' in 'where clause' [1054]

SQL

SELECT al.location_id, a.ad_id, a.ad_code, a.ad_centering FROM phpbb_ad_locations al LEFT JOIN phpbb_ads a ON (al.ad_id = a.ad_id) WHERE a.ad_enabled = 1 AND (a.ad_start_date = 0 OR a.ad_start_date < 1558908901) AND (a.ad_end_date = 0 OR a.ad_end_date > 1558908901) AND (a.ad_views_limit = 0 OR a.ad_views_limit > a.ad_views) AND (a.ad_clicks_limit = 0 OR a.ad_clicks_limit > a.ad_clicks) AND NOT EXISTS (SELECT ag.group_id FROM phpbb_ad_group ag WHERE ag.ad_id = a.ad_id AND ag.group_id = '5') AND al.location_id IN ('above_header', 'after_header_navbar', 'below_header', 'above_footer', 'after_footer_navbar', 'below_footer', 'pop_up', 'slide_up', 'scripts') ORDER BY al.location_id, (RAND() * a.ad_priority) DESC

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: 193
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/phpbb/ads/ad/manager.php
LINE: 96
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/phpbb/ads/event/main_listener.php
LINE: 140
CALL: phpbb\ads\ad\manager->get_ads()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\ads\event\main_listener->setup_ads()

FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 184
CALL: call_user_func()

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: 4804
CALL: phpbb\event\dispatcher->trigger_event()

FILE: [ROOT]/index.php
LINE: 260
CALL: page_footer()

Re: SQL ERROR [ mysqli ] Unknown column 'a.ad_start_date' in 'where clause' [1054]

Posted: Sun May 26, 2019 11:54 pm
by stevemaury
Not with so little information. Please fill out the Support Request Template and post it back here to enable us to assist you better.