MySQL

[JohnnY.]

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] [ERROR] CMySQLQuery::Execute[SendQuery] - (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] [ERROR] CMySQLQuery::Execute[SendQuery] - (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] [ERROR] CMySQLQuery::Execute[SendQuery] - (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] [ERROR] CMySQLQuery::Execute[SendQuery] - (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] [ERROR] CMySQLQuery::Execute[SendQuery] - (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] [ERROR] CMySQLQuery::Execute[SendQuery] - (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] [ERROR] CMySQLQuery::Execute[SendQuery] - (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] [ERROR] CMySQLQuery::Execute[SendQuery] - (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] [ERROR] CMySQLQuery::Execute[SendQuery] - (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] [ERROR] CMySQLQuery::Execute[SendQuery] - (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] [ERROR] CMySQLQuery::Execute[SendQuery] - (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

[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

[JohnnY.]

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.

[JohnnY.]

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.