search

khsing / laravel-world

provide countries, states, and cities relations and database.
MIT License
427 stars 89 forks source link

Problem migrating when using sqlite #16

Closed calvincanas closed 3 years ago

calvincanas commented 5 years ago

Hello,

Trying to use sqlite as database in testing caused error when it tries to migrate. Error was: General error: 1 index uniq_locale already exists

The problem might be using same index name even for different tables.

Reference

subhakumariB commented 5 years ago

am getting this error Execute migrate first, migrating...

In Connection.php line 664:

SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it. (SQL: select * from information_schema.tables where table_schema = homestead and table_name = migrations)

In Connector.php line 67:

SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it.

khsing commented 3 years ago

@calvincanas @subhakumariB would you guys provide more information? like PHP version, laravel version