Welcome to Dream.In.Code
Getting Help is Easy!

Join 136,585 Programmers for FREE! Get instant access to thousands of experts, tutorials, code snippets, and more! There are 2,009 people online right now. Registration is fast and FREE... Join Now!




Error Executing Database Query

 
Reply to this topicStart new topic

Error Executing Database Query

mbcocca
21 Feb, 2008 - 02:25 PM
Post #1

New D.I.C Head
*

Joined: 21 Feb, 2008
Posts: 2

I am an ex-coldfusion developer, now stay-at-home mom so I have no colleagues to run this by. For a personal project I found a "great" (as in cheap) Cold Fusion hosting service www.efree2net.com/ and I've had problem after problem. Unfortunately their support staff doesn't seem to speak english so I can't get from them what the problem is. The latest is the frequent "Error Executing Database Query" that I get when on my site. The site is: http://mycreativediversions.com/recipes/ and when not getting the error it seems to be working fine.

My question is, what does this error usually mean and is there anything I can do to make it go away? (BTW I don't actually have Cold Fusion software. I add CF code manually in Dreamweaver.) Any help will be greatly appreciated.

Mary
User is offlineProfile CardPM
+Quote Post

skyhawk133
RE: Error Executing Database Query
21 Feb, 2008 - 02:29 PM
Post #2

Head DIC Head
Group Icon

Joined: 17 Mar, 2001
Posts: 14,947



Thanked: 47 times
Dream Kudos: 1650
Expert In: Web Development

My Contributions
Are there any details to the error? You can research the cferror tag and try emailing yourself when an error occurs. The email should contain information about the error:

http://www.adobe.com/livedocs/coldfusion/5...ence/Tags16.htm


User is offlineProfile CardPM
+Quote Post

mbcocca
RE: Error Executing Database Query
22 Feb, 2008 - 01:52 PM
Post #3

New D.I.C Head
*

Joined: 21 Feb, 2008
Posts: 2

Thanks for the suggestion. I've got the error pages in place, now I'm just waiting for the problem to resurface.

Meanwhile I'm also trying to create a custom 404 error page. I've made the necessary changes to IIS but I am not running Cold Fusion on my machine (I'm using a Mac) so I can't make the necessary changes to the settings in the Cold Fusion Administrator. Is there a workaround for this? It's silly to have lovely <cferror> pages but the standard (ugly) 404 error page!
User is offlineProfile CardPM
+Quote Post

sansclue
RE: Error Executing Database Query
23 Feb, 2008 - 11:58 AM
Post #4

D.I.C Head
**

Joined: 21 Nov, 2007
Posts: 113



Thanked: 7 times
My Contributions
QUOTE(mbcocca @ 22 Feb, 2008 - 02:52 PM) *

My question is, what does this error usually mean and is there anything I can do to make it go away?
...


Unless full debugging is enabled, you will only get a "teaser" about the error that occurred. It is usually disabled by default on production systems for security. So all you can tell from that message is that some type of db error occurred in the page you were viewing. Some options are to
a) add error handlers and mail yourself the message as suggested
b) enable debugging for your IP only. but that requires access to the CF Admin
c) Look in the logs. They usually contain more detail. By default the logs are in the_cf_root\logs directory.

If you do not have administrative access, then your best and possibly only option is A

This post has been edited by sansclue: 23 Feb, 2008 - 11:59 AM
User is offlineProfile CardPM
+Quote Post

hexeliebe
RE: Error Executing Database Query
25 Mar, 2008 - 05:47 PM
Post #5

New D.I.C Head
*

Joined: 22 Mar, 2008
Posts: 9

If you find the error again, then post it here. With a shared server environment (as I assume you are utilizing) there are several errors that can occur, the main one being that the server is being rebooted or the database connection has dropped.

From your terse post, I would suggest it would be the database connection error so I would think having support confirm that you are on a shared server and at what times the DB server is being rebooted.

Other than that, the db server in a shared environment could be locked due to another's bad query code.

QUOTE(mbcocca @ 21 Feb, 2008 - 03:25 PM) *

I am an ex-coldfusion developer, now stay-at-home mom so I have no colleagues to run this by. For a personal project I found a "great" (as in cheap) Cold Fusion hosting service www.efree2net.com/ and I've had problem after problem. Unfortunately their support staff doesn't seem to speak english so I can't get from them what the problem is. The latest is the frequent "Error Executing Database Query" that I get when on my site. The site is: http://mycreativediversions.com/recipes/ and when not getting the error it seems to be working fine.

My question is, what does this error usually mean and is there anything I can do to make it go away? (BTW I don't actually have Cold Fusion software. I add CF code manually in Dreamweaver.) Any help will be greatly appreciated.

Mary


User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 12/3/08 12:53AM

Live Help!

Tutorials

Programming

Web Development

Reference Sheets

Code Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month