/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 vote145 views1 answer
Returning with sqlalchemy
SQL
0 vote141 views1 answer
Mysql update sum same table
SQL
0 vote145 views4 answers
Database stuck at restoring state
SQL
-1 vote97 views2 answers
Datetime sql server week
SQL
4 votes149 views2 answers
Oracle default date format
SQL
0 vote108 views1 answer
Mysql workbench search all tables
SQL
13 votes173 views3 answers
List all the tables in sql
SQL
0 vote138 views1 answer
Allow all local clients (local socket connections) to connect to the kodekloud_db1
SQL
0 vote139 views1 answer
Sql developer export connections
SQL
0 vote114 views1 answer
Prevent duplicate rows in postgres
SQL