Network and Classroom Management Thread, MRBS booking delete error in Technical; I am logged in as an admin so I should be able to delete any booking including my own. When ...
25th August 2011, 02:44 PM #1
- Rep Power
MRBS booking delete error
I am logged in as an admin so I should be able to delete any booking including my own. When I select a booking I automatically get the following error ..
"Custom fields problem, 'ical_recur_id' exists in entry table but not in repeat table"
IDG Tech News
25th August 2011, 05:52 PM #2
have you added this column to the database? If so, you need to add it to the repeat table using phpmyadmin, or the command line mysql client. The type needs to match the column in the entry table. If you've already done that, check its spelled the same in both tables.
25th August 2011, 11:39 PM #3
- Rep Power
Thanks Chris_Cook. I deleted it using phpmyadmin in the entry table and all my recurring booking disappeared which is great. However, if I try to make a new recurring booking I get the same error so it must get created when making a recurring booking. So, I guess I need to know how to make a new column for "ical_recur_id" in the repeat table. When I go in using phpmyadmin I do not get an option to add that column. Can u step me through? Thanks in advance
26th August 2011, 05:43 PM #4
Ok, Phpmyadmin uses the terms columns and fields, and they basically mean the same thing. You need to find the type of the field called "ical_recur_id" in the entry table, and create one with exactly the same name and type in the repeat table.
1. Load up PHPMyAdmin.
2. Select your MRBS database.
3. In the list on the left side, click on "mrbs_entry". Then click "Structure" near the top of the page.
4. Find the column "ical_recur_id" and make a note of the type (Probably tinyint or int).
5. Click on "mrbs_repeat" on the left hand side.
6. check there isn't a mis-typed column field similar to "ical_recur_id".
7. just after the list of columns/fields there should be a line that is like:
Add  Column(s) [Go]
8. Click [Go] button.
9. put in the column name "ical_recur_id", and set the type to whatever you found in step 4.
10. click save or ok or similar to apply the changes.
You should then be able make a recurring booking.
30th August 2011, 02:17 AM #5
- Rep Power
thanks Chris... been pulling my hair on this for a while. All is good now
By ChrisH in forum Scripts
Last Post: 21st June 2013, 01:31 AM
By thegandalf in forum Web Development
Last Post: 29th March 2010, 10:23 AM
By lill in forum How do you do....it?
Last Post: 9th November 2009, 05:19 PM
By mossj in forum Web Development
Last Post: 14th July 2009, 05:23 PM
By pmassingham in forum How do you do....it?
Last Post: 12th February 2009, 12:03 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)