3.05 after upgrade MySql Error

[Guest]

Hello people i`ve upgraded to 3.05 but i have a problem.. My shop: http://www.klassiekegeuren.nl/parfums/

I`ve i click on a categorie where the products are listed i get the following error code:

/* +-------------------------------------------------------------------------- | CubeCart v3.0.3 | ======================================== | by Alistair Brookbanks | CubeCart is a Trade Mark of Devellion Limited | © 2005 Devellion Limited | Devellion Limited, | Westfield Lodge, | Westland Green, | Little Hadham, | Nr Ware, HERTS. | SG11 2AL | UNITED KINGDOM | http://www.devellion.com | UK Private Limited Company No. 5323904 | ======================================== | Web: http://www.cubecart.com | Date: Thursday, 22 September 2005 | Email: info (at) cubecart (dot) com | License Type: CubeCart is NOT Open Source Software and Limitations Apply | Licence Info: http://www.cubecart.com/site/faq/license.php +-------------------------------------------------------------------------- | viewCat.inc.php | ======================================== | Display the Current Category +-------------------------------------------------------------------------- */ if(!isset($config)){ echo "\r\n\r\n\r\n\r\n

Forbidden 403

\r\nThe document you are requesting is forbidden.\r\n\r\n"; exit; } if(isset($_GET['page'])){ $page = $_GET['page']; } else { $page = 0; } $view_cat = new XTemplate ("skins/".$config['skinDir']."/styleTemplates/content/viewCat.tpl"); //////////////////////// // BUILD SUB CATEGORIES //////// if(isset($_GET['catId'])) { // build query $query = "SELECT * FROM ".$glob['dbprefix']."CubeCart_category WHERE cat_father_id = ".$db->mySQLSafe($_GET['catId'])." ORDER BY cat_name ASC"; // get category array in foreign innit $resultsForeign = $db->select("SELECT cat_master_id as cat_id, cat_name FROM ".$glob['dbprefix']."CubeCart_cats_lang WHERE cat_lang = '".$lang_folder."'"); // query database $subCategories = ""; $subCategories = $db->select($query); } if(isset($_GET['catId']) && $_GET['catId']>0 && $subCategories == TRUE) { // loop results for ($i=0; $iassign("IMG_CATEGORY",$GLOBALS['rootRel']."skins/".$config['skinDir']."/styleImages/catnophoto.gif"); } else { $view_cat->assign("IMG_CATEGORY",$GLOBALS['rootRel']."images/uploads/".$subCategories[$i]['cat_image']); } $view_cat->assign("TXT_LINK_CATID",$subCategories[$i]['cat_id']); $view_cat->assign("TXT_CATEGORY", $subCategories[$i]['cat_name']); $view_cat->assign("NO_PRODUCTS", $subCategories[$i]['noProducts']); $view_cat->parse("view_cat.sub_cats.sub_cats_loop"); } // end loop results $view_cat->parse("view_cat.sub_cats"); } // end $subCategories == TRUE //////////////////////////// // BUILD PRODUCTS /////////// // build query if(isset($_GET['searchStr'])){ $searchwords = split ( "[ ,]", treatGet($_GET['searchStr'])); foreach($searchwords as $word){ $searchArray[]=$word; } $noKeys = count($searchArray); $like = ""; for ($i=0; $i<$noKeys;$i++) { $ucSearchTerm = strtoupper($searchArray[$i]); if(($ucSearchTerm!=="AND") && ($ucSearchTerm!=="OR")){ $like .= "(name LIKE '%".$searchArray[$i]."%' OR description LIKE '%".$searchArray[$i]."%' OR productCode LIKE '%".$searchArray[$i]."%') OR "; // see if search terrm is in database $searchQuery = "SELECT id FROM ".$glob['dbprefix']."CubeCart_search WHERE searchstr='".$ucSearchTerm."'"; $searchLogs = $db->select($searchQuery); $insertStr['searchstr'] = $db->mySQLsafe($ucSearchTerm); $insertStr['hits'] = $db->mySQLsafe(1); $updateStr['hits'] = "hits+1"; if($searchLogs == TRUE) { $db->update($glob['dbprefix']."CubeCart_search",$updateStr,"id=".$searchLogs[0]['id'],$quote = ""); } elseif(!empty($_GET['searchStr'])) { $db->insert($glob['dbprefix']."CubeCart_search",$insertStr); } } else { $like = substr($like,0,strlen($like)-3); $like .= $ucSearchTerm; } } $like = substr($like,0,strlen($like)-3); $productListQuery = "SELECT * FROM ".$glob['dbprefix']."CubeCart_inventory WHERE ".$like; } elseif($_GET['catId']=="saleItems" && $config['saleMode']>0) { $productListQuery = "SELECT ".$glob['dbprefix']."CubeCart_cats_idx.cat_id, ".$glob['dbprefix']."CubeCart_cats_idx.productId, productCode, quantity, description, image, price, name, popularity, sale_price, stock_level, useStockLevel FROM ".$glob['dbprefix']."CubeCart_cats_idx INNER JOIN ".$glob['dbprefix']."CubeCart_inventory ON ".$glob['dbprefix']."CubeCart_cats_idx.productId = ".$glob['dbprefix']."CubeCart_inventory.productId WHERE sale_price > 0 GROUP BY ".$glob['dbprefix']."CubeCart_inventory.productId"; } else { $productListQuery = "SELECT ".$glob['dbprefix']."CubeCart_cats_idx.cat_id, ".$glob['dbprefix']."CubeCart_cats_idx.productId, productCode, quantity, description, image, price, name, popularity, sale_price, stock_level, useStockLevel FROM ".$glob['dbprefix']."CubeCart_cats_idx INNER JOIN ".$glob['dbprefix']."CubeCart_inventory ON ".$glob['dbprefix']."CubeCart_cats_idx.productId = ".$glob['dbprefix']."CubeCart_inventory.productId WHERE ".$glob['dbprefix']."CubeCart_cats_idx.cat_id = ".$db->mySQLSafe($_GET['catId']); } $productResults = $db->select($productListQuery, $config['productPages'], $page); // get different languages if($productResults == TRUE && $lang_folder !== $config['defaultLang']){ for($i=0;$inumrows($productListQuery); // get current category info if(isset($_GET['catId']) && $_GET['catId']>0){ $currentCatQuery = "SELECT cat_name, cat_father_id, cat_id, cat_image FROM ".$glob['dbprefix']."CubeCart_category WHERE cat_id = ".$db->mySQLSafe($_GET['catId']); $currentCat = $db->select($currentCatQuery); $resultForeign = $db->select("SELECT cat_master_id as cat_id, cat_name FROM ".$glob['dbprefix']."CubeCart_cats_lang WHERE cat_lang = '".$lang_folder."' AND cat_master_id = ".$db->mySQLSafe($_GET['catId'])); if($resultForeign == TRUE){ $currentCat[0]['cat_name'] = $resultForeign[0]['cat_name']; } } if(!empty($currentCat[0]['cat_image'])) { $view_cat->assign("IMG_CURENT_CATEGORY","images/uploads/".$currentCat[0]['cat_image']); $view_cat->assign("TXT_CURENT_CATEGORY",$currentCat[0]['cat_name']); $view_cat->parse("view_cat.cat_img"); } if(isset($_GET['searchStr'])){ $view_cat->assign("TXT_CAT_TITLE",$lang['front']['viewCat']['search_results']); } elseif($_GET['catId']=="saleItems" && $config['saleMode']>0) { $view_cat->assign("TXT_CAT_TITLE",$lang['front']['viewCat']['sale_items']); } else { $view_cat->assign("TXT_CAT_TITLE",$currentCat[0]['cat_name']); } $view_cat->assign("LANG_IMAGE",$lang['front']['viewCat']['image']); $view_cat->assign("LANG_DESC",$lang['front']['viewCat']['description']); $view_cat->assign("LANG_PRICE",$lang['front']['viewCat']['price']); $view_cat->assign("PAGINATION",$db->paginate($totalNoProducts, $config['productPages'], $page, "page")); // repeated region if($productResults == TRUE){ if($_GET['catId']>0){ $view_cat->assign("LANG_CURRENT_DIR",$lang['front']['viewCat']['products_in']); $view_cat->assign("CURRENT_DIR",getCatDir($currentCat[0]['cat_name'],$currentCat[0]['cat_father_id'], $currentCat[0]['cat_id'], $link=TRUE)); } for ($i=0; $iassign("CLASS",cellColor($i, $tdEven="tdEven", $tdOdd="tdOdd")); if(file_exists($GLOBALS['rootDir']."/images/uploads/thumbs/thumb_".$productResults[$i]['image'])){ $view_cat->assign("SRC_PROD_THUMB",$GLOBALS['rootRel']."images/uploads/thumbs/thumb_".$productResults[$i]['image']); } else { $view_cat->assign("SRC_PROD_THUMB",$GLOBALS['rootRel']."skins/".$config['skinDir']."/styleImages/thumb_nophoto.gif"); } $view_cat->assign("TXT_TITLE",$productResults[$i]['name']); $view_cat->assign("TXT_DESC",substr(strip_tags($productResults[$i]['description']),0,$config['productPrecis'])."…"); if(salePrice($productResults[$i]['price'], $productResults[$i]['sale_price'])==FALSE){ $view_cat->assign("TXT_PRICE",priceFormat($productResults[$i]['price'])); } else { $view_cat->assign("TXT_PRICE","".priceFormat($productResults[$i]['price']).""); } $salePrice = salePrice($productResults[$i]['price'], $productResults[$i]['sale_price']); $view_cat->assign("TXT_SALE_PRICE", priceFormat($salePrice)); if(isset($_GET['add']) && isset($_GET['quan'])){ $view_cat->assign("CURRENT_URL",str_replace(array("&add=".$_GET['add'],"&quan=".$_GET['quan']),"",currentPage())); } else { $view_cat->assign("CURRENT_URL",currentPage()); } if($config['outofstockPurchase']==1){ $view_cat->assign("BTN_BUY",$lang['front']['viewCat']['buy']); $view_cat->assign("PRODUCT_ID",$productResults[$i]['productId']); $view_cat->parse("view_cat.productTable.products.buy_btn"); } elseif($productResults[$i]['useStockLevel']==1 && $productResults[$i]['stock_level']>0){ $view_cat->assign("BTN_BUY",$lang['front']['viewCat']['buy']); $view_cat->assign("PRODUCT_ID",$productResults[$i]['productId']); $view_cat->parse("view_cat.productTable.products.buy_btn"); } elseif($productResults[$i]['useStockLevel']==0){ $view_cat->assign("BTN_BUY",$lang['front']['viewCat']['buy']); $view_cat->assign("PRODUCT_ID",$productResults[$i]['productId']); $view_cat->parse("view_cat.productTable.products.buy_btn"); } $view_cat->assign("BTN_MORE",$lang['front']['viewCat']['more']); $view_cat->assign("PRODUCT_ID",$productResults[$i]['productId']); if($productResults[$i]['stock_level']<1 && $productResults[$i]['useStockLevel']==1 && $productResults[$i]['digital']==0){ $view_cat->assign("TXT_OUTOFSTOCK",$lang['front']['viewCat']['out_of_stock']); } else { $view_cat->assign("TXT_OUTOFSTOCK",""); } $view_cat->parse("view_cat.productTable.products"); } $view_cat->parse("view_cat.productTable"); } elseif(isset($_GET['searchStr'])) { $view_cat->assign("TXT_NO_PRODUCTS",$lang['front']['viewCat']['no_products_match']." ".treatGet($_GET['searchStr'])); $view_cat->parse("view_cat.noProducts"); } else { $view_cat->assign("TXT_NO_PRODUCTS",$lang['front']['viewCat']['no_prods_in_cat']); $view_cat->parse("view_cat.noProducts"); } $view_cat->parse("view_cat"); $page_content = $view_cat->text("view_cat"); ?>

Can somebody help me out?

[Guest]

Forbidden it says?

How`s possible?

[convict]

This is source code, not -=Forbidden it says=- . Open includes/viewCat.inc.php ... and have look at the first line <?php is missing!

EDIT> I dont know, what is the reason, may be causal key stroke DEL by editing. Just put it onto right place (PHP start mark). I suppose all will be fine.

[Guest]

Thank you very very much!!!

Greets,

Hugo