Ask a Question related to Coldfusion - Getting Started, Design and Development.
-
Vampyr_Bytes #1
HTTP 500 - Internal Server Error
Hi.
I'm getting an Internal Server Error on the following page
All other pages on the site are working fine
any and all help will be appreciated
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<cfquery Name="Iteminfo" datasource="Products">
SELECT ItemName, Image, ItemInfo, Price
FROM tblItems
WHERE tblItems.ItemCode = <cfqueryparam value="#url.id#"
cfsqltype="cf_sql_integer">
</cfquery>
<cfquery name="Warnings" datasource="Products">
SELECT WarningInfo
FROM tblWarnings, tblWarningLink, tblItems
WHERE tblWarnings.WarningCode = tblWarningLink.WarningCode
AND tblItems.ItemCode = tblWarningLink.ItemCode
AND tblItems.ItemCode = <cfqueryparam value="#url.id#"
cfsqltype="cf_sql_integer">
</cfquery>
<cfquery name="Properties" datasource="Products">
SELECT Property
FROM tblProperties, tblPropLink, tblItems
WHERE tblItems.ItemCode = tblPropLink.ItemCode
AND tblPropLink.Propcode = tblProperties.Propcode
AND tblItems.ItemCode = <cfqueryparam value="#url.id#"
cfsqltype="cf_sql_integer">
</cfquery>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Item Description</title>
</head>
<body>
<table width="772" border="0">
<tr>
<td width="180">
<cfoutput>
<cfif display.Image is "">
<img src="images/thumbnailnopic.jpg" width="100" height="100"><br>
<cfelse>
<img src="images/#ItemInfo.image#" width="100" height="100"><br>
</cfif>
</td>
<td width="607">
<H3 align="center">#ItemInfo.ItemName#</H3>
Product Description - #ItemInfo.ItemInfo#<br><br>
<cfif Properties.recordcount is not 0>
<H4 align="center">Properties</H4>
<cfoutput query="Properties">
#Properties.property#
<cfif Properties.currentrow lt Properties.Recordcount>
,
</cfif>
</cfoutput>
</cfif>
<cfif Warnings.recordcount is not 0>
<h5 align="center">Warnings</h5>
<cfoutput query="Warnings">
#Warnings.warninginfo#<br>
</cfoutput>
</cfif>
</td>
</tr>
</cfoutput>
</table>
</body>
</body>
</html>
Vampyr_Bytes Guest
-
HTTP/1.1 500 Internal Server Error
Hi When I try to create ASP.NET Web Application I get error :HTTP/1.1 500 Internal Server Error I tried aspnet_regiis -i it doesnt work. What... -
HTTP 500 Internal Server Error
Uncheck "Show Friendly HTTP Errors" in IE. Reload the page. Post the complete error message that you now see. Cheers Ken "Darin"... -
HTTP 500 - Internal server error ASP pages
HTTP 500 - Internal server error ASP pages I am running Windows 2K with IIS 5.1 and I started having problems accessing ASP databases shortly... -
'HTTP/1.1 500 Internal Server Error'
Hi, i try to create a web-project with vstudio 2003. I am unable to create a new project. The following error occurs: 'HTTP/1.1 500 Internal... -
HTTP 500--Internal Server Error
you are not providing any kind of detail where anyone could help you. "http 500--internal server error" just means there was an error if you... -
mxstu #2 Re: HTTP 500 - Internal Server Error
If you are using Internet Explorer, try turning off the "friendly" error messages to get the real error
Tools-->InternetOptions-->Advanced-->Show friendly HTTP error messages (Uncheck this)
mxstu Guest
-
BKBK #3 Re: HTTP 500 - Internal Server Error
I, too, cannot see where the gremlin is hiding. But you will lose nothing if
you
try the following:
* output the link "images/#ItemInfo.image#" and make sure it is what you
expected. I have found that mixing URLTokened links with non-URLTokened
links sometimes leads to problems.
* words like "Properties" and "Property" already make me lean forward. Check
that you're not offending any reserved keywords in database server or
Coldfusion.
* I would use
<cfif Properties.recordcount> and <cfif Warnings.recordcount>
in place of
<cfif Properties.recordcount is not 0> and <cfif Warnings.recordcount is
not 0>,
respectively.
* In would do this instead
<cfoutput>#ValueList(Properties.property)#</cfoutput>
and this, on a single line, with no space in between,
<cfoutput query="Warnings">#Warnings.warninginfo#<br></cfoutput>
BKBK Guest
-
Vampyr_Bytes #4 Re: HTTP 500 - Internal Server Error
Thanks both. mxstu led me to the answer (always easier to fix a problem when
you know what it is ;) )
I'd copied and pasted part of the code from another page in the site, but
hadn't changed one of the recordset names... it was looking for display.image
instead of iteminfo.image
Vampyr_Bytes Guest
-
BKBK #5 Re: HTTP 500 - Internal Server Error
>... it was looking for display.image instead of iteminfo.image
Good you finally found it. But, it is a bit unfair that CF issued you
an internal server error just for that. The mind boggles.
BKBK Guest
-
RUNd #6 Re: HTTP 500 - Internal Server Error
I've been having this problem sometimes on different developing machines... in
the past i always used iis and had the problem one day to the next, and now i
have it on a apache install. When I get the 500 error I have to place an
cfabort somewhere before the error (guesswork) and then when i get the blank
page, i remove the cfabort et voila the actual error. I've got absolutely no
clue what's causing this error but since several of my colleagues have had the
same problem, I'm guessing that we're not the only ones on this world, who this
is happening to...
Can someone maybe shed some light on this?
RUNd Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
