[HELP]Havimng problems with the server.

[RevolutionEO]

ok i have checked the acc server and it says 265.00 ms

Also not to spam the thread at the same time i will ask you why do i get this sort of error from the file serverfiles\accserver\log\sql_rcd-2009-12-** i get loads of lines like this.

execute [20091222000654] failed for You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near '20091222000654' at line 1

Maybe some of you like funhacker who knows most of this stuff know what this means from my point of view it looks like i'm using a wrong version of mysql, but i'm not too sure of course i'm asking this because this seems to be some sort of a bug and as most owners of pserver want their servers to be bug free i do as well.

[funhacker]

Originally Posted by ProSkyZ

Nope i think he means when you open the acc server and login you will find written on it avg time : *** ms like this

Exactly like Skyz has said.

[funhacker]

Originally Posted by ProSkyZ

Nope i think he means when you open the acc server and login you will find written on it avg time : *** ms like this

Exactly like Skyz has said.

[RevolutionEO]

Well ok, i've posted what you needed maybe now you can help me out, anyway i have arodered my dedi host support to re-install windows ... but one more question as you have run your server for a long time can you advise me on which windows should i choose i mean i always choose 2008 but there is also 2003 i think so which one is better...i guess i'll choose 2003 this time, i'll wait for your advice on there, so funhacker just scroll up when you read this and u'll see my post with the avr time in ms and another little problem i have.

[ProSkyZ]

Originally Posted by RevolutionEO

Well ok, i've posted what you needed maybe now you can help me out, anyway i have arodered my dedi host support to re-install windows ... but one more question as you have run your server for a long time can you advise me on which windows should i choose i mean i always choose 2008 but there is also 2003 i think so which one is better...i guess i'll choose 2003 this time, i'll wait for your advice on there, so funhacker just scroll up when you read this and u'll see my post with the avr time in ms and another little problem i have.

I Prefer 2008 also Forcer (Owner of Acme) said Windows Server 2008 is the most stable then 2003

[RevolutionEO]

ok sure i'll choose that then again, but funhacker said to me that vista always gives an error when closing msg server so it can't record the data in to the db and can't create a full file called DBanalysist into syslog folder and i am having this problem of eudemon ranks not being stored into cq_eudemon_dyna_rank_rec and funhacker said thart it's because of windows vista so i'm not sure maybe you ProSkyZ know better as you had a server as well.

[ProSkyZ]

Originally Posted by RevolutionEO

ok sure i'll choose that then again, but funhacker said to me that vista always gives an error when closing msg server so it can't record the data in to the db and can't create a full file called DBanalysist into syslog folder and i am having this problem of eudemon ranks not being stored into cq_eudemon_dyna_rank_rec and funhacker said thart it's because of windows vista so i'm not sure maybe you ProSkyZ know better as you had a server as well.

I used Vista/7/XP/Server2008/Server2003 before
But i think 2008 was the best then 7 then 2003
Actually Vista sucks in opening my computer!

Currently Iam using 7 as Test on my pc (not hosting just using 127.0.0.1)

[RevolutionEO]

but maybe do you know what the real problem might be? i mean that my msg server shuts down i mean error pops up saying close this program.

[ProSkyZ]

Did you try to do Complete extended repair to your my database?
_______________________
Q & A!
Q1:How to do this?
A1:

1. Just go to navicat
2. Select my db
3. Mark all the tables in my db
4. Right click on them
5. Maintain table
6. Repair
7. Extended repair

Then wait till you get the result and try to run the Msg server again

Hope that helped

[funhacker]

The close program problem is just windows not reading the application was closing I guess?? I never said anything about it editing database whilst this is happening.

As for server version at first we (ACME) used 2003 server but now we use 2008 with server manager too for second server.

As for login time 200ms is good.

Other problem perhaps you have incorrect field types to enter that kind of data? I would need to see full script to see what exactly is wrong but no way of doing that so that's the best bet.

[RevolutionEO]

Originally Posted by ProSkyZ

Did you try to do Complete extended repair to your my database?
_______________________
Q & A!
Q1:How to do this?
A1:

1. Just go to navicat
2. Select my db
3. Mark all the tables in my db
4. Right click on them
5. Maintain table
6. Repair
7. Extended repair

Then wait till you get the result and try to run the Msg server again

Hope that helped

sure i'll try that before next maintenance.

Originally Posted by funhacker

The close program problem is just windows not reading the application was closing I guess?? I never said anything about it editing database whilst this is happening.

As for server version at first we (ACME) used 2003 server but now we use 2008 with server manager too for second server.

As for login time 200ms is good.

Other problem perhaps you have incorrect field types to enter that kind of data? I would need to see full script to see what exactly is wrong but no way of doing that so that's the best bet.

the ranks storing problem isn't really a problem but it's a bit annoying when after maint people logging in with gold crown pets all the time.

[ProSkyZ]

Originally Posted by RevolutionEO

sure i'll try that before next maintenance.



the ranks storing problem isn't really a problem but it's a bit annoying when after maint people logging in with gold crown pets all the time.

Yeh they all have Gold Crown till the whole server login and rearrange the crowns and ranks again?
if that what you mean then thats normal and happens with alot of people and not considered as a bug cuz as soon as the top player login he get his rank back so i can say it has a small advantage on the second rank position for enjoying the 1st position for couple of mins lol

[RevolutionEO]

yes thats right