It's back!! original 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.
THE POSSIBLE SOLUTION: Just FYI....this appears to have been a result of a known MySQl JDBC > driver bug. The workaround is to uncheck "maintain connection" for the > datasource and add the number zero in the "validation query" box. > > So far so good Well that didn't pan out and this intermittent error is occurring again....any thoughts? I'll take complete stabs in the dark at this point ;-) I am 100% certain it has nothing to do with undefined vars, but I'm running awfully low ideas at this point. 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:312325 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
