PLEASE DEAR GOD HELP ME

a complete banner management system, any number of banners can be added
Forum rules
The content in this forum is dated Dec. 21 2005 and can be used as Archive only. This Forum is LOCKED and READ ONLY !

PLEASE DEAR GOD HELP ME

Postby copperzepher on Wed 20. Apr, 2005 07:04

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
copperzepher
Poster
Poster
 
Posts: 1
Joined: Wed 20. Apr, 2005 05:42

Postby rew2 on Thu 21. Apr, 2005 01:33

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

now you read bold text 8) and check constants.php do you ad all to this file
rew2
Poster
Poster
 
Posts: 6
Joined: Wed 07. Jan, 2004 02:41
Location: Warsaw Poland

Postby Beeveer on Wed 04. May, 2005 08:38

In this case, the database queries aren't executed properly.
User avatar
Beeveer
brilliant supporter
 
Posts: 264
Joined: Tue 30. Nov, 2004 19:13
Location: Boskoop, South-Holland, the Netherlands

Postby Niels on Sat 07. May, 2005 14:56

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.
(if a how-to is EM ready, it will mostly be bullet prof, since a machine is more picky than a human. :D)
User avatar
Niels
Poster
Poster
 
Posts: 4390
Joined: Sat 27. Jul, 2002 15:46


Return to Complete banner [2.0.6/EM]

Who is online

Users browsing this forum: No registered users and 1 guest

cron