An error occurred while executing. Please try again later!

[amohd]

Hi,

I am having issues to add new hotels under hotel info. similar to that i can't add 'hotel owner' under hotel owners user list. I am getting below error


An error occurred while executing. Please try again later!



Please help

[administrator]

Open include/classes/Hotels.class.php and set $debug = true; at the top of the file.
Run this page again to see the error description.

[akis]

Hello, I have 443 version with x- soho template and
i can't add 'hotel owner' or 'admin' too.
I have debugged hotel.class.php and i get this:
Errors(0):
------

Warnings(1):
------
* Field hotel_id: wrong definition in View mode or at least one field has no value in SQL! Please check currefully your code.

SQL:
------
Total Records | T: 0.0384 sec.
SELECT COUNT(*) as mg_total_records, aphs_hotels.id, aphs_hotels.hotel_location_id, aphs_hotels.phone, aphs_hotels.fax, aphs_hotels.email, aphs_hotels.time_zone, aphs_hotels.map_code, aphs_hotels.latitude, aphs_hotels.longitude, aphs_hotels.hotel_image_thumb, aphs_hotels.stars, aphs_hotels.is_default, aphs_hotels.is_active, aphs_hotels.priority_order, CONCAT("[ Define ]") as link_default_periods, CONCAT("[ Rooms ] (", (SELECT COUNT(*) as cnt FROM aphs_rooms r WHERE r.hotel_id = aphs_hotels.id) , ")") as link_rooms, CONCAT("Upload (", (SELECT COUNT(*) as cnt FROM aphs_hotel_images hi WHERE hi.hotel_id = aphs_hotels.id) , ")") as link_upload_images, aphs_hotels_description.name FROM (aphs_hotels LEFT OUTER JOIN aphs_hotels_description ON aphs_hotels.id = aphs_hotels_description.hotel_id AND aphs_hotels_description.language_id = 'en') WHERE 1 = 1 LIMIT 0, 1
Retrieve Records | T: 0.0014 sec.
SELECT aphs_hotels.id, aphs_hotels.hotel_location_id, aphs_hotels.phone, aphs_hotels.fax, aphs_hotels.email, aphs_hotels.time_zone, aphs_hotels.map_code, aphs_hotels.latitude, aphs_hotels.longitude, aphs_hotels.hotel_image_thumb, aphs_hotels.stars, aphs_hotels.is_default, aphs_hotels.is_active, aphs_hotels.priority_order, CONCAT("[ Define ]") as link_default_periods, CONCAT("[ Rooms ] (", (SELECT COUNT(*) as cnt FROM aphs_rooms r WHERE r.hotel_id = aphs_hotels.id) , ")") as link_rooms, CONCAT("Upload (", (SELECT COUNT(*) as cnt FROM aphs_hotel_images hi WHERE hi.hotel_id = aphs_hotels.id) , ")") as link_upload_images, aphs_hotels_description.name FROM (aphs_hotels LEFT OUTER JOIN aphs_hotels_description ON aphs_hotels.id = aphs_hotels_description.hotel_id AND aphs_hotels_description.language_id = 'en') WHERE 1 = 1 ORDER BY aphs_hotels.priority_order ASC LIMIT 0, 20

POST:
------
Array
(
)
How can i fix it?

[administrator]

I don't see here UPDATE SQL.

What UPDATE sql error do you get?

[akis]

Ok i found it. It was a field in mysql in account table
On number 8 it has hotels but it should be companies
Thank you very much once again