Category: Error

I see we have now a "Suggestion box" in Tiki22.

While this is nice I couldn’t find any information at dev or doc about this addition based on "a list of rules" ?
I found a checkbox in feature to disable it.

#While I have no idea what/where it should go, I wonder if this is really a Tiki feature.

Survey stats are allways 100 % for all values.

My Ver. 1.9.4

Thanks

A text entry to a survey question is not registered correctly if the same entry has already been registered to some other question. For example, if there is a survey on ID 1 with a text question and someone has answered "foobar" to that question and then another person takes survey on ID 2 and answers "foobar" to a text question in that survey no entry is registered. The problem can be replicated most easily but creating a survey with multiple text questions and answering for example "test" to all those questions. Only the first "text" is registered and the rest omitted.

At https://tiki.org/tiki-admin_survey_questions.php?surveyId=8 over 25 questions the pagination turn on. Moving from page to page doesn’t help, you can see questions after the first page.

No idea whether this is also happening in 12.x or earlier. I just noticed this in trunk, while reviewing the improvements to Surveys in order to update the documentation page ((doc:Tiki13))

I created a survey as admin, added 3 questions (one of them is a rating from 1 to 10 with radio buttons). I provided 2 answers as user admin, and I saw that no vote count nor average was shown from the rating scale 1...10

{img fileId="770" thumb="y" rel="box[g]"}

I am often getting:

[i18nwiki@alpha ~]$ cd www
[i18nwiki@alpha www]$ svn up
svn: Working copy 'temp/cache' is missing or not locked
[i18nwiki@alpha www]$


This is caused by something that is destroying some svn system files (presumably trying to clean the cache)

Workaround is to destroy temp and to do svn up

{syntax type="tiki" editor="plain"}
When switching from normal (wiki) editor to WYSIWYG editor everything works fine. But when switching back from WYSIWYG to normal (wiki) editor, this actions simply times out, and IE or Opera are timing out.

This problem appears in 4.0 which was working fine in the 3.x version.

Installer allows to set language for the tiki site admin in the first screen of tiki-install.php. This used to work for years. I tested in 20.x and 21.x and it doesn't change lang of the interface. Tested with Catalan and Spanish, in case it matters. No change, installer continues in step 2 in English.

on 1.9.cvs
See it in here: http://www.moviments.net/valldelcorb
Try changing language as anonymous from default (catalan) to Spanish, for instance. a blank page is shown.

If you do the same as registered, the interface is changed to Spanish, as expected, and as it happenened always with previous versions of Tiki.
(That happened with empty wiki homepage).

-----

However, I tried today (homepage had some articles through article plugin) as registered (user with admin rights), from this page:
http://www.moviments.net/valldelcorb/tiki-index.php

and I got:
^Warning: preg_replace() [function.preg-replace]: Unknown modifier 'd' in /home/httpd/tiki19/tiki-switch_lang.php on line 47

Warning: Cannot modify header information - headers already sent by (output started at /home/httpd/tiki19/tiki-switch_lang.php:47) in /home/httpd/tiki19/tiki-switch_lang.php on line 70
^
plus a blank page.

???

Hello,

I enabled the option "Detect browser language" in the internationalization module and added the switch_lang module.
But if I'm not logged in and want the change the language using switch_lang it __always__ falls back to my default language.

You can try it at http://series60-remote.sf.net
I had the same problem on http://www.opensourcecms.com/cms/tiki/

Doing edits in the WYSIWYG editor & switching to 'normal' loses the edits. The remaining content is presented as HTML source. Workaround: turn off option to use either 'normal' or WYSIWYG editor?

Revisions 63507 and its backports 63508 and 63509 broke language selection at step 1 of the installer. Selecting a language other than English causes a JavaScript error.

The only released version affected is Tiki 16.3.

This bug does not prevent changing the site language, only doing so from the installer.

Synchronize a Tiki Forum with a (Mailman) Mailinglist

a) Forum outbound email (Regression)
In Tiki 11 it was observed that Tiki cannot send emails out from a forum post to a mailinglist. This problem might be produced by Zend/composer. This is a regression. It works in Tiki9.5 (not clear about Tiki10). More Info:
https://dev.tiki.org/Regressions+in+11x
https://tiki.org/tiki-view_forum_thread.php?comments_parentId=47927

b) Forum inbound email (Error)
In Tiki 9.5 it was observed that postings from a mailinglist are shown in Forum with wrong author sometimes. Users of Forum and Mailinglist are not necessarily identical. Some users are registered at forum and mailinglist, and they are recognized by Tiki via email address correctly. Every now and then (no clear pattern yet) an inbound email from mailinglist is registered in the forum with wrong username and wrong email, apparently random chosen by someone else who wrote earlier to the list and was listed in the forum with his post.
In addition Tiki Forum breaks threading if the email topic is changed. This might be intentional and due to lack of internal handling of emails' Message-Id header.

c) Tiki Forum header (Wishlist)
Tiki recognizes whether an inbound email was sent by forum or not. This is done by a header. This header should be up to configuration, because it is not possible to connect two different Tiki forums with one mailinglist.

d) Demo and Showcase
Unfortunately it is not possible to construct a showcase easily, because the setup of Tiki plus Mailman is quite complex (spam protection would require an isolated setup which cannot spam real world) and the pattern seems to be dependent on race conditions.

Using latest 1.9.cvs (from 13th june 2007), and simple.css and tpl's.

Maybe related to these other bug reports by me a momoent ago with Calendars:
[http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=1136&show=view&offset=0&reloff=2&status=op&trackerId=5&sort_mode=created_desc|bug 1]
[http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=1138&show=view&offset=0&reloff=0&status=op&trackerId=5&sort_mode=created_desc|bug 2]

I attempted to create a simple event at this newly created calendar ("Comisión Web", see previous bug reports). I get a red message saying ~~red:Syntax error~~ (in Spanish, due to lang interface in Spanish).

See screenshot attached (if I can), after posting this bug report.
That's the text I introduced:
{CODE()}
Prueba de item: retocar estilo de tema de la web (a partir de simple.css)
{CODE}
-----
Update: when using tikineat.css and tpl's, or smartiki.css and tpl's, for instance, everything works fine, as expected.

Note: in the editor the highlighter for "java" is called "jade", but neither "java" nor "jade" work in the example:

{CODE(java)}
class Foobar {
static {
System.out.println("foobar.<cinit>");
}
public final static String FOO_COMPILE_ZEIT_KONSTANTE = "foo";
public final static String FOO_LAUFZEIT_KONSTANTE = new String("foo");
public final static int BAR_COMPILE_ZEIT_KONSTANTE = 42;
public final static int BAR_LAUFZEIT_KONSTANTE = new Integer(42).intValue();
}

​public class KonstantenTest {
public static void main(String... _) throws Exception {
System.out.println("Foobar.FOO_COMPILE_ZEIT_KONSTANTE = '"
+ Foobar.FOO_COMPILE_ZEIT_KONSTANTE);
System.out.println("Foobar.BAR_COMPILE_ZEIT_KONSTANTE = '"
+ Foobar.BAR_COMPILE_ZEIT_KONSTANTE);
System.out.println("Foobar.FOO_LAUFZEIT_KONSTANTE = '" + Foobar.FOO_LAUFZEIT_KONSTANTE);
System.out.println("Foobar.BAR_LAUFZEIT_KONSTANTE = '" + Foobar.BAR_LAUFZEIT_KONSTANTE);
}
}
{CODE}

Syntax that should work inside a description term (the x in ";x:y") don't. This includes anything in a ':' in it even if it's nested within another syntax structure like a link or table. In a link, it's especially bad, since you can't use ~np~~np~~/np~ to fix it, e.g. you can't fix ~np~((a:b))~/np~. Also, ~np~~~color:x~~~/np~ doesn't work.

~pp~
!!!~np~;a:text~/np~
;a:text
works
%%%%%%%%%%%%
!!!~np~;~~red:a~~:text~/np~
;~~red:a~~:text
looks like ~np~;a:text~/np~
%%%%%%%%%%%%
!!!~np~;((a)):text~/np~
;((a)):text
works
%%%%%%%%%%%%
!!!~np~;((a:b)):text~/np~
;((a:b)):text
looks like ~np~;a:((a:b|b)):text~/np~
%%%%%%%%%%%%
!!!~np~;((a|b:c)):text~/np~
;((a|b:c)):text
looks like ~np~;b:((a|c)):text~/np~
%%%%%%%%%%%%
!!!~np~;((a|~np~b:c~/np~~/np~~np~)):text~/np~
;((a|~np~b:c~/np~)):text
works
%%%%%%%%%%%%
!!!~np~;__a__:text~/np~
;__a__:text
works
%%%%%%%%%%%%
!!!~np~;||a||:text~/np~
;||a||:text
works
%%%%%%%%%%%%
!!!~np~;||a:b||:text~/np~
;||a:b||:text
this just looks strange
~/pp~

I looked in the parser code, and it's pretty obvious why these bugs occur. The parser code, to put it bluntly, sucks. It uses regexps for most parsing instead of a proper context-free parser, so it's bound to have these types of bugs.

{syntax type="tiki" editor="plain"}
Admin->Modules->
Assign New Module, select calendar from dropdown:

Preview-> works ok, shows calendar
Assign-> returns System error page:

System error

The following error message was returned:

Column 'params' cannot be null

The query was:
insert into `tiki_modules`(`name`,`title`,`position`,`ord`,`cache_time`,`rows`,`groups`,`params`,`type`) values(?,?,?,?,?,?,?,?,?)

Values:

1. calendar_new
2.
3. l
4. 1
5. 0
6. 10
7. a:1:{i:0;s:10:"Registered";}
8.
9.

The built query was likely:
insert into `tiki_modules`(`name`,`title`,`position`,`ord`,`cache_time`,`rows`,`groups`,`params`,`type`) values('calendar_new','','l','1','0','10','a:1:{i:0;s:10:\"Registered\";}',NULL,NULL)

I applied profile ((pr: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:

{CODE()}
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 ( ))
{CODE}

---
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) {sign user="xavi" datetime="2017-08-05T22:09:51+00:00"}

In case it matters, I enabled also this bunch of comment-related features:
{CODE()}
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)
{CODE}

{syntax type="tiki" editor="plain"}
Searching the content (try e.g., "social") FAILS with fatal error after fresh-install/index rebuild:
{CODE()}
System error.
The following error message was returned:

DOUBLE value is out of range in '(round((match `tiki-fresh`.`index_6a5a0961d11ac`.`contents` against ('social')),2) * 1)'
The query was:

SELECT *, ROUND(MATCH(`contents`) AGAINST ('social'),2) * 1 + ROUND(MATCH(`title`) AGAINST ('social'),2) * 2.5 AS `score` FROM `index_6a5a0961d11ac` WHERE 1=1 AND ((MATCH (`contents`) AGAINST ('social' IN BOOLEAN MODE) OR MATCH (`title`) AGAINST ('social' IN BOOLEAN MODE)) AND (`searchable` = 'y' AND `searchable` IS NOT NULL)) ORDER BY `score` DESC
The built query was likely:

SELECT *, ROUND(MATCH(`contents`) AGAINST ('social'),2) * 1 + ROUND(MATCH(`title`) AGAINST ('social'),2) * 2.5 AS `score` FROM `index_6a5a0961d11ac` WHERE 1=1 AND ((MATCH (`contents`) AGAINST ('social' IN BOOLEAN MODE) OR MATCH (`title`) AGAINST ('social' IN BOOLEAN MODE)) AND (`searchable` = 'y' AND `searchable` IS NOT NULL)) ORDER BY `score` DESC
{CODE}

_This happens only for the first initial search. After that first attempt it seems to work normally for any subsequent search._

Steps to reproduce:

# Run -+php console.php i:r+-
# Go to -+tiki-searchindex.php?filter~content=profile&sort_mode=score_ndesc+-

With a new Trunk install, then applied the Collaborative Community Profile.
Did not want a right column.
Went to tiki-admin_modules.php
*Clicked Right tab
*Saw 2 modules assigned. Quick Edit and Since your last visit.
**Hovered over the key
***Clicked unassign
Got an error even though it did actually remove the module.

{img fileId="1094" thumb="box"}

If I hit the back button, the module is no longer on the list or on the right column.

Looking at my MySQL, in fact the table does not exist.
*Table jabi.tiki_user_assigned_modules

Perhaps this query should be inside some "IF exists" logic?

t.o calendar: warn the user about the time zone being used at time selection by the user

I added an event at a calendar in Tiki.org community site, and selected the chosen time for the event (13h UTC).
https://tiki.org/tiki-calendar_edit_item.php?viewcalitemId=142

There was no indication of which time zone was Tiki going to understand for my selection, so I chose the time in my time zone: 15h (UTC+2). Tiki stored that time as if it was at 15h UTC, and then display the time of the saved event to me as 17h (UTC+2).

So Tiki was expecting the user to introduce the time in UTC, apparently, but there was no indication about that to the user. Some info should be shown. Maybe that will depend on the settings being set in the tiki site (there are a few combinations to test, I guess). So at least I'll leave the bug report here about it.

I recall Jonny saying that there was some new jquery library that was aware of time zones for time and date pickers? :-)
---
In addition, the time recorded for the item doesn't match the time the user selected in the edit form, or even shown when the user opens the item for edition again. This type of issue seems to have been solved recently (months) in tracker fields date and time (date picker, by developer kroky6), so it may probably just need porting similar fix to the calendar feature itself {sign user="xavi" datetime="2017-01-12T14:51:14+00:00"}

Table editor in wiki edit doesn't open anymore. It did work as expected in 15.x and 16.x

Page contents with this table here (even after updating 17.x to use svn r63071):
http://aspb.llavorspac.org/ASPB+Vehicles

However, I can't reproduce in the show.t.o instance, I don't know why. {sign user="xavi" datetime="2017-06-25T19:20:07+00:00"}

Table of contents in the pdf produced by mpdf doesn't respect page orientation param set in plugin pdfpage.

Stack trace

{CODE()}
TypeError:$(".table-responsive").doubleScroll is not a function. (In '$(".table-responsive").doubleScroll({resetOnWindowResize: true})', '$(".table-responsive").doubleScroll' is undefined)
 at ? (http://dev.tiki.org/Rubix%20ML:1792:36)
 at e (http://dev.tiki.org/temp/public/min_main_c807a8a98d2693284521e06cbbbb4643.js:184:30010)
 at ? (http://dev.tiki.org/temp/public/min_main_c807a8a98d2693284521e06cbbbb4643.js:184:30308)
{CODE}

More info

|| url | http://dev.tiki.org/Rubix%20ML
device | iPhone
browser | Mobile Safari 14.0.3
os.name | iOS
browser.name | Mobile Safari ||

Tablesorter doesn't allow to filter on Tracker item status

See it reproduced here:
https://dev.tiki.org/Trackers#Pending_and_Closed