codestudiohq / laravel-totem

Manage Your Laravel Schedule From A Web Dashboard
MIT License
1.78k stars 224 forks source link

Totem 6.x +Postgresql = column "duration" cannot be cast automatically to type numeric #262

Closed viccatoff closed 3 years ago

viccatoff commented 3 years ago

I have an error while migrating database:

SQLSTATE[42804]: Datatype mismatch: 7 ERROR:  column "duration" cannot be cast automatically to type numeric
  HINT:  You might need to specify "USING duration::numeric(24,14)". (SQL: ALTER TABLE totemtask_results ALTER duration TYPE NUMERIC(24, 14))

I know it was fixed in https://github.com/codestudiohq/laravel-totem/pull/251, but it's not fixed for version 6.x. Do you support this version? I'm using it, because we can't update right now to laravel 7/8.

qschmick commented 3 years ago

@viccatoff Can you open a PR with the fix from #251 pointing to the 6.x repo and we can take a look at that?

stale[bot] commented 3 years ago

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.