|
You last visited: Today at 19:06
Advertisement
[Help Thread] Please post your questions here.
Discussion on [Help Thread] Please post your questions here. within the Rappelz Private Server forum part of the Rappelz category.
10/30/2017, 21:40
|
#6571
|
elite*gold: 0 
Join Date: May 2013
Posts: 119
Received Thanks: 4
|
help shop billing
Quote:
2017/10/30 16:38:28 DB COM ERROR(Thread:2, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_TakeOutCommercialItem(dbo.smp_takeout_commercia l_item) : Database 'Billing' is being recovered. Waiting until recovery is finished.
2017/10/30 16:38:30 DB COM ERROR(Thread:0, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_ReadCommercialStorageList(dbo.smp_read_purchase d_item_list) : Database 'Billing' is being recovered. Waiting until recovery is finished.
2017/10/30 16:38:38 DB COM ERROR(Thread:1, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_TakeOutCommercialItem(dbo.smp_takeout_commercia l_item) : Database 'Billing' is being recovered. Waiting until recovery is finished.
2017/10/30 16:38:38 DB COM ERROR(Thread:0, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_TakeOutCommercialItem(dbo.smp_takeout_commercia l_item) : Database 'Billing' is being recovered. Waiting until recovery is finished.
2017/10/30 16:38:38 DB COM ERROR(Thread:3, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_ReadCommercialStorageList(dbo.smp_read_purchase d_item_list) : Database 'Billing' is being recovered. Waiting until recovery is finished.
2017/10/30 16:39:03 DB COM ERROR(Thread:0, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_ReadCommercialStorageList(dbo.smp_read_purchase d_item_list) : Database 'Billing' is being recovered. Waiting until recovery is finished.
2017/10/30 16:39:04 DB COM ERROR(Thread:1, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_TakeOutCommercialItem(dbo.smp_takeout_commercia l_item) : Database 'Billing' is being recovered. Waiting until recovery is finished.
2017/10/30 16:39:16 DB COM ERROR(Thread:3, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_TakeOutCommercialItem(dbo.smp_takeout_commercia l_item) : Database 'Billing' is being recovered. Waiting until recovery is finished.
2017/10/30 16:39:24 DB COM ERROR(Thread:3, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_ReadCommercialStorageList(dbo.smp_read_purchase d_item_list) : Database 'Billing' is being recovered. Waiting until recovery is finished.
2017/10/30 16:39:25 DB COM ERROR(Thread:2, HRESULT:80040E14, GUID:0C733A63-2A1C-11CE-ADE5-00AA0044773D) : DB_ReadCommercialStorageList(dbo.smp_read_purchase d_item_list) : Database 'Billing' is being recovered. Waiting until recovery is finished.
|
server is online don't crash, gamelog create.
|
|
|
|
10/30/2017, 23:38
|
#6572
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,915
Received Thanks: 1,492
|
Check the status of your billing database specifically.
I have had databases go into a stasis or busy state trying to auto recover itself where it can not be accessed.
Try taking the billing database offline and then back online and see what happens.
If all else fails try restoring your billing database again.
|
|
|
|
|
10/31/2017, 18:35
|
#6573
|
elite*gold: 0
Join Date: May 2013
Posts: 119
Received Thanks: 4
|
|
|
|
|
|
11/01/2017, 01:36
|
#6574
|
elite*gold: 0
Join Date: Nov 2012
Posts: 948
Received Thanks: 259
|
Quote:
Originally Posted by The War Z
my server is 7.2 revolution arab files don't gamelog.txt is empty  help |
did you make any edits in arcadia? does it crash before running luas or from the start?
|
|
|
|
|
11/01/2017, 09:38
|
#6575
|
elite*gold: 15
Join Date: Jul 2010
Posts: 726
Received Thanks: 50
|
We need more information.
1: Show us your gameserver.opt crash error create printscreen when gameserver crashes.
2: Try to search in the (log) folder for gameserver.txt.
3: Maybe you have the gamelog.txt in the (game_bin) folder.
Quote:
Originally Posted by The War Z
my server is 7.2 revolution arab files don't gamelog.txt is empty help |
|
|
|
|
|
11/01/2017, 13:43
|
#6576
|
elite*gold: 0
Join Date: May 2013
Posts: 119
Received Thanks: 4
|
Arcadia not edit, gamelog.txt empty in folder
help
|
|
|
|
|
11/01/2017, 14:46
|
#6577
|
elite*gold: 15
Join Date: Jul 2010
Posts: 726
Received Thanks: 50
|
Please explain in your own language.... Arab/Turkish/German/Russian?
Post picture/photo
Quote:
Originally Posted by The War Z
Arcadia not edit, gamelog.txt empty in folder
help |
|
|
|
|
|
11/01/2017, 15:17
|
#6578
|
elite*gold: 0
Join Date: May 2013
Posts: 119
Received Thanks: 4
|
I am from turkish  picture/photo deleted
|
|
|
|
|
11/02/2017, 16:54
|
#6579
|
elite*gold: 6190
Join Date: Sep 2014
Posts: 349
Received Thanks: 953
|
Quote:
Originally Posted by The War Z
my server is 7.2 revolution arab files don't gamelog.txt is empty help |
send me the crash dump file with the captainherlock.pdb and i will find the problem.
*upload it and send the url here ..
|
|
|
|
|
11/02/2017, 20:27
|
#6580
|
elite*gold: 0
Join Date: Aug 2011
Posts: 166
Received Thanks: 29
|
Acc register query for registerpage
Hi guys,
i have the Regiscript from iSmokeDrow.. 
there is a SQL Query for the old Auth database...
Can anyone help me to convert this Query for 9.4 Auth ?
Old Query:
INSERT INTO Accounts (login_name,password,block,withdraw_remain_time,ag e,auth_ok,pcbang,last_login_server_idx,event_code, result, email)VALUES(@User @ ,0,0 @ ,1,1,1,0,1 @ )");
|
|
|
|
|
11/02/2017, 21:42
|
#6581
|
elite*gold: 0
Join Date: May 2013
Posts: 119
Received Thanks: 4
|
Quote:
Originally Posted by Ghost Informatics
send me the crash dump file with the captainherlock.pdb and i will find the problem.
*upload it and send the url here ..
|
thanks fixed: harddisk sata crash. change to ssd disk 
datastore bugs 
new problem, //regenerate id count
delete boss spawn clear? delete regenerate code?
|
|
|
|
|
11/02/2017, 23:27
|
#6582
|
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,915
Received Thanks: 1,492
|
Quote:
Originally Posted by PetTrainer
Hi guys,
i have the Regiscript from iSmokeDrow..
there is a SQL Query for the old Auth database...
Can anyone help me to convert this Query for 9.4 Auth ? |
Try this...
INSERT INTO Account (account, password, email, password2, block, IP_user, last_login_server_idx, Admin, point, datePassword, pk_, creationDate_, updateDate_, creatorId_, updatorId_, portId_, type_, accessDate_, age) VALUES (@user, @pass, @email, @pass, 0, null, 1, 1, 0, null, 1, null, null, null, null, null, com.elixir.billing.impl.ImmAccount, null, @age)");
You can add and age column to the end of your account table or you can remove it from this script but ismoke's old register script will ask for the user input but not have a use for it if it is not there.
|
|
|
|
|
11/03/2017, 16:20
|
#6583
|
elite*gold: 0
Join Date: Aug 2011
Posts: 166
Received Thanks: 29
|
Quote:
Originally Posted by ThunderNikk
Try this...
INSERT INTO Account (account, password, email, password2, block, IP_user, last_login_server_idx, Admin, point, datePassword, pk_, creationDate_, updateDate_, creatorId_, updatorId_, portId_, type_, accessDate_, age) VALUES (@user, @pass, @email, @pass, 0, null, 1, 1, 0, null, 1, null, null, null, null, null, com.elixir.billing.impl.ImmAccount, null, @age)");
You can add and age column to the end of your account table or you can remove it from this script but ismoke's old register script will ask for the user input but not have a use for it if it is not there.
|
Don't work...
Can anyone make a Registerpage for 9.4 Auth Database ?....
|
|
|
|
|
11/03/2017, 18:04
|
#6584
|
|
Moderator
elite*gold: 1
Join Date: Dec 2012
Posts: 4,915
Received Thanks: 1,492
|
Could you explain what does not work and maybe I can fix it for you.
I use the same register page I just use the same auth db I have been using since 7.4
Is there an error message that I can correct?
|
|
|
|
|
11/03/2017, 19:11
|
#6585
|
elite*gold: 0
Join Date: Aug 2011
Posts: 166
Received Thanks: 29
|
Quote:
Originally Posted by ThunderNikk
Could you explain what does not work and maybe I can fix it for you.
I use the same register page I just use the same auth db I have been using since 7.4
Is there an error message that I can correct?
|
I have insert your Query, but i delete the ,age entry... when i will register a acc i become this error:
The multi-part identifier 'com.elixir.billing.impl.ImmAccount' could not be bound.
when i change the "com.elixir.billing.impl.ImmAccount" to "1" i will become this error:
The value NULL can not be inserted into the IP_user column, Auth94.dbo.Account table. The column does not allow NULL values. Error with INSERT. The statement has ended.
when i change the IP_user entry from "NULL" to "127.0.0.1" i will become this error:
when i change the IP_user entry from "127.0.0.1" to "1" i will become this error:
Operand type collision: int is incompatible with text
#translated from german to english with google translator
|
|
|
|
Similar Threads
|
[Helping Topic] 24/7 Helping Services!
08/27/2008 - EO PServer Hosting - 31 Replies
stucked on anything while setuping your server?
post your problem here and you will get answer as fast as possible better than spamming with posts :cool:
first of all try reading Ahmedpotop's Pserver All thing guide.
if your couldn't solve it out post your problem down here
""That includes PHP rankings pages / registrations pages / Status pages""
|
All times are GMT +1. The time now is 19:09.
|
|
![[Help Thread] Please post your questions here.](https://www.elitepvpers.com/forum/iconimages/rappelz-private-server/help-thread-please-post-your-questions-here_ltr.gif){kind=small}
![Exterminator-[Fury]'s Avatar](https://www.elitepvpers.com/forum/customavatars/avatar2601769_8.gif){kind=avatar}
