Montego Scripts: Forums
 

 

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



Joined: Jan 28, 2007
Posts: 1

PostPosted: Sun Jan 28, 2007 4:24 am Reply with quote

Hi im downloded your Newsletter module but i become this error
Array ( [debug_mode] => VERBOSE [debug_output] => DISPLAY [show_blocks] => 1 [dl_module] => downloads [blk_lmt] => 10 [scroll] => 0 [scroll_height] => 180 [scroll_amt] => 2 [scroll_delay] => 100 [version] => 01.03.01 [show_hits] => 0 [show_dates] => 1 [show_sender] => 0 [show_categories] => 1 [nsn_groups] => 1 [latest_news] => 0 [latest_downloads] => 0 [latest_links] => 0 [latest_forums] => 0 [latest_reviews] => 0 [wysiwyg_on] => 1 [wysiwyg_rows] => 30 )

----------
= Hover your cursor over these icons for detailed help text

Start of Build Banner HTML

ENCOUNTERED ERROR IN SQL: Table 'oldal.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

What can I do ?

Thanks
 
View user's profile Send private message
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1393

PostPosted: Sun Jan 28, 2007 10:11 am Reply with quote

Looks as though you are either using a Nuke version greater than 7.6 or a banner system that is not come standard with PHP-Nuke. What nuke version are you using and/or what banner system have you installed?

_________________
“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: Sun Jan 28, 2007 10:32 am Reply with quote

BTW, I just removed some of your post as it exposed some sensitive information that you do NOT want to get out in public.

_________________
“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
Guardian
Site Admin
Site Admin



Joined: Jul 18, 2005
Posts: 401

PostPosted: Mon Jan 29, 2007 9:23 pm Reply with quote

It looks like it may be an add-on banner system or the table has been removed.
I just had a quick look and the table and fields relating to the error should exist up to nuke 7.9 (I didnt check with 8.0 as its not public yet).
 
View user's profile Send private message
Tyna
Newbie
Newbie



Joined: May 14, 2007
Posts: 2

PostPosted: Mon May 14, 2007 1:47 pm Reply with quote

I have this problem too... i don`t know what to do Sad

ENCOUNTERED ERROR IN SQL: Table 'base_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


I using NSN Banner Ads 1.3.0 and i a have Nuke 7.6 Platinum...

Please help me Sad

Thanx.
 
View user's profile Send private message
Guardian
Site Admin
Site Admin



Joined: Jul 18, 2005
Posts: 401

PostPosted: Mon May 14, 2007 4:20 pm Reply with quote

The sql error seems to indicate that the table nuke_banners does not exist.
As Montego posted earlier, HTML Newsletter is only certified to run on nuke 7.6 and Raven Nuke.
It would appear that Nuke Platinum is not using and does not have the nuke_banner table.
 
View user's profile Send private message
Tyna
Newbie
Newbie



Joined: May 14, 2007
Posts: 2

PostPosted: Mon May 14, 2007 6:25 pm Reply with quote

What if i made table with name nuke_banner?
I don`t want use banner ads in newsletters... i was try to delete "Build the Banner Link - to replace {BANNER} tag" from admin_make_nls.php and nothing change Sad


P.S. Sorry, i don`t know english grammar very well Razz
 
View user's profile Send private message
Guardian
Site Admin
Site Admin



Joined: Jul 18, 2005
Posts: 401

PostPosted: Mon May 14, 2007 7:37 pm Reply with quote

I guess a quick fix would be to create the table manually.
If you enter this in phpmyadmin or whatever database utility you are using to create the table.
Code:

CREATE TABLE IF NOT EXISTS 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)
) ENGINE=MyISAM;
 
View user's profile Send private message
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1393

PostPosted: Mon May 14, 2007 8:26 pm Reply with quote

That would work, but an alternative would be to comment out the sponsors code. I addressed it over at this thread here http://montegoscripts.com/ftopicp-23.html#23, however, that thread is quite old and I believe the file names are no longer the same. So, I have dug through this again and try this:

=== OPEN ===

modules/HTML_Newsletter/admin/admin.php

=== FIND ===

Code:

/************************************************************************
* Get the sponsor banners HTML - placed here to ensure any issues are
* addressed up-front.
************************************************************************/

msnl_fDebugMsg( "Start of Build Banner HTML" );

$msnl_asHTML['BANNERS']   = "";

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

$result      = msnl_fSQLCall( $sql );

if ( !$result ) { //Bad SQL call

   msnl_fRaiseAppError( _MSNL_ADM_ERR_DBGETBANNERS );   

} else { //Successful SQL call

      while (   $row = $db->sql_fetchrow( $result ) ) {

         $msnl_asRec['bid']            = intval( $row['bid'] );
         $msnl_asRec['imageurl']      = stripslashes( $row['imageurl'] );
         $msnl_asRec['clickurl']      = stripslashes( $row['clickurl'] );
         $msnl_asRec['alttext']      = stripslashes( $row['alttext'] );

         $msnl_asHTML['BANNERS']   .= "<input type=\"radio\" name=\"msnl_banner\" value=\""
                                                   .$msnl_asRec['bid']."\"";

         if ( $_POST['msnl_banner'] == $msnl_asRec['bid'] ) {

            $msnl_asHTML['BANNERS']   .= " CHECKED";

         }

         $msnl_asHTML['BANNERS']   .= " />\n"
               ."<a href=\"".$msnl_asRec['clickurl']."\">"
               ."<img ${msnl_asCSS['IMG_def']} src=\"".$msnl_asRec['imageurl']."\" alt=\"".$msnl_asRec['alttext']."\">"
               ."</a><br /><br />\n";

      } //End While for getting sponsor banners HTML

} //End IF of SQL call check


=== REPLACE WITH ===

Code:

/************************************************************************
* Get the sponsor banners HTML - placed here to ensure any issues are
* addressed up-front.
************************************************************************/

msnl_fDebugMsg( "Start of Build Banner HTML" );

$msnl_asHTML['BANNERS']   = "";

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

$result      = msnl_fSQLCall( $sql );

if ( !$result ) { //Bad SQL call

   msnl_fRaiseAppError( _MSNL_ADM_ERR_DBGETBANNERS );   

} else { //Successful SQL call

      while (   $row = $db->sql_fetchrow( $result ) ) {

         $msnl_asRec['bid']            = intval( $row['bid'] );
         $msnl_asRec['imageurl']      = stripslashes( $row['imageurl'] );
         $msnl_asRec['clickurl']      = stripslashes( $row['clickurl'] );
         $msnl_asRec['alttext']      = stripslashes( $row['alttext'] );

         $msnl_asHTML['BANNERS']   .= "<input type=\"radio\" name=\"msnl_banner\" value=\""
                                                   .$msnl_asRec['bid']."\"";

         if ( $_POST['msnl_banner'] == $msnl_asRec['bid'] ) {

            $msnl_asHTML['BANNERS']   .= " CHECKED";

         }

         $msnl_asHTML['BANNERS']   .= " />\n"
               ."<a href=\"".$msnl_asRec['clickurl']."\">"
               ."<img ${msnl_asCSS['IMG_def']} src=\"".$msnl_asRec['imageurl']."\" alt=\"".$msnl_asRec['alttext']."\">"
               ."</a><br /><br />\n";

      } //End While for getting sponsor banners HTML

} //End IF of SQL call check
*/


Notice what I am commenting out of the code. Make sure to leave in the line with this in it:

$msnl_asHTML['BANNERS'] = "";
 
View user's profile Send private message Visit poster's website
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-bunch