i get some problem, i need help! sry for my english.
I Use Vsro 1.188 Orign (Clean)
My error happend after i Shrink Database! Before, it's working fine!
I can't buy item in 2 group mall (avatar and pet mall)
if i move tab in group mall to other group in mall like Premium or Consume, all item inside can't buy!
I Use this query to Shrink Database
PHP Code:
USE SRO_VT_SHARD;
GO
-- Truncate the log by changing the database recovery model to SIMPLE.
ALTER DATABASE SRO_VT_SHARD
SET RECOVERY SIMPLE;
GO
-- Shrink the truncated log file to 1 MB.
DBCC SHRINKFILE (SRO_VT_SHARD_Log, 1);
DBCC SHRINKDATABASE (SRO_VT_SHARD,0);
GO
That's not because of "shrink blablabla" because that query shows that it doesn't touch any table, that's just a missing refshopgoods in database.
The items aren't really in the item mall but the client shows them, because client's refshopgoods have things doesn't really exist in database.
There's a way to fix all items in shops and item mall, but this way has only 40% to succeed. Someguy had the same problem like yours but in shops too, I told him the way and it worked with him.
The way is to clean database's refshopgoods/refpricepolicy/refscrap/refpackage and copy them from media into database.
NOTE: If you'd like to try that way, I prefer to make back-up before you do it dodging any screwed up bugs.
That's not because of "shrink blablabla" because that query shows that it doesn't touch any table, that's just a missing refshopgoods in database.
The items aren't really in the item mall but the client shows them, because client's refshopgoods have things doesn't really exist in database.
There's a way to fix all items in shops and item mall, but this way has only 40% to succeed. Someguy had the same problem like yours but in shops too, I told him the way and it worked with him.
The way is to clean database's refshopgoods/refpricepolicy/refscrap/refpackage and copy them from media into database.
NOTE: If you'd like to try that way, I prefer to make back-up before you do it dodging any screwed up bugs.
Thank's for reply!
My old database working fine! After i shrink database, i got this error (tested). All refshopgoods/refpricepolicy/refscrap/refpackage are correctly ^^~ idk why error happend.
Im in vsro dev ~5year. It's the first time i got this error.
F#ck my eye
BTW you didn't even check out if the items in the media are in the database. You can check it with VSRO NPC program, because it shows the NPC as showed in the database.
Anyways, I told you you the answer and you pick up what you want.
BTW you didn't even check out if the items in the media are in the database. You can check it with VSRO NPC program, because it shows the NPC as showed in the database.
Anyways, I told you you the answer and you pick up what you want.
Quote:
Originally Posted by killerflood
Why asking for help if u does not listin in the first place.. ��
Thank's all. I already tried this method and check all line in 4tab shop. Nothing wrong!...
I tried restore old database (with no error, all item in F10 buy able). Then I shrink database and error back again!
[S] "Shrink" Geld verdien Seite 10/28/2012 - Off Topic - 0 Replies Nabend :)
Und zwar suche ich eine Seite wo ich einen Link kürzen kann und dann einen Werbungslink habe für den ich ungefähr 5$+/k Klicks erhalte.
Vielleicht kennt Ihr ja mehr als ich:
*adfly
*adfoc
