+ Post New Thread
Results 1 to 3 of 3
*nix Thread, Desperate MYSQL problem MRBS one week behind. in Technical; Dear ALL, Ive set up MRBS and the weekly schedule rolls over 2 weeks -week 1 and week 2. We ...
  1. #1

    Join Date
    Sep 2008
    Location
    Bristol
    Posts
    11
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Desperate MYSQL problem MRBS one week behind.

    Dear ALL,

    Ive set up MRBS and the weekly schedule rolls over 2 weeks -week 1 and week 2.

    We had a week off for half term.

    Now everything is a week 'behind'. I need to edit MRBS (MYSQL) to push every entry one week forward.

    I have no idea where to start. I;ve installed PHPMYADMIN and nothing is obvious.

    Does anyone have any idea how to approach this?

    Cheers,

    Ray

  2. #2

    Join Date
    Mar 2010
    Location
    Dover
    Posts
    11
    Thank Post
    0
    Thanked 4 Times in 4 Posts
    Rep Power
    9
    Before doing anything, backup your database. e.g mysqldump.

    The table you want is mrbs_entry. The fields are start time and end time. They are stored in epoch format so you could use a converter

    Epoch Converter - Unix Timestamp Converter

    One week is 604800 so you could write a query to add this value to your current value.

    Cheers,

    Nathan.

  3. #3

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,266
    Thank Post
    613
    Thanked 1,567 Times in 1,407 Posts
    Rep Power
    412
    This was always the issue we had I only ever put in a half terms worth.

    Crbs supports 2 week time tables and we currently use that.

    Ben

SHARE:
+ Post New Thread

Similar Threads

  1. MRBS & two week timetables?
    By CHiLL in forum Web Development
    Replies: 2
    Last Post: 13th September 2011, 08:08 AM
  2. [Pics] The Deadpool Approach To Problem Solving: This Week: Television
    By DaveP in forum Jokes/Interweb Things
    Replies: 6
    Last Post: 28th February 2011, 06:39 AM
  3. Woo-hoo! One week to go!
    By tech_guy in forum General Chat
    Replies: 14
    Last Post: 30th March 2009, 11:00 AM
  4. Replies: 1
    Last Post: 22nd November 2007, 10:00 PM

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
  •