Re: Client storage woes
Yes, that is how cf created the tables. More weirdness, I found out later on that only one of my PCs were causing the error. When I killed the cookies in the browser the error disappeared. So, the reboot I did early this morning wasn't really a fix - for some reason a left over cfid/cftoken caused the errorstrange... Howie - Original Message - From: "Bud" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, November 19, 2001 8:27 AM Subject: Re: Client storage woes > On 11/18/01, Howie Hamlin penned: > > > 1. Is the data schema exactly the same for both development and production > >> databases for the CDATA and CGLOBAL tables? Unless you created the data > >> schema manually, this shouldn't be a problem. > >> > > > >I had CF create the tables. > > Maybe CF screwed up somehow when creating the tables? Have you gone > in and manually checked the datatypes? > > CDATA > cfid char 20allow nulls > app char 64allow nulls > data text 16allow nulls > > CGLOBAL > cfid char 20allow nulls > data text 16allow nulls > lvisit datetime 8allow nulls > -- > > Bud Schneehagen - Tropical Web Creations > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > ColdFusion Solutions / eCommerce Development > [EMAIL PROTECTED] > http://www.twcreations.com/ > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Client storage woes
On 11/18/01, Howie Hamlin penned: > > 1. Is the data schema exactly the same for both development and production >> databases for the CDATA and CGLOBAL tables? Unless you created the data >> schema manually, this shouldn't be a problem. >> > >I had CF create the tables. Maybe CF screwed up somehow when creating the tables? Have you gone in and manually checked the datatypes? CDATA cfid char 20allow nulls app char 64allow nulls data text 16allow nulls CGLOBAL cfid char 20allow nulls data text 16allow nulls lvisit datetime 8allow nulls -- Bud Schneehagen - Tropical Web Creations _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ ColdFusion Solutions / eCommerce Development [EMAIL PROTECTED] http://www.twcreations.com/ ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Client storage woes
Ha - as soon as I get home :-) Luckily, the office is only a mile from home... Regards, Howie - Original Message - From: "Matt Robertson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, November 19, 2001 3:35 AM Subject: Re: Client storage woes > Cool. Get some sleep ;D > > Cheers, > > --Matt-- > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Client storage woes
Cool. Get some sleep ;D Cheers, --Matt-- - Original Message - From: "Howie Hamlin" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, November 19, 2001 12:22 AM Subject: Re: Client storage woes Well, the reboot actually worked - thanks for the suggestion. Regards, Howie - Original Message - From: "Matt Robertson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, November 18, 2001 10:23 PM Subject: Re: Client storage woes > Have been following this thread all day long. Doesn't sound as if anything > is wrong. Must be maddening. > > Have you tried a cold reboot to reset all services to see if that helps? > Just a shot in the dark. > > - > Matt Robertson [EMAIL PROTECTED] > MSB Designs, Inc. http://mysecretbase.com > - > > > - Original Message - > From: "Howie Hamlin" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, November 18, 2001 5:53 PM > Subject: Re: Client storage woes > > > They are the same. I had CF create the tables... > > Thanks, > > Howie > > ----- Original Message - > From: "Tony Gruen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, November 18, 2001 7:26 PM > Subject: RE: Client storage woes > > > > Compare the field types in your SQL Server databases on Dev and > Production. > > Your production database field type may need modified. > > > > Tony Gruen > > sfnetworks > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Client storage woes
Well, the reboot actually worked - thanks for the suggestion. Regards, Howie - Original Message - From: "Matt Robertson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, November 18, 2001 10:23 PM Subject: Re: Client storage woes > Have been following this thread all day long. Doesn't sound as if anything > is wrong. Must be maddening. > > Have you tried a cold reboot to reset all services to see if that helps? > Just a shot in the dark. > > - > Matt Robertson [EMAIL PROTECTED] > MSB Designs, Inc. http://mysecretbase.com > - > > > - Original Message - > From: "Howie Hamlin" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, November 18, 2001 5:53 PM > Subject: Re: Client storage woes > > > They are the same. I had CF create the tables... > > Thanks, > > Howie > > - Original Message - > From: "Tony Gruen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, November 18, 2001 7:26 PM > Subject: RE: Client storage woes > > > > Compare the field types in your SQL Server databases on Dev and > Production. > > Your production database field type may need modified. > > > > Tony Gruen > > sfnetworks > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Client storage woes
I haven't tried that yet but it's worth a shot. Regards, Howie - Original Message - From: "Matt Robertson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, November 18, 2001 10:23 PM Subject: Re: Client storage woes > Have been following this thread all day long. Doesn't sound as if anything > is wrong. Must be maddening. > > Have you tried a cold reboot to reset all services to see if that helps? > Just a shot in the dark. > > - > Matt Robertson [EMAIL PROTECTED] > MSB Designs, Inc. http://mysecretbase.com > - > > > - Original Message - > From: "Howie Hamlin" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, November 18, 2001 5:53 PM > Subject: Re: Client storage woes > > > They are the same. I had CF create the tables... > > Thanks, > > Howie > > ----- Original Message ----- > From: "Tony Gruen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Sunday, November 18, 2001 7:26 PM > Subject: RE: Client storage woes > > > > Compare the field types in your SQL Server databases on Dev and > Production. > > Your production database field type may need modified. > > > > Tony Gruen > > sfnetworks > > > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Client storage woes
Have been following this thread all day long. Doesn't sound as if anything is wrong. Must be maddening. Have you tried a cold reboot to reset all services to see if that helps? Just a shot in the dark. - Matt Robertson [EMAIL PROTECTED] MSB Designs, Inc. http://mysecretbase.com - - Original Message - From: "Howie Hamlin" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, November 18, 2001 5:53 PM Subject: Re: Client storage woes They are the same. I had CF create the tables... Thanks, Howie - Original Message - From: "Tony Gruen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, November 18, 2001 7:26 PM Subject: RE: Client storage woes > Compare the field types in your SQL Server databases on Dev and Production. > Your production database field type may need modified. > > Tony Gruen > sfnetworks ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Client storage woes
They are the same. I had CF create the tables... Thanks, Howie - Original Message - From: "Tony Gruen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, November 18, 2001 7:26 PM Subject: RE: Client storage woes > Compare the field types in your SQL Server databases on Dev and Production. > Your production database field type may need modified. > > Tony Gruen > sfnetworks ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Client storage woes
Compare the field types in your SQL Server databases on Dev and Production. Your production database field type may need modified. Tony Gruen sfnetworks -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 18, 2001 1:54 PM To: CF-Talk Subject: Client storage woes Our main web server has a registry that is huge because of the CF client storage. So, I decide to store client data in a SQL db. I can get this to work fine on my development server but when I try to do the same thing for the production server I get a SQL error when accessing pages: ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. I have no idea why this happens on our production server. Both production and test servers are CF5. Thanks, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server <<< Vote for iMS as the CFDJ Reader's Choice Awards Most Innovative Product >>> http://www.sys-con.com/coldfusion/readerschoice2001/nominationformbpa.cfm >>> Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Client storage woes
> My production server has 2.5.1 and the dev server has 2.6. > Would you recommend upgrading to 2.6 or 2.7? I didn't even know there was a 2.7, so I'm probably not qualified to give you advice on this. I'd probably stick with 2.6 SP1, since you know that works on the dev server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Client storage woes
My production server has 2.5.1 and the dev server has 2.6. Would you recommend upgrading to 2.6 or 2.7? Thanks, Howie - Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, November 18, 2001 5:50 PM Subject: RE: Client storage woes > > Our main web server has a registry that is huge because of > > the CF client storage. So, I decide to store client data in > > a SQL db. I can get this to work fine on my development server > > but when I try to do the same thing for the production server > > I get a SQL error when accessing pages: > > > > ODBC Error Code = 22001 (String data right truncation) > > [Microsoft][ODBC SQL Server Driver][SQL Server]String or > > binary data would be truncated. > > > > I have no idea why this happens on our production server. > > Both production and test servers are CF5. > > I'd look at these things: > > 1. Is the data schema exactly the same for both development and production > databases for the CDATA and CGLOBAL tables? Unless you created the data > schema manually, this shouldn't be a problem. > > 2. In your ODBC datasource configuration in the CF Administrator on the > production server, did you enable the "Long Text Retrieval Settings" option? > > 3. Do you have different versions of MDAC on your two servers? You can find > out which version you have on each with the MDAC Component Checker, > available at http://www.microsoft.com/data/. > > My money is on number 2. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Client storage woes
- Original Message - From: "Dave Watts" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, November 18, 2001 5:50 PM Subject: RE: Client storage woes > > Our main web server has a registry that is huge because of > > the CF client storage. So, I decide to store client data in > > a SQL db. I can get this to work fine on my development server > > but when I try to do the same thing for the production server > > I get a SQL error when accessing pages: > > > > ODBC Error Code = 22001 (String data right truncation) > > [Microsoft][ODBC SQL Server Driver][SQL Server]String or > > binary data would be truncated. > > > > I have no idea why this happens on our production server. > > Both production and test servers are CF5. > > I'd look at these things: > > 1. Is the data schema exactly the same for both development and production > databases for the CDATA and CGLOBAL tables? Unless you created the data > schema manually, this shouldn't be a problem. > I had CF create the tables. > 2. In your ODBC datasource configuration in the CF Administrator on the > production server, did you enable the "Long Text Retrieval Settings" option? > I didn't - I changed the setting but it made no difference. > 3. Do you have different versions of MDAC on your two servers? You can find > out which version you have on each with the MDAC Component Checker, > available at http://www.microsoft.com/data/. > OK, I'll check that. Thanks, Howie > My money is on number 2. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > voice: (202) 797-5496 > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Client storage woes
I had CF create them. Howie - Original Message - From: "Joseph DeVore" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, November 18, 2001 5:41 PM Subject: RE: Client storage woes > Did you have ColdFusion create the tables on your production server when > switching to ODBC client storage, or did you import them from the dev box? > > If you didn't have CF create the tables, it's possible you selected an > incorrect datatype. > > > Joseph DeVore > VeloxWeb Technologies > > > > -Original Message- > From: Howie Hamlin [mailto:[EMAIL PROTECTED]] > Sent: Sunday, November 18, 2001 1:54 PM > To: CF-Talk > Subject: Client storage woes > > > Our main web server has a registry that is huge because of the CF client > storage. So, I decide to store client data in a SQL db. I > can get this to work fine on my development server but when I try to do the > same thing for the production server I get a SQL error > when accessing pages: > > ODBC Error Code = 22001 (String data right truncation) > [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would > be truncated. > > I have no idea why this happens on our production server. Both production > and test servers are CF5. > > Thanks, > > -- > Howie Hamlin - inFusion Project Manager > On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 > inFusion Mail Server (iMS) - The Intelligent Mail Server > <<< Vote for iMS as the CFDJ Reader's Choice Awards Most Innovative Product > >>> > http://www.sys-con.com/coldfusion/readerschoice2001/nominationformbpa.cfm > >>> Find out how iMS Stacks up to the competition: > http://www.coolfusion.com/imssecomparison.cfm > > > ~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Client storage woes
> Our main web server has a registry that is huge because of > the CF client storage. So, I decide to store client data in > a SQL db. I can get this to work fine on my development server > but when I try to do the same thing for the production server > I get a SQL error when accessing pages: > > ODBC Error Code = 22001 (String data right truncation) > [Microsoft][ODBC SQL Server Driver][SQL Server]String or > binary data would be truncated. > > I have no idea why this happens on our production server. > Both production and test servers are CF5. I'd look at these things: 1. Is the data schema exactly the same for both development and production databases for the CDATA and CGLOBAL tables? Unless you created the data schema manually, this shouldn't be a problem. 2. In your ODBC datasource configuration in the CF Administrator on the production server, did you enable the "Long Text Retrieval Settings" option? 3. Do you have different versions of MDAC on your two servers? You can find out which version you have on each with the MDAC Component Checker, available at http://www.microsoft.com/data/. My money is on number 2. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Client storage woes
Did you have ColdFusion create the tables on your production server when switching to ODBC client storage, or did you import them from the dev box? If you didn't have CF create the tables, it's possible you selected an incorrect datatype. Joseph DeVore VeloxWeb Technologies -Original Message- From: Howie Hamlin [mailto:[EMAIL PROTECTED]] Sent: Sunday, November 18, 2001 1:54 PM To: CF-Talk Subject: Client storage woes Our main web server has a registry that is huge because of the CF client storage. So, I decide to store client data in a SQL db. I can get this to work fine on my development server but when I try to do the same thing for the production server I get a SQL error when accessing pages: ODBC Error Code = 22001 (String data right truncation) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated. I have no idea why this happens on our production server. Both production and test servers are CF5. Thanks, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com - 631-737-4668 x101 inFusion Mail Server (iMS) - The Intelligent Mail Server <<< Vote for iMS as the CFDJ Reader's Choice Awards Most Innovative Product >>> http://www.sys-con.com/coldfusion/readerschoice2001/nominationformbpa.cfm >>> Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm ~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
