[Base4]

Originally Posted by omegatron

Again as I have stated in another thread you need to run any necessary upgrades.

...but I thought I have just run the upgrades...(see last post) is there something I am missing?

The site (www.base4gardening.com) worked to some extent (not how we wanted) before I ran the upgrades now after running the upgrade script it is in the same state as (www.base4art.com)

Originally Posted by omegatron

Your other install you had not ran the upgrade script which caused you issues...

I ran the same upgrade procedure (see last post) on this www.base4art.com (2 weeks ago) as I just have on www.base4gardening.com - except base4art was upgraded in several parts i.e 5.03 --> 5.1 --> 5.11 - these were done via upgrade script using the 5.12 zipped files. So 5.12? --> 5.13 was done by just uploading the necessary (5.13 zipped) files as per michael's post for upgrading.

Originally Posted by omegatron

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 );

I have just run your query but it seems to throw a syntax error. Possible missing curly brace? Forgive my ignorance I do not know much SQL.

Thanks

Jon