/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

6 votes145 views4 answers
Remove spaces sql server
SQL
0 vote161 views2 answers
Mysql add days to date
SQL
3 votes131 views5 answers
Mysql get last inserted id
SQL
0 vote155 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
2 votes180 views1 answer
Username sql
SQL
0 vote141 views1 answer
SQL Query to delete all the tables in a database
SQL
8 votes145 views2 answers
Sqlsrv default port
SQL
0 vote141 views1 answer
Mysql replication change database name
SQL
0 vote200 views1 answer
Oracle sql all days except weekends
SQL
0 vote159 views1 answer
Synapse sql table set pk
SQL