/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 vote112 views1 answer
Mysql wait_timeout
SQL
4 votes131 views1 answer
Postgresql create table with index
SQL
0 vote118 views1 answer
Disableforiegn key check
SQL
0 vote117 views1 answer
Mysql query with sql to get the next row
SQL
0 vote130 views3 answers
Characters found after end of sql statement
SQL
3 votes108 views2 answers
Mysql create database
SQL
0 vote122 views1 answer
Mysql update from select on same table
SQL
5 votes124 views1 answer
Oracle generate list of dates in between a date range
SQL
4 votes107 views1 answer
Id primary key auto generated
SQL
0 vote109 views1 answer
Java mysql date format
SQL