Navigation Horizontal | Navigation Vertical / Unternavigation | Direkt zum Inhalt

Inhalt:

Datenbank-Fehler

Datenbank-Fehler

Die SQL-Datenbank meldete folgenden Fehler:
Error 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND l.kuerzel = 'en' ORDER BY u.sort' at line 10

Die verursachende SQL-Anweisung war: "SELECT u.name, u.text, u.text_hyphenated, u.zusatz1, u.zusatz2 FROM tr_hoch_texte_uebersetzung u LEFT JOIN t_languages l ON u.fk_language = l.sys_pk WHERE u.fk_produkt = AND l.kuerzel = 'en' ORDER BY u.sort"

Callstack

array
  0 => 
    array
      'file' => string '/home/lutz/www/hoch/lib/Funktionen.php' (length=38)
      'line' => int 5663
      'function' => string 'query' (length=5)
      'class' => string 'mysql' (length=5)
      'type' => string '->' (length=2)
      'args' => 
        array
          0 => &string 'SELECT
            u.name,
            u.text,
            u.text_hyphenated,
            u.zusatz1,
            u.zusatz2
            FROM tr_hoch_texte_uebersetzung u
            LEFT JOIN t_languages l ON u.fk_language = l.sys_pk
            WHERE u.fk_produkt = 
            AND l.kuerzel = 'en'
            ORDER BY u.sort' (length=327)
          1 => &string 'Texte' (length=5)
  1 => 
    array
      'file' => string '/home/lutz/www/hoch/lib/Funktionen.php' (length=38)
      'line' => int 2604
      'function' => string 'abfrage_texte' (length=13)
      'class' => string 'funktionen' (length=10)
      'type' => string '->' (length=2)
      'args' => 
        array
          0 => &null
          1 => &string 'en' (length=2)
  2 => 
    array
      'file' => string '/home/lutz/www/hoch/html/seiten/products.phtml' (length=46)
      'line' => int 51
      'function' => string 'mitlaufprodnavi' (length=15)
      'class' => string 'funktionen' (length=10)
      'type' => string '->' (length=2)
      'args' => 
        array
          0 => &int 33314
  3 => 
    array
      'file' => string '/home/lutz/www/hoch/html/templates/tpl.php' (length=42)
      'line' => int 748
      'function' => string 'content_block' (length=13)
      'args' => 
        array
          0 => &boolean false
  4 => 
    array
      'file' => string '/home/lutz/www/hoch/lib/project.php' (length=35)
      'line' => int 81
      'function' => string 'output_template' (length=15)
      'args' => 
        array
          0 => &string 'LuckyReptile' (length=12)
          1 => &
            array
              0 => &
                object(navelement)
                  var 'id' => string '7' (length=1)
                  var 'parent' => string '1' (length=1)
                  var 'name' => string 'Imprint' (length=7)
                  var 'url' => string 'html/seiten/text.phtml?ausblenden&nav=7&lang=en' (length=47)
                  var 'current' => boolean false
                  var 'options' => string 'ausblenden' (length=10)
                  var 'bild' => null
                  var 'children' => 
                    array
                      empty
                  var 'row_amount' => string '1' (length=1)
                  var 'right_shift' => string '0' (length=1)
                  var 'bild_path' => null
                  var 'div_shift' => null
                  var 'color' => string '-1' (length=2)
                  var 'accesskey' => string '' (length=0)
                  var 'fk_produkt' => null
                  var 'flag_reiter' => boolean false
              1 => &
                object(navelement)
                  var 'id' => string '138' (length=3)
                  var 'parent' => string '1' (length=1)
                  var 'name' => string 'GBC' (length=3)
                  var 'url' => string 'html/seiten/text.phtml?ausblenden&nav=138&lang=en' (length=49)
                  var 'current' => boolean false
                  var 'options' => string 'ausblenden' (length=10)
                  var 'bild' => null
                  var 'children' => 
                    array
                      empty
                  var 'row_amount' => string '1' (length=1)
                  var 'right_shift' => string '0' (length=1)
                  var 'bild_path' => null
                  var 'div_shift' => null
                  var 'color' => string '0' (length=1)
                  var 'accesskey' => string '' (length=0)
                  var 'fk_produkt' => null
                  var 'flag_reiter' => boolean false
              2 => &
                object(navelement)
                  var 'id' => string '145' (length=3)
                  var 'parent' => string '1' (length=1)
                  var 'name' => string 'Products' (length=8)
                  var 'url' => string 'html/seiten/products.phtml?nav=145&lang=en' (length=42)
                  var 'current' => boolean true
                  var 'options' => string '' (length=0)
                  var 'bild' => null
                  var 'children' => 
                    array
                      empty
                  var 'row_amount' => string '1' (length=1)
                  var 'right_shift' => string '0' (length=1)
                  var 'bild_path' => null
                  var 'div_shift' => null
                  var 'color' => string '0' (length=1)
                  var 'accesskey' => string '' (length=0)
                  var 'fk_produkt' => null
                  var 'flag_reiter' => boolean false
              3 => &
                object(navelement)
                  var 'id' => string '146' (length=3)
                  var 'parent' => string '1' (length=1)
                  var 'name' => string 'Service' (length=7)
                  var 'url' => string 'html/seiten/service.phtml?nav=146&lang=en' (length=41)
                  var 'current' => boolean false
                  var 'options' => string '' (length=0)
                  var 'bild' => null
                  var 'children' => 
                    array
                      0 => &
                        object(navelement)
                          var 'id' => string '150' (length=3)
                          var 'parent' => string '146' (length=3)
                          var 'name' => string 'Animals' (length=7)
                          var 'url' => string 'html/seiten/tiere.phtml?nav=150&lang=en' (length=39)
                          var 'current' => boolean false
                          var 'options' => string '' (length=0)
                          var 'bild' => null
                          var 'children' => 
                            array
                              empty
                          var 'row_amount' => string '1' (length=1)
                          var 'right_shift' => string '0' (length=1)
                          var 'bild_path' => null
                          var 'div_shift' => null
                          var 'color' => string '0' (length=1)
                          var 'accesskey' => string '' (length=0)
                          var 'fk_produkt' => null
                          var 'flag_reiter' => boolean false
                      1 => &
                        object(navelement)
                          var 'id' => string '147' (length=3)
                          var 'parent' => string '146' (length=3)
                          var 'name' => string 'Where to Buy' (length=12)
                          var 'url' => string 'html/seiten/bezugsquellen.phtml?nav=147&lang=en' (length=47)
                          var 'current' => boolean false
                          var 'options' => string '' (length=0)
                          var 'bild' => null
                          var 'children' => 
                            array
                              empty
                          var 'row_amount' => string '1' (length=1)
                          var 'right_shift' => string '0' (length=1)
                          var 'bild_path' => null
                          var 'div_shift' => null
                          var 'color' => string '0' (length=1)
                          var 'accesskey' => string '' (length=0)
                          var 'fk_produkt' => null
                          var 'flag_reiter' => boolean false
                      2 => &
                        object(navelement)
                          var 'id' => string '1235510216' (length=10)
                          var 'parent' => string '146' (length=3)
                          var 'name' => string 'Veterinaries' (length=12)
                          var 'url' => string 'html/seiten/tieraerzte.phtml?nav=1235510216&lang=en' (length=51)
                          var 'current' => boolean false
                          var 'options' => string '' (length=0)
                          var 'bild' => null
                          var 'children' => 
                            array
                              empty
                          var 'row_amount' => string '1' (length=1)
                          var 'right_shift' => string '0' (length=1)
                          var 'bild_path' => null
                          var 'div_shift' => null
                          var 'color' => string '0' (length=1)
                          var 'accesskey' => string '' (length=0)
                          var 'fk_produkt' => null
                          var 'flag_reiter' => boolean false
                      3 => &
                        object(navelement)
                          var 'id' => string '151' (length=3)
                          var 'parent' => string '146' (length=3)
                          var 'name' => string 'FAQ (Häufig gestellte Fragen)' (length=30)
                          var 'url' => string 'html/seiten/faq.phtml?nav=151&lang=en' (length=37)
                          var 'current' => boolean false
                          var 'options' => string '' (length=0)
                          var 'bild' => null
                          var 'children' => 
                            array
                              empty
                          var 'row_amount' => string '1' (length=1)
                          var 'right_shift' => string '0' (length=1)
                          var 'bild_path' => null
                          var 'div_shift' => null
                          var 'color' => string '0' (length=1)
                          var 'accesskey' => string '' (length=0)
                          var 'fk_produkt' => null
                          var 'flag_reiter' => boolean false
                      4 => &
                        object(navelement)
                          var 'id' => string '152' (length=3)
                          var 'parent' => string '146' (length=3)
                          var 'name' => string 'Support' (length=7)
                          var 'url' => string 'html/seiten/support.phtml?nav=152&lang=en' (length=41)
                          var 'current' => boolean false
                          var 'options' => string '' (length=0)
                          var 'bild' => null
                          var 'children' => 
                            array
                              empty
                          var 'row_amount' => string '1' (length=1)
                          var 'right_shift' => string '0' (length=1)
                          var 'bild_path' => null
                          var 'div_shift' => null
                          var 'color' => string '0' (length=1)
                          var 'accesskey' => string '' (length=0)
                          var 'fk_produkt' => null
                          var 'flag_reiter' => boolean false
                      5 => &
                        object(navelement)
                          var 'id' => string '1235510217' (length=10)
                          var 'parent' => string '146' (length=3)
                          var 'name' => string 'Download' (length=8)
                          var 'url' => string 'html/seiten/downloads.phtml?nav=1235510217&lang=en' (length=50)
                          var 'current' => boolean false
                          var 'options' => string '' (length=0)
                          var 'bild' => null
                          var 'children' => 
                            array
                              empty
                          var 'row_amount' => string '1' (length=1)
                          var 'right_shift' => string '0' (length=1)
                          var 'bild_path' => null
                          var 'div_shift' => null
                          var 'color' => string '0' (length=1)
                          var 'accesskey' => string '' (length=0)
                          var 'fk_produkt' => null
                          var 'flag_reiter' => boolean false
                      6 => &
                        object(navelement)
                          var 'id' => string '1235510210' (length=10)
                          var 'parent' => string '146' (length=3)
                          var 'name' => string 'Links' (length=5)
                          var 'url' => string 'html/seiten/links.phtml?nav=1235510210&lang=en' (length=46)
                          var 'current' => boolean false
                          var 'options' => string '' (length=0)
                          var 'bild' => null
                          var 'children' => 
                            array
                              empty
                          var 'row_amount' => string '1' (length=1)
                          var 'right_shift' => string '0' (length=1)
                          var 'bild_path' => null
                          var 'div_shift' => null
                          var 'color' => string '0' (length=1)
                          var 'accesskey' => string '' (length=0)
                          var 'fk_produkt' => null
                          var 'flag_reiter' => boolean false
                      7 => &
                        object(navelement)
                          var 'id' => string '1235510231' (length=10)
                          var 'parent' => string '146' (length=3)
                          var 'name' => string 'Picturegalleries' (length=16)
                          var 'url' => string 'html/seiten/service.phtml?nav=1235510231&lang=en' (length=48)
                          var 'current' => boolean false
                          var 'options' => string '' (length=0)
                          var 'bild' => null
                          var 'children' => 
                            array
                              empty
                          var 'row_amount' => string '1' (length=1)
                          var 'right_shift' => string '0' (length=1)
                          var 'bild_path' => null
                          var 'div_shift' => null
                          var 'color' => string '0' (length=1)
                          var 'accesskey' => string '' (length=0)
                          var 'fk_produkt' => null
                          var 'flag_reiter' => boolean false
                      8 => &
                        object(navelement)
                          var 'id' => string '6' (length=1)
                          var 'parent' => string '146' (length=3)
                          var 'name' => string 'Contact' (length=7)
                          var 'url' => string 'html/seiten/kontakt.phtml?nav=6&lang=en' (length=39)
                          var 'current' => boolean false
                          var 'options' => string '' (length=0)
                          var 'bild' => null
                          var 'children' => 
                            array
                              empty
                          var 'row_amount' => string '1' (length=1)
                          var 'right_shift' => string '0' (length=1)
                          var 'bild_path' => null
                          var 'div_shift' => null
                          var 'color' => string '-1' (length=2)
                          var 'accesskey' => string '' (length=0)
                          var 'fk_produkt' => null
                          var 'flag_reiter' => boolean false
                      9 => &
                        object(navelement)
                          var 'id' => string '1235510218' (length=10)
                          var 'parent' => string '146' (length=3)
                          var 'name' => string 'Survey' (length=6)
                          var 'url' => string 'html/seiten/umfrage.phtml?nav=1235510218&lang=en' (length=48)
                          var 'current' => boolean false
                          var 'options' => string '' (length=0)
                          var 'bild' => null
                          var 'children' => 
                            array
                              empty
                          var 'row_amount' => string '1' (length=1)
                          var 'right_shift' => string '0' (length=1)
                          var 'bild_path' => null
                          var 'div_shift' => null
                          var 'color' => string '0' (length=1)
                          var 'accesskey' => string '' (length=0)
                          var 'fk_produkt' => null
                          var 'flag_reiter' => boolean false
                  var 'row_amount' => string '1' (length=1)
                  var 'right_shift' => string '0' (length=1)
                  var 'bild_path' => null
                  var 'div_shift' => null
                  var 'color' => string '0' (length=1)
                  var 'accesskey' => string '' (length=0)
                  var 'fk_produkt' => null
                  var 'flag_reiter' => boolean false
              4 => &
                object(navelement)
                  var 'id' => string '1235510212' (length=10)
                  var 'parent' => string '1' (length=1)
                  var 'name' => string 'Infopool' (length=8)
                  var 'url' => string 'html/seiten/infopool.phtml?ausblenden&nav=1235510212&lang=en' (length=60)
                  var 'current' => boolean false
                  var 'options' => string 'ausblenden' (length=10)
                  var 'bild' => null
                  var 'children' => 
                    array
                      empty
                  var 'row_amount' => string '1' (length=1)
                  var 'right_shift' => string '0' (length=1)
                  var 'bild_path' => null
                  var 'div_shift' => null
                  var 'color' => string '0' (length=1)
                  var 'accesskey' => string '' (length=0)
                  var 'fk_produkt' => null
                  var 'flag_reiter' => boolean false
              5 => &
                object(navelement)
                  var 'id' => string '1235510213' (length=10)
                  var 'parent' => string '1' (length=1)
                  var 'name' => string 'Novelties' (length=9)
                  var 'url' => string 'html/seiten/text.phtml?ausblenden&nav=1235510213&lang=en' (length=56)
                  var 'current' => boolean false
                  var 'options' => string 'ausblenden' (length=10)
                  var 'bild' => null
                  var 'children' => 
                    array
                      empty
                  var 'row_amount' => string '1' (length=1)
                  var 'right_shift' => string '0' (length=1)
                  var 'bild_path' => null
                  var 'div_shift' => null
                  var 'color' => string '0' (length=1)
                  var 'accesskey' => string '' (length=0)
                  var 'fk_produkt' => null
                  var 'flag_reiter' => boolean false
  5 => 
    array
      'file' => string '/home/lutz/www/hoch/html/seiten/products.phtml' (length=46)
      'line' => int 112
      'function' => string 'output_go' (length=9)
      'class' => string 'project' (length=7)
      'type' => string '->' (length=2)
      'args' => 
        array
          empty