ZoneMinder Forums

Posted: **Sun Jan 10, 2016 9:07 pm**

First of all I will report that 1.29 is working very well on Puppy Linux Tahr 6.0.5 which installed using the Puppy Package Manager after adding the PPA from iconner.

After several initial installs and testing that everything worked. Now after more recent install of 1.29, this mysql error pops up:

Code: Select all

SQL-ERR 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Hostname' in 'field list'', statement was 'INSERT INTO Servers set Name = dummy.server', Hostname = 'dummy.server.net'

I added the missing column "Hostname" and the Adding New Server in options worked again. I just went through all the steps again to install ZM which includes using the guide to install on Ubuntu and the error occurred. And adding the missing column in the server table fixed it.

Posted: **Mon Jan 11, 2016 1:34 am**

Which guide did you use? There are some on the web that are not current. I suggest you check the Zoneminder WIKI for Ubuntu. There are updated preliminary instructions there.

Posted: **Mon Jan 11, 2016 2:23 am**

I used ZM Install on Ubuntu
But this OS being Puppy Linux Tahr 6.0.5 is using Ubuntu binaries, so the install steps are a general guide because there are some slight differences between this Puppy Linux and Ubuntu. It looks like the "Hostname" column is not created in the ZM database when zm_create.sql is initially imported for some reason.

It is the only error I have encountered so so far with 1.29 on this OS

Posted: **Mon Jan 11, 2016 2:52 am**

Thanks for reporting this. It has been fixed.
https://github.com/ZoneMinder/ZoneMinde ... ce1e04f99f

Posted: **Mon Jan 11, 2016 3:08 am**

Excellent. Your welcome.

ZoneMinder Forums

MySQL error appeared.

MySQL error appeared.

Re: MySQL error appeared.

Re: MySQL error appeared.

Re: MySQL error appeared.

Re: MySQL error appeared.