/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 vote753 views2 answers
Zsh: command not found: mysq
SQL
13 votes311 views2 answers
Sql join
SQL
0 vote301 views1 answer
Sql last 7 days
SQL
0 vote301 views5 answers
Linq cheat sheet
SQL
4 votes312 views2 answers
Convert utc to est sql
SQL
0 vote319 views2 answers
Disadvantages of stored procedures sql
SQL
0 vote319 views1 answer
Create bdd mysql
SQL
8 votes322 views1 answer
Sql limit results returned
SQL
0 vote312 views1 answer
Create query in where clasue
SQL
37 votes307 views3 answers
Postgresql insert column
SQL