/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 vote140 views1 answer
What is top n result in sql
SQL
0 vote132 views1 answer
Postgres sequence name
SQL
0 vote131 views1 answer
Database traccar
SQL
0 vote133 views1 answer
Narural join
SQL
1 vote133 views2 answers
Rebuild index sql server
SQL
1 vote130 views1 answer
Md5 encryption for existing records
SQL
7 votes126 views4 answers
What is my mysql version
SQL
0 vote134 views1 answer
Mysql_union
SQL
0 vote184 views1 answer
Oracle db get table sizes
SQL
0 vote127 views2 answers
How to combine diff colmun value using group by postgres
SQL