Page 1 of 1
zmpkg.pl[2659]: DBD::mysql::st execute failed: Unknown column 'Id' in 'field list' at /usr/bin/zmpkg.pl line 238.
Posted: Sun Apr 08, 2018 3:38 pm
by geraldbrandt
At the latest 1.31.40, and I get this error:
zmpkg.pl[2659]: DBD::mysql::st execute failed: Unknown column 'Id' in 'field list' at /usr/bin/zmpkg.pl line 238.
And Zoneminder won't start.
Ideas?
Gerald
Re: zmpkg.pl[2659]: DBD::mysql::st execute failed: Unknown column 'Id' in 'field list' at /usr/bin/zmpkg.pl line 238.
Posted: Wed Apr 18, 2018 11:51 pm
by geraldbrandt
I'm still getting this error in 1.31.41.
Re: zmpkg.pl[2659]: DBD::mysql::st execute failed: Unknown column 'Id' in 'field list' at /usr/bin/zmpkg.pl line 238.
Posted: Thu Apr 19, 2018 3:52 pm
by rockedge
I dropped the zm database then created a new one and imported the zm_create.sql for 1.31.41 and the error went away. Also encountered it with 1.31.40 and there I removed ZM and then reinstalled 1.30.4 then overwrote it with the 1.31.40 .deb file created a new database and it worked...almost completely. No FPS ever shows in any view which features the fps values amongst other things.
Re: zmpkg.pl[2659]: DBD::mysql::st execute failed: Unknown column 'Id' in 'field list' at /usr/bin/zmpkg.pl line 238.
Posted: Thu Apr 19, 2018 5:53 pm
by geraldbrandt
Hmmm, I'd rather not lose all my events and camera settings. I'll hold out another release or two to see if it gets fixed.
Re: zmpkg.pl[2659]: DBD::mysql::st execute failed: Unknown column 'Id' in 'field list' at /usr/bin/zmpkg.pl line 238.
Posted: Fri Apr 20, 2018 5:34 pm
by rockedge
yes I agree.... these versions are for testing and hammering out the bugs so I am not stressing out
Re: zmpkg.pl[2659]: DBD::mysql::st execute failed: Unknown column 'Id' in 'field list' at /usr/bin/zmpkg.pl line 238.
Posted: Mon Apr 23, 2018 3:41 am
by geraldbrandt
rockedge wrote: ↑Fri Apr 20, 2018 5:34 pm
yes I agree.... these versions are for testing and hammering out the bugs so I am not stressing out
True.