I followed the instructions:
- Enable PHP debug
- Run pre-upgrade script
- Reload the page
- Press the submit button to update the system

then the following messages appeared



It results blank page except "User Menu" & "Main Menu", and "Blocks|List all blocks" in Admin area returns nothing.

Please help.

hmmm...

Can you get to the administration area? Try updating first the Extended Profiles module, then the System module afterwards.

I'll see if I can reproduce and fix this.

Same trouble here.



I can get into system since I got a test site running and can copy the link to my main site.

Updating the extended users seems to work but I'm afraid to say that I lost all the users (as far as I can see for now). In the forum the post on the mainpage (CBB latest) do show usernames. Clicking them gives: ' No user selected. Please go back and try again.'
Actualy going into the forum list all post as writen by guest....

Strange third problem: lost all the right blocks and even though I can click Blocks, no blocks are shown (on the test site they do)

Any clues on how to rescue as much as possible?

Regards

Did you update the system module after the Ext. Profiles module update?

I'm not sure anymore I'm afraid. I believe I tried the xoopsupdate.php which partly failed. Went on to update the system module and then the extended profiles.

Do the system module update from modules admin once more and see if it changes anything.

Will have to track down this one, but it may take a week or so.

trying system again gives something like xoopsupdate.php did:



I hope you find a solution!

Thanx for trying to solve this.

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???

What php - MySQL version is everyone using with these problems?

I can confirm and reproduce the problem, when going from XOOPS 2.0.13.2 to 2.2.3 Final.

The many routines to run to update the system got in the way of each other.

I have fixed it and am uploading to sf.net now.