hi there i download "cdbase v1.3" that optikool has modfied it, and submit it in his site
http://www.optikool.comwhen 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
le="color: #000000"><?php 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
