Restore DB Pangya Server 4.9 TH and Guide I bad EN

[Analezey]

I want PICTRUE For Guide
Since Install SQL SETUP SQL 2005&2008

Edit My server Config IP
And Projectg.exe ? Hex

Setup Server

I finish Server 80%
Run Error

[MentaL]

[mrNickname]

1. Uncompressed ProjectG can be download from the original Server Repack topic. Google for Hex Editor Neo free edition. Use it find and change the client version to '582.05'. Goto SQL Pangya_S4_TH > dbo.Pangya_Server_Config set Server value '1.0' and Client '582.05'. Edit those so you can create room/lounge.

2. And you missed ODBC setup which is in '\Control Panel\All Control Panel Items\Administrative Tools\ODBC'. Read Tsukasa's guide for it: http://forum.ragezone.com/f200/commo...stions-715711/

If you are running W7 you need Professional or Ultimate edition to have ODBC feature i think.

[Analezey]

1. Uncompressed ProjectG can be download from the original Server Repack topic. Google for Hex Editor Neo free edition. Use it find and change the client version to '582.05'. Goto SQL Pangya_S4_TH > dbo.Pangya_Server_Config set Server value '1.0' and Client '582.05'. Edit those so you can create room/lounge.

2. And you missed ODBC setup which is in '\Control Panel\All Control Panel Items\Administrative Tools\ODBC'. Read Tsukasa's guide for it: http://forum.ragezone.com/f200/commo...stions-715711/

If you are running W7 you need Professional or Ultimate edition to have ODBC feature i think.

^^^^
Finish 100%

runServer Error

Thank

[mrNickname]

What's the error? Please post Login and GameServer logs, use code tag to warp it here.

[Analezey]

I Check DB ERROR 60%
I Request PANGYA_S4_TH.sql Fix For SQL2005
INI3_BILLDB Fix For SQL2005
INI3_ACCOUNT Fix For SQL2005

[mrNickname]

I'm going to upload my release anyway as a decent release after the repack. It works for SQL2008 and should too with SQL2005.

I'll probably post it today or tomorrow.

[Analezey]

Msg 15023, Level 16, State 1, Line 3
User, group, or role 'payletter' already exists in the current database.
Msg 15023, Level 16, State 1, Line 3
User, group, or role 'Pangya_TH' already exists in the current database.
Msg 15023, Level 16, State 1, Line 3
User, group, or role 'ini3webstat' already exists in the current database.
Msg 15023, Level 16, State 1, Line 3
User, group, or role 'ini3web' already exists in the current database.
Msg 2714, Level 16, State 6, Line 1
There is already an object named 'TD_CHAR_EQUIP_S4' in the database.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Item' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Item' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Item' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 2714, Level 16, State 3, Procedure USP_CARD_GET_LIST, Line 11
There is already an object named 'USP_CARD_GET_LIST' in the database.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 1921, Level 16, State 1, Line 3
Invalid filegroup 'Pangya_S4_TH_Mail' specified.
Msg 2714, Level 16, State 3, Procedure USP_CHAR_EQUIP_SAVE_S4, Line 229
There is already an object named 'USP_CHAR_EQUIP_SAVE_S4' in the database.
Msg 2714, Level 16, State 3, Procedure USP_CHAR_EQUIP_UCC_S4, Line 39
There is already an object named 'USP_CHAR_EQUIP_UCC_S4' in the database.
Msg 2714, Level 16, State 3, Procedure USP_CHAR_EQUIP_LOAD_S4, Line 13
There is already an object named 'USP_CHAR_EQUIP_LOAD_S4' in the database.
Msg 208, Level 16, State 1, Procedure UVW_USER_ITEM, Line 6
Invalid object name 'DBO.PangYa_Character_Information'.
Msg 208, Level 16, State 1, Procedure UVW_ENCHANT_PANG, Line 5
Invalid object name 'PANGYA_ITEM_WAREHOUSE'.
Msg 2714, Level 16, State 3, Procedure USP_TUTORIAL_GET_STATUS, Line 10
There is already an object named 'USP_TUTORIAL_GET_STATUS' in the database.
Msg 2714, Level 16, State 3, Procedure USP_NICKNAME_UPDATE, Line 11
There is already an object named 'USP_NICKNAME_UPDATE' in the database.
Msg 2714, Level 16, State 3, Procedure USP_CARD_LIST, Line 11
There is already an object named 'USP_CARD_LIST' in the database.
Msg 1767, Level 16, State 0, Line 3
Foreign key 'FK_TD_MAIL_LOG_RET_TA_MAIL_SENDERR_ACC_ERR_CD' references invalid table 'dbo.TA_MAIL_SENDERR_ACC'.
Msg 1750, Level 16, State 0, Line 3
Could not create constraint. See previous errors.
Msg 4917, Level 16, State 0, Line 1
Constraint 'FK_TD_MAIL_LOG_RET_TA_MAIL_SENDERR_ACC_ERR_CD' does not exist.
Msg 4916, Level 16, State 0, Line 1
Could not enable or disable the constraint. See previous errors.

---------- Post added at 08:48 PM ---------- Previous post was at 08:46 PM ----------

i use SQL 2005
I don't Know Excute SQL file
Request for Guide

[Analezey]

Original File Error code

Msg 7202, Level 11, State 2, Procedure UP_NT_MB_CHECK_PLAY, Line 76
Could not find server 'BOOMZDB1' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_NT_CREP_DTC_TEST, Line 10
Could not find server 'BRACCOUNTTEST' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_NT_MB_YG_ACCOUNT_UPD_GAME, Line 32
Could not find server 'YTDB' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_NT_MB_SILKACCOUNT_UPD_BUY, Line 18
Could not find server 'BRACCOUNTDB' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_TX_MB_WAR2S1_OTHERLOG_DEPLOY, Line 151
Could not find server 'ONLINE' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_TX_MB_WAR2S1_ITEMBUYLOG_DEPLOY, Line 141
Could not find server 'ONLINE' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 137, Level 15, State 2, Procedure UP_TX_MB_EXCHG_BYGAMEEVENT, Line 630
Must declare the scalar variable "@pi_strSiteCodeAND".
Msg 7202, Level 11, State 2, Procedure UP_TX_MB_WAR2S2_ITEMBUYLOG_DEPLOY, Line 141
Could not find server 'ONLINE' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_TX_MB_WAR2S2_OTHERLOG_DEPLOY, Line 148
Could not find server 'ONLINE' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_TX_MB_WAR2S4_ITEMBUYLOG_DEPLOY, Line 143
Could not find server 'ONLINE' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_TX_MB_WAR2S4_OTHERLOG_DEPLOY, Line 153
Could not find server 'ONLINE' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_TX_MB_WAR2S3_OTHERLOG_DEPLOY, Line 152
Could not find server 'ONLINE' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_TX_MB_WAR2S3_ITEMBUYLOG_DEPLOY, Line 142
Could not find server 'ONLINE' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 102, Level 15, State 1, Procedure UP_NT_MB_PURCHASE_CANCEL, Line 393
Incorrect syntax near 'TITEMHOLDMST'.
Msg 102, Level 15, State 1, Procedure UP_NT_MB_PURCHASE_CANCEL, Line 557
Incorrect syntax near 'RETURN'.
Msg 7202, Level 11, State 2, Procedure UP_NT_MB_BOOMZ2_DONATIONCOOKIE, Line 62
Could not find server 'boomzdb2' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_NT_MB_BOOMZ1_DONATIONCOOKIE, Line 60
Could not find server 'boomzdb1' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 102, Level 15, State 1, Procedure UP_TX_MB_YG_GRANT_BYUL, Line 239
Incorrect syntax near 'RETURNEND'.
Msg 102, Level 15, State 1, Procedure UP_TX_MB_YG_GRANT_BYUL, Line 302
Incorrect syntax near 'RETURN'.
Msg 7202, Level 11, State 2, Procedure UP_NT_BT_MAKESYNC_YOGURTING, Line 79
Could not find server 'YTDB' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_NT_MB_BOOMZ1_COOKIEUSE_V2, Line 50
Could not find server 'BOOMZDB1' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_NT_MB_BOOMZ2_COOKIEUSE_V2, Line 49
Could not find server 'BOOMZDB2' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_TX_MB_BOOMZ1_LOGWEALTH, Line 48
Could not find server 'BOOMZDB1' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_TX_MB_BOOMZ1_AUCTIONCOOKIE, Line 46
Could not find server 'BOOMZDB1' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_TX_MB_BOOMZ1_WEDDING_LOG, Line 49
Could not find server 'boomzdb1' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 102, Level 15, State 1, Procedure UP_NT_MB_YG_CHARGE_ITEM, Line 128
Incorrect syntax near ','.
Msg 102, Level 15, State 1, Procedure UP_NT_MB_YG_CHARGE_ITEM, Line 247
Incorrect syntax near 'RETURN'.
Msg 7202, Level 11, State 2, Procedure UP_TX_MB_BOOMZ2_AUCTIONCOOKIE, Line 49
Could not find server 'BOOMZDB2' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_TX_MB_BOOMZ2_WEDDING_LOG, Line 48
Could not find server 'boomzdb2' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_TX_MB_BOOMZ2_LOGWEALTH, Line 49
Could not find server 'BOOMZDB2' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_TX_MB_BOOMZ1_EXTRA_LOG, Line 50
Could not find server 'BOOMZDB1' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_TX_MB_BOOMZ2_EXTRA_LOG, Line 51
Could not find server 'BOOMZDB2' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 102, Level 15, State 1, Procedure UP_TX_MB_YG_CHARGE_CANCEL, Line 123
Incorrect syntax near 'YGCOOKIEAMT'.
Msg 7202, Level 11, State 2, Procedure UP_NT_MB_ACCOUNT_INS, Line 36
Could not find server 'BOOMZDB1' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_NT_MB_SILKACCOUNT_UPD, Line 29
Could not find server 'BRACCOUNTDB' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_TX_MB_WAR2S1_FREECOOKIELOG_DEPLOY, Line 111
Could not find server 'ONLINE' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_TX_MB_WAR2S2_FREECOOKIELOG_DEPLOY, Line 106
Could not find server 'ONLINE' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_TX_MB_WAR2S3_FREECOOKIELOG_DEPLOY, Line 114
Could not find server 'ONLINE' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Msg 7202, Level 11, State 2, Procedure UP_TX_MB_WAR2S4_FREECOOKIELOG_DEPLOY, Line 114
Could not find server 'ONLINE' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.

How to edit

If the wrong code Ini3_Billdb I want to INI3_BILLDB.sql Fix!.

Thanks
I used Google Translate TH >> EN
I bad EN

[mrNickname]

Ah.. you must have used the first release, download the repack it has INI3Bill_DB.sql with no error.

[Analezey]

rename DB >>> INI3bill_Db

---------- Post added at 11:35 PM ---------- Previous post was at 11:30 PM ----------

Run Emu Error
You have INI3Bill_DB Fix ?

Pix >>> Error

http://upic.me/i/od/af3sf.jpg
Thanks

---------- Post added at 11:41 PM ---------- Previous post was at 11:35 PM ----------

http://upic.me/i/73/9pjsd.jpg

[Tsukasa]

One more double post, one more picture-only post and I will close this thread.

Be descriptive, if you do not speak English - bad luck for you.

[mrNickname]

Hmm nothing unusual i can see from that pic. And pretty much the wrong place to look for real errors. Those red text on consoles doesn't show error, it just slow on the SQL queries that's all.