/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 vote93 views1 answer
Join creating duplicate columns sqllite
SQL
0 vote97 views5 answers
Mode sql course
SQL
0 vote87 views1 answer
Sql count null as 0
SQL
0 vote94 views1 answer
Oracle step procedure
SQL
0 vote99 views2 answers
Identity syntax in sql
SQL
0 vote110 views1 answer
How to create a table based on another table in mysql
SQL
3 votes94 views3 answers
Mysql get table size
SQL
0 vote92 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
0 vote89 views1 answer
Mysql get 2nd value in comma separated list
SQL
0 vote102 views3 answers
Postgres date difference seconds
SQL