The response from API is not formated

Request

Request paremeters:

http://ibe.qtravelcloud.com/api/hotels/directory/json/46d578be421290c458f4829597d87aa7?language=ro
Array ( [destination_code] => stv [hotel_code] => [page_number] => 1 [results_per_page] => 20 [hotel_name] => [facility_type] => [test] => [language] => ro )

Response




Database Error



	

A Database Error Occurred

Error Number: 1054

Unknown column 'QTC_Destinations_Cities.HotelsSystemsOrder' in 'field list'

SELECT `QTC_Destinations_Cities`.`Id`, `QTC_Destinations_Cities`.`Id` AS `CityId`, `QTC_Destinations_Cities`.`CityCode`, `QTC_Destinations_Cities`.`IataCode`, `QTC_Destinations_Cities`.`Latitude`, `QTC_Destinations_Cities`.`Longitude`, `QTC_Destinations_Cities`.`HotelsSystemsOrder`, COALESCE(`QTC_Destinations_Cities_Translations`.`CityName`, `QTC_Destinations_Cities`.`CityName`) AS `CityName`, COALESCE(`QTC_Destinations_Countries`.`Id`, 0) AS `CountryId`, COALESCE(`QTC_Destinations_Countries`.`CountryCode`, '') AS `CountryCode`, COALESCE(`QTC_Destinations_Countries_Translations`.`CountryName`, `QTC_Destinations_Countries`.`CountryName`) AS `CountryName` FROM `QTravelCloudOnlineIBE_57`.`QTC_Destinations_Cities` LEFT OUTER JOIN `QTravelCloudOnlineIBE_57`.`QTC_Destinations_Cities_Translations` ON `QTC_Destinations_Cities_Translations`.`CityId` = `QTC_Destinations_Cities`.`Id` AND `QTC_Destinations_Cities_Translations`.`Language` = 'ro' AND `QTC_Destinations_Cities_Translations`.`Deleted` = 0 LEFT OUTER JOIN `QTravelCloudOnlineIBE_57`.`QTC_Destinations_Countries` ON `QTC_Destinations_Countries`.`Id` = `QTC_Destinations_Cities`.`CountryId` LEFT OUTER JOIN `QTravelCloudOnlineIBE_57`.`QTC_Destinations_Countries_Translations` ON `QTC_Destinations_Countries_Translations`.`CountryId` = `QTC_Destinations_Countries`.`Id` AND `QTC_Destinations_Countries_Translations`.`Language` = 'ro' AND `QTC_Destinations_Countries_Translations`.`Deleted` = 0 WHERE `QTC_Destinations_Cities`.`CityCode` = 'stv' AND `QTC_Destinations_Cities`.`Deleted` = 0 LIMIT 1

Filename: /var/www/html/qtravelcloud.com/backoffice/core/MY_Model.php

Line Number: 20