error message: 1 Error, missing data for getting the booking information

  • Resolved droomarario

    (@droomarario)


    4 years ago

    Hello, I would like to make an enquiry.

    We are using your booking system, thanks for providing great engine.
    But there is a small error continuously occurring, can you check and see if it can be fixed.

    On our booking page, there is a black text field for users to write down any demands. When users use apple emojis, error occurs and the user cannot continue the booking.

    Also we tried to book a room via ‘Bookings Calender’ at the admin page, but when text on the ‘customer information’ field include apple emojis, error occurs as well. This error is more serious than the user error, because not only the booking cannot be completed, the booking data somehow enters into the system. So the room is shown as occupied(at ‘availability overview’ and also at the front), but in the ‘all bookings’ page — where we believe all bookings must be shown and could be searched — there is no corresponding data. Also, at ‘availability overview’ page the error message ‘1 Error, missing data for getting the booking information’ pops up. So there is no way to cancel the relevant booking, nor get a new booking for the room, meanwhile the room is shown as occupied.

    In short, we ask you two things.

    1. To check the problem which occur when user uses apple emojis. (We warned users not to use any emoji or special characters throughout the booking process, but we hope the error is fixed.)
    2. To provide us a way to completely delete the ‘entered data’ described above. We wish to get a new booking for the room (or at least get access to the corresponding data).

    I hope our problem is well conveyed to those who may concern, and we will wait for your response. Thank you for your effort.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author e4jvikwp

    (@e4jvikwp)

    Hello,

    Thanks for reporting the issue with all the details. We would like to explain first what is happening, especially in the wp-admin section when you try to create a manual reservation.

    Basically, the system first occupies the room by executing some “INSERT” queries on a specific database table of Vik Booking, and then it attempts to save the reservation record by making another query. What’s happening in your case is that this query to create the new reservation record fails, and so you end up having like a “ghost” record that is occupying the room on the requested dates, but such record is not related to any reservation ID.

    The same thing is happening in the front-end section of your website, when your guests use the input field with some Emoji characters.

    Such queries fail due to an SQL error, usually with code 1366, which equals to “Incorrect string value” for the content of the query. We’ve seen this issue happening several times to others of our clients, but it is not something related to Vik Booking, it is only caused by an invalid Database Characters Set and Collate, which should be set to support the “utf8mb4” collation.

    You should also discuss this topic with your hosting company, to make sure your database supports Emoji characters with the “utf8mb4” collation.

    As a quick work-around, we can suggest using a database management interface like PHPMyAdmin, and by selecting the table “_vikbooking_orders”, you can alter the column “custdata” to make sure its collation supports a set of the “utf8mb4_unicode” collation. However, this should not be necessary as long as the UTF8MB4 collation is supported by your database.

    This should answer your first question. Regarding your second question instead, locating a “ghost” record to free up the room on specific dates is not that easy, especially if you have a lot of reservations stored in your database. It is true that we could implement a sort of a fallback system to identify such “ghost records” in the database to remove them, but the point is that such issues should not happen if you have a recent version of MySQL (or any other type of database) that supports a wide range of character sets.
    The record you want to remove is stored in the database table “_vikbooking_busy”, but identifying the exact record is pretty hard, as all check-in and check-out dates are expressed in Unix Timestamps. One record ID in that table is not linked to any reservation ID, and so it’s a “ghost” record that occupies your room.

    We invite you to get in touch with our team through our website if you need any further help, as this is something pretty technical that involves your database collation, and so similar issues should never happen.

    We hope this helps!

    Best,
    The VikWP Team

    Thread Starter droomarario

    (@droomarario)

    Thank you for the specific explanation, and such immediate reply. We find the reply very helpful, and we see that further action for the resolution is our work to do. Thanks again!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘error message: 1 Error, missing data for getting the booking information’ is closed to new replies.