SQL Eror

Newbie Joined: Jan 28, 2007 Posts: 1

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

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

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?

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

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

Spam Stopper - Comments Modules · Site Admin Joined: Jul 18, 2005 Posts: 308

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).

Newbie Joined: May 14, 2007 Posts: 2

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.

Spam Stopper - Comments Modules · Site Admin Joined: Jul 18, 2005 Posts: 308

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.

Newbie Joined: May 14, 2007 Posts: 2

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

Spam Stopper - Comments Modules · Site Admin Joined: Jul 18, 2005 Posts: 308

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;

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

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'] = "";