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

Created at 30-Jul-2021 , By samar

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.

  • 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>
    

    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

If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.

Buy Me A Coffee

Don't forget to share this article! Help us spread the word by clicking the share button below.

We appreciate your support and are committed to providing you valuable and informative content.

We are thankful for your never ending support.