/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 vote220 views1 answer
How to get alternate records from a table in sql
SQL
0 vote255 views1 answer
How to know if table in rigt or left in sql
SQL
1 vote223 views2 answers
Postgresql list columns
SQL
0 vote225 views1 answer
Sql orcale i forgot what my name & password was
SQL
-1 vote234 views3 answers
Psql get last rows
SQL
1 vote279 views1 answer
Create email address from first and last name in sql
SQL
0 vote264 views1 answer
How to create notes in mysql
SQL
9 votes270 views3 answers
Postgres make sql dump
SQL
0 vote254 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
6 votes288 views2 answers
How to get last element sql
SQL