Go to LandSandBoat
http://forums.dspt.info:80/
Delaide wrote:Please check your logs. They should be in the darkstar/logs folder.
Ty for the help. I will let you know how it turns out.demolish wrote:please see:
https://support.plesk.com/hc/en-us/arti ... mpiled-in-
and https://stackoverflow.com/questions/171 ... s-computer
Code: Select all
[1;37m[Info][0m DarkStar[22/Apr 04:54][1;37m[Info][0m Console Silent Setting: 0
[22/Apr 04:54][1;32m[Status][0m The login-server-auth is [1;32mready[0m (Server is listening on the port 54231).
[22/Apr 04:54][1;32m[Status][0m The login-server-lobbydata is [1;32mready[0m (Server is listening on the port 54230).
[22/Apr 04:54][1;32m[Status][0m The login-server-lobbyview is [1;32mready[0m (Server is listening on the port 54001).
[22/Apr 04:54][1;35m[SQL][0m Can't initialize character set unknown (path: compiled_in)
Code: Select all
[1;37m[Info][0m DarkStar[1;32m[Status][0m do_init: begin server initialization... - [1;32m[OK][0m
[22/Apr] [04:57:14][1;32m[Status][0m do_init: map_config is reading - [1;32m[OK][0m
[22/Apr] [04:57:14][1;32m[Status][0m luautils::init:lua initializing... - [1;32m[OK][0m
[22/Apr] [04:57:14][1;32m[Status][0m do_init: sqlhandle is allocating[22/Apr] [04:57:14][1;35m[SQL][0m Can't initialize character set unknown (path: compiled_in)
[22/Apr] [04:57:14][1;32m[Status][0m [1;37mluautils::free[0m:lua free... - [1;32m[OK][0m
Code: Select all
[1;37m========================================================
[0m [1;37mDSSearch-server
[1;37m========================================================
[0m [1;32mAH task to return items older than 3 days is running
[0m[1;35m[SQL][0m Can't initialize character set unknown (path: compiled_in)
[1;31m[Error][0m cant connect
[1;35m[SQL][0m Can't initialize character set unknown (path: compiled_in)
[1;35m[SQL][0m DB error - MySQL server has gone away
SQL: SELECT T0.id,T0.itemid,T1.stacksize, T0.stack, T0.seller FROM auction_house T0 INNER JOIN item_basic T1 ON T0.itemid = T1.itemid WHERE datediff(now(),from_unixtime(date)) >=3 AND buyer_name IS NULL;
Sent 0 expired auction house items back to sellers
I have checked the links but the only thing I understaned from there is how to find my.ini file, and when I did, I did not found the following line:please see:
https://support.plesk.com/hc/en-us/arti ... mpiled-in-
and https://stackoverflow.com/questions/171 ... s-computer
Code: Select all
skip-character-set-client-handshake
Yup ... that was my problem. Uninstalling 8 and installing 5.7 solves it.PS: mySQL version is 8.0.15