Installation Problems on Nuke Platinum

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

Thanks Guardian! I was questioning that in my mind as well, but didn't have the heart to say it. Wink

RavenNuke is about the best thing going on right now and both Guardian and I are on the Team, with others, working on it. It is NOT going to be bloatware, though. We are striving for most secure, most bug free and best performing 7.6 version of nuke around.

I hadn't realized that about NukePlatinum and how far back it was. That could very well be the problem. I'll have to look into it more when I get home from work.

In the meantime, to answer your question about the "subscriber" functionality, it is on the "to do" list, but I just haven't had the time to get to any of the list in quite awhile. I am working up to getting motivated again to cut a new release.

Newbie Joined: Dec 17, 2006 Posts: 5

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

I get the nuke_banner table does not exsist.. do I need this

and if so, where do i get it.. LOL

Newbie Joined: Dec 17, 2006 Posts: 5

this is what is in platnium

nuke_nsnba_banners Wink

Newbie Joined: Dec 17, 2006 Posts: 5

Ok..

This what i got so far.. might want to maybe make it a sticky..

1. Once you install as what is stated in the Read e File

2. Follow these instructions

http://montegoscripts.com/ftopict-10.html

Instead dont comment out, Change the Table to referr to

_nsnba_banners the Prefix is all ready set you just need to pull the right table which in Platnium 7.6 it is this one

NOW you can comment out and it will work.. ( this is a Debug Feature) so you dont have to have the banners for this module to work..

I am working on the Preview issue.. Once you create a Newsletter you get File can't be access directly

I will let you know..

Site Admin Joined: Jul 18, 2005 Posts: 383

If you open the root mainfile.php and turn on error reporting it might tell you which file it cannot acces and why - that would help in your debugging but I suspect the issue is that as you are using Platinum the table fields are completely different from the standard nuke_banners table

Newbie Joined: Dec 17, 2006 Posts: 5

Platnium Banner Table

REATE TABLE IF NOT EXISTS `nuke_nsnba_banners` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`pid` tinyint(1) NOT NULL default '0',
`imptotal` int(11) NOT NULL default '0',
`impmade` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(200) NOT NULL default '',
`clickurl` varchar(200) NOT NULL default '',
`alttext` varchar(255) NOT NULL default '',
`code` tinyint(1) NOT NULL default '0',
`flash` tinyint(1) NOT NULL default '0',
`height` int(4) NOT NULL default '60',
`width` int(4) NOT NULL default '468',
`datestr` date NOT NULL default '0000-00-00',
`dateend` date NOT NULL default '0000-00-00',
`active` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`bid`),
KEY `bid` (`bid`),
KEY `cid` (`cid`)

Nuke Banner Table

CREATE TABLE nuke_banner (
bid int(11) NOT NULL auto_increment,
cid int(11) NOT NULL default '0',
name varchar(50) NOT NULL default '',
imptotal int(11) NOT NULL default '0',
impmade int(11) NOT NULL default '0',
clicks int(11) NOT NULL default '0',
imageurl varchar(100) NOT NULL default '',
clickurl varchar(200) NOT NULL default '',
alttext varchar(255) NOT NULL default '',
`date` datetime default NULL,
dateend datetime default NULL,
position int(10) NOT NULL default '0',
active tinyint(1) NOT NULL default '1',
ad_class varchar(5) NOT NULL default '',
ad_code text NOT NULL,
ad_width int(4) default '0',
ad_height int(4) default '0',
PRIMARY KEY (bid),
KEY bid (bid),
KEY cid (cid)
);

From that section of Code in admin it calls for the Same Fields...

It must be something else other than the tables..

I wil get back wif ya.. Wink

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

Sorry, I have been out of town with minimal time to make updates.

So, Tperk, are you saying that changing the table name did not work? You have to find everywhere that it is used. At least I know in admin.php and admin_make_nls.php at a minimum.

Site Admin Joined: Jul 18, 2005 Posts: 383

Yes,
around line 57 in HTML_Nwsletter/admin/admin.php I presume you have changed

Code:

$sql = "SELECT `bid`, `imageurl`, `clickurl`, `alttext` FROM `" .$prefix."_banner`";

to

Code:

$sql = "SELECT `bid`, `imageurl`, `clickurl`, `alttext` FROM `" .$prefix."_nsnba_banners`";

So in essence you are adding the '_nsnba' bit as well as the 's' in banners.

The same around line 610 in HTML_Newsletter/admin/admin_make_ns.php