Dragonfly CMS - German Community

vibz · Investigator Offline Joined: May 20, 2004 Posts: 5

Wenn ich einen neuen banner hinzufügen möchte kommt diese fehlermeldung:

On /index.php?name=Our_Sponsors
While executing query "insert into cms_banner values (NULL, '', '1000', '0', '0', 'http://www.mailrakete.de/bannerfarm/banner4.gif', 'http://www.dw0.de', 'txt', now(), '00-00-0000 00:00:00', '0', '0', '0', '', '', '', '','')"

the following error occured: Column count doesn't match value count at row 1

kann mir bitte jemand helfen?

Ertan · Posted: 21.05.2004 02:39 Post subject: Re: ERROR bei our_sponsors

bitte noch info über benutzte cpg version?

Ertan · Posted: 21.05.2004 15:29 Post subject: Re: ERROR bei our_sponsors

der 8.1.1 installer fügt 1 feld zu viel in cms_banner

Fix:

ALTER TABLE cms_banner DROP text_url;

spoddig · Doppel-Null-Agent Offline Joined: May 19, 2004 Posts: 208

und wie ändere ich das in der Datenbank

spoddig · Doppel-Null-Agent Offline Joined: May 19, 2004 Posts: 208

Ich weiß ja nicht ob das so richtig ist.
In der Datenbank habe ich in cms4u_banner folgende Zeile eingefügt.
text_url varchar(100) NOT NULL default '',

Ist das so richtig??

spoddig · Doppel-Null-Agent Offline Joined: May 19, 2004 Posts: 208

Nun das war wohl nicht richtig oder der Fehler liegt woanders. Soeben habe ich wieder eine Mail bekommen.
On / While executing query "update cms4u_banner set impmade=impmade+1 where bid=" the following error occured: You have an error in your SQL syntax near '' at line 1 Guest information: User id: Username: IP: 81.0.16.137 Admin: No .

Noch komme ich auf die Seite aber ich denke in ein zwei Stunden ist wieder schluß, wie jedesmal das nervt langsam.

Hilfe

spoddig · Doppel-Null-Agent Offline Joined: May 19, 2004 Posts: 208

Fehler konnte ich leider nnicht beheben aber ich habe gemerkt das der Fehler nur auftrit wenn ich ein anderes Thme al das Standard Theme verwende.
Mit folgendem Theme habe ich oben genanntes Problem:
<?php

/********************************************************/
/* NSN Theme v3 */
/* By: NukeScripts Network (webmaster@nukescripts.net) */
/* www.nukescripts.net */
/* Copyright © 2000-2003 by NukeScripts Network */
/********************************************************/

global $nv, $new_topic, $catid, $topic, $categories, $topics, $side, $pos, $storyhome, $loonr, $kokku, $NameOfTheme, $bgcolor1, $bgcolor2, $bgcolor3, $bgcolor4, $bgcolor5, $bgcolor6, $bgcolor7, $textcolor1, $textcolor2, $textcolor3, $textcolor4, $prefix, $db, $querylang;
if ($topics==1) {
$kokku = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_stories WHERE topic='$topic' $querylang LIMIT $storyhome"));
} elseif($categories==1) {
$kokku = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_stories WHERE catid='$catid' $querylang LIMIT $storyhome"));
} elseif($new_topic > 0) {
$kokku = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_stories WHERE topic='$new_topic' $querylang LIMIT $storyhome"));
} else {
$kokku = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_stories WHERE sid='*' $querylang LIMIT 0, $storyhome "));
}

$nv = 2; // 1 for textual, 2 for graphical
$NameOfTheme = basename(dirname(__FILE__));
include("themes/$NameOfTheme/colors.php");

if ($kokku == "") { $kokku = $storyhome; }
if ($loonr == "") { $loonr = "0"; }
if (isset($newlang)) { $language = $newlang; } elseif (isset($lang)) { $language = $lang; }
if(file_exists("themes/$NameOfTheme/language/lang-$language.php")) { include("themes/$NameOfTheme/language/lang-$language.php"); } else { include("themes/$NameOfTheme/language/lang-english.php"); }
include("themes/$NameOfTheme/tables.php");

/************************************************************/
/* Function themeheader() */
/************************************************************/

function themeheader() {
global $nv, $user, $admin, $banners, $sitename, $slogan, $cookie, $prefix, $user_prefix, $db, $NameOfTheme, $bgcolor1, $bgcolor2, $bgcolor3, $bgcolor4, $bgcolor5, $bgcolor6, $bgcolor7, $textcolor1, $textcolor2, $textcolor3, $textcolor4;
cookiedecode($user);
$username = $cookie[1];
if ($username == "") {
$username = "Anonymous";
}
echo "<body text=\"$textcolor1\" topmargin=\"0\" leftmargin=\"0\" marginwidth=\"0\" marginheight=\"0\">\n";
include("themes/$NameOfTheme/style.php");
echo "<div id=\"overDiv\" style=\"position:absolute; visibility:hidden; z-index:1000;\"></div>\n";
echo "<script language=\"JavaScript\" src=\"themes/$NameOfTheme/style/overlib.js\"></script>\n";
if ($banners == 1) {
global $prefix, $db, $admin;
$bresult = $db->sql_query("select * from ".$prefix."_banner");
$numrows = $db->sql_numrows($bresult);
if ($numrows>1) {
$numrows = $numrows-1;
mt_srand((double)microtime()*1000000);
$bannum = mt_rand(0, $numrows);
} else {
$bannum = 0;
}
$bresult2 = $db->sql_query("select bid, imageurl from ".$prefix."_banner limit $bannum,1");
list($bid, $imageurl) = $db->sql_fetchrow($bresult2);
if (!is_admin($admin)) {
$db->sql_query("update ".$prefix."_banner set impmade=impmade+1 where bid=$bid");
}
if($numrows>0) {
$aborrar = $db->sql_query("select cid, imptotal, impmade, clicks, date from ".$prefix."_banner where bid=$bid");
list($cid, $imptotal, $impmade, $clicks, $date) = $db->sql_fetchrow($aborrar);
if (($imptotal <= $impmade) AND ($imptotal != 0)) {
$db->sql_query("insert into ".$prefix."_bannerfinish values (NULL, '$cid', '$impmade', '$clicks', '$date', now())");
$db->sql_query("delete from ".$prefix."_banner where bid=$bid");
}
$tbanners = "<a href=\"banners.php?op=click&amp;bid=$bid\" target=\"_blank\"><img src=\"$imageurl\" border=\"0\" alt=\"\"></a>";
}
}
$uresult = $db->sql_query("select user_id from ".$user_prefix."_users where username='$username'");
list($uid) = $db->sql_fetchrow($uresult);
$presult = $db->sql_query("select * from ".$prefix."_bbprivmsgs where privmsgs_to_userid='$uid' AND (privmsgs_type='0' OR privmsgs_type='1' OR privmsgs_type='3' OR privmsgs_type='5')");
$pnumrow = $db->sql_numrows($presult);
if ($username == "Anonymous") {
$priv_msgs = "<font class=\"content\">"._TNOINFOFOR." $username</font>";
} else {
$priv_msgs = "<font class=\"content\">"._TYOUHAVE." <a href=\"modules.php?name=Private_Messages\">$pnumrow</a> "._TPRIVATEMSG."</font>";
}
$mresult = $db->sql_query("select * from ".$user_prefix."_users");
$mnumrow = $db->sql_numrows($mresult);
$members = "<font class=\"content\">"._TREGUSERS." $mnumrow</font>";
if ($username == "Anonymous") {
$theuser = "<a href=\"modules.php?name=Your_Account&op=new_user\">"._TNEWUSER."</a> / <a href=\"modules.php?name=Your_Account\">"._TUSERLOGIN."</a>";
} else {
$theuser = ""._THELLO." $username: <a href=\"modules.php?name=Your_Account&op=logout\">"._TLOGOUT."</a>";
}
include("themes/$NameOfTheme/navbar.php");
echo "\n";
echo "<center><table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\" align=\"center\"><tr bgcolor=\"$textcolor4\"><td align=\"center\">\n";
echo "<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\" align=\"center\">\n";
echo "<tr bgcolor=\"$bgcolor5\"><td width=\"10%\"><img src=\"themes/$NameOfTheme/images/logo.gif\" height=\"61\" width=\"468\" alt=\"\"._TWELCOMETO.\" $sitename\" border=\"0\"></td>\n";
echo "<td align=\"right\" width=\"90%\">$tbanners</td></tr>\n";
echo "</table>\n";
echo "<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\" align=\"center\">\n";
echo "<tr bgcolor=\"$textcolor1\"><td><IMG src=\"themes/$NameOfTheme/images/pixel.gif\" width=\"1\" height=\"1\" alt=\"\" border=\"0\" hspace=\"0\"></td></tr>\n";
echo "</table>\n";
echo "<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\" align=\"center\">\n";
echo "<tr bgcolor=\"$bgcolor6\" valign=\"middle\"><td align=\"center\" height=\"20\">";
$public_msg = public_message();
if ($public_msg > "") { echo "$public_msg"; } else { echo "$navbar[$nv]"; }
echo "</td></tr>\n";
echo "</table>\n";
echo "<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\" align=\"center\">\n";
echo "<tr bgcolor=\"$textcolor1\"><td><IMG src=\"themes/$NameOfTheme/images/pixel.gif\" width=\"1\" height=\"1\" alt=\"\" border=\"0\" hspace=\"0\"></td></tr>\n";
echo "</table>\n";
echo "<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\" align=\"center\">\n";
echo "<tr valign=\"middle\" bgcolor=\"$bgcolor5\">\n";
echo "<td width=\"20%\" nowrap><font class=\"content\" color=\"$textcolor1\">&nbsp;&nbsp;$theuser</font></td>\n";
echo "<td align=\"center\" height=\"20\" width=\"60%\"><font class=\"content\">$priv_msgs</font></td>\n";
echo "<td align=\"right\" width=\"20%\"><font class=\"content\">$members&nbsp;&nbsp;</font></td>\n";
echo "</tr>\n";
echo "</table>\n";
echo "<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\" align=\"center\">\n";
echo "<tr bgcolor=\"$textcolor1\"><td><IMG src=\"themes/$NameOfTheme/images/pixel.gif\" width=\"1\" height=\"1\" alt=\"\" border=\"0\" hspace=\"0\"></td></tr>\n";
echo "</table>\n";
echo "<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" align=\"center\">\n";
echo "<tr bgcolor=\"$textcolor4\"><td><img src=\"themes/$NameOfTheme/images/pixel.gif\" width=\"1\" height=\"20\" border=\"0\" alt=\"\"></td></tr>\n";
echo "</table>\n";
echo "<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" align=\"center\"><tr bgcolor=\"$textcolor4\" valign=\"top\">\n";
echo "<td bgcolor=\"$textcolor4\" width=\"180\" valign=\"top\">\n";
echo "\n";
blocks(left);
echo "\n";
echo "</td>\n";
echo "<td><img src=\"themes/$NameOfTheme/images/pixel.gif\" width=\"5\" height=\"1\" border=\"0\" alt=\"\"></td>\n";
echo "<td valign=\"top\" width=\"100%\">\n";
echo "\n";
}

/************************************************************/
/* Function themefooter() */
/************************************************************/

function themefooter() {
global $sitename, $nv, $copyright, $index, $foot1, $foot2, $foot3, $NameOfTheme, $bgcolor1, $bgcolor2, $bgcolor3, $bgcolor4, $bgcolor5, $bgcolor6, $bgcolor7, $textcolor1, $textcolor2, $textcolor3, $textcolor4;
include("themes/$NameOfTheme/navbar.php");
echo "\n";
echo "</td>\n";
echo "<td><img src=\"themes/$NameOfTheme/images/pixel.gif\" width=\"5\" height=\"1\" border=\"0\" alt=\"\"></td>\n";
echo "<td valign=\"top\" width=\"180\">\n";
echo "\n";
blocks(right);
$footer_message = "$foot1<br>$foot2<br>$foot3";
echo "\n";
echo "</td>\n";
echo "</tr></table>\n";
echo "<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\" align=\"center\">\n";
echo "<tr bgcolor=\"$textcolor1\"><td><IMG src=\"themes/$NameOfTheme/images/pixel.gif\" width=\"1\" height=\"1\" alt=\"\" border=\"0\" hspace=\"0\"></td></tr>\n";
echo "</table>\n";
echo "<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\" align=\"center\">\n";
echo "<tr valign=\"middle\" bgcolor=\"$bgcolor5\"><td align=\"center\" height=\"20\" width=\"60%\"><font class=\"content\">$copyright</font></td></tr>\n";
echo "</table>\n";
echo "<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\" align=\"center\">\n";
echo "<tr bgcolor=\"$textcolor1\"><td><IMG src=\"themes/$NameOfTheme/images/pixel.gif\" width=\"1\" height=\"1\" alt=\"\" border=\"0\" hspace=\"0\"></td></tr>\n";
echo "</table>\n";
echo "<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\" align=\"center\">\n";
echo "<tr bgcolor=\"$bgcolor6\" valign=\"middle\"><td align=\"center\" height=\"20\">$navbar[$nv]</td></tr>\n";
echo "</table>\n";
echo "<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\" align=\"center\">\n";
echo "<tr bgcolor=\"$textcolor1\"><td><IMG src=\"themes/$NameOfTheme/images/pixel.gif\" width=\"1\" height=\"1\" alt=\"\" border=\"0\" hspace=\"0\"></td></tr>\n";
echo "</table>\n";
echo "<table width=\"100%\" cellpadding=\"0\" cellspacing=\"0\" border=\"0\" align=\"center\">\n";
echo "<tr align=\"center\" bgcolor=\"$bgcolor5\"><td width=\"100%\">$footer_message</td></tr>\n";
echo "</table>\n";
echo "<table cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" border=\"0\" align=\"center\">\n";
echo "<tr bgcolor=\"$textcolor1\"><td><IMG src=\"themes/$NameOfTheme/images/pixel.gif\" width=\"1\" height=\"1\" alt=\"\" border=\"0\" hspace=\"0\"></td></tr>\n";
echo "</table>\n";
echo "</td></tr></table><br>$NameOfTheme "._TBY." <a href=\"http://www.nukescripts.net\" target=\"NSN\">NukeScripts Network</a></center>\n";
echo "\n";
}

/************************************************************/
/* Function themeindex() */
/************************************************************/

function themeindex ($aid, $informant, $time, $title, $counter, $topic, $thetext, $notes, $morelink, $topicname, $topicimage, $topictext) {
global $cookie, $loonr, $vasak, $parem, $kokku, $sid, $anonymous, $tipath, $NameOfTheme, $bgcolor1, $bgcolor2, $bgcolor3, $bgcolor4, $bgcolor5, $bgcolor6, $bgcolor7, $textcolor1, $textcolor2, $textcolor3, $textcolor4;
$loonr = ($loonr+1);
if (isset($cookie[3])) {
$storynum = $cookie[3];
} else {
$storynum = $storyhome;
}
$ridaaa1 = round($loonr/2);
if ($notes != "") {
$notes = "<br><br><b>"._TNOTE."</b> <i>$notes</i>\n";
} else {
$notes = "";
}
if ("$aid" == "$informant") {
$content = "$thetext$notes\n";
} else {
if($informant != "") {
$content = "<a href=\"modules.php?name=Your_Account&op=userinfo&amp;uname=$informant\">$informant</a> ";
} else {
$content = "$anonymous ";
}
$content .= ""._TWRITES." \"$thetext\"$notes\n";
}
$posted = ""._TPOSTEDBY." ";
$posted .= get_author($aid);
$posted .= " "._TON." $time $timezone ($counter "._TREADS.")";

if (($ridaaa1*2) != $loonr) {
$vasak .= "\n";
$vasak .= "<table border=\"0\" cellpadding=\"3\" cellspacing=\"1\" bgcolor=\"$bgcolor6\" width=\"100%\">\n";
$vasak .= "<tr bgcolor=\"$bgcolor2\"><td align=\"left\"><font class=\"option\" color=\"$textcolor1\"><b>$title</b></font></td></tr>\n";
$vasak .= "<tr bgcolor=\"$textcolor4\"><td align=\"left\"><font class=\"content\"><a href=\"modules.php?name=News&file=topics&op=newindex&topic=$topic\"><img src=\"$tipath$topicimage\" border=\"0\" Alt=\"$topictext\" align=\"right\" hspace=\"10\" vspace=\"10\"></a>$content</font></td></tr>\n";
$vasak .= "<tr bgcolor=\"$bgcolor1\"><td align=\"right\"><font class=\"content\">$posted</font><br>\n";
$vasak .= "<font class=\"content\">$morelink</font></td></tr>\n";
$vasak .= "</table><br>\n";
$vasak .= "\n";
} else {
$parem .= "\n";
$parem .= "<table border=\"0\" cellpadding=\"3\" cellspacing=\"1\" bgcolor=\"$bgcolor6\" width=\"100%\">\n";
$parem .= "<tr bgcolor=\"$bgcolor2\"><td align=\"left\"><font class=\"option\" color=\"$textcolor1\"><b>$title</b></font></td></tr>\n";
$parem .= "<tr bgcolor=\"$textcolor4\"><td align=\"left\"><font class=\"content\"><a href=\"modules.php?name=News&file=topics&op=newindex&topic=$topic\"><img src=\"$tipath$topicimage\" border=\"0\" Alt=\"$topictext\" align=\"right\" hspace=\"10\" vspace=\"10\"></a>$content</font></td></tr>\n";
$parem .= "<tr bgcolor=\"$bgcolor1\"><td align=\"right\"><font class=\"content\">$posted</font><br>\n";
$parem .= "<font class=\"content\">$morelink</font></td></tr>\n";
$parem .= "</table><br>\n";
$parem .= "\n";
}
if ($loonr == $storynum OR $loonr == $kokku) {
echo "<table width=\"100%\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tr>";
echo "<td width=\"49%\" valign=\"top\">$vasak</td>";
echo "<td width=\"2%\" valign=\"top\">&nbsp;</td>";
echo "<td width=\"49%\" valign=\"top\">$parem</td>";
echo "</tr></table>";
}

}

/************************************************************/
/* Function themearticle() */
/************************************************************/

function themearticle ($aid, $informant, $datetime, $title, $thetext, $topic, $topicname, $topicimage, $topictext) {
global $admin, $sid, $tipath, $NameOfTheme, $bgcolor1, $bgcolor2, $bgcolor3, $bgcolor4, $bgcolor5, $bgcolor6, $bgcolor7, $textcolor1, $textcolor2, $textcolor3, $textcolor4;
$posted = ""._TPOSTEDBY." ";
$posted .= get_author($aid);
$posted .= " "._TON." $time $timezone ($counter "._TREADS.")";
if (is_admin($admin)) {
$posted .= " [ <a href=\"admin.php?op=EditStory&amp;sid=$sid\">"._TEDIT."</a> | <a href=\"admin.php?op=RemoveStory&amp;sid=$sid\">"._TDELETE."</a> ]\n";
}
if ($notes != "") {
$notes = "<br><br><b>"._TNOTE."</b> <i>$notes</i>\n";
} else {
$notes = "";
}
if ("$aid" == "$informant") {
$content = "$thetext$notes\n";
} else {
if($informant != "") {
$content = "<a href=\"modules.php?name=Your_Account&op=userinfo&amp;uname=$informant\">$informant</a> ";
} else {
$content = "$anonymous ";
}
$content .= ""._TWRITES." \"$thetext\"$notes\n";
}
echo "\n";
echo "<table border=\"0\" cellpadding=\"3\" cellspacing=\"1\" bgcolor=\"$bgcolor6\" width=\"100%\">\n";
echo "<tr bgcolor=\"$bgcolor2\"><td align=\"left\"><font class=\"option\" color=\"$textcolor1\"><b>$title</b></font><br>\n";
echo "<font class=\"content\">$posted</font></td></tr>\n";
echo "<tr bgcolor=\"$textcolor4\"><td algin=\"left\"><font class=\"content\"><a href=\"modules.php?name=News&file=topics&op=newindex&topic=$topic\"><img src=\"$tipath$topicimage\" border=\"0\" Alt=\"$topictext\" align=\"right\" hspace=\"10\" vspace=\"10\"></a>$content</font></td></tr>\n";
echo "</table><br>\n";
echo "\n";
}

/************************************************************/
/* Function themesidebox() */
/************************************************************/

function themesidebox($title, $content) {
global $NameOfTheme, $bgcolor1, $bgcolor2, $bgcolor3, $bgcolor4, $bgcolor5, $bgcolor6, $bgcolor7, $textcolor1, $textcolor2, $textcolor3, $textcolor4;
echo "\n";
echo "<table border=\"0\" cellpadding=\"3\" cellspacing=\"1\" bgcolor=\"$bgcolor6\" width=\"180\">\n";
echo "<tr bgcolor=\"$bgcolor5\"><td align=\"center\"><font class=\"content\" color=\"$textcolor1\"><b>$title</b></font></td></tr>\n";
echo "<tr valign=\"top\" bgcolor=\"$textcolor4\"><td>$content</td></tr>\n";
echo "</table><br>\n";
echo "\n";
}

?>

vibz · Investigator Offline Joined: May 20, 2004 Posts: 5

Webmaster wrote:

bitte noch info über benutzte cpg version?

Hi, meine Benutzte cpg version ist die 8.1

ich versuch mal das in der datenbank zu ändern.

Müsste ja über phpMyAdmin gehen oder?

gruss
vibz

vibz · Investigator Offline Joined: May 20, 2004 Posts: 5

oh nööööö,

ich hab da überhaupt keinen Plan.

Sag mir doch bitte genau wie das ändern in PhpMyAdmin funktioniert.

danke

Ertan · Posted: 24.05.2004 13:17 Post subject: Re: ERROR bei our_sponsors

wenn du phpmyadmin schon installiert und eingestellt hast

einfach oben "sql" anklicken
dann in textfeld

ALTER TABLE cms_banner DROP text_url;

eingeben und auf o.k.

das wars Wink

vibz · Investigator Offline Joined: May 20, 2004 Posts: 5

wenn ich das eingebe kommt der folgende fehler:

Fehler

SQL-Befehl :

SELECT *
FROM `cms_banner`
WHERE 1
ALTER TABLE cms_banner DROP text_url LIMIT 0 ,
30

MySQL meldet:

You have an error in your SQL syntax near 'ALTER TABLE cms_banner DROP text_url LIMIT 0, 30' at line 1
Zurück

vibz · Investigator Offline Joined: May 20, 2004 Posts: 5

ok ich hab den fehler gefunden ich hab nach der ersten zeile kein ; eingefügt.

juhuuu es klappt

herzliches dankeschön Very Happy