i first tried upgrading to 2.2, then i put the 2.3 files on top.

the start page comes up and i can click on the modules on the left menu and they display, but none of my original blocks are here.

when i click blocks/list all blocks, there are none listed and i cant find where to configure them.

also, im suspecing a problem with the database schema. did the xoopsupdate.php try to change the schema and get it wrong? for example, when i go into admin/modules and try to update the system module, i get this:

Unable to install System. Error(s):
- Could not add nameid field in configcategory table
- Could not add description field in configcategory table
- Could not add module id field in configcategory table
- Could not delete user configuration category
- Could not insert System to database.
xoops_module_pre_update_system executed successfully.
Unknown column 'umode' in 'field list'
INSERT INTO xoops_user_profile (profileid, user_icq, user_from, user_sig, user_viewemail, user_aim, user_yim, user_msnm, user_occ, url, bio, user_intrest, umode, uorder, notify_method, notify_mode, user_regdate, posts, attachsig, timezone_offset, user_mailok, theme, actkey, last_login) SELECT uid, user_icq, user_from, user_sig, user_viewemail, user_aim, user_yim, user_msnm, user_occ, url, bio, user_intrest, umode, uorder, notify_method, notify_mode, user_regdate, posts, attachsig, timezone_offset, user_mailok, theme, actkey, last_login FROM xoops_users
Can't DROP 'block_id'. Check that column/key exists
Can't DROP 'module_id'. Check that column/key exists
Duplicate column name 'pageid'
xoops_module_update_system executed successfully.

is there something obvious im missing or is my database borked?

thanks for any help,