2.9 Upgrade Today - Error Follows

[MRaburn]

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script: showproduct

Query: SELECT catname,template,extra1,extra2,extra3,extra4,extra5,extra6 FROM categories where id='9'

Result: Unknown column 'extra1' in 'field list'

Database handle: Resource id #8

[MRaburn]

Also at the bottom of showcat.php I have this text at the VERY bottom.

SELECT id,user,userid,cat,date,title,description,keywords,bigimage,views,approved,rating,manu,numreviews FROM products WHERE approved='1' AND cat='9' AND cat='9' ORDER BY disporder,manu

[MRaburn]

Well I have looked at the code in the latest showproduct.php.

It Reads:

$query = "SELECT catname,,extra1,extra2,extra3,extra4,extra5,extra6template FROM {$Globals['pp_db_prefix']}categories where id='$cat'";
$resulta = ppmysql_query($query,$link);
list( $thecatname, $template, $Globals['extra1name'], $Globals['extra2name'], $Globals['extra3name'], $Globals['extra4name'], $Globals['extra5name'], $Globals['extra6name'] ) = mysql_fetch_row($resulta);
ppmysql_free_result($resulta);

Which is strange since this is a call to the Categories table and those extra fields do not exist as well as a call to pp prefix which should probably read rp.

I have take out the extra field names from the query and it is currently working.

Might want to take a look at that.

Mike

[MRaburn]

So far so good but at the end of showcat.php after the html close tag I get this.

</html>SELECT id,user,userid,cat,date,title,description,keywords,bigimage,views,approved,rating,manu,numreviews FROM products WHERE approved='1' AND cat='8' AND cat='8' ORDER BY disporder,manu

[Chuck S]

at the bottom of showcat.php remove

echo "$query";

In showproduct.php the query should read like this

$query = "SELECT catname,template FROM {$Globals['pp_db_prefix']}categories where id='$cat'";
$resulta = ppmysql_query($query,$link);
list( $thecatname, $template ) = mysql_fetch_row($resulta);
ppmysql_free_result($resulta);

the extra fields where not moved in 2.9 yet