1 kskhater Nov 12, 2006 04:14
3 kskhater Nov 12, 2006 16:34
When I upgrade I get the following error which I can't understand:
Upgrading data in existing b2evolution database
Checking DB schema version... 8066 : OK.
Dropping old Hitlog table... OK.
Creating plugins table... OK.
Upgrading blogs table... OK.
Updating relative URLs... OK.
Copying urlnames to stub names... OK.
Upgrading posts table... OK.
Updating post data... OK.
Upgrading users table... OK.
Setting new defaults... OK.
Altering table for Blog-User permissions...
An unexpected error has occured!
If this error persits, please report it to the administrator.
Go back to home page
Additional information about this error:
MySQL error!
Duplicate column name 'bloguser_perm_media_upload'(Errno=1060)
Your query:
ALTER TABLE evo_blogusers
MODIFY COLUMN bloguser_blog_ID int(11) unsigned NOT NULL default 0,
MODIFY COLUMN bloguser_user_ID int(11) unsigned NOT NULL default 0,
ADD COLUMN bloguser_perm_media_upload tinyint NOT NULL default 0,
ADD COLUMN bloguser_perm_media_browse tinyint NOT NULL default 0,
ADD COLUMN bloguser_perm_media_change tinyint NOT NULL default 0
4 blueyed Nov 12, 2006 17:18
From which version are you trying to upgrade? 0.9.1, right?
I cannot reproduce the problem here.. have you tried upgrading before? Have you manually changed your DB?
It's strange that the bloguser_perm_media_upload already exists.
5 kskhater Nov 13, 2006 02:59
I upgraded before from 0.9.1 to 0.9.2 and now I'm trying to upgrade to 1.8.5
I'm following the instuctions in the document "Upgrading from 0.9.x to 1.8.x AND "Upgrading from an older version"
6 blueyed Nov 18, 2006 02:54
kskhater, using the dump you've sent me I cannot reproduce the problem (after having removed the "evo_plugins" table from the dump, but which triggers another error earlier and you've probably have left it in there accidently - I've commented out lines 361-375 with a "#" for it).
Please try it again.. it should work.
7 kskhater Nov 18, 2006 08:32
You said: "I've commented out lines 361-375 with a "#" for it).
where're these lines located. Are they in the SQL-DB?
Thanks
8 blueyed Nov 18, 2006 17:36
In the dump you've sent me, yes. But it would cause another error, if you would use the dump as-is: "Table evo_plugins already exists"
The message is because the new files require you to upgrade your database before they can work.
Directly underneath that message you should have 2 links to the installer.
¥