1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
MYSQL not saving stats once player /q.
Swarn
Big Clucker
***
Posts: 134
Threads: 23
Joined: Sep 2015
Reputation: 0
#1

01.01.2016, 20:12
Well, this is the problem. Nothing saves when the player leaves the server.
pawn Код:
(29/12/2015) ErrorID: 1064
(29/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(29/12/2015) Query: UPDATE samp_users SET `Password`='110428716', Level='1', Pos_x='1451.02', Pos_y='-1044.07', Pos_z='39.00', 
(29/12/2015) Callback: OnQueryFinish
(29/12/2015) ErrorID: 1064
(29/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(29/12/2015) Query: UPDATE samp_users SET `Password`='110428716', Level='1', Pos_x='1451.02', Pos_y='-1044.06', Pos_z='39.00', 
(29/12/2015) Callback: OnQueryFinish
(29/12/2015) ErrorID: 1064
(29/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(29/12/2015) Query: UPDATE samp_users SET `Password`='110428716', Level='1', Pos_x='1653.71', Pos_y='-1727.64', Pos_z='13.38', 
(29/12/2015) Callback: OnQueryFinish
(29/12/2015) ErrorID: 1064
(29/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(29/12/2015) Query: UPDATE samp_users SET `Password`='110428716', Level='1', Pos_x='1792.00', Pos_y='-2105.21', Pos_z='13.54', 
(29/12/2015) Callback: OnQueryFinish
(29/12/2015) ErrorID: 1064
(29/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(29/12/2015) Query: UPDATE samp_users SET `Password`='110428716', Level='1', Pos_x='1923.75', Pos_y='-1999.74', Pos_z='13.54', 
(29/12/2015) Callback: OnQueryFinish
(29/12/2015) ErrorID: 1064
(29/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(29/12/2015) Query: UPDATE samp_users SET `Password`='110428716', Level='1', Pos_x='1612.31', Pos_y='-2330.16', Pos_z='13.54', 
(29/12/2015) Callback: OnQueryFinish
(29/12/2015) ErrorID: 1064
(29/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(29/12/2015) Query: UPDATE samp_users SET `Password`='110428716', Level='1', Pos_x='1622.20', Pos_y='-2189.00', Pos_z='13.54', 
(29/12/2015) Callback: OnQueryFinish
(29/12/2015) ErrorID: 1064
(29/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(29/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='1', Pos_x='1611.58', Pos_y='-2190.59', Pos_z='13.37', 
(29/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='1', Pos_x='-1956.44', Pos_y='284.42', Pos_z='32.04', R
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='1580.12', Pos_y='-2274.31', Pos_z='13.36', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='2281.61', Pos_y='-1679.59', Pos_z='14.26', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='2282.35', Pos_y='-1676.59', Pos_z='14.61', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='2154.84', Pos_y='-1749.82', Pos_z='13.21', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='2099.42', Pos_y='-1801.35', Pos_z='13.55', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='2391.48', Pos_y='-2009.41', Pos_z='13.25', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='2391.48', Pos_y='-2009.41', Pos_z='13.25', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='1608.65', Pos_y='-2323.85', Pos_z='13.38', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='1642.35', Pos_y='-2239.93', Pos_z='13.49', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='2792.53', Pos_y='-1614.51', Pos_z='10.92', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='1612.31', Pos_y='-2329.83', Pos_z='13.54', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='1053.00', Pos_y='-1369.08', Pos_z='13.03', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='1051.83', Pos_y='-1379.12', Pos_z='13.47', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='1053.70', Pos_y='-1389.17', Pos_z='13.47', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='553.88', Pos_y='-1274.76', Pos_z='17.17', R
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='1595.45', Pos_y='-2325.74', Pos_z='13.54', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='1609.64', Pos_y='-2327.55', Pos_z='13.54', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='1568.29', Pos_y='-2323.76', Pos_z='13.53', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='1558.68', Pos_y='-2252.16', Pos_z='13.54', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='1591.08', Pos_y='-2325.30', Pos_z='13.54', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='-1956.44', Pos_y='284.42', Pos_z='32.04', R
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='-1956.44', Pos_y='284.42', Pos_z='32.04', R
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='2244.15', Pos_y='-1664.67', Pos_z='15.47', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='1574.12', Pos_y='-1702.35', Pos_z='5.89', R
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='127074782', Level='1', Pos_x='1637.91', Pos_y='-2300.30', Pos_z='13.54', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='127074782', Level='1', Pos_x='1637.91', Pos_y='-2300.30', Pos_z='13.54', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='34799827', Level='3', Pos_x='2151.19', Pos_y='-1180.32', Pos_z='23.82', R
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='34799827', Level='3', Pos_x='2151.19', Pos_y='-1180.32', Pos_z='23.82', R
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='127074782', Level='1', Pos_x='2145.66', Pos_y='-1183.40', Pos_z='23.82', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='127074782', Level='1', Pos_x='2145.66', Pos_y='-1183.40', Pos_z='23.82', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='573899915', Level='1', Pos_x='1280.39', Pos_y='-1408.34', Pos_z='13.77', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='573899915', Level='1', Pos_x='1280.39', Pos_y='-1408.34', Pos_z='13.77', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='34799827', Level='2', Pos_x='2128.32', Pos_y='-1135.87', Pos_z='25.63', R
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='2127.95', Pos_y='-1136.35', Pos_z='25.53', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='2126.79', Pos_y='-1129.52', Pos_z='25.31', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='34799827', Level='2', Pos_x='2129.58', Pos_y='-1141.30', Pos_z='25.11', R
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='34799827', Level='2', Pos_x='2129.58', Pos_y='-1141.30', Pos_z='25.11', R
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='127074782', Level='1', Pos_x='1250.73', Pos_y='-1374.62', Pos_z='13.20', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='127074782', Level='1', Pos_x='1250.73', Pos_y='-1374.62', Pos_z='13.20', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='62521677', Level='1', Pos_x='1466.54', Pos_y='-1507.32', Pos_z='1.64', Re
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='127074782', Level='1', Pos_x='1186.55', Pos_y='-1353.47', Pos_z='13.57', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='1185.19', Pos_y='-1357.01', Pos_z='14.24', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='34799827', Level='1', Pos_x='1531.49', Pos_y='-1621.45', Pos_z='13.39', R
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='573899915', Level='1', Pos_x='1186.98', Pos_y='-1351.69', Pos_z='13.56', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='34799827', Level='1', Pos_x='1197.51', Pos_y='-1326.84', Pos_z='14.24', R
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='573899915', Level='1', Pos_x='1869.85', Pos_y='-1687.27', Pos_z='1997.60'
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='1183.42', Pos_y='-1321.23', Pos_z='13.57', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='1579.82', Pos_y='-2316.78', Pos_z='13.38', 
(30/12/2015) Callback: OnQueryFinish
(30/12/2015) ErrorID: 1064
(30/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(30/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='1567.34', Pos_y='-2288.84', Pos_z='13.38', 
(30/12/2015) Callback: OnQueryFinish
(31/12/2015) ErrorID: 1064
(31/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(31/12/2015) Query: UPDATE samp_users SET `Password`='62521677', Level='1', Pos_x='2355.61', Pos_y='-648.69', Pos_z='128.05', R
(31/12/2015) Callback: OnQueryFinish
(31/12/2015) ErrorID: 1064
(31/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(31/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='2355.16', Pos_y='-650.39', Pos_z='128.05', 
(31/12/2015) Callback: OnQueryFinish
(31/12/2015) ErrorID: 1064
(31/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(31/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='2078.11', Pos_y='-1103.08', Pos_z='82.60', 
(31/12/2015) Callback: OnQueryFinish
(31/12/2015) ErrorID: 1064
(31/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(31/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='1938.68', Pos_y='-1140.64', Pos_z='26.06', 
(31/12/2015) Callback: OnQueryFinish
(31/12/2015) ErrorID: 1064
(31/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(31/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='383.60', Pos_y='-2087.97', Pos_z='7.83', Re
(31/12/2015) Callback: OnQueryFinish
(31/12/2015) ErrorID: 1064
(31/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(31/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='384.03', Pos_y='-2086.97', Pos_z='7.83', Re
(31/12/2015) Callback: OnQueryFinish
(31/12/2015) ErrorID: 1064
(31/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(31/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='395.16', Pos_y='-2088.54', Pos_z='7.83', Re
(31/12/2015) Callback: OnQueryFinish
(31/12/2015) ErrorID: 1064
(31/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(31/12/2015) Query: UPDATE samp_users SET `Password`='68944173', Level='1', Pos_x='2467.23', Pos_y='-2104.60', Pos_z='14.11', R
(31/12/2015) Callback: OnQueryFinish
(31/12/2015) ErrorID: 1064
(31/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(31/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='2127.36', Pos_y='-1129.08', Pos_z='25.28', 
(31/12/2015) Callback: OnQueryFinish
(31/12/2015) ErrorID: 1064
(31/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(31/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='555.89', Pos_y='-1255.10', Pos_z='17.05', R
(31/12/2015) Callback: OnQueryFinish
(31/12/2015) ErrorID: 1064
(31/12/2015) Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for th
(31/12/2015) Query: UPDATE samp_users SET `Password`='189924065', Level='3', Pos_x='555.89', Pos_y='-1255.10', Pos_z='17.05', R
(31/12/2015) Callback: OnQueryFinish
Find
Reply
Mister0
Huge Clucker
***
Posts: 220
Threads: 28
Joined: Aug 2015
Reputation: 0
#2

01.01.2016, 20:36
replace in your mysql syntax

SET `Password`='189924065', `Level`='1', `Pos_x`='1611.58', `Pos_y`='-2190.59', `Pos_z`='13.37',
Find
Reply
AmigaBlizzard
Huge Clucker
****
Posts: 319
Threads: 7
Joined: Jul 2012
Reputation: 0
#3

01.01.2016, 20:39
Looks to me like your query-variable is too small.
After your pos_z field, there is a comma but nothing else behind it.
Your update query also doesn't state a WHERE clause, so it would update those fields for ALL registered players in your entire database if the query would work without errors.
It also seems you have cut-off the rest of your text to the right, because your error-message also suddenly stops in the middle of a sentence.

Can you show the code which generates and sends this query?
Find
Reply
Swarn
Big Clucker
***
Posts: 134
Threads: 23
Joined: Sep 2015
Reputation: 0
#4

01.01.2016, 23:30
Quote:
Originally Posted by Mister0
Посмотреть сообщение
replace in your mysql syntax

SET `Password`='189924065', `Level`='1', `Pos_x`='1611.58', `Pos_y`='-2190.59', `Pos_z`='13.37',
EDIT: I compiled it, didn't work.
Find
Reply
Swarn
Big Clucker
***
Posts: 134
Threads: 23
Joined: Sep 2015
Reputation: 0
#5

01.01.2016, 23:35
Quote:
Originally Posted by AmigaBlizzard
Посмотреть сообщение
Looks to me like your query-variable is too small.
After your pos_z field, there is a comma but nothing else behind it.
Your update query also doesn't state a WHERE clause, so it would update those fields for ALL registered players in your entire database if the query would work without errors.
It also seems you have cut-off the rest of your text to the right, because your error-message also suddenly stops in the middle of a sentence.

Can you show the code which generates and sends this query?
I am not sure which bit of code generates this error.
Find
Reply
AmigaBlizzard
Huge Clucker
****
Posts: 319
Threads: 7
Joined: Jul 2012
Reputation: 0
#6

05.01.2016, 19:31
You could check the code where the query is created (it's given by your error-log):
Код:
UPDATE samp_users SET `Password`
If you search for this in your code, you should be able to find it.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help