| Summary: | mysql error 1171 in Web installer Step 3 | ||
|---|---|---|---|
| Product: | Koha | Reporter: | g.meyer |
| Component: | Installation and upgrade (web-based installer) | Assignee: | Bugs List <koha-bugs> |
| Status: | RESOLVED DUPLICATE | QA Contact: | Testopia <testopia> |
| Severity: | major | ||
| Priority: | P2 | CC: | flittle, gmcharlt, jonathan.druart |
| Version: | 3.22 | ||
| Hardware: | PC | ||
| OS: | Linux | ||
| See Also: | https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16402 | ||
| Change sponsored?: | --- | Patch complexity: | --- |
| Documentation contact: | Documentation submission: | ||
| Text to go in the release notes: | Version(s) released in: | ||
| Circulation function: | |||
Hi, I have this issue also, trying to install koha on a fresh ubuntu 16.04 install, MySQL 5.7.12. Same message in the web installer: mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1171 (42000) at line 1385: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead Can you continue the web installer after this warning? (In reply to Katrin Fischer from comment #2) > Can you continue the web installer after this warning? Hi, no it will not continue. For me it is exactly the same. Please take a look at bug 16402 for a possible fix! |
Web installer Step 3 displays the following mysql error: "The following error occurred while importing the database structure: mysql: [Warning] Using a password on the command line interface can be insecure. ERROR 1171 (42000) at line 1385: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead " These are the informations from Step 2 "Database settings: database type : mysql database name : koha_library database host : localhost database port : 3306 (probably OK if blank) database user : koha_library Connection established. Database koha_library exists. User koha_library has all required privileges on database koha_library."