[application error on update - database definition..]

Did you change the default database layout in any way? We've just successfully upgraded from 3.0.2 to 3.2.3 with no installation issues. Your error message sounds like Revive is trying to install from scratch instead of updating (because it cannot successfully detect you already have Revive installed). The *_account_preference_assoc table was added in December 2007 according to version control so an update script should not try to install it as it likely predates 3.0.2.

no, we didn't change the layout. but we continously upgraded from an really early phpadsnew-Version (2.0.11 i think) to openx (latest official) and to revive 3.0.5 in 2014. i now try to upgrade from that version to 3.2.3. Underlying PHP-Version is latest 5.3.

[application error on update - database definition..]

I must confirm this error. I see no possibility to upgrade Revive to the current 3.2.3 Version. Any ideas are welcome.