antonioribeiro / antonioribeiro/tracker
i got tracker session table error after uploading hosting
- Dominant language
- PHP
- Stars
- 2.9k
- Forks
- 594
- PR merge metrics
- No merged PRs in 30d
Description
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' (SQL: insert into `tracker_sessions` (`user_id`, `device_id`, `client_ip`, `geoip_id`, `agent_id`, `referer_id`, `cookie_id`, `language_id`, `is_robot`, `uuid`, `updated_at`, `created_at`) values (, , 124.43.41.19, , , , , , 0, 0b73a0e3-4636-4565-9e83-faa6673743e5, 2019-11-08 09:54:37, 2019-11-08 09:54:37))
Contributor guide
No contributing guide indexed for this repository
Research direction
Start by reproducing the hosting upload that triggers the `tracker_sessions` insert and inspect the table schema and insert path. Confirm the cause of the duplicate primary-key value, then verify that uploading no longer produces the SQLSTATE[23000] error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- laravel, php
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100