MODS.DB9.DK

[copperzepher]

I installed this MOD with easyMOD. And now I have a HUGE problem. I tried to back up the databse to before it was installed, but that didnt work, now I cant do ANYTHING.

General Error

Couldn't get banners data

DEBUG MODE

SQL Error : 1146 Table 'shadow_phpb1.phpbb_banner' doesn't exist

SELECT DISTINCT banner_id, banner_name, banner_spot, banner_description, banner_forum, banner_type, banner_width, banner_height, banner_filter FROM phpbb_banner WHERE banner_active AND IF(banner_level_type,IF(banner_level_type=1,-1<=banner_level,IF(banner_level_type=2,-1>=banner_level,-1<>banner_level)),banner_level=-1) AND (banner_timetype=0 OR (( 0500 BETWEEN time_begin AND time_end) AND ((banner_timetype=2 OR (( 3 BETWEEN date_begin AND date_end) AND banner_timetype=4) OR (( 20050420 BETWEEN date_begin AND date_end) AND banner_timetype=6) )))) ORDER BY banner_spot,banner_weigth*SUBSTRING(RAND(),6,2) DESC

Line : 359
File : page_header.php

[rew2]

SQL Error : 1146 Table 'shadow_phpb1.phpbb_banner' doesn't exist

now you read bold text and check constants.php do you ad all to this file

[Beeveer]

In this case, the database queries aren't executed properly.

[Niels]

AS said, you haven't executed the SQL's PRIOR to installing the mod.
EM does (or did not) execute SQL's

To fix your forum, you will need temporary to rename your page_header.php to e.g. page_header_banner.php
Then you need a unmodifyed page_header.php or atleast a page_header.php backup file before this mod.
if you haven't got a backup file, you may simply download the lates version from phpbb.com.

once this is done you forum will work again.
now you may execute the included db_update.php file, simply by copying into your forum root, and cal it from your browser (you ned to be logged into your froum as admin)

once this is done you may switch your page_header.php back again, and all is runing well - inlcuding the banner mod.

place notise that admin/admin_banner.php have been upgraded to day, so remember to DW this mod again, and replace this file, with the pressent one.