hi there i download "cdbase v1.3" that optikool has modfied it, and submit it in his site www.optikool.com
when i submit a new artist i have that message
Quote:
i edit the sql line field "art_id" to int(8)
but it still to give me the error message
and that the php code at admin submit page
if ($op == "addcatgo") {
// agregar artist
$myts =& MyTextSanitizer::getInstance();
$newid = $xoopsDB->genId($xoopsDB->prefix("cdbase_artists")."_id_art_seq");
$dateadd = time();
$sql = "INSERT INTO ".$xoopsDB->prefix("cdbase_artists").
" (id_art, artist, image, image_border, bio, date_of_birth, place_of_birth, ethnic, dateadd, genre, url, url_target, similar, gallery, gallery_desc, gallery_target, movies, movies_desc, movies_target, dropcap)
VALUES (".$newid.", '".$artist."', '".$image."', '".$image_border."', '".$bio."', '".$date_of_birth."', '".$place_of_birth."', '".$ethnic."', ".$dateadd.", '".$genre."', '".$url."', '".$url_target."','".$similar."', '".$gallery."', '".$gallery_desc."', '".$gallery_target."', '".$movies."', '".$movies_desc."', '".$movies_target."', '".$dropcap."')";
if (!$xoopsDB->query($sql)) {
xoops_cp_header();
echo "Could not add category";
xoops_cp_footer();
} else {
//notification new artist
$extra_tags = array();
$extra_tags['ARTIST_URL'] = XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/index.php?id_art=' . $id_art;
$extra_tags['ARTIST_NAME'] = $artist;
$notification_handler =& xoops_gethandler("notification");
$notification_handler->triggerEvent ("global", $id_art, "new_artist", $extra_tags=array());
redirect_header("index.php?op=listcat",1,_XD_DBSUCCESS);
}
exit();
}
i ask optikool to see that eroor, and modfied it
thank you
