Ho trovato una soluzione bisogna cancellare questo codice dal file productbook.php
$database->setQuery( "SELECT *, a.id, "
. " a.catid, "
. " a.imgtitle, "
. " a.imgauthor, "
. " a.imgtext, "
. " a.imgdate, "
. " a.imgcounter, "
. " a.imgvotes, "
. " a.imgvotesum, "
. " a.published, "
. " a.imgoriginalname, "
. " a.imgfilename, "
. " a.imgthumbname, "
. " a.owner, u.id "
. " FROM #__productbook as a "
. " \n left join #__users as u on u.username = a.owner "
. " \n WHERE a.id= '$id' "
. " AND a.approved=1 ");
$result1 = $database->query();
if (count($database->loadObjectList()) < 1) {
mosRedirect(sefRelToAbs("index.php?option=com_productbook&func=userpannel&Itemid=$Itemid"), $PRODUBK->PRODUBK_0026 );
}
list($id, $catid, $imgtitle, $imgauthor, $imgtext, $descr, $note, $imgdate, $imgcounter, $imgvotes, $imgvotesum,
$published, $imgoriginalname, $imgfilename, $imgthumbname, $pricing, $netpricing, $persone, $diff, $stock, $calorie,
$specification01, $specvalue01, $specification02, $specvalue02, $specification03, $specvalue03,
$specification04, $specvalue04, $specification05, $specvalue05, $specification06, $specvalue06,
$specification07, $specvalue07, $specification08, $specvalue08, $specification09, $specvalue09,
$specification10, $specvalue10, $specification11, $specvalue11, $specification12, $specvalue12,
$specification13, $specvalue13, $specification14, $specvalue14, $checked_out, $imgowner, $imgownerid ) = mysql_fetch_row($result1);
e sostituirlo con questo
$database->setQuery( "SELECT a.* FROM #__productbook as a left join #__users as u on u.username = a.owner WHERE a.id= '$id' AND a.approved=1 ");
$res = $database->loadObject($var);
if (!$res) {
mosRedirect(sefRelToAbs("index.php?option=com_productbook&func=userpannel&Itemid=$Itemid"), $PRODUBK->PRODUBK_0026 );
}
foreach ($var as $key => $val) {
${$key} = $val;
}
non so se sbaglio, ma joom!fish non funziona con gli array (es.loadRow), solo con gli oggetti (es.loadObject). Se dico una cavolata abbiate pazienza.
Credo che il problema delle sottocategorie lo stesso.
Grazie Ciao Davide