Hey there,

i tried to uprage my c5 from version 5.2.1 to latest version 5.4.1.1, c5 told me to uprade to version 5.3.2 fist, worked well.
After that i tried again to upgrade to version 5.4.1.1 and occurred an mysql error (details later).

So i thought lets try it step by step:

5.2.1 to 5.3.2 -> ok
5.3.2 to 5.3.3 -> ok
5.3.3 to 5.3.3.1 -> same mysql error as before

Error message:

An Unexpected Error occurred while upgrading: mysql error: [1054: Unknown column 'ak_exclude_nav' in 'where clause'] in EXECUTE("select distinct p1.cID, if(p2.cID is null, pt1.ctHandle, pt2.ctHandle) as ctHandle from Pages p1 left join Pages p2 on (p1.cPointerID = p2.cID) left join PageTypes pt1 on (pt1.ctID = p1.ctID) left join PageTypes pt2 on (pt2.ctID = p2.ctID) inner join CollectionVersions cv on (cv.cID = if(p2.cID is null, p1.cID, p2.cID)) left join PagePermissions pp1 on (pp1.cID = p1.cInheritPermissionsFromCID) left join PagePermissions pp2 on (pp2.cID = p2.cInheritPermissionsFromCID) left join CollectionSearchIndexAttributes on (CollectionSearchIndexAttributes.cID = if (p2.cID is null, p1.cID, p2.cID)) where 1=1 and cvIsApproved = 1 and (p1.cIsTemplate = 0 or p2.cIsTemplate = 0) and ((pp1.cgPermissions like 'r%' and (pp1.gID in (2,3,5,6,7,10,1) or pp1.uID = 51)) or (pp2.cgPermissions like 'r%' and (pp2.gID in (2,3,5,6,7,10,1) or pp2.uID = 51)) or (p1.cPointerExternalLink !='' AND p1.cPointerExternalLink IS NOT NULL )) and ak_exclude_nav = 1 and (p1.cID not in (5,6,7,8,173,10,11,12,101,14,100,19,20,22,23,94,95,97,98,99,102,103,104,105,106,107,174,175,176,177,178,179,182,183,184,185,186,188,189) or p2.cID not in (5,6,7,8,173,10,11,12,101,14,100,19,20,22,23,94,95,97,98,99,102,103,104,105,106,107,174,175,176,177,178,179,182,183,184,185,186,188,189)) ")

Server details

- Apache 2.2.9 (Win32)
- PHP 5.2.6
- MySQL 5.0.67

Can anyone help me to fix this problem?

Greetings