Change password error.

**AlienHere2** · 2022-01-26 20:57:55

When I click on my name and click on user profile. I get a error:
SQL error: see logs/sql.log

When I see it. this is the error:

mycal:ERROR Script: /index.php - SQL execute error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'number' in 'field list'

So, I cannot view profile inorder to change password or whatever changes I need to make. Running the latest version. LuxCal V5.2.0M

any help would be appreciated.

Roel · 2022-01-27 00:45:04

Hi there,

You found a anomaly in the account script. Please do the following:

Edit the file "pages/account.php" and on line 73 delete the text ",`number`" (in the middle of the line).

So line 73 will now look as follows:

$stH = stPrep("SELECT `ID`,`name`,`email`,`phone`,`language` FROM `users` WHERE `ID` = ?");

That's all.
Roel

**AlienHere2** · 2022-01-27 01:58:15

Thank you! That worked.

Posts: 3