[database]cant delete character

[kret]

Hello

when i try to delete character from PHPMYADMIN i have an error

Błąd

zapytanie SQL:

DELETE FROM `test`.`players` WHERE `players`.`id` =4548 LIMIT 1

MySQL zwrócił komunikat: Dokumentacja
#1054 - Unknown column 'value' in 'where clause'

How to fix it? I search answer in google but i dont find anything ;(

 

[Dark Warrior]

Try

DELETE FROM 'players` WHERE 'id` =4548 LIMIT 1

P.S. Make a backup before xD

EDIT: I didn read the post right, Try updating your phpmyadmin at phpmyadmin.net

 

[Blue Charizard]

The mix of ' and ` is never a good ideea... instead use the following:

DELETE FROM `players` WHERE `id` = 4548

It should work properly.

(LIMIT 1 is really only used for SELECT statements, its not used in DELETE statements since `id` is an unique key and thus there can only be one player with id 4548)

 

[kret]

@up

#1054 - Unknown column 'value' in 'where clause'

 

[Blue Charizard]

Are you only executing the line suggested, or are you executing somekind of script file?

 

[royalmichael]

Someone fix this?