Shopify / Shopify/shopify-app-template-php
Custom App with error Warning: 1265 Data truncated for column 'id' for the session table
Nobody has claimed this yet.
- Dominant language
- PHP
- Stars
- 340
- Forks
- 108
- PR merge metrics
- No merged PRs in 30d
Description
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
composer.json
session table schema
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
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by comparing the session table schema shown in the issue with the Laravel template code that writes the session id. Reproduce the warning against MySQL and trace the session update path; it is done when valid session ids can be stored without the data-truncation warning.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- laravel, mysql, php
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100