Automatic upgrade error

Ask your questions regarding TimeTrex installation here.
Post Reply
davidl
Posts: 2
Joined: Sun Feb 25, 2024 6:42 pm

Automatic upgrade error

Post by 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
Posts: 710
Joined: Thu Jul 27, 2006 11:58 am

Re: Automatic upgrade error

Post by 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.
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
davidl
Posts: 2
Joined: Sun Feb 25, 2024 6:42 pm

Re: Automatic upgrade error

Post by davidl »

I deleted the duplicate rows from the system_setting table and Timetrex was successfully upgraded automatically. Thanks so much for your help!
mikeb
Posts: 710
Joined: Thu Jul 27, 2006 11:58 am

Re: Automatic upgrade error

Post by 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. 🙏
TimeTrex Community Edition is developed and supported by volunteers.
Help motivate us to continue by showing your appreciation!
Post Reply