Loading...
 
Skip to main content

System error when attempting to enable blog comments on a blog created by a profile

Status
Open
Subject
System error when attempting to enable blog comments on a blog created by a profile
Version
17.x
18.x
Category
  • Conflict of two features (each works well independently)
  • Error
Feature
Blog
Comment
Installer (profiles, upgrades and server-related issues)
Resolution status
New
Submitted by
Xavier de Pedro
Lastmod by
Xavier de Pedro
Rating
(0)
Description

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:

Copy to clipboard
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:

Copy to clipboard
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)

Importance
7
Easy to solve?
4
Priority
28
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
6421
Created
Saturday 05 August, 2017 21:54:20 UTC
by Xavier de Pedro
LastModif
Saturday 05 August, 2017 22:10:59 UTC


Show PHP error messages