Hi
anyone kindly help in this
[/details]
Nextcloud version (eg, 19.0.2):
Operating system and version (eg, centos 08):
Apache or nginx version (eg, Apache 2.4.37):
PHP version (eg, 7.4.11):
The issue you are facing:
attendee event or calendar update not update on mail
Is this the first time you’ve seen this error? (Y/N):Y
The output of your Nextcloud log in Admin > Logging:
|Error|mail|Doctrine\DBAL\Exception\NotNullConstraintViolationException : An exception occurred while executing ‘INSERT INTO oc_mail_classifiers (type, training_set_size, validation_set_size, account_id, duration, app_version, estimator, active, created_at) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?)’ with params [“importance”, 900, 100, 6, 0, “1.4.1”, “Rubix\ML\Classifiers\GaussianNB”, false, 1601883221]: SQLSTATE[HY000]: General error: 1364 Field ‘recall_important’ doesn’t have a default value
/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 169:
Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 145:
Doctrine\DBAL\DBALException::wrapException()
/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1063:
Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
/var/www/html/nextcloud/lib/private/DB/Connection.php - line 214:
Doctrine\DBAL\Connection->executeUpdate()
/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 203:
OC\DB\Connection->executeUpdate()
/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 216:
Doctrine\DBAL\Query\QueryBuilder->execute()
/var/www/html/nextcloud/lib/public/AppFramework/Db/QBMapper.php - line 129:
OC\DB\QueryBuilder\QueryBuilder->execute()
/var/www/html/nextcloud/apps/mail/lib/Service/Classification/PersistenceService.php - line 110:
OCP\AppFramework\Db\QBMapper->insert()
/var/www/html/nextcloud/apps/mail/lib/Service/Classification/ImportanceClassifier.php - line 221:
OCA\Mail\Service\Classification\PersistenceService->persist()
/var/www/html/nextcloud/apps/mail/lib/BackgroundJob/TrainImportanceClassifierJob.php - line 80:
OCA\Mail\Service\Classification\ImportanceClassifier->train()
/var/www/html/nextcloud/lib/public/BackgroundJob/Job.php - line 80:
OCA\Mail\BackgroundJob\TrainImportanceClassifierJob->run()
/var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php - line 61:
OCP\BackgroundJob\Job->execute()
/var/www/html/nextcloud/cron.php - line 148:
OCP\BackgroundJob\TimedJob->execute()
Caused by Doctrine\DBAL\Driver\PDOException : SQLSTATE[HY000]: General error: 1364 Field ‘recall_important’ doesn’t have a default value
/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1054:
Doctrine\DBAL\Driver\PDOStatement->execute()
/var/www/html/nextcloud/lib/private/DB/Connection.php - line 214:
Doctrine\DBAL\Connection->executeUpdate()
/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 203:
OC\DB\Connection->executeUpdate()
/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 216:
Doctrine\DBAL\Query\QueryBuilder->execute()
/var/www/html/nextcloud/lib/public/AppFramework/Db/QBMapper.php - line 129:
OC\DB\QueryBuilder\QueryBuilder->execute()
/var/www/html/nextcloud/apps/mail/lib/Service/Classification/PersistenceService.php - line 110:
OCP\AppFramework\Db\QBMapper->insert()
/var/www/html/nextcloud/apps/mail/lib/Service/Classification/ImportanceClassifier.php - line 221:
OCA\Mail\Service\Classification\PersistenceService->persist()
/var/www/html/nextcloud/apps/mail/lib/BackgroundJob/TrainImportanceClassifierJob.php - line 80:
OCA\Mail\Service\Classification\ImportanceClassifier->train()
/var/www/html/nextcloud/lib/public/BackgroundJob/Job.php - line 80:
OCA\Mail\BackgroundJob\TrainImportanceClassifierJob->run()
/var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php - line 61:
OCP\BackgroundJob\Job->execute()
/var/www/html/nextcloud/cron.php - line 148:
OCP\BackgroundJob\TimedJob->execute()
Caused by PDOException : SQLSTATE[HY000]: General error: 1364 Field ‘recall_important’ doesn’t have a default value
/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php - line 117:
PDOStatement->execute()
/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1054:
Doctrine\DBAL\Driver\PDOStatement->execute()
/var/www/html/nextcloud/lib/private/DB/Connection.php - line 214:
Doctrine\DBAL\Connection->executeUpdate()
/var/www/html/nextcloud/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 203:
OC\DB\Connection->executeUpdate()
/var/www/html/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php - line 216:
Doctrine\DBAL\Query\QueryBuilder->execute()
/var/www/html/nextcloud/lib/public/AppFramework/Db/QBMapper.php - line 129:
OC\DB\QueryBuilder\QueryBuilder->execute()
/var/www/html/nextcloud/apps/mail/lib/Service/Classification/PersistenceService.php - line 110:
OCP\AppFramework\Db\QBMapper->insert()
/var/www/html/nextcloud/apps/mail/lib/Service/Classification/ImportanceClassifier.php - line 221:
OCA\Mail\Service\Classification\PersistenceService->persist()
/var/www/html/nextcloud/apps/mail/lib/BackgroundJob/TrainImportanceClassifierJob.php - line 80:
OCA\Mail\Service\Classification\ImportanceClassifier->train()
/var/www/html/nextcloud/lib/public/BackgroundJob/Job.php - line 80:
OCA\Mail\BackgroundJob\TrainImportanceClassifierJob->run()
/var/www/html/nextcloud/lib/public/BackgroundJob/TimedJob.php - line 61:
OCP\BackgroundJob\Job->execute()
/var/www/html/nextcloud/cron.php - line 148:
| OCP\BackgroundJob\TimedJob->execute() |
|---|
The output of your config.php file in `/path/to/nextcloud` (make sure you remove any identifiable information!):
login as: root
root@10.254.253.130’s password:
Activate the web console with: systemctl enable --now cockpit.socket
Last login: Mon Oct 5 11:39:22 2020 from 10.254.253.132
[root@localhost ~]# httpd v
Usage: httpd [-D name] [-d directory] [-f file]
[-C “directive”] [-c “directive”]
[-k start|restart|graceful|graceful-stop|stop]
[-v] [-V] [-h] [-l] [-L] [-t] [-T] [-S] [-X]
Options:
-D name : define a name for use in directives
-d directory : specify an alternate initial ServerRoot
-f file : specify an alternate ServerConfigFile
-C “directive” : process directive before reading config files
-c “directive” : process directive after reading config files
-e level : show startup errors of level (see LogLevel)
-E file : log startup errors to file
-v : show version number
-V : show compile settings
-h : list available command line options (this page)
-l : list compiled in modules
-L : list available configuration directives
-t -D DUMP_VHOSTS : show parsed vhost settings
-t -D DUMP_RUN_CFG : show parsed run settings
-S : a synonym for -t -D DUMP_VHOSTS -D DUMP_RUN_CFG
-t -D DUMP_MODULES : show all loaded modules
-M : a synonym for -t -D DUMP_MODULES
-t -D DUMP_INCLUDES: show all included configuration files
-t : run syntax check for config files
-T : start without DocumentRoot(s) check
-X : debug mode (only one worker, do not detach)
[root@localhost ~]# httpd v
Usage: httpd [-D name] [-d directory] [-f file]
[-C “directive”] [-c “directive”]
[-k start|restart|graceful|graceful-stop|stop]
[-v] [-V] [-h] [-l] [-L] [-t] [-T] [-S] [-X]
Options:
-D name : define a name for use in directives
-d directory : specify an alternate initial ServerRoot
-f file : specify an alternate ServerConfigFile
-C “directive” : process directive before reading config files
-c “directive” : process directive after reading config files
-e level : show startup errors of level (see LogLevel)
-E file : log startup errors to file
-v : show version number
-V : show compile settings
-h : list available command line options (this page)
-l : list compiled in modules
-L : list available configuration directives
-t -D DUMP_VHOSTS : show parsed vhost settings
-t -D DUMP_RUN_CFG : show parsed run settings
-S : a synonym for -t -D DUMP_VHOSTS -D DUMP_RUN_CFG
-t -D DUMP_MODULES : show all loaded modules
-M : a synonym for -t -D DUMP_MODULES
-t -D DUMP_INCLUDES: show all included configuration files
-t : run syntax check for config files
-T : start without DocumentRoot(s) check
-X : debug mode (only one worker, do not detach)
[root@localhost ~]# httpd -v
Server version: Apache/2.4.37 (centos)
Server built: Sep 15 2020 15:41:16
[root@localhost ~]# cd /var/www/html/nextcloud/
[root@localhost nextcloud]# cd config/
[root@localhost config]# vim config.php
[root@localhost config]# cp config.php config.copy.php
[root@localhost config]# vim config.copy.php
[root@localhost config]#
[root@localhost config]# cat config.copy.php