WordPress.org

Ready to get started?Download WordPress

Forums

WP Photo Album Plus
[resolved] WP Photo Album Plus: Unexpected error: Missing database table (23 posts)

  1. davidallen23
    Member
    Posted 2 years 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/

  2. Jacob N. Breetvelt
    Member
    Plugin Author

    Posted 2 years 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.

  3. davidallen23
    Member
    Posted 2 years 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

  4. Jacob N. Breetvelt
    Member
    Plugin Author

    Posted 2 years 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

  5. Jacob N. Breetvelt
    Member
    Plugin Author

    Posted 2 years 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;
    }
  6. davidallen23
    Member
    Posted 2 years 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

  7. Jacob N. Breetvelt
    Member
    Plugin Author

    Posted 2 years ago #

    That is correct.

  8. davidallen23
    Member
    Posted 2 years 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

  9. davidallen23
    Member
    Posted 2 years 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.

  10. Jacob N. Breetvelt
    Member
    Plugin Author

    Posted 2 years ago #

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

  11. davidallen23
    Member
    Posted 2 years ago #

    Thanks.

  12. Jacob N. Breetvelt
    Member
    Plugin Author

    Posted 2 years ago #

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

  13. davidallen23
    Member
    Posted 2 years 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!

  14. Jacob N. Breetvelt
    Member
    Plugin Author

    Posted 2 years 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!

  15. davidallen23
    Member
    Posted 2 years ago #

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

  16. Jacob N. Breetvelt
    Member
    Plugin Author

    Posted 2 years 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.

  17. davidallen23
    Member
    Posted 2 years ago #

    If only I could do the same.
    On my server I navigate to:
    wp-content/plugins/wp-photo-album-plus/lightbox/prototype.js
    I right-click on the file and select copy.
    I'm then presented with a dialog box asking where I want to copy the file to so I enter:
    public_html/wp-includes/js/
    and click OK.
    The screen refreshes and I navigate to the folder:
    public_html/wp-includes/js/
    but the prototype.js file is not there.
    I'll contact my webhost support and ask them how to do this.
    Many thanks for your support and patience.

  18. davidallen23
    Member
    Posted 2 years ago #

    OK, I've now managed to copy the prototype.js to /wp-includes/js/.
    I have cleared the IE9 cache, reloaded and yet Lightbox has the same problem.
    I apologize for bugging you with this problem as it's probably not an area that you support. After all, your plugin works extremely well in all other browsers.
    Is there somewhere else I should be going for support on this issue?

  19. Jacob N. Breetvelt
    Member
    Plugin Author

    Posted 2 years ago #

    If only i could reproduce this...

    I know of yet another way to make it someone elses problem.

    1. Uncheck WPPA+ Lightbox (Table IX ietm 9)
    2. Find a wp lightbox plugin that works under IE9, and, if not, ask them for a fix.

    This should work.

    I know there are wp lightbox plugins. Some use a different keyword for the rel="lightbox" html attrib. If you need a setting in wppa+ to use a different keyword, tell me and i will implement it.

  20. davidallen23
    Member
    Posted 2 years ago #

    ...and if only IE9 wasn't such a pig...

  21. Jacob N. Breetvelt
    Member
    Plugin Author

    Posted 2 years ago #

    I edited the previous post...

  22. davidallen23
    Member
    Posted 2 years ago #

    Thanks. I'll try that.
    BTW, I just donated.

  23. Jacob N. Breetvelt
    Member
    Plugin Author

    Posted 2 years ago #

    Oh, it was you, thanx

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic