An error occurred while executing. Please try again later!

Discuss everything related to PHP Hotel Site. All versions. Any questions related to the PHP Hotel Site developing or using should be posted to this forum.

Moderators: ne_moj, zewa, vadimako, ne_moj, zewa, vadimako

amohd
Newbie
Newbie
Posts: 3
Joined: Oct 10th, '15, 08:36

An error occurred while executing. Please try again later!

Postby amohd » Aug 1st, '16, 17:23

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
Site Admin
Site Admin
Posts: 5990
Joined: Jan 7th, '09, 23:18
Contact:

Re: An error occurred while executing. Please try again later!

Postby administrator » Aug 2nd, '16, 10:11

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
Expert
Expert
Posts: 66
Joined: Feb 20th, '13, 20:33

Re: An error occurred while executing. Please try again later!

Postby akis » Feb 25th, '18, 09:34

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
Site Admin
Site Admin
Posts: 5990
Joined: Jan 7th, '09, 23:18
Contact:

Re: An error occurred while executing. Please try again later!

Postby administrator » Feb 26th, '18, 11:36

I don't see here UPDATE SQL.

What UPDATE sql error do you get?

akis
Expert
Expert
Posts: 66
Joined: Feb 20th, '13, 20:33

Re: An error occurred while executing. Please try again later!

Postby akis » Feb 26th, '18, 17:57

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


Return to “ApPHP HotelSite / uHotelBooking Talk {developers/users}”