Rota Database Error

About › Support › Rota › Rota Database Error

  • This topic is empty.
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • 20th February 2012 at 10:20 pm #2542
    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.

    20th February 2012 at 11:09 pm #3300
    Avatar for Andy MoyleAndy Moyle
    Keymaster

    Yes it does look like the table wasn’t created. But that query no longer appears in the plugin at all – it used to be used in pdf rota creation but the rota section was changed radically under the hood a few months ago!

    What version are you using and when did the error occur please? The current Version is 0.33.4.2. recent versions migrated data from wp_church_admin_rota to wp_church_admin_rotas for more efficient use.

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