Category: All / Undefined

Please see:
http://en.opquast.com/bonnes-pratiques/

It Tiki we can use Smarty or Wiki templates (wiki pages).

For the Wiki pages there no consistency between tools in Tiki.

-=The template parameter=-
For customSearch plugin the parameter is "wiki=" - https://doc.tiki.org/PluginCustomSearch
For the List plugin the parameter is "tplwiki=" - https://doc.tiki.org/PluginList-output-control-block
For the Plugin IncludeTpl the parameter is "filename="wiki:" - https://doc.tiki.org/PluginIncludeTpl
... There could be more...

All the parameter to call a template from a wiki page the parameter should be the same anywhere.
"tplwiki=" seems to me to most understandable and precise.

-=The Wiki syntax require to use the template=-
* Plugin List: a wiki template can be use as is (you just paste your HTML)
* Plugin customSearch: your html need to be enclosed between literal tags ({literal} HTML {/literal}

It should be just consistent for the end user (not power user) experience.

Currently, the $page and $description variables are available only for content displayed as Wiki Pages. Coding modules to extract similar information from other pages that may be displayed has to be done on a case by case basis.

I have been testing a nice web site testing tool - WebInspect. After running several hours of tests against a Tiki site, it identified several places where user input was not scrubbed and open to cross site scripting:

For 1.9.3 updated 25 March

tiki-send_blog_post?postID=
tiki-view_blog.php?find=
tiki-print_blog_post.php?postID=
tiki-remind_password.php
tiki-error.php?error=
tiki-view_blog_post?blogID=
tiki-config_pdf.php?page=
tiki-print.php?page=
tiki-calendar.php?editmode=
tiki-take_survey.php?surveyId=
tiki-index.php?page=

Bundled themes readiness, see ''New Css Entities'', Fix broken themes ((tw:RecipeRestoreCss))

I just made a fresh installation on a shared hosting service (all-inkl.com) via svn and did not get the Tiki running after successfull installation.

The installation was made in a PHP7 document root.

Two problems:

1. Site never stopped loading
2. Dropdowns) did not work (all dropdowns like login, quickadmin, etc) and added a # hashtag to the url in the address bar of the browser.

After a while (minutes) the site mentioned some JavaScript error in a popup error message.

I did change the PHP to PHP5.6 and then after a few minutes the site worked as fine as expected.
There seems to be some coherence with the PHP version.

Is that maybe related with Xavi's [https://dev.tiki.org/item6035|Bug 6035] ?
Torsten

Get this on image view pages like...
http://cefn.com/cefntiki/tiki-browse_image.php?galleryId=2&imageId=2

An error occured in a database query!

Context:
File /cefn.com/cefntiki/tiki-browse_image.php
Url /cefntiki/tiki-browse_image.php?galleryId=2&imageId=2
Query:
select `catObjectId` from `tiki_categorized_objects` where `type`=? and `objId`=?
Values:
0 image gallery
1 2
Message:
Error Message

Database error as follows:

#
Context:
#
File tiki-editpage.php
#
Url tiki-editpage.php
#
Query:
#
insert into `tiki_objects`(`type`,`itemId`,`description`,`name`,`href`,`created`,`hits`,`comments_locked`) values(?,?,?,?,?,?,?,?)
Message:
#
Unknown column 'comments_locked' in 'field list'

installer/schema/20090205_forum_and_comments_locking_tiki.sql appears not to be run on fresh install. This file was introduced in:

http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki?view=rev&revision=17801

Shouldn't the filename be 20090405....? Is this the problem?

Also, is this related to http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki?view=rev&revision=17919

The datachannel does not accept data when passed as a country selector tracker field. ( Without a JQ event ). Jyhem has a well explained document at http://doc.tiki.org/Data+Channels?highlight=datachannels . This example works only when there is a JQ event i.e. when the user makes a change to the fields explained. Though my use case is simliar, I am using the tracker plugin to pull from a user registration tracker to pre-fill fields for the user to verify, there are typically no changes to the fields and consequently the JQ doesn't trigger. Therefore I used the standard datachannel method of passing static fields "fieldName,external=fieldId" to pass the values to the datachannel. No worries there...the problem occurs when I try to pass a country selector field value to the datachannel. I am using the "hidden" method i.e. "fieldName,hidden=" and the JQ script $("inputname='Country'").val($('#page-data').find(":selected").text()); to pass this value. Inspection of the HTML output using a console indicates the form data are properly outputted i.e. input type="hidden" name="Country" value="United States" (end tags removed) but this is not passed or it is parsed out upon form submission. The importance of this functionality is obvious and I think it would greatly improve the use of the datachannel plugin.

Thanks in advance for your consideration.

Robert A Rasgorshek

showtiki info admin 12345

We need to decide on our branching & merging strategy.

Background info:
Many of the enhancements on HEAD have been backported to BRANCH-1-9. Most of the other enhancements have been done by Terence (teedog) -> ((tw:ReleaseProcess110))

Do we continue merges from 1.8 to 1.9 to Head?

Do we have devs assigned to merges, or do we ask each dev to do them?

Please see:
http://sourceforge.net/mailarchive/message.php?msg_id=11402375

More discussion needed here...

Dev.tiki.org Last update from SVN (18.2svn): Monday 07 May, 2018 23:24:55 IDT- REV 66296

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

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

IRC-Log 20050705
---
[22:38:53] <amette> ahum - it looks to me, that we loose data on tw.o and on dev.tw.o after site-updates - please have a look here: http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=257&show=view&status=o&trackerId=5&sort_mode=f_41_desc&filterfield=26&filtervalue[26]=tracker
[22:39:36] <amette> luci added the solution as far as I remember (lastmod is empty) - later on I closed this item with solution Accepted and a modification to the solution

--- some stuff cut ---

[22:49:50] <amette> The thing with tw.o is, that I know exactly I edited a page - later toggg told me, that I didn't make the change, hm, well, yes, it was lost.....
---
The page in question is
http://tikiwiki.org/tiki-index.php?page=FindTikiExpert

No one can confirm that with their own Tiki.

I really don't know what it could be (site updates) - but it scares the hell out of me.... well, almost ;)

Calendar URLs are currently excluded for spiders and bots, for example:

/calendar?focus=1268089200&viewmode=week

excluded by entries:

Disallow: tiki-calendar.php
Disallow: /tiki-calendar.php

However, the URL /tiki-tell_a_friend.php?url=%2Fcalendar%3Ffocus%3D1268089200%26viewmode%3Dweek would be spidered instead.

Hello,

When you use an existing database (UTF8 coded but charset=latin1 and collate=latin1-swedish-ci) converted by tiki-install 5.0 :

1- the titles and contents are displayed : as pure utf8 is saying the French texts (tables defined charset=latin1) :

A- Titles of any item
"L'échec et ses conséquences" is displayed :
" L'échecs et ses conséquences"

B- Texts of dictionnary (language.php UTF8 encoded) as
"créé à partir d'une structure" (comment the update or creation origin of a document) is too displayed
"créé à partir d'une structure"

C- Contents of Wiki or articles : id

D- Menu options : are well displayed
The text comes from the same file language.php (fr)

E- Tiles of column of tables etc. : well displayed

F- Warning messages ?

Everything behaves like the titles and contents even defined as charset=latin1 are dsiplyed as UTF8 while the others are threated well.
Is it a relation with the fact that "modify" action never displays anything because of the query, I will try to understand.

Everything was displayed well in 4.x versions

trebly

!!phenomenon :
On a particular configuration, not identified yet, pieces of text are displayed as latin1 in a pagecode identified as utf-8 encoded.

!!test and facts :
# From a database well encoded utf8 and used with 5.0 on windows : export sql and look at encoding in hexa editor.
# Create from sql file two new database one on a windows installation, the other on Linux (OVH)
# Copy 5.3 to both installations.
# Run install and uses upgrade and convert
# Export databases to sql
# Compare the sql file : identical main data
# On loading the same page from the two servers we obtain two different displays :
## - Locally the delivered html page is clean and well displayed (sourcepage save and edited in hexa and firebug)
##__ - From the OVH server all the data from database are converted to latin1(where ?, probably served by mysql converted to latin1) while the text form system (language file) are displayed in utf8.__
# __ - The behaviour of the OVH installation is completely erratic (because the data are served converted and all indexes request and keys with accents become wrong)
# The Administrator general display says : "database error"__

!!question :
Why the data served to tikiwiki, with exactly the same parameters and data, are right on my server and converted into latin1 on the OVH configuration ?
I have not yet searched into the product, and I don't know, previously, how tikiwiki holds the encoding.

I think that who have developed these piece of product is able to tell me where the encoding to serve by mysql to the product is defined and which parameter can have an effect on the linux server and not on the one on windows.

Have a look at this older bug report.

It is being rendered like in the screenshot (attachments), completely illegible. My browser here is a current MS Edge on W10.

Without starting a new discussion on breaking layouts: If a page like dto writen not on ancient but fairly up-to-date Tiki versions renders like the screenshot: How can an admin protect his/her website from such? How can it be remedied? Sites as large as dto surely cannot be inspected page by page for layout errors.

Thanks
hman

Next servers are down (but next.tiki)

https://nextdoc.tiki.org
https://nextdev.tiki.org
https://nextthemes.tiki.org

502 Bad Gateway
nginx/1.12.2

{syntax type="tiki" editor="plain"}
In RC2 they made some changes to the edit-help (the now blue circle with a question mark).

When you open up the help and go to full screen mode, the text is un-readable while using the Darkroom theme.

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

If you activate the function "check orthography" in params of a tiki page when editing it, When you save you get systematically the following error :


__!System error.__

Le message d'erreur suivant a été renvoyé :

__Table 'spacprottwk153.babl_words_fr' doesn't exist__

The query was :
select `word` from `babl_words_fr` where `word`=? or `word`=?

Valeurs :

1. Table
2. table

The built query was likely :
select `word` from `babl_words_fr` where `word`='Table' or `word`='table'

Things to check:

1.

Is your database up and running?
2.

Is your database corrupt? Please see how to repair your database
3.

Are your database credentials accurate? (username, database name, etc in db/local.php)
4.

Did you complete the Tiki Installer?

Please see the documentation for more information.

__The database is conform to update from 4.1 and validated__

This should be migrated to the community site, and handled with ((doc:Organic groups)) and ((doc:User Trackers))

!ENH trunk 7x : ability to introduce [breakline] in some texts and their translations

!!Nature of the problem
I many text it is unhallowed to use any markup language and filters are applied to these text.
Nevertheless, regardless HTML the this creates one main problem :

For <label> <input> and others strings with implicit new type "tikitypes" as warnings, comments etc... it is often necessary to have for a good GUI <breakline> at optimized positions.
HTML allows <br /> in all these cases (and all tags for strings into many tags.

Sometimes after translation because the words are longer a simple remark or a label which precede an input which followed himself by buttons-icons see the buttons at the next line.

All these cases needs to allow a [breakline] command which is then the lonely tag allowed.

I made this first for prefs in tiki_admin for labels (particularly when they are dependent and have a disposal on two columns)

!!What have been done
!!!Define the [breakline] command
!!!Create a smarty modifier "breakline"
It just replaces into strings [breakline] by "<br />" after the firewalls have been passed...
!!!Apply to list.tpl (class adminoptionbox)
Sample in list.tpl
<label for="{$p.id|escape}">{$p.name|escape}:</label>
Become
<label for="{$p.id|escape}">{$p.name|escape|breakline}:</label>

!!What to do ?
Nothing I just have to commit.
But it changes general common rules. It is a [MOD] of second level the level of developers.

Ready to commit.

What's your opinion ?

trebly

{syntax type=tiki}
{syntax type="tiki" editor="plain"}
This is the ((Tracking system for Tiki issues)).
If this is your first time, please read: ((How to Submit a new item on the Wishlist))

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

This concerns the [http://dev.tikiwiki.org/Search+Bugs] and [http://dev.tikiwiki.org/tiki-index.php?page=Search+Bugs]

I have yet reported this bug, but because of three crossed bugs 3104 and the "not found ones" this had been yet reported but not reachable.

__The three bugs are (were for the first) :__

!! 1- Report with no author
The registering of a "report a bug" was not always getting the author name. So, the report was, till ten days ago (diagnostic by chat and it seems repaired), treated as a not registered user (or logged in user ) writing.

!!!The consequences are :
# No way to access them (no ticket displayed) and no access if found for the real author. Nota : if you have the ticket number (got from chat when submitted ) you can access it reacting the http query for this ticket.

# no way to manage them by the registered author

I have between ten and twenty report lost by this way.
And because of the second bug I can't find them back (just those submitted while I was chatting because the ticked is displayed on the chat.

!! 2- Filter crash :
the reason is the use of the "IN()" SQL clause which is not accepted by MYSQL
It is impossible to check the list in a right manner

!!3- Crash on sort list
(click on column headers) for the same reason : use of "IN() clause into the SQL request

!Problems and solutions

!!Repair the request generation - all

!!Getback the management of his ticket to the real author

It is a lot of job and not fair to rewrite all the reports lost (generates doubletons).

The lonely solution seems to be that the author could submit to the manager (webmaster...) the list of the concerned reports (ticket number or title).

This needs to get a successful search (filter), implies that the 2d and 3td bug should be solved (I could not display an available list to find mines - I have sometimes made a local copy, so I have some dates, but at this dates or around I can't find my report, the list is always just a part of the full one)

!!Display the ticket number even the author is not known should be usefull

!!The mean of "any" in properties of report and display
Even this data means "any not defined" when you say "any" you mean actually : "only the marked - any - reports". So it is impossible without clicking individually all the checks "anyone" of this criteria.
The solution can be either :
*on the filter a button : select all
*a data for filter names "anyone"
*both

- "select all" allow to unselect someones after
- "anyone" makes a more simple query allowing to forgot the criteria


__Without these solutions it is either awful or impossible to manage his "reports a bug"
__

Trebly - 04/28/2010 - 3h.07 Paris

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

I just submit a new search, the SQL request crashes with "system error" as reported in item 3104.

This seems to be solved a few days ago, but it was not a full solution.
Here beyond the beginning of the request :

SELECT tti.*, ttif.`value`, ttf.`type`, sttif.`value` as `sortvalue` FROM ( `tiki_tracker_items` tti INNER JOIN `tiki_tracker_item_fields` ttif ON tti.`itemId` = ttif.`itemId` INNER JOIN `tiki_tracker_fields` ttf ON ttf.`fieldId` = ttif.`fieldId`) LEFT JOIN (`tiki_tracker_item_fields` sttif) ON (tti.`itemId` = sttif.`itemId` AND sttif.`fieldId` = 41) INNER JOIN `tiki_tracker_item_fields` ttif0 ON (ttif0.`itemId` = ttif.`itemId`) INNER JOIN `tiki_objects` tob43 ON (tob43.`itemId` = tti.`itemId`) INNER JOIN `tiki_category_objects` tco43 ON (tob43.`objectId` = tco43.`catObjectId`) INNER JOIN `tiki_tracker_item_fields` ttif1 ON (ttif1.`itemId` = ttif0.`itemId`) INNER JOIN `tiki_objects` tob47 ON (tob47.`itemId` = tti.`itemId`) INNER JOIN `tiki_category_objects` tco47 ON (tob47.`objectId` = tco47.`catObjectId`) WHERE tti.`trackerId` = ? and (`status`=? or `status`=?) AND ttif0.`fieldId`=? AND tob43.`type` = 'trackeritem' AND tco43.`categId` IN ( ) AND ttif1.`fieldId`=? AND tob47.`type` = 'trackeritem' AND tco47.`categId` IN ( ) GROUP BY tti.`itemId` ORDER BY `sortvalue` desc...

You can notice that the syntax uses in "IN ()" clause which is not accepted by MYSQL.

!!Solution, first steps
Check all SQL queries for "IN()" clause and find a bypass anywhere in tikiwiki.

Trebly

Printing pages is sometimes a real mess.
So, http://www.printwhatyoulike.com brings the opportunity to select parts of the page to print etc.