Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 20:32

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Error after Shrink database. Help!!!

Discussion on Error after Shrink database. Help!!! within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Apr 2016
Posts: 289
Received Thanks: 67
Error after Shrink database. Help!!!

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_Log1);
DBCC SHRINKDATABASE (SRO_VT_SHARD,0);
GO 
This is my video which record problem

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



Thank's!
hoangphan7 is offline  
Old 06/04/2018, 19:24   #2
 
#HB's Avatar
 
elite*gold: 100
Join Date: Sep 2017
Posts: 1,110
Received Thanks: 907
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.
#HB is offline  
Old 06/05/2018, 00:12   #3
 
elite*gold: 0
Join Date: Apr 2016
Posts: 289
Received Thanks: 67
Quote:
Originally Posted by #HB View Post
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
hoangphan7 is offline  
Old 06/05/2018, 00:19   #4
 
#HB's Avatar
 
elite*gold: 100
Join Date: Sep 2017
Posts: 1,110
Received Thanks: 907
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.
#HB is offline  
Old 06/06/2018, 00:43   #5
 
elite*gold: 0
Join Date: Jan 2009
Posts: 250
Received Thanks: 23
Why asking for help if u does not listin in the first place.. ��
killerflood is offline  
Old 06/06/2018, 06:00   #6
 
elite*gold: 0
Join Date: Apr 2016
Posts: 289
Received Thanks: 67
Quote:
Originally Posted by #HB View Post
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 View Post
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!
hoangphan7 is offline  
Old 06/06/2018, 14:43   #7
 
#HB's Avatar
 
elite*gold: 100
Join Date: Sep 2017
Posts: 1,110
Received Thanks: 907
Then don't shrink it. Although I am pretty sure the shrinking isn't even related to tables or your problem.
#HB is offline  
Reply


Similar Threads Similar Threads
[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



All times are GMT +1. The time now is 20:33.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.