No events displayed after 6.3.19 upgrade

[pacman]

Please help me

We did an upgrade from version 6.3.17 to version 6.3.19 but unfortunately there are no events displayed. We have the events stored in a mysql database, and we are able to check the info directly in mysql; however, there are no events displayed in the calendar neither in the events manager.
We checked the data in the setup manager and everything is correct. We followed the instructions for a manual upgrade ... but we don't know what's going on, any help will be appreciated.

[Brian]

Check the mySQL table and make sure that the columns are changed:

repeat > repeatx
type > eventType

[pacman]

Wow that's a fast response!!! Thank you very much now everything seems to be working .
Just a question, I didn't see anything of these changes in the upgrade instructions. Are these changes done in the autoinstall versions? or documented in any place for the manual upgrade?

[Brian]

It was supposed to happen automatically when logging into the Setup Manager after the upgrade. For some reason (unknown), it's not working correctly for everyone...

[pacman]

I might know what happened then. The user that we have for the calendar does not have all permissions in mysql, such as alter table. Maybe that's the problem

[mojo88]

I saw that your post was up while I was writing my question. I tried the solution of changing the fields in the mysql database and now the calendar has the events showing again, but a long line of the following error proceeds the calendar:

Warning: Division by zero in /home/jeetgill/public_html/calendar/functions/dateMarking.php on line 820

What to do next?

[Brian]

You have a repeating event with some incorrect information... Please open a support ticket and attach your database so I can take a look.

[BigWing]

I have upgraded 2 calendars - one is working fine but the other is showing no data! This is intolerable - it makes me look terrible to my client. Fortunately, I can see in phpAdmin that the data is still there.

I should not have to, but I have just used phpAdmin to alter the repeat > repeatx and type > eventType as described above - but now that calendar does not even show at all!

What are you doing to solve this problem? I need a fix now. Can I revert to an earlier version?

[Brian]

Please open a support ticket with the URL and login to your Setup Manager for the non-working calendar.

[BigWing]

I can't fault Brian for the speed of response! He spent the last few hours figuring out where the problem lay (it should be "eventx" and not "eventX" as he originally wrote). I am now up and running again.

Thanks again Brian (I assume it was you on the other end of the emails?).

[Brian]

It's all in a day's work!

(Not sure how that way in the first post that way but it's been fixed now.)