Open hungryfrankie opened 3 years ago
the solution is to put it in backtick
I changed the querry to this
$query = "INSERT INTO " . $DBPrefix . "users
(nick, password, hash, name, address, city, prov, country, zip, phone, nletter, email, birthdate,
suspended, language, balance, timezone,`groups`)
VALUES
(:nick, :password, :hash, :name, :address, :city, :prov, :country, :zip, :phone, :nletter, :email, :birthdate,
:suspended, :language, :balance, :timezone,:groups)";
`
when. a new user registers the data is not entered in the db the reason is the field named groups. sql breaks because it is a reserved word. I had to change the name of this field mysql 8.0.25 php 7.3.24