Hope you have adjusted and added new items to the shop with already existing items, if yes, continue reading:
First of all, make a backup of your existing text-files of your silkroad client.
refpackageitem.txt, refpricepolicyofitem.txt, refscrapofpackageitem.txt and refshopgoods.txt.
Copy them somewhere else.
Open them and delete whatever is inside.
Execute this simply query:
PHP Code:
USE SRO_VT_SHARD
SELECT * FROM _RefPackageItem
WHERE Service = 1
ORDER BY [ID]
SELECT * FROM _RefPricePolicyOfItem
WHERE Service = 1
SELECT * FROM _RefScrapOfPackageItem
WHERE Service = 1
ORDER BY [Index]
SELECT * FROM _RefShopGoods
WHERE Service = 1
And copy those entries to their respective text files (from _RefPackageItem to refpackageitem.txt, and so on).
Save them and start the client while the server is running.
Still nothing working? Hope you have made a backup before deleting every shop item and adding new ones afterwards to your database.