Skip to content

NethHotel: Can't add extras on new installations #7600

@Stell0

Description

@Stell0

extra_history table don't accept NULL input for checkout column, but doesn't have a default value. Function to add the extra doesn't provide a value for the checkout column

Steps to reproduce

  • Install Nethvoice 8 and enable hotel
  • create a new "extra"
  • add a room
  • check in the room
  • charge the extra to the room

Expected behavior

  • extra should be added to the list

Actual behavior

  • extra list remains empty

Workaround

MariaDB [roomsdb]> ALTER TABLE roomsdb.extra_history MODIFY COLUMN checkout TINYINT(1) NOT NULL DEFAULT 0;

See also

https://mattermost.nethesis.it/nethesis/pl/hkac39whbpyi9y1ps4imep3n6r

Metadata

Metadata

Assignees

No one assigned

    Labels

    nethvoiceBug or features releted to the NethVoice project

    Type

    Projects

    Status

    Done

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions