SQLSTATE[01000]: Warning: 1265 Data truncated for column 'visibility' at row 1

I have found this error SQLSTATE[01000]: Warning: 1265 Data truncated for column 'visibility' at row 1 while submitting form data to the table in column (enum type). I have passed the incorrect value to the form input while submitting the data.

Answers 1
  • Pass accurate data to form input while submitting data to column with enum type

    <select class="form-control" name="visibility" id="eventVisibility">
        <option selected value="public"> Public </option>
        <option value="private"> Private </option>
    </select>
    
    0

    There is a column with an enum type that has a predefined value in the table. So if pass the incorrect data or data which is already not defined in it then we can get SQLSTATE[01000]: Warning: 1265 Data truncated for column 'visibility' at row 1 error while submitting the form data to the server.

  • Back to code snippet queries related sql