1
Hi,
I'm trying to build a new site, and everything is new right now so I don't have to worry about losing users or data.
First I tried to manually install 2.2, but I could not get a database to work for the install. I tried creating one, and tried letting XOOPS build one during install. I couldn't get it.
So, I just installed XOOPS 2.0.10 via fantastico (I know its out of date, but anyway). I then proceeded to manually update to 2.0.10 to 2.0.12a then 2.0.12a to 2.0.13. Everything up to this point is fine.
I then tried to manually update from 2.0.13 to 2.2. This went pretty good until I ran the mysite.com/update script. I keep getting errors when updating. It appears to be a database problem?? But I am totally retarded when trying to figure out the databases.
here's the errors.
Adding module config category data...
[color=FF0000]ERROR: Could not insert config category general to the database.
ERROR: Could not insert config category meta to the database.
ERROR: Could not insert config category censor to the database.
ERROR: Could not insert config category search to the database.
ERROR: Could not insert config category mail to the database.
ERROR: Could not insert config category auth to the database.[/color]
Adding module config data...
Config sitename added to the database.
And
Adding user profile fields...
[color=FF0000]ERROR: Could not insert field umode into the database. Table 'robert4_xoop1.xoops_user_profile' doesn't exist
ERROR: Could not insert field uorder into the database. Table 'robert4_xoop1.xoops_user_profile' doesn't exist
ERROR: Could not insert field notify_method into the database. Table 'robert4_xoop1.xoops_user_profile' doesn't exist
ERROR: Could not insert field notify_mode into the database. Table 'robert4_xoop1.xoops_user_profile' doesn't exist
ERROR: Could not insert field user_regdate into the database. Table 'robert4_xoop1.xoops_user_profile' doesn't exist
ERROR: Could not insert field posts into the database. Table 'robert4_xoop1.xoops_user_profile' doesn't exist
ERROR: Could not insert field attachsig into the database. Table 'robert4_xoop1.xoops_user_profile' doesn't exist
ERROR: Could not insert field timezone_offset into the database. Table 'robert4_xoop1.xoops_user_profile' doesn't exist
ERROR: Could not insert field user_mailok into the database. Table 'robert4_xoop1.xoops_user_profile' doesn't exist
ERROR: Could not insert field theme into the database. Table 'robert4_xoop1.xoops_user_profile' doesn't exist
ERROR: Could not insert field actkey into the database. Table 'robert4_xoop1.xoops_user_profile' doesn't exist
ERROR: Could not insert field last_login into the database. Table 'robert4_xoop1.xoops_user_profile' doesn't exist[/color]
Module System updated successfully.
I have tried logging into phpmyadmin and creating a table named xoops_user_profile but I have to enter fields in order to save it. If I create the fields listed in the error messages (which I don't know what values and attributes, etc to give each field) I get the following error message. PLuse the same error message I posted at the top of this post.
Adding user profile fields...
[color=FF0000]ERROR: Could not insert field umode into the database. Duplicate column name 'umode'
ERROR: Could not insert field uorder into the database. Duplicate column name 'uorder'
ERROR: Could not insert field notify_method into the database. Duplicate column name 'notify_method'
ERROR: Could not insert field notify_mode into the database. Duplicate column name 'notify_mode'
ERROR: Could not insert field user_regdate into the database. Duplicate column name 'user_regdate'
ERROR: Could not insert field posts into the database. Duplicate column name 'posts'
ERROR: Could not insert field attachsig into the database. Duplicate column name 'attachsig'
ERROR: Could not insert field timezone_offset into the database. Duplicate column name 'timezone_offset'
ERROR: Could not insert field user_mailok into the database. Duplicate column name 'user_mailok'
ERROR: Could not insert field theme into the database. Duplicate column name 'theme'
ERROR: Could not insert field actkey into the database. Duplicate column name 'actkey'
ERROR: Could not insert field last_login into the database. Duplicate column name 'last_login'[/color]
Module System updated successfully.
Could someone please help explain what I have to do, in somewhat simple terms...possibly a step-by-step to walk me through??
Thanks,
Rob
Thanks for everything!
Later,
Rob