/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 vote173 views1 answer
Check psql validity function
SQL
0 vote185 views1 answer
Oracle SQL join three tables and group by column
SQL
0 vote173 views1 answer
Recursive query herarchical data sql server
SQL
0 vote186 views1 answer
Jenkins SQLCMD run
SQL
1 vote171 views2 answers
Sql where keyword
SQL
1 vote173 views1 answer
Delete row mssql
SQL
0 vote209 views2 answers
Starts and end with vowel sql
SQL
0 vote195 views1 answer
Sql with example
SQL
0 vote190 views1 answer
Mariadb cast null to 0
SQL
1 vote181 views1 answer
Postgres convert exisiting column to text
SQL