kostenloser Webspace werbefrei: lima-city

Nukephp5.5 -Problem

lima-city → Forum → Programmiersprachen → PHP, MySQL & .htaccess

1. Autor dieses Themas

   buechersternchen

   buechersternchen hat kostenlosen Webspace.

   4:27, 13.1.2006

   Hab gerade versucht phpNuke5.5 zu installieren und bekomme diverse Fehlermeldungen, was hab ich falsch gemacht?
   
   http://buechersternchen.pyrokar.lima-city.de/nuke/html/
   
   
   
   Beitrag ge?ndert am 13.01.2006 04:28 von buechersternchen

2. Diskutiere mit und stelle Fragen: Jetzt kostenlos anmelden!

   lima-city: Gratis werbefreier Webspace für deine eigene Homepage

3. a**e

   11:56, 13.1.2006

   Es sieht ganz danach aus, als seien noch keine Daten in der Datenbank bzw. falsche Datenbankanfragen in der Datei nuke/html/includes/sql_layer.php.
   
   ?berpr?fe zuerst, ob du die richtigen Daten zum Verbinden mit dem Server angegeben hast (Passwort/Nutzername/Host). Ich glaube aber, dass die Daten korrekt sind. (keine Fehlermeldung, die von mysql_connect() verursacht wird)
   
   Danach solltest du kontrollieren, ob die Datenbank besteht und ob du bereits Daten eingetragen hast.
   
   Wenn das Problem weiterhin besteht, w?re es sinnvoll die Datenbankanfragen zu kontrollieren bzw. die Datei sql_layer.php hier zu posten.
   
   mfg
   Arve
4. Autor dieses Themas

   buechersternchen

   buechersternchen hat kostenlosen Webspace.

   13:40, 13.1.2006

   danke erst mal
   
   also, die datenbank besteht. allerdings scheint sie leer zu sein
   
   ?ber die admin-seite l??t sie sich auch nicht einrichten, da kommen die identischen fehlermeldungen, wie schon beschrieben
   
   hier nun die sql_layer.php
   
   <?php
   
   /************************************************************************/
   /* PHP-NUKE: Web Portal System */
   /* =========================== */
   /* */
   /* Copyright (c) 2002 by Francisco Burzi (fbc@mandrakesoft.com) */
   /* http://phpnuke.org */
   /* */
   /* 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",$PHP_SELF)) {
   Header("Location: ../index.php");
   die();
   }
   
   /* $dbtype = "MySQL"; */
   /* $dbtype = "mSQL"; */
   /* $dbtype = "PostgreSQL"; */
   /* $dbtype = "PostgreSQL_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 "PostgreSQL":
   $dbi=@pg_connect("host=$host user=$user password=$password port=5432 dbname=$db");
   return $dbi;
   break;;
   
   case "PostgreSQL_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 "PostgreSQL":
   case "PostgreSQL_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);
   return $res;
   break;;
   
   case "mSQL":
   $res=@msql_query($query, $id);
   return $res;
   break;;
   
   case "PostgreSQL":
   case "PostgreSQL_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);
   return $rows;
   break;;
   
   case "mSQL":
   $rows=msql_num_rows($res);
   return $rows;
   break;;
   
   case "PostgreSQL":
   case "PostgreSQL_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 PostgreSQL
   */
   
   function sql_fetch_row($res, $nr)
   {
   global $dbtype;
   switch ($dbtype) {
   
   case "MySQL":
   $row = mysql_fetch_row($res);
   return $row;
   break;;
   
   case "mSQL":
   $row = msql_fetch_row($res);
   return $row;
   break;;
   
   case "PostgreSQL":
   case "PostgreSQL_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 PostgreSQL.
   */
   
   function sql_fetch_array($res, $nr)
   {
   global $dbtype;
   switch ($dbtype)
   {
   case "MySQL":
   $row = array();
   $row = mysql_fetch_array($res);
   return $row;
   break;;
   
   case "mSQL":
   $row = array();
   $row = msql_fetch_array($res);
   return $row;
   break;;
   
   case "PostgreSQL":
   case "PostgreSQL_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)
   {
   global $dbtype;
   switch ($dbtype)
   {
   case "MySQL":
   $row = mysql_fetch_object($res);
   if($row) return $row;
   else return false;
   break;;
   
   case "mSQL":
   $row = msql_fetch_object($res);
   if($row) return $row;
   else return false;
   break;;
   
   case "PostgreSQL":
   case "PostgreSQL_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);
   return $row;
   break;;
   
   case "mSQL":
   $row = msql_free_result($res);
   return $row;
   break;;
   
   
   case "PostgreSQL":
   case "PostgreSQL_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;;
   }
   }
   
   ?>

5. a**e

   19:02, 13.1.2006

   Habs nur kurz ?berflogen. Ich glaube, dass es daran liegt, dass du den Datenbanktyp nicht eingestellt hast.
   

   /* $dbtype = "MySQL"; */

   
   Kommentare entfernen:
   

   $dbtype = "MySQL";

   
   
   probiers einfach mal.
   
   Bei einem professionellen System, wie PHPNuke sollten eigentlich Fehlermeldungen kommen, wenn nichts in der Daten bank ist.
   
   mfg
   Arve
   

6. Diskutiere mit und stelle Fragen: Jetzt kostenlos anmelden!

   lima-city: Gratis werbefreier Webspace für deine eigene Homepage

Dir gefällt dieses Thema?