Database error importing site

Support
1

Since today I have the same issue.

Local Lightning 5.0.7 and OSX Catalina.

Error: Command failed: /Applications/Local.app/Contents/Resources/extraResources/site-binaries/mysql-8.0.15/bin/mysql --default-character-set=utf8 -A --skip-column-names -e SET names ‘utf8’; use local; source /Users/username/Documents/Websites/test/app/sql/local.wp_cf_forms.sql;

ERROR 1062 (23000) at line 4 in file: ‘/Users/username/Documents/Websites/test/app/sql/local.wp_cf_forms.sql’: Duplicate entry ‘1’ for key ‘PRIMARY’

2

@soldier99, it looks like there is an issue with the local.wp_cf_forms.sql file.

You might try pulling that from the folder, zipping it up and importing it again. You’ll probably need to look at the SQL syntax to see if there is an issue with the Primary key in that table.

3

Hey @soldier99 – were you able to get this site imported correctly?

4

No. I just created a new site and started fresh.

5

Thanks for following up and letting us know. Let us know if you need any other help, otherwise have a great day!

6

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.