skypanther
Exalted Code Master!
A client's site is acting all funky and I don't see what's causing the error. Perhaps you can give me your thoughts on how to troubleshoot it? Check out:
http://renewableenergylongisland.org/pressRelease.cfm
Click the first press release entry and you get an empty page. Click on the second one and you get data. Both use the same code and simply pull data from a mysql database. So, I know the CF code is working.
I can use phpmyadmin and look at my database, and there's data in all the records. It's as if the query is retrieving an empty record but it's a bit weirder than that.
I created a test version of the page that outputs the db query as well as the number of records returned. For records IDs that I know exist and that I know have data in them, I get "Records retrieved: 0" from my test code.
http://renewableenergylongisland.org/test_pr.cfm?releaseID=65
I have the query wrapped in a <cftry> block yet the <cfcatch type="database"> and "<cfcatch type="any"> blocks aren't getting called.
I don't do a whole lot of CF anymore (I mostly do PHP) so I'm really rusty. What are some debugging methods I can use to figure out what's causing this?
Thanks,
Tim
PS - This is a site, that until this past weekend, was hosted elsewhere. I just moved it here. It was working fine there. I exported my DB from the other host and imported it here (a couple of times now). Since most of the pages work and just a few database-related issues like this are coming up, I don't think it's a major imcompatibility between environments.
http://renewableenergylongisland.org/pressRelease.cfm
Click the first press release entry and you get an empty page. Click on the second one and you get data. Both use the same code and simply pull data from a mysql database. So, I know the CF code is working.
I can use phpmyadmin and look at my database, and there's data in all the records. It's as if the query is retrieving an empty record but it's a bit weirder than that.
I created a test version of the page that outputs the db query as well as the number of records returned. For records IDs that I know exist and that I know have data in them, I get "Records retrieved: 0" from my test code.
http://renewableenergylongisland.org/test_pr.cfm?releaseID=65
I have the query wrapped in a <cftry> block yet the <cfcatch type="database"> and "<cfcatch type="any"> blocks aren't getting called.
I don't do a whole lot of CF anymore (I mostly do PHP) so I'm really rusty. What are some debugging methods I can use to figure out what's causing this?
Thanks,
Tim
PS - This is a site, that until this past weekend, was hosted elsewhere. I just moved it here. It was working fine there. I exported my DB from the other host and imported it here (a couple of times now). Since most of the pages work and just a few database-related issues like this are coming up, I don't think it's a major imcompatibility between environments.