Server Problem.

Quote:

---

Originally Posted by phoenix_147

Well I checked my Server Log again and it did not show me any QuestGameLog overflow error. It disconnected like 4 times the whole night. It's reduced, thanks for it. For the remaining part, here's my server.ini :

Code:

---

MODE="clan"
COUNTRY="BRZ"
LANGUAGE="BRZ"
USETICKET="0"

[LANGUAGE]
LANG_TYPE="eng"

[LOCALE]
DBAgentPort=5100
DBAgentIP=127.0.0.1

[FILTER]
USE="1"
ACCEPT_INVALID_IP="0"

[ENVIRONMENT]
USE_HSHIELD="0"
USE_XTRAP="0"
USE_EVENT="0"
USE_FILECRC="0"
USE_MD5="0"

---

---

Code:

---

MODE="clan"
COUNTRY="BRZ"
LANGUAGE="BRZ"
USETICKET="0"

[LANGUAGE]
LANG_TYPE="eng"

[LOCALE]
DBAgentPort=5100
DBAgentIP=127.0.0.1

[FILTER]
USE="0"
ACCEPT_INVALID_IP="1"

[ENVIRONMENT]
USE_HSHIELD="0"
USE_XTRAP="0"
USE_EVENT="0"
USE_FILECRC="0"
USE_MD5="0"

---

Note: Don't ever use an IP Country filter again.

Also, as I've said in the previous post, change the procedure data type of the variable to int, and replace the "QuestLog" table's column data type to int.

You will need to find the column name of the table and the procedure variable that stores the data which overflowed.

Quote:

---

Originally Posted by Linear88

Code:

---

MODE="clan"
COUNTRY="BRZ"
LANGUAGE="BRZ"
USETICKET="0"

[LANGUAGE]
LANG_TYPE="eng"

[LOCALE]
DBAgentPort=5100
DBAgentIP=127.0.0.1

[FILTER]
USE="0"
ACCEPT_INVALID_IP="1"

[ENVIRONMENT]
USE_HSHIELD="0"
USE_XTRAP="0"
USE_EVENT="0"
USE_FILECRC="0"
USE_MD5="0"

---

Note: Don't ever use an IP Country filter again.

Also, as I've said in the previous post, change the procedure data type of the variable to int, and replace the "QuestLog" table's column data type to int.

You will need to find the column name of the table and the procedure variable that stores the data which overflowed.

---

Don't many servers use Country filter? :O
Are you sure I should remove it? =/

This is my QuestGameLog.dbo. What changes should I make here?

http://i33.tinypic.com/107s02h.jpg

Quote:

---

Originally Posted by phoenix_147

Well I checked my Server Log again and it did not show me any QuestGameLog overflow error. It disconnected like 4 times the whole night. It's reduced, thanks for it. For the remaining part, here's my server.ini :

Code:

---

MODE="clan"
COUNTRY="BRZ"
LANGUAGE="BRZ"
USETICKET="0"

[LANGUAGE]
LANG_TYPE="eng"

[LOCALE]
DBAgentPort=5100
DBAgentIP=127.0.0.1

[FILTER]
USE="1"
ACCEPT_INVALID_IP="0"

[ENVIRONMENT]
USE_HSHIELD="0"
USE_XTRAP="0"
USE_EVENT="0"
USE_FILECRC="0"
USE_MD5="0"

---

---

your problem wasn't what I thought it was sorry

---------- Post added at 12:43 PM ---------- Previous post was at 12:41 PM ----------

Quote:

---

Originally Posted by Linear88

Code:

---

MODE="clan"
COUNTRY="BRZ"
LANGUAGE="BRZ"
USETICKET="0"

[LANGUAGE]
LANG_TYPE="eng"

[LOCALE]
DBAgentPort=5100
DBAgentIP=127.0.0.1

[FILTER]
USE="0"
ACCEPT_INVALID_IP="1"

[ENVIRONMENT]
USE_HSHIELD="0"
USE_XTRAP="0"
USE_EVENT="0"
USE_FILECRC="0"
USE_MD5="0"

---

Note: Don't ever use an IP Country filter again.

Also, as I've said in the previous post, change the procedure data type of the variable to int, and replace the "QuestLog" table's column data type to int.

You will need to find the column name of the table and the procedure variable that stores the data which overflowed.

---

the "Filter" is for the locale and if he has that on have accept Invalid IP on

I stopped using the Country Filter Linear but, I usually get these 2 errors. The h2 thread error is like once a day and the Stored Procedure error is like every hour. I'm using Steven's keeper with Auto Backup and FTP Upload (Which doesn't work though..looking for one.) It occurs only while using his server keeper.

http://i38.tinypic.com/vo4xtu.jpg --> The Match Server crashes immediately when this error occurs.

http://i38.tinypic.com/29dx0fm.jpg

Quote:

---

Originally Posted by phoenix_147

I stopped using the Country Filter Linear but, I usually get these 2 errors. The h2 thread error is like once a day and the Stored Procedure error is like every hour. I'm using Steven's keeper with Auto Backup and FTP Upload (Which doesn't work though..looking for one.) It occurs only while using his server keeper.

http://i38.tinypic.com/vo4xtu.jpg --> The Match Server crashes immediately when this error occurs.

http://i38.tinypic.com/29dx0fm.jpg

---

I use MAIET's ServerKeeper and you should empty the filters in the db for the IP's cuse it will still try to read it

Quote:

---

Originally Posted by gregon13

I use MAIET's ServerKeeper and you should empty the filters in the db for the IP's cuse it will still try to read it

---

Well MAIET's keeper doesn't have Auto Backups, FTP Uploads or DLL Injections right?

Quote:

---

Originally Posted by phoenix_147

Well MAIET's keeper doesn't have Auto Backups, FTP Uploads or DLL Injections right?

---

Why would I need to auto back-up my db? I don't need to inject dll's and even stevens ftp doesn't work so ftp doesn't count, if your site and server were secured in the first place you wouldn't need to back-up the database

Quote:

---

Originally Posted by gregon13

Why would I need to auto back-up my db? I don't need to inject dll's and even stevens ftp doesn't work so ftp doesn't count, if your site and server were secured in the first place you wouldn't need to back-up the database

---

I'm pretty sure the Euro GunZ Website is secure but having backups is always better. I need to inject dll's as my server crashes all the time you know. If I find a permanent solution that my server runs for weeks and weeks together, no problem!

I don't have problems running Quest and Clan separately but then again, it includes ASM (to run it on the same dedicated server). Sad luck xD

Quote:

---

Originally Posted by phoenix_147

I'm pretty sure the Euro GunZ Website is secure but having backups is always better. I need to inject dll's as my server crashes all the time you know. If I find a permanent solution that my server runs for weeks and weeks together, no problem!

I don't have problems running Quest and Clan separately but then again, it includes ASM (to run it on the same dedicated server). Sad luck xD

---

Well I have Quest+Clan Running in one server It works fine for me atm, back-ups are a good Idea but I have no need for it atm (6 accounts and it is all LAN) which taht could be the difference between me and you, because i'm pretty sure your not running yours LAN your going WAN correct?

AutoBackup are smart But still

if you have a well protected site you will be fine

There's a new crash (Kind of old) using Equipment list and another one using ServerList Response. I've already posted a few fixes refer to my prior posts. Trinity already has this patched. I might release a public patch for this, but if I do it the patch will advertise Trinity every 30 minutes. KK?

Quote:

---

Originally Posted by Theoretical

There's a new crash (Kind of old) using Equipment list and another one using ServerList Response. I've already posted a few fixes refer to my prior posts. Trinity already has this patched. I might release a public patch for this, but if I do it the patch will advertise Trinity every 30 minutes. KK?

---

Erm..If you could help me in some other way, it'd be great Phail. I don't really want my players getting advertisements of trinity. What image would my server have? Try and understand.

If there's any other way, please do let me know as this isn't some problem that can be ignored. Disconnections get on everyone's nerves. Thank you.

Quote:

---

Originally Posted by phoenix_147

Erm..If you could help me in some other way, it'd be great Phail. I don't really want my players getting advertisements of trinity. What image would my server have? Try and understand.

If there's any other way, please do let me know as this isn't some problem that can be ignored. Disconnections get on everyone's nerves. Thank you.

---

Why do you think I went from 600 to 250 players? Exactly =p.

Well then..I might as well give it a try.