Sql error while updating scheduled jobs schedule

Permalink 0 0 Browser Info Environment
Hello,

I noticed that an sql error is returned when i try to update the scheduledjobs plan.

An exception occurred while executing 'UPDATE JobSets SET isScheduled = ?, scheduledInterval = ?, scheduledValue = ? WHERE jsID = ?' with params [false, "days", "0", "2"]: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'isScheduled' at row 1


Stacktrace:


Doctrine\DBAL\Exception\DriverException
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php115
30
Doctrine\DBAL\Driver\AbstractMySQLDriver convertException
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php128
29
Doctrine\DBAL\DBALException driverExceptionDuringQuery
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php855
28
Doctrine\DBAL\Driver\PDOException
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php107
27
PDOException
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php105
26
PDOStatement execute
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php105
25
Doctrine\DBAL\Driver\PDOStatement execute
…/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php849
24
Doctrine\DBAL\Connection executeQuery
…/src/Database/Connection/Connection.php70
23
Concrete\Core\Database\Connection\Connection query
…/src/Job/Set.php248
22
Concrete\Core\Job\Set setSchedule
…/controllers/single_page/dashboard/system/optimization/jobs.php257
21
Concrete\Controller\SinglePage\Dashboard\System\Optimization\Jobs update_set_schedule
…/src/Controller/AbstractController.php294
20
call_user_func_array
…/src/Controller/AbstractController.php294
19
Concrete\Core\Controller\AbstractController runAction
…/src/Http/ResponseFactory.php182
18
Concrete\Core\Http\ResponseFactory controller
…/src/Http/ResponseFactory.php369
17
Concrete\Core\Http\ResponseFactory collection
…/src/Routing/DispatcherRouteCallback.php34
16
Concrete\Core\Routing\DispatcherRouteCallback execute
…/src/Http/DefaultDispatcher.php122
15
Concrete\Core\Http\DefaultDispatcher handleDispatch
…/src/Http/DefaultDispatcher.php54
14
Concrete\Core\Http\DefaultDispatcher dispatch
…/src/Http/Middleware/DispatcherDelegate.php39
13
Concrete\Core\Http\Middleware\DispatcherDelegate next
…/src/Http/Middleware/ThumbnailMiddleware.php71
12
Concrete\Core\Http\Middleware\ThumbnailMiddleware process
…/src/Http/Middleware/MiddlewareDelegate.php38
11
Concrete\Core\Http\Middleware\MiddlewareDelegate next
…/src/Http/Middleware/FrameOptionsMiddleware.php39
10
Concrete\Core\Http\Middleware\FrameOptionsMiddleware process
…/src/Http/Middleware/MiddlewareDelegate.php38
9
Concrete\Core\Http\Middleware\MiddlewareDelegate next
…/src/Http/Middleware/CookieMiddleware.php37
8
Concrete\Core\Http\Middleware\CookieMiddleware process
…/src/Http/Middleware/MiddlewareDelegate.php38
7
Concrete\Core\Http\Middleware\MiddlewareDelegate next
…/src/Http/Middleware/ApplicationMiddleware.php29
6
Concrete\Core\Http\Middleware\ApplicationMiddleware process
…/src/Http/Middleware/MiddlewareDelegate.php38
5
Concrete\Core\Http\Middleware\MiddlewareDelegate next
…/src/Http/Middleware/MiddlewareStack.php86
4
Concrete\Core\Http\Middleware\MiddlewareStack process
…/src/Http/DefaultServer.php85
3
Concrete\Core\Http\DefaultServer handleRequest
…/src/Foundation/Runtime/Run/DefaultRunner.php115
2
Concrete\Core\Foundation\Runtime\Run\DefaultRunner run
…/src/Foundation/Runtime/DefaultRuntime.php102
1
Concrete\Core\Foundation\Runtime\DefaultRuntime run
…/dispatcher.php36
0

Thanks Ron Vermeeren


Status: New

concrete5 Environment Information

# concrete5 Version
Core Version - 8.3.2
Version Installed - 8.3.2
Database Version - 20180122213656

# concrete5 Packages
Zuiderlicht MET ggz (1.0), Zuiderlicht Utilities (2.5.7)

# concrete5 Overrides
blocks/content/templates/homepage_banner_groen.php, blocks/content/templates/homepage.php, blocks/content/templates/homepage_banner_oranje.php, blocks/content/templates/homepage_banner_paars.php, blocks/content/templates/linkblokjes.php, blocks/content/templates, blocks/content/view.php, blocks/content, blocks/tags/view.css, blocks/tags/view.php, blocks/tags, blocks/share_this_page/view.php, blocks/share_this_page, blocks/next_previous/view.php, blocks/next_previous, blocks/youtube/view.php, blocks/youtube, blocks/autonav/templates/mobilemenu/view.php, blocks/autonav/templates/mobilemenu, blocks/autonav/templates/breadcrumb.php, blocks/autonav/templates/hoofdmenu/view.php, blocks/autonav/templates/hoofdmenu, blocks/autonav/templates/secundairmenu/view.php, blocks/autonav/templates/secundairmenu, blocks/autonav/templates/submenurechts/view.php, blocks/autonav/templates/submenurechts, blocks/autonav/templates/submenuboven/view.php, blocks/autonav/templates/submenuboven, blocks/autonav/templates/uitklapmenu/view.php, blocks/autonav/templates/uitklapmenu, blocks/autonav/templates, blocks/autonav, blocks/page_list/templates/footerlinklijst/view.php, blocks/page_list/templates/footerlinklijst, blocks/page_list/templates/metnieuwscompact/view.php, blocks/page_list/templates/metnieuwscompact, blocks/page_list/templates/metnieuws_v2/view.php, blocks/page_list/templates/metnieuws_v2, blocks/page_list/templates/metagenda/view.php, blocks/page_list/templates/metagenda, blocks/page_list/templates/abclijst/view.php, blocks/page_list/templates/abclijst, blocks/page_list/templates/metnieuws/view.php, blocks/page_list/templates/metnieuws, blocks/page_list/templates, blocks/page_list/controller.php, blocks/page_list/view.php, blocks/page_list, blocks/image/view.php, blocks/image, controllers/single_page/download_file.php, controllers/single_page, elements/custom_style.php, jobs/clear_empty_workflow_progress.php, single_pages/page_not_found.php, themes/ztheme/less/fonts.less, themes/ztheme/less/mixins.less, themes/ztheme/less/icons.less, themes/ztheme/less/bootstrap.less, themes/ztheme/less/includes.less, themes/ztheme/less/reset.less, themes/ztheme/less/framework.less, themes/ztheme/less, themes/ztheme/default.php, themes/ztheme/description.txt, themes/ztheme/elements/footer.php, themes/ztheme/elements/socialmediameta.php, themes/ztheme/elements/header.php, themes/ztheme/elements, themes/ztheme/js/main.js, themes/ztheme/js/main.min.js, themes/ztheme/js, themes/ztheme/thumbnail.png, themes/ztheme/page.php, themes/ztheme/page_theme.php, themes/ztheme/css/theme.less, themes/ztheme/css/presets/defaults.less, themes/ztheme/css/presets, themes/ztheme/css/styles.xml, themes/ztheme/css/framework.css, themes/ztheme/css/theme.css, themes/ztheme/css, themes/ztheme

# concrete5 Cache Settings
Block Cache - On
Overrides Cache - On
Full Page Caching - Off
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache/2.4.18 (Ubuntu)

# Server API
apache2handler

# PHP Version
7.0.22-0ubuntu0.16.04.1

# PHP Extensions
apache2handler, apcu, calendar, Core, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, intl, json, libxml, mbstring, mcrypt, mysqli, mysqlnd, openssl, pcre, PDO, pdo_mysql, Phar, posix, readline, Reflection, session, shmop, SimpleXML, sockets, SPL, standard, sysvmsg, sysvsem, sysvshm, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, Zend OPcache, zip, zlib

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 128M
post_max_size - 50M
sql.safe_mode - Off
upload_max_filesize - 50M
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200
opcache.max_accelerated_files - 2000
opcache.max_file_size - 0
opcache.max_wasted_percentage - 5

Browser User-Agent String

Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36