• Registered: 2019-05-28
  • Posts: 3

Topic: Calendar won't display after restoring sql database

Good morning.
I installed version 4.7.5 as an upgrade, following all instructions, from version 3.xx yesterday.
Today, the calendar displayed correctly except for a couple of entries. I also wanted to change the view.

So - i first changed the view to "work month" and then back to "month" using the admin tools in the calendar, as i want only one month to show at a time.
Then i changed "Weeks to show in month view" to "1".
My calendar quit displaying anything.  I believe its an sql error.

I attemped to restore the sql tables and data using sevearl methods, including "phpmyadmin" restore functions.
Im getting the following error in my log file:
019.05.29 09:00:53 mycal:ERROR Script: /Calendar/index.php - SQL query error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'e.ID' in 'field list'
Query string: SELECT
        e.`ID` AS eid,
        e.`private` AS pri,
        e.`title` AS tit,
and it continues down...
I looked at change dates for all calendar files and see none changed this morning.
URL to calendar is www.seips.org/calendar.php

What should i try?

Quote Post 1

  • Roel
  • Roel
  • Administrator
  • Offline
  • Registered: 2018-02-26
  • Posts: 565

Re: Calendar won't display after restoring sql database

We are currently solving this problem by email.

Roel

Quote Post 2

  • Registered: 2019-05-28
  • Posts: 3

Re: Calendar won't display after restoring sql database

Yes, this is most definitely a user problem, not a LuxCal issue.

Somehow i was able to install a LuxCal update, but I restored an earlier version of my sql database.

I have restored my backup to an older version while i work thru other php issues and it is solved.

This shows the importance of backing up!!!

Thank you Roel for you help.
TimE

Quote Post 3