Datenbankfehler - Wer kann helfen ?

Ich seh hier ehrlich gesagt keinen Zusammenhang mit einer Datenbank...

Bitte mal den Quelltext von global.php posten.

Ich seh hier ehrlich gesagt keinen Zusammenhang mit einer Datenbank...

Bitte mal den Quelltext von global.php posten.

<?php
/**
* This sets the correct headers that we need. For example UTF-8 encoding of the pages
* it also reads general data that is needed in many places of TSEP
*
* @author Sebastian P�erl
*
* following will be filled automatically by SubVersion!
* Do not change by hand!
*  $LastChangedDate: 2005-09-01 15:14:02 +0200 (Do, 01 Sep 2005) $
*  @lastedited $LastChangedBy: toon $
*  $LastChangedRevision: 303 $
*
*/

/* !!! Do not change or delete these placeholders !!! */
/* !!! They are used by setup !!! *
/* %BEGIN_SETUP_DATABASE_DATA% */
/* URL to your database server */
$db_server = 'localhost';
/* Your database login name */
$db_usrname = 'test';
/* Your database password */
$db_pwd = 'test';
/* TSEP database name */
$db_name = 'tsep';
/* TSEP table prefix */
$db_table_prefix = 'tsep_';
/* %END_SETUP_DATABASE_DATA% */


/* Force the browser to use UTF-8 enconding */
$headers  = "Content-type: text/html; charset=utf-8\r\n";
$headers .= "Content-Transfer-Encoding: 8bit\r\n";
header($headers);

//stop caching dynamic pages
//from http://de3.php.net/header
// Date in the past
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
// always modified
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
// HTTP/1.1
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
// HTTP/1.0
header("Pragma: no-cache");



/* Get the TSEP root folder */
if ( !mysql_connect( $db_server, $db_usrname, $db_pwd ) ) {
    die("<b>Can't connect to the database.</b><br />MySQL error: ".mysql_error() );
}
if ( !mysql_select_db( $db_name ) ) {
    die("<b>Can't open TSEP database.</b><br />MySQL error: ".mysql_error() );
}
$SQLResult = mysql_query( "SELECT stringvalue FROM ".$db_table_prefix."internal WHERE description='absPath' and stringtag='config'" ) or die( "<b>Couldn't read from the database.</b><br />MySQL error: ".mysql_error() );
list( $tsepRootDir ) = mysql_fetch_row( $SQLResult );
@mysql_close();

/* Open connection to the database */
require_once( "$tsepRootDir/include/dbconnection.php" );
/* general config data */
require_once( "$tsepRootDir/include/config.php" );

/* read language strings */
/* include for security - if admin enters something that does not exist */
/* always read english language as some (new) strings might not have been translated */
include( "$tsepRootDir/language/en_US/language.php" );
/* code recycle: get language strings from fitting language.php */
include( "$tsepRootDir/language/".$tsep_config['config_Language']."/language.php" );
/* handles language related issues */
require_once( "$tsepRootDir/include/languagehandler.php" );

/* Include debug framework */
require_once( "$tsepRootDir/include/tseptrace.php" );

?>

@Schwoebel: Die Fehlermeldung, die bei deiner Diagnose kommt, lautet etwas anders. Warten wir besser mal auf den Code . Auch ist eine Pufferung der Ausgaben, wie du sie beschrieben hast, nicht als Allheilmittel zu sehen. Wenn man mal ehrlich ist, dann lässt sich deren Verwendung in geschätzten 90% der Fälle vermeiden, wenn man einfach nur sauber programmiert.

OK, das war bei der Fehlermeldung zu erwarten. Die Umbrüche in den Header-Anweisungen machen Probleme.

Ersetze mal die 3 Zeilen unter dem Kommentar /* Force the browser to use UTF-8 enconding */ mit folgendem:

Schhön, das hat geklappt. Vielen Dank. Bei dem Ausweisen der Suchergebnisse bekomme ich folgende Fehlermeldung:

 

Warning: main() [function.main]: open_basedir restriction in effect. File(/php/tsep.0942/search.php ) is not within the allowed path(s): (/www/htdocs/v139072/:/tmp:/usr/bin:/www/htdocs/v139072:/bin:/usr/local/bin:/usr/share/php ) in /www/htdocs/v139072/search.php on line 249

Warning: main(/php/tsep.0942/search.php ) [function.main]: failed to open stream: Operation not permitted in /www/htdocs/v139072/search.php on line 249

Warning: main() [function.main]: open_basedir restriction in effect. File(/php/tsep.0942/search.php ) is not within the allowed path(s): (/www/htdocs/v139072/:/tmp:/usr/bin:/www/htdocs/v139072:/bin:/usr/local/bin:/usr/share/php ) in /www/htdocs/v139072/search.php on line 249

Warning: main(/php/tsep.0942/search.php ) [function.main]: failed to open stream: Operation not permitted in /www/htdocs/v139072/search.php on line 249

Fatal error: main() [function.require]: Failed opening required '/php/tsep.0942/search.php' (include_path='.:/usr/share/php:..') in /www/htdocs/v139072/search.php on line 249

Hallo,

include_path='.:/usr/share/php:..')

Ich geh mal stark davon aus, dass es sich um einen Shared Host handelt, zumindest suggeriert das der Pfad. Da sieht's schlecht dann aus mit Eingriffen in die Konfiguration

greez
JoSsiF

Hallo,

ja, das ist ein Shared Host. Das Script ist aber nicht selbst geschrieben und somit sollte es doch ohne "Eingriffe" sondern nur mit Anpassungen funktionieren, oder ?

Das Script ist aber nicht selbst geschrieben und somit sollte es doch ohne "Eingriffe" sondern nur mit Anpassungen funktionieren, oder ?

Hallo,

doch, Pfade müssen angepasst werden. Anleitung gibt es, finde aber nichts, was ich vergessen habe. Hier ist der Link

Jetzt bin ich etwas weitre. Jetzt kommt nur noch diese Fehlermeldung:

 

Warning: Division by zero in /www/htdocs/v139072/tsep.0942/include/pagenavigation.php on line 25
Ergebnisse
1 - 28
von
28
Treffern.
Die Suche benötigte
0.396
Sekunden.

Warning: Division by zero in /www/htdocs/v139072/tsep.0942/include/recordsplit.php on line 81

Warning: Division by zero in /www/htdocs/v139072/tsep.0942/include/recordsplit.php on line 72

Warning: Division by zero in /www/htdocs/v139072/tsep.0942/include/recordsplit.php on line 72
<< -10 -9 -8 -7 -6 -5 -4 -3 -2 -1 0 >> >|
Es wurde gesucht nach
wave

Warning: Division by zero in /www/htdocs/v139072/tsep.0942/include/pagenavigation.php on line 25

"Division by zero" - als USA-Reisender weißt du ja sicher, was das heißt

Der Entwickler hat da wohl einen Ausnahmefall ungenügend behandelt. Spricht nicht gerade für die Qualität des Skripts.

Könnte mir vorstellen, dass das Problem bei einer einzigen Variablen hängt. Vielleicht kannst du's beheben, die Zeilenangabe liefert dir ja die Fehlermeldung.

Hallo,

ich habe die "recordsplit.php" schon rauf und runter gesucht aber nichts gefunden. Hat mir vielleicht jemand einen Tipp ?

 

<?php
/**
* Split the search in userdefined (!) records. Splits a large amount of search results into different pages
*
* @author Sebastian P�lsterl
*
* following will be filled automatically by SubVersion!
* Do not change by hand!
*  $LastChangedDate: 2005-06-09 22:00:51 +0200 (Do, 09 Jun 2005) $
*  @lastedited $LastChangedBy: sebastian $
*  $LastChangedRevision: 120 $
*
*/

class recordsplit {
   
   var $offset = 5;
   var $results_count;
   var $results_per_page;
   var $start;
   
   /**
    * Assign values at init
    *
    * @param $results_count integer
    * @param $results_per_page integer
    * @param $start integer
    */
   function recordsplit($results_count, $results_per_page, $start) {
      $this->results_count = $results_count;
      $this->results_per_page = $results_per_page;
      $this->start = $start;
            
      return;
   }
   
   /**
    * Returns the number of first results on previous page
    *
    * @return false if current page is 1 or the starting result of previous page
    */
   function getPreviousPageStart() {
      $diff = $this->start - $this->results_per_page;
      return ($diff < 0) ? false : $diff;
   }
   
   /**
    * Returns the number of the first result on the next page
    *
    * @return false if current page is the last one or the starting result of next page
    */
   function getNextPageStart() {
      $sum = $this->start + $this->results_per_page;
      return ($sum > $this->results_count) ? false : $sum;
   }
   
   /**
    * Returns the number of the first entry on the last page
    *
    * @return integer
    */
   function getLastPageStart() {
      return $this->results_per_page * $this->getLastPageNumber() - $this->results_per_page;
   }
   
   /**
    * Returns the number of the last page
    *
    * @return double
    */
   function getLastPageNumber() {
      return ceil($this->results_count / $this->results_per_page);
   }
   
   /**
    * Returns the number of the current page
    *
    * @return integer
    */
   function getCurrentPageNumber() {
      return $this->start / $this->results_per_page + 1;
   }
   
   /**
    * Returns an array containing the page navigation
    *
    * @return array
    */
   function getNavigation() {
      global $tsep_lng;
      
      $currentPage = $this->getCurrentPageNumber();
      $lastPage = $this->getLastPageNumber();
      
      // Don't display navigation with only one site
      if ($lastPage == 1) {
         return NULL;
      }
      
      // Don't show link to first page if current page is first page
      if ($currentPage != 1) {
         $start = 0;      
         $pages['first'] = array('title' => $tsep_lng['help_first_page'] ." - ". $tsep_lng['results']." ".($start+1)." ".$tsep_lng['to'] ." ".($start + $this->results_per_page),
                           'value' => '&#124;&lt;',
                           'start' => $start);
      }
      // show link to previous page only if current page != 1
      if ($this->getPreviousPageStart() !== false) {
         $start = $this->getPreviousPageStart();
         $pages['previous'] = array('title' => $tsep_lng['help_previous_page'] ." - ". $tsep_lng['results']." ".($start+1)." ".$tsep_lng['to'] ." ".($start + $this->results_per_page),
                              'value' => '&lt;&lt;',
                              'start' => $start);      
      }
      
      if ($this->results_count <= 11 * $this->results_per_page) {
         // navigation for 11 or less pages total
         for ($i=1; $i<=$this->getLastPageNumber(); $i++) {
            if ($i == $currentPage) {               
               $pages["$i"] = array('value' => "$i", 'start' => NULL);
            } else {
               $start = $i * $this->results_per_page - $this->results_per_page;
               $pages["$i"] = array('title' => $tsep_lng['results']." ".($start+1)." ".$tsep_lng['to'] ." ".($start + $this->results_per_page),
                               'value' => "$i",
                               'start' => $start);
            }
         }            
      } else {
         // navigation for more than 11 pages of results      
         
         $page_start = $currentPage - $this->offset;
         $page_end = $currentPage + $this->offset;
         
         // first and last page if current page == 1
         if ($page_start < 1) {
            $page_start = 1;
            $page_end = 10;
         }         
         
         // first and last page if current page == last page
         if ($page_end > $lastPage) {
            $page_start = $lastPage - 10;
            $page_end = $lastPage;
         }
         
         // build navigation
         for ($i=$page_start; $i<=$page_end; $i++) {
            if ($i == $currentPage) {
               $pages["$i"] = array('value' => "$i", 'start' => NULL);
            } else {
               $start = $i * $this->results_per_page - $this->results_per_page;
               $pages["$i"] = array('title' => $tsep_lng['results']." ".($start+1)." ".$tsep_lng['to'] ." ".($start + $this->results_per_page),
                               'value' => "$i",
                               'start' => $start);
            }
         }
      }
      
      // show link to next page only if current page != last page
      if ($this->getNextPageStart() !== false) {
         $start = $this->getNextPageStart();
         $pages['next'] = array('title' => $tsep_lng['help_next_page'] ." - ". $tsep_lng['results']." ".($start+1)." ".$tsep_lng['to'] ." ".($start + $this->results_per_page),
                           'value' => '&gt;&gt;',
                           'start' => $start);
      }
      
      // Don't show link to last page if current page is last page
      if ($currentPage != $lastPage) {
         $start = (int) $this->getLastPageStart();
         $pages['last'] = array('title' => $tsep_lng['help_last_page'] ." - ". $tsep_lng['results']." ".($start+1)." ".$tsep_lng['to'] ." ".($start + $this->results_per_page),
                           'value' => '&gt;&#124;',
                           'start' => $start);
      }
      
      return $pages;
   }
   
} // end class
   
   // create object
   $r = new recordsplit($page_count, $tsep_config['config_How_Many_Results'], $s);
   $pages = $r->getNavigation();
   if(!is_null($pages)) {
      print "<div class=\"DivManyPages\">"; //open div "DivManyPages"
      
      // print navigation
      foreach ($pages as $page) {
         if (!is_null($page['start'])) {
            print "<a href=\"". $script ."?q=". rawurlencode($q) ."&amp;s=". $page['start'] ."&amp;user_e=". $user_e ."\" title=\"". $page['title'] ."\"><span class=\"PageNavigation\">". $page['value'] ."</span></a>\n";
         } else {
            print "<span class=\"PageNavigation\">[". $page['value'] ."]</span>\n";
         }
      }
      
      print "</div>"; //close div "DivManyPages"
   }
   
?>