Please read attachment. Something's wrong with that missing dbo, need a fix. Could someone help? =.=;
Printable View
Please read attachment. Something's wrong with that missing dbo, need a fix. Could someone help? =.=;
you need to create the odbs
Create it in PANGYA_S4_TH database or? And do i need to add some information into the table etc?
you need to create the odbc
Ah the ODBC, i misread the first reply. Anyway should i create in User DNS or System DNS?
And must i change the default database to those 3 pangya databases?
Sorry i'm newb to MSSQL setup =.= hopefully i can learn more if i can get this right.
EDIT: Well nvm i fixed the problems by reading the server ini file, now how can i create new account and make the Client connect to my server? The game client with the 127.0.0.1 hex still report as "Please reinstall or run the updater" etc..
mrNickName, you have to bootstrap the client a bit when using offline updates only.
Run the following batch file and you should be fine:
Code:@echo off
REG ADD HKLM\SOFTWARE\Ntreev\PangYa_Th /v Patcher /t REG_EXPAND_SZ /d "update.exe"
REG ADD HKLM\SOFTWARE\Ntreev\PangYa_Th /v PatchNum /t REG_EXPAND_SZ /d "185"
REG ADD HKLM\SOFTWARE\Ntreev\PangYa_Th /v IntegratedPak /t REG_EXPAND_SZ /d "projectg500+.pak"
REG ADD HKLM\SOFTWARE\Ntreev\PangYa_Th /v Ver /t REG_EXPAND_SZ /d "TH.R4.583.02"
Whoow! That's a big help Tsukasa, i skipped using updater.exe just launch ProjectG.exe and boot to login screen. But lagged badly due to running USPangya and private client together.
With database, servers and client running 100% the final question would be how to create usernames and make it admin or GM?
Please see the newly-created Common beginner questions thread.
Thanks again, i needed more info on that Create User area that i have no idea what to fill in properly.
(See Attachment)
idcard: I treat this as an increasing int, starting from 1 I always increase the value by 1 for every account.
sex: 0 = Male, 1 = Female
birthday: Necessary, format is YYYYMMDD, i.e. 19801224
zipcode: 00000 sounds like a great area to live in ;)
id: The account login name, i.e. tsukasa or mrnickname
pswd: No explanation necessary...
Fail, even deleted the entire databases and re-create everything and still having this same issue.
I tried to edit Visa_Ref but the options are greyed out.
As stated in the linked post you need to alter the table.
- Generate the CREATE TABLE statement for Ini3_UserLogin
- Edit the CREATE TABLE statement for Ini3_UserLogin, replace the NOT NULL statements with NULL statements for the problematic fields
- Drop Ini3_UserLogin
- Run the edited CREATE TABLE query to regenerate the table
Thanks Tsukasa, i actually went to eat, got so hungry working on it for 6 hrs xD From your procedures it seems confusing, but during my exploration i found out:
1. Right click on dbo.Ini3_UserLogin's 'Columns' folder and 'New Columns'.
2. Add new Column name 'Visa_Ref2', same data type and Allow Null and save.
3. Delete the original un-editable 'Visa_Ref' and rename Visa_Ref2 to Visa_Ref.
Voila~ Now i'm able to create username and activated with no error. Next i logged in but no Channel ROFLMAO RAWR! I read from your 'wikipedia' that says retry will work, i'll try a few more times if nothing works imma come back with my long face ;P
To create the user runs this query she had created all userQuote:
Originally Posted by mrNickname
USE [master]
GO
/*******************************************
Pangya Server 4.9 Database * * Bootstrapper
*
* Use at your own risk! *
*
Please edit the @ * is * DBUSER_PASSWORD
* Your server. Leaving the default * Simply
* Isn't cool. *
*
* USAGE: *
* 1. Run this query *
* 2. Run INI3_BILLDB.sql *
* 3. Run INI3_PY_ACCOUNT.sql *
* 4. Run Pangya_S4_TH.sql *
* 5. ?? (Add / Alter procedures, etc.). *
*******************************************/
DECLARE @ DBUSER_PASSWORD VARCHAR (256)
DECLARE @ DBUSER_CREATE_SQL NVARCHAR (256)
SET @ DBUSER_PASSWORD N'Password = '
/ * =========== =========== * Create users /
IF NOT EXISTS (SELECT loginname FROM WHERE name = dbo.syslogins N'ini3web ')
BEGIN
SELECT @ DBUSER_CREATE_SQL = 'CREATE LOGIN [ini3web] WITH PASSWORD =''' + @ DBUSER_PASSWORD +''', DEFAULT_DATABASE = [master], CHECK_EXPIRATION = OFF, OFF = CHECK_POLICY'
EXEC sp_executesql @ DBUSER_CREATE_SQL
END
ELSE
PRINT 'User ini3web already exists, skipping creation ...'
IF NOT EXISTS (SELECT loginname FROM WHERE name = dbo.syslogins N'ini3gamebr ')
BEGIN
SELECT @ DBUSER_CREATE_SQL = 'CREATE LOGIN [ini3gamebr] WITH PASSWORD =''' + @ DBUSER_PASSWORD +''', DEFAULT_DATABASE = [master], CHECK_EXPIRATION = OFF, OFF = CHECK_POLICY'
EXEC sp_executesql @ DBUSER_CREATE_SQL
END
ELSE
PRINT 'User ini3gamebr already exists, skipping creation ...'
IF NOT EXISTS (SELECT loginname FROM WHERE name = dbo.syslogins N'ini3webstat ')
BEGIN
SELECT @ DBUSER_CREATE_SQL = 'CREATE LOGIN [ini3webstat] WITH PASSWORD =''' + @ DBUSER_PASSWORD +''', DEFAULT_DATABASE = [master], CHECK_EXPIRATION = OFF, OFF = CHECK_POLICY'
EXEC sp_executesql @ DBUSER_CREATE_SQL
END
ELSE
PRINT 'User ini3webstat already exists, skipping creation ...'
IF NOT EXISTS (SELECT loginname FROM WHERE name = dbo.syslogins N'pangya ')
BEGIN
SELECT @ DBUSER_CREATE_SQL = 'CREATE LOGIN [pangya] WITH PASSWORD =''' + @ DBUSER_PASSWORD +''', DEFAULT_DATABASE = [master], CHECK_EXPIRATION = OFF, OFF = CHECK_POLICY'
EXEC sp_executesql @ DBUSER_CREATE_SQL
END
ELSE
PRINT 'User pangya already exists, skipping creation ...'
IF NOT EXISTS (SELECT loginname FROM WHERE name = dbo.syslogins N'Pangya_TH ')
BEGIN
SELECT @ DBUSER_CREATE_SQL = 'CREATE LOGIN [Pangya_TH] WITH PASSWORD =''' + @ DBUSER_PASSWORD +''', DEFAULT_DATABASE = [master], CHECK_EXPIRATION = OFF, OFF = CHECK_POLICY'
EXEC sp_executesql @ DBUSER_CREATE_SQL
END
ELSE
PRINT 'User Pangya_TH already exists, skipping creation ...'
IF NOT EXISTS (SELECT loginname FROM WHERE name = dbo.syslogins N'Biller ')
BEGIN
SELECT @ DBUSER_CREATE_SQL = 'CREATE LOGIN [Biller] WITH PASSWORD =''' + @ DBUSER_PASSWORD +''', DEFAULT_DATABASE = [master], CHECK_EXPIRATION = OFF, OFF = CHECK_POLICY'
EXEC sp_executesql @ DBUSER_CREATE_SQL
END
ELSE
PRINT 'User Biller already exists, skipping creation ...'
IF NOT EXISTS (SELECT loginname FROM WHERE name = dbo.syslogins N'pangyaclub ')
BEGIN
SELECT @ DBUSER_CREATE_SQL = 'CREATE LOGIN [pangyaclub] WITH PASSWORD =''' + @ DBUSER_PASSWORD +''', DEFAULT_DATABASE = [master], CHECK_EXPIRATION = OFF, OFF = CHECK_POLICY'
EXEC sp_executesql @ DBUSER_CREATE_SQL
END
ELSE
PRINT 'User pangyaclub already exists, skipping creation ...'
IF NOT EXISTS (SELECT loginname FROM WHERE name = dbo.syslogins N'payletter ')
BEGIN
SELECT @ DBUSER_CREATE_SQL = 'CREATE LOGIN [payletter] WITH PASSWORD =''' + @ DBUSER_PASSWORD +''', DEFAULT_DATABASE = [master], CHECK_EXPIRATION = OFF, OFF = CHECK_POLICY'
EXEC sp_executesql @ DBUSER_CREATE_SQL
END
ELSE
PRINT 'User payletter already exists, skipping creation ...'
IF NOT EXISTS (SELECT loginname FROM WHERE name = dbo.syslogins N'yogurting ')
BEGIN
SELECT @ DBUSER_CREATE_SQL = 'CREATE LOGIN [yogurting] WITH PASSWORD =''' + @ DBUSER_PASSWORD +''', DEFAULT_DATABASE = [master], CHECK_EXPIRATION = OFF, OFF = CHECK_POLICY'
EXEC sp_executesql @ DBUSER_CREATE_SQL
END
ELSE
PRINT 'User yogurting already exists, skipping creation ...'
/ * For people using the database we need a modified Monk user * /
IF NOT EXISTS (SELECT loginname FROM WHERE name = dbo.syslogins N'Monk ')
BEGIN
SELECT @ DBUSER_CREATE_SQL = 'CREATE LOGIN [Monk] WITH PASSWORD =''' + @ DBUSER_PASSWORD +''', DEFAULT_DATABASE = [master], CHECK_EXPIRATION = OFF, OFF = CHECK_POLICY'
EXEC sp_executesql @ DBUSER_CREATE_SQL
END
ELSE
PRINT 'Monk User already exists, skipping creation ...'
/ * =========== =========== Ini3_py_account * /
IF EXISTS (SELECT name FROM WHERE name = sys.databases N'ini3_py_account ')
BEGIN
ALTER DATABASE [ini3_py_account] SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE [ini3_py_account] SET ONLINE
DROP DATABASE [ini3_py_account]
END
/ * - Recreate Database - * /
CREATE DATABASE [ini3_py_account]
GO
/ * =========== =========== INI3Bill_DB * /
IF EXISTS (SELECT name FROM WHERE name = sys.databases N'INI3Bill_DB ')
BEGIN
ALTER DATABASE [INI3Bill_DB] SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE [INI3Bill_DB] SET ONLINE
DROP DATABASE [INI3Bill_DB]
END
/ * - Recreate Database - * /
CREATE DATABASE [INI3Bill_DB]
GO
/ * =========== =========== Pangya_S4_TH * /
IF EXISTS (SELECT name FROM WHERE name = sys.databases N'Pangya_S4_TH ')
BEGIN
/ * - Close all connections and drop the database - * /
ALTER DATABASE [Pangya_S4_TH] SET OFFLINE WITH ROLLBACK IMMEDIATE
ALTER DATABASE [Pangya_S4_TH] SET ONLINE
DROP DATABASE [Pangya_S4_TH]
END
/ * - Recreate Database - * /
CREATE DATABASE [Pangya_S4_TH]
DECLARE @ DATABASE_PATH VARCHAR (256)
SELECT @ = DATABASE_PATH physical_name
FROM sys.master_files
WHERE name = N'Pangya_S4_TH '
SET @ DATABASE_PATH = REPLACE (@ DATABASE_PATH, 'Pangya_S4_TH.mdf','')
PRINT 'Pangya_S4_TH database reside at:' + @ DATABASE_PATH
/ * --- Add File Groups and Files to the database Pangya_S4_TH --- * /
DECLARE @ ADDFILE_CARD_SQL varchar (256)
DECLARE @ ADDFILE_GLOG_SQL varchar (256)
DECLARE @ ADDFILE_ITEM_SQL varchar (256)
DECLARE @ ADDFILE_MAIL_SQL varchar (256)
SET @ ADDFILE_CARD_SQL = 'ALTER DATABASE [Pangya_S4_TH] ADD File (Pangya_S4_TH_Card NAME =, FILENAME = N''' + @ DATABASE_PATH + '\''Pangya_S4_TH_Card.mdf, SIZE = 1MB) TO FILEGROUP Pangya_S4_TH_Card'
SET @ ADDFILE_GLOG_SQL = 'ALTER DATABASE [Pangya_S4_TH] ADD File (Pangya_S4_TH_gLog NAME =, FILENAME = N''' + @ DATABASE_PATH + '\''Pangya_S4_TH_gLog.mdf, SIZE = 1MB) TO FILEGROUP Pangya_S4_TH_gLog'
SET @ ADDFILE_ITEM_SQL = 'ALTER DATABASE [Pangya_S4_TH] ADD File (Pangya_S4_TH_Item NAME =, FILENAME = N''' + @ DATABASE_PATH + '\''Pangya_S4_TH_Item.mdf, SIZE = 1MB) TO FILEGROUP Pangya_S4_TH_Item'
SET @ ADDFILE_MAIL_SQL = 'ALTER DATABASE [Pangya_S4_TH] ADD File (Pangya_S4_TH_Mail NAME =, FILENAME = N''' + @ DATABASE_PATH + '\''Pangya_S4_TH_Mail.mdf, SIZE = 1MB) TO FILEGROUP Pangya_S4_TH_Mail'
ALTER DATABASE [Pangya_S4_TH] ADD FILEGROUP Pangya_S4_TH_Card;
ALTER DATABASE [Pangya_S4_TH] ADD FILEGROUP Pangya_S4_TH_gLog;
ALTER DATABASE [Pangya_S4_TH] ADD FILEGROUP Pangya_S4_TH_Item;
ALTER DATABASE [Pangya_S4_TH] ADD FILEGROUP Pangya_S4_TH_Mail;
EXEC (@ ADDFILE_CARD_SQL)
EXEC (@ ADDFILE_GLOG_SQL)
EXEC (@ ADDFILE_ITEM_SQL)
EXEC (@ ADDFILE_MAIL_SQL)
GO
Thanks Kim that is for creating the databases and i got that installed. But from now the channel won't show up no matter how i edit the Server.ini, there no showing any error on the consoles where could the problem be...
USE [Pangya_S4_TH]Quote:
Originally Posted by mrNickname
GO
CREATE PROC [dbo].[USP_CHAR_EQUIP_LOAD_S4] (
@UID INT
)
AS
BEGIN
SET NOCOUNT ON
IF ( @UID > 0 ) BEGIN
SELECT X.ITEM_ID
, TYPEID
/* new */
, ITEMID_PARTS_1
, ITEMID_PARTS_2
, ITEMID_PARTS_3
, ITEMID_PARTS_4
, ITEMID_PARTS_5
, ITEMID_PARTS_6
, ITEMID_PARTS_7
, ITEMID_PARTS_8
, ITEMID_PARTS_9
, ITEMID_PARTS_10
, ITEMID_PARTS_11
, ITEMID_PARTS_12
, ITEMID_PARTS_13
, ITEMID_PARTS_14
, ITEMID_PARTS_15
, ITEMID_PARTS_16
, ITEMID_PARTS_17
, ITEMID_PARTS_18
, ITEMID_PARTS_19
, ITEMID_PARTS_20
, ITEMID_PARTS_21
, ITEMID_PARTS_22
, ITEMID_PARTS_23
, ITEMID_PARTS_24
/* new */
, PARTS_1
, PARTS_2
, PARTS_3
, PARTS_4
, PARTS_5
, PARTS_6
, PARTS_7
, PARTS_8
, PARTS_9
, PARTS_10
, PARTS_11
, PARTS_12
, PARTS_13
, PARTS_14
, PARTS_15
, PARTS_16
, PARTS_17
, PARTS_18
, PARTS_19
, PARTS_20
, PARTS_21
, PARTS_22
, PARTS_23
, PARTS_24
, AUXPARTS_1
, AUXPARTS_2
, AUXPARTS_3
, AUXPARTS_4
, AUXPARTS_5
, DEFAULT_HAIR
, DEFAULT_SHIRTS
, GIFT_FLAG
, PCL0
, PCL1
, PCL2
, PCL3
, PCL4
, PURCHASE
FROM (
SELECT
ITEM_ID
, TYPEID
, PARTS_1
, PARTS_2
, PARTS_3
, PARTS_4
, PARTS_5
, PARTS_6
, PARTS_7
, PARTS_8
, PARTS_9
, PARTS_10
, PARTS_11
, PARTS_12
, PARTS_13
, PARTS_14
, PARTS_15
, PARTS_16
, PARTS_17
, PARTS_18
, PARTS_19
, PARTS_20
, PARTS_21
, PARTS_22
, PARTS_23
, PARTS_24
, AUXPARTS_1
, AUXPARTS_2
, AUXPARTS_3
, AUXPARTS_4
, AUXPARTS_5
, DEFAULT_HAIR
, DEFAULT_SHIRTS
, GIFT_FLAG
, PCL0
, PCL1
, PCL2
, PCL3
, PCL4
, PURCHASE
FROM DBO.PANGYA_CHARACTER_INFORMATION WITH (NOLOCK)
WHERE UID = @UID
) X
INNER JOIN
(
SELECT
ITEM_ID
, ITEMID_PARTS_1 = MAX(CASE WHEN EQUIP_NUM = 1 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_2 = MAX(CASE WHEN EQUIP_NUM = 2 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_3 = MAX(CASE WHEN EQUIP_NUM = 3 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_4 = MAX(CASE WHEN EQUIP_NUM = 4 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_5 = MAX(CASE WHEN EQUIP_NUM = 5 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_6 = MAX(CASE WHEN EQUIP_NUM = 6 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_7 = MAX(CASE WHEN EQUIP_NUM = 7 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_8 = MAX(CASE WHEN EQUIP_NUM = 8 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_9 = MAX(CASE WHEN EQUIP_NUM = 9 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_10 = MAX(CASE WHEN EQUIP_NUM = 10 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_11 = MAX(CASE WHEN EQUIP_NUM = 11 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_12 = MAX(CASE WHEN EQUIP_NUM = 12 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_13 = MAX(CASE WHEN EQUIP_NUM = 13 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_14 = MAX(CASE WHEN EQUIP_NUM = 14 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_15 = MAX(CASE WHEN EQUIP_NUM = 15 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_16 = MAX(CASE WHEN EQUIP_NUM = 16 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_17 = MAX(CASE WHEN EQUIP_NUM = 17 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_18 = MAX(CASE WHEN EQUIP_NUM = 18 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_19 = MAX(CASE WHEN EQUIP_NUM = 19 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_20 = MAX(CASE WHEN EQUIP_NUM = 20 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_21 = MAX(CASE WHEN EQUIP_NUM = 21 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_22 = MAX(CASE WHEN EQUIP_NUM = 22 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_23 = MAX(CASE WHEN EQUIP_NUM = 23 THEN ITEMID ELSE 0 END)
, ITEMID_PARTS_24 = MAX(CASE WHEN EQUIP_NUM = 24 THEN ITEMID ELSE 0 END)
FROM (
SELECT
ITEM_ID
, TYPEID
, PARTS_1
, PARTS_2
, PARTS_3
, PARTS_4
, PARTS_5
, PARTS_6
, PARTS_7
, PARTS_8
, PARTS_9
, PARTS_10
, PARTS_11
, PARTS_12
, PARTS_13
, PARTS_14
, PARTS_15
, PARTS_16
, PARTS_17
, PARTS_18
, PARTS_19
, PARTS_20
, PARTS_21
, PARTS_22
, PARTS_23
, PARTS_24
FROM DBO.PANGYA_CHARACTER_INFORMATION WITH (NOLOCK)
WHERE UID = @UID
) A
LEFT OUTER JOIN
(
SELECT CHAR_ITEMID, ITEMID, TYPEID, EQUIP_NUM
FROM TD_CHAR_EQUIP_S4 WITH (NOLOCK)
WHERE UID = @UID
--AND ITEMID > 0
AND USE_YN = 'Y'
) B
ON A.ITEM_ID = B.CHAR_ITEMID
GROUP BY ITEM_ID
) Y
ON X.ITEM_ID = Y.ITEM_ID
END
END
Kim i have that package installed as well, and has nothing to do with the channel lol..
this creates does not change
Could you just paste your working Server.ini file? I want to run a diagnostic see where the problem lay.
[SERVERINFO]
VERSION="582.00"
LOCALIP="127.0.0.1"
PORT=20201
MAXUSER=1200
SERVERGUID=20201
SERVERNAME="PangyaKr"
PROPERTY=32
ICONINDEX=9
[CONFIG]
REFRESHTIME=10
MSNSERVER="127.0.0.1"
MSNPORT=10103
MSNSERVER="127.0.0.1"
MSNPORT=10103
MSNSERVER="127.0.0.1"
MSNPORT=10103
MSNLOCALPORT="127.0.0.1"
MSNLOCALIP=10102
[SERVER_AUTH]
SERVER_IP=127.0.0.1
IP="127.0.0.1"
PORT=7911
[RANK]
;RANKIP=127.0.0.1
RANKIP=127.0.0.1
RANKPORT=10105
[DATABASE]
DBIP="Pangya_S4_TH"
DBUSER="sa"
DBPASSWORD="masterkr"
[DATABASE_CASH]
DBIP="INI3BILL_DB"
DBUSER="sa"
DBPASSWORD="masterkr"
[OPTION]
TTL=-1
30S_HOLES = 10
ONEMANPLAY=2
GAMEGUARD_CHECK=0
CONNECTIONTIMELIVE=2
USER_STATE_TRACK_INTERVAL=3600000
LOGROOTDIR=C:\PANGYA_TEST\PY_LOGDIR
[CHANNELINFO]
NUM_CHANNEL=5
TYPE
ÀÏ¹Ý Ã¤³Î : TYPE_NORMAL = 1
30Àδëȸ Àü¿ë ä³Î : TYPE_30_CHANNEL = 1
[CHANNEL1]
NAME="Iniciante "
TYPE=1
MAXUSER=1000
[CHANNEL2]
NAME="Novato"
TYPE=70
MAXUSER=1000
[CHANNEL3]
NAME="Junior"
TYPE=1
MAXUSER=1000
[CHANNEL4]
NAME="Amador"
TYPE=1
MAXUSER=1000
[CHANNEL5]
NAME="Profissional"
TYPE=1
MAXUSER=1000
HELP
nr.2 INI3_BILLDB
Code:current object because it depends on the missing object 'dbo.UP_TX_MB_WAR2S1_FREECOOKIELOG_DEPLOY'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_TX_MB_WAR2S2_FREECOOKIELOG_DEPLOY'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_TX_MB_WAR2S1_ITEMBUYLOG_DEPLOY'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_TX_MB_WAR2S2_ITEMBUYLOG_DEPLOY'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_TX_MB_WAR2S1_OTHERLOG_DEPLOY'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_TX_MB_WAR2S2_OTHERLOG_DEPLOY'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_GCCASHSELL_CANCEL'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'UP_NT_MB_ACCOUNT_INFO4GAME'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_BYUL_CALC'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_LOG_INS'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_UPD'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_LOG_INS'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_UPD'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'UP_NT_MB_ACCOUNT_INFO'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_LOG_INS'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_UPD'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_GCACCOUNT_UPD'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_GCACCOUNT_INFO'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_GCACCOUNT_UPD'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_LOG_INS'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_UPD'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_LOG_INS'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_UPD'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_LOG_INS'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_UPD'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_LOG_INS'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_UPD'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_GIVE_FREE_COOKIE'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_LOG_INS'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_UPD'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_BYUL_CALC'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_LOG_INS'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_UPD'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'UP_NT_MB_ACCOUNT_INFO4GAME'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'UP_NT_MB_ACCOUNT_INFO4GAME'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_LOG_INS'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_YG_ACCOUNT_UPD'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'dbo.UP_NT_MB_GCACCOUNT_INFO'. The object will still be created.
nr.4 Pangya_S4_TH
Code:Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.USP_EVENT_POST'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.USP_EVENT_POST'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.USP_ROOM_DEFAULT_ITEM'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.PROCEVENTROOKIEF'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.PROCCHECKBIRTHDAYEVENT'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'USP_PANG_BONGDARI'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'USP_CARD_POP_S4'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.USP_MAIL_SEND'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.PROCPLAYTIMEPOINT_ADD_COMBO_INC'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.USP_MAIL_SEND'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.USP_MAIL_SEND'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.USP_MAIL_SEND'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.USP_MAIL_SEND'. The object will still be created.
Cannot add rows to sysdepends for the current object because it depends on the missing object 'DBO.USP_MAIL_SEND'. The object will still be created.
[ThaiLand]
Please abide by the rules and do not post the same post several times over multiple topics. If you're asking for help, please do so in the form of a somewhat complete English sentense.Quote:
Originally Posted by shinez
Also, please check the common beginner questions thread that explains the messages. Alternatively you can also read the release thread, which will do the same.
In a nutshell: Just ignore these messages. They indicate that the database isn't complete - a fact you should all know by now.
Thanks i tried but the same problem. I guess i'm running out of luck.
Study the gameserver logs for details. You should see an error message that'll help you to identify the problem (i.e. stored procedure missing or whatnot). As you probably have noticed there are several log-files created, so be sure to check them all.Quote:
Originally Posted by mrNickname
Code:USE [ini3_py_account]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[SP_PANGYA_REGIST]
@idcard = N'1',
@sex = 0,
@birthday = N'19900424',
@zipcode = N'33000',
@id = N'lifeme',
@pswd = N'lifeme'
SELECT 'Return Value' = @return_value
GO
Error
HELPCode:Msg 515, Level 16, State 2, Procedure SP_PANGYA_REGIST, Line 14
Cannot insert the value NULL into column 'Visa_Ref', table 'ini3_py_account.dbo.Ini3_UserLogin'; column does not allow nulls. INSERT fails.
The statement has been terminated.
(1 row(s) affected)
USE [INI3Bill_DB]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[hb_py_gp_apply_userinfo_in]
@iUser_No = 1, idx
@iUser_ID = N'admin', login
@iUser_ip = N'127.0.0.1',
@iDB_id = NULL,
@iItem_no = NULL,
@iOrder_no = NULL,
@iPersonal_no = NULL,
@iApply_type = N'K0',
@iAmount = 1000000 cookies
SELECT 'Return Value' = @return_value
GO
@Shinez drop your existing ini3_py_account database and create new one and fix the 'INI3_PY_ACCOUNT.sql' :
In 'ini3_py_account.sql' search and find [Visa_Ref] and [VisaIDCard] set both 'NOT NULL' to 'NULL' make sure you edit all of it, save and execute again to fix it.
@Kim, nice script for adding cookies :D
And for me.. i haven't work out a solution for the Channel not being displayed on my list. I don't know if client incompatible or what i started to suspect the server files and configs are somehow wrong. It seems like server DID send the list but client did not display it.. Ignore the first error on top because i forgot to do 'alluseropen'.
LOGIN SERVER LOG:
Code:2010-12-30 17:49:08 1 loginserver#1 13 Server OnConnected
2010-12-30 17:49:08 1 loginserver#1 13 ID:10101 TYPE:LOGIN CONN STATE:CONNECT DATA STATE:PINGPONG Block
2010-12-30 17:49:08 1 loginserver#1 13 Ping Free
2010-12-30 17:49:08 1 loginserver#1 13 ID:10101 TYPE:LOGIN CONN STATE:CONNECT DATA STATE:PONG Block
2010-12-30 17:49:08 1 loginserver#1 13 Pong Free : Interval(0)
2010-12-30 17:49:08 1 loginserver#1 13 ID:10101 TYPE:LOGIN CONN STATE:CONNECT DATA STATE:NONE
2010-12-30 17:52:08 1 loginserver#1 2 MacAddrs Size() 1 - 00-1e-10-1f-aa-49
2010-12-30 17:52:09 1 loginserver#1 0 [S_LOGIN] Call Fuction CheckLogin
2010-12-30 17:52:09 1 loginserver#1 0 [S_LOGIN] LoginCheck Query : exec dbo.USP_LOGINCHECK_TH 'konakona', 10101, 0
2010-12-30 17:52:09 1 loginserver#1 2 [DI_LOGIN] konakona Call InsertNewUser
2010-12-30 17:52:09 1 loginserver#1 2 [DI_LOGIN] konakona Call InsertNewUser 2
2010-12-30 17:52:09 1 loginserver#1 2 [DI_LOGIN] konakona Function InsertNewUser 1
2010-12-30 17:52:09 1 loginserver#1 2 [F_LOGIN] konakona CheckLogin Failed
2010-12-30 17:52:09 1 loginserver#1 2 [F_LOGIN] konakona CMD_REQUEST_LOGIN : ErrorCode 15
2010-12-30 17:52:31 1 loginserver#1 2 MacAddrs Size() 1 - 00-1e-10-1f-aa-49
2010-12-30 17:52:31 1 loginserver#1 0 [S_LOGIN] Call Fuction CheckLogin
2010-12-30 17:52:31 1 loginserver#1 0 [S_LOGIN] LoginCheck Query : exec dbo.USP_LOGINCHECK_TH 'konakona', 10101, 0
2010-12-30 17:52:31 1 loginserver#1 2 [DI_LOGIN] konakona Call InsertNewUser
2010-12-30 17:52:31 1 loginserver#1 2 [DI_LOGIN] konakona Call InsertNewUser 2
2010-12-30 17:52:31 1 loginserver#1 2 [DI_LOGIN] konakona Function InsertNewUser 1
2010-12-30 17:52:31 1 loginserver#1 2 [DI_LOGIN] konakona Function InsertNewUser 2
2010-12-30 17:52:31 1 loginserver#1 2 [DI_LOGIN] konakona Function InsertNewUser DB :Query exec dbo.USP_INSERT_NEWUSER_TH 0, 'konakona', 0, '', '800101', '00000', '800101-1000000', 0, 0, 'konakona'
2010-12-30 17:52:31 1 loginserver#1 2 [S_LOGIN] konakona CMD_REQUEST_LOGIN :
2010-12-30 17:52:47 1 loginserver#1 1 [S_NICKNAME] Change Nick : -> (note)Anemone
2010-12-30 17:52:50 1 loginserver#1 2 [S_LOGIN] ID(konakona) : CreateSecurityKey : AuthKey(35801D13)
2010-12-30 17:52:50 1 loginserver#1 1 [N_LOGIN] Uid(1), SendServerList