Flash Sale for Premium Subscriptions

50% off annual premium licence subscription.

Get 50%off now

Rota Database Error

About Support Rota Rota Database Error

  • This topic is empty.
Viewing 8 posts - 1 through 8 (of 8 total)
  • Author
    Posts
  • #2543
    Avatar for fireandsaltfireandsalt
    Member

    Hi,

    I’m getting the following error:

    Code:
    WordPress database error: [Table ‘gustason_wrd5.wp_church_admin_rota’ doesn’t exist]
    SELECT wp_church_admin_rota.rota_option_id, MAX( LENGTH( wp_church_admin_rota.who ) )AS whocount,LENGTH(wp_church_admin_rota_settings.rota_task) AS title,wp_church_admin_rota.rota_option_id FROM wp_church_admin_rota,wp_church_admin_rota_settings WHERE wp_church_admin_rota.rota_date>=’2012-02-20′ AND wp_church_admin_rota.rota_date<'2012-08-20' AND wp_church_admin_rota.rota_option_id=wp_church_admin_rota_settings.rota_id GROUP BY wp_church_admin_rota.rota_option_id

    I believe this was caused by a failure of the plugin to get the table created in the database, but I want to confirm this.

    #3301
    Avatar for fireandsaltfireandsalt
    Member

    Could you supply a sql query script for adding tables and fields for this plug-in. Then I’ll just run it after deleting all the tables wp_church_admin for a clean database install using phpMyAdmin.

    Thanks a lot!

    #3302
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    Can do, but I think you are using an old version of the plugin – latest is 0.33.4.2

    That query isn’t in recent versions. The rota table is now wp_church_admin_rotas

    #3303
    Avatar for fireandsaltfireandsalt
    Member

    I’m using 0.33.4.2 and installed it by using the search feature of the WordPress Admin > Plug-ins > Add New feature. If you think it will help, I’ll delete all the tables, uninstall the plug-in and then ftp and delete any remaining files. Then I’ll try to re-install.

    #3304
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    How very strange!
    I’ve just downloaded 0.33.4.2 from WordPress and files that shouldn’t be in the plugin anymore still are.

    I think I didn’t remove them properly from the “svn” which is used to create the plugin zip files on WordPress.org.

    I’ve redone it and uploaded 0.33.4.3
    If you want delete the tables and and entries in wp_options table with the option name church_admin% – you shouldn’t have to though!!!

    #3305
    Avatar for fireandsaltfireandsalt
    Member

    OK, I’ll try the new package. Thanks for the excellent support!

    #3306
    Avatar for fireandsaltfireandsalt
    Member

    Excellent, the errors are no longer there. One minor problem though, when you go to settings, and select pdf page size to letter, and then click save, it reverts back to what was previously selected. This does not happen when selecting legal or A4.

    Other than that, this plug-in should work nicely for the church admin site I am setting up for my congregation. Thanks for your effort in developing this plug-in!

    #3307
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    Next update will have that fix. Enjoy the plugin.

    Please put your url in the showcase of sites section of the forum!

Viewing 8 posts - 1 through 8 (of 8 total)
  • You must be logged in to reply to this topic.