mysql errorai:

[Lukas Ch]

[09:56:05] [DEBUG] mysql_errno - connection: 1
[09:56:05] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `tehserverz1351` WHERE `Server` = '1';", callback: "Safe_LoadServerStats", format: "(null)"
[09:56:05] [DEBUG] mysql_format - connection: 1, len: 256, format: "UPDATE `tehserverz1351` SET `Last_Restarted_Time` = '%s', `Last_Restarted_Date` = '%s' WHERE `Server` = '1';"
[09:56:05] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `tehserverz1351` SET `Last_Restarted_Time` = '9:56:5', `L", callback: "(null)", format: "(null)"
[09:56:05] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[09:56:05] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[09:56:05] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[09:56:05] [DEBUG] CMySQLConnection::Connect - connection was successful
[09:56:05] [DEBUG] CMySQLConnection::Connect - connection was successful
[09:56:05] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[09:56:05] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[09:56:05] [DEBUG] CMySQLConnection::Connect - connection was successful
[09:56:05] [DEBUG] CMySQLQuery::Execute[Safe_LoadServerStats] - starting query execution
[09:56:05] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[09:56:05] [ERROR] CMySQLQuery::Execute[Safe_LoadServerStats] - (error #1146) Table 'usfowner.tehserverz1351' doesn't exist
[09:56:05] [DEBUG] CMySQLQuery::Execute[Safe_LoadServerStats] - error will be triggered in OnQueryError
[09:56:05] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[09:56:05] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table 'usfowner.tehserverz1351' doesn't exist
[09:56:05] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[09:56:24] [DEBUG] mysql_format - connection: 1, len: 158, format: "SELECT AccountID, Password, Banned, IP FROM `tehuzerz1351` WHERE Username = '%e' LIMIT 1"
[09:56:24] [DEBUG] mysql_tquery - connection: 1, query: "SELECT AccountID, Password, Banned, IP FROM `tehuzerz1351` WHERE", callback: "CheckAccount", format: "i"
[09:56:24] [DEBUG] CMySQLQuery::Execute[CheckAccount] - starting query execution
[09:56:24] [DEBUG] CMySQLQuery::Execute[CheckAccount] - query was successfully executed within 0.521 milliseconds
[09:56:24] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[09:56:24] [DEBUG] Calling callback "CheckAccount"..
[09:56:24] [DEBUG] cache_get_data - connection: 1
[09:56:24] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[09:56:35] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `tehuzerz1351` (Username, Password, IP, Score, Cash,", callback: "(null)", format: "(null)"
[09:56:35] [DEBUG] mysql_format - connection: 1, len: 128, format: "UPDATE `tehserverz1351` SET `Total_Users` = '%i' WHERE Server = '1';"
[09:56:35] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `tehserverz1351` SET `Total_Users` = '1' WHERE Server = '", callback: "(null)", format: "(null)"
[09:56:35] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[09:56:35] [ERROR] CMySQLQuery::Execute[] - (error #1064) 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 '' at line 1
[09:56:35] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[09:56:35] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[09:56:35] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table 'usfowner.tehserverz1351' doesn't exist
[09:56:35] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[09:56:41] [DEBUG] mysql_format - connection: 1, len: 620, format: "UPDATE `tehuzerz1351` SET Admin = '%i', VIP = '%i', LastActive = '%s', Cash = '%i', Score = '%i', Kills = '%i', Deaths = '%i', S..."
[09:56:41] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `tehuzerz1351` SET Admin = '0', VIP = '0', LastActive = '", callback: "(null)", format: "(null)"
[09:56:41] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[09:56:41] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'Bounce' in 'field list'
[09:56:41] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError

bandau regintis, 

new Query[620];
            strcat(Query, "INSERT INTO `"Users_Table"` (Username, Password, IP, Score, Cash, Admin, VIP, AltName, RegisteredOn, Kills, Deaths, Hours, Minutes, Helmet, SpawnPosX, SpawnPosY, SpawnPosZ, CustomSlot1, CustomSlot2, CustomSlot3, CustomSlot4, CustomSlot5, CustomSlot6, CustomSlot7, WeaponSet, Skin, Bounce, SpeedBoost) VALUES");
strcat(Query, "('%s', '%s', '%s', '0', '0', '0', '0', '%s', '%s', '0', '0', '0', '0', '0', '%f', '%f', '%f', '0', '0', '0', '0', '0', '0', '0', '0', '%i', '1', '1.5')");
format(gQuery, 620, Query, GetName(playerid), hashpass, GetIP(playerid), PlayerInfo[playerid][AltName], PlayerInfo[playerid][RegOn], PlayerInfo[playerid][POS_X], PlayerInfo[playerid][POS_Y], PlayerInfo[playerid][POS_Z], GetPlayerSkin(playerid));

nemanau, kad neinsertina playerio del to kad nera tehserverz135

error #1064) 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 '' at line 1

nezinau ka taisyt.

Redaguota Liepos 26, 2015, nario Lukkas56

[SCmindė]

WHERE Server = '"

manau susigaudisi?

[Castello]

blogas kodas

[Lukas Ch]

pas mane WHERE Server = '1'

[freeman]

manau suprasi pats

 (error #1146) Table 'usfowner.tehserverz1351' doesn't exist

[Lukas Ch]

jau idejau viskas ok bet error lieka tas pats

(error #1064) 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 '' at line 1

[freeman]

Also, don't use ' ' for numbers, just for strings.

 

 

jau idejau viskas ok bet error lieka tas pats

(error #1064) 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 '' at line 1

 

 

format(gQuery, 620, Query, GetName(playerid), hashpass, GetIP(playerid), PlayerInfo[playerid][AltName], PlayerInfo[playerid][RegOn], PlayerInfo[playerid][POS_X], PlayerInfo[playerid][POS_Y], PlayerInfo[playerid][POS_Z], GetPlayerSkin(playerid));

nemanau, kad neinsertina playerio del to kad nera tehserverz135

 

:D:DD:D::D:DD: jeigu nera kur insertinti todel ir neinsertina

Redaguota Liepos 26, 2015, nario MartinQ 

[Lukas Ch]

Also, don't use ' ' for numbers, just for strings.

 

 

 

 

:D:DD:D: :D:DD: jeigu nera kur insertinti todel ir neinsertina

ponas protinguolis, cia visai kas kita yra, man turi insertinti i tehuzerz o ne i tehserverz ))

users_table = tehserver...... 

Redaguota Liepos 26, 2015, nario Lukkas56

[freeman]

ponas protinguolis, cia visai kas kita yra, man turi insertinti i tehuzerz o ne i tehserverz ))

tai jeigu data_base pas tave defininta i tehserverz, todel ir neisertina, nevisi durni masto

[Lukas Ch]

nezinau ka cia tu sneki per nesamones, geriau nerasyk, man reikai error istaisyti db

radau klaida   taip buvo ' "

dq minde pastebejau db

 

P.S: bet tai kad normali eilute:

ysql_format(MySQL, gQuery, 128, "UPDATE `"Servers"` SET `Total_Users` = '%i' WHERE Server = '1';", totalreg);

Redaguota Liepos 26, 2015, nario Lukkas56

['Eko]

nu ir kokias klaidas gauni dabar, kai padarei viską ką tau žmones viršuje sakė?

[Lukas Ch]

ta pati errora kurio niekas nesutvarko, nes jo sustabdyti neimanoma, jis plinta visur ir nera sutvarkomas. saugokites, as istryniau sita gm. ;D

Redaguota Liepos 26, 2015, nario Lukkas56

['Eko]

mysql_format(MySQL, gQuery, 128, "UPDATE Servers SET Total_Users = %i WHERE Server = 1", totalreg);

[Lukas Ch]

pas mane servers nudefinta