The patch seemed to work. When I used xoopsupdater.php at first I still got errors, but when I ran the update from the system module everything seemed to work and my users are all back.

Thanks for your effort on this. Great work!

I'll try and download the updates you are posting. But for your information my hosting company is using the following:

PHP version 4.3.11
MySQL version 4.0.25-standard-log

I have the same or similar issues when updating my XOOPS as well. I get the following after running the updater:

Unable to install System. Error(s):
- 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
loginname field added
uname field updated
loginname data updated
xoops_module_update_system executed successfully.

Module System updated successfully.

And then the following when trying to run the system update in the module administration:

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.

Module System updated successfully.

Any ideas???