Cannot create Tasks, Task Manager Blank

[Wayne Workman]

FOG release, being 1.2.0 ?

[Juan Bertolotti]

Yes sir

[Tom Elliott]

Was this an upgrade or fresh install?

[Juan Bertolotti]

Fresh install

[Tom Elliott]

And what tasking are you trying to do

[Juan Bertolotti]

Download task.
[FONT=helvetica][COLOR=#373e4d][SIZE=12px]Anyway I cannot see any task on the basic or advance menu.[/SIZE][/COLOR][/FONT]
[FONT=helvetica][COLOR=#373e4d][SIZE=12px]If I click on the “Download” arrow I get[/SIZE][/COLOR][/FONT]
[SIZE=16px][FONT=Ubuntu][COLOR=#ff0000][CENTER]task failed to create for [U]XXXXX[/U] with image[/CENTER][/COLOR][/FONT][/SIZE]
[SIZE=16px][FONT=Ubuntu][COLOR=#ff0000][CENTER]Task Type is not valid[/CENTER][/COLOR][/FONT][/SIZE]
[LEFT][SIZE=16px][COLOR=#000000]I just replaced the hostname.[/COLOR][/SIZE][/LEFT]

[Tom Elliott]

How did the task type table get removed? Do you have a table named taskType?

[Juan Bertolotti]

I didnt do anything , it may be a DB issue?

[Tom Elliott]

I’m thinking you’re missing the taskType table or maybe it didn’t get updated?

[Wayne Workman]

I’d re-run the installer…

[Tom Elliott]

Rerunning won’t matter because db needs to be updated. It seems like there was a problem with it loading the schema information

[Juan Bertolotti]

any way to update db manually?

[Juan Bertolotti]

Im not able to see fog.taskTypes and fog.taskStates on my DB ,

[Tom Elliott]

I’d say try reinstalling from scratch, and if the same problem occur’s please let us know.

[Juan Bertolotti]

I need the sql code to regenerate task* tables, any guess?

[Juan Bertolotti]

I solved the problem by creating missing task* tables using a new instalation db as example, worked like charm. Would be great to have sql code to regenerate tables in case of this.
Thanks for your time and advice!