I applied profile GeoCMS_Maps
Then whent to the blog created by the profile, edited it, and attempted to enable the comments on that blog, which triggered this error:
System error. The following error message was returned: Incorrect integer value: '' for column 'related_max' at row 1 The query was: update `tiki_blogs` set `title`=? ,`description`=?,`user`=?,`public`=?,`lastModif`=?,`maxPosts`=?,`heading`=?,`use_title`=?,`use_title_in_post`=?,`use_description`=?,`use_breadcrumbs`=?,`use_author`=?,`add_date`=?,`use_find`=?,`allow_comments`=?,`show_avatar`=?,`always_owner`=?, `post_heading`=?, `show_related`=?, `related_max`=?, `use_excerpt`=? where `blogId`=? Values: My Personal GeoBlog Random daily thoughts and travel stories admin n 1501966273 10 Never a dull moment! n n y y n n n y n n {* $Id: blog_post_heading.tpl 58008 2016-03-19 22:26:34Z lindonb $ *} {if $blog_data.use_title_in_post eq 'y'} {capture name="blog_actions"}{include file='blog_actions.tpl'}{/capture} {title url={$blogId|sefurl:blog} actions="{$smarty.capture.blog_actions}"}{$blog_data.title}{/title} {/if} {if $blog_data.use_breadcrumbs eq 'y'} <div class="breadcrumb"><a class="link" href="tiki-list_blogs.php">{tr}Blogs{/tr}</a> {$prefs.site_crumb_seper} <a class="link" href="tiki-view_blog.php?blogId={$post_info.blogId}">{$blog_data.title|escape}</a> {$prefs.site_crumb_seper} {$post_info.title|escape}</div> {/if} {* below is example code. In case you desire to add more info to the default blog heading * remove the line above (starting curly bracket then asterisk) and the last line to enable <div class="bloginfo"> {tr}Created by{/tr} {$post_info.user|userlink} {$post_info.created|tiki_short_datetime:on}<br> {tr}Last post{/tr} {$post_info.lastModif|tiki_short_datetime}<br> </div> *} n n 1 The built query was likely: update `tiki_blogs` set `title`='My Personal GeoBlog' ,`description`='Random daily thoughts and travel stories',`user`='admin',`public`='n',`lastModif`='1501966273',`maxPosts`='10',`heading`='Never a dull moment!',`use_title`='n',`use_title_in_post`='n',`use_description`='y',`use_breadcrumbs`='y',`use_author`='n',`add_date`='n',`use_find`='n',`allow_comments`='y',`show_avatar`='n',`always_owner`='n', `post_heading`='{* $Id: blog_post_heading.tpl 58008 2016-03-19 22:26:34Z lindonb $ *} {if $blog_data.use_title_in_post eq \'y\'} {capture name=\"blog_actions\"}{include file=\'blog_actions.tpl\'}{/capture} {title url={$blogId|sefurl:blog} actions=\"{$smarty.capture.blog_actions}\"}{$blog_data.title}{/title} {/if} {if $blog_data.use_breadcrumbs eq \'y\'} <div class=\"breadcrumb\"><a class=\"link\" href=\"tiki-list_blogs.php\">{tr}Blogs{/tr}</a> {$prefs.site_crumb_seper} <a class=\"link\" href=\"tiki-view_blog.php'n'blogId={$post_info.blogId}\">{$blog_data.title|escape}</a> {$prefs.site_crumb_seper} {$post_info.title|escape}</div> {/if} {* below is example code. In case you desire to add more info to the default blog heading * remove the line above (starting curly bracket then asterisk) and the last line to enable <div class=\"bloginfo\"> {tr}Created by{/tr} {$post_info.user|userlink} {$post_info.created|tiki_short_datetime:on}<br> {tr}Last post{/tr} {$post_info.lastModif|tiki_short_datetime}<br> </div> *} ', `show_related`='', `related_max`='n', `use_excerpt`='1' where `blogId`=? Stacktrace: * /var/www/html/17.x/tiki-edit_blog.php : 0 -> {main}(array ( )) * /var/www/html/17.x/tiki-edit_blog.php : 155 -> replace_blog(array ( )) * /var/www/html/17.x/lib/blogs/bloglib.php : 481 -> query(array ( )) * /var/www/html/17.x/lib/core/TikiDb/Bridge.php : 27 -> query(array ( )) * /var/www/html/17.x/lib/core/TikiDb/Pdo.php : 120 -> handleQueryError(array ( )) * /var/www/html/17.x/lib/core/TikiDb.php : 162 -> handle(array ( ))
Unable to reproduce in the show.t.o instance linked to this bug report, but only reproduced at home, which uses Mysql 5.7 (Ubuntu 16.04.x GNU/Linux which comes with Mysql 5.7)
In case it matters, I enabled also this bunch of comment-related features:
The following changes have been applied Preference feature wiki comments enabled (Preference name: feature_wiki_comments) Preference feature inline comments enabled (Preference name: feature_inline_comments) Preference feature article comments enabled (Preference name: feature_article_comments) Preference comments vote enabled (Preference name: comments_vote) Preference feature image galleries comments enabled (Preference name: feature_image_galleries_comments) Preference tracker show comments below enabled (Preference name: tracker_show_comments_below) Preference feature poll comments enabled (Preference name: feature_poll_comments) Preference comments archive enabled (Preference name: comments_archive) Preference feature file galleries comments enabled (Preference name: feature_file_galleries_comments) Preference wiki comments simple ratings enabled (Preference name: wiki_comments_simple_ratings) Preference wikiplugininline trackercomments enabled (Preference name: wikiplugininline_trackercomments) Preference wiki comments displayed default enabled (Preference name: wiki_comments_displayed_default) Preference wiki comments form displayed default enabled (Preference name: wiki_comments_form_displayed_default)
To help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.
filename | created | hits | comment | version | filetype | ||
---|---|---|---|---|---|---|---|
No attachments for this item |