- Posts: 1
- Home
- Forum
- Community Forum
- Feature requests / Suggestions
- Complex tariff - set % rate based on base rate
error 1054
- halipeti
- Topic Author
- Offline
Less
More
10 years 9 months ago #4445
by halipeti
error 1054 was created by halipeti
Dear Solidres,
After I write the check in and out ; and i click the "Search" buttom I get this massage:
An error has occurred while processing your request.
You may not be able to visit this page because of:
an out-of-date bookmark/favourite
a mistyped address
a search engine that has an out-of-date listing for this site
you have no access to this page
Go to the Home Page
Home Page
If difficulties persist, please contact the System Administrator of this site and report the error below.
1054 Unknown column 'state' in 'where clause' SQL=SELECT id, label FROM `ykn_sr_rooms` WHERE room_type_id = '1' AND id NOT IN (SELECT room_id FROM `ykn_sr_limit_booking_details` WHERE limit_booking_id IN (SELECT id FROM `ykn_sr_limit_bookings` WHERE ( ('2014-07-07' <= start_date AND '2014-07-09' > start_date ) OR ('2014-07-07' >= start_date AND '2014-07-09' <= end_date ) OR ('2014-07-07' < end_date AND '2014-07-09' >= end_date ) ) AND state = 1 ))
Thank for your answer.
After I write the check in and out ; and i click the "Search" buttom I get this massage:
An error has occurred while processing your request.
You may not be able to visit this page because of:
an out-of-date bookmark/favourite
a mistyped address
a search engine that has an out-of-date listing for this site
you have no access to this page
Go to the Home Page
Home Page
If difficulties persist, please contact the System Administrator of this site and report the error below.
1054 Unknown column 'state' in 'where clause' SQL=SELECT id, label FROM `ykn_sr_rooms` WHERE room_type_id = '1' AND id NOT IN (SELECT room_id FROM `ykn_sr_limit_booking_details` WHERE limit_booking_id IN (SELECT id FROM `ykn_sr_limit_bookings` WHERE ( ('2014-07-07' <= start_date AND '2014-07-09' > start_date ) OR ('2014-07-07' >= start_date AND '2014-07-09' <= end_date ) OR ('2014-07-07' < end_date AND '2014-07-09' >= end_date ) ) AND state = 1 ))
Thank for your answer.
Please Log in or Create an account to join the conversation.
- vietvh
-
- Offline
Less
More
- Posts: 1553
10 years 9 months ago #4446
by vietvh
Replied by vietvh on topic error 1054
Hi,
Could you make sure that you are using the latest stable version of Solidres and plugins?
You can go to the backend of Solidres - menu System in the bottom of the left navigation bar and take a screenshot of it. Then please attach it here so that we can check it for you.
Regards,
Could you make sure that you are using the latest stable version of Solidres and plugins?
You can go to the backend of Solidres - menu System in the bottom of the left navigation bar and take a screenshot of it. Then please attach it here so that we can check it for you.
Regards,
The following user(s) said Thank You: halipeti
Please Log in or Create an account to join the conversation.
Moderators: solidres