Page 1 of 1
When I run zm_create.sql -- "ERROR 1005 (HY000) at line 29: Can't create table 'zm.Config' (errno: -1)"
Posted: Sun Jun 19, 2016 6:34 pm
by eatkeylimepie
My sql logs are not giving me much feedback for what is going wrong here, any suggestions?
Re: When I run zm_create.sql -- "ERROR 1005 (HY000) at line 29: Can't create table 'zm.Config' (errno: -1)"
Posted: Sun Jun 19, 2016 7:52 pm
by bbunge
Linux and MySQL versions please...
Re: When I run zm_create.sql -- "ERROR 1005 (HY000) at line 29: Can't create table 'zm.Config' (errno: -1)"
Posted: Mon Jun 20, 2016 1:11 pm
by SteveGilvarry
Did you run it with an account with permissions to create tables? Check your readme for distro probably has some instructions to run it as -u root.
Re: When I run zm_create.sql -- "ERROR 1005 (HY000) at line 29: Can't create table 'zm.Config' (errno: -1)"
Posted: Mon Jun 20, 2016 4:00 pm
by eatkeylimepie
Yes, I am trying to run it with elevated permissions, this is the command I am using, it prompts for a password and the password is valid.
mysql -u root -p < /usr/share/zoneminder/db/zm_create.sql
I am on Ubuntu 14.04.4.
mysql Ver 14.14 Distrib 5.5.49, for debian-linux-gnu (x86_64) using readline 6.3
Thanks for the help!
Re: When I run zm_create.sql -- "ERROR 1005 (HY000) at line 29: Can't create table 'zm.Config' (errno: -1)"
Posted: Thu Jun 23, 2016 3:09 pm
by bbunge
Well, it looks like your command is correct. You may want to try again using these instructions:
https://wiki.zoneminder.com/Ubuntu_Serv ... e_easy_way
Might be best to reinstall Ubuntu and while you are at it use 16.04 with instructions for ZM here:
https://wiki.zoneminder.com/Ubuntu_Serv ... e_easy_way
Re: When I run zm_create.sql -- "ERROR 1005 (HY000) at line 29: Can't create table 'zm.Config' (errno: -1)"
Posted: Thu Jun 23, 2016 3:58 pm
by knight-of-ni
Googling reveals "can't create table errno: -1" is caused by corrupt sql tables. The corruption is such that you can just drop the table and recreate it, and you can't write over it... catch 22. The simplest approach may be to just apt-get purge mysql, manually go in and delete any leftover datbase files, and reinstall mysql, and create a new zoneminder database.