Odštampaj stranicu - MYSQL problem

Naslov: MYSQL problem
Poruka od: ©pawno poslato Januar 01, 2020, 19:22:45 POSLE PODNE

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
[pawn][19:15:57 01/01/20] [ERROR] CMySQLQuery::Execute[CheckPlayerAccount] - (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")
[/pawn]
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 (https://imgur.com/V2G5txZ) SLIKA 2 (https://imgur.com/8wcEq9J)

Naslov: Odg: MYSQL problem
Poruka od: Salesman poslato Januar 01, 2020, 19:26:19 POSLE PODNE

Zasto nisi stavio query:

[pawn]SELECT * FROM users WHERE pname = 'Pawno_Legacy'[/pawn]

Naslov: Odg: MYSQL problem
Poruka od: ©pawno poslato Januar 01, 2020, 19:27:58 POSLE PODNE

@Salesman nisam shvatio ?

Naslov: Odg: MYSQL problem
Poruka od: Salesman poslato Januar 01, 2020, 19:31:38 POSLE PODNE

Probaj ovako:

[pawn]SELECT * FROM users WHERE p_name = '%e' LIMIT 1[/pawn]

Naslov: Odg: MYSQL problem
Poruka od: ©pawno poslato Januar 01, 2020, 19:34:47 POSLE PODNE

Citat: Salesman poslato Januar 01, 2020, 19:31:38 POSLE PODNE
Probaj ovako:

[pawn]SELECT * FROM users WHERE p_name = '%e' LIMIT 1[/pawn]

[pawn][19:33:37 01/01/20] [ERROR] CMySQLQuery::Execute[CheckPlayerAccount] - (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")[/pawn]

Naslov: Odg: MYSQL problem
Poruka od: ©pawno poslato Januar 01, 2020, 19:35:06 POSLE PODNE

@Salesman isto sve..

Naslov: Odg: MYSQL problem
Poruka od: Rejk.inc poslato Januar 01, 2020, 19:42:14 POSLE PODNE

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

Naslov: Odg: MYSQL problem
Poruka od: Salesman poslato Januar 01, 2020, 19:47:07 POSLE PODNE

Citat: ©pawno poslato Januar 01, 2020, 19:34:47 POSLE PODNE
[pawn][19:33:37 01/01/20] [ERROR] CMySQLQuery::Execute[CheckPlayerAccount] - (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")[/pawn]

Wtf si ti druze uradio?
Evo ti cijeli query:

[pawn]SELECT * FROM users WHERE p_name = '%e' LIMIT 1[/pawn]

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.

Naslov: Odg: MYSQL problem
Poruka od: ©pawno poslato Januar 01, 2020, 19:53:18 POSLE PODNE

Citat: Salesman poslato Januar 01, 2020, 19:47:07 POSLE PODNE
Wtf si ti druze uradio?
Evo ti cijeli query:

[pawn]SELECT * FROM users WHERE p_name = '%e' LIMIT 1[/pawn]

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

[pawn]   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);
}[/pawn]

[pawn][19:54:14 01/01/20] [ERROR] 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")[/pawn]

Naslov: Odg: MYSQL problem
Poruka od: bunta poslato Januar 01, 2020, 19:58:43 POSLE PODNE

ajde malo procitaj V Roleplay temu!

Naslov: Odg: MYSQL problem
Poruka od: Salesman poslato Januar 01, 2020, 20:05:22 POSLE PODNE

Citat: ©pawno poslato Januar 01, 2020, 19:53:18 POSLE PODNE
to kad stavim server se ugasi.....
@Salesman

[pawn]   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);
}[/pawn]

[pawn][19:54:14 01/01/20] [ERROR] 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")[/pawn]

[pawn]   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);
}[/pawn]

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

Naslov: Odg: MYSQL problem
Poruka od: ©pawno poslato Januar 01, 2020, 20:07:03 POSLE PODNE

Citat: bunta poslato Januar 01, 2020, 19:58:43 POSLE PODNE
ajde malo procitaj V Roleplay temu!

sve već urađeno I iznad navedeno....

Naslov: Odg: MYSQL problem
Poruka od: Salesman poslato Januar 01, 2020, 20:09:04 POSLE PODNE

Druze znaci uzmes ovo ispod sad sto ti pise "KOD ODABERI" kopiras i zamjenis umjesto svog i probas.

[pawn]   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);
}[/pawn]

Citat: Salesman poslato Januar 01, 2020, 20:05:22 POSLE PODNE
[pawn]   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);
}[/pawn]

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

I NIŠTA.

Naslov: Odg: MYSQL problem
Poruka od: Salesman poslato Januar 01, 2020, 20:10:07 POSLE PODNE

Ništa? Nemoguce da je ništa sta ti izbacuje u logu lmao

Citat: Salesman poslato Januar 01, 2020, 20:10:07 POSLE PODNE
Ništa? Nemoguce da je ništa sta ti izbacuje u logu lmao

[pawn]20:08:49 01/01/20] [ERROR] CMySQLQuery::Execute[CheckPlayerData] - (error #1054) Unknown column 'Pawno_Legacy' in 'where clause' (Query: "SELECT * FROM users WHERE p_name = `Pawno_Legacy` LIMIT 1")[/pawn]

Naslov: Odg: MYSQL problem
Poruka od: Salesman poslato Januar 01, 2020, 20:15:38 POSLE PODNE

(https://i.imgur.com/VbSvj33.png)

Citat: Salesman poslato Januar 01, 2020, 20:15:38 POSLE PODNE
(https://i.imgur.com/VbSvj33.png)

sada ni u logovima ništa ne izlazi

Naslov: Odg: MYSQL problem
Poruka od: Salesman poslato Januar 01, 2020, 20:26:08 POSLE PODNE

Znaci da je dobar query ne baca ti errore sve funkcionise. Sada pravi dalje ucitavanje igraca login reg.

Balkan SA:MP

PAWN skriptanje, gamemodovi, filterskripte, include fajlovi, mape, pluginovi => Razgovor u vezi PAWN - skriptanja => Temu započeo: ©pawno poslato Januar 01, 2020, 19:22:45 POSLE PODNE