Hi,
I’m trying to create a new site on a remote database and I’ve already followed this tutorial:
https://discuss.frappe.io/t/remote-database-setup/22687/6, which used to work for me on ERPNext 11.
Now, I am doing everything same on ERPNext 12 but it’s giving me error now, which is:
frappe@ubuntu:~/frappe-bench$ bench new-site site1.remote --install-app erpnext --verbose
MySQL root password:
Created user _a1947c1ffeceb24a
Created database _a1947c1ffeceb24a
Granted privileges to user _a1947c1ffeceb24a and database _a1947c1ffeceb24a
Starting database import...
Creating Database...
9.23KiB 0:00:00 [ 180MiB/s] [========================================================================>] 100%
ERROR 1171 (42000) at line 174: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
Imported from database /home/frappe/frappe-bench/apps/frappe/frappe/database/mariadb/framework_mariadb.sql
Database not installed, this can due to lack of permission, or that the database name exists.
Check your MySQL root password, or use --force to reinstall
frappe@ubuntu:~/frappe-bench$
Can someone please help?
Thanks!