Skip to content

Increase delivery_instructions Field Length Across Address Tables #2245

@Huncsuga

Description

@Huncsuga
  • Lunar version: 1.0.0-beta22
  • Laravel Version: 11.45.1
  • PHP Version: 8.3.23
  • Database Driver & Version: MySQL 8.0.42

Expected Behaviour:

The delivery_instructions field in the lunar_addresses, lunar_cart_addresses, and lunar_order_addresses tables should allow users to enter longer messages without hitting character limits.

Actual Behaviour:

Currently, the delivery_instructions field is defined as a VARCHAR(255), which often results in a Data too long for column error when users try to provide more detailed instructions for delivery.

Steps To Reproduce:

  1. Attempt to submit an address form (e.g. as a guest) with a longer delivery_instructions message (e.g. over 255 characters).
  2. Observe SQL exception: SQLSTATE[22001]: Data too long for column 'delivery_instructions'.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions