Hey Ben, Can you post an error message? That would go a long way towards putting a pin in the problem(s).
~tom >-----Original Message----- >From: Ben [mailto:[EMAIL PROTECTED] >Sent: Wednesday, December 10, 2003 1:26 PM >To: FarCry Developers >Subject: [farcry-dev] Re: Problems moving from dev to prod. > > >Thanks for that Brendan. > >I will look into it. It is very difficult tho when I have VERY >minimal access to the server. Mostly have to relay information >from one person to another - frustrating is the word! I know >if they just let me at the box I can get it working. > >I was thinking. Just to ensure that the db is setup correctly >would it be worth running the setup again to create a blank db >with all the permissions etc etc setup? Perhaps then deploying >all the types and then doing an import of the data? > >Regards, > >Ben Robinson > > > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf >Of Brendan Sisson >Sent: Wednesday, December 10, 2003 10:35 AM >To: FarCry Developers >Subject: [farcry-dev] Re: Problems moving from dev to prod. > >Ben Robinson wrote: > > Moved the site code over. >> Got the tech dudes where it is being hosted to create a blank sql >server db. >> Did an import of the tables and data to the blank db (had issues with >that too but worked in the end). Created all the mappings >datasources and virtual directories etc etc > > >Make sure you check that all the default values are set in the types >tables (eg dmHTML, dmNews etc and fields locked and status etc) > > >> Now trying to run the site I get db errors. Mainly to do with >permissions on the user dbo for the database which is blowing >the sql queries which is referencing tables like FROM >dbo.tablename if you get my drift. > > >You set the dbowner in your <appname>/cofig/_serverSpecificVars.cfm: > >application.dbowner = "dbo."; > >Change this to what ever your tech guys have set you up with but >remember the . at the end. Then update your application scope by >appending updateapp=1 to the url. > >Hope that helps > >-Brendan >http://farcry.daemon.com.au > > >--- >You are currently subscribed to farcry-dev as: >[EMAIL PROTECTED] To unsubscribe send a blank email to >[EMAIL PROTECTED] > >MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
