The error speaks of two different tables "westensc_zenp2.zenp_search_cache" and "zenp2.zenp_search_cache". So what is your database prefix actually? Setup should create all needed tables.
If you did upgrade through one of the third party install helpers, please report this problem to them. It can only happen if the Zenphoto setup script was not used to properly migrate your installation.