WordPress.org

Support

Support » Plugins and Hacks » [Resolved] WP Photo Album Plus: Unexpected error: Missing database table

[Resolved] WP Photo Album Plus: Unexpected error: Missing database table

  • davidallen23
    Participant

    @davidallen23

    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)
  • Plugin Author Jacob N. Breetvelt
    Participant

    @opajaap

    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.

    davidallen23
    Participant

    @davidallen23

    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
    Participant

    @opajaap

    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
    Participant

    @opajaap

    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;
    }
    davidallen23
    Participant

    @davidallen23

    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
    Participant

    @opajaap

    That is correct.

    davidallen23
    Participant

    @davidallen23

    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

    davidallen23
    Participant

    @davidallen23

    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
    Participant

    @opajaap

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

    davidallen23
    Participant

    @davidallen23

    Thanks.

    Plugin Author Jacob N. Breetvelt
    Participant

    @opajaap

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

    davidallen23
    Participant

    @davidallen23

    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
    Participant

    @opajaap

    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!

    davidallen23
    Participant

    @davidallen23

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

    Plugin Author Jacob N. Breetvelt
    Participant

    @opajaap

    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)
  • The topic ‘[Resolved] WP Photo Album Plus: Unexpected error: Missing database table’ is closed to new replies.