1
yaleyu
Problems when upgrade from 2.0.13.1 to 2.2.3 Final
  • 2005/10/30 16:00

  • yaleyu

  • Just popping in

  • Posts: 5

  • Since: 2002/12/26


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

Unable to install SystemError(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 (profileiduser_icquser_fromuser_siguser_viewemailuser_aimuser_yimuser_msnmuser_occurlbiouser_intrestumodeuordernotify_methodnotify_modeuser_regdatepostsattachsigtimezone_offsetuser_mailokthemeactkeylast_loginSELECT uiduser_icquser_fromuser_siguser_viewemailuser_aimuser_yimuser_msnmuser_occurlbiouser_intrestumodeuordernotify_methodnotify_modeuser_regdatepostsattachsigtimezone_offsetuser_mailokthemeactkeylast_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.


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

Please help.

2
Mithrandir
Re: Problems when upgrade from 2.0.13.1 to 2.2.3 Final

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.
"When you can flatten entire cities at a whim, a tendency towards quiet reflection and seeing-things-from-the-other-fellow's-point-of-view is seldom necessary."

Cusix Software

3
powadha
Re: Problems when upgrade from 2.0.13.1 to 2.2.3 Final
  • 2005/10/30 16:49

  • powadha

  • Just popping in

  • Posts: 41

  • Since: 2005/2/27


Same trouble here.

Unable to install SystemError(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 li3Pl04DxW_user_profile (profileiduser_icquser_fromuser_siguser_viewemailuser_aimuser_yimuser_msnmuser_occurlbiouser_intrestumodeuordernotify_methodnotify_modeuser_regdatepostsattachsigtimezone_offsetuser_mailokthemeactkeylast_loginSELECT uiduser_icquser_fromuser_siguser_viewemailuser_aimuser_yimuser_msnmuser_occurlbiouser_intrestumodeuordernotify_methodnotify_modeuser_regdatepostsattachsigtimezone_offsetuser_mailokthemeactkeylast_login FROM li3Pl04DxW_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.


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

4
Mithrandir
Re: Problems when upgrade from 2.0.13.1 to 2.2.3 Final

Did you update the system module after the Ext. Profiles module update?
"When you can flatten entire cities at a whim, a tendency towards quiet reflection and seeing-things-from-the-other-fellow's-point-of-view is seldom necessary."

Cusix Software

5
powadha
Re: Problems when upgrade from 2.0.13.1 to 2.2.3 Final
  • 2005/10/30 17:08

  • powadha

  • Just popping in

  • Posts: 41

  • Since: 2005/2/27


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.

6
Mithrandir
Re: Problems when upgrade from 2.0.13.1 to 2.2.3 Final

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.
"When you can flatten entire cities at a whim, a tendency towards quiet reflection and seeing-things-from-the-other-fellow's-point-of-view is seldom necessary."

Cusix Software

7
powadha
Re: Problems when upgrade from 2.0.13.1 to 2.2.3 Final
  • 2005/10/30 17:15

  • powadha

  • Just popping in

  • Posts: 41

  • Since: 2005/2/27


trying system again gives something like xoopsupdate.php did:

Unable to install SystemError(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 li3Pl04DxW_user_profile (profileiduser_icquser_fromuser_siguser_viewemailuser_aimuser_yimuser_msnmuser_occurlbiouser_intrestumodeuordernotify_methodnotify_modeuser_regdatepostsattachsigtimezone_offsetuser_mailokthemeactkeylast_loginSELECT uiduser_icquser_fromuser_siguser_viewemailuser_aimuser_yimuser_msnmuser_occurlbiouser_intrestumodeuordernotify_methodnotify_modeuser_regdatepostsattachsigtimezone_offsetuser_mailokthemeactkeylast_login FROM li3Pl04DxW_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.

Back to Module Administration page


I hope you find a solution!

Thanx for trying to solve this.

8
jhintze
Re: Problems when upgrade from 2.0.13.1 to 2.2.3 Final
  • 2005/10/30 19:11

  • jhintze

  • Just popping in

  • Posts: 3

  • Since: 2005/10/30


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

9
sitekeep
Re: Problems when upgrade from 2.0.13.1 to 2.2.3 Final
  • 2005/10/30 20:33

  • sitekeep

  • Just popping in

  • Posts: 12

  • Since: 2003/2/7 7


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

10
Mithrandir
Re: Problems when upgrade from 2.0.13.1 to 2.2.3 Final

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.
"When you can flatten entire cities at a whim, a tendency towards quiet reflection and seeing-things-from-the-other-fellow's-point-of-view is seldom necessary."

Cusix Software

Login

Who's Online

169 user(s) are online (67 user(s) are browsing Support Forums)


Members: 0


Guests: 169


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits