Montego Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic
Author Message
sniper
Newbie
Newbie



Joined: Feb 27, 2006
Posts: 1

PostPosted: Mon Feb 27, 2006 1:46 pm Reply with quote

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
 
View user's profile Send private message
Guardian
Site Admin
Site Admin



Joined: Jul 18, 2005
Posts: 401

PostPosted: Mon Feb 27, 2006 8:30 pm Reply with quote

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?
 
View user's profile Send private message
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1393

PostPosted: Mon Feb 27, 2006 10:52 pm Reply with quote

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.

_________________
“To err is human, but when the eraser wears out ahead of the pencil, you’re overdoing it.”
-- Josh Jenkins 
View user's profile Send private message Visit poster's website
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1393

PostPosted: Sat Mar 18, 2006 3:12 pm Reply with quote

sniper, whatever happened with this?

_________________
“To err is human, but when the eraser wears out ahead of the pencil, you’re overdoing it.”
-- Josh Jenkins 
View user's profile Send private message Visit poster's website
erecpr18
Newbie
Newbie



Joined: Mar 11, 2008
Posts: 12

PostPosted: Sat Oct 17, 2009 3:03 pm Reply with quote

i have the same problem, im using nuke Platinum 7.6.b.4
 
View user's profile Send private message
Guardian
Site Admin
Site Admin



Joined: Jul 18, 2005
Posts: 401

PostPosted: Sat Oct 17, 2009 3:12 pm Reply with quote

Then you need to run the installer that came with the HTML Newsletter package.
 
View user's profile Send private message
erecpr18
Newbie
Newbie



Joined: Mar 11, 2008
Posts: 12

PostPosted: Sat Oct 17, 2009 4:27 pm Reply with quote

but i already did that and it said all was successful or is there any other installer?
 
View user's profile Send private message
erecpr18
Newbie
Newbie



Joined: Mar 11, 2008
Posts: 12

PostPosted: Sat Oct 17, 2009 4:36 pm Reply with quote

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
 
View user's profile Send private message
Guardian
Site Admin
Site Admin



Joined: Jul 18, 2005
Posts: 401

PostPosted: Sat Oct 17, 2009 4:49 pm Reply with quote

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.
 
View user's profile Send private message
erecpr18
Newbie
Newbie



Joined: Mar 11, 2008
Posts: 12

PostPosted: Sat Oct 17, 2009 5:17 pm Reply with quote

then if it relies on the advertising module, it should be working because i have 7.9?
 
View user's profile Send private message
erecpr18
Newbie
Newbie



Joined: Mar 11, 2008
Posts: 12

PostPosted: Sat Oct 17, 2009 6:11 pm Reply with quote

i have the Banners ad module
 
View user's profile Send private message
Guardian
Site Admin
Site Admin



Joined: Jul 18, 2005
Posts: 401

PostPosted: Sat Oct 17, 2009 6:30 pm Reply with quote

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.
 
View user's profile Send private message
erecpr18
Newbie
Newbie



Joined: Mar 11, 2008
Posts: 12

PostPosted: Sat Oct 17, 2009 6:49 pm Reply with quote

ohh, can you tell me what code might that be?
 
View user's profile Send private message
Guardian
Site Admin
Site Admin



Joined: Jul 18, 2005
Posts: 401

PostPosted: Sun Oct 18, 2009 3:26 am Reply with quote

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.
 
View user's profile Send private message
erecpr18
Newbie
Newbie



Joined: Mar 11, 2008
Posts: 12

PostPosted: Sun Oct 18, 2009 3:38 pm Reply with quote

I understand. What about creating the table?
 
View user's profile Send private message
Display posts from previous:       
Post new topic   Reply to topic

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 4 Hours
 
Forums ©
linear-bunchlinear-bunchlinear-bunchlinear-bunch