forum error...can you help me?

  Post new topicReply to topicPrintable Version
<< View previous topic View next topic >>
Share: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
#1   forum error...can you help me?
silverflame
CZ Newbie
silverflame has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Jan 29, 2004
0.00 posts per day
Posts: 6
Points: 356
   
I keep getting this error when trying to visit the forum on my website...of course it is a nuke site icon_smile.gif

General Error

Tried obtaining data. It failed

DEBUG MODE

SQL Error : 1146 Table 'mysite.nuke_board_message' doesn't exist

SELECT msg_id, title, message, showpage , auth, width, images, ordr, bbcode_uid, startdate, enddate, users_timezone FROM nuke_board_message WHERE ((showpage <> '-9999' AND showpage = '0' ) OR showpage = '9999') AND MID(days,6,1) = '1' AND auth <= 3 AND startdate <= 1075468487 AND enddate >= 1075468487

Line : 131
File : /home/mysite/public_html/includes/functions_bm.php

Is there anything I could do? Any mySQL query I could run or something?



Back to top Reply with quote
#2   re: forum error...can you help me?
Taut
PayPal Donation
CZ Revered Member
 Codezwiz Site Donator
usa.gif california.gif
Occupation: Entrepreneur
Gender: Female
Fav. Sports Team: SF Giants
Status: Offline
Joined: May 27, 2003
0.71 posts per day
Posts: 5530
Points: 481,695
   
what version are you running...seems your are missing one of the tables.


taut



Back to top Reply with quote
#3   re: forum error...can you help me?
silverflame
CZ Newbie
silverflame has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Jan 29, 2004
0.00 posts per day
Posts: 6
Points: 356
   
well...I was upgrading my nuke from 6.0 with splatt forum to nuke 6.8...and used the upgrade script within the nuke and not nukesql. when I tried nukesql.php, it never got past the conntest page...I used the mysql connect file on nuke cops to make sure my info was right, and it was...I don't know what to do though... icon_sad.gif



Back to top Reply with quote
#4   re: forum error...can you help me?
Taut
PayPal Donation
CZ Revered Member
 Codezwiz Site Donator
usa.gif california.gif
Occupation: Entrepreneur
Gender: Female
Fav. Sports Team: SF Giants
Status: Offline
Joined: May 27, 2003
0.71 posts per day
Posts: 5530
Points: 481,695
   
am not familiar with the type of forum you are using but the same error messages were posted and can be found in this article, although it is for a diff forum version
[ Register or login to view links on this board. ]

if that doesn't help fix your problem, please post back


taut



Back to top Reply with quote
#5   re: forum error...can you help me?
silverflame
CZ Newbie
silverflame has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Jan 29, 2004
0.00 posts per day
Posts: 6
Points: 356
   
I have this error now...
Fatal error: Failed opening required 'includes/sql_layer.php' (include_path='.:/usr/share/pear') in /home/mysite/public_html/mainfile.php on line 80
upon looking in my directory, I see no sql_layer.php file on my server...however, is there any way I could get it without downloading the nuke again?



Back to top Reply with quote
#6   re: forum error...can you help me?
Taut
PayPal Donation
CZ Revered Member
 Codezwiz Site Donator
usa.gif california.gif
Occupation: Entrepreneur
Gender: Female
Fav. Sports Team: SF Giants
Status: Offline
Joined: May 27, 2003
0.71 posts per day
Posts: 5530
Points: 481,695
   
hang on am getting you one from my site: here ya go

<?php

/************************************************************************/
/* PHP-NUKE: Web Portal System                                          */
/* ===========================                                          */
/*                                                                      */
/* Copyright (c) 2002 by Francisco Burzi                                */
/* http://phpnuke.org                                                   */
/*                                                                      */
/* postgres fix by Rubén Campos - Oscar Silla                         */
/*                                                                      */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License.       */
/************************************************************************/

if (eregi("sql_layer.php",$_SERVER['PHP_SELF'])) {
    Header("Location: ../index.php");
    die();
}

/* $dbtype = "MySQL"; */
/* $dbtype = "mSQL"; */
/* $dbtype = "postgres"; */
/* $dbtype = "postgres_local";// When postmaster start without "-i" option. */
/* $dbtype = "ODBC"; */
/* $dbtype = "ODBC_Adabas"; */
/* $dbtype = "Interbase"; */
/* $dbtype = "Sybase"; */

/*
* sql_connect($host, $user, $password, $db)
* returns the connection ID
*/


class ResultSet {
   var $result;
   var $total_rows;
   var $fetched_rows;

   function set_result( $res ) {
      $this->result = $res;
   }

   function get_result() {
      return $this->result;
   }

   function set_total_rows( $rows ) {
      $this->total_rows = $rows;
   }

   function get_total_rows() {
      return $this->total_rows;
   }

   function set_fetched_rows( $rows ) {
      $this->fetched_rows = $rows;
   }

   function get_fetched_rows() {
      return $this->fetched_rows;
   }

   function increment_fetched_rows() {
      $this->fetched_rows = $this->fetched_rows + 1;
   }
}



function sql_connect($host, $user, $password, $db)
{
global $dbtype;
switch ($dbtype) {

    case "MySQL":
        $dbi=@mysql_connect($host, $user, $password);
   mysql_select_db($db);
        return $dbi;
    break;;

    case "mSQL":
         $dbi=msql_connect($host);
    msql_select_db($db);
    return $dbi;
    break;;


    case "postgres":
         $dbi=@pg_connect("host=$host user=$user password=$password port=5432 dbname=$db");
         return $dbi;
    break;;

    case "postgres_local":
         $dbi=@pg_connect("user=$user password=$password dbname=$db");
         return $dbi;
    break;;

    case "ODBC":
         $dbi=@odbc_connect($db,$user,$password);
         return $dbi;
    break;;

    case "ODBC_Adabas":
         $dbi=@odbc_connect($host.":".$db,$user,$password);
    return $dbi;
    break;;

    case "Interbase":
         $dbi=@ibase_connect($host.":".$db,$user,$password);
         return $dbi;
    break;;

    case "Sybase":
        $dbi=@sybase_connect($host, $user, $password);
       sybase_select_db($db,$dbi);
   return $dbi;
    break;;

    default:
    break;;
    }

}

function sql_logout($id)
{
global $dbtype;
switch ($dbtype) {

    case "MySQL":
        $dbi=@mysql_close($id);
        return $dbi;
    break;;

    case "mSQL":
         $dbi=@msql_close($id);
         return $dbi;
    break;;

    case "postgres":
    case "postgres_local":
         $dbi=@pg_close($id);
         return $dbi;
    break;;
 
    case "ODBC":
    case "ODBC_Adabas":
         $dbi=@odbc_close($id);
         return $dbi; 
    break;;

    case "Interbase":
         $dbi=@ibase_close($id);
         return $dbi;
    break;;

    case "Sybase":
        $dbi=@sybase_close($id);
        return $dbi;
    break;;

    default:
    break;;
    }
}


/*
* sql_query($query, $id)
* executes an SQL statement, returns a result identifier
*/

function sql_query($query, $id)
{

global $dbtype;
global $sql_debug;
$sql_debug = 0;
if($sql_debug) echo "SQL query: ".str_replace(",",", ",$query)."<BR>";
switch ($dbtype) {

    case "MySQL":
        $res=@mysql_query($query, $id);
        if (mysql_errno()) { echo mysql_error()."<br>"; }
        return $res;
    break;;

    case "mSQL":
        $res=@msql_query($query, $id);
        return $res;
    break;;

    case "postgres":
    case "postgres_local":
   $res=pg_exec($id,$query);
   $result_set = new ResultSet;
   $result_set->set_result( $res );
   $result_set->set_total_rows( sql_num_rows( $result_set ) );
   $result_set->set_fetched_rows( 0 );
        return $result_set;
    break;;

    case "ODBC":
    case "ODBC_Adabas":
        $res=@odbc_exec($id,$query);
        return $res;
    break;;

    case "Interbase":
        $res=@ibase_query($id,$query);
        return $res;
    break;;

    case "Sybase":
        $res=@sybase_query($query, $id);
        return $res;
    break;;

    default:
    break;;

    }
}

/*
* sql_num_rows($res)
* given a result identifier, returns the number of affected rows
*/

function sql_num_rows($res)
{
global $dbtype;
switch ($dbtype) {

    case "MySQL":
        $rows=mysql_num_rows($res);
        if (mysql_errno()) { echo mysql_error()."<br>"; }
        return $rows;
    break;;

    case "mSQL": 
        $rows=msql_num_rows($res);
        return $rows;
    break;;

    case "postgres":
    case "postgres_local":
        $rows=pg_numrows( $res->get_result() );
        return $rows;
    break;;
       
    case "ODBC":
    case "ODBC_Adabas":
        $rows=odbc_num_rows($res);
        return $rows;
    break;;
       
    case "Interbase":
   echo "<BR>Error! PHP dosen't support ibase_numrows!<BR>";
        return $rows;
    break;;

    case "Sybase":
        $rows=sybase_num_rows($res);
        return $rows;
    break;;

    default:
    break;;
    }
}

/*
* sql_fetch_row(&$res,$row)
* given a result identifier, returns an array with the resulting row
* Needs also a row number for compatibility with postgres
*/

function sql_fetch_row(&$res, $nr=0)
{
global $dbtype;
switch ($dbtype) {

    case "MySQL":
        $row = mysql_fetch_row($res);
        if (mysql_errno()) { echo mysql_error()."<br>"; }
        return $row;
    break;;

    case "mSQL":
        $row = msql_fetch_row($res);
        return $row;
    break;;

    case "postgres":
    case "postgres_local":
   if ( $res->get_total_rows() > $res->get_fetched_rows() ) {
      $row = pg_fetch_row($res->get_result(), $res->get_fetched_rows() );
      $res->increment_fetched_rows();
      return $row;
   } else {
      return false;
   }
    break;;

    case "ODBC":
    case "ODBC_Adabas":
        $row = array();
        $cols = odbc_fetch_into($res, $nr, $row);
        return $row;
    break;;

    case "Interbase":
        $row = ibase_fetch_row($res);
        return $row;
    break;;

    case "Sybase":
        $row = sybase_fetch_row($res);
        return $row;
    break;;

    default:
    break;;
    }
}

/*
* sql_fetch_array($res,$row)
* given a result identifier, returns an associative array
* with the resulting row using field names as keys.
* Needs also a row number for compatibility with postgres.
*/

function sql_fetch_array(&$res, $nr=0)
{
global $dbtype;
switch ($dbtype)
    {
    case "MySQL":
        $row = array();
        $row = mysql_fetch_array($res);
        if (mysql_errno()) { echo mysql_error()."<br>"; }
        return $row;
    break;;

    case "mSQL":
        $row = array();
        $row = msql_fetch_array($res);
        return $row;
    break;;

    case "postgres":
    case "postgres_local":
   if( $res->get_total_rows() > $res->get_fetched_rows() ) {
      $row = array();
      $row = pg_fetch_array($res->get_result(), $res->get_fetched_rows() );
      $res->increment_fetched_rows();
      return $row;
   } else {
      return false;
   }
    break;;

/*
* ODBC doesn't have a native _fetch_array(), so we have to
* use a trick. Beware: this might cause HUGE loads!
*/

    case "ODBC":
        $row = array();
        $result = array();
        $result = odbc_fetch_row($res, $nr);
   $nf = odbc_num_fields($res); /* Field numbering starts at 1 */
        for($count=1; $count < $nf+1; $count++)
   {
            $field_name = odbc_field_name($res, $count);
            $field_value = odbc_result($res, $field_name);
            $row[$field_name] = $field_value;
        }
        return $row;
    break;;

    case "ODBC_Adabas":
        $row = array();
        $result = array();
        $result = odbc_fetch_row($res, $nr);

        $nf = count($result)+2; /* Field numbering starts at 1 */
   for($count=1; $count < $nf; $count++) {
       $field_name = odbc_field_name($res, $count);
       $field_value = odbc_result($res, $field_name);
       $row[$field_name] = $field_value;
   }
        return $row;
    break;;

    case "Interbase":
   $orow=ibase_fetch_object($res);
   $row=get_object_vars($orow);
        return $row;
    break;;

    case "Sybase":
        $row = sybase_fetch_array($res);
        return $row;
    break;;

    }
}

function sql_fetch_object(&$res, $nr=0)
{
global $dbtype;
switch ($dbtype)
    {
    case "MySQL":
        $row = mysql_fetch_object($res);
        if (mysql_errno()) { echo mysql_error()."<br>"; }
   if($row) return $row;
   else return false;
    break;;

    case "mSQL":
        $row = msql_fetch_object($res);
   if($row) return $row;
   else return false;
    break;;

    case "postgres":
    case "postgres_local":
   if( $res->get_total_rows() > $res->get_fetched_rows() ) {
      $row = pg_fetch_object( $res->get_result(), $res->get_fetched_rows() );
      $res->increment_fetched_rows();
      if($row) return $row;
      else return false;
   } else {
      return false;
   }
    break;;

    case "ODBC":
        $result = odbc_fetch_row($res, $nr);
   if(!$result) return false;
   $nf = odbc_num_fields($res); /* Field numbering starts at 1 */
        for($count=1; $count < $nf+1; $count++)
   {
            $field_name = odbc_field_name($res, $count);
            $field_value = odbc_result($res, $field_name);
            $row->$field_name = $field_value;
        }
        return $row;
    break;;

    case "ODBC_Adabas":
        $result = odbc_fetch_row($res, $nr);
   if(!$result) return false;

        $nf = count($result)+2; /* Field numbering starts at 1 */
   for($count=1; $count < $nf; $count++) {
       $field_name = odbc_field_name($res, $count);
       $field_value = odbc_result($res, $field_name);
       $row->$field_name = $field_value;
   }
        return $row;
    break;;

    case "Interbase":
        $orow = ibase_fetch_object($res);
   if($orow)
   {
       $arow=get_object_vars($orow);
       while(list($name,$key)=each($arow))
       {
      $name=strtolower($name);
      $row->$name=$key;
       }
           return $row;
   }else return false;
    break;;

    case "Sybase":
        $row = sybase_fetch_object($res);
        return $row;
    break;;

    }
}

/*** Function Free Result for function free the memory ***/
function sql_free_result($res) {
global $dbtype;
switch ($dbtype) {

    case "MySQL":
        $row = mysql_free_result($res);
        if (mysql_errno()) { echo mysql_error()."<br>"; }
        return $row;
    break;;

      case "mSQL":
        $row = msql_free_result($res);
        return $row;
    break;;


       case "postgres":
    case "postgres_local":
        $rows=pg_FreeResult( $res->get_result() );
        return $rows;
    break;;

    case "ODBC":
    case "ODBC_Adabas":
        $rows=odbc_free_result($res);
        return $rows;
    break;;

    case "Interbase":
   echo "<BR>Error! PHP dosen't support ibase_numrows!<BR>";
        return $rows;
    break;;

    case "Sybase":
        $rows=sybase_free_result($res);
        return $rows;
    break;;
   }
}

?>






taut


Back to top Reply with quote
#7   re: forum error...can you help me?
silverflame
CZ Newbie
silverflame has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Jan 29, 2004
0.00 posts per day
Posts: 6
Points: 356
   
the main page opens, however the forum on the other hand...still reads this error
Fatal error: Failed opening required 'modules/Forums/nukebb.php' (include_path='.:/usr/share/pear') in /home/ki-teachings/public_html/modules/Forums/index.php on line 67

I apologize if this is an inconvenience...but I honestly don't have that in my forums folder...and I am not at work, so I can check my workstation to complete the upgrade...anyone have the file?



Back to top Reply with quote
#8   re: forum error...can you help me?
Taut
PayPal Donation
CZ Revered Member
 Codezwiz Site Donator
usa.gif california.gif
Occupation: Entrepreneur
Gender: Female
Fav. Sports Team: SF Giants
Status: Offline
Joined: May 27, 2003
0.71 posts per day
Posts: 5530
Points: 481,695
   
if you are missing all these files, you would probably be better of with a fresh install but for your convenience here's the file:

<?php
/***************************************************************************
* phpbb2 forums port version 2.1 (c) 2003 - Nuke Cops (http://nukecops.com)
*
* Ported by Paul Laudanski (Zhen-Xjell) to phpbb2 standalone 2.0.4.  Test
* and debugging completed by the Elite Nukers at Nuke Cops: ArtificialIntel,
* Chatserv, MikeM, sixonetonoffun, Zhen-Xjell.  Thanks to some heavy debug
* work by AI in Nuke 6.5.
*
* You run this package at your sole risk.  Nuke Cops and affiliates cannot
* be held liable if anything goes wrong.  You are advised to test this
* package on a development system.  Backup everything before implementing
* in a production environment.  If something goes wrong, you can always
* backout and restore your backups.
*
* Installing and running this also means you agree to the terms of the AUP
* found at Nuke Cops.
*
* This is version 2.1 of the phpbb2 forum port for PHP-Nuke.  Work is based
* on Tom Nitzschner's forum port version 2.0.6.  Tom's 2.0.6 port was based
* on the phpbb2 standalone version 2.0.3.  Our version 2.1 from Nuke Cops is
* now reflecting phpbb2 standalone 2.0.4 that fixes some major SQL
* injection exploits.
***************************************************************************/

/***************************************************************************
*   This file is part of the phpBB2 port to Nuke 6.0 (c) copyright 2002
*   by Tom Nitzschner (tom@toms-home.com)
*   http://bbtonuke.sourceforge.net (or http://www.toms-home.com)
*
*   As always, make a backup before messing with anything. All code
*   release by me is considered sample code only. It may be fully
*   functual, but you use it at your own risk, if you break it,
*   you get to fix it too. No waranty is given or implied.
*
*   Please post all questions/request about this port on http://bbtonuke.sourceforge.net first,
*   then on my site. All original header code and copyright messages will be maintained
*   to give credit where credit is due. If you modify this, the only requirement is
*   that you also maintain all original copyright messages. All my work is released
*   under the GNU GENERAL PUBLIC LICENSE. Please see the README for more information.
*
***************************************************************************/

if (!eregi("modules.php", $_SERVER['PHP_SELF'])) {
    die ("You can't access this file directly...");
}
   
global $phpbb_root_path, $nuke_root_path, $nuke_file_path, $php_root_dir, $module_name, $nukename, $pass, $nukename;
$module_name = "Forums";
$nuke_root_path = "modules.php?name=".$module_name;
$nuke_file_path = "modules.php?name=".$module_name."&file=";
$phpbb_root_path = "modules/".$module_name."/";
$phpbb_root_dir = "./../";
require_once("mainfile.php");
get_lang($module_name);

include("header.php");
?>




hope that helps

taut


Back to top Reply with quote
#9   re: forum error...can you help me?
silverflame
CZ Newbie
silverflame has been a member for over 20 year's 20 Year Member
Status: Offline
Joined: Jan 29, 2004
0.00 posts per day
Posts: 6
Points: 356
   
looks like this might be the last error in the admin module...when trying to admin the forums...this message
phpBB : Critical Error

Could not open subSilver template config file

DEBUG MODE

Line : 370
File : /home/mysite/public_html/includes/functions.php
I hope this is the last error...and again I apologize for the inconvenience



Back to top Reply with quote
#10   re: forum error...can you help me?
Taut
PayPal Donation
CZ Revered Member
 Codezwiz Site Donator
usa.gif california.gif
Occupation: Entrepreneur
Gender: Female
Fav. Sports Team: SF Giants
Status: Offline
Joined: May 27, 2003
0.71 posts per day
Posts: 5530
Points: 481,695
   
unfortunately, you will have to re upload that theme. I don't have that theme so I can't give you anything.....sorry or you may want to read this:
[ Register or login to view links on this board. ]


taut



Back to top Reply with quote
Display posts from previous:      
Add To: Del.icio.us  Digg  Google  Spurl  Blink  Furl  Y! MyWeb  
<< View previous topic View next topic >>
Post new topicReply to topic

Jump to 
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
You cannot attach files in this forum
You cannot download files in this forum