🐛 [BUG] Update 62 fails to create table hrperfcriteriascores

[efeoli]

Description

Title is self descriptive

Reproduction URL

https://github.com/timschofield/webERP/issues

Reproduction steps

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Screenshots

![DESCRIPTION](LINK.png)

Logs

Browsers

No response

OS

No response

[dalers]

Same error with update 62 when performing updates 61 and 62.

webERP update log:

dale@server1:/usr/local/www/weberp $ less companies/weberp_scc_sb/logs/weberp_scc_sb\ -\ DBUpdateLog-2026-05-05.log
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
          Update File Number - 61
          Updated on - 2026-05-05
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
          Update File Number - 62
          Updated on - 2026-05-05
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

/*
***ERROR*** The table hrperfcriteriascores could not be created

companies/weberp_scc_sb/logs/weberp_scc_sb - DBUpdateLog-2026-05-05.log (END)

Apache error log:

[Tue May 05 08:06:13.164127 2026] [proxy_fcgi:error] [pid 68553:tid 36575444754440] [client 174.0.43.39:50449] AH01071: Got error 'PHP message: PHP Warning: mysqli_query(): (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci' at line 17 in /usr/local/www/weberp/includes/ConnectDB_mariadb.php on line 63', referer: https://weberp.dalescott.net/Z_UpgradeDatabase.php
dale@server1:/usr/local/www/weberp $

No error in MariaDb error log.

Using PHP 8.2 and MariaDb 10.4 on FreeBSD 14.3

[dalers]

Curious that a description is not shown for update 62 after logging in again after the failed upgrade (I didn't notice if a description was missing before upgrading in the first place).

[dalers]

Same error on Windows Xampp PHP 8.2 and MariaDb 10.4.

Warning: mysqli_query(): (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci' at line 17 in C:\xampp\htdocs\weberp\includes\ConnectDB_mariadb.php on line 63

[dalers]

Can anyone suggest a workaround or solution? I have Z_ImportStocksBoms.php ready to contribute with a new update to register the script and add to the menu.

[pakricard]

Hi all:
I faced the same problem and I just committed a fixed 62.php that should solve the issue.
To reset the DB properly, Just go to phpMyAdmin, table config.php and reset "DBUpdateNumber" to 61.

@timschofield : I will review your previous commits about HR module in the following days. ;-)

R

[dalers]

Thanks @pakricard I should be able to test tomorrow.