GTA:BLKN
PRIJAVA REGISTRACIJA

MYSQL problem

peeetarrrr Započeo ©pawno
pre 6 godina
1,886
pregleda
19
postova
peeetarrrr
©pawno
Shot Caller
pre 6 godina
#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
Salesman
Enforcer
pre 6 godina
#2
Zasto nisi stavio query:
SELECT * FROM users WHERE pname = 'Pawno_Legacy'
peeetarrrr
©pawno
Shot Caller
pre 6 godina
#3
@Salesman  nisam shvatio ?
Coox
Salesman
Enforcer
pre 6 godina
#4
Probaj ovako: 
SELECT * FROM users WHERE p_name = '%e' LIMIT 1
peeetarrrr
©pawno
Shot Caller
pre 6 godina
#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
©pawno
Shot Caller
pre 6 godina
#6
@Salesman  isto sve..
#tsipras
Rejk.inc
Shot Caller
pre 6 godina
#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
Salesman
Enforcer
pre 6 godina
#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
©pawno
Shot Caller
pre 6 godina
#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-.-
bunta
Kingpin
pre 6 godina
#10
ajde malo procitaj V Roleplay temu!
Coox
Salesman
Enforcer
pre 6 godina
#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
©pawno
Shot Caller
pre 6 godina
#12
bunta wrote on January 1, 2020, 6:58 pm:
ajde malo procitaj V Roleplay temu!


sve već urađeno I iznad navedeno….
Coox
Salesman
Enforcer
pre 6 godina
#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
©pawno
Shot Caller
pre 6 godina
#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
Salesman
Enforcer
pre 6 godina
#15
Ništa? Nemoguce da je ništa sta ti izbacuje u logu lmao

Morate biti prijavljeni da biste odgovorili na ovu temu.

Prijava