Error after Shrink database. Help!!!

[hoangphan7]

Hello epvpers!

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 


This is my video which record problem

https://www.youtube.com/watch?v=ql7ku7uUwrQ

Thank's!

[#HB]

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.

[hoangphan7]

Originally Posted by #HB

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

[#HB]

And I know what I am saying too!

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.

[killerflood]

Why asking for help if u does not listin in the first place.. ��

[hoangphan7]

Originally Posted by #HB

And I know what I am saying too!

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.

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!

[#HB]

Then don't shrink it. Although I am pretty sure the shrinking isn't even related to tables or your problem.