Developer forum

Forum » Development » Problem updating

Problem updating

E-mail notifications

Reply
Posted on 27/11/2008 09:28:04

Hey guys,

 

I just downloaded the new application (November 19, 2008) from the download area.

 

But when i try to update an older custom solution it seems not all new database columns are created.

 

I know i need to change the version numbers in the update.xml and ecom_xx.xml, but i can seem to hit the right number, so the missing fields are added to the DB. i tried setting them both to 0. but with luck

 

I get this error when i try to view a product:

System.Data.SqlClient.SqlException: Invalid object name 'EcomOrderLineFields'.
 

What to do?

 

/Martin


Replies

 
Posted on 27/11/2008 10:04:33
Reply

This change was issued in package 70 of the eCommerce update package which is seperate from the standard update. To change this, you need to udate the number in UpdateVersion_ecom.xml to 69 and then restart the solution. Something else might be missing, so please set it to 50 or something.

 
Posted on 27/11/2008 10:27:51
Reply

Hi Lars,

 

it seems i missed a rather important option when i created my DB user for my database, it wasn't DB_OWNER so the update couldn't create/alter tables :-)

 

It updated fine after i change to DB_OWNER.

 

/Martin

 
Posted on 27/11/2008 16:50:54
Reply

<p>Remove the dbowner role from the user and add ddladmin instead, and the use something like sp_changeobjectowner to set the new tables from your sql user to dbo. Otherwise your new tables will be [databasename].[username][tablename] rather than [databasename].dbo.[tablename], and your sql server user will not have access to them. All other tables are owned by dbo.</p>

 

You must be logged in to post in the forum