CONTENIDO Forum

Das Diskussionsforum zum Open Source Content Management System
https://www.forum.contenido.org/

MySQL error 1064 und Codefragment in Artikelanzeige

https://www.forum.contenido.org/viewtopic.php?f=104&t=24022

Seite 1 von 1

MySQL error 1064 und Codefragment in Artikelanzeige

Verfasst: Di 30. Jun 2009, 11:02
von maxl
Hallo Community!

Ich habe in Contenido 4.8.11 über Style->Template ein neues Template angelegt und als "Text (Container 52 bis 55)" das Modul "Article-Include" ausgewählt. Dann habe ich das neue Template unter Content->Kategorie verwendet. Seit dem enthalten ALLE Artikel auf der Site den folgenden Text.
#Includes cInclude("frontend", "includes/functions.input.helper.php"); # Initialization $bDebug = false; $iDataStart = 20; $sSubmitLink = ''; unset ($aSettings); # Base settings $aSettings = array(); $aSettings["ArticleCount"] = "$C51"; $aSettings["ArticlePerPage"] = "$C51"; $aSettings["SortBy"] = "$C51"; $aSettings["SortDir"] = "$C51"; $aSettings["ShowStart"] = "$C51"; $aSettings["Category"] = "$C51"; $aSettings["SampleCat"] = "$C51"; $aSettings["SampleArt"] = "$C51"; $aSettings["HeadlineIdentifier"] = "$C51"; $aSettings["HeadlineLength"] = "$C51"; $aSettings["Elements"] = "$C51"; $aSettings["CatTypeSel"] = "$C51"; $aSettings["AddCats"] = "$C51"; $aSettings["Template"] = "$C51"; # Checking base settings if (!is_numeric($aSettings["ArticleCount"]) || $aSettings["ArticleCount"] < 0) { $aSettings["ArticleCount"] = 5; } if (!is_numeric($aSettings["ArticlePerPage"]) || $aSettings["ArticlePerPage"] < 0) { $aSettings["ArticlePerPage"] = 0; // Deactivating page browsing } if (!is_numeric($aSettings["Category"]) || $aSettings["Category"] <= 0) { $aSettings["Category"] = 0; } if (!is_numeric($aSettings["SampleCat"]) || $aSettings["SampleCat"] <= 0) { $aSettings["SampleCat"] = $aSettings["Category"]; } if (!is_numeric($aSettings["SampleArt"]) || $aSettings["SampleArt"] < 0) { $aSettings["SampleArt"] = 0; } if (strlen($aSettings["HeadlineIdentifier"]) > 50) { $aSettings["HeadlineIdentifier"] = ""; } if (!is_numeric($aSettings["HeadlineLength"]) || $aSettings["HeadlineLength"] < 0) { $aSettings["HeadlineLength"] = 0; } if (!is_numeric($aSettings["Elements"]) || $aSettings["Elements"] < 0) { $aSettings["Elements"] = 0; } if ($aSettings["CatTypeSel"] == "" || ($aSettings["AddCats"] == "" && $aSettings["CatTypeSel"] == "selected")) { $aSettings["CatTypeSel"] = "none"; } # Detail settings if ($aSettings["Elements"] > 0) { for ($i = 0; $i < $aSettings["Elements"]; $i++) { $iElementType = $iDataStart + ($i * 5); $iElementIdentifier = $iElementType + 1; $iElementWidth = $iElementType + 2; $iElementHeight = $iElementType + 3; $aSettings["k".$i] = array(); $aSettings["k".$i]["ElementType"] = "$C51CMS_VALUE[$iElementType]"; // Text, Image, ExtractedImage $aSettings["k".$i]["Identifier"] = "$C51CMS_VALUE[$iElementIdentifier]"; $aSettings["k".$i]["ElementWidth"] = "$C51CMS_VALUE[$iElementWidth]"; // Textlength or ImageWidth $aSettings["k".$i]["ElementHeight"] = "$C51CMS_VALUE[$iElementHeight]"; # Check detail settings if ($aSettings["k".$i]["ElementType"] == "") { $aSettings["k".$i]["ElementType"] == "Text"; } if ($aSettings["k".$i]["ElementType"] == "") { $aSettings["k".$i]["ElementType"] == "Textanders"; } if ($aSettings["k".$i]["ElementType"] == "Text") { $aSettings["ElementHeight"] = 0; if (!is_numeric($aSettings["k".$i]["ElementWidth"]) || $aSettings["k".$i]["ElementWidth"] < 0) { $aSettings["k".$i]["ElementWidth"] = 50; } } else if (!is_numeric($aSettings["k".$i]["ElementWidth"]) || $aSettings["k".$i]["ElementWidth"] <= 0 || !is_numeric($aSettings["k".$i]["ElementHeight"]) || $aSettings["k".$i]["ElementHeight"] <= 0) { $aSettings["k".$i]["ElementWidth"] = 0; $aSettings["k".$i]["ElementHeight"] = 0; } if (strlen($aSettings["Identifier"]) > 50) { $aSettings["Identifier"] = ""; } } } echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; if ($aSettings["ShowStart"] != "enabled") { echo ' '."\n"; } else { echo ' '."\n"; } echo ' '."\n"; echo '
'.mi18n("Primary Category:").' '.fncBuildCategorySelect("CMS_VAR[5]", $aSettings["Category"], 0, "").'
'.mi18n("Additional Categories:").' '; if ($aSettings["CatTypeSel"] == "none") { echo ''.mi18n("None").' '; } else { echo ''.mi18n("None").' '; } if ($aSettings["CatTypeSel"] == "below") { echo ''.mi18n("All below primary").' '; } else { echo ''.mi18n("All below primary").' '; } if ($aSettings["CatTypeSel"] == "selected") { $sDisabled = ""; echo ''.mi18n("Selected").'
'; } else { $sDisabled = "disabled"; echo ''.mi18n("Selected").'
'; } echo fncAddMultiSelJS().fncBuildCategorySelect("c".$cnumber."cbxAddCatSel", $aSettings["AddCats"], 0, "fncUpdateSel('c".$cnumber."cbxAddCatSel', '"."CMS_VAR[11]"."');", "10", "multiple", false, 0, $sDisabled); echo '
'.mi18n("Article:").' '.mi18n("Count (total):").' '."\n"; echo ' '.mi18n("Per Page:").'
'.mi18n("Sort by:").' '."\n"; if (($aSettings["SortDir"] != "DESC") && ($aSettings["SortDir"] == "ASC") && ($aSettings["SortDir"] != "IDTREE") ) { echo ' '.mi18n("Ascending").' '.mi18n("Descending").' '.mi18n("idtree")."\n"; } else if (($aSettings["SortDir"] == "DESC") && ($aSettings["SortDir"] != "ASC") && ($aSettings["SortDir"] != "IDTREE")){ echo ' '.mi18n("Ascending").' '.mi18n("Descending").' '.mi18n("idtree")."\n"; } else { echo ' '.mi18n("Ascending").' '.mi18n("Descending").' '.mi18n("idtree")."\n"; } echo '
'.mi18n("Start Article:").' '.mi18n("Show").' '.mi18n("Show").'
'."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; if ($aSettings["SampleCat"] == 0) { $sDisabled = "disabled"; } else { $sDisabled = ""; } echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; if ($aSettings["Elements"] == 0) { $sBottomStyle = "border-bottom: 1px solid #747488;"; // Paint the table area closing line } else { $sBottomStyle = ""; } echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; if ($aSettings["Elements"] > 0) { for ($i = 0; $i < $aSettings["Elements"]; $i++) { $iElementType = $iDataStart + ($i * 5); $iElementIdentifier = $iElementType + 1; $iElementWidth = $iElementType + 2; $iElementHeight = $iElementType + 3; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; if ($i == ($aSettings["Elements"] - 1)) { $sBottomStyle = "border-bottom: 1px solid #747488;"; // Paint the table area closing line } else { $sBottomStyle = ""; } echo ' '."\n"; switch ($aSettings["k".$i]["ElementType"]) { case "Image": echo ' '."\n"; echo ' '."\n"; break; case "ExtractedImage": echo ' '."\n"; echo ' '."\n"; break; default: echo ' '."\n"; echo ' '."\n"; } echo ' '."\n"; } } echo '
'.mi18n("Identify elements:").'
'.mi18n("Choose Template").':

'.mi18n("Sample Category:").' '.fncBuildCategorySelect("CMS_VAR[12]", $aSettings["SampleCat"], 0, "if (document.forms[0].elements['CMS_VAR[12]'].value != '$C51') { document.forms[0].elements['CMS_VAR[6]'].disabled = true; document.forms[0].elements['CMS_VAR[7]'].disabled = true; document.forms[0].elements['CMS_VAR[8]'].disabled = true; document.forms[0].elements['CMS_VAR[9]'].disabled = true; } else { document.forms[0].elements['CMS_VAR[6]'].disabled = false; document.forms[0].elements['CMS_VAR[7]'].disabled = false; document.forms[0].elements['CMS_VAR[8]'].disabled = false; document.forms[0].elements['CMS_VAR[9]'].disabled = false;}").' '.$sSubmitLink.'
'.mi18n("Sample Article:").' '.fncBuildArticleSelect("CMS_VAR[6]", $aSettings["SampleCat"], $aSettings["SampleArt"], "if (document.forms[0].elements['CMS_VAR[6]'].value != '$C51') { document.forms[0].elements['CMS_VAR[7]'].disabled = true; document.forms[0].elements['CMS_VAR[8]'].disabled = true; document.forms[0].elements['CMS_VAR[9]'].disabled = true; } else { document.forms[0].elements['CMS_VAR[7]'].disabled = false; document.forms[0].elements['CMS_VAR[8]'].disabled = false; document.forms[0].elements['CMS_VAR[9]'].disabled = false;}", $sDisabled).' '.$sSubmitLink.'
'.mi18n("Headline Element:").' '.fncBuildTypeSelect("CMS_VAR[7]", $aSettings["SampleArt"], $aSettings["HeadlineIdentifier"], "'1','2','3','9','17'").' '.mi18n("Length (max.):").'
'.mi18n("Additional elements:").' '.$sSubmitLink.'
'.sprintf(mi18n("%s. Element:"), $i + 1).' '.mi18n("Type:").'
'."\n"; echo ' '.$sSubmitLink.' '."\n"; echo '
'.mi18n("Item:").'
'.fncBuildTypeSelect("CMS_VAR[$iElementIdentifier]", $aSettings["SampleArt"], $aSettings["k".$i]["Identifier"], "'4'").' '."\n"; echo ' '.mi18n("Width:"). ' '."\n"; echo ' '.mi18n("Height:").' '.mi18n("Item:").'
'.fncBuildTypeSelect("CMS_VAR[$iElementIdentifier]", $aSettings["SampleArt"], $aSettings["k".$i]["Identifier"], "'1','2','3','9','17'").' '."\n"; echo ' '.mi18n("Width:"). ' '."\n"; echo ' '.mi18n("Height:").' '.mi18n("Item:").'
'.fncBuildTypeSelect("CMS_VAR[$iElementIdentifier]", $aSettings["SampleArt"], $aSettings["k".$i]["Identifier"], "'1','2','3','9','17'").' '."\n"; echo ' '.mi18n("Length (max.):").' '."\n";
Im Log finden sich die folgenden Einträge:
bJ2NmZ0NsaWVudCddWycxJ11bJ3BhdGgnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSddWydwYXRoJ11bJ2Zyb250ZW5kJ10gPSAnL2hvbWVwYWdlcy8zNi9kMjUxODAwMjMzL2h0ZG9jcy9jbXMvJzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycxJ11bJ3BhdGgnXVsnaHRtbHBhdGgnXSA9ICdodHRwOi8vd3d3LmF2aW5udXMuY29tL2Ntcy8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsnaW1hZ2VzJ10gPSAnaHR0cDovL3d3dy5hdmlubnVzLmNvbS9jbXMvaW1hZ2VzLyc7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSddWyd1cGxvYWQnXSA9ICd1cGxvYWQvJzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycxJ11bJ2h0bWxwYXRoJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsnaHRtbHBhdGgnXVsnZnJvbnRlbmQnXSA9ICdodHRwOi8vd3d3LmF2aW5udXMuY29tL2Ntcy8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsndXBsJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsndXBsJ11bJ3BhdGgnXSA9ICcvaG9tZXBhZ2VzLzM2L2QyNTE4MDAyMzMvaHRkb2NzL2Ntcy91cGxvYWQvJzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycxJ11bJ3VwbCddWydodG1scGF0aCddID0gJ2h0dHA6Ly93d3cuYXZpbm51cy5jb20vY21zL3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsndXBsJ11bJ2Zyb250ZW5kcGF0aCddID0gJ3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsnY3NzJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsnY3NzJ11bJ3BhdGgnXSA9ICcvaG9tZXBhZ2VzLzM2L2QyNTE4MDAyMzMvaHRkb2NzL2Ntcy9jc3MvJzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycxJ11bJ2pzJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsnanMnXVsncGF0aCddID0gJy9ob21lcGFnZXMvMzYvZDI1MTgwMDIzMy9odGRvY3MvY21zL2pzLyc7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSddWyd0cGwnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSddWyd0cGwnXVsncGF0aCddID0gJy9ob21lcGFnZXMvMzYvZDI1MTgwMDIzMy9odGRvY3MvY21zL3RlbXBsYXRlcy8nOyAkR0xPQkFMU1snZXJyc2l0ZV9pZGNhdCddID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2VycnNpdGVfaWRjYXQnXVsnMSddID0gJzMxJzsgJEdMT0JBTFNbJ2VycnNpdGVfaWRhcnQnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydlcnJzaXRlX2lkYXJ0J11bJzEnXSA9ICczNic7ICRHTE9CQUxTWydyZW1ha2VTdHJUYWJsZSddID0gJzEnOyAkR0xPQkFMU1snU3RyVGFibGVDbGllbnQnXSA9ICcxJzsgJEdMT0JBTFNbJ1N0clRhYmxlTGFuZyddID0gJzInOyAkR0xPQkFMU1snYXJlYV90cmVlJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snYXJlYV90cmVlJ11bJzYnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydhcmVhX3RyZWUnXVsnNiddWycwJ10gPSAnMzAnOyAkR0xPQkFMU1snYXJlYV90cmVlJ11bJzYnXVsnMSddID0gJzYnOyAkR0xPQkFMU1snYXJlYV90cmVlJ11bJzEnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydhcmVhX3RyZWUnXVsnMSddWycwJ10gPSAnNCc7ICRHTE9CQUxTWydhcmVhX3RyZWUnXVsnMSddWycxJ10gPSAnNSc7ICRHTE9CQUxTWydhcmVhX3RyZWUnXVsnMSddWycyJ10gPSAnMSc7ICRHTE9CQUxTWydhcmVhX3RyZWUnXVsnMSddWyczJ10gPSAnMic7ICRHTE9CQUxTWydhcmVhX3RyZWUnXVsnMSddWyc0J10gPSAnMyc7ICRHTE9CQUxTWydhcmVhX3RyZWUnXVsnMSddWyc1J10gPSAnNjA0JzsgJEdMT0JBTFNbJ2FyZWFfdHJlZSddWycxJ11bJzYnXSA9ICc4MDInOyAkR0xPQkFMU1snYXJlYV90cmVlJ11bJzEyJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snYXJlYV90cmVlJ11bJzEyJ11bJzAnXSA9ICc3Mic7ICRHTE9CQUxTWydhcmVhX3RyZWUnXVsnMTInXVsnMSddID0gJzMzJzsgJEdMT0JBTFNbJ2FyZWFfdHJlZSddWycxMiddWycyJ10gPSAnMTMnOyAkR0xPQkFMU1snYXJlYV90cmVlJ11bJzEyJ11bJzMnXSA9ICcxMic7ICRHTE9CQUxTWydyZW1ha2VDYXRUYWJsZSddID0gJzEnOyAkR0xPQkFMU1snQ2F0VGFibGVDbGllbnQnXSA9ICcxJzsgJEdMT0JBTFNbJ0NhdFRhYmxlTGFuZyddID0gJzInOyAkR0xPQkFMU1snc3luY2Zyb20nXSA9ICcwJzsgJEdMT0JBTFNbJ2VuY29kaW5nJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snZW5jb2RpbmcnXVsnMSddID0gJ2lzby04ODU5LTEnOyAkR0xPQkFMU1snZW5jb2RpbmcnXVsnMiddID0gJ2lzby04ODU5LTEnOyAkR0xPQkFMU1sndmlldyddID0gJ2VkaXQnOyAkR0xPQkFMU1sndXBsX2xhc3RfcGF0aCddID0gJ05vcndheV9pbl9KdW5lLyc7ICRHTE9CQUxTWydicm93c2VycGFyYW1ldGVycyddID0gYXJyYXkoKTsg', '20090629143551')
[29-Jun-2009 14:35:52] /contenido/main.php?area=mod&frame=3&contenido=55221e3dd4399559fc895426ae97841f Session: freeze() failed.
[29-Jun-2009 14:52:01] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 14:52:06] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 14:52:19] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 14:52:48] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 14:52:53] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 14:53:05] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 14:53:30] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 14:53:48] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 14:55:46] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.pretplcfg_edit_form.php(147) : eval()'d code on line 3
[29-Jun-2009 14:56:38] /contenido/main.php?area=js&frame=1&contenido=55221e3dd4399559fc895426ae97841f MySQL error 1062: Duplicate entry '55221e3dd4399559fc895426ae97841f' for key 1
insert into con_phplib_active_sessions ( sid, name, val, changed ) values ('55221e3dd4399559fc895426ae97841f', 'contenido', 'Y29udGVuaWRvOiR0aGlzLT5pbiA9ICcwJzsgJHRoaXMtPnB0ID0gYXJyYXkoKTsgJHRoaXMtPnB0WydhdXRoJ10gPSAnMSc7ICR0aGlzLT5wdFsnY2hhbGxlbmdlJ10gPSAnMSc7ICR0aGlzLT5wdFsnc2F2ZUxvZ2luVGltZSddID0gJzEnOyAkdGhpcy0+cHRbJ2JlbGFuZyddID0gJzEnOyAkdGhpcy0+cHRbJ2NsaWVudCddID0gJzEnOyAkdGhpcy0+cHRbJ2xhbmcnXSA9ICcxJzsgJHRoaXMtPnB0WydzZXNzX2FyZWEnXSA9ICcxJzsgJHRoaXMtPnB0WydjZmdDbGllbnQnXSA9ICcxJzsgJHRoaXMtPnB0WydlcnJzaXRlX2lkY2F0J10gPSAnMSc7ICR0aGlzLT5wdFsnZXJyc2l0ZV9pZGFydCddID0gJzEnOyAkdGhpcy0+cHRbJ3JlbWFrZVN0clRhYmxlJ10gPSAnMSc7ICR0aGlzLT5wdFsnU3RyVGFibGVDbGllbnQnXSA9ICcxJzsgJHRoaXMtPnB0WydTdHJUYWJsZUxhbmcnXSA9ICcxJzsgJHRoaXMtPnB0WydhcmVhX3RyZWUnXSA9ICcxJzsgJHRoaXMtPnB0WydyZW1ha2VDYXRUYWJsZSddID0gJzEnOyAkdGhpcy0+cHRbJ0NhdFRhYmxlQ2xpZW50J10gPSAnMSc7ICR0aGlzLT5wdFsnQ2F0VGFibGVMYW5nJ10gPSAnMSc7ICR0aGlzLT5wdFsnc3luY2Zyb20nXSA9ICcxJzsgJHRoaXMtPnB0WydlbmNvZGluZyddID0gJzEnOyAkdGhpcy0+cHRbJ3ZpZXcnXSA9ICcxJzsgJHRoaXMtPnB0Wyd1cGxfbGFzdF9wYXRoJ10gPSAnMSc7ICR0aGlzLT5wdFsnYnJvd3NlcnBhcmFtZXRlcnMnXSA9ICcxJzsgJEdMT0JBTFNbJ2F1dGgnXSA9IG5ldyBDb250ZW5pZG9fQ2hhbGxlbmdlX0NyeXB0X0F1dGg7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGggPSBhcnJheSgpOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWyd1aWQnXSA9ICc0OGEzNjViNGNlMWUzMjJhNTVhZTkwMTdmM2RhZjBjMCc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ3Blcm0nXSA9ICdzeXNhZG1pbic7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ2V4cCddID0gJzEyNDYyODM3OTcnOyAkR0xPQkFMU1snYXV0aCddLT5hdXRoWydyZWZyZXNoJ10gPSAnMTI0NjI3MDE1OSc7ICRHTE9CQUxTWydhdXRoJ10tPmF1dGhbJ3VuYW1lJ10gPSAnc3lzYWRtaW4nOyAkR0xPQkFMU1snY2hhbGxlbmdlJ10gPSAnNDg1Y2I2NjJjMjI1MzY4YTJhMjRiMmZhZmMzMDE0NWInOyAkR0xPQkFMU1snc2F2ZUxvZ2luVGltZSddID0gJzAnOyAkR0xPQkFMU1snYmVsYW5nJ10gPSAnZGVfREUnOyAkR0xPQkFMU1snY2xpZW50J10gPSAnMSc7ICRHTE9CQUxTWydsYW5nJ10gPSAnMic7ICRHTE9CQUxTWydzZXNzX2FyZWEnXSA9ICdqcyc7ICRHTE9CQUxTWydjZmdDbGllbnQnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnc2V0J10gPSAnc2V0JzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycxJ10gPSBhcnJheSgpOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsncGF0aCddID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycxJ11bJ3BhdGgnXVsnZnJvbnRlbmQnXSA9ICcvaG9tZXBhZ2VzLzM2L2QyNTE4MDAyMzMvaHRkb2NzL2Ntcy8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsncGF0aCddWydodG1scGF0aCddID0gJ2h0dHA6Ly93d3cuYXZpbm51cy5jb20vY21zLyc7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSddWydpbWFnZXMnXSA9ICdodHRwOi8vd3d3LmF2aW5udXMuY29tL2Ntcy9pbWFnZXMvJzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycxJ11bJ3VwbG9hZCddID0gJ3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsnaHRtbHBhdGgnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSddWydodG1scGF0aCddWydmcm9udGVuZCddID0gJ2h0dHA6Ly93d3cuYXZpbm51cy5jb20vY21zLyc7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSddWyd1cGwnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSddWyd1cGwnXVsncGF0aCddID0gJy9ob21lcGFnZXMvMzYvZDI1MTgwMDIzMy9odGRvY3MvY21zL3VwbG9hZC8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsndXBsJ11bJ2h0bWxwYXRoJ10gPSAnaHR0cDovL3d3dy5hdmlubnVzLmNvbS9jbXMvdXBsb2FkLyc7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSddWyd1cGwnXVsnZnJvbnRlbmRwYXRoJ10gPSAndXBsb2FkLyc7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSddWydjc3MnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSddWydjc3MnXVsncGF0aCddID0gJy9ob21lcGFnZXMvMzYvZDI1MTgwMDIzMy9odGRvY3MvY21zL2Nzcy8nOyAkR0xPQkFMU1snY2ZnQ2xpZW50J11bJzEnXVsnanMnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydjZmdDbGllbnQnXVsnMSddWydqcyddWydwYXRoJ10gPSAnL2hvbWVwYWdlcy8zNi9kMjUxODAwMjMzL2h0ZG9jcy9jbXMvanMvJzsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycxJ11bJ3RwbCddID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2NmZ0NsaWVudCddWycxJ11bJ3RwbCddWydwYXRoJ10gPSAnL2hvbWVwYWdlcy8zNi9kMjUxODAwMjMzL2h0ZG9jcy9jbXMvdGVtcGxhdGVzLyc7ICRHTE9CQUxTWydlcnJzaXRlX2lkY2F0J10gPSBhcnJheSgpOyAkR0xPQkFMU1snZXJyc2l0ZV9pZGNhdCddWycxJ10gPSAnMzEnOyAkR0xPQkFMU1snZXJyc2l0ZV9pZGFydCddID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2VycnNpdGVfaWRhcnQnXVsnMSddID0gJzM2JzsgJEdMT0JBTFNbJ3JlbWFrZVN0clRhYmxlJ10gPSAnMSc7ICRHTE9CQUxTWydTdHJUYWJsZUNsaWVudCddID0gJzEnOyAkR0xPQkFMU1snU3RyVGFibGVMYW5nJ10gPSAnMic7ICRHTE9CQUxTWydhcmVhX3RyZWUnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydhcmVhX3RyZWUnXVsnNiddID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2FyZWFfdHJlZSddWyc2J11bJzAnXSA9ICczMCc7ICRHTE9CQUxTWydhcmVhX3RyZWUnXVsnNiddWycxJ10gPSAnNic7ICRHTE9CQUxTWydhcmVhX3RyZWUnXVsnMSddID0gYXJyYXkoKTsgJEdMT0JBTFNbJ2FyZWFfdHJlZSddWycxJ11bJzAnXSA9ICc0JzsgJEdMT0JBTFNbJ2FyZWFfdHJlZSddWycxJ11bJzEnXSA9ICc1JzsgJEdMT0JBTFNbJ2FyZWFfdHJlZSddWycxJ11bJzInXSA9ICcxJzsgJEdMT0JBTFNbJ2FyZWFfdHJlZSddWycxJ11bJzMnXSA9ICcyJzsgJEdMT0JBTFNbJ2FyZWFfdHJlZSddWycxJ11bJzQnXSA9ICczJzsgJEdMT0JBTFNbJ2FyZWFfdHJlZSddWycxJ11bJzUnXSA9ICc2MDQnOyAkR0xPQkFMU1snYXJlYV90cmVlJ11bJzEnXVsnNiddID0gJzgwMic7ICRHTE9CQUxTWydhcmVhX3RyZWUnXVsnMTInXSA9IGFycmF5KCk7ICRHTE9CQUxTWydhcmVhX3RyZWUnXVsnMTInXVsnMCddID0gJzcyJzsgJEdMT0JBTFNbJ2FyZWFfdHJlZSddWycxMiddWycxJ10gPSAnMzMnOyAkR0xPQkFMU1snYXJlYV90cmVlJ11bJzEyJ11bJzInXSA9ICcxMyc7ICRHTE9CQUxTWydhcmVhX3RyZWUnXVsnMTInXVsnMyddID0gJzEyJzsgJEdMT0JBTFNbJ3JlbWFrZUNhdFRhYmxlJ10gPSAnMSc7ICRHTE9CQUxTWydDYXRUYWJsZUNsaWVudCddID0gJzEnOyAkR0xPQkFMU1snQ2F0VGFibGVMYW5nJ10gPSAnMic7ICRHTE9CQUxTWydzeW5jZnJvbSddID0gJzAnOyAkR0xPQkFMU1snZW5jb2RpbmcnXSA9IGFycmF5KCk7ICRHTE9CQUxTWydlbmNvZGluZyddWycxJ10gPSAnaXNvLTg4NTktMSc7ICRHTE9CQUxTWydlbmNvZGluZyddWycyJ10gPSAnaXNvLTg4NTktMSc7ICRHTE9CQUxTWyd2aWV3J10gPSAnZWRpdCc7ICRHTE9CQUxTWyd1cGxfbGFzdF9wYXRoJ10gPSAnTm9yd2F5X2luX0p1bmUvJzsgJEdMT0JBTFNbJ2Jyb3dzZXJwYXJhbWV0ZXJzJ10gPSBhcnJheSgpOyA=', '20090629145638')
[29-Jun-2009 14:56:38] /contenido/main.php?area=js&frame=1&contenido=55221e3dd4399559fc895426ae97841f Session: freeze() failed.
[29-Jun-2009 14:57:56] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 14:58:01] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 15:06:38] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 15:06:45] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 15:06:50] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 15:06:55] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 15:06:59] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 15:07:04] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 15:07:09] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 15:07:16] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 15:07:21] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 15:07:24] /contenido/external/backendedit/front_content.php?changeview=edit&client=1〈=2&action=con_editart&idartlang=89&idart=78&idcat=58&tmpchangelang=&contenido=55221e3dd4399559fc895426ae97841f MySQL 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 '' at line 6
SELECT
level
FROM
con_cat_tree
WHERE
idcat=
[29-Jun-2009 15:07:24] /contenido/external/backendedit/front_content.php?changeview=edit&client=1〈=2&action=con_editart&idartlang=89&idart=78&idcat=58&tmpchangelang=&contenido=55221e3dd4399559fc895426ae97841f next_record called with no query pending in Module ID 19.
[29-Jun-2009 15:07:24] /contenido/external/backendedit/front_content.php?changeview=edit&client=1〈=2&action=con_editart&idartlang=89&idart=78&idcat=58&tmpchangelang=&contenido=55221e3dd4399559fc895426ae97841f MySQL 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 level <= 1
AND C.visible=1
ORDER by A.idtree' at line 13
SELECT
*
FROM
con_cat_tree AS A,
con_cat AS B,
con_cat_lang AS C
WHERE
A.idcat=B.idcat
AND B.idcat=C.idcat
AND C.idlang='2'
AND B.idclient='1'
AND B.parentid=
AND level <= 1
AND C.visible=1
ORDER by A.idtree
[29-Jun-2009 15:07:24] /contenido/external/backendedit/front_content.php?changeview=edit&client=1〈=2&action=con_editart&idartlang=89&idart=78&idcat=58&tmpchangelang=&contenido=55221e3dd4399559fc895426ae97841f next_record called with no query pending in Module ID 19.
[29-Jun-2009 15:07:26] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 15:07:32] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 15:07:38] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 15:07:42] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 15:07:47] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 15:07:50] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 15:07:55] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 15:08:00] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 15:08:15] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.tplcfg_edit_form.php(404) : eval()'d code on line 3
[29-Jun-2009 15:22:39] PHP Parse error: syntax error, unexpected $end in /homepages/36/d251800233/htdocs/contenido/includes/include.pretplcfg_edit_form.php(147) : eval()'d code on line 3
Das Rückgängigmachen der Änderungen und das Upgrade auf 4.8.12 haben leider nicht geholfen. Der Verweis auf fehlerhafte SQL Syntax wundert mich, da keine php Dateien verändert wurden. Zumindest nicht manuell. Kann es sein, dass nach dem Anlegen des neuen Template eine Dateninkonsitenz vorliegt?

Vielen Dank für Hinweise!

Re: MySQL error 1064 und Codefragment in Artikelanzeige

Verfasst: Di 30. Jun 2009, 14:45
von BagHira
Hallo Maxl,

ich kenne das Modul "Article-Include" so nicht / hab noch nicht damit gearbeitet.
Hast du den die entsprechende Kategorie konfiguriert? Das was du in dem Oberen Code-Block drin hast sieht nach dem Output des Modules aus.

Zum zweiten Codeblock

Code: Alles auswählen

...PHP Parse error: syntax error, unexpected $end in ... eval()
Das deutet auf eine nicht geschlossene Klammer in einem Modul hin, hast du irgendein Modul geändert?

Re: MySQL error 1064 und Codefragment in Artikelanzeige

Verfasst: Di 30. Jun 2009, 20:07
von maxl
Hallo Holger!

Vielen Dank für deine schnelle Antwort. Ich habe die Module durchgeschaut und der Output ist vom Modul "Sub_Headline". Geändert habe ich keinen Code in den Modulen. Anbei der Outputcode der Sub_Headline. Vielleicht ist darin was corrupt?

Code: Alles auswählen

<?php
/**
* $RCSfile$
*
* Description: Output standard h2 subheadline
*
* @version 1.0.0
* @author Rudi Bieller
* @copyright four for business AG <www.4fb.de>
*
* {@internal
* created 2008-04-07
* }}
*
* $Id$
*/

$sText = "CMS_HTMLHEAD[2]";

if (!isset($tpl) || !is_object($tpl)) {
    $tpl = new Template();
}

$tpl->reset();
if ($contenido && $edit) {
    $tpl->set('s', 'text', $sText);
    $tpl->generate('templates/subheadline_h2.html');
} else {
    if ($sText != '') {
        $tpl->set('s', 'text', strip_tags($sText));
        $tpl->generate('templates/subheadline_h2.html');
    }
}

?>    #Includes
    cInclude("frontend", "includes/functions.input.helper.php");

    # Initialization
    $bDebug      = false;
    $iDataStart  = 20;
    $sSubmitLink = '<a href="javascript:if (document.tplcfgform.send) {document.tplcfgform.send.value = 0}; document.tplcfgform.submit();"><img src="images/submit.gif" /></a>';
    unset ($aSettings);

    # Base settings
    $aSettings = array();
    $aSettings["ArticleCount"]       = "CMS_VALUE[0]";
    $aSettings["ArticlePerPage"]     = "CMS_VALUE[1]";
    $aSettings["SortBy"]             = "CMS_VALUE[2]";
    $aSettings["SortDir"]            = "CMS_VALUE[3]";
    $aSettings["ShowStart"]          = "CMS_VALUE[4]";
    $aSettings["Category"]           = "CMS_VALUE[5]";
    $aSettings["SampleCat"]          = "CMS_VALUE[12]";
    $aSettings["SampleArt"]          = "CMS_VALUE[6]";
    $aSettings["HeadlineIdentifier"] = "CMS_VALUE[7]";
    $aSettings["HeadlineLength"]     = "CMS_VALUE[8]";
    $aSettings["Elements"]           = "CMS_VALUE[9]";
    $aSettings["CatTypeSel"]         = "CMS_VALUE[10]";
    $aSettings["AddCats"]            = "CMS_VALUE[11]";
    $aSettings["Template"]           = "CMS_VALUE[99]";


    # Checking base settings
    if (!is_numeric($aSettings["ArticleCount"]) || $aSettings["ArticleCount"] < 0) {
       $aSettings["ArticleCount"] = 5;
    }
    if (!is_numeric($aSettings["ArticlePerPage"]) || $aSettings["ArticlePerPage"] < 0) {
       $aSettings["ArticlePerPage"] = 0; // Deactivating page browsing
    }
    if (!is_numeric($aSettings["Category"]) || $aSettings["Category"] <= 0) {
       $aSettings["Category"] = 0;
    }
    if (!is_numeric($aSettings["SampleCat"]) || $aSettings["SampleCat"] <= 0) {
       $aSettings["SampleCat"] = $aSettings["Category"];
    }
    if (!is_numeric($aSettings["SampleArt"]) || $aSettings["SampleArt"] < 0) {
       $aSettings["SampleArt"] = 0;
    }
    if (strlen($aSettings["HeadlineIdentifier"]) > 50) {
       $aSettings["HeadlineIdentifier"] = "";
    }
    if (!is_numeric($aSettings["HeadlineLength"]) || $aSettings["HeadlineLength"] < 0) {
       $aSettings["HeadlineLength"] = 0;
    }
    if (!is_numeric($aSettings["Elements"]) || $aSettings["Elements"] < 0) {
       $aSettings["Elements"] = 0;
    }
    if ($aSettings["CatTypeSel"] == "" || ($aSettings["AddCats"] == "" && $aSettings["CatTypeSel"] == "selected")) {
       $aSettings["CatTypeSel"] = "none";
    }

    # Detail settings
    if ($aSettings["Elements"] > 0) {
       for ($i = 0; $i < $aSettings["Elements"]; $i++) {
          $iElementType       = $iDataStart + ($i * 5);
          $iElementIdentifier = $iElementType + 1;
          $iElementWidth      = $iElementType + 2;
          $iElementHeight     = $iElementType + 3;

          $aSettings["k".$i] = array();
          $aSettings["k".$i]["ElementType"]    = "CMS_VALUE[$iElementType]"; // Text, Image, ExtractedImage
          $aSettings["k".$i]["Identifier"]     = "CMS_VALUE[$iElementIdentifier]";
          $aSettings["k".$i]["ElementWidth"]   = "CMS_VALUE[$iElementWidth]"; // Textlength or ImageWidth
          $aSettings["k".$i]["ElementHeight"]  = "CMS_VALUE[$iElementHeight]";

          # Check detail settings
          if ($aSettings["k".$i]["ElementType"] == "") {
             $aSettings["k".$i]["ElementType"] == "Text";
          }
              if ($aSettings["k".$i]["ElementType"] == "") {
             $aSettings["k".$i]["ElementType"] == "Textanders";
          }       
          if ($aSettings["k".$i]["ElementType"] == "Text") {
             $aSettings["ElementHeight"] = 0;
             if (!is_numeric($aSettings["k".$i]["ElementWidth"]) || $aSettings["k".$i]["ElementWidth"] < 0) {
                $aSettings["k".$i]["ElementWidth"] = 50;
             }
          } else if (!is_numeric($aSettings["k".$i]["ElementWidth"]) || $aSettings["k".$i]["ElementWidth"] <= 0 ||
                     !is_numeric($aSettings["k".$i]["ElementHeight"]) || $aSettings["k".$i]["ElementHeight"] <= 0) {
             $aSettings["k".$i]["ElementWidth"] = 0;
             $aSettings["k".$i]["ElementHeight"] = 0;
          }
          if (strlen($aSettings["Identifier"]) > 50) {
             $aSettings["Identifier"] = "";
          }
       }
    }


    echo '        <table cellspacing="0" cellpadding="2" border="0" width="100%">'."\n";
    echo '           <tr>'."\n";
    echo '              <td class="text">'.mi18n("Primary Category:").'</td>'."\n";
    echo '              <td class="text">'.fncBuildCategorySelect("CMS_VAR[5]", $aSettings["Category"], 0, "").'</td>'."\n";
    echo '           </tr>'."\n";
    echo '           <tr>'."\n";
    echo '              <td class="text" style="vertical-align: top;">'.mi18n("Additional Categories:").'</td>'."\n";
    echo '              <td class="text">';
    if ($aSettings["CatTypeSel"] == "none") {
       echo '<input type="radio" name="CMS_VAR[10]" value="none" checked="checked" onclick="document.getElementsByName(\'c'.$cnumber.'cbxAddCatSel\')[0].disabled = true;">'.mi18n("None").'&nbsp;';
    } else {
       echo '<input type="radio" name="CMS_VAR[10]" value="none" onclick="document.getElementsByName(\'c'.$cnumber.'cbxAddCatSel\')[0].disabled = true;">'.mi18n("None").'&nbsp;';
    }
    if ($aSettings["CatTypeSel"] == "below") {
       echo '<input type="radio" name="CMS_VAR[10]" value="below" checked="checked" onclick="document.getElementsByName(\'c'.$cnumber.'cbxAddCatSel\')[0].disabled = true;">'.mi18n("All below primary").'&nbsp;';
    } else {
       echo '<input type="radio" name="CMS_VAR[10]" value="below" onclick="document.getElementsByName(\'c'.$cnumber.'cbxAddCatSel\')[0].disabled = true;">'.mi18n("All below primary").'&nbsp;';
    }
    if ($aSettings["CatTypeSel"] == "selected") {
       $sDisabled = "";
       echo '<input type="radio" name="CMS_VAR[10]" value="selected" checked="checked" onclick="document.getElementsByName(\'c'.$cnumber.'cbxAddCatSel\')[0].disabled = false;">'.mi18n("Selected").'<br>';
    } else {
       $sDisabled = "disabled";
       echo '<input type="radio" name="CMS_VAR[10]" value="selected" onclick="document.getElementsByName(\'c'.$cnumber.'cbxAddCatSel\')[0].disabled = false;">'.mi18n("Selected").'<br>';
    }
    echo fncAddMultiSelJS().fncBuildCategorySelect("c".$cnumber."cbxAddCatSel", $aSettings["AddCats"], 0, "fncUpdateSel('c".$cnumber."cbxAddCatSel', '"."CMS_VAR[11]"."');", "10", "multiple", false, 0, $sDisabled);
    echo '<input type="hidden" name="CMS_VAR[11]" value="'.$aSettings["AddCats"].'"></td>'."\n";
    echo '           </tr>'."\n";
    echo '           <tr>'."\n";
    echo '              <td class="text">'.mi18n("Article:").'</td>'."\n";
    echo '              <td class="text">'.mi18n("Count (total):").'&nbsp;<input type="text" name="CMS_VAR[0]" value="'.$aSettings["ArticleCount"].'" size="3" title="'.mi18n("Set to 0 to show all articles").'">&nbsp;'."\n";
    echo '                '.mi18n("Per Page:").'&nbsp;<input type="text" name="CMS_VAR[1]" value="'.$aSettings["ArticlePerPage"].'" size="3" title="'.mi18n("Set to 0 to disable page browsing").'"></td>'."\n";
    echo '           </tr>'."\n";
    echo '           <tr>'."\n";
    echo '              <td class="text">'.mi18n("Sort by:").'</td>'."\n";
    echo '              <td class="text"><select name="CMS_VAR[2]">'."\n";
    if ($aSettings["SortBy"] == "" || $aSettings["SortBy"] == "CATART.idart") {
       echo '                <option value="CATART.idart" selected>'.mi18n("Article ID").'</option>'."\n";
    } else {
       echo '                <option value="CATART.idart">'.mi18n("Article ID").'</option>'."\n";
    }
    if ($aSettings["SortBy"] == "idtree") {
       echo '                <option value="idtree" selected>'.mi18n("idtree").'</option>'."\n";
    } else {
       echo '                <option value="idtree">'.mi18n("idtree").'</option>'."\n";
    }
    if ($aSettings["SortBy"] == "tblData.value") {
       echo '                <option value="tblData.value" selected>'.mi18n("Headline").'</option>'."\n";
    } else {
       echo '                <option value="tblData.value">'.mi18n("Headline").'</option>'."\n";
    }
    if ($aSettings["SortBy"] == "ARTLANG.created") {
       echo '                <option value="ARTLANG.created" selected>'.mi18n("Add Date").'</option>'."\n";
    } else {
       echo '                <option value="ARTLANG.created">'.mi18n("Add Date").'</option>'."\n";
    }
    if ($aSettings["SortBy"] == "ARTLANG.lastmodified") {
       echo '                <option value="ARTLANG.lastmodified" selected>'.mi18n("Last Modified Date").'</option>'."\n";
    } else {
       echo '                <option value="ARTLANG.lastmodified">'.mi18n("Last Modified Date").'</option>'."\n";
    }
    if ($aSettings["SortBy"] == "ARTLANG.published") {
       echo '                <option value="ARTLANG.published" selected>'.mi18n("Published Date").'</option>'."\n";
    } else {
       echo '                <option value="ARTLANG.published">'.mi18n("Published Date").'</option>'."\n";
    }
    if ($aSettings["SortBy"] == "ARTLANG.title") {
       echo '                <option value="ARTLANG.title" selected>'.mi18n("Page Title (Backend)").'</option>'."\n";
    } else {
       echo '                <option value="ARTLANG.title">'.mi18n("Page Title (Backend)").'</option>'."\n";
    }
    if ($aSettings["SortBy"] == "ARTLANG.pagetitle") {
       echo '                <option value="ARTLANG.pagetitle" selected>'.mi18n("Page Title (Frontend)").'</option>'."\n";
    } else {
       echo '                <option value="ARTLANG.pagetitle">'.mi18n("Page Title (Frontend)").'</option>'."\n";
    }
    if ($aSettings["SortBy"] == "ARTLANG.summary") {
       echo '                <option value="ARTLANG.summary" selected>'.mi18n("Summary (Backend)").'</option>'."\n";
    } else {
       echo '                <option value="ARTLANG.summary">'.mi18n("Summary (Backend)").'</option>'."\n";
    }
    if ($aSettings["SortBy"] == "ARTLANG.artsort") {
       echo '                <option value="ARTLANG.artsort" selected>'.mi18n("Sort No.").'</option>'."\n";
    } else {
       echo '                <option value="ARTLANG.artsort">'.mi18n("Sort No.").'</option>'."\n";
    }
    if ($aSettings["SortBy"] == "RAND()") {
       echo '                <option value="RAND()" selected>'.mi18n("Random").'</option>'."\n";
    } else {
       echo '                <option value="RAND()">'.mi18n("Random").'</option>'."\n";
    }
    echo '              </select>'."\n";
    if (($aSettings["SortDir"] != "DESC") && ($aSettings["SortDir"] == "ASC") && ($aSettings["SortDir"] != "IDTREE") ) {
       echo '             <input type="radio" name="CMS_VAR[3]" value="ASC" checked>'.mi18n("Ascending").'&nbsp;<input type="radio" name="CMS_VAR[3]" value="DESC">'.mi18n("Descending").'&nbsp; <input type="radio" name="CMS_VAR[3]" value="b.idtree">'.mi18n("idtree")."\n";
    } else if (($aSettings["SortDir"] == "DESC") && ($aSettings["SortDir"] != "ASC") && ($aSettings["SortDir"] != "IDTREE")){
       echo '             <input type="radio" name="CMS_VAR[3]" value="ASC">'.mi18n("Ascending").'&nbsp;<input type="radio" name="CMS_VAR[3]" value="DESC" checked>'.mi18n("Descending").'&nbsp;<input type="radio" name="CMS_VAR[3]" value="b.idtree">'.mi18n("idtree")."\n";
    }
    else {
       echo '             <input type="radio" name="CMS_VAR[3]" value="ASC">'.mi18n("Ascending").'&nbsp;<input type="radio" name="CMS_VAR[3]" value="DESC">'.mi18n("Descending").'&nbsp;<input type="radio" name="CMS_VAR[3]" value="b.idtree" checked>'.mi18n("idtree")."\n";
    }
    echo '           </tr>'."\n";
    echo '           <tr>'."\n";
    echo '              <td class="text">'.mi18n("Start Article:").'</td>'."\n";
    if ($aSettings["ShowStart"] != "enabled") {
       echo '              <td class="text"><input type="checkbox" name="CMS_VAR[4]" value="enabled">'.mi18n("Show").'</td>'."\n";
    } else {
       echo '              <td class="text"><input type="checkbox" name="CMS_VAR[4]" value="enabled" checked>'.mi18n("Show").'</td>'."\n";
    }
    echo '           </tr>'."\n";
    echo '        </table>'."\n";
    echo '        <table cellspacing="0" cellpadding="2" border="0" width="100%">'."\n";
    echo '           <tr>'."\n";
    echo '              <td colspan="2" class="textw_medium" style="background-color: #a9aec2; border: 1px solid #747488;">'.mi18n("Identify elements:").'</td>'."\n";
    echo '           </tr>'."\n";
    echo '    <tr>
                <td class="text" style="border-left:1px solid #747488;">'.mi18n("Choose Template").':</td>
                 <td class="text" style="border-right: 1px solid #747488;">
                     <select name="CMS_VAR[99]" size="1">
                        <option value="">'.mi18n("Nothing selected").'</option>';

                 // $strPath_fs = $cfgClient[$client]["path"]["frontend"].'templates/'; 
                 $strPath_fs = '../cms/templates/';           

                 $optionFields ="";
                 $handle = opendir($strPath_fs);
             $files = array();
             while ($entryName = readdir($handle))
             {
                    if (is_file($strPath_fs.$entryName))
            {
                $files[]=array($strPath_fs.$entryName,$entryName);
            }
                 }
                 closedir($handle);
                 asort($files);
                while (list ($key, $val) = each ($files))
                 {
             if ("CMS_VALUE[99]"==$val[0]) {
                $optionFields.="\n\t".'<option selected="selected" value="'.$val[0].'">'.$val[1].'</option>';
            } else {
                $optionFields.="\n\t".'<option value="'.$val[0].'">'.$val[1].'</option>';
            }

             }
       echo $optionFields.'</select><br /><br /></td>
       </tr>';
    echo '           <tr>'."\n";
    echo '              <td class="text" style="border-left:  1px solid #747488;">'.mi18n("Sample Category:").'</td>'."\n";
    echo '              <td class="text" style="border-right: 1px solid #747488;">'.fncBuildCategorySelect("CMS_VAR[12]", $aSettings["SampleCat"], 0, "if (document.forms[0].elements['CMS_VAR[12]'].value != 'CMS_VALUE[12]') { document.forms[0].elements['CMS_VAR[6]'].disabled = true; document.forms[0].elements['CMS_VAR[7]'].disabled = true; document.forms[0].elements['CMS_VAR[8]'].disabled = true; document.forms[0].elements['CMS_VAR[9]'].disabled = true; } else { document.forms[0].elements['CMS_VAR[6]'].disabled = false; document.forms[0].elements['CMS_VAR[7]'].disabled = false; document.forms[0].elements['CMS_VAR[8]'].disabled = false; document.forms[0].elements['CMS_VAR[9]'].disabled = false;}").'&nbsp'.$sSubmitLink.'</td>'."\n";
    echo '           </tr>'."\n";
    echo '           <tr>'."\n";
    echo '              <td class="text" style="border-left:  1px solid #747488;">'.mi18n("Sample Article:").'</td>'."\n";
    if ($aSettings["SampleCat"] == 0) {
       $sDisabled = "disabled";
    } else {
       $sDisabled = "";
    }
    echo '              <td class="text" style="border-right: 1px solid #747488;">'.fncBuildArticleSelect("CMS_VAR[6]", $aSettings["SampleCat"], $aSettings["SampleArt"], "if (document.forms[0].elements['CMS_VAR[6]'].value != 'CMS_VALUE[6]') { document.forms[0].elements['CMS_VAR[7]'].disabled = true; document.forms[0].elements['CMS_VAR[8]'].disabled = true; document.forms[0].elements['CMS_VAR[9]'].disabled = true; } else { document.forms[0].elements['CMS_VAR[7]'].disabled = false; document.forms[0].elements['CMS_VAR[8]'].disabled = false; document.forms[0].elements['CMS_VAR[9]'].disabled = false;}", $sDisabled).'&nbsp'.$sSubmitLink.'</td>'."\n";
    echo '           </tr>'."\n";
    echo '           <tr>'."\n";
    echo '              <td class="text" style="border-left:  1px solid #747488;">'.mi18n("Headline Element:").'</td>'."\n";
    echo '              <td class="text" style="border-right: 1px solid #747488;">'.fncBuildTypeSelect("CMS_VAR[7]", $aSettings["SampleArt"], $aSettings["HeadlineIdentifier"], "'1','2','3','9','17'").' '.mi18n("Length (max.):").' <input type="text" name="'."CMS_VAR[8]".'" value="'.$aSettings["HeadlineLength"].'" size="3" title="'.mi18n("Set to 0 to show all").'"></td>'."\n";
    echo '           </tr>'."\n";

    if ($aSettings["Elements"] == 0) {
       $sBottomStyle = "border-bottom: 1px solid #747488;"; // Paint the table area closing line
    } else {
       $sBottomStyle = "";
    }
    echo '           <tr>'."\n";
    echo '              <td class="text" style="border-left:  1px solid #747488;'.$sBottomStyle.'">'.mi18n("Additional elements:").'</td>'."\n";
    echo '              <td class="text" style="border-right: 1px solid #747488;'.$sBottomStyle.'"><input type="text" name="CMS_VAR[9]" value="'.$aSettings["Elements"].'" size="3" title="'.mi18n("Set to a value above 0 to specify text or images as additional elements").'">&nbsp'.$sSubmitLink.'</td>'."\n";
    echo '           </tr>'."\n";

    if ($aSettings["Elements"] > 0) {
       for ($i = 0; $i < $aSettings["Elements"]; $i++) {
          $iElementType       = $iDataStart + ($i * 5);
          $iElementIdentifier = $iElementType + 1;
          $iElementWidth      = $iElementType + 2;
          $iElementHeight     = $iElementType + 3;

          echo '           <tr>'."\n";
          echo '              <td class="text" style="border-left:  1px solid #747488;padding-left: 20px;vertical-align: top;">'.sprintf(mi18n("%s. Element:"), $i + 1).'</td>'."\n";
          echo '              <td class="text" style="border-right: 1px solid #747488;">'.mi18n("Type:").'<br />'."\n";
          echo '                <select name="'."CMS_VAR[$iElementType]".'" onchange="if (document.forms[0].elements[\''."CMS_VAR[$iElementType]".'\'].value != \''.$aSettings["k".$i]["ElementType"].'\') { document.forms[0].elements[\''."CMS_VAR[$iElementIdentifier]".'\'].disabled = true; document.forms[0].elements[\''."CMS_VAR[$iElementWidth]".'\'].disabled = true; if (document.forms[0].elements[\''."CMS_VAR[$iElementHeight]".'\']) {document.forms[0].elements[\''."CMS_VAR[$iElementHeight]".'\'].disabled = true;}} else { document.forms[0].elements[\''."CMS_VAR[$iElementIdentifier]".'\'].disabled = false; document.forms[0].elements[\''."CMS_VAR[$iElementWidth]".'\'].disabled = false; if (document.forms[0].elements[\''."CMS_VAR[$iElementHeight]".'\']) {document.forms[0].elements[\''."CMS_VAR[$iElementHeight]".'\'].disabled = false;}}"">'."\n";
          if ($aSettings["k".$i]["ElementType"] == "Text") {
             echo '                 <option value="Text" selected="selected">'.mi18n("Text").'</option>'."\n";
          } else {
             echo '                 <option value="Text">'.mi18n("Text").'</option>'."\n";
          }
          if ($aSettings["k".$i]["ElementType"] == "Textanders") {
             echo '                 <option value="Textanders" selected="selected">'.mi18n("Textanders").'</option>'."\n";
          } else {
             echo '                 <option value="Textanders">'.mi18n("Textanders").'</option>'."\n";
          }
          if ($aSettings["k".$i]["ElementType"] == "Image") {
             echo '                 <option value="Image" selected="selected">'.mi18n("Image").'</option>'."\n";
          } else {
             echo '                 <option value="Image">'.mi18n("Image").'</option>'."\n";
          }
          if ($aSettings["k".$i]["ElementType"] == "ExtractedImage") {
             echo '                 <option value="ExtractedImage" selected="selected">'.mi18n("Image from text").'</option>'."\n";
          } else {
             echo '                 <option value="ExtractedImage">'.mi18n("Image from text").'</option>'."\n";
          }
          echo '                 </select>&nbsp'.$sSubmitLink.'&nbsp;'."\n";
          echo '              </td>'."\n";
          echo '           </tr>'."\n";

          if ($i == ($aSettings["Elements"] - 1)) {
             $sBottomStyle = "border-bottom: 1px solid #747488;"; // Paint the table area closing line
          } else {
             $sBottomStyle = "";
          }

          echo '           <tr>'."\n";
          switch ($aSettings["k".$i]["ElementType"]) {
             case "Image":
                echo '              <td class="text" style="border-left:  1px solid #747488;'.$sBottomStyle.'padding-left: 20px;">&nbsp;</td>'."\n";
                echo '              <td class="text" style="border-right: 1px solid #747488;'.$sBottomStyle.'">'.mi18n("Item:").'<br />'.fncBuildTypeSelect("CMS_VAR[$iElementIdentifier]", $aSettings["SampleArt"], $aSettings["k".$i]["Identifier"], "'4'").'&nbsp;'."\n";
                echo '                 '.mi18n("Width:"). ' <input type="text" name="'."CMS_VAR[$iElementWidth]".'" value="'.$aSettings["k".$i]["ElementWidth"].'" size="4" title="'.mi18n("Set to 0 to disable resize").'">&nbsp;'."\n";
                echo '                 '.mi18n("Height:").' <input type="text" name="'."CMS_VAR[$iElementHeight]".'" value="'.$aSettings["k".$i]["ElementHeight"].'" size="4" title="'.mi18n("Set to 0 to disable resize").'"></td>'."\n";
                break;
             case "ExtractedImage":
                echo '              <td class="text" style="border-left:  1px solid #747488;'.$sBottomStyle.'padding-left: 20px;">&nbsp;</td>'."\n";
                echo '              <td class="text" style="border-right: 1px solid #747488;'.$sBottomStyle.'">'.mi18n("Item:").'<br />'.fncBuildTypeSelect("CMS_VAR[$iElementIdentifier]", $aSettings["SampleArt"], $aSettings["k".$i]["Identifier"], "'1','2','3','9','17'").'&nbsp;'."\n";
                echo '                 '.mi18n("Width:"). ' <input type="text" name="'."CMS_VAR[$iElementWidth]".'" value="'.$aSettings["k".$i]["ElementWidth"].'" size="4" title="'.mi18n("Set to 0 to disable resize").'">&nbsp;'."\n";
                echo '                 '.mi18n("Height:").' <input type="text" name="'."CMS_VAR[$iElementHeight]".'" value="'.$aSettings["k".$i]["ElementHeight"].'" size="4" title="'.mi18n("Set to 0 to disable resize").'"></td>'."\n";
                break;
             default:
                echo '              <td class="text" style="border-left:  1px solid #747488;'.$sBottomStyle.'padding-left: 20px;">&nbsp;</td>'."\n";
                echo '              <td class="text" style="border-right: 1px solid #747488;'.$sBottomStyle.'">'.mi18n("Item:").'<br />'.fncBuildTypeSelect("CMS_VAR[$iElementIdentifier]", $aSettings["SampleArt"], $aSettings["k".$i]["Identifier"], "'1','2','3','9','17'").'&nbsp;'."\n";
                echo '                 '.mi18n("Length (max.):").' <input type="text" name="'."CMS_VAR[$iElementWidth]".'" value="'.$aSettings["k".$i]["ElementWidth"].'" size="3" title="'.mi18n("Set to 0 to show all").'"></td>'."\n";
          }
          echo '           </tr>'."\n";
       }
    }

    echo '        </table></div>'."\n";
Es sieht so aus, als wenn der Code nach "#Includes" nicht ausgeführt, sondern quasi direkt angezeigt wird, bis auf die HTML Tags, die werden umgesetzt. Ich habe beim Durchsehen der Module festgestellt, dass einige nicht mit "<?php" beginnen, sondern mit "?>". Das habe ich eben so abgeändert, dass mit "<?php" begonnen wird und mit "?>" geschlossen (ausser wenn nach dem ?> noch Includes kommen oder pures HTML). Hat aber nicht geholfen.

Danke für weitere Analyse!

Re: MySQL error 1064 und Codefragment in Artikelanzeige

Verfasst: Di 30. Jun 2009, 20:38
von idea-tec
hi,
also zuerst einmal, müsste dir die AMPEL!!! direkt links oben neben Output ein ROT anzeigen (dein fall habe ich selbst nicht geprüft, sollte aber eigentlich ein fehler angezeigt werden), denn dir fehlt der schließende php-Tag

Code: Alles auswählen

?>
am ende des moduls
zudem ist das ORIGINAL so:

Code: Alles auswählen

<?php
/**
* $RCSfile$
*
* Description: Output standard h2 subheadline
*
* @version 1.0.0
* @author Rudi Bieller
* @copyright four for business AG <www.4fb.de>
*
* {@internal
* created 2008-04-07
* }}
*
* $Id$

*/
$sText = "CMS_HTMLHEAD[2]";
if (!isset($tpl) || !is_object($tpl)) {
    $tpl = new Template();
}
$tpl->reset();
if ($contenido && $edit) {
    $tpl->set('s', 'text', $sText);
    $tpl->generate('templates/subheadline_h2.html');
} else {
    if ($sText != '') {
        $tpl->set('s', 'text', strip_tags($sText));
        $tpl->generate('templates/subheadline_h2.html');
    }
}
?>
Ich vermute da wurde unsinn reinkopiert!!!

lösung:
entweder du löschst das "?>" VOR "#Includes" und setzt es ganz ans ende des output
oder du löschst alles ab "#Includes"
ich habe mir den rest ab #includes nicht angesehen, da mich nicht interessiert was du vor hast, aber da hat definitiv einer nicht aufgepasst ;-)

NACHTRAG:
Der so eingefügte Code führt tatsächlich nciht zu einer Fehleranzeige des Moduls!!!
Getestet in 4.8.12 mit genau dem Code von maxl

Re: MySQL error 1064 und Codefragment in Artikelanzeige

Verfasst: Di 30. Jun 2009, 21:03
von maxl
Hallo Karsten!

Vielen Dank für den original Code-Block. Ich habe den Include-Part rausgenommen und alles sieht wieder gut aus! :-)

Da ich definitiv keinen Code dort eingefügt hatte, kann es aus meiner Sicht nur am Anlegen des neuen Template mit dem Auswählen von Artikel_Include und anlegen einer solchen Kategorie liegen. Das neue Template hatte ich Artikelliste genannt, mit dem Layout der Site. Dann habe ich einer Kategorie vom Typ Newsliste das neue Template zugewiesen und einen Artikel als Include ausgewählt. Danach erschien dann der Fehler.

Mach ich nicht wieder ;-)

Danke nochmal und einen schönen Abend noch!
Alle Zeiten sind UTC+01:00
Seite 1 von 1

Powered by phpBB® Forum Software © phpBB Limited

Deutsche Übersetzung durch phpBB.de