issue with column groups in table users

[hungryfrankie]

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

[hungryfrankie]

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)";
  `