product detail page not working

Hey Ray

Have got a site on the dev server thats been worked on for a LONG time and with the migration from the old host to the new, the product detail page is now not returning any data.

I initially thought it was in the mod rewrite but the page in the PM is itself mod rewritten so it cant be that. All the other pages are working as expected, just this one.

Wouold really appreciate any thoughts or advice please?

Thanks

Jamie

I'll need FTP access to debug this. I don't see what the issue is. Have you tried adding this to the body:

<?php

var_dump($_GET);

echo($PageContents->debugSQL()); 

echo("<br>");

echo($Categories->debugSQL());

?>

I'd probably start with that to see if I could see what is wrong in the SQL statement. It appears no results are being returned to the recordsets.

Thanks Ray...have added the debug to the body and have attached the site def file

Cheers

Jamie

You don't appear to be using the PageContents recordset on this page... I'm not sure if it is needed, but it was filtered by the "perm" URL parameter, but I think it is supposed to be filtered with the "sub" parameter.

The Categories recordset used an INNER JOIN for getting the parent category, which caused it to not show a result if it has no parent category, like this one. The solution was to change it to use a LEFT OUTER JOIN instead.

The page appears to be working now.

thanks mate. appreciate the help as always

This post has been deleted.