Booking not saved if seat prefix has more than 11 characters

  • Resolved kalle1989

    (@kalle1989)


    1 year, 10 months ago

    First of all, thank you for this great plugin!

    I have a very specific use case where I need to name the “seats/seats”. While testing, I found that the booking only works if the prefix is not longer than 11 characters. The booking is not saved if I have more than 11 characters.

    I checked the coding in “seatreg_functions.php” and saw that the database field “seat_nr” is defined as “varchar(11)”. For my use case, I changed the coding/database field to “varchar(255)” and now the booking is also stored with a longer prefix.

    Could you expand the field to 255 by default or is there a reason this was limited?

    With kind regards,
    Kai

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

    (@thesiim)

    Hello

    At the time I chose the “varchar(11)” for “seat_nr” there were no prefix feature (it was added a lot later). So I though to myself how many characters “seat_nr” should take. And I thought that 11 should be okay.
    But now there is this prefix feature and you can add custom seat numbers. So yeah the 11 is not enough. I am planning to change it to 255. Thank you for notifying

    Thread Starter kalle1989

    (@kalle1989)

    Thanks @thesiim for your fast response

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Booking not saved if seat prefix has more than 11 characters’ is closed to new replies.