Re: [MRBS-general] Entries not showing in view

[Chris S. <cr...@ha...>]

I was about to reply saying yes you misunderstood but...

I just ran this update:

update `mrbs_entry` set `start_time` = `start_time` - 3600, `end_time` =
`end_time` - 3600 where id = "10559"

For a sample booking ()id 10559 and it worked!

I'll run it for all my bookings after yesterday morning's time change. 

-----Original Message-----
From: Campbell Morrison [mailto:ma...@ca...] 
Sent: 30 March 2009 14:48
To: General purpose list (support/developers/users)
Subject: Re: [MRBS-general] Entries not showing in view

Maybe I misunderstood you.   I thought you ran some SQL which fixed the 
problem?

Campbell


----- Original Message ----- 
From: "Chris Snow" <cr...@ha...>
To: "General purpose list (support/developers/users)" 
<mrb...@li...>
Sent: Monday, March 30, 2009 2:36 PM
Subject: Re: [MRBS-general] Entries not showing in view


> OK, so if changing the start and end times for bookings by and hour
does
> not fix it, how can I get our bookings to appear again in the calendar
> view without having to resort to rebooking them?
>
> Happy to do any suggested testing!
>
> Chris.
>
> -----Original Message-----
> From: Campbell Morrison [mailto:ma...@ca...]
> Sent: 30 March 2009 14:05
> To: General purpose list (support/developers/users)
> Subject: Re: [MRBS-general] Entries not showing in view
>
> Ah OK.  I think there were still some DST issues in 1.4, so yes, there
> could
> be problems with bookings made pre-DST change using 1.4.
>
> Campbell
>
>
>
> ----- Original Message ----- 
> From: "Chris Snow" <cr...@ha...>
> To: "General purpose list (support/developers/users)"
> <mrb...@li...>
> Sent: Monday, March 30, 2009 1:59 PM
> Subject: Re: [MRBS-general] Entries not showing in view
>
>
>> That's correct.
>>
>> More explicitly, my upgrade to 1.4.1 was this morning so bookings
were
>> made prior to daylight saving time change in 1.4
>>
>> I applied the sql update and refreshed (clearing the cache too) the
> web
>> page. I did not see the "missing" bookings appear as I'd hoped to.
>>
>> I thought maybe I should have subtracted the hour instead of adding
it
>> (grasping @ straws) so I took two hrs off (having added on a moment
> ago)
>> that did not help so I restored my mrbs database from a backup I took
>> before hacking away at it with updates!
>>
>> Chris.
>>
>>
>> -----Original Message-----
>> From: Campbell Morrison [mailto:ma...@ca...]
>> Sent: 30 March 2009 13:48
>> To: General purpose list (support/developers/users)
>> Subject: Re: [MRBS-general] Entries not showing in view
>>
>>>
>>> Chris.
>>>
>>> P.S. It did not fix the problem in 1.4.1 I'm sorry to report.
>>
>> You mean bookings made using 1.4.1 before the change aren't showing
> up?
>>
>> Campbell
>>
>>
>>
>
------------------------------------------------------------------------
>> ------
>> _______________________________________________
>> mrbs-general mailing list
>> mrb...@li...
>> https://lists.sourceforge.net/lists/listinfo/mrbs-general
>> Disclaimer
>>
>> This e-mail (including any attachments) is only for the person or
>> organisation it is addressed to. If you are not the intended
recipient
> you
>> must let me know immediately and then delete this e-mail. If you use
> this
>> e-mail without permission, or if you allow anyone else to see, copy
or
>
>> distribute the e-mail, or if you do, or don't do something because
you
>
>> have read this e-mail, you may be breaking the law.
>>
>> Liability cannot be accepted for any loss or damage arising from this
>> e-mail (or any attachments) or from incompatible scripts or any virus
>> transmitted.
>>
>> E-mails and attachments sent to or received from staff and elected
> Members
>> may be monitored and read and the right is reserved to reject or
> return or
>> delete any which are considered to be inappropriate or unsuitable.
>>
>> Do you really need to print this email? It will use paper, add to
your
>
>> waste disposal costs and harm the environment.
>>
>>
>
------------------------------------------------------------------------
> ------
>> _______________________________________________
>> mrbs-general mailing list
>> mrb...@li...
>> https://lists.sourceforge.net/lists/listinfo/mrbs-general
>>
>
>
>
>
------------------------------------------------------------------------
> ------
> _______________________________________________
> mrbs-general mailing list
> mrb...@li...
> https://lists.sourceforge.net/lists/listinfo/mrbs-general
> Disclaimer
>
> This e-mail (including any attachments) is only for the person or 
> organisation it is addressed to. If you are not the intended recipient
you 
> must let me know immediately and then delete this e-mail. If you use
this 
> e-mail without permission, or if you allow anyone else to see, copy or

> distribute the e-mail, or if you do, or don't do something because you

> have read this e-mail, you may be breaking the law.
>
> Liability cannot be accepted for any loss or damage arising from this 
> e-mail (or any attachments) or from incompatible scripts or any virus 
> transmitted.
>
> E-mails and attachments sent to or received from staff and elected
Members 
> may be monitored and read and the right is reserved to reject or
return or 
> delete any which are considered to be inappropriate or unsuitable.
>
> Do you really need to print this email? It will use paper, add to your

> waste disposal costs and harm the environment.
>
>
------------------------------------------------------------------------
------
> _______________________________________________
> mrbs-general mailing list
> mrb...@li...
> https://lists.sourceforge.net/lists/listinfo/mrbs-general
> 



------------------------------------------------------------------------
------
_______________________________________________
mrbs-general mailing list
mrb...@li...
https://lists.sourceforge.net/lists/listinfo/mrbs-general
Disclaimer

This e-mail (including any attachments) is only for the person or organisation it is addressed to. If you are not the intended recipient you must let me know immediately and then delete this e-mail. If you use this e-mail without permission, or if you allow anyone else to see, copy or distribute the e-mail, or if you do, or don't do something because you have read this e-mail, you may be breaking the law. 
 
Liability cannot be accepted for any loss or damage arising from this e-mail (or any attachments) or from incompatible scripts or any virus transmitted. 
 
E-mails and attachments sent to or received from staff and elected Members may be monitored and read and the right is reserved to reject or return or delete any which are considered to be inappropriate or unsuitable. 
 
Do you really need to print this email? It will use paper, add to your waste disposal costs and harm the environment.