error 1054

More
9 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.

Please Log in or Create an account to join the conversation.

More
9 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,
The following user(s) said Thank You: halipeti

Please Log in or Create an account to join the conversation.

Moderators: solidres
Powered by Kunena Forum

All the things you need to make your work easier. Did you like Solidres?