Category: Usability

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

I just updated to tiki 8.2 and found the problem with data integration from spreadsheets to wiki pages. I did the upgrade to tiki 8.1 before that and there was a problem mentioned in release notes that "Spreadsheets cannot be viewed (via view_sheets). The table quickly disappears when the page loads. Spreadsheets can nevertheless be viewed by editing them, if the user has the appropriate permission." Same thing happened when you integrated cells in wiki page. In 8.2 that problem was fixed, but now whet i type something like

{CODE(colors="c")}''Telephone number:'' | {SHEET(id=>4 range="A6:A6")}Table{SHEET}{CODE}

on wiki page in result I get the whole table showed like in default mode without range instead of only one cell. I tried to find something about changes in module or so, cause may be syntax changed, but no success. In 7.2.1 everything works just fine.

Thanks in andvance
Devox

I use Tiki Wiki for many of my sites and some of them have multiple domains associated with them. So domain.ca, domain.com and domain.co.uk all point to the same folder on the same server using domain redirection.

The main domain works and looks fine but if I go to any of the other domains everything is there but it is out of place. The modules were in the wrong place on the screen and it looked like the theme CSS was messed up. I tried playing with perspectives, multi-domain, areas, domain redirects (within Tiki), category, themes, and anything else that looked promising.

{syntax type="tiki" editor="plain"}
When in tiki-view_tracker_item.php or in tiki-view_tracker.php there is a nice useful "no tab" button on the upper right.
It does not do anything

Firefox 7.0.1 on linux

{syntax type="tiki" editor="plain"}
After updating from 6.x to 8.x (fresh install, database upgraded), the username in the "To:"-field is not autocompleted any more when composing a new message.

{syntax type="tiki" editor="plain"}
>> clever, but this causes quiet upload failures (which happen when
>> PHP doesn't allow a sufficient uploaded file size, POST size,
>> memory limit, or with an insufficient MySQL packet size limit).
>> When the upload fails, the error is displayed in a hidden iframe,
>> and the page keeps showing "Uploading file...".

> Maybe we could trap the error and send a error message... shouldn't be
> too difficult with a error_handler I think !
> As it is really easy I let it to the reader ! :DD

Reference:
http://article.gmane.org/gmane.comp.cms.tiki.cvs/70557


This problem is also for WebDAV (could webDAV client show error message?)

Both the wiki page attach file and filesplugin feature an action icon. When this icon is chosen a pop up box appears with several actions that can be taken on the file. When the delete or red X is chosen the page reloads but the file is still in the file gallery.

Steps in 6.3:
*create tracker, set Auto-create corresponding categories
*define tracker_item like name, add two items.
As result category is created (as tracker name) and items are added as subcategories:

*Informatics Projects(0/1)
** Item1(0/0)
** Item2(1/1)

Same steps in 8.3, result:

*Tracker 1
**Tracker Item
***Name Type Category
***# Projects tracker item Tracker Item
***# Projects tracker item Tracker Item

Result, instead of tracker name category 'Tracker 1' was created, than subcategory 'Tracker Item' and empty object inside, displayed as table with links to non existing "http://localhost/tiki/tiki-view_tracker_item.php?trackerId=1&itemId="

Thanks,
Jakub

in debug mode (eg. when debugging ldap logins) many log entries are created at the same time so sorting by time is not sufficient to get the entries in their real order. Sorting by ID is better then.

Unfortunately sorting by ID leads to an unexpected result.

Looking at the code the problem can be fixed easily: The problem is that two tables are being joined (actionlog and actionlog_conf) and sorting by ID leads to sorting by actionlog_conf.id instead of actionlog.actionID.

Both needs to be fixed - in the SQL query the table for sorting must be added in the sort statement, in the template the columnname must be changed from Id to ActionId.

See patch.

TikiWiki 6.6

When using banners, and you update the banner table manually, the changes are not visible because the banners are cached. (so far so good).

However when clicking 'Clear all tiki caches' the banner cache (which resides in the /temp dir) is not cleared.

{syntax type="tiki" editor="plain"}
We recently upgraded from Tiki 3.x to Tiki 6.x and noticed that the Tracker Field User Select does not work with the variables of 0,1 entered and the selection of specific users. What it does do is just show the entire list of users as you type in a username.

So for example we have a tech ticket issue system setup using a tracker. Afer a user has submitted a ticket/tracker item, an IT person would go to an "Assigned" field (which is a user selector field) and choose the particular tech from a drop down list which was generated from the option of "Select list items that will be displayed:"

Is this an actual bug or are we misconfigured?

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

!!!This problems concerns quite all table and forms (in tables or not) with fixedwidth themes.
This is the reason while it appear in so many functions.

!!!As for most of tables in many functions, with "twist" (no other style tested) the tables of the middle (C2) either overlap C3 or are behind C3 and sometimes C2. They just have a little part outside the 990px large (in twist as the width is written into css it can't be changed by prefs).

__~~#F00:The corresponding functions are then completely unusable.
~~__

Here I write this for the example elementary function "add an element to a structure" givin in screenshots joined documents

Three scrennshots proposed are :
#What a user see
#The limit of the div as shown by firebug
#The whole div zone hidden

{syntax type="tiki" editor="plain"}
!!!After upgrade the admin can't login anymore

!!!The failure sequence :
#Create a new directory or repository for the new version
#Update with your files (particularly images or icons)
#Site enable (example a sub-domain) on Apache
#Copy the database on new name
#Install manually .htaccess (compare and insert your valid options )
#Update "local.php"
#run <your new domain>/tiki-install.php. Goto the end (note an error occurs if your say at the end "run tiki" without locking or not because tiki-setup tries to re-open a session already automatically opened by installer). You just launch again (default tiki-index)
#~~#F00:__Try to login as admin : You will be rejected as wrong password __~~

!!Analysis - many possible reasons :
There are a lot of reasons to be in this situations. So to be successful a lot of conditions must be satisfied :

#If your new version uses the same current domain (after upgrade for my own I defines the same "servername" as current one and then keep the other when a particular name containng the version :
- The Cookies of session will try to reconnect an older version and a trace shows that the password is not the one you have given (generally empty). So the cookies of the site name must be cleared on your navigator

#The temp files or session table contain too wrong data : they must be cleared on server for your current copy (SVN update case)

#Your admin record in user_user record contains sessions data : they create a conflict which makes crash your login

#Be careful of the fact that you can have an open session in your navigator with the same site (sometimes we uses a lot of tab management which can create this : on firefox use showcase and search to clear your old sessions

#Generally avoid these problem is sufficient but at the end you will be prompt to update your password (as for the first login as admin with password admin). This can fail for the following reason : if the .htaccess is not set or modrewrite not well operational the <site name> will include the "port" used by your server. If your NAT translates the port address (i.e. 80-> 4397) you will get the following url <site>:4397/.... which fails

It is sure that if you use only one site close everything and upgrade you will get the minimum of problems but you will get someone anywhere.


!!~~#099:This situation is common and complex for whom have to manage product and data migration from one version (or several) of tiki to a new one.~~
It is not seen generally by developers, because it is not at all their common upgrade process nor test.

I am pretty new at this, so I am not sure if I posted the bug and patch at the correct place and in the correct form. Please let me know if I should change something. Unfortunately I do not have time at the moment to learn how to commit patches via SVN and am also a bit unsure about my fix, so please take a look and include it in the next release if you think it is correct.

Scenario:
Tiki LTS 6.6, Tracker not publicly accessible (by anonymous users), RSS Feeds enabled, RSS for Trackers and for Individual tracker items enabled, RSS basic Authentication enabled.

Behaviour:
If I try to subscribe to the RSS feeds of my tracker (by adding http://tiki.***.***/tiki-tracker_rss.php?trackerId=9 to Outlook) I always get the error "Tiki RSS Feed Error Message: You do not have permission to view this section". Same happens if I log out of Tiki and copy the address in my browser.

Tested in version 3.3 and 7:
Importing tracker items through CSV does not properly process the date field.

My exported CSV contains e.g. "24/12/2010 19:55"
The imported data only contains "24/12/2010" The time has been left out.

{CODE(caption="incorrect code 3.3" colors="php")}# Version 3.3
Line 1697
} elseif ($field['type'] == 'f' || $field['type'] == 'j') {
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = split('/', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = split('/', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
}
}{CODE}

Replaced by following code :
{CODE(caption="correct code 3.3" colors="php") } elseif ($field['type'] == 'f' || $field['type'] == 'j') {
$l = strlen($data[$i]);
switch ($l) {
case ($l == 10):
# Field does not contain the time
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = explode('/', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = explode('/', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
}
break;
case ($l == 16):
# Field contains HH:MM
list($fd, $ft) = explode(' ', $data[$i]);
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = explode('/', $fd);
list($hh, $mm) = explode(':', $ft);
$data[$i] = $tikilib->make_time($hh, $mm, 0, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = explode('/', $fd);
list($hh, $mm) = explode(':', $ft);
$data[$i] = $tikilib->make_time($hh, $mm, 0, $m, $d, $y);
}
break;
case ($l == 19):
# Field contains HH:MM:SS
list($fd, $ft) = explode(' ', $data[$i]);
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = explode('/', $fd);
list($hh, $mm) = explode(':', $ft);
$data[$i] = $tikilib->make_time($hh, $mm, $ss, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = explode('/', $fd);
list($hh, $mm) = explode(':', $ft);
$data[$i] = $tikilib->make_time($hh, $mm, $ss, $m, $d, $y);
}
break;
}
}{CODE}

The same for the latest version 8.3

{CODE(caption="Incorrect code 8.3" wrap="0" colors="php")} case 'f':
case 'j':
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = preg_split('#/#', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = preg_split('#/#', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
} elseif ($dateFormat == 'yyyy-mm-dd') {
list($y, $m, $d) = preg_split('#-#', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
}
break;
}{CODE}


{CODE(caption="Correct code v8.3" wrap="0" colors="php")}# Line 1730
case 'f':
case 'j':
$l = strlen($data[$i]);
switch ($l) {
case ($l == 10):
# Field does not contain the time
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = explode('/', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = explode('/', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
} elseif ($dateFormat == 'yyyy-mm-dd') {
list($y, $m, $d) = explode('-', $data[$i]);
$data[$i] = $tikilib->make_time(0, 0, 0, $m, $d, $y);
}
break;
case ($l == 16):
# Field contains HH:MM
list($fd, $ft) = explode(' ', $data[$i]);
list($hh, $mm) = explode(':', $ft);
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = explode('/', $fd);
$data[$i] = $tikilib->make_time($hh, $mm, 0, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = explode('/', $fd);
$data[$i] = $tikilib->make_time($hh, $mm, 0, $m, $d, $y);
} elseif ($dateFormat == 'yyyy-mm-dd') {
list($y, $m, $d) = explode('-', $fd);
$data[$i] = $tikilib->make_time($hh, $mm, 0, $m, $d, $y);
}
break;
case ($l == 19):
# Field contains HH:MM:SS
list($fd, $ft) = explode(' ', $data[$i]);
list($hh, $mm, $ss) = explode(':', $ft);
if ($dateFormat == 'mm/dd/yyyy') {
list($m, $d, $y) = explode('/', $fd);
$data[$i] = $tikilib->make_time($hh, $mm, $ss, $m, $d, $y);
} elseif ($dateFormat == 'dd/mm/yyyy') {
list($d, $m, $y) = explode('/', $fd);
$data[$i] = $tikilib->make_time($hh, $mm, $ss, $m, $d, $y);
} elseif ($dateFormat == 'yyyy-mm-dd') {
list($y, $m, $d) = explode('-', $fd);
$data[$i] = $tikilib->make_time($hh, $mm, $ss, $m, $d, $y);
}
break;
}
break;
{CODE}

{syntax type="tiki" editor="plain"}
It used to only take checking a checkbox to create a beautiful horizontal menu instead of the horrible, default vertical menu on the left side of the page.



Now it is a complete mystery to me how this is accomplished. I have tried it at OpenSourceCMS.com only to get marginal results.

Importing tracker items through CSV only sets the created and lastModif value properly if the dates from the CSV file are in the numerical php date format.

When you import a csv file where the created and lastModif dates are written as proper dates, the imported tracker items have a created and lastModif date/timestamp of the date & time of the import action.

example csv :

"itemId","status","created","lastModif","VRID -- 265"
"849","o","07/12/2009 13:24","07/12/2009 13:24","4"

Whenever I export a csv file, it contains the dates as shown above, so you can't just export data and import data on the fly without modifying all the values...

c.f. [https://dev.tiki.org/item3500|bug 3500]

{syntax type="tiki" editor="plain"}
In the version 8.3 there are some errors if one wants to export a spreadsheet

The first one appears if one click on the export button. An error () shows up.
I have tried to fix it by inserting the code
"$sheetlib = TikiLib::lib("sheet");" at the line 11 of the "tiki-export_sheet.php" file.

After this fix the export menu appears but exporting the spreadsheet as csv file does not work. (exporting as V 1.0 does not work either, exporting as TikisheetFile V.1 seams to work)
For the case of exporting as csv: After clicking on the "Export" button, the browser ask for saving the file. Depending on the option I choose for saving ("Save as" or "DownloadThemAll") different behavior are observed:
* Save as: A file of 0kB is downloaded (for info the .tws file as 141kb)
* DownloadThemAll an "Server error*" error is shown in the program.

{syntax type="tiki" editor="plain"}
After clicking "create new wiki page", i typed a name for this site containing a forbidden char (in this case "&"). I prompted this entry (not knowing this char is forbidden) to add content to this page.

the "invalid character" field popped up and forced me to rename the page. looked similar to the normal "rename page" input, but without a button to "save" the change.

unfortunately, the save button was also missing in the editor field for my new page and "previewing" the new site didn't change anything in this behaviour.

so in the end - content as well as the page were lost.

please add "save" buttons to this areas.

We have links to external pages using file:// because the pages are internal to our system. This type of link worked in version 3.0 and now doesn't. The links work within a browser so we know it isn't an address error. This type of link uses the protocol (other) within the WYSIWIG editor.

The calendar in TW6.7 does not render correctly in IE8. It shows two months worth of dates instead of the expected single month when in month view. Week view and day view render correctly in IE8, though.

Also, amazingly, the same install of TW6.7 shows the dates of the month of March when viewed with IE8 and April (the current month) when viewed in IE9 and other major standards compliant browsers.

{syntax type="tiki" editor="plain"}
This is a minor issue, and not sure if it something for tiki or google to fix. However I try to push Chrome as the default browser in my school because we use Google apps and it works better for that.
I don’t want to have to tell my users they need to switch browsers to insert an image. This will not get tiki accepted very fast.

I have tested this on a fresh install of 8.3, svn pre8.4, and svn pre9.0

I am on a windows 7 system with Chrome 18, Firefox 11 and IE9.
In wiki syntax mode the file galary image selector works fine.

In WYSIWYG mode the image slector works fine in Firefox and IE, in Chrome I have a new window that tries to open. The window is listed in the task bar but I cannot access it.

I have turned off pop up blockers and disabled all extensions while testing with the same result.

I have also tried from different computers.

{syntax type="tiki" editor="plain"}
When 0 is put in the Parent Category option of the Category field, no category selection is offered in the item creation form.
Even for admin.

This makes it impossible to offer a way of selecting first-level categories in tracker items.

So, tracker items can not be categorised in the first-level categories that way.

I suppose the workaround would be to create a useless category and put all the others as children. Nobody will figure that out and it is uselessly complicated

As an admin, I change the group of a user, and the default group.
The user needs to logout/login or the default group is not changed

Any other Plugin used within PluginTabs doesn't show the edit button. It is not possible to edit them itself like it was before.
For Example, Tab1 with CODE and Tab2 with FANCYTABLE:

{TABS(tabs="code|fancytable|box" toggle="y")}
{CODE()}{CODE}
/////
{FANCYTABLE()}{FANCYTABLE}
/////
{BOX()}{BOX}
/////{TABS}

{syntax type="tiki" editor="plain"}
several problems in Fancytable:
1. Field separator '|' (pipe) is not working with plugins. (must use '~|~' to get it work)
2. any plugin which is used in fancytable is looking fine when only one line is in. When you add a second line, you will get a lot of html viewed.

here is an example i used to figure out these problems:
{FANCYTABLE(head="code|box" colwidths="50%|50%")}{CODE(caption="code with 1 line" colors="sql")}select sysdate from dual;{CODE}~|~{BOX(title="box with 1 line")}1st line in a box{BOX}
{CODE(caption="code with 2 lines" colors="sql")}select sysdate from dual;
select sysdate from dual;{CODE}~|~{BOX(title="box with 2 lines")}1st line in a box
2nd line in a box{BOX}{FANCYTABLE}