/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

1 vote149 views1 answer
Order by oracle
SQL
18 votes158 views4 answers
Mysql current date between two dates
SQL
0 vote215 views1 answer
Php insert null mysql
SQL
1 vote158 views1 answer
Input in mysql
SQL
7 votes174 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
8 votes190 views1 answer
See all users mysql
SQL
5 votes147 views1 answer
Sql select ciunt
SQL
0 vote163 views2 answers
Null value in column violates not-null constraint
SQL
1 vote163 views1 answer
Mysql size int
SQL
0 vote183 views1 answer
Sql create table with references not primary key
SQL