RE: Laravel #6 - How to fix SQLSTATE error [42000]: Syntax error or access violation: 1071 Specified key was too long in laravel by yokunjon

utopian-io · @yokunjon · Feb 19 '18

Thank you for the contribution. It has been approved.

* I did approve, but you should fix your grammar. Otherwise, it won't be formal as stated in rules. Reason for my approval is your post showed how to reproduce it, detect it, fix it. And this is the preferable way of teaching something. If you need assistance with grammar, you can use Grammarly or like programs.

You can contact us on [Discord](https://discord.gg/uTyJkNm).

**[[utopian-moderator]](https://utopian.io/moderators)**

properties (22)

`author`	yokunjon
`permlink`	re-iwaydi-laravel-6-how-to-fix-sqlstate-error-42000-syntax-error-or-access-violation-1071-specified-key-was-too-long-in-laravel-20180219t082932607z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"community":"utopian","app":"utopian/1.0.0"}
`created`	2018-02-19 08:31:00
`last_update`	2018-02-19 08:31:00
`depth`	1
`children`	1
`last_payout`	2018-02-26 08:31:00
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	488
`author_reputation`	19,266,807,595,513
`root_title`	"Laravel #6 - How to fix SQLSTATE error [42000]: Syntax error or access violation: 1071 Specified key was too long in laravel"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	38,732,643
`net_rshares`	0

`author`	iwaydi
`permlink`	re-yokunjon-re-iwaydi-laravel-6-how-to-fix-sqlstate-error-42000-syntax-error-or-access-violation-1071-specified-key-was-too-long-in-laravel-20180219t105817227z
`category`	utopian-io
`json_metadata`	{"tags":["utopian-io"],"users":["yokunjon"],"app":"steemit/0.1"}
`created`	2018-02-19 10:58:21
`last_update`	2018-02-19 10:58:21
`depth`	2
`children`	0
`last_payout`	2018-02-26 10:58:21
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	87
`author_reputation`	611,028,158,863
`root_title`	"Laravel #6 - How to fix SQLSTATE error [42000]: Syntax error or access violation: 1071 Specified key was too long in laravel"
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	38,760,409
`net_rshares`	0