Schedule V3
Have just started using scheduler and like so many have been having trouble getting any data to “stick” to the database…
After a number of weeks chasing the issue… the solution is simple!
Symptoms
You install a fresh copy of scheduler 3.x (mine was 3.6)
You create a scheduler menu item
from the menu you navigate to the scheduler page
you enter new event/data
navigate away from the page changes lost, not saved to database
regardless of ACL settings… new items are not saved,
but you can edit and save the default item “scheduler calendar was installed on…”
on some views the event is in a red font (indicates database write error)
I fixed this by simply allowing null values in all database fields
- further investigation shows that its possibly the lat and lng fields of the table events_rec
- when a new record is written there is no value written to the lat and lng fields
- at the database level there is no default value
- because of this when no value is specified by the code and null is not allowed the write fails
- because scheduler is Java based the changes are made to the displayed page but not to the database.
Hope it helps those that are having similar issues
BTW - I dont see any error on database write from the front-end even with debug set to on