I started off looking up my errors on this post. Because my error outputs were spot on with the complaints people got when they moved from 5.3.2 to 5.3.3
http://www.concrete5.org/index.php?cID=21083...

An Unexpected Error occurred while upgrading: mysql error: [1062: Duplicate entry '1-1' for key 1] in EXECUTE("ALTER TABLE FileAttributeValues DROP COLUMN fakID")

and

An unexpected error occurred.
mysql error: [1054: Unknown column 'ak_exclude_nav' in 'where clause'] in EXECUTE ... lots of crap

However, the download area states you can be on 5.3.2 and move directly to 5.4.1.1
I'm not sure what world you have to live in to get this to work but it craps out for me.

This is what I ended up doing below, however what I would like to know is... Is there a better way to fix this issue.

Upgraded from 5.3.2 to 5.4.1.1

Okay this is what I had to do so far to fix this error. First roll back or restore you database back to the original.
Then empty 2 tables.
fileattributevalues
That fixes the first problem. However when I upgrade at this point once I get in to the dashboard and go to attributes on a folder in the Sitemap I get an error.

Fatal error: Call to a member function getAttributeKeyID() on a non-object in attributes

So then I cleared;
collectionattributevalues
Then that fixed that problem.

So to get it to work with out much error. Clear those two and then update. You will still get an error, but click run update again and it will go through.

HOWEVER this will delete all page attributes like exclude from nav, meta data ect.
After this was done I had to manually add back my Attributes options under Pages and Themes, then click Attributes.
If you can't find the originals look in the table collectionattributekeys
they're still there. exclude from nav and exclude from search index are check box's when you are making new ones.

By the way this is not a fix all. In the end this is just a crazy problem. I have a feeling the upgrade didn't do everything it was tasked to.

TheHinac