Can't create projects -> Pop-Up stating "error"

[jnParis]

TimeTracker seems like a very nice tool!

Unfortunately I can't create projects at the moment. When I try to create a new project a pop-up states "error" without any further result.

Environment:

• TimeTracker 0.0.71
• Nextcloud 21.0.4

What works:

• Creating Clients
• Creating Tags
• Use Timer, Dashboard, etc.

What does not work:

• Creating Projects

[mtierltd]

Hi

What database backend are you using?

[jnParis]

Hey,

I'm using a Synology Diskstation with the official MariaDB 10 app (10.3.27-1037) Just opened the database with phpmyadmin and found the timetracker tables. oc_timetracker_project exist but is still empty.

[mtierltd]

Please try our latest 0.0.72 release.

[jnParis]

Just checked: Same issue with nextcloud 22.2 and TimeTracker 0.0.72

[mtierltd]

Please send us your nextcloud logfile with the error message generated by timetracker.

[jnParis]

Here is the log attached. As it states something with colors I tried to choose different or none color but it never worked. (path and username changed in log file)

timetracker.log

[mtierltd]

Can you show me the schema of your oc_timetracker_project table? It seems you are missing a column.

[jnParis]

id | name | client_id | created_by_user_uid | locked | archived | created_at

[mtierltd]

Yes you are definitely missing a column from there. Please set 'debug' => 'true' in your configuration file and then run occ migrations:status timetracker.

[jnParis]

>> App:                                                timetracker
>> Version Table Name:                                 oc_migrations
>> Migrations Namespace:                               OCA\TimeTracker\Migration
>> Migrations Directory:                               mypath/apps/timetracker/lib/Migration
>> Previous Version:                                   000000Date20210719124731
>> Current Version:                                    000001Date20210719192031
>> Next Version:                                       Already at latest migration step
>> Latest Version:                                     000001Date20210719192031
>> Executed Migrations:                                2
>> Executed Unavailable Migrations:                    2
>> Available Migrations:                               2
>> New Migrations:                                     2
>> Pending Migrations:                                 None

[mtierltd]

For some reason, you are missing the color column and that is why you get the error, however the database migrations are up-to-date.

I suggest you just add the missing column.

ALTER TABLE oc_timetracker_project ADD COLUMN color VARCHAR(7) NOT NULL DEFAULT '#ffffff';