Rota Database Error

About Support Rota Rota Database Error

  • This topic is empty.
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
  • #2542
    Avatar for fireandsaltfireandsalt


    I’m getting the following error:

    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.

    Avatar for Andy MoyleAndy Moyle

    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 recent versions migrated data from wp_church_admin_rota to wp_church_admin_rotas for more efficient use.

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