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

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions