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.
The URL for the show.tikiwiki.org instance that demonstrates this bug is at: http://xavi-9794-6421.show.tikiwiki.org. Note that if you get a popup asking for a username/password, please just enter "show" and "show". This is different from the initial login and password for a new Tiki which is "admin" and "admin".
For the install log, see http://xavi-9794-6421.show.tikiwiki.org/info.txt
Note that if you see PHP errors or a Tiki claiming to be missing third party software, the instance creation is probably not finished. Please wait a couple minutes and reload.
Snapshots are database dumps of the configuration that developers can download for debugging. Once you have reproduced your bug on the show.tikiwiki.org instance, create a snapshot that can then be downloaded by developers for further investigation.
Snapshots can be accessed at: http://xavi-9794-6421.show.tikiwiki.org/snapshots/. Note that if you get a popup asking for a username/password, please just enter "show" and "show".
Create new snapshotfilename | created | hits | comment | version | filetype | ||
---|---|---|---|---|---|---|---|
No attachments for this item |