Failed upgrade 2.0.? to 2.1.18p1 "Undefined index: DisplayAs"

review

I followed the upgrade instructions but the yourforum.com/index.php?p=/utility/update page says:

Failure
The update was not successful.
Debug Trace
Info Need to re-index theme cache
Info Need to re-index plugin cache

When I try to use the forum, it sort of seems to work but the top of the page says

"Notice: Undefined index: DisplayAs in /home1/myfolder/public_html/forum/applications/vanilla/models/class.categorymodel.php on line 156"

What does that mean?

I've turned on debugging, switched to default theme, deleted the helper_functions.php file, deleted the .ini files from the cache folder and disabled the only plugin besides HTMLawed.

Linc

Have you run /utility/update a second time?

Go to /utility/structure to find what queries have not executed. You can manually paste them into a SQL manager to run them one at a time if necessary. Then run /utility/update again to confirm they all applied.

review

It appears to be

alter table GDN_Tag
add unique index UX_Tag (Name, CategoryID)

But running that in phpMyAdmin fails saying

1061 - Duplicate key name 'UX_Tag'

Not sure what a unique index is in SQL but every field in that table seems to be both of them. There's no UX_Tag field.

review

OK, fixed it like this:

Dropped the UX_Tag key from the GDN_Tag table

Ran that SQL query to add the key back again

Ran /utility/update and it said success

Sadly now all the files people had attached to their posts seem to have disappeared and FileUplad plugin doesn't work with 2.1 It would be great if the old 2.0 still got the security updates then everything would keep running smoothly.

Bleistivt

Sadly now all the files people had attached to their posts seem to have disappeared and FileUplad plugin doesn't work with 2.1 It would be great if the old 2.0 still got the security updates then everything would keep running smoothly.

http://vanillaforums.org/discussion/28532/a-mod-to-file-upload-version-1-8-4-to-make-it-work-with-vanilla-2-1-5

review

O for awesome! That modification to version 1.8.4 of the FileUpload plugin works perfectly!