Something went wrong with an upgrade and now the blocks are not showing in the blocks admin section of the admin side of my site. I cannot control the blocks, because as soon as I add one it disappears from the admin side even though it shows on the live site.

During the upgrade all my blocks disappeared and I'm trying to re-add all of them.

Please help.

Errors in MySQL Debug when you access the blocks admin section?

Thanks for replying, Mith, I'm really frustrated by this.

No errors. Though there is a reference to tinycontent which is not installed. It says "SELECT storyid,title,link FROM xoops_tinycontent0 WHERE submenu='1' AND visible ORDER BY blockid ( 0.00033)"

A couple of days ago I migrated from 2.0.9.2 to 2.2.2 with no problems. For some reason when I did an upgrade last night when I moved from tinycontent (which seemed to be creating errors [phpdebug] to tinyd and then took a look at the site all my blocks disappeared. I eventually figured out that the blocks_instance table was dropped and had to readd it manually. Now none of the blocks will stay visible in the blocks admin section.

Please help.