Klausimas | localhost

[*Puklas*]

Sveiki, serve nebuvo server failu, sudėjau, surašiau ten viska, rodos gerai, viskas veikia, gm užkrauna, fs, pluginus, bet serve nemeta login lentelės nes kaip suprantu nekrauna sql failo. Ką daryt? Logai: 

[22:56:56] Number of vehicle models: 45
[22:56:56] [connection] 127.0.0.1:64767 requests connection cookie.
[22:56:57] [MYSQL ERROR]: id 2006 error MySQL server has gone away callback LoadWangCarsList query SELECT * FROM `serverparams`
[22:56:57] [connection] incoming connection: 127.0.0.1:64767 id: 0
[22:56:58] [MYSQL ERROR]: id 2006 error MySQL server has gone away callback LoadHouses query SELECT * FROM `namai`
[22:56:59] [MYSQL ERROR]: id 2006 error MySQL server has gone away callback LoadBusiness query SELECT * FROM `verslai`
[22:57:01] [MYSQL ERROR]: id 2006 error MySQL server has gone away callback LoadGaragues query SELECT * FROM `garazai`
[22:57:02] [MYSQL ERROR]: id 2006 error MySQL server has gone away callback LoadPelnas query SELECT * FROM `pelnai`
[22:57:03] [MYSQL ERROR]: id 2006 error MySQL server has gone away callback LoadMsg query SELECT * FROM `dzinutes`
[22:57:04] [MYSQL ERROR]: id 2006 error MySQL server has gone away callback LoadGangs query SELECT * FROM `gaujos`
[22:57:05] [MYSQL ERROR]: id 2006 error MySQL server has gone away callback LoadZones query SELECT * FROM `gzonos`
[22:57:06] [MYSQL ERROR]: id 2006 error MySQL server has gone away callback LoadGraffiti query SELECT * FROM `graffiti`
[22:57:07] [MYSQL ERROR]: id 2006 error MySQL server has gone away callback LoadClubs query SELECT * FROM `klubai`
[22:57:08] [MYSQL ERROR]: id 2006 error MySQL server has gone away callback  query UPDATE `users` SET `sportavo1`= '0' WHERE `sportavo1` = '1'
[22:57:09] [MYSQL ERROR]: id 2006 error MySQL server has gone away callback  query UPDATE `users` SET `sportavo2`= '0' WHERE `sportavo2` = '1'
[22:57:11] [MYSQL ERROR]: id 2006 error MySQL server has gone away callback  query UPDATE `users` SET `paemealga`= '0' WHERE `paemealga` = '1'
[22:57:12] [MYSQL ERROR]: id 2006 error MySQL server has gone away callback LoadParams query SELECT * FROM `nustatymai`
[22:57:13] [MYSQL ERROR]: id 2006 error MySQL server has gone away callback LoadJobRanks query SELECT * FROM `darburangai` WHERE `ID` = '1'
[22:57:14] [MYSQL ERROR]: id 2006 error MySQL server has gone away callback LoadJobSkins query SELECT * FROM `darburangai` WHERE `ID` = '2'
[22:57:15] [MYSQL ERROR]: id 2006 error MySQL server has gone away callback LoadJobCars query SELECT * FROM `darbumasinos`
[22:57:16] [MYSQL ERROR]: id 2006 error MySQL server has gone away callback FixPlayerStatus query SELECT `id`, `vardas` FROM `users` WHERE `On` = '1'
[22:57:36] [connection] 127.0.0.1:59618 requests connection cookie.
[22:57:37] [connection] incoming connection: 127.0.0.1:59618 id: 0
[22:57:37] [join] Auto_Moto has joined the server (0:127.0.0.1)
[22:57:37] Iter_OnPlayerConnect: 0
[22:57:37] Iter_OnPlayerConnect end
[22:57:38] [MYSQL ERROR]: id 2006 error MySQL server has gone away callback CheckPlayerBan query SELECT * FROM `banai` WHERE IP = '127.0.0.1' OR `Vardas` = 'Fenix_Tripline'
[22:57:43] OnPlayerRequestClass Auto_Moto
[22:57:44] [MYSQL ERROR]: id 2006 error MySQL server has gone away callback CheckPlayerAccount query SELECT `id` FROM `users` WHERE `vardas` = 'Auto_Moto'
[22:57:48] [log] Auto_Moto atsijungė € 0 BANKE 0 XP0
[22:57:48] [part] Auto_Moto has left the server (0:1)

Redaguota Sausio 22, 2018, nario *Puklas*

[NTQ]

Teisingai įvedei duomenų bazes prisijungimo informaciją? Ir manyčiau nereikėtų naudoti žvaigždutės, nurodyti eilutes individualiai, priešingu atveju - sumažės našumas.

Redaguota Sausio 22, 2018, nario Direct

[*Puklas*]

3 minutes prieš, Direct parašė:

Teisingai įvedei duomenų bazes prisijungimo informaciją? Ir manyčiau nereikėtų naudoti žvaigždutės, nurodyti eilutes individualiai, priešingu atveju - sumažės našumas.

// ---------------- MYSQL PRISIJUNGIMAS --------------------------- -- //
#define SQL_HOST                     "localhost"
#define SQL_USER                     "root"
#define SQL_PASS                     "" 
#define SQL_DB                         "serveris_mysql"
//Lentelės
#define VEHICLETABLE                "transportas"      // Mysql transporto lentelė
#define USERTABLE                   "users"            // žaidėjų duomenų lentelė