Topic: Weird issue with PHP / PHP Classifieds
Hi -
I'm facing a weird issue with PHP Classifieds and can't find what I missed...
I'm moving PHP Classifieds 7.5:
-> from a Linux box running Apache 2.2.4, PHP 5.2.3 and MySQL 5.0.45
-> to a Sun Solaris box running Sun Java Web Server 7.0, PHP 5.2.13 and MySQL 5.1.40
I just did a backup/restore of the MySQL database, took the whole PHP Classifieds files tree, changed the url and the path in /admin/config/gen_inc.php. Files permissions and php.ini are similar and I have several PHP apps running flawlessly on the same machine. I cross checked everything and didn't find anything abnormal.
Now, when try to access to PHP Classified, I get a broken PHP page like:
SECURITY WARNING
You have not followed our instructions to delete install.php immediately after install. Leaving this file here is a major security problem and opens your site up to wild hacking.
"; } print '
'; // If we are on the frontpage, write out welcome message along with flags if ($catid==0 AND !$special_mode) { echo "
$name_of_site
"; echo formatString($welcome_message, array("$name_of_site")); include "templates/flags_frontpage.html"; ?>
"; // Print out categories include("catcol.php"); // This is the column containing special ads if (!empty($set_special) AND !isset($_REQUEST["catid"])) { print " "; include "special.php"; print "
"; } // Print out ad-listings include("links.php"); // Counter (if activated from admin area) $frontpage=1; if (isset($set_count_dynamic)) { $str = ""; if (isset($validation)) { if ($validation<>"") $str = " where valid=1"; } $row = mysql_fetch_array(mysql_query("select count(ad_username) from $ads_tbl $str")); $upd_ads = $row["count(ad_username)"]; $row = mysql_fetch_array(mysql_query("select count(email) from $usr_tbl")); $upd_users = $row["count(email)"]; $row = mysql_fetch_array(mysql_query("select sum(sitehits) from $ads_tbl $str")); $upd_sitehits = $row["sum(sitehits)"]; if (!$upd_sitehits) $upd_sitehits = 0; $la_s_bar = formatString($la_s_bar, array("$upd_users","$upd_ads","$upd_sitehits")); $show_bar = 1; } print "\n"; print ""; include_once("footer_inc.php"); ?>or:
SECURITY WARNING
You have not followed our instructions to delete install.php immediately after install. Leaving this file here is a major security problem and opens your site up to wild hacking.
"; } } /* while ($lCatCounter<100) { $lCatFatherId=1; $lCatAllowAds='on'; $lCatName="testcat_" . $lCatCounter; $lCatDescription=""; $sql="insert into $cat_tbl (cat_name,cat_description,cat_allow_ads,cat_fatherid) values ("; $sql.="'$lCatName', '$lCatDescription','$lCatAllowAds',$lCatFatherId)"; $res=q($sql); $id=mysql_insert_id(); $lCatCounter++; } */ // If we are on the frontpage, write out welcome message along with flags $tplIndex=new TplLoad; $tplIndex->assign("catname","$lCatName"); $val_string = ""; $tplIndex->assign("index_catid",$catid); $tplIndex->assign("banner",$lBanner); $tplIndex->assign("isFrontpage","$fp"); if ($fp && !$set_latest_fp) $tplIndex->assign("HideLastListFp","1"); $tplIndex->assign("index_nameofsite",$set_sitename); $tplIndex->assign("index_welcome",formatString(WELCOME_MESSAGE, array("$set_sitename"))); $tplIndex->assign("index_welcome_1",formatString(LA_WELCOME_1, array("$set_sitename"))); $tplIndex->assign("index_welcome_2",formatString(LA_WELCOME_2, array("$set_sitename"))); $tplIndex->assign("index_welcome_91",formatString(LA_WELCOME_LOGGED_1, array($_SESSION['user_name']))); $tplIndex->assign("index_welcome_92",formatString(LA_WELCOME_LOGGED_2, array($_SESSION['user_name']))); $tplIndex->assign("member",$_SESSION["valid_user"]); $tplIndex->assign("premium_picture",$set_premium_picture); $tplIndex->assign("set_special",$set_special); $tplIndex->assign("premium_picture",$set_premium_picture); $tplIndex->assign("set_special",$set_special); if ($set_special) { $limit=$set_premium_limit; $sql_str = "select ad_title, ad_id from $ads_tbl where ad_is_premium=1 "; if ($catid AND $set_special_categories) $sql_str.=" AND ad_cat_id=$catid"; if ($set_special_only_frontpage AND $catid) $sql_str.=" AND 2<1"; $sql_str.=" $val_string order by ad_id desc limit $limit"; $res_sp = q($sql_str); $sp_i=0; while ($row_sp=mysql_fetch_array($res_sp)) { $s_title = $row_sp["ad_title"]; $s_id = $row_sp["ad_id"]; $lSpecialAds[$sp_i]["s_title"]=dotString($s_title,$set_special_string_length); $lSpecialAds[$sp_i]["s_id"]=$s_id; $lSpecialAds[$sp_i]["s_link"]=linkDetail($s_id); $sp_i++; } $tplIndex->assign("special_list",$lSpecialAds); if ($sp_i==0) $tplIndex->assign("size","100"); else $tplIndex->assign("size","70"); } else { $tplIndex->assign("size","100"); } $tplIndex->display("index.tpl"); include_once("footer_inc.php"); ?>Of course, the install.php file doesn't exist.
It's just like if the paths couldn't be read.
Any hint would be greatly appreciated!
Thanks,
Georges
