RE: Can moving from cf server 5 to mx7 cause an app to stop working?
Excellent idea Kym. On one of the datasources it worked fine, the other continued to throw errors and not work. -Original Message- From: Kym Kovan [mailto:[EMAIL PROTECTED] Sent: Sunday, February 26, 2006 6:48 PM To: CF-Talk Subject: Re: Can moving from cf server 5 to mx7 cause an app to stop working? Steve Kahn wrote: > The database looks fine. I set up the > site to have identical 'sql, username, and passwords' and yet I will get an > error saying a column name doesnt exist in the database when in fact I can > see it in enterprise manager. ... > That looks like an database ownership issue. Try making your query of the form where the From aspect is a fully qualified [dbo].mytable, eg "select thiscolumn from [dbo].myTable", rather than the more usual "select thiscolumn from myTable". If that works then the restored database's owner is not your user. OTTOMH I cannot remember the knowledgebase article but look up sp_changedbowner in SQL books online and you will be in roughly the right place. HTH, Kym K ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233522 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Can moving from cf server 5 to mx7 cause an app to stop working?
> Has anyone else experienced this issue and what do > you recommend as a solution. Does it pay to persue > finding a host running cf server 5 and does anyone > know of one? Personally, I would try to track down the issue and update the code if you can run on a newer version of CF. If anyone has a need for a specific version of CF, the company I work for offers hosting on CF 5, 6, and 7 with MSSQL Server 2000. We also have solid e-mail service with very, very good spam/virus filtering. -Justin Scott | GravityFree Senior Programmer / Product Engineer 1960 Stickney Point Road, Second Floor Sarasota | FL | 34231 | 800.207.4431 941.927.7674 | f 941.923.5429 www.GravityFree.com ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233521 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can moving from cf server 5 to mx7 cause an app to stop working?
Steve Kahn wrote: > The database looks fine. I set up the > site to have identical 'sql, username, and passwords' and yet I will get an > error saying a column name doesnt exist in the database when in fact I can > see it in enterprise manager. ... > That looks like an database ownership issue. Try making your query of the form where the From aspect is a fully qualified [dbo].mytable, eg "select thiscolumn from [dbo].myTable", rather than the more usual "select thiscolumn from myTable". If that works then the restored database's owner is not your user. OTTOMH I cannot remember the knowledgebase article but look up sp_changedbowner in SQL books online and you will be in roughly the right place. HTH, Kym K ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233520 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can moving from cf server 5 to mx7 cause an app to stop working?
Steve, I recently moved an app from CF5 to CFMX7 and I did not have any significant problems. Any chance you could post code/errors? George On 2/26/06, Steve Kahn <[EMAIL PROTECTED]> wrote: > > Aaron - good point. > I set up a demo on the sql server and did a cfform/ action to insert data > and it threw an error. Enterprise manager shows the table exists but has > no > data entered. Sounds like a server related issue now, but im far from thru > the woods on these errors. > > Thanks > Steve > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233519 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Can moving from cf server 5 to mx7 cause an app to stop working?
Aaron - good point. I set up a demo on the sql server and did a cfform/ action to insert data and it threw an error. Enterprise manager shows the table exists but has no data entered. Sounds like a server related issue now, but im far from thru the woods on these errors. Thanks Steve -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Sunday, February 26, 2006 3:15 PM To: CF-Talk Subject: Re: Can moving from cf server 5 to mx7 cause an app to stop working? This happens for any column and any table? What happens if you just make a test page to connect to the database and select one row from one of the tables? On 2/26/06, Steve Kahn <[EMAIL PROTECTED]> wrote: > > There is no fusebox code. I am moving my site from cfm-resources to > crystaltech hosting. I restored the sql with a .bak file and ran a > datacompare with red-gate sql tools. The database looks fine. I set up the > site to have identical 'sql, username, and passwords' and yet I will get > an > error saying a column name doesn't exist in the database when in fact I > can > see it in enterprise manager. Very confusing, for all intents the sites > should migrate well but are not. Thanks again for your advise. > > Steve > > -Original Message- > From: Barney Boisvert [mailto:[EMAIL PROTECTED] > Sent: Sunday, February 26, 2006 1:49 PM > To: CF-Talk > Subject: Re: Can moving from cf server 5 to mx7 cause an app to stop > working? > > Are you by chance running Fusebox 3 with the conditionals in > index.cfm? If so, remove them, leaving only the include for the CF5 > core file. > > There are a lot of little language changes between 5 and 7, but > nothing springs to mind as something that would totally kill your > sites. I'd start chopping out sections of your app to see if you can > narrow down where the problem is, and make sure you're checking all > the relevant log files for any clues that might be in them. > > cheers, > barneyb > > On 2/26/06, Steve Kahn <[EMAIL PROTECTED]> wrote: > > I am moving my sites from coldfusion server 5 / mssql 7 to a new host > running mx7 / ms sql 2000. The sites work fine on the original host, but > are > functionless at the new one. > > > > Has anyone else experienced this issue and what do you recommend as a > solution. Does it pay to persue finding a host running cf server 5 and > does > anyone know of one? > > > > Thank you > > Steve > > -- > Barney Boisvert > [EMAIL PROTECTED] > 360.319.6145 > http://www.barneyb.com/ > > Got Gmail? I have 100 invites. > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233514 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Can moving from cf server 5 to mx7 cause an app to stop working?
Make sure your table owners of the sql object correlates with your script (ie if your using Sproc's.) Check your queries for any database object references and make sure they match your new ones. -Original Message- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Sunday, February 26, 2006 12:15 PM To: CF-Talk Subject: Re: Can moving from cf server 5 to mx7 cause an app to stop working? This happens for any column and any table? What happens if you just make a test page to connect to the database and select one row from one of the tables? On 2/26/06, Steve Kahn <[EMAIL PROTECTED]> wrote: > > There is no fusebox code. I am moving my site from cfm-resources to > crystaltech hosting. I restored the sql with a .bak file and ran a > datacompare with red-gate sql tools. The database looks fine. I set up > the site to have identical 'sql, username, and passwords' and yet I > will get an error saying a column name doesn't exist in the database > when in fact I can see it in enterprise manager. Very confusing, for > all intents the sites should migrate well but are not. Thanks again > for your advise. > > Steve > > -Original Message- > From: Barney Boisvert [mailto:[EMAIL PROTECTED] > Sent: Sunday, February 26, 2006 1:49 PM > To: CF-Talk > Subject: Re: Can moving from cf server 5 to mx7 cause an app to stop > working? > > Are you by chance running Fusebox 3 with the conditionals in > index.cfm? If so, remove them, leaving only the include for the CF5 > core file. > > There are a lot of little language changes between 5 and 7, but > nothing springs to mind as something that would totally kill your > sites. I'd start chopping out sections of your app to see if you can > narrow down where the problem is, and make sure you're checking all > the relevant log files for any clues that might be in them. > > cheers, > barneyb > > On 2/26/06, Steve Kahn <[EMAIL PROTECTED]> wrote: > > I am moving my sites from coldfusion server 5 / mssql 7 to a new > > host > running mx7 / ms sql 2000. The sites work fine on the original host, > but are functionless at the new one. > > > > Has anyone else experienced this issue and what do you recommend as > > a > solution. Does it pay to persue finding a host running cf server 5 and > does anyone know of one? > > > > Thank you > > Steve > > -- > Barney Boisvert > [EMAIL PROTECTED] > 360.319.6145 > http://www.barneyb.com/ > > Got Gmail? I have 100 invites. > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233513 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can moving from cf server 5 to mx7 cause an app to stop working?
This happens for any column and any table? What happens if you just make a test page to connect to the database and select one row from one of the tables? On 2/26/06, Steve Kahn <[EMAIL PROTECTED]> wrote: > > There is no fusebox code. I am moving my site from cfm-resources to > crystaltech hosting. I restored the sql with a .bak file and ran a > datacompare with red-gate sql tools. The database looks fine. I set up the > site to have identical 'sql, username, and passwords' and yet I will get > an > error saying a column name doesn't exist in the database when in fact I > can > see it in enterprise manager. Very confusing, for all intents the sites > should migrate well but are not. Thanks again for your advise. > > Steve > > -Original Message- > From: Barney Boisvert [mailto:[EMAIL PROTECTED] > Sent: Sunday, February 26, 2006 1:49 PM > To: CF-Talk > Subject: Re: Can moving from cf server 5 to mx7 cause an app to stop > working? > > Are you by chance running Fusebox 3 with the conditionals in > index.cfm? If so, remove them, leaving only the include for the CF5 > core file. > > There are a lot of little language changes between 5 and 7, but > nothing springs to mind as something that would totally kill your > sites. I'd start chopping out sections of your app to see if you can > narrow down where the problem is, and make sure you're checking all > the relevant log files for any clues that might be in them. > > cheers, > barneyb > > On 2/26/06, Steve Kahn <[EMAIL PROTECTED]> wrote: > > I am moving my sites from coldfusion server 5 / mssql 7 to a new host > running mx7 / ms sql 2000. The sites work fine on the original host, but > are > functionless at the new one. > > > > Has anyone else experienced this issue and what do you recommend as a > solution. Does it pay to persue finding a host running cf server 5 and > does > anyone know of one? > > > > Thank you > > Steve > > -- > Barney Boisvert > [EMAIL PROTECTED] > 360.319.6145 > http://www.barneyb.com/ > > Got Gmail? I have 100 invites. > > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233512 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can moving from cf server 5 to mx7 cause an app to stop working?
>There is no fusebox code. I am moving my site from cfm-resources to >crystaltech hosting. I restored the sql with a .bak file and ran a >datacompare with red-gate sql tools. The database looks fine. I set up the >site to have identical 'sql, username, and passwords' and yet I will get an >error saying a column name doesnt exist in the database when in fact I can >see it in enterprise manager. Very confusing, for all intents the sites >should migrate well but are not. Thanks again for your advise. > >Steve > >-Original Message- >From: Barney Boisvert [mailto:[EMAIL PROTECTED] >Sent: Sunday, February 26, 2006 1:49 PM >To: CF-Talk >Subject: Re: Can moving from cf server 5 to mx7 cause an app to stop >working? > >Are you by chance running Fusebox 3 with the conditionals in >index.cfm? If so, remove them, leaving only the include for the CF5 >core file. > >There are a lot of little language changes between 5 and 7, but >nothing springs to mind as something that would totally kill your >sites. I'd start chopping out sections of your app to see if you can >narrow down where the problem is, and make sure you're checking all >the relevant log files for any clues that might be in them. > >cheers, >barneyb > >On 2/26/06, Steve Kahn <[EMAIL PROTECTED]> wrote: >> I am moving my sites from coldfusion server 5 / mssql 7 to a new host >running mx7 / ms sql 2000. The sites work fine on the original host, but are >functionless at the new one. >> >> Has anyone else experienced this issue and what do you recommend as a >solution. Does it pay to persue finding a host running cf server 5 and does >anyone know of one? >> >> Thank you >> Steve > >-- >Barney Boisvert >[EMAIL PROTECTED] >360.319.6145 >http://www.barneyb.com/ > >Got Gmail? I have 100 invites. There are some differences on CFForm usage especially if you're using built-in validation. I don't know if CF5 supported validation off-hand, but coming from MX 6.1 to 7 there were some issues with cfform usage and validation. Also check and see if your host has the new 7.01 patch installed. Dump the server scope to find out what version they are using. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233511 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Can moving from cf server 5 to mx7 cause an app to stop working?
There is no fusebox code. I am moving my site from cfm-resources to crystaltech hosting. I restored the sql with a .bak file and ran a datacompare with red-gate sql tools. The database looks fine. I set up the site to have identical 'sql, username, and passwords' and yet I will get an error saying a column name doesnt exist in the database when in fact I can see it in enterprise manager. Very confusing, for all intents the sites should migrate well but are not. Thanks again for your advise. Steve -Original Message- From: Barney Boisvert [mailto:[EMAIL PROTECTED] Sent: Sunday, February 26, 2006 1:49 PM To: CF-Talk Subject: Re: Can moving from cf server 5 to mx7 cause an app to stop working? Are you by chance running Fusebox 3 with the conditionals in index.cfm? If so, remove them, leaving only the include for the CF5 core file. There are a lot of little language changes between 5 and 7, but nothing springs to mind as something that would totally kill your sites. I'd start chopping out sections of your app to see if you can narrow down where the problem is, and make sure you're checking all the relevant log files for any clues that might be in them. cheers, barneyb On 2/26/06, Steve Kahn <[EMAIL PROTECTED]> wrote: > I am moving my sites from coldfusion server 5 / mssql 7 to a new host running mx7 / ms sql 2000. The sites work fine on the original host, but are functionless at the new one. > > Has anyone else experienced this issue and what do you recommend as a solution. Does it pay to persue finding a host running cf server 5 and does anyone know of one? > > Thank you > Steve -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233509 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Can moving from cf server 5 to mx7 cause an app to stop working?
Are you by chance running Fusebox 3 with the conditionals in index.cfm? If so, remove them, leaving only the include for the CF5 core file. There are a lot of little language changes between 5 and 7, but nothing springs to mind as something that would totally kill your sites. I'd start chopping out sections of your app to see if you can narrow down where the problem is, and make sure you're checking all the relevant log files for any clues that might be in them. cheers, barneyb On 2/26/06, Steve Kahn <[EMAIL PROTECTED]> wrote: > I am moving my sites from coldfusion server 5 / mssql 7 to a new host running > mx7 / ms sql 2000. The sites work fine on the original host, but are > functionless at the new one. > > Has anyone else experienced this issue and what do you recommend as a > solution. Does it pay to persue finding a host running cf server 5 and does > anyone know of one? > > Thank you > Steve -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 100 invites. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233508 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Can moving from cf server 5 to mx7 cause an app to stop working?
I am moving my sites from coldfusion server 5 / mssql 7 to a new host running mx7 / ms sql 2000. The sites work fine on the original host, but are functionless at the new one. Has anyone else experienced this issue and what do you recommend as a solution. Does it pay to persue finding a host running cf server 5 and does anyone know of one? Thank you Steve ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233507 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
