Jesse, I am having similar problems, with the following additions; ( SYSTEM: after an upgrade of CF5 Professional to CFMX Professional on RH 7.1 kernel 2.4.9-34 apache-1.3.22-5.7.1 glibc-2.2.4-29, note: these are the versions after running the up2date utility )
1. My vhosts seem to be having trouble grabbing the correct CF pages from the correct vhost, intermittently I will request a page from host A but receive a page from host B, the only reason I mention this is the fact this had never happened previously and I made no changes to my vhost setup or DNS the only change was running up2date a move to CFMX, from CF5. 2. My previous CF5 app build SQL statements and passed them to MySQL using cfquery. Since the move to CFMX it appears that internal to CF, quotes are escaped differently than before, when I print out the SQL statement before I pass it to the cfquery tag it has all the quotes doubled, tripled and in some cases an additional 5-8 quotes are added. So rather than passing the intended SQL statement below: SELECT table.column INTO OUTFILE '/www/website1/htdocs/download/092002-104722-1' FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '' LINES TERMINATED BY '\n' I end up with this: SELECT table.column INTO OUTFILE ''''''''''''''''''''''''''''''''/www/website1/htdocs/download/092002-104722-1'''''''''''''''''''''''''''''''' FIELDS TERMINATED BY ''''''''''''''''''''''''''''''''\t'''''''''''''''''''''''''''''''' ENCLOSED BY '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ESCAPED BY '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' LINES TERMINATED BY ''''''''''''''''''''''''''''''''\n'''''''''''''''''''''''''''''''' FROM table WHERE int_filesource_id IN (3,4,2,1,5,6,7) Again in this case not one line of CF code was altered, I just ran up2date and installed CFMX. I have several (closed src) dependencies that make kernel upgrades a difficult process, so I hope this is not kernel related, if it is, I may have to roll back to CF5. I am also concerned about upgrading to apache 2.0 since I have (or had) a working setup already. I would like to avoid an this upgrade if at all possible until I can be sure that it will not introduce a new host of problems. Thanks, Jim Finucane -------- Original Message -------- Subject: RE: CF MX Problems with hundreds of threads Date: Fri, 20 Sep 2002 10:09:30 -0400 From: Jesse Noller <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Linux <[EMAIL PROTECTED]> Right now, I am examining multiple reports to this, and commonly the fix is to upgrade to apache 2. Jesse Noller [EMAIL PROTECTED] Macromedia Server Development Unix/Linux "special guy" "But I neeeeed tacos! I need them or I will explode! That happens to me sometimes!" -GIR > -----Original Message----- > From: Christoph Gr�ver [mailto:[EMAIL PROTECTED]] > Sent: Friday, September 20, 2002 10:03 AM > To: CF-Linux > Subject: Re: CF MX Problems with hundreds of threads > > On Fri, 20 Sep 2002 08:31:15 -0400 > Jesse Noller <[EMAIL PROTECTED]> wrote: > > > Make sure glibc is fully patched, and try upgrading to Apache 2 > > > > Upgrading to Apache 2 is not really possible. We are using 1.3.x only > Apache modules. > Also AFAIK the glibc used by SuSE is fully patched. > > Any more ideas ? > > Greetings > > -- > Christoph Gr�ver, [EMAIL PROTECTED] > Sitepark, Gesellschaft f�r Informationsmanagement mbH > Rothenburg 14-16, D-48143 M�nster, Telefon (0251) 48265-50 > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
