• Registered: 2018-04-03
  • Posts: 7

Topic: Error upgrading from v4.5.2 to v4.6

I was on 4.5.2, tried to upgrade to 4.6.

The web page say: SQL error. See 'logs/sql.log'

The log says:

2018.04.03 13:55:44 Script: /calendar/index.php - SQL execute error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'g.sendSms' in 'field list'
Values string: 2

Can this be corrected?

Thanks

Quote Post 1

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

Re: Error upgrading from v4.5.2 to v4.6

Hi Gilbert,

The column name sendSms is a valid name and therefore it is hard to say what went wrong.
Could you export the database from your 4.5.2 version to a .sql file and email this file to me. I will then analyze the problem, upgrade the file to 4.6 and send it back to you. Thereafter you can import the file in your v4.6 calendar and all should be fine.
Roel

Quote Post 2

  • Registered: 2018-04-03
  • Posts: 7

Re: Error upgrading from v4.5.2 to v4.6

Thank you, you are very kind.  You did this the last time I upgraded, I had a similar issue.
When would be the best time to send you the file so that I can get it back quickly and import it?  I want to make sure we don't overwrite anything in the database.

Also, what it the best way to get it to you?

Quote Post 3

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

Re: Error upgrading from v4.5.2 to v4.6

Hi Dilbert,

I suggest to export the calendar database to a .sql file, for instance using phpMyAdmin, as soon as possible and send it to me via the email address at the bottom of the Contact Us page. I think you are  in the USA, so if you send me the file by the end of your day, I will work on it while you are asleep and send the upgraded database back to you next day.
Roel

Quote Post 4

  • Registered: 2018-04-03
  • Posts: 7

Re: Error upgrading from v4.5.2 to v4.6

Thank you!  I sent you the database.

Quote Post 5