[CLOSED] Failed to Get Sponsor Banner Info

Newbie Joined: Feb 27, 2006 Posts: 1

I have installed html newsletter with no error's but when i go to my controle panel and click on html news letter i get the follow error's

ENCOUNTERED ERROR IN SQL: Table 'sniper_pcn.nuke_banner' doesn't exist

SQL = SELECT `bid`, `imageurl`, `clickurl`, `alttext` FROM `nuke_banner`

ERROR IN MODULE: HTML_Newsletter

ERROR MSG: Failed to get sponsor banner information

who can help me

Site Admin Joined: Jul 18, 2005 Posts: 387

This error mesage indicates the the table nuke_banners does not exist.
As this is a core table that is used in phpnuke up to version 7.6 can you confirm which version of phpnuke you are using.

Did the installer create the new tables for the HTMl Newsletter?

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1360

sniper,

This is not a problem with the HTML Newsletter module. Guardian is right, you don't have the nuke_banners table in your distribution. Sounds to me like you have either a bad nuke installation or you are using a non-standard banners tool?

What banner system do you have installed? If you installed this, can you provide the table schema (structure) in a post so I can see what is different between it and the core nuke banner system? I may be able to point you to what to change in the HTML Newsletter code to work with your installed banner system.

Site Admin/Owner Joined: Feb 12, 2005 Posts: 1360

sniper, whatever happened with this?

Newbie Joined: Mar 11, 2008 Posts: 12

i have the same problem, im using nuke Platinum 7.6.b.4

Site Admin Joined: Jul 18, 2005 Posts: 387

Then you need to run the installer that came with the HTML Newsletter package.

Newbie Joined: Mar 11, 2008 Posts: 12

but i already did that and it said all was successful or is there any other installer?

Newbie Joined: Mar 11, 2008 Posts: 12

i have run it again

Code:

Create table nuke_hnl_categories succeeded
Insert 1 into nuke_hnl_categories succeeded
Insert 2 into nuke_hnl_categories succeeded
Insert 3 into nuke_hnl_categories succeeded
Create table nuke_hnl_newsletters succeeded
Insert 1 into nuke_hnl_newsletters succeeded
Insert 2 into nuke_hnl_newsletters succeeded
Create table nuke_hnl_cfg succeeded
Insert 1 into nuke_hnl_cfg succeeded
Insert 2 into nuke_hnl_cfg succeeded
Insert 3 into nuke_hnl_cfg succeeded
Insert 4 into nuke_hnl_cfg succeeded
Insert 5 into nuke_hnl_cfg succeeded
Insert 6 into nuke_hnl_cfg succeeded
Insert 7 into nuke_hnl_cfg succeeded
Insert 8 into nuke_hnl_cfg succeeded
Insert 9 into nuke_hnl_cfg succeeded
Insert 10 into nuke_hnl_cfg succeeded
Insert 11 into nuke_hnl_cfg succeeded
Insert 12 into nuke_hnl_cfg succeeded
Insert 13 into nuke_hnl_cfg succeeded
Insert 14 into nuke_hnl_cfg succeeded
Insert 15 into nuke_hnl_cfg succeeded
Insert 16 into nuke_hnl_cfg succeeded
Insert 17 into nuke_hnl_cfg succeeded
Insert 18 into nuke_hnl_cfg succeeded
Insert 19 into nuke_hnl_cfg succeeded
Insert 20 into nuke_hnl_cfg succeeded
Insert 21 into nuke_hnl_cfg succeeded
Insert 22 into nuke_hnl_cfg succeeded

but i still get this:

Code:

ENCOUNTERED ERROR IN SQL: Table 'lafiebre_nuke.nuke_banner' doesn't exist

SQL = SELECT `bid`, `imageurl`, `clickurl`, `alttext` FROM `nuke_banner`

ERROR IN MODULE: HTML_Newsletter

ERROR MSG: Failed to get sponsor banner information

Site Admin Joined: Jul 18, 2005 Posts: 387

In that case it might be a problem with the banner module.
The banners module was removed in phpNuke 7.8 (about) and replaced with the Advertising module.
You'll need to check which you have installed as I think HTML Newsletter relies on the Advertising module.

Newbie Joined: Mar 11, 2008 Posts: 12

then if it relies on the advertising module, it should be working because i have 7.9?

Newbie Joined: Mar 11, 2008 Posts: 12

i have the Banners ad module

Site Admin Joined: Jul 18, 2005 Posts: 387

Platinum 7.6b4 is based on phpNuke 7.6 so it will be using the old Banners module and thats why you are getting the error - the table doesn't exist.
As HTML Newsletter only gets an image from the table, it should be easy enough to change the code the use that table.

Newbie Joined: Mar 11, 2008 Posts: 12

ohh, can you tell me what code might that be?

Site Admin Joined: Jul 18, 2005 Posts: 387

It appears in too many files to give you a line by line guide but the error message should indicate the file name if you turn on error reporting in the Platinum root config.php file.
Please keep in mind that I don't think Platinum is supported as far as HTML Newsletter is concerned as there are just too many forks of phpNuke to be able to support every single one of them.

Newbie Joined: Mar 11, 2008 Posts: 12

I understand. What about creating the table?