MODS.DB9.DK

[riga75]

I have installed the complete banner 1.3.7 and when I click on banner in the amministration they give this error to me:

Couldn't obtain ranks data

DEBUG MODE

SQL Error : 1146 Table 'forum_db.BANNERS_TABLE' doesn't exist

SELECT * FROM BANNERS_TABLE order by banner_spot

Line : 667
File : admin_banner.php

I have already update the database with the file complete_banner_db_update

and I have tried to update and they give this message to me:

This list is a result of the SQL queries needed for mod


Banner mod
[Already added] line: 1 , CREATE TABLE phpbb_banner ( banner_id MEDIUMINT( UNSIGNED NOT NULL, banner_name TEXT NOT NULL, banner_spot SMALLINT(1) UNSIGNED NOT NULL, banner_forum MEDIUMINT( UNSIGNED NOT NULL, banner_description VARCHAR(30) NOT NULL, banner_url VARCHAR(128) NOT NULL, banner_owner MEDIUMINT( NOT NULL, banner_click MEDIUMINT( UNSIGNED NOT NULL, banner_view MEDIUMINT( UNSIGNED NOT NULL, banner_weigth TINYINT(1) UNSIGNED DEFAULT "50" NOT NULL, banner_active TINYINT(1) NOT NULL, banner_timetype TINYINT(1) NOT NULL, time_begin INT(11) NOT NULL, time_end INT(11) NOT NULL, date_begin INT(11) NOT NULL, date_end INT(11) NOT NULL, banner_level TINYINT(1) NOT NULL, banner_level_type TINYINT(1) NOT NULL, banner_comment VARCHAR(50) NOT NULL, banner_type MEDIUMINT(5) NOT NULL, banner_width MEDIUMINT(5) UNSIGNED NOT NULL, banner_height MEDIUMINT(5) UNSIGNED NOT NULL, banner_filter TINYINT(1) NOT NULL, banner_filter_time MEDIUMINT(5) DEFAULT "600" NOT NULL, INDEX (banner_id))
[Already added] line: 2 , CREATE TABLE phpbb_banner_stats ( banner_id MEDIUMINT( UNSIGNED NOT NULL, click_date int (11) NOT NULL, click_ip char( NOT NULL, click_user MEDIUMINT( NOT NULL, user_duration int (11) NOT NULL)

What I can make? Thanks of the aid

[bacalhau_cnatas]

Read very carefully this Post

http://mods.db9.dk/viewtopic.php?t=5891&start=0

Best regard

[riga75]

Excuse but I do not succeed to find the solution to my problem

[rew2]

maybe you not ad all to constants.php check

[fbilly]

i also have this problem. I read all post , can't find this problem ....

please help !

SQL Error : 1146 Table '3talk.banners_table' doesn't exist

SELECT * FROM BANNERS_TABLE order by banner_spot