1. Greger
  2. Sherlock Holmes
  3. Printing
  4. Sunday, 26 January 2020
  5.  Subscribe via email

It's a weird bug in my program. it is not possible to set the date range for printing longer than March 8, as soon as I try to extend the printing period to March 9, the program crashes. On the other hand, I can print if I set the date period from March 16 onwards without any problems. There seems to be a problem with the week of March 9-15. All other periods can be set for printing as usual. What could be the problem?

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

I know you had problems before: whenever changing the date range for a WE template. 

I wonder, is it still template related? And something else I wonder: how did the other date ranges get solved? If you know, sometimes problems just come and go and you don't know...

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
  1. Greger
  2. 4 months ago
  3. #1886
no it is the same problem but i did not discover until now that it was the special week that blocked the printout, nor was it affected by the change of administrator rights it was the same.
  1. Greger
  2. 4 months ago
  3. #1887
And it had nothing to do with different templates, the program reacted the same no matter what template I used
  1. Greger
  2. 4 months ago
  3. #1888
the reason I didn't find it before was because I was constantly trying to print a schedule for three months at a time, so I put the dates past the month of March and it made it crash. Then I tried to extend the print period gradually one veca at a time and discovered that it always crashed when I got to March 9th. Just as I did when I went back in time and started from April 30 and on week after week it always crashed when I came to March 16.
There are no comments made yet.
  1. more than a month ago
  2. Printing
  3. # 1
Marc
Members
Accepted Answer Pending Moderation
0
Votes
Undo

Pff, sometimes it takes a long time and a lot of work to pinpoint the problem to one very specific issue. This is new and probably helpful info.The bad thing is, I cannot reproduce this :-(

The fact that is it working for the other dates shows that the software code for printing is working. Assuming you and I installed the same software version (did we? I am on Windows) I must assume the software is equal. So I am just wondering if the (imported) dates in the database are correct. Could you open the database (if you do not have a database editor see suggestion in my signature below) and find the tables 'lmm_assignment', 'lmm_meeting', 'lmm_schedule' and 'lmm_scheduleassist', and check the existence of 2020-03-09 in the 'date' column? You can type 2020-03 into the filter field above the date column to more easily spot any irregularities compared to other weeks.

That is assuming the issue is in the midweek meeting. You could do something similar in the tables 'publicmeeting' (which includes both talks and wt studies) and 'wt_article_dates'. Now that latter table is predefined by the software developers, so I do not expect an issue there, but one could be surprised... 

If you prefer, we could do a Teamviewer session, and I could help you check this.

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
  1. Greger
  2. 4 months ago
  3. #1889
Well, I think you are right there, I also think there is something wrong with the database because when I created a new login account on the computer and opened a clean copy with new database that was not linked to the dropbox folder I could put date ranges all over the period without problems, then when I copied the database from my usual Theocbase it started crashing again. I'll test it! Very good thanks!
There are no comments made yet.
  1. more than a month ago
  2. Printing
  3. # 2
Marc
Members
Accepted Answer Pending Moderation
0
Votes
Undo

Oh, OK, that may point to an issue with the Dropbox file. That can be addressed after you know more about the database.

OR: you could rename the current Dropbox sync file and create a new syncfile like you connect to DB for the first time. If that works, you would be done. (make sure to make a copy of the theocbase.sqlite file somewhere first, so as to be sure it downloads all zeros from Dropbox and all is lost. I don't think it happened before, but you cannot be too careful)

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
  1. Greger
  2. 4 months ago
  3. #1890
Yes I was wondering if it was Dropbox too but since the clean copy in the second login account started crashing in the same way although I was not logged in to Dropbox but had just copied over the old database I thought it might have to be the database? but I test both alternatives so it turns out I guess. Thank you for the advice!
  1. Marc
  2. 4 months ago
  3. #1891
ah, right. I hadn't understood that bit correctly I think..
  1. Greger
  2. 4 months ago
  3. #1892
I managed to solve it in the end. the problem was an exception to the program just that week. We have the Circuit overseer that week and I had not marked the congregation first in assigning speech on the weekend. It disrupted the entire print function. I remarked on and put the congregation first and then the speaker, (circuit overseer) then it worked. Strange!
There are no comments made yet.
  1. more than a month ago
  2. Printing
  3. # 3
Marc
Members
Accepted Answer Pending Moderation
0
Votes
Undo

I am not sure if I complete understand that, but, yes, it does sound strange... At least it is solved...

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
  1. Greger
  2. 4 months ago
  3. #1893
I maybe not use the right method for the circuit overseer? normally a brother must be included in the register of speakers in order to be able to assign him public speech during the weekends, so I simply assigned the circuit overseer a congregation and entered his name under speakers there and booked different rights, then in the weekly schedule, I pull down the drop list for the various weekends and the circuit overseer for the weekend he usually has the public speaking. Don't know but there may be another method of fixing it ,,, maybe he should automatically end up in public speech the week he visits the congregation, how do I set up that function if so?
There are no comments made yet.
  1. more than a month ago
  2. Printing
  3. # 4
Marc
Members
Accepted Answer Pending Moderation
0
Votes
Undo

I do not use TB for public talks, but I thought the CO was chosen automatically.  Maybe that is only true for service talk and final talk !?

I'd have to check that. Later this week...

All the same, it is quite unexpected that a print failure would occur because of this. (I can imagine a print to come out funny, because the html is different foe a CO week, but TB is crashing even before it gets to that point). The method you use may not be what the writers of TB had in mind, but it isn't very farfetched either. Shouldn't be a big deal.

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. Printing
  3. # 5
  • Page :
  • 1


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