/SQL/SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"

SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"

$table->integer('thnajrn_id', 10)->unsigned();
to
$table->integer('thnajrn_id')->unsigned();
or try
table->integer('thnajrn_id')->length(10)->unsigned();

Syntax error or access violation: 1075 Incorrect table def inition; there can be only one auto column and it must be defined as a key

$table->integer('thnajrn_id')->unsigned();

Source: stackoverflow.com

Similar codes

0 vote210 views1 answer
Get schema of table sql
SQL
1 vote235 views2 answers
Full join
SQL
4 votes214 views2 answers
Oracle last day of month
SQL
0 vote212 views1 answer
Alter database name script
SQL
1 vote194 views1 answer
SQL server query column yes or no
SQL
0 vote212 views1 answer
Microsoft sql server python connection
SQL
0 vote196 views1 answer
Mysql shell set time_zone
SQL
0 vote210 views1 answer
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-de-Quentin.local.pid).
SQL
0 vote206 views1 answer
Contact mysql column field
SQL
0 vote200 views1 answer
Alter table name including schema
SQL