vendredi 24 juin 2016

phpMyAdmin giving errors everywhere and its because its not adding in a where clause in the queries

phpMyAdmin is giving me errors every time I try to do an inline edit or click the edit or delete buttons. If I click the edit button on one of my records in a database it comes back with the error:

ERROR

SQL Query:
SELECT * FROM "project"."blogPosts" WHERE ;

MySQL Said:
#1064 - You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server
version for the right syntax to use near '' at line 1

I don't understand this as why would phpMyAdmin not include a where clause when i click on an inbuilt button. Of course it will throw an error if it doesn't include that? The same thing happens whenever I double click on an element in a table and then edit that element and press enter to save the inline edit.

Any ideas on how to fix this would be greatly appreciated!

Thanks :)

EDIT:

For lack of clarity before, here's a video of my error!

https://streamable.com/en0b

Aucun commentaire:

Enregistrer un commentaire