Error after Shrink database. Help!!!

06/03/2018 18:11 hoangphan7#1

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

[Only registered and activated users can see links. Click Here To Register...]

Thank's!

06/04/2018 19:24 #HB#2

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.

06/05/2018 00:12 hoangphan7#3

Quote:

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

06/05/2018 00:19 #HB#4

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.

06/06/2018 00:43 killerflood#5

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

06/06/2018 06:00 hoangphan7#6

Quote:

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.

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!

06/06/2018 14:43 #HB#7

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