EasyCFM.COM ColdFusion Forums / Work Showcase! / Car Site

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Car Site

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

mbear21
09-05-2006 @ 5:26 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 33
Joined: Aug 2006

I created this for a car dealership. Rather simple, but yeah. The host they ended up using isn't that great, so 1 in 8 clicks you'll get a 'cannot connect to db' error.

www.futureclassicsnj.com/index.cfm

I used the page links tutorial off EasyCFM, worked awesomely. Smile

I just did the Coldfusion, not the layout.

This message was edited by mbear21 on 9-5-06 @ 5:29 PM

Webmaster
09-05-2006 @ 9:14 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Administrator
Posts: 4542
Joined: Jan 2002

1 in 8; you using MS Access?

Pablo Varando
Senior Application Architect
EasyCFM.COM, LLC.

904.483.1457 \\ mobile
webmaster@easycfm.com \\email

mbear21
09-05-2006 @ 9:23 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 33
Joined: Aug 2006

No, we are using MYSQL database. Every so often we get:

[MySQL][ODBC 3.51 Driver][mysqld-4.1.20-max-log]Lost connection to MySQL server during query

Refresh once and it goes away, but it still seems to be happening ALOT more than it should. I just went to our site to get the exact error to paste above, and it only took 2 page loads.

Currently using for hosting: www.ixwebhosting.com

mquack
09-05-2006 @ 11:27 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Moderator
Posts: 1544
Joined: Jan 2005

SQL Server and a reputed host will solve that problem Smile

http://www.rachelqueensg.com

krisbrixon
09-21-2006 @ 12:54 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Senior Member
Posts: 233
Joined: Feb 2005

Couple of options if you can not change the host.

Cache the queries.

put the queries in a function and if they error then run the function again. (don't put it in a loop, just run two or three times.) That will give you a few chances to not fail.

If this is a low load site then don't use a database, use something like WDDX.

It is possible the timeout on the database and the time out on the CF server are different, see if the hosting company will make sure they have the same timing.

Kris Brixon
www.brixontech.com


Website Designed and Developed by Pablo Varando.