A

Anonymous

Question

cold fusion and mysql error: I think?

Forum|Forum|15 years ago
July 29, 2010
5 replies
3441 views

I posted this in a MySQL forum, but was told they thought it might be a Cold Fusion error instead.

Sometimes when I view my webpage, which has a search form on it and then search for records in my database, and I let it sit there for a few minutes and then refresh or hit the back button, it throws up an error saying:

"500 Internal Server Error: There is a problem with the resource you are looking for, and it cannot be displayed. "

"Error executing database query

communications link failure. Last packet sent to the server was 0ms ago"

"The error occurred in D:\inetpub\michael-sexton\rlb\search.cfm line 2:"

1:

2: <cfquery name ="rsBulbs" datasource="rlbulbs">
3: SELECT item
4: FROM rlbBulbs

You will notice in the SELECT statement, its pulling items from rlbBulbs. The b in bulbs here is capitalized, but when I view my page code it is not capitalized. I have looked at my database and the table is rlbbulbs, no caps there either. I have made sure I put the current page to the remote server.

Also, when I do get the error, I can usually click back and click search again and it displays the records with no problem. Does anyone know whats going on? I cant have clients coming to my page and get errors every other time they try to do a new search. Thanks for any help.

Database access

This topic has been closed for replies.

S

Swift

Inspiring

Out of interest, what is the JDBC URL for your rlbulbs datasource?

If you have "localhost" in there, try using 127.0.0.1 instead.

Swift

A

Anonymous

Thanks Swift, and Jane for the tips and suggestions. This has actually been resolved. I think, if I can remember since this was almost 2 months ago, that they had moved my db to another db server and I had forgot. lol

Swift, it was an error that was happeneing on the remote side, not just local. Thanks again!

btw, sorry I didn't mark solved. I dont know if I see how to do that. lol

C

Comcar Tech

Inspiring

Can you be more specific in your explanation of how this was fixed?

I've just had my site move to a new server and am getting this fault intermittently, what was your solution to the problem?

J

JaneUK

Known Participant

I had a similar intermittent problem a while back, and was told that I needed to "flush" things at the MySQL end. As a result, I have an icon on the admin desktop of the MySQL server which runs the following code:

"c:\Program Files\MySQL\MySQL Server 5.1\bin\mysqladmin" -u root -p flush-hosts
pause

I don't claim to fully understand what this does, how, or why, but it might be a starting point.

A

Adam Cameron.

Inspiring

"The error occurred in D:\inetpub\michael-sexton\rlb\search.cfm line 2:"
1: 

2: <cfquery name ="rsBulbs" datasource="rlbulbs">
3: SELECT item
4: FROM rlbBulbs

You will notice in the SELECT statement, its pulling items from rlbBulbs. The b in bulbs here is capitalized, but when I view my page code it is not capitalized. I have looked at my database and the table is rlbbulbs, no caps there either. I have made sure I put the current page to the remote server.

Are you sure you're looking @ the right CF template? And you're not looking at some out-of-date template on your dev environment, and the live environment is different? Have you got trusted cache switched on? If so have you flushed it?

Do me a favour. On the template you think is the one being run for this query, modify it to be like this:

2: <cfquery name ="rsBulbs" datasource="rlbulbs">
3: SELECT item
4: FROM rlbBulbs /* ARE YOU SURE THIS IS THE RIGHT TEMPLATE??? */

(ie: put that comment in).

Go through your steps to reproduce the error and check whether the newly-added comment is coming out in the error msg...

--

Adam

A

Anonymous

Hi Adam, thanks for the response! Just to let you know, I am testing your suggestion at this moment. I added the

comment on my search.cfm page. I checked my admin page and here is a rundown of what is checked and what is not checked.

Maximum number of cached templates = 1024

Trusted Cache = Not checked

Cache Template In Request = Checked

Component Cache = Checked

Save Class Files = checked

Cache web server paths = Not Checked

maximum number of cached queries = 150

Also, I am getting this error when viewing the template in my remote server and I think I get it viewing locally as well. Thanks again for the help! Will let you know about the comment test.

Tony

A

Anonymous

ok had added the comment on line 5 and not the line you suggested. so moved that to line 4 and ran the query and

got a slightly different error than the one posted here.

Error Executing Database Query.
Communications link failure Last packet sent to the server was 0 ms ago.

The error occurred in D:\inetpub\michael-sexton\rlb\results.cfm: line 38
36 : </cfif> 37 : <cfif FORM.voltage IS NOT ""> 38 : AND a.voltage LIKE '#FORM.voltage#%' 39 : </cfif> 40 :

This is completely confusing me at the moment!

A

Anonymous

Is there noone that can give me any suggestions with this issue? I have been trying to understand whats wrong for almost a week now. I have googled the error and have yet to find a solution or even close to a solution to my particular instance. Thanks again for any help.

D

Dan_Bracuk

Inspiring

Having tried it myself, I think a google search on "500 Internal Server Error: There is a problem with the resource you are looking for, and it cannot be displayed" will lead you to some useful information.

A

Anonymous

Hey Dan thanks for the info. I had tried googling the error. Not sure I understand or even found a solution though. I also have been loading the page on another pc and letting it sit like before and it seems to reload fine without the error. I am very new to this and really confused.

A

Anonymous

ok so much for it working on another pc. I waited about 15 minutes and clicked back on my browser and got the error again. I'm really frustrated and wish someone could tell me what to do to resolve this error.

Error Executing Database Query.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded