mtierltd / timetracker

GNU Affero General Public License v3.0
82 stars 27 forks source link

missing database update after upgrading to 0.77 Version #207

Open fpPierre opened 1 year ago

fpPierre commented 1 year ago

Dear @all.

I have updated my timetracker to the current version 0.77.

Somehow my databases wasen´t altered well / correct.

Following on that I entered / added manually the missing columns oc_timetracker_project.color and oc_timetracker_work_interval.cost.

Since I have done this I can use the UI flawless.

Nevertheless I get the error outlined hereinafter: {"reqId":"fdSCqVUT3OrtyZmd9l7W","level":3,"time":"2023-03-16T17:10:54+00:00","remoteAddr":"XXX.XXX.XXX.XXX","user":"Xxxxx Buettner","app":"index","method":"POST","url":"/index.php/apps/timetracker/ajax/timeline","message":{"Exception":"BadFunctionCallException","Message":"cost is not a valid attribute","Code":0,"Trace":[{"file":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","line":151,"function":"setter","class":"OCP\AppFramework\Db\Entity","type":"->"},{"file":"/var/www/nextcloud/apps/timetracker/lib/Controller/AjaxController.php","line":1019,"function":"__call","class":"OCP\AppFramework\Db\Entity","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":169,"function":"postTimeline","class":"OCA\TimeTracker\Controller\AjaxController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":100,"function":"executeController","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":152,"function":"dispatch","class":"OC\AppFramework\Http\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":309,"function":"main","class":"OC\AppFramework\App","type":"::"},{"file":"/var/www/nextcloud/lib/base.php","line":1008,"function":"match","class":"OC\Route\Router","type":"->"},{"file":"/var/www/nextcloud/index.php","line":37,"function":"handleRequest","class":"OC","type":"::"}],"File":"/var/www/nextcloud/lib/public/AppFramework/Db/Entity.php","Line":122,"CustomMessage":"--"},"userAgent":"xxxxxxxx"}

To get rid of that issue I tried several column types within the database (DECIMAL, FLOAT, INT) for the column oc_timetracker_work_interval.cost. Finally the issue occurs consistently.

Summarized I do have the bad feeling that my database tables aren´t compatible with 0.77 and am looking for the CREATE / ALTER Table statements. Is somebody able to provide this statements to allow me a comparison?

In addition my somebody is able to help me with my above mentioned "cost" issue.

Thanks a lot.

Cheers, Pierre