Page 2 of 2

Re: XAseco

Posted: 12 Apr 2020 09:34
by Tutur
Thx you a lot, it works fine :thumbsup: :thumbsup: :gobananas:

Re: XAseco

Posted: 18 Apr 2020 19:32
by Sokol
undef.de wrote:
12 Apr 2020 08:52
Here is the download which I uploaded for nicomoore0, I hope that works for you too: https://www.uaseco.org/downloads/xaseco ... r_1.16.zip
Friends, what am I doing wrong? Installed the build using the link undef.de. After starting xaseco, local records are saved for a couple of minutes, then local records are no longer saved to the database.
Below is the xaseco log. PID=10621 - php aseco.php TMN

Code: Select all

PHP Deprecated:  Methods with the same name as their class will not be constructors in a future version of PHP; Aseco has a deprecated constructor in /sites/server.1/lol_mini_relax/xaseco/aseco.php on line 138

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Aseco has a deprecated constructor in /sites/server.1/lol_mini_relax/xaseco/aseco.php on line 138
# initialize XASECO ###########################################################
[XAseco] PHP Version is 7.3.4 on Linux
[XAseco] Load settings [config.xml]
[XAseco] Load admin/ops lists [adminops.xml]
[XAseco] Load banned IPs list [bannedips.xml]
[XAseco] Load plugins list [plugins.xml]
[XAseco] Load plugin [plugin.localdatabase.php]
[XAseco] Load plugin [plugin.rounds.php]
[XAseco] Load plugin [chat.admin.php]
[XAseco] Load plugin [chat.help.php]
[XAseco] Load plugin [chat.records.php]
[XAseco] Load plugin [chat.records2.php]
[XAseco] Load plugin [chat.recrels.php]
[XAseco] Load plugin [chat.dedimania.php]
[XAseco] Load plugin [chat.players.php]
[XAseco] Load plugin [chat.players2.php]
[XAseco] Load plugin [chat.wins.php]
[XAseco] Load plugin [chat.laston.php]
[XAseco] Load plugin [chat.lastwin.php]
[XAseco] Load plugin [chat.stats.php]
[XAseco] Load plugin [chat.server.php]
[XAseco] Load plugin [chat.songmod.php]
[XAseco] Load plugin [chat.me.php]
[XAseco] Load plugin [plugin.tmxinfo.php]
[XAseco] Load plugin [plugin.track.php]
[XAseco] Load plugin [plugin.checkpoints.php]
[XAseco] Load plugin [plugin.dedimania.php]
[XAseco] Load plugin [plugin.rasp.php]
[XAseco] Load plugin [plugin.rasp_jukebox.php]
[XAseco] Load plugin [plugin.rasp_chat.php]
[XAseco] Load plugin [plugin.rasp_karma.php]
[XAseco] Load plugin [plugin.rasp_nextmap.php]
[XAseco] Load plugin [plugin.rasp_nextrank.php]
[XAseco] Load plugin [plugin.rasp_votes.php]
[XAseco] Load plugin [plugin.chatlog.php]
[XAseco] Load plugin [plugin.style.php]
[XAseco] Load plugin [plugin.panels.php]
[XAseco] Load plugin [plugin.fufi.menu.php]
[XAseco] Load plugin [plugin.donate.php]
[XAseco] Load plugin [plugin.records_eyepiece.php]
[XAseco] Load plugin [plugin.uptodate.php]
[XAseco] Load plugin [jfreu.plugin.php]
[XAseco] Load plugin [mistral.idlekick.php]
[04/18,19:14:54] Try to connect to TM dedicated server on 127.0.0.1:2091 timeout 180s
[04/18,19:14:54] Try to authenticate with login 'SuperAdmin' and password ''
[04/18,19:14:54] Connection established successfully !
[04/18,19:14:55] [LocalDB] Load config file [localdatabase.xml]
[04/18,19:14:55] [LocalDB] Try to connect to MySQL server on 'localhost' with database 'sokol_lol_mini'
[04/18,19:14:55] [LocalDB] MySQL Server Version is 5.5.54
[04/18,19:14:55] [LocalDB] Checking database structure...
[04/18,19:14:55] [LocalDB] ...Structure OK!
[04/18,19:14:55] [RASP] Loading config file [rasp.xml]
[04/18,19:14:55] [RASP] Checking database structure...
[04/18,19:14:55] [RASP] ...Structure OK!
[04/18,19:14:55] [RASP] Cleaning up unused data
[04/18,19:14:55] Load default style [styles/DarkBlur.xml]
[04/18,19:14:55] Load default admin panel [panels/AdminBelowChat.xml]
[04/18,19:14:55] Load default donate panel [panels/DonateBelowCPList.xml]
[04/18,19:14:55] Load default records panel [panels/RecordsRightBottom.xml]
[04/18,19:14:55] Load default vote panel [panels/VoteBelowChat.xml]
[04/18,19:14:55] ************* (Dedimania) *************
[04/18,19:14:55] * Dataserver connection on Dedimania ...
[04/18,19:14:55] * Try connection on http://dedimania.net:8002/Dedimania ...
[04/18,19:14:55] Webaccess (dedimania.net:8002/Dedimania.8007): send: deflate, receive: deflate
[04/18,19:14:55] * Connection and status ok! (Dedimania.8007)
[04/18,19:14:55] * NEWS (Dedimania, 08/05): news
[04/18,19:14:55] ------------- (Dedimania) -------------
[04/18,19:14:55] **********[plugin.records_eyepiece.php/1.1.1-TMF]**********
[04/18,19:14:55] >> Checking Database for required extensions...
[04/18,19:14:55]    + Found column `timezone` at table `players_extra`.
[04/18,19:14:55]    + Found column `displaywidgets` at table `players_extra`.
[04/18,19:14:56]    + Found column `mostfinished` at table `players_extra`.
[04/18,19:14:56]    + Found column `mostrecords` at table `players_extra`.
[04/18,19:14:56]    + Found column `roundpoints` at table `players_extra`.
[04/18,19:14:56]    + Found column `visits` at table `players_extra`.
[04/18,19:14:56]    + Found column `winningpayout` at table `players_extra`.
[04/18,19:14:56]    + Found index `Nation` at table `players`.
[04/18,19:14:56]    + Found index `Wins` at table `players`.
[04/18,19:14:56]    + Found index `UpdatedAt` at table `players`.
[04/18,19:14:56]    + Found index `Score` at table `records`.
[04/18,19:14:56]    + Found index `Score` at table `rs_karma`.
[04/18,19:14:56]    + Found index `Score` at table `rs_times`.
[04/18,19:14:56] >> Updating `mostfinished` counts for all Players...
[04/18,19:14:56] >> Updating `mostrecords` counts for all Players...
[04/18,19:14:56] >> Finished.
[04/18,19:14:56] ***********************************************************
[04/18,19:14:59] << player 64 joined the game [msok : $i$f00Ѕ๏к๏เ : Russia : 60698 : 188.233.51.23]
###############################################################################
  XASECO v1.16 running on 127.0.0.1:2091
  Name   : гәו๑א - lol-mini-rlx
  Game   : TmForever United - Stadium - TimeAttack
  Version: 2.11.26 / 2011-02-21
  Authors: Florian Schnell & Assembler Maniac
  Re-Authored: Xymph
###############################################################################
Begin Challenge
[04/18,19:15:00] [plugin.records_eyepiece.php] Register event "onCheckpoint" to enabled wanted Widgets.
[04/18,19:15:00] track changed [undefined] >> [autosport101]
[04/18,19:15:00] currently no record on autosport101
[04/18,19:15:11] player msok used chat command "/list "
[04/18,19:15:46] [LocalDB] player msok finished with 24530 and took the 1. LR place!
[04/18,19:16:16] player msok clicked command "/admin restartmap"
[04/18,19:16:16] MasterAdmin [msok] restarts challenge!
End Round
Restart Challenge (with ChatTime)
[04/18,19:16:20] track changed [autosport101] >> [autosport101]
[04/18,19:16:20] current record on autosport101 is 0:24.53 and held by Ѕ๏к๏เ
[04/18,19:16:25] player msok clicked command "/admin nextmap"
[04/18,19:16:25] MasterAdmin [msok] skips challenge!
Begin Round
[04/18,19:16:32] player msok clicked command "/admin nextmap"
[04/18,19:16:32] MasterAdmin [msok] skips challenge!
End Round
End Challenge
Begin Challenge
[04/18,19:16:39] track changed [autosport101] >> [///Tiny Tech #10]
[04/18,19:16:39] currently no record on ///Tiny Tech #10
[04/18,19:16:49] player msok used chat command "/list "
Begin Round
[04/18,19:19:03] player msok used chat command "/list "
[PHP Warning] Error while sending QUERY packet. PID=10621 on line 118 in file /sites/server.1/lol_mini_relax/xaseco/includes/modernizer.inc.php
[PHP Warning] mysqli_fetch_object() expects parameter 1 to be mysqli_result, bool given on line 86 in file /sites/server.1/lol_mini_relax/xaseco/includes/modernizer.inc.php
[PHP Warning] mysqli_free_result() expects parameter 1 to be mysqli_result, bool given on line 96 in file /sites/server.1/lol_mini_relax/xaseco/includes/modernizer.inc.php
[04/18,19:19:27] [plugin.records_eyepiece.php] UPDATE `mostfinished` at `players_extra` failed. [for statement "UPDATE `players_extra` SET `mostfinished`=`mostfinished`+1 WHERE `playerID`='1';"]!
[XASECO Warning] Could not insert/update record! (2006: MySQL server has gone away)
sql = INSERT INTO records
	          (ChallengeId, PlayerId, Score, Date, Checkpoints)
	          VALUES
	          (4, 1, 17200, NOW(), '8440,11520,17200') ON DUPLICATE KEY UPDATE Score=VALUES(Score), Date=VALUES(Date), Checkpoints=VALUES(Checkpoints)
[04/18,19:19:27] [LocalDB] player msok finished with 17200 and took the 1. LR place!
[04/18,19:19:27] [plugin.records_eyepiece.php] UPDATE `mostrecords` at `players_extra` failed. [for statement "UPDATE `players_extra` SET `mostrecords`=`mostrecords`+1 WHERE `playerID`='1';"]!
[XASECO Warning] {RASP_ERROR} Could not insert time! (MySQL server has gone away)
sql = INSERT INTO rs_times (playerID, challengeID, score, date, checkpoints)
			          VALUES (1, 4, 17200, '1587237567', '8440,11520,17200')
[04/18,19:19:49] [plugin.records_eyepiece.php] UPDATE `mostfinished` at `players_extra` failed. [for statement "UPDATE `players_extra` SET `mostfinished`=`mostfinished`+1 WHERE `playerID`='1';"]!
[XASECO Warning] {RASP_ERROR} Could not insert time! (MySQL server has gone away)
sql = INSERT INTO rs_times (playerID, challengeID, score, date, checkpoints)
			          VALUES (1, 4, 17810, '1587237589', '8870,12180,17810')
Need help!

Re: XAseco

Posted: 19 Apr 2020 08:29
by undef.de
Sokol wrote:
18 Apr 2020 19:32

Code: Select all

PHP Deprecated:  Methods with the same name as their class will not be constructors in a future version of PHP; Aseco has a deprecated constructor in /sites/server.1/lol_mini_relax/xaseco/aseco.php on line 138

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Aseco has a deprecated constructor in /sites/server.1/lol_mini_relax/xaseco/aseco.php on line 138
My updated XAseco will remove this PHP notices: https://www.uaseco.org/downloads/xaseco ... r_1.16.zip

About your database: If it isn't an new database, then try to repair the tables.

Re: XAseco

Posted: 19 Apr 2020 08:30
by undef.de
undef.de wrote:
12 Apr 2020 08:52
Here is the download which I uploaded for nicomoore0, I hope that works for you too: https://www.uaseco.org/downloads/xaseco ... _1.16a.zip

Re: XAseco

Posted: 19 Apr 2020 10:19
by Sokol
undef.de, PHP notices is gone, thank you!

But no clearing of tables helps. The database was cleared before all manipulations initially. Still, a couple of minutes - and local records are not saved. If you re-upload to the server-a couple of minutes - and local records are not saved again.

Code: Select all

# initialize XASECO ###########################################################
[XAseco] PHP Version is 7.3.4 on Linux
[XAseco] Load settings [config.xml]
[XAseco] Load admin/ops lists [adminops.xml]
[XAseco] Load banned IPs list [bannedips.xml]
[XAseco] Load plugins list [plugins.xml]
[XAseco] Load plugin [plugin.localdatabase.php]
[XAseco] Load plugin [plugin.rounds.php]
[XAseco] Load plugin [chat.admin.php]
[XAseco] Load plugin [chat.help.php]
[XAseco] Load plugin [chat.records.php]
[XAseco] Load plugin [chat.records2.php]
[XAseco] Load plugin [chat.recrels.php]
[XAseco] Load plugin [chat.dedimania.php]
[XAseco] Load plugin [chat.players.php]
[XAseco] Load plugin [chat.players2.php]
[XAseco] Load plugin [chat.wins.php]
[XAseco] Load plugin [chat.laston.php]
[XAseco] Load plugin [chat.lastwin.php]
[XAseco] Load plugin [chat.stats.php]
[XAseco] Load plugin [chat.server.php]
[XAseco] Load plugin [chat.songmod.php]
[XAseco] Load plugin [chat.me.php]
[XAseco] Load plugin [plugin.tmxinfo.php]
[XAseco] Load plugin [plugin.track.php]
[XAseco] Load plugin [plugin.checkpoints.php]
[XAseco] Load plugin [plugin.dedimania.php]
[XAseco] Load plugin [plugin.rasp.php]
[XAseco] Load plugin [plugin.rasp_jukebox.php]
[XAseco] Load plugin [plugin.rasp_chat.php]
[XAseco] Load plugin [plugin.rasp_karma.php]
[XAseco] Load plugin [plugin.rasp_nextmap.php]
[XAseco] Load plugin [plugin.rasp_nextrank.php]
[XAseco] Load plugin [plugin.rasp_votes.php]
[XAseco] Load plugin [plugin.chatlog.php]
[XAseco] Load plugin [plugin.style.php]
[XAseco] Load plugin [plugin.panels.php]
[XAseco] Load plugin [plugin.fufi.menu.php]
[XAseco] Load plugin [plugin.donate.php]
[XAseco] Load plugin [plugin.records_eyepiece.php]
[XAseco] Load plugin [plugin.uptodate.php]
[XAseco] Load plugin [jfreu.plugin.php]
[XAseco] Load plugin [mistral.idlekick.php]
[04/19,10:23:57] Try to connect to TM dedicated server on 127.0.0.1:2091 timeout 180s
[04/19,10:23:57] Try to authenticate with login 'SuperAdmin' and password ''
[04/19,10:23:57] Connection established successfully !
[04/19,10:23:57] [LocalDB] Load config file [localdatabase.xml]
[04/19,10:23:57] [LocalDB] Try to connect to MySQL server on 'localhost' with database 'sokol_lol_mini'
[04/19,10:23:57] [LocalDB] MySQL Server Version is 5.5.54
[04/19,10:23:57] [LocalDB] Checking database structure...
[04/19,10:23:57] [LocalDB] ...Structure OK!
[04/19,10:23:57] [RASP] Loading config file [rasp.xml]
[04/19,10:23:57] [RASP] Checking database structure...
[04/19,10:23:57] [RASP] ...Structure OK!
[04/19,10:23:57] [RASP] Cleaning up unused data
[04/19,10:23:57] Load default style [styles/DarkBlur.xml]
[04/19,10:23:57] Load default admin panel [panels/AdminBelowChat.xml]
[04/19,10:23:57] Load default donate panel [panels/DonateBelowCPList.xml]
[04/19,10:23:57] Load default records panel [panels/RecordsRightBottom.xml]
[04/19,10:23:57] Load default vote panel [panels/VoteBelowChat.xml]
[04/19,10:23:58] ************* (Dedimania) *************
[04/19,10:23:58] * Dataserver connection on Dedimania ...
[04/19,10:23:58] * Try connection on http://dedimania.net:8002/Dedimania ...
[04/19,10:23:58] Webaccess (dedimania.net:8002/Dedimania.8013): send: deflate, receive: deflate
[04/19,10:23:58] * Connection and status ok! (Dedimania.8013)
[04/19,10:23:58] * NEWS (Dedimania, 08/05): news
[04/19,10:23:58] ------------- (Dedimania) -------------
[04/19,10:23:58] **********[plugin.records_eyepiece.php/1.1.1-TMF]**********
[04/19,10:23:58] >> Checking Database for required extensions...
[04/19,10:23:58]    + Found column `timezone` at table `players_extra`.
[04/19,10:23:58]    + Found column `displaywidgets` at table `players_extra`.
[04/19,10:23:58]    + Found column `mostfinished` at table `players_extra`.
[04/19,10:23:58]    + Found column `mostrecords` at table `players_extra`.
[04/19,10:23:58]    + Found column `roundpoints` at table `players_extra`.
[04/19,10:23:58]    + Found column `visits` at table `players_extra`.
[04/19,10:23:58]    + Found column `winningpayout` at table `players_extra`.
[04/19,10:23:58]    + Found index `Nation` at table `players`.
[04/19,10:23:58]    + Found index `Wins` at table `players`.
[04/19,10:23:58]    + Found index `UpdatedAt` at table `players`.
[04/19,10:23:58]    + Found index `Score` at table `records`.
[04/19,10:23:58]    + Found index `Score` at table `rs_karma`.
[04/19,10:23:58]    + Found index `Score` at table `rs_times`.
[04/19,10:23:58] >> Updating `mostfinished` counts for all Players...
[04/19,10:23:58] >> Updating `mostrecords` counts for all Players...
[04/19,10:23:58] >> Finished.
[04/19,10:23:58] ***********************************************************
###############################################################################
  XASECO v1.16a running on 127.0.0.1:2091
  Name   : гәו๑א - lol-mini-rlx
  Game   : TmForever United - Stadium - TimeAttack
  Version: 2.11.26 / 2011-02-21
  Authors: Florian Schnell & Assembler Maniac
  Re-Authored: Xymph
###############################################################################
Begin Challenge
[04/19,10:24:00] [plugin.records_eyepiece.php] Register event "onCheckpoint" to enabled wanted Widgets.
[04/19,10:24:00] track changed [undefined] >> [///Tiny Tech #25]
[04/19,10:24:00] currently no record on ///Tiny Tech #25
[04/19,10:24:08] << player 52 joined the game [msok : $i$f00Ѕ๏к๏เ : Russia : 60698 : 188.233.51.23]
End Round
End Challenge
Begin Challenge
[04/19,10:24:12] track changed [///Tiny Tech #25] >> [autosport101]
[04/19,10:24:12] currently no record on autosport101
Begin Round
[04/19,10:25:04] [LocalDB] player msok finished with 23810 and took the 1. LR place!
[04/19,10:25:19] player msok used chat command "/list "
[04/19,10:26:17] [LocalDB] player msok finished with 23500 and took the 1. LR place!
[04/19,10:26:44] [LocalDB] player msok finished with 23410 and took the 1. LR place!
[04/19,10:27:40] player msok used chat command "/list "
[04/19,10:29:23] player msok used chat command "/list "
[PHP Warning] Error while sending QUERY packet. PID=23229 on line 118 in file /sites/server.1/lol_mini_relax/xaseco/includes/modernizer.inc.php
[PHP Warning] mysqli_fetch_object() expects parameter 1 to be mysqli_result, bool given on line 86 in file /sites/server.1/lol_mini_relax/xaseco/includes/modernizer.inc.php
[PHP Warning] mysqli_free_result() expects parameter 1 to be mysqli_result, bool given on line 96 in file /sites/server.1/lol_mini_relax/xaseco/includes/modernizer.inc.php
End Round
End Challenge
Begin Challenge
[XASECO Warning] Could not get challenge info! (MySQL server has gone away)
sql = SELECT c.Id AS ChallengeId, r.Score, p.NickName, p.Login, r.Date, r.Checkpoints
	          FROM challenges c
	          LEFT JOIN records r ON (r.ChallengeId=c.Id)
	          LEFT JOIN players p ON (r.PlayerId=p.Id)
	          WHERE c.Uid='v6gMGATr6gXqJgGbUm1ko7MAGEg'
	          GROUP BY r.Id
	          ORDER BY r.Score ASC,r.Date ASC
	          LIMIT 50
[04/19,10:30:55] track changed [autosport101] >> [Stadium Fun 7]
[04/19,10:30:55] currently no record on Stadium Fun 7
[PHP Warning] mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given on line 123 in file /sites/server.1/lol_mini_relax/xaseco/includes/modernizer.inc.php
[PHP Warning] mysqli_free_result() expects parameter 1 to be mysqli_result, bool given on line 96 in file /sites/server.1/lol_mini_relax/xaseco/includes/modernizer.inc.php
Begin Round
[04/19,10:31:09] player msok used chat command "/list "
[PHP Warning] mysqli_fetch_object() expects parameter 1 to be mysqli_result, bool given on line 86 in file /sites/server.1/lol_mini_relax/xaseco/includes/modernizer.inc.php
[PHP Warning] mysqli_free_result() expects parameter 1 to be mysqli_result, bool given on line 96 in file /sites/server.1/lol_mini_relax/xaseco/includes/modernizer.inc.php
[04/19,10:31:16] >> player 52 left the game [msok : $i$f00Ѕ๏к๏เ : 00:07:08]
[XASECO Warning] Could not update disconnecting player! (MySQL server has gone away)
sql = UPDATE players
	          SET UpdatedAt=NOW(),
	              TimePlayed=TimePlayed+428
	          WHERE Login='msok'
[PHP Warning] mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given on line 123 in file /sites/server.1/lol_mini_relax/xaseco/includes/modernizer.inc.php
[PHP Warning] mysqli_free_result() expects parameter 1 to be mysqli_result, bool given on line 96 in file /sites/server.1/lol_mini_relax/xaseco/includes/modernizer.inc.php
[XASECO Warning] Could not update player's CPs! (MySQL server has gone away)
sql = UPDATE players_extra
	          SET cps=0, dedicps=-1
	          WHERE playerID=0
[04/19,10:31:16] [LocalDB] Reconnected to MySQL Server

Re: XAseco

Posted: 19 Apr 2020 10:35
by undef.de
It looks like your MySQL server dies, please check that logfile.

Re: XAseco

Posted: 19 Apr 2020 14:41
by Sokol
MySQL logfile didn't contain any errors. There were a lot of "Aborted connects", more than 50%. I updated MySQL 5.5 to 5.7 and the errors disappeared. Thanks! :D

Re: XAseco

Posted: 19 Apr 2020 15:09
by Sokol
No, there are still errors. They just appeared a little later...

Code: Select all

End Round
End Challenge
[PHP Warning] Error while sending QUERY packet. PID=8191 on line 118 in file /sites/server.1/lol_mini_relax/xaseco/includes/modernizer.inc.php
Begin Challenge
[XASECO Warning] Could not get challenge info! (MySQL server has gone away)
sql = SELECT c.Id AS ChallengeId, r.Score, p.NickName, p.Login, r.Date, r.Checkpoints
	          FROM challenges c
	          LEFT JOIN records r ON (r.ChallengeId=c.Id)
	          LEFT JOIN players p ON (r.PlayerId=p.Id)
	          WHERE c.Uid='XieZHb9FLJ8Gq8VHeBelJJNeqUg'
	          GROUP BY r.Id
	          ORDER BY r.Score ASC,r.Date ASC
	          LIMIT 50
[04/19,14:54:42] track changed [///Tiny Tech #111] >> [Tropical Technologies]
[04/19,14:54:42] currently no record on Tropical Technologies
[PHP Warning] mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given on line 123 in file /sites/server.1/lol_mini_relax/xaseco/includes/modernizer.inc.php
[PHP Warning] mysqli_free_result() expects parameter 1 to be mysqli_result, bool given on line 96 in file /sites/server.1/lol_mini_relax/xaseco/includes/modernizer.inc.php
Begin Round
[04/19,15:00:26] player msok used chat command "/list "
[PHP Warning] mysqli_fetch_object() expects parameter 1 to be mysqli_result, bool given on line 86 in file /sites/server.1/lol_mini_relax/xaseco/includes/modernizer.inc.php
[PHP Warning] mysqli_free_result() expects parameter 1 to be mysqli_result, bool given on line 96 in file /sites/server.1/lol_mini_relax/xaseco/includes/modernizer.inc.php
[04/19,15:01:00] >> player 48 left the game [msok : $i$f00Ѕ๏к๏เ : 00:11:35]
[XASECO Warning] Could not update disconnecting player! (MySQL server has gone away)
sql = UPDATE players
	          SET UpdatedAt=NOW(),
	              TimePlayed=TimePlayed+695
	          WHERE Login='msok'
[PHP Warning] mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given on line 123 in file /sites/server.1/lol_mini_relax/xaseco/includes/modernizer.inc.php
[PHP Warning] mysqli_free_result() expects parameter 1 to be mysqli_result, bool given on line 96 in file /sites/server.1/lol_mini_relax/xaseco/includes/modernizer.inc.php
[XASECO Warning] Could not update player's CPs! (MySQL server has gone away)
sql = UPDATE players_extra
	          SET cps=0, dedicps=-1
	          WHERE playerID=0
[04/19,15:01:01] [LocalDB] Reconnected to MySQL Server
End Round
End Challenge
Begin Challenge
[04/19,15:01:08] track changed [Tropical Technologies] >> [Titan #1]
[04/19,15:01:08] currently no record on Titan #1
Begin Round

Re: XAseco

Posted: 20 Apr 2020 10:49
by undef.de
You should open an own topic for this and then please tell us more details about your system (which Linux...). Maybe there is an timeout in MySQL which abort the connection too early and XAseco does no reconnect (it's being a long time for me, I can't remember how XAseco works).

Re: XAseco

Posted: 03 May 2020 11:21
by Sokol
The problem was solved by editing parameters in the configuration file mysql:

Code: Select all

net_read_timeout=1000
net_write_timeout=1000
interactive_timeout=2000
wait_timeout=2000
It was all on the CentOS7, MySQL5 .7

For the experiment repeated everything in Ubuntu18.04, MariaDB10.1.44. The same error occurred until you configured the database server like this:

Code: Select all

connect_timeout=2000
net_read_timeout=2000
net_write_timeout=2000
interactive_timeout=2000
wait_timeout=2000