Start a new topic

Installation Error: "Database doesn't match reference schema"

I'm trying to reinstall bc-server after replacing a bad SSD in my server, but I'm getting a SQL schema error on install. I'm not even able to purge the package and try again because then that gives me an error that "Site Bluecherry does not exist" and aborts the uninstall.

Here is the output of apt-get when installing:

valdes@valdesServer:~$ sudo apt-get install bluecherry

Reading package lists... Done

Building dependency tree

Reading state information... Done

The following packages were automatically installed and are no longer required:

snort-rules-default libtcmalloc-minimal0 dbconfig-common suricata

libyaml-0-2 libnetfilter-queue1 libhtp1 libprelude2 libnet1

Use 'apt-get autoremove' to remove them.

Suggested packages:

monit mail-transport-agent

The following NEW packages will be installed:

bluecherry

0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.

Need to get 0 B/1,711 kB of archives.

After this operation, 4,759 kB of additional disk space will be used.

Preconfiguring packages ...

Selecting previously unselected package bluecherry.

(Reading database ... 124757 files and directories currently installed.)

Unpacking bluecherry (from .../bluecherry_1%3a2.2.2-2_amd64.deb) ...

groupadd: group 'bluecherry' already exists

bluecherry: unrecognized service

Processing triggers for ureadahead ...

Setting up bluecherry (1:2.2.2-2) ...

+ . /usr/share/debconf/confmodule

++ '[' '!' '' ']'

++ PERL_DL_NONLAZY=1

++ export PERL_DL_NONLAZY

++ '[' '' ']'

++ exec /usr/share/debconf/frontend /var/lib/dpkg/info/bluecherry.postinst configure ''

+ . /usr/share/debconf/confmodule

++ '[' '!' 1 ']'

++ '[' -z '' ']'

++ exec

++ '[' '' ']'

++ exec

++ DEBCONF_REDIR=1

++ export DEBCONF_REDIR

+ DB_BACKUP_GZ_FILE=/tmp/bc_db.sql.gz

+ case "$1" in

+ ucfr bluecherry /etc/bluecherry.conf

+ chown -R bluecherry:bluecherry /var/lib/bluecherry

+ chmod -R 770 /var/lib/bluecherry

+ chown -R bluecherry:bluecherry /var/run/bluecherry

+ chmod -R 750 /var/run/bluecherry

+ touch /var/log/bluecherry.log

+ id syslog

+ chown syslog:bluecherry /var/log/bluecherry.log

+ chmod 640 /var/log/bluecherry.log

+ a2enmod ssl

Module ssl already enabled

+ a2enmod php5

Module php5 already enabled

+ rm /etc/apache2/sites-enabled/bluecherry /etc/apache2/sites-available/bluecherry

rm: cannot remove `/etc/apache2/sites-enabled/bluecherry': No such file or directory

rm: cannot remove `/etc/apache2/sites-available/bluecherry': No such file or directory

+ true

+ a2ensite bluecherry.conf

Site bluecherry.conf already enabled

+ rm /etc/php5/conf.d/bluecherry.ini

rm: cannot remove `/etc/php5/conf.d/bluecherry.ini': No such file or directory

+ true

++ which service

+ '[' '!' -z /usr/sbin/service ']'

+ service apache2 reload

* Reloading web server config apache2 [ OK ]

+ service rsyslog restart

rsyslog stop/waiting

rsyslog start/running, process 27335

+ '[' '!' -e /var/lib/.bcins ']'

+ '[' -x /sbin/apparmor_parser ']'

+ :

+ trap db_upgrade_err ERR

+ [[ -s /etc/bluecherry.conf ]]

+ db_fset bluecherry/mysql_admin_login seen false

+ _db_cmd 'FSET bluecherry/mysql_admin_login' seen false

+ _db_internal_IFS='

'

+ IFS=' '

+ printf '%s\n' 'FSET bluecherry/mysql_admin_login seen false'

+ IFS='

'

+ IFS='

'

+ read -r _db_internal_line

+ RET=false

+ case ${_db_internal_line%%[ ]*} in

+ return 0

+ db_fset bluecherry/mysql_admin_password seen false

+ _db_cmd 'FSET bluecherry/mysql_admin_password' seen false

+ _db_internal_IFS='

'

+ IFS=' '

+ printf '%s\n' 'FSET bluecherry/mysql_admin_password seen false'

+ IFS='

'

+ IFS='

'

+ read -r _db_internal_line

+ RET=false

+ case ${_db_internal_line%%[ ]*} in

+ return 0

+ db_fset bluecherry/db_name seen false

+ _db_cmd 'FSET bluecherry/db_name' seen false

+ _db_internal_IFS='

'

+ IFS=' '

+ printf '%s\n' 'FSET bluecherry/db_name seen false'

+ IFS='

'

+ IFS='

'

+ read -r _db_internal_line

+ RET=false

+ case ${_db_internal_line%%[ ]*} in

+ return 0

+ db_fset bluecherry/db_user seen false

+ _db_cmd 'FSET bluecherry/db_user' seen false

+ _db_internal_IFS='

'

+ IFS=' '

+ printf '%s\n' 'FSET bluecherry/db_user seen false'

+ IFS='

'

+ IFS='

'

+ read -r _db_internal_line

+ RET=false

+ case ${_db_internal_line%%[ ]*} in

+ return 0

+ db_fset bluecherry/db_password seen false

+ _db_cmd 'FSET bluecherry/db_password' seen false

+ _db_internal_IFS='

'

+ IFS=' '

+ printf '%s\n' 'FSET bluecherry/db_password seen false'

+ IFS='

'

+ IFS='

'

+ read -r _db_internal_line

+ RET=false

+ case ${_db_internal_line%%[ ]*} in

+ return 0

+ db_input high bluecherry/mysql_admin_login

+ _db_cmd 'INPUT high' bluecherry/mysql_admin_login

+ _db_internal_IFS='

'

+ IFS=' '

+ printf '%s\n' 'INPUT high bluecherry/mysql_admin_login'

+ IFS='

'

+ IFS='

'

+ read -r _db_internal_line

+ RET='question will be asked'

+ case ${_db_internal_line%%[ ]*} in

+ return 0

+ db_input high bluecherry/mysql_admin_password

+ _db_cmd 'INPUT high' bluecherry/mysql_admin_password

+ _db_internal_IFS='

'

+ IFS=' '

+ printf '%s\n' 'INPUT high bluecherry/mysql_admin_password'

+ IFS='

'

+ IFS='

'

+ read -r _db_internal_line

+ RET='question will be asked'

+ case ${_db_internal_line%%[ ]*} in

+ return 0

+ db_input high bluecherry/db_name

+ _db_cmd 'INPUT high' bluecherry/db_name

+ _db_internal_IFS='

'

+ IFS=' '

+ printf '%s\n' 'INPUT high bluecherry/db_name'

+ IFS='

'

+ IFS='

'

+ read -r _db_internal_line

+ RET='question will be asked'

+ case ${_db_internal_line%%[ ]*} in

+ return 0

+ db_input high bluecherry/db_user

+ _db_cmd 'INPUT high' bluecherry/db_user

+ _db_internal_IFS='

'

+ IFS=' '

+ printf '%s\n' 'INPUT high bluecherry/db_user'

+ IFS='

'

+ IFS='

'

+ read -r _db_internal_line

+ RET='question will be asked'

+ case ${_db_internal_line%%[ ]*} in

+ return 0

+ db_input high bluecherry/db_password

+ _db_cmd 'INPUT high' bluecherry/db_password

+ _db_internal_IFS='

'

+ IFS=' '

+ printf '%s\n' 'INPUT high bluecherry/db_password'

+ IFS='

'

+ IFS='

'

+ read -r _db_internal_line

+ RET='question will be asked'

+ case ${_db_internal_line%%[ ]*} in

+ return 0

+ db_go

+ _db_cmd 'GO '

+ _db_internal_IFS='

'

+ IFS=' '

+ printf '%s\n' 'GO '

+ IFS='

'

+ IFS='

'

+ read -r _db_internal_line

+ RET=ok

+ case ${_db_internal_line%%[ ]*} in

+ return 0

+ db_get bluecherry/mysql_admin_login

+ _db_cmd 'GET bluecherry/mysql_admin_login'

+ _db_internal_IFS='

'

+ IFS=' '

+ printf '%s\n' 'GET bluecherry/mysql_admin_login'

+ IFS='

'

+ IFS='

'

+ read -r _db_internal_line

+ RET=root

+ case ${_db_internal_line%%[ ]*} in

+ return 0

+ export MYSQL_ADMIN_LOGIN=root

+ MYSQL_ADMIN_LOGIN=root

+ db_get bluecherry/mysql_admin_password

+ _db_cmd 'GET bluecherry/mysql_admin_password'

+ _db_internal_IFS='

'

+ IFS=' '

+ printf '%s\n' 'GET bluecherry/mysql_admin_password'

+ IFS='

'

+ IFS='

'

+ read -r _db_internal_line

+ RET=<<PASSWORD REDACTED>>

+ case ${_db_internal_line%%[ ]*} in

+ return 0

+ export MYSQL_ADMIN_PASSWORD=<<PASSWORD REDACTED>>

+ MYSQL_ADMIN_PASSWORD=<<PASSWORD REDACTED>>

+ db_get bluecherry/db_name

+ _db_cmd 'GET bluecherry/db_name'

+ _db_internal_IFS='

'

+ IFS=' '

+ printf '%s\n' 'GET bluecherry/db_name'

+ IFS='

'

+ IFS='

'

+ read -r _db_internal_line

+ RET=bluecherry

+ case ${_db_internal_line%%[ ]*} in

+ return 0

+ export dbname=bluecherry

+ dbname=bluecherry

+ db_get bluecherry/db_user

+ _db_cmd 'GET bluecherry/db_user'

+ _db_internal_IFS='

'

+ IFS=' '

+ printf '%s\n' 'GET bluecherry/db_user'

+ IFS='

'

+ IFS='

'

+ read -r _db_internal_line

+ RET=bluecherry

+ case ${_db_internal_line%%[ ]*} in

+ return 0

+ export user=bluecherry

+ user=bluecherry

+ db_get bluecherry/db_password

+ _db_cmd 'GET bluecherry/db_password'

+ _db_internal_IFS='

'

+ IFS=' '

+ printf '%s\n' 'GET bluecherry/db_password'

+ IFS='

'

+ IFS='

'

+ read -r _db_internal_line

+ RET=<<PASSWORD REDACTED>>

+ case ${_db_internal_line%%[ ]*} in

+ return 0

+ export password=<<PASSWORD REDACTED>>

+ password=<<PASSWORD REDACTED>>

+ echo 'DROP DATABASE IF EXISTS bluecherry; CREATE DATABASE bluecherry'

+ mysql -uroot -p<<PASSWORD REDACTED>>

+ echo 'GRANT ALL ON bluecherry.* to bluecherry@'\''localhost'\'' IDENTIFIED BY '\''<<PASSWORD REDACTED>>'\'''

+ mysql -uroot -p<<PASSWORD REDACTED>>

+ create_tables_write_version

+ mysql -ubluecherry -p<<PASSWORD REDACTED>> -Dbluecherry

++ cat /usr/share/bluecherry/installed_db_version

+ DB_VERSION=2020000

+ echo 'INSERT INTO GlobalSettings (parameter, value) VALUES ('\''G_DB_VERSION'\'', '\''2020000'\'')'

+ mysql -ubluecherry -p<<PASSWORD REDACTED>> -Dbluecherry

+ mysql -ubluecherry -p<<PASSWORD REDACTED>> -Dbluecherry

+ cat /usr/share/bluecherry/bluecherry.conf.in

+ sed -e s/_DBC_DBNAME_/bluecherry/ -e s/_DBC_DBUSER_/bluecherry/ -e s/_DBC_DBPASS_/<<PASSWORD REDACTED>>/

+ /usr/share/bluecherry/compare.sh

--- /dev/fd/63 2014-07-21 22:05:00.037298762 -0400

+++ /dev/fd/62 2014-07-21 22:05:00.037298762 -0400

@@ -18,7 +18,7 @@

`from_client` tinyint(1) DEFAULT NULL,

`time` int(11) DEFAULT NULL,

`kick` tinyint(1) DEFAULT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `AvailableSources`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -31,7 +31,7 @@

`video_type` varchar(255) NOT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `device` (`device`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `Devices`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -73,7 +73,7 @@

PRIMARY KEY (`id`),

UNIQUE KEY `device_name` (`device_name`),

UNIQUE KEY `device` (`device`,`channel`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `EventComments`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -86,10 +86,8 @@

`comment` varchar(160) DEFAULT NULL,

PRIMARY KEY (`id`),

KEY `event_id` (`event_id`),

- KEY `user_id` (`user_id`),

- CONSTRAINT `EventComments_ibfk_1` FOREIGN KEY (`event_id`) REFERENCES `EventsCam` (`id`) ON DELETE CASCADE,

- CONSTRAINT `EventComments_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `Users` (`id`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+ KEY `user_id` (`user_id`)

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `EventLevels`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -97,7 +95,7 @@

CREATE TABLE `EventLevels` (

`id` varchar(10) NOT NULL,

PRIMARY KEY (`id`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `EventTags`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -110,10 +108,8 @@

`user_id` int(11) DEFAULT NULL,

PRIMARY KEY (`id`),

KEY `event_id` (`event_id`),

- KEY `user_id` (`user_id`),

- CONSTRAINT `EventTags_ibfk_1` FOREIGN KEY (`event_id`) REFERENCES `EventsCam` (`id`) ON DELETE CASCADE,

- CONSTRAINT `EventTags_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `Users` (`id`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+ KEY `user_id` (`user_id`)

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `EventTypesCam`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -121,7 +117,7 @@

CREATE TABLE `EventTypesCam` (

`id` varchar(10) NOT NULL,

PRIMARY KEY (`id`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `EventTypesSys`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -129,7 +125,7 @@

CREATE TABLE `EventTypesSys` (

`id` varchar(10) NOT NULL,

PRIMARY KEY (`id`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `EventsCam`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -148,12 +144,8 @@

KEY `media_id` (`media_id`),

KEY `level_id` (`level_id`),

KEY `device_id` (`device_id`),

- KEY `type_id` (`type_id`),

- CONSTRAINT `EventsCam_ibfk_1` FOREIGN KEY (`media_id`) REFERENCES `Media` (`id`) ON DELETE CASCADE,

- CONSTRAINT `EventsCam_ibfk_2` FOREIGN KEY (`level_id`) REFERENCES `EventLevels` (`id`),

- CONSTRAINT `EventsCam_ibfk_3` FOREIGN KEY (`device_id`) REFERENCES `Devices` (`id`),

- CONSTRAINT `EventsCam_ibfk_4` FOREIGN KEY (`type_id`) REFERENCES `EventTypesCam` (`id`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+ KEY `type_id` (`type_id`)

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `EventsSystem`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -167,10 +159,8 @@

`details` text,

PRIMARY KEY (`id`),

KEY `level_id` (`level_id`),

- KEY `type_id` (`type_id`),

- CONSTRAINT `EventsSystem_ibfk_1` FOREIGN KEY (`level_id`) REFERENCES `EventLevels` (`id`),

- CONSTRAINT `EventsSystem_ibfk_2` FOREIGN KEY (`type_id`) REFERENCES `EventTypesSys` (`id`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+ KEY `type_id` (`type_id`)

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `GlobalSettings`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -179,7 +169,7 @@

`parameter` varchar(60) NOT NULL,

`value` varchar(255) DEFAULT NULL,

PRIMARY KEY (`parameter`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `Licenses`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -189,7 +179,7 @@

`authorization` varchar(64) NOT NULL,

`added` int(11) NOT NULL,

PRIMARY KEY (`license`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `Media`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -203,9 +193,8 @@

`filepath` varchar(1024) NOT NULL,

`archive` tinyint(1) NOT NULL DEFAULT '0',

PRIMARY KEY (`id`),

- KEY `device_id` (`device_id`),

- CONSTRAINT `Media_ibfk_1` FOREIGN KEY (`device_id`) REFERENCES `Devices` (`id`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+ KEY `device_id` (`device_id`)

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `PTZPresets`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -217,9 +206,8 @@

`preset_name` varchar(64) DEFAULT NULL,

PRIMARY KEY (`id`),

UNIQUE KEY `device_id_2` (`device_id`,`preset_id`),

- UNIQUE KEY `device_id` (`device_id`,`preset_name`),

- CONSTRAINT `PTZPresets_ibfk_1` FOREIGN KEY (`device_id`) REFERENCES `Devices` (`id`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+ UNIQUE KEY `device_id` (`device_id`,`preset_name`)

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `ServerStatus`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -228,7 +216,7 @@

`pid` int(11) NOT NULL,

`timestamp` int(11) NOT NULL,

`message` text

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `Storage`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -240,7 +228,7 @@

`min_thresh` decimal(5,2) NOT NULL,

PRIMARY KEY (`priority`),

UNIQUE KEY `path` (`path`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `TagNames`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -249,7 +237,7 @@

`id` int(11) NOT NULL AUTO_INCREMENT,

`name` varchar(10) DEFAULT NULL,

PRIMARY KEY (`id`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `Users`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -272,7 +260,7 @@

`access_ptz_list` varchar(255) DEFAULT '',

`access_schedule` varchar(168) DEFAULT '111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111',

PRIMARY KEY (`id`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `ipCameraDriver`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -284,7 +272,7 @@

`rtsp_port` int(8) DEFAULT NULL,

`mjpeg_port` int(8) DEFAULT NULL,

PRIMARY KEY (`id`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `ipCameras`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -299,7 +287,7 @@

`driver` varchar(32) NOT NULL DEFAULT 'RTSP-GENERIC',

PRIMARY KEY (`id`),

KEY `driver` (`driver`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `ipPtzCommandPresets`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -329,7 +317,7 @@

`custom` tinyint(1) NOT NULL DEFAULT '0',

`port` varchar(5) NOT NULL DEFAULT '80',

PRIMARY KEY (`id`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `notificationSchedules`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -346,7 +334,7 @@

`nlimit` mediumint(8) unsigned NOT NULL DEFAULT '0',

`disabled` tinyint(1) NOT NULL DEFAULT '0',

PRIMARY KEY (`id`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `notificationsSent`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -354,7 +342,7 @@

CREATE TABLE `notificationsSent` (

`rule_id` smallint(5) unsigned NOT NULL,

`time` int(11) NOT NULL

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

DROP TABLE IF EXISTS `userLayouts`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

@@ -365,7 +353,7 @@

`layout_name` varchar(50) DEFAULT NULL,

`layout` varchar(255) DEFAULT NULL,

PRIMARY KEY (`id`)

-) ENGINE=InnoDB DEFAULT CHARSET=utf8;

+) ENGINE=MyISAM DEFAULT CHARSET=utf8;

/*!40101 SET character_set_client = @saved_cs_client */;

/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

Database doesn't match reference schema

++ db_upgrade_err

++ trap - ERR

++ echo 'An error occurred while migrating your database to the latest version. Please contact Bluecherry support here: https://bluecherry.zendesk.com/anonymous_requests/new . Provide full uncut output from console (the above text).'

An error occurred while migrating your database to the latest version. Please contact Bluecherry support here: https://bluecherry.zendesk.com/anonymous_requests/new . Provide full uncut output from console (the above text).

++ [[ -e /tmp/bc_db.sql.gz ]]

+++ which service

++ '[' '!' -z /usr/sbin/service ']'

++ service apache2 start

* Starting web server apache2 httpd (pid 3258) already running

[ OK ]

++ exit 1

dpkg: error processing bluecherry (--configure):

subprocess installed post-installation script returned error exit status 1

Errors were encountered while processing:

bluecherry

E: Sub-process /usr/bin/dpkg returned an error code (1)

Login or Signup to post a comment