/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 vote218 views1 answer
AddEntityFrameworkSqlite
SQL
-1 vote227 views1 answer
Mysql extract days
SQL
0 vote234 views1 answer
Sql stored procedure update if parameter is not null
SQL
1 vote196 views1 answer
Insert into sql
SQL
8 votes251 views1 answer
Oracle add auto_increment column to existing table
SQL
1 vote230 views3 answers
How to get date in sql
SQL
6 votes285 views2 answers
Oracle undotbs usage
SQL
0 vote231 views1 answer
Mysql conf.d exampel
SQL
2 votes230 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
4 votes255 views1 answer
Oracle nls_date_format
SQL