• Roel
  • Roel
  • Administrator
  • Offline
  • Registered: 2018-02-26
  • Posts: 565

Topic: LuxCal 5.2.0 SQL error when opening User Profile

When you are logged in and select your user name and then User Profile, an SQL error may occur.

To solve this, edit the file "pages/account.php" and on line 73 remove the text ",`number`" (in the middle).
So thereafter line 73 should be:

$stH = stPrep("SELECT `ID`,`name`,`email`,`phone`,`language` FROM `users` WHERE `ID` = ?");
  • Registered: 2022-02-02
  • Posts: 2

Re: LuxCal 5.2.0 SQL error when opening User Profile

How do you remove the User Profile menu option?

Jim

  • Roel
  • Roel
  • Administrator
  • Offline
  • Registered: 2018-02-26
  • Posts: 565

Re: LuxCal 5.2.0 SQL error when opening User Profile

Hi Jim,

You will need to change the PHP code to remove this. If you really want to do this, edit the file "common/header.php" and delete line 232 completely.
Line 232 looks like this:

<p onclick=\"index({cP:21});\">{$xx['title_profile']}</p>

Roel