+ Post New Thread
Results 1 to 5 of 5
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 ...
  1. #1

    Join Date
    Aug 2011
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    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"

    Any ideas?

  2. #2

    Join Date
    Sep 2008
    Location
    England
    Posts
    261
    Thank Post
    6
    Thanked 67 Times in 59 Posts
    Rep Power
    51
    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.

  3. #3

    Join Date
    Aug 2011
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    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

  4. #4

    Join Date
    Sep 2008
    Location
    England
    Posts
    261
    Thank Post
    6
    Thanked 67 Times in 59 Posts
    Rep Power
    51
    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 [1] 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.

  5. #5

    Join Date
    Aug 2011
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    thanks Chris... been pulling my hair on this for a while. All is good now

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 30
    Last Post: 21st June 2013, 12:31 AM
  2. Replies: 0
    Last Post: 29th March 2010, 09:23 AM
  3. MRBS room booking assigning admins
    By lill in forum How do you do....it?
    Replies: 0
    Last Post: 9th November 2009, 04:19 PM
  4. MRBS, PHP, IIS 6.0, and one 500 error
    By mossj in forum Web Development
    Replies: 7
    Last Post: 14th July 2009, 04:23 PM
  5. Meeting Room Booking System - MRBS
    By pmassingham in forum How do you do....it?
    Replies: 4
    Last Post: 12th February 2009, 11:03 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •