Looks like error is from line 85 of Event model. Not at my computer right now. You can try:

'conditions' => 'relation = \'event\'',

to see if that solves this issue.

I will test this fix myself later tonight.

Thanks for reporting

Last updated 7 years ago

Yes this works for me, thank you for the fast reply! =D

I have been making quite a few changes to this plugin lately and was not really ready to push it out until I had tested a little more but I wanted to fix this issue. PLEASE report any issues promptly and I will rush to fix anything I may have broken recently.

Kurt, I wanted to update it and this appeared to me:

I found error in query :

    update `kurtjensen_mycal_events` 
    set `date` = 2017-04-28 00:00:00, 
    `length` = 2017-04-28 01:00:00, 
    `time` = 2017-04-28 12:00:00,
    `pattern` = FREQ=WEEKLY;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR;WKST=SU;UNTIL=14/27/2017;, 

and

    `pattern` = 'FREQ=WEEKLY;INTERVAL=1;BYDAY=MO,TU,WE,TH,FR;WKST=SU;UNTIL=14/27/2017;' , 

These queries are not created raw in the code. They are created by query builder of Laravel from the model->save()

The queries shown in ERROR are not the actual queries run. I have confirmed this on my own installations using https://octobercms.com/plugin/bedard-debugbar

One tool you might consider for helping find the issue is https://octobercms.com/plugin/bedard-debugbar

The error SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction is an error that can be caused by many other factors. Do a search on that issue "SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction" and see if there is a setting in MySQL that needs tweeking.