admin_user.php

[fleetlognorge]

Hi,

Thank you for this fantastic product, it was exactly what I was looking for! :)

I deployed this in my environment yesterday by using the install.sh. Today I noticed that I was unable to create more users, and apache2 was throwing some sql errors.

Digging deeper I saw that there were some syntax error in the sql query in the file located at /var/www/hostname/post/admin/admin_user.php

The original query looked like this:

mysqli_query($mysqli, "INSERT INTO users SET user_name = '$name', user_email = '$email', user_password = '$password', user_specific_encryption_ciphertext = '$user_specific_encryption_ciphertext' user_role_id = $role");

In the end here you can see it is missing comma and single-quotes
I edited the line to the below code, and that worked perfectly

mysqli_query($mysqli, "INSERT INTO users SET user_name = '$name', user_email = '$email', user_password = '$password', user_specific_encryption_ciphertext = '$user_specific_encryption_ciphertext', user_role_id = '$role'");

[github-actions]

Hello & Welcome! :)

Thanks for taking the time to get in touch.

We ask that all bugs/feature/support requests are raised via the forum. We'll be in touch shortly to confirm.

[wrongecho]

@johnnyq for vis

[wrongecho]

Hello @fleetlognorge

Thank you for reporting. #1201 should resolve this.

Please raise anything in future via the Forum instead.

Thanks.