/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 vote124 views1 answer
Group by max date
SQL
2 votes123 views1 answer
Oracle block
SQL
0 vote118 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote142 views1 answer
Typical max-connect-errors mysql
SQL
1 vote149 views1 answer
Drop colum oracle 18c
SQL
4 votes113 views2 answers
Mysql select where starts with
SQL
3 votes116 views2 answers
How to start postgresql on windows
SQL
1 vote109 views1 answer
Reutrn string after character sql
SQL
0 vote117 views1 answer
How to login to mysql in homestead
SQL
0 vote118 views1 answer
MySQL INSERT IGNORE Statement
SQL