Dragonfly CMS - German Community

vibz · Investigator Offline Dabei seit: Mai 20, 2004 Beiträge: 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 · Verfasst am: 21.05.2004 02:39 Titel: Re: ERROR bei our_sponsors

bitte noch info über benutzte cpg version?

Ertan · Verfasst am: 21.05.2004 15:29 Titel: 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 · Verfasst am: 21.05.2004 16:23 Titel: Re: ERROR bei our_sponsors

und wie ändere ich das in der Datenbank

spoddig · Verfasst am: 21.05.2004 21:23 Titel: Re: ERROR bei our_sponsors

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 · Verfasst am: 21.05.2004 23:42 Titel: Re: ERROR bei our_sponsors

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 · Verfasst am: 22.05.2004 16:59 Titel: Re: ERROR bei our_sponsors

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 Dabei seit: Mai 20, 2004 Beiträge: 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 Dabei seit: Mai 20, 2004 Beiträge: 5

oh nööööö,

ich hab da überhaupt keinen Plan.

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

danke

Ertan · Verfasst am: 24.05.2004 13:17 Titel: 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 zwinker

vibz · Investigator Offline Dabei seit: Mai 20, 2004 Beiträge: 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 Dabei seit: Mai 20, 2004 Beiträge: 5

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

juhuuu es klappt

herzliches dankeschön sehr glücklich