1. Adam Meyer
  2. Sherlock Holmes
  3. Weekend Meeting
  4. Monday, 04 February 2019
  5.  Subscribe via email

I noticed that the weekend beginning July 1 was skipped when importing the May 2019 study edition, with its article (Love and Justice in the Christian Congregation) assigned to the weekend after. As a result, July 1 was empty and the weekends after were out of sync by a week.

If you encounter the same, correcting this is pretty easy:

1) Backup the Database, then close Theocbase

2) Open the Database, navigate to the 'publicmeeting' table and sort by Date descending (latest date is row 1). You will likely see something like this (notice the missing week between 2019-06-24 and 2019-07-08)

Screen Shot 2019 02 04 at 9.42.41 pm

3) Change the dates working backwards, ie.

2019-08-05 becomes 2019-07-29

2019-07-29 becomes 2019-07-22

2019-07-22 becomes 2019-07-15

2019-07-15 becomes 2019-07-08

2019-07-08 becomes 2019-07-01

4) Ensure the changes are written to the database, re-open Theocbase and everything should now line up properly.

Sidenote: the 'publicmeetinghistory' table should update automatically after the changes to 'publicmeeting', but it is good to double-check this. After the changes, 'publicmeetinghistory' should look like this (mtg_date will be a day later if your weekend meeting is a Sunday):

Screen Shot 2019 02 04 at 9.44.51 pm

  1. Steven
  2. 1 year ago
  3. #1539
Thanks Adam, really appreciated that someone took the time to let us know how to fix.
There are no comments made yet.

There are no replies made for this post yet.
Be one of the first to reply to this post!