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

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Registered User
Posts: 31
Joined: Sat May 06, 2017 6:48 pm

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

Post 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]


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


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()
User avatar
Support Team Member
Support Team Member
Posts: 51386
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve

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

Post 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.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
Post Reply

Return to “[3.2.x] Support Forum”