Automatic upgrade error

[davidl]

I am running Timetrex version 16.3.2 on Ubuntu 22.04 and have been getting the following automatic upgrade error in the timetrex log.

Code: Select all

[P0303430] [00622ms] [L1277]: Validator::Error(): Validation Error: Label: name Value: "0" Msg: Name already exists
[P0303430] [00622ms] [L1240] Array: Validator::isError(): Errors
array(1) {
  ["name"]=>
  array(1) {
    [0]=>
    string(19) "Name already exists"
  }
}

This is the result from select * from system_setting

Code: Select all

05f52dd7-b94b-27fb-e724-22a017395bd9 | auto_upgrade_failed         | 0
 05f52dd7-b98a-c77d-bb80-22a017395bd9 | new_version                 | 0
 22a01739-5b43-1eb9-61ff-000000000007 | update_notify               | 0
 22a01739-5b43-1eb9-61ff-000000000008 | anonymous_update_notify     | 0
 22a01739-5b43-1eb9-61ff-000000000010 | new_version                 | 0
 22a01739-5b43-1eb9-61ff-000000000005 | system_version              | 16.1.3
 22a01739-5b43-1eb9-61ff-000000000001 | schema_version_group_A      | 1137A
 22a01739-5b43-1eb9-61ff-000000000012 | auto_upgrade_failed         | 0
 22a01739-5b43-1eb9-61ff-000000000011 | valid_install_requirements  | 1
 22a01739-5b43-1eb9-61ff-000000000006 | system_version_install_date | 1676915416
 22a01739-5b43-1eb9-61ff-000000000003 | tax_data_version            | 20221001
 22a01739-5b43-1eb9-61ff-000000000004 | tax_engine_version          | 1.0.61
 05ca841f-d523-38fa-8246-22a017395bd9 | last_notification_sync_time | 1630043702
 05f52de2-64c6-e3d9-6fc6-22a017395bd9 | registration_key            | c92f76c566e54ae19d7b3515e9e697d1
 cbe1532d-047c-7680-b73d-000000000002 | schema_version_group_A      | 1142A
 05f52dcc-7cdc-3b07-cbd3-cbe1532d0479 | tax_data_version            | 20230101
 05f52dcc-7ceb-9eab-c698-cbe1532d0479 | tax_engine_version          | 1.0.62
 05f52dcc-7d7d-50de-238e-cbe1532d0479 | system_version              | 16.3.2
 05f52dcc-7d8c-7fca-2ae9-cbe1532d0479 | system_version_install_date | 1676951936
 05f52dcd-4f6a-b76a-8f15-cbe1532d0479 | update_notify               | 1
 05f52dcd-4ff3-763b-51f5-cbe1532d0479 | anonymous_update_notify     | 0
 05f52dd4-3175-3b18-6f6d-22a017395bd9 | last_notification_sync_time | 1676952065
 05f52dd4-4ba6-918d-f3a7-22a017395bd9 | valid_install_requirements  | 1

How can I get Timetrex to upgrade?

[mikeb]

Your system_settings table appears to be corrupted as it has duplicate rows. This can occur if you tried migrating the database from one system to another, or modified the database outside of TimeTrex at all, among other reasons.

Its likely you may have other corrupted data as well, but you will need to remove all the duplicate rows from the "system_setting" table at the very least.

[davidl]

I deleted the duplicate rows from the system_setting table and Timetrex was successfully upgraded automatically. Thanks so much for your help!

[mikeb]

Good to hear it resolved your issue.


If you've found value in using TimeTrex, we kindly ask you to consider leaving a review. Your feedback not only motivates our dedicated volunteers, who devote countless hours away from their loved ones to maintain and enhance this open-source project, but it also helps new users to discover and join our growing community.

Sharing your experiences and satisfaction with TimeTrex helps us continue to grow and improve. Thank you for your support!

Leave a review – it only takes a moment, but it makes a huge difference.