CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`80.57.191.10` SQL SECURITY DEFINER VIEW `vw_availability_per_object` AS select `vw_availability_per_month`.`objectID` AS `objectid`,sum((case when ((`vw_availability_per_month`.`bookingyear` = year(now())) and (`vw_availability_per_month`.`bookingmonth` = month(now()))) then `vw_availability_per_month`.`numberofweeks` else 0 end)) AS `cur_month_numberofweeks`,sum((case when ((`vw_availability_per_month`.`bookingyear` = year(now())) and (`vw_availability_per_month`.`bookingmonth` = month(now()))) then `vw_availability_per_month`.`weeksbooked` else 0 end)) AS `cur_month_weeksbooked`,sum((case when ((`vw_availability_per_month`.`bookingyear` = year((now() + interval 1 month))) and (`vw_availability_per_month`.`bookingmonth` = month((now() + interval 1 month)))) then `vw_availability_per_month`.`numberofweeks` else 0 end)) AS `month_1_numberofweeks`,sum((case when ((`vw_availability_per_month`.`bookingyear` = year((now() + interval 1 month))) an[...]

MySQL said: Documentation
#1449 - The user specified as a definer ('root'@'80.57.191.10') does not exist