Cannot create Tasks, Task Manager Blank

[Juan Bertolotti]

[SIZE=13px][INDENT]I click on my Host Management, then select the Host I want to make an image from then click on “Basic Tasks” on the left side and selected “Upload”. Once I left click “Upload” it takes me to the Task Management section but all I have is a blank page with the Fog Menu at the top and below that it says Task Management and doesn’t allow me to do anything else.[/INDENT]
[INDENT]Im running lastest fog release on ubuntu 13.04[/INDENT]
[INDENT]Ive found this on the apache logs, any ideas?[/INDENT][/SIZE]
[SIZE=11px] [/SIZE]
[Tue Apr 14 14:18:26.290350 2015] [:error] [pid 16340] [client 192.168.1.55:17948] PHP Fatal error: Uncaught exception ‘Exception’ with message ‘Task Type is not valid’ in /var/www/fog/lib/fog/Host.class.php:968\nStack trace:\n#0 /var/www/fog/lib/fog/BootMenu.class.php(371): Host->createImagePackage(1, ‘AutoRegTask’, false, false, true, false, ‘jmb’)\n#1 /var/www/fog/lib/fog/BootMenu.class.php(343): BootMenu->setTasking()\n#2 /var/www/fog/lib/fog/BootMenu.class.php(146): BootMenu->verifyCreds()\n#3 /var/www/fog/service/ipxe/boot.php(14): BootMenu->__construct(Object(Host))\n#4 {main}\n thrown in /var/www/fog/lib/fog/Host.class.php on line 968

[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!