/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 vote257 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
1 vote272 views1 answer
Mysql select and count left join
SQL
0 vote253 views1 answer
How to change mysql port in xampp
SQL
1 vote279 views1 answer
Select users with same username
SQL
3 votes257 views1 answer
Créer une table sql
SQL
0 vote270 views1 answer
MySQL update with subquery
SQL
6 votes264 views2 answers
Find mysql version linux
SQL
1 vote254 views1 answer
Oracle rolling back
SQL
3 votes274 views5 answers
Duplicate table sql
SQL
0 vote264 views1 answer
Mysql workbench view
SQL