Installation Experience (Mysql Installation Error ! #1171 - All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead)

[crafter]

@dsuyashrai

Can you please tell the location and name of the file for line 174 for MySQL issue?

[Solved] All parts of a PRIMARY KEY must be NOT NULL on MySQL 5.7+

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 _a1947c…