/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

3 votes208 views3 answers
How to set up an auto incrementing id db browser
SQL
4 votes303 views1 answer
Select first and last row sql
SQL
0 vote206 views1 answer
Normalization in database 2nd normal form
SQL
0 vote199 views1 answer
Postgresql create user roles
SQL
0 vote213 views1 answer
Python dictionary to sql update
SQL
0 vote284 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote284 views1 answer
Sql delete caracter list
SQL
0 vote216 views1 answer
Search db for table name
SQL
3 votes197 views1 answer
Oracle transaction commit rollback example
SQL
0 vote195 views1 answer
Oracle current timestamp
SQL