Transferring Data [CFG_Value] Error


https://forum.kartris.com/Topic2923.aspx
Print Topic | Close Window

By ianguest - Thu 27 Mar 2014
I have just transferred data from one Kartris database to a new updated version.

However, this process brings across the same tblKartrisConfig settings if ticked. This will cause the new database to 'link' to the original.

In the backend you may have difficulty accessing the field to change [Config Setting / General / webshopURL], as this will link to the old original SQL database.

To change this, edit the [CFG_Value] for general.webshopurl using an MSSQL script

UPDATE [databasename].[dbo].[tblKartrisConfig]
SET CFG_Value = 'http://newdomainname'
WHERE CFG_Value = 'http://olddomainname'
GO

Once you have confirmed the change is successful, restart Kartris under Database Admin