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
- 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 clipboardSystem 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 clipboardThe 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+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- 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