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.
Unable to connect to show.tikiwiki.org. Please let us know of the problem so that we can do something about it. Thanks.
filename | created | hits | comment | version | filetype | ||
---|---|---|---|---|---|---|---|
No attachments for this item |