MySQL

Skripta koju koristim: NL
Detaljan opis problema: Prebacio sam cijeli NL na novi MySQL jer stari je uzasan (logicno) i sad samo NEKADA, znaci ne resetira stalno, nego samo NEKADA resetira pare i level, dok zlato i sve ostalo ne, samo pare i lvl mi resetira, ne znam zasto niti kako no baca error u mysql_log.txt kad se taj reset dogodi...

[23:47:30] 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 'WHERE `ID` = '17'' at line 1
[23:50:21] 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 'WHERE `ID` = '17'' at line 1
[23:51:07] 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 'WHERE 'Test_Test'' at line 1
[23:51:51] 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 'WHERE 'Test_Test'' at line 1
[23:54: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 'WHERE 'Test_Test'' at line 1
[23:57:47] 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 'WHERE 'Test_Test'' at line 1
[00:05:09] 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 'WHERE `ID` = '17'' at line 1
[00:08:50] 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 'WHERE `ID` = '17'' at line 1
[00:13:36] 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 'WHERE `ID` = '17'' at line 1
[00:15:24] 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 'WHERE `ID` = '17'' at line 1
[15:49:40] 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 'WHERE `ID` = '17'' at line 1

Dio skripte:
Neke slike/video za lakse dobivanje pomoci(neobavezno): Isto tako ne znam kako u bazi da resetiram IDove igraca, ako ih obrisem (igrace) nastavlja se id tamo di je stao, ja zelim da krene od 0 trenutno, ali on krene tamo di je stao...

@CADILAB

Za to prvo ne mogu da ti dam specifican odgovor, jedino sto mogu da ti kazem jeste da upit nije dobro napisan a sada koji je to upit ne znam najbolje da ga pokusas debugovati.
A za ovo drugo, ako sam te dobro razumeo, hoces da resetujes redni broj od kojeg ai krece kada obrises sve igrace ?
Za to moras ici u (sad ne znam jel koristis phpmyadmin, heidi...ali predpostavljam phpmyadmin) phpmyadmin, bazu na koju se povezujes, onda otvori sql i upisi

ALTER TABLE players(kako ti se vec zove) AUTO_INCREMENT = 1

Cadilab wrote on August 24, 2017, 4:48 pm:

Za to prvo ne mogu da ti dam specifican odgovor, jedino sto mogu da ti kazem jeste da upit nije dobro napisan a sada koji je to upit ne znam najbolje da ga pokusas debugovati.
A za ovo drugo, ako sam te dobro razumeo, hoces da resetujes redni broj od kojeg ai krece kada obrises sve igrace ?
Za to moras ici u (sad ne znam jel koristis phpmyadmin, heidi...ali predpostavljam phpmyadmin) phpmyadmin, bazu na koju se povezujes, onda otvori sql i upisi

ALTER TABLE players(kako ti se vec zove) AUTO_INCREMENT = 1

Rijesio sam drugo, resetirao sam ga vec. A za prvo kazes nije upit ispravno napisan. Hvala na odgovoru, pokisat cu rijesiti.

Jedva sam otvorio mysql_log koliko je unutra naspamano svega i svacega....

Cim mi resetira javit cu ti se jer se ja slabo razumijem u MySQL. Ne razumijem se kao ti.  😠