- This topic is empty.
-
Posts
-
So after being forced to move to a newer version of php (5.2 > 5.5) by our host Yeah!!
Internal errors all over the shop I banged my head against the nearest solid wall and hit delete and its been a great few hours of rebuilding the site, everybody take note keep regular backups….So with everything imported back into the database i’ve hit an issue with calendar.
– Calendar events are not showing up, although in the database
– New events not being added to database, hitting the following errorWordPress database error: [Unknown column ‘event_image’ in ‘field list’]
INSERT INTO ********_wp_church_admin_calendar_date (title,description,location,recurring,year_planner, event_image,cat_id,event_id,how_many,start_date,start_time,end_time)VALUES(“test”,”test”,”test”,”s”,”1″,”394″,”5″,”86″,””,”2014-10-04″,”18:00:00″,”19:30:00″)Date(s) saved
See below pictures for database data…
Hope you’ve had a nice holiday
Happy days!
The lastest versions of church admin have added some extra columns to the calendar date table – start_date,start_time,end_time and event_image. I’m now storing event data in just the one table, for greater simplicity in handling and some new features coming soon.So it looks like in your updating/importing fun, the church admin update has not gone smoothly!
Please can you check what version you are at with church admin.If you are at 0.5970 then the db should have updated and copied data over from the now redundant church_admin_calendar_event table.
Try these steps…
1) Please try upgrading if not at 0.5970
2) delete church_admin_version from the wp_options table if you have phpmyadmin access – the plugin will update itself and repair the missing columns.
3) If those don’t work please come back, let me know what columns are there in the date table and I will work out the necessary mysql queries to fix! – Edit: email me the plugin database backup and I’ll fix it and email it back (clients at the moyles dot co uk)
- You must be logged in to reply to this topic.