| 1.2.8 -> 2.0.1 woes [message #3149] |
Wed, 12 June 2002 16:48  |
 |
rwest
Messages: 24
Registered: March 2002
Karma: 0
|
Junior Member |
|
|
I thought I would tackle upgrading to FUDForum 2.0.1 from 1.2.8, but I have had no luck.
Right off the bat, the first thing it complains about (the upgrade script, that is) is that "mime_types" is not defined in the fud_attach table.
I tried creating that by hand (int(10), not null, 0, UNSIGNED), and that got me past there.
It popped up the query to have me log in to the forum, but repeated attempts failed. I tried re-running the script, and that allowed me in, but the window that popped up shows:
Rebuilding users' last post ids
--------------------------------------
Error in function/script: db.inc
has caused the following error: query failed: %( UPDATE fud_users SET u_last_post_id=157 WHERE id=0 )% because %( Unknown column 'u_last_post_id' in 'field list' )%
while processing script name: /home/httpd/html/forums/adm/consist.php
the error occured at: 12/06/2002 16:35:01 GMT
Browser: Mozilla/5.0 Galeon/1.2.0 (X11; Linux i686; U;) Gecko/20020311
User Ip: 192.168.1.2
Script Accessed: /home/httpd/html/wesmo.com/forums2/adm/consist.php
Query Failed: UPDATE fud_users SET u_last_post_id=157 WHERE id=0
Reason: Unknown column 'u_last_post_id' in 'field list'
I've manually walked through also updating the fud_users table to include "u_last_post_id", "home_page", and "bio".
But, now, it pops up the "Login Into The Forum" screen and, although I type in the proper account name and password, it brings me back to the same screen... (I've tried other passwords, which generate an error (Incorrect password) and other accounts which also generate an error (Only administrators can login).
Anyone had luck going from 1.2.8 to 2.0.1?
-Rich
|
|
|
|
|
|
| Re: 1.2.8 -> 2.0.1 woes [message #3153 is a reply to message #3151] |
Wed, 12 June 2002 16:59  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Does your forum account have permissions to run ALTER queries on it's database?
FUDforum Core Developer
|
|
|
|
|
|
|
|
| Re: 1.2.8 -> 2.0.1 woes [message #3164 is a reply to message #3162] |
Wed, 12 June 2002 18:31 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
I already added checks to the 1.2.8 to 2.0 upgrade script that will stop its execution immidiately if it sees that you do not have CREATE/ALTER TABLE priveledges in the CVS.
So, anyone upgrading from 1.2.8 to 2.0.2 won't have any problems.
FUDforum Core Developer
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]