- This topic is empty.
-
AuthorPosts
-
20th February 2012 at 10:20 pm #2543fireandsaltMember
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_idI 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:11 pm #3301fireandsaltMemberCould 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!
20th February 2012 at 11:14 pm #3302Andy MoyleKeymasterCan 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
20th February 2012 at 11:37 pm #3303fireandsaltMemberI’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.
21st February 2012 at 10:39 am #3304Andy MoyleKeymasterHow 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!!!21st February 2012 at 10:59 pm #3305fireandsaltMemberOK, I’ll try the new package. Thanks for the excellent support!
21st February 2012 at 11:06 pm #3306fireandsaltMemberExcellent, 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!
22nd February 2012 at 6:18 pm #3307Andy MoyleKeymasterNext update will have that fix. Enjoy the plugin.
Please put your url in the showcase of sites section of the forum!
-
AuthorPosts
- You must be logged in to reply to this topic.