/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 vote179 views1 answer
Bigquery declare
SQL
10 votes168 views2 answers
Linux command line import mysql database
SQL
0 vote191 views1 answer
Postgres list all triggers
SQL
3 votes180 views1 answer
Sql insert inserted id
SQL
0 vote185 views1 answer
Mysql coonect sample code
SQL
0 vote278 views1 answer
Mysql update table from select on another table
SQL
0 vote254 views1 answer
How to check event scheduler status mysql
SQL
0 vote140 views2 answers
Avg() sql
SQL
0 vote168 views1 answer
Mysql percentage of total
SQL
0 vote183 views2 answers
Mysql dump database tables only
SQL