Hey All, Wow....long time no post ;-)
So we just moved a bunch of client sites to a VPS (HostMySite) and all has gone well. One of the sites we moved has a small web app for building content for an HTML e-bulletin that gets mailed out once a week. It went out fine last week (after moving from shared hosting to the VPS) as it always does, but not yesterday. It's running CF 8 on Windows and uses MySQL for the DB. The DB did not move from where it was when the site was hosted on a shared server.....just the code moved to the VPS. The code is stable and HAS NOT changed since before the move to the VPS. THE ERROR IS: -intermittent (can refresh and erroring page and see no errors and vica versa) -not happening in the same place (various files at various times) -even references queries with NO VARIABLES....just hardcoded values in cfqueryparam -always references a query THE ERROR MESSAGE IS: The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. So like I said.....code is fine.....doubled checked it all. A page will run fine many times and then won't. No other sites on the VPS are experiencing this problem (none use MySQL). WHAT I'VE DONE: -cycled CF services - no love -restarted virtual server - no love -had tech restart MySQL service - no love I'm at a loss on this one....any ideas welcome ;-) Given that everything has been restarted and this thing is intermittent....I have to think it's NOT the code as the error eludes to, but rather something on the VPS or an issue with the data source or the DB itself. TIA Cheers - Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312031 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
