Updated Extension, board went down

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
isuquinndog
Registered User
Posts: 31
Joined: Wed May 21, 2003 9:02 pm
Contact:

Updated Extension, board went down

Post by isuquinndog » Thu Sep 13, 2018 3:26 am

I've asked in the extension support but I'm not confident I'm going to help soon.

Upgraded the Advertisement Managment Extension (https://www.phpbb.com/customise/db/extension/ads/) which I already had installed. I didn't disable it, though I didn't think I needed to. I copied the files over and then I got an cache error. So I deleted the production folder in there, left the rest and now I get this error on my main forum page:
General Error
SQL ERROR [ mysqli ]

Table 'redbirdf_bb2.bb_ad_group' doesn't exist [1146]

SQL

SELECT al.location_id, a.ad_id, a.ad_code, a.ad_centering FROM bb_ad_locations al LEFT JOIN bb_ads a ON (al.ad_id = a.ad_id) WHERE a.ad_enabled = 1 AND (a.ad_end_date = 0 OR a.ad_end_date > 1536808873) 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 bb_ad_group ag WHERE ag.ad_id = a.ad_id AND ag.group_id IN ('2', '4', '5')) AND al.location_id IN ('above_header', 'after_header_navbar', 'below_header', 'above_footer', 'after_footer_navbar', 'below_footer', 'pop_up', 'slide_up') 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: 996
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: 94
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/phpbb/ads/event/main_listener.php
LINE: 133
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: 4693
CALL: phpbb\event\dispatcher->trigger_event()

FILE: [ROOT]/index.php
LINE: 246
CALL: page_footer()
I don't know what the columns are in that table, otherwise I'd just add it. Any help for a noob would be awesome.

link to forum: https://www.redbirdfan.net/forum

isuquinndog
Registered User
Posts: 31
Joined: Wed May 21, 2003 9:02 pm
Contact:

Re: Updated Extension, board went down

Post by isuquinndog » Thu Sep 13, 2018 3:34 am

Got it. Deleted the ext folder for that extension and removed cache again.

User avatar
Mannix_
Registered User
Posts: 349
Joined: Sun Oct 25, 2015 2:56 pm
Contact:

Re: Updated Extension, board went down

Post by Mannix_ » Thu Sep 13, 2018 5:52 am

Instructions in the ACP say that 1 you need to disable the extension 2 delete the old files from ftp 3 upload new files to ftp 4 enable the extension. Just FYI
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
My CDB contributions . Like my work? Want me to do make a style just for you? PM here or on twitter.
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Need some graphics? PM here or on twitter.

Post Reply

Return to “[3.2.x] Support Forum”