1.4.3 to 1.5 Database Migration

[Christopher]

Good morning,

I wanted to first thank you for all that you do.

I'm working on upgrading from 1.4.3 to 1.5 using an existing database. I've read another conversation stating to follow the database update process. I wasn't able to access the backend due to the database errors, but was able to run php index.php console migrate. 

I was then able to log into the backend, but I still keep getting DB errors and no appointments/services are showing up. Did I do something incorrectly? seems like the database didn't update correctly. 

Errors:

A DATABASE ERROR OCCURRED

Error Number: 1054

Unknown column 'is_unavailability' in 'where clause'

SELECT * FROM `ea_appointments` WHERE 'all' = 'all' AND ((start_datetime > '2022-11-28' AND `start_datetime` < '2022-12-06') or (`end_datetime` > '2022-11-28' AND `end_datetime` < '2022-12-06') or (`start_datetime` <= '2022-11-28' AND end_datetime >= '2022-12-06')) AND is_unavailability = 0 AND `delete_datetime` IS NULL AND `is_unavailability` = 0

Filename: models/Appointments_model.php

Line Number: 331

[txuko]

it run without error via command line but  I am having the same problem, if I run it on the browser I get a failure page

trying to sync I get " Argument 1 passed to Providers_model::find() must be of the type int, string given, called in .../easyappointments/application/controllers/Google.php on line 72" not sure if it's related to the same field as I'm not savvy enough unfortunately 
regards,

txuko

[Alex Tselegidis]

Hello! 

It looks like the is indeed naming issue when upgrading, but I will have to check the migrations before I can tell. 

For now make sure that the ea_appointments DB table has a column called is_unavaibility and not is_unavailable as it used to be in the previous releases. 

Alex Tselegidis, Easy!Appointments Creator Need a customization? Get a free quote!

[Christopher]

That was it. Thank you Alex!

[Alex Tselegidis]

Awesome, glad to know you solved the problem. 

Alex Tselegidis, Easy!Appointments Creator Need a customization? Get a free quote!

[Bitaubé Antoine (Ab)]

Ok, I get same issue, it's not right written again, it's : "  is_unavailability " ;) Thanks, I finally succeed update and everything work <3

[Alex Tselegidis]

Glad you sorted this out

Alex Tselegidis, Easy!Appointments Creator
Need a customization? Get a free quote!