| Re: upgrade problem 2.0.13 - 2.2 |
| by rob777 on 2005/8/5 19:40:45 Thanks for the offer to help, but I have already scrapped the site and tried the fresh 2.2 install again. It was a brand new site, so there were no users, visitors or data to be saved on the datbase yet, so I could just delete and try again. Somehow I managed to get the database and the 2.2 install to connect correctly. Don't ask how...I don't quite know for sure...I created the database in phpmyadmin...ran the install...tweak the user login, database name, password ect. until the install finally went through correctly. Now I am trying to get some modules to work on the 2.2. LOL here I go again. It would really help if I knew something about php. Thanks, Rob |
| Re: upgrade problem 2.0.13 - 2.2 |
| by louisg1 on 2005/8/5 18:08:33 well it looks like you forgot to follow the directions correctly i can help you get your site working make a full backup of your database tempoarialy shut your site down and give me access to your database. i know the problems i had the same 1s you have to manually convert your users over to XOOPS 2.2 and have to change the system module nuber to 2.2 all has to be done from php my admin. |
| upgrade problem 2.0.13 - 2.2 |
| by rob777 on 2005/8/5 6:57:26 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. le="color: #000000"><?php 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 le="color: #000000"><?php 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. le="color: #000000"><?php 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 |
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|