ZoneMinder Forums

Posted: **Tue Nov 07, 2017 1:40 pm**

HI all,

I working a long time with the 1.31.1 version without any issue. Today I do the update to 1.31.12 based on the repository of iconnor.

I started with an new DB (mysql) and create again my monitors. After doing that with the first i get the follow SQL error

Code: Select all

SQL-ERR dbFetchOne no result, statement was 'select count(if(1 and ( E.MonitorId = '2' ),1,NULL)) as EventCount0, count(if(1 and ( and E.MonitorId = '2' ),1,NULL)) as EventCount1, count(if(1 and ( and E.MonitorId = '2' ),1,NULL)) as EventCount2, count(if(1 and ( and E.MonitorId = '2' ),1,NULL)) as EventCount3, count(if(1 and ( and E.MonitorId = '2' ),1,NULL)) as EventCount4, count(if(1 and ( and E.MonitorId = '2' ),1,NULL)) as EventCount5 from Events as E where MonitorId = ?'params: 2

Any idea how to solve?

By the way I checked the mysql mode setting to "sql_mode = NO_ENGINE_SUBSTITUTION"

Thanks

Posted: **Tue Nov 07, 2017 4:21 pm**

I'm not sure there is any real problem there, except that it expected there to be data and there wasn't. Once there are events in the db, it will probably stop complaining.

Posted: **Wed Nov 08, 2017 9:11 am**

I do a new installation without existing DB. No problem.
After creation of one Monitor the issue started and will not solved after some minutes.

Did i need to create a new db? How can i do? Can you teach me?

Posted: **Wed Nov 08, 2017 4:14 pm**

You have a mix of old and new. Your install is confused. You are somehow using console.php from 1.31.1 with the other files from 1.31.12

Try resetting your skin by adding ?zmSkin=classic to the url

ZoneMinder Forums

SQL Error after add Monitor starting after Update to 1.31.12

SQL Error after add Monitor starting after Update to 1.31.12

Re: SQL Error after add Monitor starting after Update to 1.31.12

Re: SQL Error after add Monitor starting after Update to 1.31.12

Re: SQL Error after add Monitor starting after Update to 1.31.12