Skip to main content
Participating Frequently
May 25, 2008
Question

Query Errors

  • May 25, 2008
  • 1 reply
  • 589 views
Hello,

I changed hosting companies and now I'm having issues with query errors. I attached the code of the first one below.

Does anyone have any ideas?

Thanks
This topic has been closed for replies.

1 reply

May 28, 2008
First off, did your new hosting company create your datasource for you? I imagine they did, but I ask because sometimes a hit counter is the first DB activity you'll see, and that can be related to the datasource being set up.
Participating Frequently
May 28, 2008
Hello, thanks for the reply!

I've really been having issues with this site. Anyway, no, my hosting comany didn't create it, I did, along with another programmer. We found the problem yesterday. The table name inside the database was called counter and for some reason my new host didn't like that. It must be the version of CF they are using. I got around it by changing the table name to hitcounter, but thanks for you help anyway.

We've managed to fix most of the errors now, but there are stll a few giving use trouble. Here's one more:


May 28, 2008
Knock down your UPDATE script to do one update at a time, when each works add another field in your update script. That's how I track down the problem child.

Also, take a look at cfqueryparam. It can really save you some headaches.