WP Photo Album Plus: Unexpected error: Missing database table

Resolved davidallen23
(@davidallen23)

12 years, 5 months ago

Hi
Suddenly I’m getting the following message

WP Photo Album Plus Settings
Database revision: 425. WP Charset: UTF-8. Current PHP version: 5.2.17. WPPA+ API Version: 4-2-5-000.
[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.

I have de-activated and re-activated the plugin and I have installed the latest version but the message is still showing.
The website, however, seems to be working fine. Should I worry about this?

http://wordpress.org/extend/plugins/wp-photo-album-plus/

Viewing 15 replies - 1 through 15 (of 22 total)

1 2 →

Plugin Author Jacob N. Breetvelt
(@opajaap)

12 years, 5 months ago

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.

Thread Starter davidallen23
(@davidallen23)

12 years, 5 months ago

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

Plugin Author Jacob N. Breetvelt
(@opajaap)

12 years, 5 months ago

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
Plugin Author Jacob N. Breetvelt
(@opajaap)

12 years, 5 months ago
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;
}
```
Thread Starter davidallen23
(@davidallen23)

12 years, 5 months ago

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

Plugin Author Jacob N. Breetvelt
(@opajaap)

12 years, 5 months ago

That is correct.

Thread Starter davidallen23
(@davidallen23)

12 years, 5 months ago

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: http://www.gamlingayphotos.co.uk seems to work OK apart from in the dreaded IE9

Thread Starter davidallen23
(@davidallen23)

12 years, 5 months ago

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.

Plugin Author Jacob N. Breetvelt
(@opajaap)

12 years, 5 months ago

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

Thread Starter davidallen23
(@davidallen23)

12 years, 5 months ago

Thanks.

Plugin Author Jacob N. Breetvelt
(@opajaap)

12 years, 5 months ago

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

Thread Starter davidallen23
(@davidallen23)

12 years, 5 months ago

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!

Plugin Author Jacob N. Breetvelt
(@opajaap)

12 years, 5 months ago

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!

Thread Starter davidallen23
(@davidallen23)

12 years, 4 months ago

Oh well, I updated WP to 3.3 and Lightbox still doesn’t work in IE9
Plugin Author Jacob N. Breetvelt
(@opajaap)

12 years, 4 months ago
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.

Viewing 15 replies - 1 through 15 (of 22 total)

1 2 →

The topic ‘WP Photo Album Plus: Unexpected error: Missing database table’ is closed to new replies.