SA-MP Forums

Go Back   SA-MP Forums > SA-MP Server > Server Support

Reply
 
Thread Tools Display Modes
Old 18/06/2019, 03:48 AM   #1
RANGER44
Big Clucker
 
Join Date: Oct 2016
Location: India 🇮🇳
Posts: 117
Reputation: 33
Default Server unknown restart/lag!

Hello everyone, I am having a problem with my server... Sometimes (mostly) I join my server and it goes lagging so much that my commands doesn't works and ping also doesn't move (tab), but I when I alt tab and see in the client, I see that the ping is good and the ping is moving,...I tried to join other servers, no lag, only on my server, it(server) also sometimes restarts unfortunately...and after logging out of a game(quitting) I see that my player is already in-game, and when I try to join again, it doesn't even connect, says connection closed. or no response.
Everything is fine with my clien/network, the problem is in the server because other players experiencing it also.
I would be glad and happy if someone could help me, thanks for reading!


Some logs:

[21:38:05] [connection] incoming connection: 42.110.130.139:38093 id: 0

[21:38:06] [join] New_Peep has joined the server (0:42.110.130.139)

[21:38:06] The request failed! The response code was: 6


and I deleted MySQL log but it creates again and in the low it shows:
[21:12:30] [ERROR] cache_get_field_content_int - invalid datatype
[21:12:30] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('1')
[21:12:30] [ERROR] cache_get_field_content_int - invalid datatype
[21:18:44] [ERROR] CMySQLConnection::Connect - (error #1044) Access denied for user 'Dev'@'%' to database 'shoutcast'
[21:18:44] [ERROR] CMySQLConnection::Connect - (error #1044) Access denied for user 'Dev'@'%' to database 'shoutcast'
[21:18:44] [ERROR] CMySQLConnection::Connect - (error #1044) Access denied for user 'Dev'@'%' to database 'shoutcast'
[21:18:44] [ERROR] CMySQLConnection::Connect - (error #1044) Access denied for user 'Dev'@'%' to database 'shoutcast'
[21:18:44] [ERROR] cache_get_field_content_int - invalid datatype
[21:18:44] [ERROR] cache_get_field_content_int - invalid datatype
[21:18:44] [ERROR] cache_get_field_content_int - invalid datatype
[21:18:44] [ERROR] cache_get_field_content_int - invalid datatype
[21:18:44] [ERROR] cache_get_field_content_int - invalid datatype
[21:18:44] [ERROR] cache_get_field_content_int - invalid datatype
[21:18:44] [ERROR] cache_get_field_content_int - invalid datatype
RANGER44 is offline   Reply With Quote
Old 20/06/2019, 02:16 PM   #2
iHunterJ
Little Clucker
 
Join Date: Feb 2019
Posts: 4
Reputation: 7
Default Re: Server unknown restart/lag!

Your MySQL database is clearly not configured correctly. At least one/multiple tables used within the player saving/loading aspect of the code use the wrong data type, as your log states. Ensure you're using the correct datatypes.
iHunterJ is offline   Reply With Quote
Old 21/06/2019, 03:17 AM   #3
khRamin78
Huge Clucker
 
Join Date: Jun 2015
Posts: 310
Reputation: 29
Default Re: Server unknown restart/lag!

Quote:
Originally Posted by iHunterJ View Post
Your MySQL database is clearly not configured correctly. At least one/multiple tables used within the player saving/loading aspect of the code use the wrong data type, as your log states. Ensure you're using the correct datatypes.
What the heck !?
w
Quote:
Originally Posted by RANGER44 View Post
Hello everyone, I am having a problem with my server... Sometimes (mostly) I join my server and it goes lagging so much that my commands doesn't works and ping also doesn't move (tab), but I when I alt tab and see in the client, I see that the ping is good and the ping is moving,...I tried to join other servers, no lag, only on my server, it(server) also sometimes restarts unfortunately...and after logging out of a game(quitting) I see that my player is already in-game, and when I try to join again, it doesn't even connect, says connection closed. or no response.
Everything is fine with my clien/network, the problem is in the server because other players experiencing it also.
I would be glad and happy if someone could help me, thanks for reading!


Some logs:

[21:38:05] [connection] incoming connection: 42.110.130.139:38093 id: 0

[21:38:06] [join] New_Peep has joined the server (0:42.110.130.139)

[21:38:06] The request failed! The response code was: 6


and I deleted MySQL log but it creates again and in the low it shows:
[21:12:30] [ERROR] cache_get_field_content_int - invalid datatype
[21:12:30] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('1')
[21:12:30] [ERROR] cache_get_field_content_int - invalid datatype
[21:18:44] [ERROR] CMySQLConnection::Connect - (error #1044) Access denied for user 'Dev'@'%' to database 'shoutcast'
[21:18:44] [ERROR] CMySQLConnection::Connect - (error #1044) Access denied for user 'Dev'@'%' to database 'shoutcast'
[21:18:44] [ERROR] CMySQLConnection::Connect - (error #1044) Access denied for user 'Dev'@'%' to database 'shoutcast'
[21:18:44] [ERROR] CMySQLConnection::Connect - (error #1044) Access denied for user 'Dev'@'%' to database 'shoutcast'
[21:18:44] [ERROR] cache_get_field_content_int - invalid datatype
[21:18:44] [ERROR] cache_get_field_content_int - invalid datatype
[21:18:44] [ERROR] cache_get_field_content_int - invalid datatype
[21:18:44] [ERROR] cache_get_field_content_int - invalid datatype
[21:18:44] [ERROR] cache_get_field_content_int - invalid datatype
[21:18:44] [ERROR] cache_get_field_content_int - invalid datatype
[21:18:44] [ERROR] cache_get_field_content_int - invalid datatype
The problem is that your MySQL plugin cant access to the database to load your data!
are you running it on the host? contact them
khRamin78 is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Server Restart kesarthakur Scripting Help 2 02/01/2015 06:19 AM
PHP - Restart a SA-MP server lewismichaelbbc Help Archive 3 05/08/2011 06:04 PM
[SA-MP Server 0.3a RC7] PVar resetted too early at server restart Wanted1900 Bug Reports 11 14/04/2010 11:15 AM
Unknown Reason for Server Restart..... Outbreak Help Archive 13 12/08/2009 08:20 PM


All times are GMT. The time now is 12:21 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.