/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

9 votes328 views3 answers
Where in sql
SQL
0 vote344 views1 answer
Drop unique
SQL
19 votes323 views1 answer
Sqrt(-1)
SQL
2 votes368 views1 answer
Mysql set value as null
SQL
5 votes323 views3 answers
Truncate function in sql oracle
SQL
0 vote338 views1 answer
Soql last week
SQL
0 vote350 views1 answer
SQL SELECT-Klausel
SQL
4 votes356 views2 answers
Sql offset
SQL
3 votes359 views1 answer
Sql timestamp to date
SQL
0 vote360 views1 answer
Get date from timestamp in mysql
SQL