02-25-2023, 09:31 PM
I guess everything starts from table systypes, and if column typeno is not updated correctly it'll let to duplicate entry for whatever key.
When I installed/upgraded to version 4.15.2 most accounts couldn't be update,
I took a look to the systypes tables and I found out that all typeno where updated back to 0 and under SQL_CommonFunctions.inc
line 19
increments any primary ID of a give account ID (typename), however I don't get it why that when I ran the upgrade all my typeno was updated to back to 0, Hence facing Duplicate entry for key 'PRIMARY' for almost everything
When I installed/upgraded to version 4.15.2 most accounts couldn't be update,
I took a look to the systypes tables and I found out that all typeno where updated back to 0 and under SQL_CommonFunctions.inc
line 19
PHP Code:
$SQL = "UPDATE systypes SET typeno = typeno + 1 WHERE typeid = '" . $TransType . "'";
increments any primary ID of a give account ID (typename), however I don't get it why that when I ran the upgrade all my typeno was updated to back to 0, Hence facing Duplicate entry for key 'PRIMARY' for almost everything