Category: Conflict of two features (each works well independently)

===text===
On Feb 21, 2013 5:34 AM, "mekko" <[hidden email]> wrote:

Hi all,

I am trying to follow the instructions on using my own content delivery
network with a separate domain on the same server as my Tiki. Strangely,
while file gallery images and my logo in the tiki folder are displayed fine,
all icons disappeared and are replaced by a question mark. When moving with
the mouse over the question mark, the tooltip displays an error "URI
http://cdn.mydomain.com/... not allowed by security setting". When I copy
the URL and open it in a new browser tab it is displayed without a problem.
So I guess this is a Tiki specific issue. I could not find any matching
permission settings or similar.

Collapsible sections are those created by starting a title with "+" or "-". Some of these sections cannot be expanded or collapsed due to a conflict with other collapsible sections shown at the same time but parsed in different contexts.

When such a conflict happens, the div elements of the conflicting sections have identical id attributes (which means the HTML is invalid). Browsers deal with such conflicts by considering that the real element with the duplicate id is the first one. Consequently, when that happens, trying to open/close any of the conflicting sections will open/close the first conflicting section.

It would be difficult to explain exactly when this occurs or not, but this is very simple to reproduce. Suffice to call the FADE plugin twice and to have at least 1 collapsible section in each call's body. Trying to open or close the first section of the second call to FADE will fail.


!! Cause
The identifiers of the section are generated in parse_data_process_maketoc(). The $nb_hdrs variable holds a count of collapsible sections which attempts to avoid such conflicts, but as this is a local variable, when parse_data_process_maketoc() is called several times, conflicts can occur between different contexts. As FADE calls parse_data() to parse its body, a page's immediate content and its content inside a FADE zone are parsed in different contexts.

This affects trunk as of r69061.

!! Example
This is demonstrated on [http://chealer-232-7031.show.tikiwiki.org/tiki-index.php?page=HomePage|this show.tikiwiki.org page].

ex.: rollback and view source actions appear but then, there is an error when trying to use

Something about namespaces seems to conflict with url sending user after updating tracker item with SEFURL

Url where I update an item is:
{CODE()}
http://example.com/item608?from=SERGEN-Xavier%3A_%3AMagatzem-LH-AraVinc
{CODE}

Editing the tracker item is done in a modal window. I update a datepicker field in the tracker, save, and I'm re-sent to this full url in the browser:
{CODE()}
sergen-xavier:_:Magatzem-LH-AraVinc
{CODE}

i.e., with no http, nor domain, etc.

The tracker item edit was saved properly, it's just disorienting for the user to be sent to that defective url.

{syntax type="tiki" editor="plain"}
Hello,

This is a new formulation of 3029 problem after near 200 hours of test and debug.

!The problem is now precise and near solution :
I can't affirm that I wrote debug because the execution stop on another problem.
The time spend is not only on TikiWiki, a had to solved installation problems and find a bug into easyphp and addresses resolution on the server.
The problem began with 4.1 and php 5.3.0 and I upgrade to 4.2 and 5.3.2 to be sure of the problem and the available solution.

!Span of the problem :
# Definition of main classes TikiDb and TikiDb_Pdo and PDO->function execution
# Progs : tiki-db-pdo.php, tikisession-pdo.php and naturally pdo.php, tikiDb.php
# PDO extension and behavior of objects and classes

!Description
note : Because I found the nature of the problem, I don't start from the nature of the crash but the analysis, but I produce a selected track made with xdebug var_dump)

# In tiki-db-pdo.php:40 we create the Pdo object
<$dbTiki = new PDO("$db_tiki:$db_hoststring;dbname=$dbs_tiki", $user_tiki, $pass_tiki); >

# just later In tiki-db-pdo.php:49 we set the singleton of TikiDb_Pdo into TikiDb abstract class with scope operator
<TikiDb::set( new TikiDb_Pdo( $dbTiki ) ); >

# further we call In tikisession-pdo.php:28 we can find the session read
< $sth = TikiDb::get()->prepare($qry); >
This instruction generates the fatal error :
__ Fatal error: Call to undefined method TikiDb_Pdo::prepare() in D:\Trebly\Teawik-ld8-422a\lib\tikisession-pdo.php on line 28__

!Explanation and solution implemented
The reason is simple and explained by the error comment :
we try to run the prepare function which is a PDO function on a TikiDb_Pdo object which has no reason to inherit of these Pdo function even <TikiDb::get()->db->prepare> could have a meaning.

Then the solution is in what is made in ZEND lib (not yet used), create an interface to PDO into Class TikiDb_Pdo.
This functions and it is written.

! A major question
One important question is why and how the same instructions seems to be available and functions well on Linux (I have a site which runs normally with 4.1, not yet upgraded to 4.2, a to-do)

I believe that the actual solution that I have developed for 4.2 on Windows with PDO (compiled) extension, should be extended to the normal version.

As I have said before I can't confirm completely that the solution is correctly tested and free of bug because, the program have a FATAL ERROR PDOException: SQLSTATE[HY093] later on the prefs restoration I create another report for this.

Note :
the execute statement written execute() without parameter generates each time a warning message when xdebug is activated with STRICT option (default in 5.3.2) for errors handling in php, and necessarily makes the code lightly slower. I developed an enhanced error template according to the error handler which displays much more informations about the context and, into these, the parameter (title) of execute statement. This make an enhancement to find much more quickly the errors.

{img src=images/code.png}%%% {CODE(caption=current strikethrough syntax)}
{TAG(tag=>strike)}texte{TAG}
{CODE}

Suggested one for us:
--strike--

As suggested in wikicreole:
http://www.wikicreole.org/wiki/Strike

All wiki engines:
http://www.wikimatrix.org/syntax.php?i=27

This is very useful when using wiki pages for ((project management))

When the Structure TOC Plugin is activated, I can no longer edit pages in WYSIWYG mode. CKeditor sits and spins "Loading".

Errors produced:
/vendor_bundled/vendor/ckeditor/ckeditor/plugins/Tabledesmati%C3%A8res(Structure)/plugin.js?t=I8BH:1 Failed to load resource: the server responded with a status of 404 (Not Found)

ckeditor.js:248 Uncaught Error: [CKEDITOR.resourceManager.load] Resource name "Tabledesmatières(Structure)" was not found at "http://outilingua.net/vendor_bundled/vendor/ckeditor/ckeditor/plugins/Tabledesmatières(Structure)/plugin.js?t=I8BH".
at window.CKEDITOR.window.CKEDITOR.dom.CKEDITOR.resourceManager.<anonymous> (ckeditor.js:248)
at f (ckeditor.js:244)
at Array.n (ckeditor.js:244)
at r (ckeditor.js:244)
at HTMLScriptElement.CKEDITOR.env.ie.d.$.onerror (ckeditor.js:245)


This occurred on two separate Tiki sites after upgrading from 18.2. I have no workaround as Structures are an important part of both sites for navigation.

{syntax type="tiki" editor="plain"}
When the system is set up to use staging & approval and the Structures are turned on, pages/topics created using the Add Page feature included with Structures get created with a staging name. The structure fails/disappears when the page is approved (fails in that the structure loses the staging name and does NOT substitute in the page without the staging name).

{syntax type="tiki" editor="plain"}
If you turn on SEF all your links will be converted to SEF-links so far with the exception of the links the bradcrumb bar of the structure.

Tested on tiki 3.5

When you set up in ((doc:PluginPivotTable)) the renderName from __HeatMap__ to __Table With Subtotal Heatmap__, then when you click on a cell produces no popup with the aggregate details any more.

Using the switch-theme module has no effect. The page refreshes but the theme doesn't change. But, it works as expected when the user is logged in.

see also : http://dev.tiki.org/item4874

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}

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"}

I have a search module which searches into the wiki pages.

On clicking "OK", I do get on tiki-listpages.php?find=mysearchword&go=OK and it displays for a short time the correct list of pages and the correct number of pages. Then the « I'm searching » spinner kicks in and the list of search result pages is replaced with the full list of all pages.

There is a demo here:
[https://showlistpages.winter.alsawiki.com]
Database available here : [https://showlistpages.winter.alsawiki.com/backups/dump_db.sql.gz]

Tablesorter doesn't allow to filter on Tracker item status

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

Tablesorter doesn't allow to sort on tracker item status

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

Reproduced here:
http://xavi-9794-6037.show.tikiwiki.org/tiki-index.php?page=Tracker_as_Calendar_12#contentTracker_as_Calendar_Tabs-2
u: admin
p: 12345

See field "Location" shown as text input field, evevn if defined as dropdown.
When you change the param server=y to server=n, dropdown is shown as expected.

On a Tiki forum when it is enable Tablesorter is added to the table that list the forum to allow filtering and sorting. Work fine if you have only Forums.
When you use subforum discussions the table sorter is interfering as it is working on the subform list instead of continuing to filter/sort the discussion below.

The tablesorter filter row is placed above the subforums list instead of the discussion list it should be moved below to be applied on the discussions.

Tablesorter: dropdowns in tsfilters and shown as text filters (most of them) when server=y

Reproduced at the show instance from this related report:
https://dev.tiki.org/item6200

http://xavi-9794-6200.show.tikiwiki.org/tiki-index.php?page=Bug6202
u: admin
p: 12345

edit the page, and you will see that many of the filters where set as dropdowns, However, they are shown as text filters.

Tablesorter: filtering for an item doesn’t find it if not in the first pagination when server=y


It was going to be reproduced at this show instance but for some reason, I cannot reproduce the issue that we have seen in a development site for a client. :-/

In any case, for the record:
http://xavi-9794-6200.show.tikiwiki.org/tiki-index.php?page=Bug6200
u: admin
p: 12345

FYI: this show instance is also used to demonstrate the issues reported in the bug reports:
https://dev.tiki.org/item6201
https://dev.tiki.org/item6202

Tablesorter: with server=n tspaginate is not taken into account (we did set max:2 and it keeps displaying all the 5 items) when js minification is enabled.


Reproduced at the show instance from this related report:
https://dev.tiki.org/item6200

http://xavi-9794-6200.show.tikiwiki.org/tiki-index.php?page=Bug6201
u: admin
p: 12345


{CODE()}
{trackerlist trackerId="1" fields="4:2:3:1:5:8:9:10" showlinks="y" popup="6:7" editableall="y" sortable="y" showstatus="y" status="opc" tsfilters="type:text;placeholder:|type:dropdown;placeholder:|type:nofilter|type:dropdown;placeholder:|type:text;placeholder|type:dropdown;placeholder:|type:dropdown;placeholder:|type:dropdown;placeholder|type:dropdown;placeholder|type:text;placeholder" tspaginate="max:2;expand:5;expand:10;expand:20" showpagination="n" max="-1" server=n}
{CODE}

Disable minifcation cehckboxes in the control panels, and it worked for me as expected.

Found out that if you use wiki tags, and SEFURL, the tags feature will be invisible unless you visit the exact link to the wiki page. For exemple, if you have a wiki page named "abc def"you go to foo.bar/abc+def it will work, but SEFURL will make links go to foo.bar/abc_def (assuming you choose it to replace to underlines), and for some reason the tags feature won't show, but all other things work fine.

Show instance: http://fvtorres-11800-5943.show.tikiwiki.org/
User: admin
Pass: 12345

Please see video: [tiki-download_item_attachment.php?attId=758]

Take Username internally (even if Realname displayed in the To field for users) in the intratiki messaging feature

intratiki messaging displays Realname (when the pref. is selected to do so), but Tiki needs to somehow convert that string back into the username internally in Tiki, since the user sees the user's Realname in the "To" field, but Tiki expects usernames to know who to send the message to.

---
Update: Pending to fix: when you reply to a previous message, you still get the usernames added at the "To" field, instead of the realnames. Therefore, when replying, you get the message that no valid user was there to reply to, since Tiki, in current revisions, and with that configuration, expects the realnames in the "To" field.

Adding many users at once to a group fails in 12.x, and it used to work nicely in 9.x LTS at least.

I had Jquery Chosen enabled, and when I disabled it, I was able to add them to a group through tiki-adminusers.php as usual.


To reproduce, go to:
http://xavi-9794-5163.show.tikiwiki.org/tiki-adminusers.php

u: admin
p: 12345

select both users (user1 & user2), click at "Manage group assignments", and choose to assign them to group "Admins". Validate the confirmation step. Nothing happens (they are not added to the Admins group).

Repeat without JQuery Chosen, and it will work as expected.
---
Update {sign user="xavi" datetime="2014-04-07T07:44:15+00:00"}
Actions on multiple users with chosen and sortable tables work, but the second dropdown is not shown properly:
{img fileId="742" thumb="y" rel="box[g]"}
---
Update {sign user="xavi" datetime="2015-04-02T08:04:24+00:00"}
You can't even select any groups at the step to choose group in the multi selection combo box.
{img fileId="992" thumb="y" rel="box[g]"}
---
Update {sign user="lindon" datetime="2015-04-07T03:41:55+00:00"}
I am not able to recreate this [[the former issue report related to jquery sortable tables] using my local 12x - I am able to add or remove multiple users to multiple groups. Did it with 25 users with no issue. The list of groups came up properly and I was able to multi-select.
---
Update {sign user="xavi" datetime="2015-12-16T07:59:32+00:00"}: removed references to Tablesorter as I could confirm that at least with current code (thanks lindon for checking!) the issue seems to be attibuted to Chosen only.