zmpkg.pl[2659]: DBD::mysql::st execute failed: Unknown column 'Id' in 'field list' at /usr/bin/zmpkg.pl line 238.

Forum for questions and support relating to the 1.31.x releases only.
Locked
geraldbrandt
Posts: 129
Joined: Tue Dec 09, 2014 10:20 pm

zmpkg.pl[2659]: DBD::mysql::st execute failed: Unknown column 'Id' in 'field list' at /usr/bin/zmpkg.pl line 238.

Post 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
geraldbrandt
Posts: 129
Joined: Tue Dec 09, 2014 10:20 pm

Re: zmpkg.pl[2659]: DBD::mysql::st execute failed: Unknown column 'Id' in 'field list' at /usr/bin/zmpkg.pl line 238.

Post by geraldbrandt »

I'm still getting this error in 1.31.41.
rockedge
Posts: 1173
Joined: Fri Apr 04, 2014 1:46 pm
Location: Connecticut,USA

Re: zmpkg.pl[2659]: DBD::mysql::st execute failed: Unknown column 'Id' in 'field list' at /usr/bin/zmpkg.pl line 238.

Post 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.
geraldbrandt
Posts: 129
Joined: Tue Dec 09, 2014 10:20 pm

Re: zmpkg.pl[2659]: DBD::mysql::st execute failed: Unknown column 'Id' in 'field list' at /usr/bin/zmpkg.pl line 238.

Post 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.
rockedge
Posts: 1173
Joined: Fri Apr 04, 2014 1:46 pm
Location: Connecticut,USA

Re: zmpkg.pl[2659]: DBD::mysql::st execute failed: Unknown column 'Id' in 'field list' at /usr/bin/zmpkg.pl line 238.

Post by rockedge »

yes I agree.... these versions are for testing and hammering out the bugs so I am not stressing out :D
geraldbrandt
Posts: 129
Joined: Tue Dec 09, 2014 10:20 pm

Re: zmpkg.pl[2659]: DBD::mysql::st execute failed: Unknown column 'Id' in 'field list' at /usr/bin/zmpkg.pl line 238.

Post 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 :D
True.
Locked