GTA:BLKN

MYSQL problem

Započeo ©pawno
•1. Jan. 2020.
2,005
pregleda
19
postova
peeetarrrr
4
©pawno
Shot Caller
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
1. Jan. 2020.
#1
Problem(error/warning): koristim mod V-Roleplay od Mumitze i spojio sam ga u bazu,sve okej i kada ulazim na server nece dalje od connecta
[19:15:57 01/01/20] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM `users` WHERE `p_name` = 'Pawno_Legacy' LIMIT 1' at line 1 (Query: "SELECT `registered`, `password`, `user_id`, `level`, `exp`, `xOnlineSati`, `country`, `money`, `xBRacun`, `job_id`, `contract`, `skin_id`, `warn`, `admin_lvl`, `helper_level`, `xTestAdmin`, `vip_level`, `v_poen`, `xVCoin`, `xTogStats`, FROM `users` WHERE `p_name` = 'Pawno_Legacy' LIMIT 1")

Dio skripte: MYSQL / pawno
Debug iz server_log(ukoliko je u pitanju crashanje servera - crashdetect log): //
Slika/video ingame problema(obavezno ako je ingame problem): SLIKA 1 SLIKA 2
Coox
4
Salesman
Enforcer
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
1. Jan. 2020.
#2
Zasto nisi stavio query:
SELECT * FROM users WHERE pname = 'Pawno_Legacy'
peeetarrrr
4
©pawno
Shot Caller
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
1. Jan. 2020.
#3
@Salesman  nisam shvatio ?
Coox
4
Salesman
Enforcer
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
1. Jan. 2020.
#4
Probaj ovako: 
SELECT * FROM users WHERE p_name = '%e' LIMIT 1
peeetarrrr
4
©pawno
Shot Caller
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
1. Jan. 2020.
#5
Salesman wrote on January 1, 2020, 6:31 pm:
Probaj ovako: 
SELECT * FROM users WHERE p_name = '%e' LIMIT 1

[19:33:37 01/01/20] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SELECT * FROM users WHERE p_name = `Pawno_Legacy` LIMIT 1' at line 1 (Query: "SELECT `registered`, `password`, `user_id`, `level`, `exp`, `xOnlineSati`, `country`, `money`, `xBRacun`, `job_id`, `contract`, `skin_id`, `warn`, `admin_lvl`, `helper_level`, `xTestAdmin`, `vip_level`, `v_poen`, `xVCoin`, `xTogStats`, SELECT * FROM users WHERE p_name = `Pawno_Legacy` LIMIT 1")
peeetarrrr
4
©pawno
Shot Caller
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
1. Jan. 2020.
#6
@Salesman  isto sve..
#tsipras
4
Rejk.inc
Shot Caller
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
1. Jan. 2020.
#7
Fali ti 1 column u bazi...

Ubaci ovaj .sql fajl umjesto tog koji sada imas (copy,replace) i ponovo importuj bazu sa ovim .sql u phpmyadmin/mysql..

Link fixanog .sql-a: http://www.solidfiles.com/v/Y8mMvL3Y72j4j
Coox
4
Salesman
Enforcer
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
1. Jan. 2020.
#8
©pawno wrote on January 1, 2020, 6:34 pm:
[19:33:37 01/01/20] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SELECT * FROM users WHERE p_name = `Pawno_Legacy` LIMIT 1' at line 1 (Query: "SELECT `registered`, `password`, `user_id`, `level`, `exp`, `xOnlineSati`, `country`, `money`, `xBRacun`, `job_id`, `contract`, `skin_id`, `warn`, `admin_lvl`, `helper_level`, `xTestAdmin`, `vip_level`, `v_poen`, `xVCoin`, `xTogStats`, SELECT * FROM users WHERE p_name = `Pawno_Legacy` LIMIT 1")


Wtf si ti druze uradio?
Evo ti cijeli query:
SELECT * FROM users WHERE p_name = '%e' LIMIT 1


Znaci ovo sto sam ti iznad napisao pises umjesto ovog tvog.

Da se nadovezem za decka prije mene. Nema nikakve veze sa columnom jer bi bacalo error za isti.
peeetarrrr
4
©pawno
Shot Caller
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
1. Jan. 2020.
#9
Salesman wrote on January 1, 2020, 6:47 pm:
Wtf si ti druze uradio?
Evo ti cijeli query:
SELECT * FROM users WHERE p_name = '%e' LIMIT 1


Znaci ovo sto sam ti iznad napisao pises umjesto ovog tvog.

Da se nadovezem za decka prije mene. Nema nikakve veze sa columnom jer bi bacalo error za isti.


to kad stavim server se ugasi…..
@Salesman 
	mysql_format(mSQL, str, sizeof(str),
										"SELECT `registered`, `password`, `user_id`, `level`, `exp`, `xOnlineSati`, `country`, `money`, `xBRacun`, `job_id`, `contract`, `skin_id`, \
												`warn`, `admin_lvl`, `helper_level`, `xTestAdmin`, `vip_level`, `v_poen`, `xVCoin`, `xTogStats`, FROM `users` WHERE `p_name` = '%e' LIMIT 1", ImeIgraca(playerid));

	mysql_pquery(mSQL, str, "SELECT * FROM users WHERE p_name = `%e` LIMIT 1", "i", playerid);
	return(true);
}

[19:54:14 01/01/20] CMySQLQuery::Execute[SELECT * FROM users WHERE p_name = `%e` LIMIT 1] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM `users` WHERE `p_name` = 'Pawno_Legacy' LIMIT 1' at line 1 (Query: "SELECT `registered`, `password`, `user_id`, `level`, `exp`, `xOnlineSati`, `country`, `money`, `xBRacun`, `job_id`, `contract`, `skin_id`, `warn`, `admin_lvl`, `helper_level`, `xTestAdmin`, `vip_level`, `v_poen`, `xVCoin`, `xTogStats`, FROM `users` WHERE `p_name` = 'Pawno_Legacy' LIMIT 1")
Nikola-.-
6
bunta
Kingpin
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
1. Jan. 2020.
#10
ajde malo procitaj V Roleplay temu!
Coox
4
Salesman
Enforcer
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
1. Jan. 2020.
#11
©pawno wrote on January 1, 2020, 6:53 pm:
to kad stavim server se ugasi…..
@Salesman 
	mysql_format(mSQL, str, sizeof(str),
										"SELECT `registered`, `password`, `user_id`, `level`, `exp`, `xOnlineSati`, `country`, `money`, `xBRacun`, `job_id`, `contract`, `skin_id`, \
												`warn`, `admin_lvl`, `helper_level`, `xTestAdmin`, `vip_level`, `v_poen`, `xVCoin`, `xTogStats`, FROM `users` WHERE `p_name` = '%e' LIMIT 1", ImeIgraca(playerid));

	mysql_pquery(mSQL, str, "SELECT * FROM users WHERE p_name = `%e` LIMIT 1", "i", playerid);
	return(true);
}

[19:54:14 01/01/20] CMySQLQuery::Execute[SELECT * FROM users WHERE p_name = `%e` LIMIT 1] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'FROM `users` WHERE `p_name` = 'Pawno_Legacy' LIMIT 1' at line 1 (Query: "SELECT `registered`, `password`, `user_id`, `level`, `exp`, `xOnlineSati`, `country`, `money`, `xBRacun`, `job_id`, `contract`, `skin_id`, `warn`, `admin_lvl`, `helper_level`, `xTestAdmin`, `vip_level`, `v_poen`, `xVCoin`, `xTogStats`, FROM `users` WHERE `p_name` = 'Pawno_Legacy' LIMIT 1")

	mysql_format(mSQL, str, sizeof str, "SELECT * FROM users WHERE p_name = '%e' LIMIT 1", ImeIgraca(playerid));

	mysql_tquery(mSQL, str, "CheckPlayerData", "i", playerid);
	return(true);
}


EDIT: Bukvalno samo ides copy paste sad to sto sam ti napisao iznad.
peeetarrrr
4
©pawno
Shot Caller
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
1. Jan. 2020.
#12
bunta wrote on January 1, 2020, 6:58 pm:
ajde malo procitaj V Roleplay temu!


sve već urađeno I iznad navedeno….
Coox
4
Salesman
Enforcer
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
1. Jan. 2020.
#13
Druze znaci uzmes ovo ispod sad sto ti pise "KOD ODABERI" kopiras i zamjenis umjesto svog i probas.
	mysql_format(mSQL, str, sizeof str, "SELECT * FROM users WHERE p_name = `%e` LIMIT 1", ImeIgraca(playerid));

	mysql_tquery(mSQL, str, "CheckPlayerData", "i", playerid);
	return(true);
}
peeetarrrr
4
©pawno
Shot Caller
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
1. Jan. 2020.
#14
Salesman wrote on January 1, 2020, 7:05 pm:
	mysql_format(mSQL, str, sizeof str, "SELECT * FROM users WHERE p_name = '%e' LIMIT 1", ImeIgraca(playerid));

	mysql_tquery(mSQL, str, "CheckPlayerData", "i", playerid);
	return(true);
}


EDIT: Bukvalno samo ides copy paste sad to sto sam ti napisao iznad.


I NIŠTA.
Coox
4
Salesman
Enforcer
Balkan SA:MPBalkan SA:MP
SA-MP DoprinosSA-MP Doprinos
1. Jan. 2020.
#15
Ništa? Nemoguce da je ništa sta ti izbacuje u logu lmao

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava

© 2026 SmartShark. All rights reserved.

Powered by Momentum|v2026.3.001 Alpha