|
Again as I have stated in another thread you need to run any necessary upgrades. Your other install you had not ran the upgrade script which caused you issues. This is the query and you are missing something so run the query in phpmyadmin to see what your missing and then run the necessary upgrade
if ( is_numeric($cat) ) {
$query = "SELECT c.id,c.catname,c.thumbs,c.cattype,c.parent,c.theme,
c.sortorder,c.frames,c.intro,c.introtitle,c.introcopy,c.ratingtype,c.takevotes,c.ismember,n.userid
FROM {$Globals['pp_db_prefix']}categories c
LEFT JOIN {$Globals['pp_db_prefix']}notify n ON (n.userid={$User['userid']} AND n.photo=c.id AND n.type=1)
WHERE c.id=$cat";
$ctitleq = ppmysql_query($query, $link);
list( $thecatid, $thecatname, $catthumbs, $cattype, $catparent, $cattheme, $catsortorder, $frames, $hasintro, $introtitle, $introcopy, $ratingtype, $takevotes, $ismember, $notify ) = mysql_fetch_row($ctitleq);
ppmysql_free_result( $ctitleq );
|