1. Andrea
  2. Weekend Meeting
  3. Friday, 07 June 2019
  4.  Subscribe via email

I've got a problem with speakers and talks. 

Unfortunately I deleted a speaker whose was associated a talk n.3

Now in the printing worksheet I find the talk

How can I delete these records empty in database?

 tried to remove and rewrite a talk but it's wrong.

Comment
There are no comments made yet.
Accepted Answer
Marc
Members
Accepted Answer Pending Moderation
0
Votes
Undo

I am not sure about pictures 2 and 3, but:

Do you say you deleted the speaker before you disconnected him from the talk? And the speaker is also not disconnected from his congregation? 

If this is true, and you deleted the speaker from the persons table, the connections are still there behind the scenes.

I suggest you close Theocbase, go to the theocbase.sqlite file, open it with a sqlite file editor (see my signature below), and find the table called persons. Find the row with the speaker. Somewhere in the row there is a field called "active". The value is 0. Change it to 1, save and close the database file. Open TB. You should find him now.

To remove a speaker: first all his talks must be disconnected from him, then he must be disconnected from his congregation (all in Settings) and then he may be removed from the Persons table. 

https://www.theocbase.net/support-forum/1097-donations.html

For accessing the database my personal preference is http://sqlitebrowser.org/

For editing templates I like to use http://brackets.io/ 

 

Comment
There are no comments made yet.
  1. more than a month ago
  2. Weekend Meeting
  3. # Permalink
Andrea
Members
Accepted Answer Pending Moderation
0
Votes
Undo

I quite solved using the data base

About picture 2: if you in setting options, section talks, the third view shows all speakers and talks you entered but it also shows what is not active....it makes confusion

Remain to solve: in app Theocbase doesn't sync with pc application with speakers outgoing. It could be usefule to modify speakers outgoiing through the app because it makes all easier 

 

Comment
  1. Andrea
  2. 4 weeks ago
  3. #1701
Solved everything deleting the cloud database and sync it again after it.
There are no comments made yet.
  • Page :
  • 1


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