"Converting filters from PHP to JSON format" failed

Forum for questions and support relating to the 1.25.x releases only.
Post Reply
redxiii
Posts: 48
Joined: Thu Aug 05, 2010 1:47 am

"Converting filters from PHP to JSON format" failed

Post by redxiii » Wed Sep 17, 2014 5:08 pm

upgrading from 1.24 (ubuntu 10.04) to 1.25 (ubuntu 12.04) yields the following errors:

Code: Select all

# dpkg --configure zoneminder
Setting up zoneminder (1.25.0-1) ...
Stopping ZoneMinder: DBD::mysql::st execute failed: Table 'zm.Logs' doesn't exist at /usr/share/perl5/ZoneMinder/Logger.pm line 609.
Zoneminder already stopped


Initiating database upgrade to version 1.25.0 from version 1.24.2

Upgrading database to version 1.25.0
Loading config from DB
Saving config to DB

Database successfully upgraded from version 1.24.2.

Database successfully upgraded from version 1.24.3.

Converting filters from PHP to JSON format
  PurgeWhenFull - failed, please check or report. Query is '{"sort_field":"Id","terms":[{"val":0,"attr":"Archived","op":"="},{"cnj":"and","val":95,"attr":"DiskPercent","op":">="}],"limit":5,"sort_asc":1}'
ERROR: Unknown type {. at /usr/bin/zmupdate.pl line 930
Conversion complete
ERROR 1142 (42000) at line 10: CREATE command denied to user 'zmuser'@'localhost' for table 'Logs'
Output: 
Command 'mysql -hlocalhost -uzmuser -pzmpass zm < /usr/share/zoneminder/db/zm_update-1.24.4.sql' exited with status: 1
dpkg: error processing zoneminder (--configure):
 subprocess installed post-installation script returned error exit status 1
Errors were encountered while processing:
 zoneminder
#

redxiii
Posts: 48
Joined: Thu Aug 05, 2010 1:47 am

Re: "Converting filters from PHP to JSON format" failed

Post by redxiii » Tue Oct 28, 2014 6:31 am

the code below seems to have helped, but i still got these errors:
Stopping ZoneMinder: DBD::mysql::st execute failed: Table 'zm.Logs' doesn't exist at /usr/share/perl5/ZoneMinder/Logger.pm line 609.
and
Converting filters from PHP to JSON format
PurgeWhenFull - failed

but ZM is running now at least and the PurgeWhenFull filter is still there...
are there more things i need to fix?

Code: Select all

$ sudo mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 151
Server version: 5.5.38-0ubuntu0.12.04.1 (Ubuntu)

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use zm
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> show grants for 'zmuser'@'localhost';
+---------------------------------------------------------------------------------------------------------------+
| Grants for zmuser@localhost                                                                                   |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'zmuser'@'localhost' IDENTIFIED BY PASSWORD '*X' |
| GRANT SELECT, INSERT, UPDATE, DELETE, ALTER, LOCK TABLES ON `zm`.* TO 'zmuser'@'localhost'                    |
+---------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> grant create on * to 'zmuser'@'localhost';
Query OK, 0 rows affected (0.00 sec)

mysql> show grants for 'zmuser'@'localhost';
+---------------------------------------------------------------------------------------------------------------+
| Grants for zmuser@localhost                                                                                   |
+---------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'zmuser'@'localhost' IDENTIFIED BY PASSWORD '*X' |
| GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER, LOCK TABLES ON `zm`.* TO 'zmuser'@'localhost'            |
+---------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

mysql> exit
Bye
$ sudo apt-get install zoneminder 
Reading package lists... Done
Building dependency tree       
Reading state information... Done
zoneminder is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 53 not upgraded.
1 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue [Y/n]? 
Setting up zoneminder (1.25.0-1) ...
Stopping ZoneMinder: DBD::mysql::st execute failed: Table 'zm.Logs' doesn't exist at /usr/share/perl5/ZoneMinder/Logger.pm line 609.
Zoneminder already stopped


Initiating database upgrade to version 1.25.0 from version 1.24.2

Upgrading database to version 1.25.0
Loading config from DB
Saving config to DB

Database successfully upgraded from version 1.24.2.

Database successfully upgraded from version 1.24.3.

Converting filters from PHP to JSON format
  PurgeWhenFull - failed, please check or report. Query is '{"sort_field":"Id","terms":[{"val":0,"attr":"Archived","op":"="},{"cnj":"and","val":95,"attr":"DiskPercent","op":">="}],"limit":5,"sort_asc":1}'
ERROR: Unknown type {. at /usr/bin/zmupdate.pl line 930
Conversion complete

Database successfully upgraded from version 1.24.4.

Database upgrade to version 1.25.0 successful.

Starting ZoneMinder: success

$ 

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest