WP Photo Album Plus: Unexpected error: Missing database table

I recently built in an extra check as a diagnostic for people who have certain problems. It seems that there are mysql implementations that act different from what i expect.

If the site works, you should not worry, in that case the error message is faulty.

I made a tiny change in an attemp to make this error message more reliable.

If you re-install the plugin (read this topic if you need help) to get hotfix 002, the messages may be gone. If so, please tell me.

If I uninstall and reinstall the plugin will I lose everything and have to start over?
Well, the site is working OK presently so maybe I’ll leave it as it is.
Thanks

Uninstalling and re-installing will NEVER damage anything, its SAFE to do as many times you like.

Can you find your mysql version number? im interested to know

It could be the fact that the query to retrieve the list of existing tables returns them in uppercase in some mysql implementations while i check them against the lowercase names as how they are created.
If this is the case, please change the very last function of wppa-common-functions.php into:

function wppa_table_exists($xtable) {
global $wpdb;

	$tables = $wpdb->get_results($wpdb->prepare("SHOW TABLES FROM ".DB_NAME), 'ARRAY_A');

	foreach ($tables as $table) {
		if ( is_array($table) )	foreach ( $table as $item ) {
			if ( strcasecmp($item, $xtable) == 0 ) return true;
		}
	}
	return false;
}

Are you saying that uninstalling and re-installing WP Photo Album Plus plugin will not delete my albums, slideshows and settings?
Mysql version 5

That is correct.

OK, I’ve uninstalled and reinstalled WP Photo Album Plus and now I get the following errors:

Could not create database table wp_wppa_albums
Could not create database table wp_wppa_photos
Could not create database table wp_wppa_rating
Could not create database table wp_wppa_comments
WPPA+ successfully updated in single site mode to db version 425.
Plugin activated.

The site: https://www.gamlingayphotos.co.uk seems to work OK apart from in the dreaded IE9

And in the Settings’ panel:
WP Photo Album Plus Settings
Database revision: 425. WP Charset: UTF-8. Current PHP version: 5.2.17. WPPA+ API Version: 4-2-5-002.
[WPPA+ dbg msg: Unexpected error: Missing database table: wp_wppa_albums]
[WPPA+ dbg msg: Unexpected error: Missing database table: wp_wppa_photos]
[WPPA+ dbg msg: Unexpected error: Missing database table: wp_wppa_rating]
[WPPA+ dbg msg: Unexpected error: Missing database table: wp_wppa_comments]

Please de-activate and re-activate the plugin. If this problem persists, ask your administrator.

The two messages above have the same source.
Ignore it, the errormessages are faulty.
This will be fixed in the next version.

Thanks.

This should be fixed in 4.2.6 or later. Is it in your site also fixed?

Yes. All error messages have now gone. Thank you.
The only problem I now have is that Lightbox doesn’t work in IE9 but IE has always been pretty rubbish. I guess that the problem has nothing to do with WP Photo Album Plus.
BTW, I tried your method of opening a bottle of wine with a shoe. It works!

Lightbox in ie9 is a known problem.
The scriptaculous and prototype that come with wp core do not work in ie9.

You may copy the files that come with wppa (for completelyness only) to the places where they belong in wp core.

You may also wait until wp 3.3 that will be released soon, i expect they will have fixed it there.

See This thread for details on which files you need to copy if you want to fix it now.

Cheers!

Oh well, I updated WP to 3.3 and Lightbox still doesn’t work in IE9

I did the same and had the same problem.

I copied

.../wp-content/plugins/wp-photo-album-plus/lightbox/prototype.js

to

.../wp-includes/js/prototype.js

that fixed it.