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
grofstepe
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 » Sun May 26, 2019 10:23 pm

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()

User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 50812
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

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

Post by stevemaury » Sun May 26, 2019 11:54 pm

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”