Hi All,
I have a small site where it seems like the xoopsupgrade.php script fails.
When run, I get:
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 x_bigsplash_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 x_bigsplash_users
Can't DROP 'block_id'; check that column/key exists
Can't DROP 'module_id'; check that column/key exists
Can't DROP 'PRIMARY'; check that column/key exists
Duplicate column name 'pageid'
Duplicate entry '1-0-0' for key 1
xoops_module_update_system executed successfully.
The site show the top banner area, but then fails as it's about to create the left blocks.
If I access /admin.php, is the System modul missing, as assumed by the error above.
Any helpfull thoughts?