Try ERPNext Buy Support Partners Foundation Foundation Members

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)

Hi,
After some series of struggle with the conventions and package versions, I was finally able to complete the setup.

Meanwhile, I felt putting forward some immediate concerns as discussion with everyone.

  • Password Validation control
    case : our mysql installation wasn’t allowing MEDIUM strength validation. I had to alter the whole server configuration to pass through the installation.
    suggestion: a variable to allow password generator to generate random passwords with the required strength value

  • collation
    case : our server had a different connection collation / charset
    suggestion: allowing to pass the connection collation during the setup

  • Mysql Installation Error !! #1171 - All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
    case : mysql version 5.7+ doesn’t allow NULL values for primary keys
    I had to update the SQL line 174 to pass through.

Were you able to resolve this issue?

Hi,

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

Thanks!