close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

product detail page not working

Thread began 4/24/2019 9:23 am by Jamie | Last modified 4/25/2019 10:05 am by Ray Borduin | 40 views | 4 replies |

Jamie

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

Sign in to reply to this post

Ray BorduinWebAssist

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:
<?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.

Sign in to reply to this post

Jamie

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

Cheers

Jamie

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

Jamie

thanks mate. appreciate the help as always

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...