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
An error occurred while executing. Please try again later!
Moderators: ne_moj, zewa, vadimako, ne_moj, zewa, vadimako
-
- Site Admin
- Posts: 5976
- Joined: Jan 7th, '09, 23:18
- Contact:
Re: An error occurred while executing. Please try again later!
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.
Run this page again to see the error description.
Re: An error occurred while executing. Please try again later!
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?
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?
-
- Site Admin
- Posts: 5976
- Joined: Jan 7th, '09, 23:18
- Contact:
Re: An error occurred while executing. Please try again later!
I don't see here UPDATE SQL.
What UPDATE sql error do you get?
What UPDATE sql error do you get?
Re: An error occurred while executing. Please try again later!
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
On number 8 it has hotels but it should be companies
Thank you very much once again