Transferring Data [CFG_Value] Error

Posted By ianguest Thu 27 Mar 2014
Add to Favorites0
Author Message
ianguest
 Posted Thu 27 Mar 2014
Supreme Being

Supreme Being - (48,186 reputation)Supreme Being - (48,186 reputation)Supreme Being - (48,186 reputation)Supreme Being - (48,186 reputation)Supreme Being - (48,186 reputation)Supreme Being - (48,186 reputation)Supreme Being - (48,186 reputation)Supreme Being - (48,186 reputation)Supreme Being - (48,186 reputation)

Group: Forum Members
Last Active: Tue 31 Mar 2015
Posts: 68, Visits: 185
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

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top