search

Shopify / shopify-app-template-php

280 stars 90 forks source link

Custom App with error Warning: 1265 Data truncated for column 'id' for the session table #500

Open robinhosanee opened 7 months ago

robinhosanee commented 7 months ago

Issue summary

Hello,

Built a Custom App and getting occasional error

(PDOException(code: 01000): SQLSTATE[01000]: Warning: 1265 Data truncated for column 'id' for the session table ![image](https://github.com/Shopify/shopify-app-template-php/assets/31942027/93ca86f3-ed5e-4a55-bc15-14eba2f6f9bb)

composer.json image

session table schema image

It looks like the Laravel template is trying to update the session id column with a varchar value when it is of type int . so mySQL is throwing an error.

Not sure if anyone encountered the same issue and what would be a solution to this issue ?

Thank you