Nach Neuinstallation sind schon Einträge in der Errorlog

Gesperrt
Azibi
Beiträge: 13
Registriert: Di 23. Mär 2004, 19:19
Kontaktdaten:

Nach Neuinstallation sind schon Einträge in der Errorlog

Beitrag von Azibi » Mo 7. Jun 2004, 12:04

Hallo.

Endlich habe auch ich mal ein Problem mit Contenido. Ich benutze die Version 4.4.4.
Nachdem der Server meines Providers komplett gehackt und alle Daten gelöscht wurden muß ich jetzt nochmal von vorne anfangen. Aber egal.

Also ich habe eine Neuinstallation gemacht... Nun kann ich nur noch die Startseite des Frontend sehen, versuche ich zum Beispiel den Kontakt zu öffnen bekomme ich nur noch eine weiße Seite und habe dann so einige Einträge in der Errorlog.

Ich hänge jetzt mal die Einstellungen und den Inhalt der Log-Datei an:

Einstellungen:

Code: Alles auswählen

Variable Lokaler Wert 
Contenido-Version 4.4.4 
Contenido-Pfad /home/htdocs/web5/html/foliendesign/contenido/ 
Contenido-HTML-Pfad ../contenido/ 
Contenido HTML-Pfad http://www.azibi.de/foliendesign/contenido/ 
Frontend-Pfad /home/htdocs/web5/html/foliendesign 
Contenido PHPLib-Pfad /home/htdocs/web5/html/foliendesign/conlib/ 
Contenido WYSIWYG-Pfad /home/htdocs/web5/html/foliendesign/contenido/external/wysiwyg/spaw/ 
Contenido WYSIWYG HTML-Pfad http://www.azibi.de/foliendesign/contenido/external/wysiwyg/spaw/ 
Hostname www.azibi.de 
Browser-Pfad http://www.azibi.de/foliendesign/contenido/ 
Mandanteninformationen Anzahl der Mandanten:1
Mandanten-Einstellungen Werte 
Foliendesign 
Sprache(n) deutsch  
HTM-Pfad http://www.azibi.de/foliendesign/cms/  
frontend-Pfad /home/htdocs/web5/html/foliendesign/cms/  
 
Anzahl der Benutzer 2 
Anzahl der Artikel 15 
Serverbetriebssystem Apache/2.0.48 (Linux/SuSE) 
MySQL Serverversion 4.0.15 
Installierte PHP-Version 4.3.3 
safe_mode Aktiviert 
magic_quotes_gpc Aktiviert 
magic_quotes_runtime Deaktiviert 
gpc_order GPC 
memory_limit 60M 
max_execution_time 30 
Deaktivierte Funktionen nothing disabled 
Gettext extension loaded 
sql.safe_mode Deaktiviert 
GD-Bibliothek Einstellungen Werte 
GD Support  enabled  
GD Version  bundled (2.0.15 compatible)  
FreeType Support  enabled  
FreeType Linkage  with freetype  
T1Lib Support  enabled  
GIF Read Support  enabled  
JPG Support  enabled  
PNG Support  enabled  
WBMP Support  enabled  
XBM Support  enabled  
 
include_path .:/usr/share/php 
ErrorLog:

Code: Alles auswählen

[07-Jun-2004 12:47:28] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:28] lock() failed.
[07-Jun-2004 12:47:28] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:28] Invalid SQL: INSERT INTO cms_stat (visited, idcatart, idlang, idstat, idclient) VALUES ('1', '32', '1', '0', '1')<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('startartikel','&15=1',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('punkt','&15=1',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('www','&15=8',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('upload','&15=4',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('logos','&15=3',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('logo','&15=3',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('jpg','&15=2',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('http','&15=8',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('foliendesign','&15=8',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('de','&15=8',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('contenido','&15=1',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('cms','&15=8',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('azibi','&15=8',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('itprof','&15=1',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('gif','&15=2',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('bilder','&15=1',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('banner','&15=1',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('fb','&15=1',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_keywords (keyword,auto,idlang, idkeyword) VALUES ('blank','&15=3',1,0)<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_code (idcode, idcatart, code, idlang, idclient) VALUES ('0', '27', '<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\">

<html>
<head>
        <title>Contenido</title>
        <link rel=\"stylesheet\" type=\"text/css\" href=\"css/format.css\">
<meta name=\"generator\" content=\"CMS Contenido 4.4.4\">
<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">
</head>

<body bgcolor=\"white\" style=\"margin:0px\">
<table width=\"100%\" height=\"100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">
<tr><td height=\"5\"></td></tr>
<tr><td align=\"center\">
<table width=\"800\" border=\"0\" height=\"100%\" cellspacing=\"0\" cellpadding=\"0\">
 <tr>
   <td width=\"200\" align=\"center\"><?php

if (\"http://www.azibi.de/foliendesign/cms/upload/logos/contenido_logo.jpg\" != \"\") {

    $img = \'<img src=\"http://www.azibi.de/foliendesign/cms/upload/logos/contenido_logo.jpg\" border=\"0\">\';

    if (\"http://www.azibi.de/foliendesign/cms/\" != \"http://\") {
        $img = sprintf(\'<a href=\"%s\" target=\"%s\">%s</a>\',\"http://www.azibi.de/foliendesign/cms/\", \"_blank\", $img);

    }

    echo $img;

}

echo \"<br>\";
echo \"\";
echo \"<br>\";
echo \"\";
echo \"<br>\";

?>
</td>
    <td align=\"center\" height=\"80\" with=\"400\">
     <table width=\"400\" border=\"0\" height=\"80\" cellspacing=\"0\" cellpadding=\"0\" background=\"images/background.jpg\" style=\"border: 1px;border-color: #F7C473; border-style: dashed; background-color: #FCF2D5\">
     <tr><td>
     <table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"400\" height=\"80\">
     <tr><td> </td></tr><tr><td align=\"right\" valign=\"bottom\">

     <!--hilfsnavi-->
     <?php

include_once($cfg[\"path\"][\"contenido\"].$cfg[\"path\"][\"includes\"].\"functions.con.php\");

$catStart = \"2\";

if ($catStart != \"\") {
  $catIds = conDeeperCategoriesArray($catStart);

  echo \'<table cellpadding=\"0\" cellspacing=\"0\" border=\"0\"><tr>\';
  echo \'<td><img src=\"images/wuerfel.gif\"></td>\';

  if ( is_array($catIds) ) {

    foreach($catIds as $key=>$val) {
      // Ersten Eintrag ueberspringen, weil das der Menupunkt selbst ist
      // und nicht angezeigt werden soll.
      if ($key != 0) {

        $sql = \"SELECT CAT.idcat AS idcat, name FROM \".
               $cfg[\"tab\"][\"cat\"].\" AS CAT, \".
               $cfg[\"tab\"][\"cat_lang\"].\" AS CATLANG 
               WHERE CAT.idcat = \".$val.\"
               AND CAT.idcat = CATLANG.idcat
               AND CATLANG.idlang = \'$lang\'
               AND CATLANG.visible = \'1\'\";

        $db->query($sql);

        $db2 = new DB_Contenido;
        
        while ( $db->next_record() ) {
        
           $target = \"_self\";
          
          /* Check for redirect and new window flag */
          $sql = \"SELECT idart FROM \".$cfg[\"tab\"][\"cat_art\"].\" WHERE idcat=\'\". $db->f(\"idcat\").\"\' AND is_start = \'1\'\";
          $db2->query($sql);
          if ($db2->next_record())
          {
                $cidart = $db2->f(\"idart\");
                $sql = \"SELECT external_redirect FROM \".$cfg[\"tab\"][\"art_lang\"].\" WHERE idart = \'$cidart\' AND idlang=\'$lang\'\";
                $db2->query($sql);
                if ($db2->next_record())
                {
                    $target = ( $db2->f(\"external_redirect\") == 0 ) ? \'_self\' : \'_blank\';
                }
          }
          echo \'<td height=\"21\" class=\".navigation\" style=\"border: 0px; border-top:1px; border-color: #F7C473; border-style: dashed; background-color: #FFFFFF; padding-left:7px; padding-right:7px;\">
          <a class=\"klein\" target=\"\'.$target.\'\" href=\"front_content.php?idcat=\'.$db->f(\"idcat\").\'\">\'.$db->f(\"name\").\'</a></td>\';
        } // end while
      } // if
    }  // end foreach
  } // end if (is_array)

  echo \'</tr></table>\';

}
?>

     <!--hilfsnavi ende-->

     </td></tr>
     </table>
     </td></tr>
     </table>

    </td>
    <td width=\"200\" align=\"center\"><?php

if (\"http://www.azibi.de/foliendesign/cms/upload/logos/itprof_logo.gif\" != \"\") {

    $img = \'<img src=\"http://www.azibi.de/foliendesign/cms/upload/logos/itprof_logo.gif\" border=\"0\">\';

    if (\"http://www.azibi.de/foliendesign/cms/\" != \"http://\") {
        $img = sprintf(\'<a href=\"%s\" target=\"%s\">%s</a>\',\"http://www.azibi.de/foliendesign/cms/\", \"_blank\", $img);

    }

    echo $img;

}

echo \"<br>\";
echo \"\";
echo \"<br>\";
echo \"\";
echo \"<br>\";

?>
</td>
  </tr>

  <tr><td colspan=\"3\" height=\"5\"></td></tr>


  <tr>
    <td align=\"right\" valign=\"top\">
     <!--navi-->
     <?php

/***********************************************
* CONTENIDO MODUL - OUTPUT
*
* Modulname   :     Navigation 1.1
* Author      :     Jan Lengowski
* Copyright   :     Contenido - four for business
* Created     :     15-05-2003
* Modified    :     26-05-2003
************************************************/

if ( !is_object($db2) ) {
    $db2 = new DB_Contenido;
}

/**
 * Check if a category is child
 * of another category
 *
 * @return boolean true/false
 * @author Jan Lengowski <Jan.Lengowski@4fb.de>
 * @copyright four for business AG 2003
 */
if (!function_exists(\"catIsChildOf\"))
{
    function catIsChildOf($id, $idparent) {
    
        global $cfg, $client, $lang;
    
        $db = new DB_Contenido;
    
        $parent = $id;
    
        while ( $parent != 0 ) {
    
            $sql = \"SELECT
                        a.parentid
                    FROM
                        \".$cfg[\"tab\"][\"cat\"].\" AS a,
                        \".$cfg[\"tab\"][\"cat_lang\"].\" AS b
                    WHERE
                        a.idclient  = \'\".$client.\"\' AND
                        b.idlang    = \'\".$lang.\"\' AND
                        a.idcat     = b.idcat AND
                        a.idcat   = \'\".$parent.\"\'\";
    
            $db->query($sql);
            $db->next_record();
    
            $parent = $db->f(\"parentid\");
    
            if ($parent == $idparent) {
                return true;
            }
    
        }
    
        return false;
    
    }
}

if ( catIsChildOf($idcat, \"1\") ) {
    $sel_idcat = $idcat;
} else {
    $sel_idcat = \"1\";
}

/* Include Template Class */
include_once($cfg[\"path\"][\"contenido\"] . \'classes/class.template.php\');

/**
 * Array storing alle the
 * navigation data
 */
$navitems = array();


/* Template Instance */
$tpl = new Template;

/**
 * Recursive function for creating
 * the navigation array
 * @param Int $idcat Category id
 */
function nav($idcat) {

        global $navitems, $client, $lang, $cfg;

        $db  = new DB_Contenido;
        $db2 = new DB_Contenido;

        $sql = \"SELECT parentid FROM \".$cfg[\"tab\"][\"cat\"].\" WHERE idcat = \'$idcat\'\";

        $db->query($sql);
        $db->next_record();

        $parentid = $db->f(\"parentid\");

        if ( $parentid == 0 ) {

           if ( $idcat != \"1\" ){

                $navitems = array();
              
                $sql = \"SELECT
                            A.idcat,
                            C.name
                        FROM
                            \".$cfg[\"tab\"][\"cat_tree\"].\" AS A,
                            \".$cfg[\"tab\"][\"cat\"].\" AS B,
                            \".$cfg[\"tab\"][\"cat_lang\"].\" AS C
                        WHERE
                            A.idcat     = B.idcat   AND
                            B.idcat     = C.idcat   AND
                            B.idclient  = \'$client\' AND
                            C.idlang    = \'$lang\'   AND
                            C.visible   = \'1\'       AND
                            B.parentid  = \'1\'
                        ORDER
                            BY A.idtree\";

                      $db->query($sql);

                      while ($db->next_record()) {

                            /* Check for external redirects... */
                            $sql = \"SELECT
                                        a.external_redirect AS ext
                                    FROM
                                        \".$cfg[\"tab\"][\"art_lang\"].\" AS a,
                                        \".$cfg[\"tab\"][\"cat_art\"].\" AS b,
                                        \".$cfg[\"tab\"][\"cat\"].\" AS c
                                    WHERE
                                        b.idcat     = \'\".$db->f(\"idcat\").\"\' AND
                                        b.is_start  = \'1\' AND
                                        c.idclient  = \'\".$client.\"\' AND
                                        c.idcat     = b.idcat AND
                                        a.idart     = b.idart AND
                                        a.idlang    = \'\".$lang.\"\'\";

                            $db2->query($sql);
                            $db2->next_record();

                            $target = ( $db2->f(\"ext\") == 0 ) ? \'_self\' : \'_blank\';

                            $navitems[$db->f(\"idcat\")] = array(\"idcat\"      => $db->f(\"idcat\"),
                                                                \"name\"      => $db->f(\"name\"),
                                                                \"target\"    => $target);
                      }

           }
           
           return true;
        }

        $sql = \"SELECT
                    A.idcat,
                    C.name
                FROM
                    \".$cfg[\"tab\"][\"cat_tree\"].\" AS A,
                    \".$cfg[\"tab\"][\"cat\"].\" AS B,
                    \".$cfg[\"tab\"][\"cat_lang\"].\" AS C
                WHERE
                    A.idcat     = B.idcat   AND
                    B.idcat     = C.idcat   AND
                    B.idclient  = \'$client\' AND
                    C.idlang    = \'$lang\'   AND
                    C.visible   = \'1\'       AND
                    B.parentid  = \'$parentid\'
                ORDER BY
                    A.idtree\";

        $db->query($sql);

        while ($db->next_record()) {

                /* Check for external redirects... */
                $sql = \"SELECT
                            a.external_redirect AS ext
                        FROM
                            \".$cfg[\"tab\"][\"art_lang\"].\" AS a,
                            \".$cfg[\"tab\"][\"cat_art\"].\" AS b,
                            \".$cfg[\"tab\"][\"cat\"].\" AS c
                        WHERE
                            b.idcat     = \'\".$db->f(\"idcat\").\"\' AND
                            b.is_start  = \'1\' AND
                            c.idclient  = \'\".$client.\"\' AND
                            c.idcat     = b.idcat AND
                            a.idart     = b.idart AND
                            a.idlang    = \'\".$lang.\"\'\";

                $db2->query($sql);
                $db2->next_record();

                $target = ( $db2->f(\"ext\") == 0 ) ? \'_self\' : \'_blank\';
                
                $tmp_nav[$db->f(\"idcat\")] = array(\"idcat\"   => $db->f(\"idcat\"),
                                                  \"name\"    => $db->f(\"name\"),
                                                  \"target\"  => $target);
        }

        $tmp_nav[$idcat][\"sub\"] = $navitems;
        $navitems = $tmp_nav;

        /* Function call */
        nav($parentid);

}  // end function

$sql = \"SELECT
            A.idcat,
            C.name
        FROM
            \".$cfg[\"tab\"][\"cat_tree\"].\" AS A,
            \".$cfg[\"tab\"][\"cat\"].\" AS B,
            \".$cfg[\"tab\"][\"cat_lang\"].\" AS C
        WHERE
            A.idcat     = B.idcat   AND
            B.idcat     = C.idcat   AND
            B.idclient  = \'$client\' AND
            C.idlang    = \'$lang\'   AND
            C.visible   = \'1\'       AND
            B.parentid  = \'$sel_idcat\'
        ORDER BY
            A.idtree\";

$db->query($sql);

while ( $db->next_record() ) {

        /* Check for external redirects... */
        $sql = \"SELECT
                    a.external_redirect AS ext
                FROM
                    \".$cfg[\"tab\"][\"art_lang\"].\" AS a,
                    \".$cfg[\"tab\"][\"cat_art\"].\" AS b,
                    \".$cfg[\"tab\"][\"cat\"].\" AS c
                WHERE
                    b.idcat     = \'\".$db->f(\"idcat\").\"\' AND
                    b.is_start  = \'1\' AND
                    c.idclient  = \'\".$client.\"\' AND
                    c.idcat     = b.idcat AND
                    a.idart     = b.idart AND
                    a.idlang    = \'\".$lang.\"\'\";

        $db2->query($sql);
        $db2->next_record();

        $target = ( $db2->f(\"ext\") == 0 ) ? \'_self\' : \'_blank\';

        $navitems[$db->f(\"idcat\")] = array(\"idcat\"  => $db->f(\"idcat\"),
                                           \"name\"   => $db->f(\"name\"),
                                           \"target\" => $target);
}

/* Create Navigation Array */
nav($sel_idcat);

/* Start Output buffer */
ob_start();

echo \'<table cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\';

foreach ($navitems as $key => $data) {

    /* 1. Navigations Ebene */
    $tpl->reset();
    $tpl->set(\'d\', \'NAME\',  $data[\'name\']);
    $tpl->set(\'d\', \'TARGET\', $data[\'target\']);
    $tpl->set(\'d\', \'HREF\',  $sess->url(\'front_content.php?idcat=\'.$data[\'idcat\']));
    $tpl->next();

    if ($idcat == $data[\'idcat\'] || is_array($data[\'sub\'])) {
        $tpl->generate(\'templates/navfirst_on.html\');
    } else {
        $tpl->generate(\'templates/navfirst_off.html\');
    }

    if (is_array($data[\'sub\'])) {

        foreach ($data[\'sub\'] as $key => $data) {

            /* 2. Navigations Ebene */
            $tpl->reset();
            $tpl->set(\'d\', \'NAME\',  $data[\'name\']);
            $tpl->set(\'d\', \'TARGET\', $data[\'target\']);
            $tpl->set(\'d\', \'HREF\',  $sess->url(\'front_content.php?idcat=\'.$data[\'idcat\']));
            $tpl->next();

            if ($idcat == $data[\'idcat\'] || is_array($data[\'sub\'])) {
                $tpl->generate(\'templates/navsecond_on.html\');
            } else {
                $tpl->generate(\'templates/navsecond_off.html\');
            }

            if (is_array($data[\'sub\'])) {

                foreach ($data[\'sub\'] as $key => $data) {

                    /* 3. Navigations Ebene */
                    $tpl->reset();
                    $tpl->set(\'d\', \'NAME\',  $data[\'name\']);
                    $tpl->set(\'d\', \'TARGET\', $data[\'target\']);
                    $tpl->set(\'d\', \'HREF\',  $sess->url(\'front_content.php?idcat=\'.$data[\'idcat\']));
                    $tpl->next();

                    if ($idcat == $data[\'idcat\']) {
                        $tpl->generate(\'templates/navthird_on.html\');
                    } else {
                        $tpl->generate(\'templates/navthird_off.html\');
                    }

                } // end foreach

            } // end if

        } // end foreach

    } // end if

} // end foreach

echo \'</table>\';

/* Read out buffer */
$html = ob_get_contents();

/* Clean buffer */
ob_end_clean();

/* Output buffer-contents */
echo $html;

?>

     <!--navi ende-->

    </td>
     <td valign=\"top\">
      <!--inhalt-->
        <table width=\"400\" height=\"50%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" style=\"border: 1px;border-color: #F7C473; border-style: dashed; background-color: #FCF2D5\">
         <tr><td height=\"20\" colspan=\"2\"> </td></tr>
        <tr><td rowspan=\"3\" width=\"25\"> </td>
        <td valign=\"top\" height=\"30\" class=\"headline\"><?php echo \"Startartikel Punkt 2\"; ?>
</td></tr>
        <tr><td valign=\"top\" height=\"30\" class=\"subheadline\"><?php echo \"\"; ?>
</td></tr>
        <tr><td valign=\"top\" height=\"100%\" class=\"text\"><?php echo \"\"; ?>
</td></tr>
     </table>
       <!--inhalt ende-->
      </td>

     <td align=\"center\" valign=\"top\">

        <table cellspacing=\"0\" cellpadding=\"0\" border=\"0\">

            <tr>
                <td><?php
/***********************************************
* CONTENIDO MODUL - OUTPUT
*
* REFERENZ MODUL / ARTIKELLISTE
*
* Artikelliste mit Img 1, Head 1, Head 2
*
* Erstellt eine Liste mit allen Artikel bis
* auf den Startartikel.
*
* Author      :     Jan Lengowski
* Copyright   :     four for business AG
* Created     :     15-08-2002
* Modified    :     16-08-2002
************************************************/

// second db class instance
$db2 = new DB_Contenido;

// selected category
$selcat = \"12\";

 if($selcat!=\"0\" && $selcat!=\"\"){

// select all articles in category widthout start article
$query = \"SELECT ARTLANG.idart, ARTLANG.idartlang FROM \".$cfg[\"tab\"][\"cat_art\"].\" AS CATART, \".
          $cfg[\"tab\"][\"art_lang\"].\" AS ARTLANG \".
         \"WHERE CATART.idcat = \'$selcat\' AND ARTLANG.idart = CATART.idart AND ARTLANG.idlang = \'$lang\' AND \".
         \"ARTLANG.online = \'1\' ORDER BY CATART.idart DESC\";

// execute query
$db->query($query);

unset($articleID);
unset($linkID);

// get id\'s of sub articles
while ($db->next_record()) {
  $articleID[] = $db->f(\"idartlang\");
  $linkID[] = $db->f(\"idart\");
} // end while

// loop through subarticles

echo \'
<table width=\"165\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
<tr><td height=\"30\" colspan=\"2\" ></td></tr>
<tr><td height=\"21\" width=\"22\" style=\"border: 0px; border-top:1px; border-bottom:1px; border-color: #F7C473; border-style: solid; background-color: #FCF2D5\"><img src=\"images/wuerfel.gif\" width=\"22\" height=\"21\" border=\"0\"></td>
<td width=\"143\" style=\"border: 1px; border-left:0px; border-color: #F7C473; border-style: dashed; background-color: #FCF2D5; padding-left:10px\" class=\"punkte\">News</td></tr>
\';

if (is_array($articleID)) {

    foreach ($articleID as $key => $value) {

          // select all CMS variables of the article
          $sql = \"SELECT * FROM \".$cfg[\"tab\"][\"content\"].\" WHERE idartlang = \'$value\' AND idtype = \'1\' AND typeid = \'1\'\";
          $db->query($sql);
          $db->next_record();
          $head = $db->f(\"value\");

          if ( strlen($head) > \"50\") {
            $head = substr($head, 0, \"50\");
            $head .= \'..\';
          }

          // link
          $link = $sess->url(\"front_content.php?client=$client&lang=$lang&idcat=$selcat&idart=$linkID[$key]&m=$m&s=$s\");

          echo \'<tr><td colspan=\"2\" class=\"text\" height=\"22\" style=\"border: 1px; border-top:0px; border-color: #F7C473; border-style: dashed; background-color: #FCF2D5; padding-left:10px\"><a href=\"\'.$link.\'\">\'.urldecode($db->f(\"value\")).\'</a></td></tr>\';

    } // end while



          unset($headline);
        unset($text);
        
    } // end foreach
    
} // end if (is_array)

echo \'</table><br>\';


?>


</td>
            </tr>
            
            <tr>
                <td><?php

if (\"http://www.azibi.de/foliendesign/cms/upload/bilder/banner.jpg\" != \"\") {

    $img = \'<img src=\"http://www.azibi.de/foliendesign/cms/upload/bilder/banner.jpg\" border=\"0\">\';

    if (\"http://www.azibi.de/foliendesign/cms/\" != \"http://\") {
        $img = sprintf(\'<a href=\"%s\" target=\"%s\">%s</a>\',\"http://www.azibi.de/foliendesign/cms/\", \"\", $img);

    }

    echo $img;

}

echo \"<br>\";
echo \"\";
echo \"<br>\";
echo \"\";
echo \"<br>\";

?>
</td>
            </tr>
            
            <tr>
                <td><?php

if (\"http://www.azibi.de/foliendesign/cms/upload/logos/4fb_logo.gif\" != \"\") {

    $img = \'<img src=\"http://www.azibi.de/foliendesign/cms/upload/logos/4fb_logo.gif\" border=\"0\">\';

    if (\"http://www.azibi.de/foliendesign/cms/\" != \"http://\") {
        $img = sprintf(\'<a href=\"%s\" target=\"%s\">%s</a>\',\"http://www.azibi.de/foliendesign/cms/\", \"_blank\", $img);

    }

    echo $img;

}

echo \"<br>\";
echo \"\";
echo \"<br>\";
echo \"\";
echo \"<br>\";

?>
</td>
            </tr>

        </table>

</td></tr></table>

</td></tr></table>
</body>
</html>', '1', '1')<br><br>
[07-Jun-2004 12:47:31] Invalid SQL: lock tables cms_sequence write<br><br>
[07-Jun-2004 12:47:31] lock() failed.
[07-Jun-2004 12:47:31] cannot lock cms_sequence - has it been created?
[07-Jun-2004 12:47:31] Invalid SQL: INSERT INTO cms_stat (visited, idcatart, idlang, idstat, idclient) VALUES ('1', '27', '1', '0', '1')<br><br>
Hoffentlich könnt ihr mir helfen...


Gruß Azibi


Azibi
Beiträge: 13
Registriert: Di 23. Mär 2004, 19:19
Kontaktdaten:

Beitrag von Azibi » Mo 7. Jun 2004, 12:23

Danke!!! Es hat geholfen. Vielleicht kann ich ja jetzt auch mein Backup wieder einfügen. Wenn was schief geht meld ich mich nochmal.

Gruß Azibi

Azibi
Beiträge: 13
Registriert: Di 23. Mär 2004, 19:19
Kontaktdaten:

Beitrag von Azibi » Do 8. Jul 2004, 19:59

Hallo ich mal wieder...

Ich hab jetzt mal ein Update auf 4.5.2 ALPHA gemacht und was soll ich sagen die Errorlog hat schon wieder den einen oder anderen Eintrag mit dem ich nichts anzufangen weiß. Das ich der Inhalt:
[08-Jul-2004 20:42:00] PHP Warning: fclose(): supplied argument is not a valid stream resource in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 180
[08-Jul-2004 20:42:00] PHP Warning: fputs(): supplied argument is not a valid stream resource in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 179
[08-Jul-2004 20:42:00] PHP Warning: fopen(/home/htdocs/web5/html/foliendesign/contenido/cronjobs/pseudo-cron.log): failed to open stream: Permission denied in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 174
[08-Jul-2004 20:42:00] PHP Warning: fclose(): supplied argument is not a valid stream resource in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 180
[08-Jul-2004 20:42:00] PHP Warning: fputs(): supplied argument is not a valid stream resource in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 179
[08-Jul-2004 20:42:00] PHP Warning: fopen(/home/htdocs/web5/html/foliendesign/contenido/cronjobs/pseudo-cron.log): failed to open stream: Permission denied in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 174
[08-Jul-2004 20:42:00] PHP Warning: fclose(): supplied argument is not a valid stream resource in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 180
[08-Jul-2004 20:42:00] PHP Warning: fputs(): supplied argument is not a valid stream resource in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 179
[08-Jul-2004 20:42:00] PHP Warning: fopen(/home/htdocs/web5/html/foliendesign/contenido/cronjobs/pseudo-cron.log): failed to open stream: Permission denied in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 174
[08-Jul-2004 20:42:00] PHP Warning: fclose(): supplied argument is not a valid stream resource in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 180
[08-Jul-2004 20:42:00] PHP Warning: fputs(): supplied argument is not a valid stream resource in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 179
[08-Jul-2004 20:42:00] PHP Warning: fopen(/home/htdocs/web5/html/foliendesign/contenido/cronjobs/pseudo-cron.log): failed to open stream: Permission denied in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 174
[08-Jul-2004 20:42:00] PHP Warning: fclose(): supplied argument is not a valid stream resource in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 180
[08-Jul-2004 20:42:00] PHP Warning: fputs(): supplied argument is not a valid stream resource in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 179
[08-Jul-2004 20:42:00] PHP Warning: fopen(/home/htdocs/web5/html/foliendesign/contenido/cronjobs/pseudo-cron.log): failed to open stream: Permission denied in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 174
[08-Jul-2004 20:42:00] PHP Warning: fclose(): supplied argument is not a valid stream resource in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 180
[08-Jul-2004 20:42:00] PHP Warning: fputs(): supplied argument is not a valid stream resource in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 179
[08-Jul-2004 20:42:00] PHP Warning: fopen(/home/htdocs/web5/html/foliendesign/contenido/cronjobs/pseudo-cron.log): failed to open stream: Permission denied in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 174
[08-Jul-2004 20:42:00] PHP Warning: fclose(): supplied argument is not a valid stream resource in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 180
[08-Jul-2004 20:42:00] PHP Warning: fputs(): supplied argument is not a valid stream resource in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 179
[08-Jul-2004 20:42:00] PHP Warning: fopen(/home/htdocs/web5/html/foliendesign/contenido/cronjobs/pseudo-cron.log): failed to open stream: Permission denied in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 174
[08-Jul-2004 20:42:00] PHP Warning: fclose(): supplied argument is not a valid stream resource in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 180
[08-Jul-2004 20:42:00] PHP Warning: fputs(): supplied argument is not a valid stream resource in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 179
[08-Jul-2004 20:42:00] PHP Warning: fopen(/home/htdocs/web5/html/foliendesign/contenido/cronjobs/pseudo-cron.log): failed to open stream: Permission denied in /home/htdocs/web5/html/foliendesign/contenido/includes/pseudo-cron.inc.php on line 174
Vielleicht könnte dabei nochmal geholfen werden? Danke

timo
Beiträge: 6284
Registriert: Do 15. Mai 2003, 18:32
Wohnort: Da findet ihr mich nie!
Kontaktdaten:

Beitrag von timo » Do 8. Jul 2004, 21:52

http://www.thilo-sommer.de/PHPMyFAQ/ind ... permission

beim nächsten mal einfach in der FAQ suchen...

Azibi
Beiträge: 13
Registriert: Di 23. Mär 2004, 19:19
Kontaktdaten:

Beitrag von Azibi » Do 8. Jul 2004, 22:18

Danke, das hat geholfen!

Jetzt habe ich diesen Eintrag:
[08-Jul-2004 23:11:36] /foliendesign/cms/front_content.php?idcat=68 next_record called with no query pending in Module ID 27.
[08-Jul-2004 23:11:36] /foliendesign/cms/front_content.php?idcat=68 Invalid SQL: SELECT level FROM WHERE idcat=1<br><br>
Allerdings kommt der Eintrag nur wenn ich auf die Sitemap klicke. Ich muss dazu sagen, das das Sitemap Modul schon bei der Installation einen Fehler hatte. Bzw hat die 4.5.2. gemeckert mit diesem Text;
This module uses variables and/or functions which are probably not available in this Contenido version. Please make sure that you use up-to-date modules.

Soll ich mein jetziges Problem im Module-Forum nochmal ansprechen, oder kannst du mir dabei weiterhelfen?

timo
Beiträge: 6284
Registriert: Do 15. Mai 2003, 18:32
Wohnort: Da findet ihr mich nie!
Kontaktdaten:

Beitrag von timo » Fr 9. Jul 2004, 09:40

Dann ist die Sitemap nicht für die Version 4.4 oder 4.5 entwickelt worden!

Gesperrt