Category: 9.x

Hi all,

I'm trying to implement tax calculations in a spreadsheet, and I find that the formulas documented in
https://doc.tiki.org/Spreadsheet+jq#New_syntax_for_formulas(external link)
are not working for me, specifically the IF formula. I tried cutting and pasting the formula in the documentation, and it returned an error: Parse error on line 1, with an arrow pointing to the first cell reference.

Is there something I have to do to configure my spreadsheet to use the JQuery formulas?

Thanks!

JK

{syntax type="tiki" editor="plain"}
The install fails if the server is running php safe mode. There are several references to this issue with work-arounds that didn't work for me (ex. http://twbasics.tikiforsmarties.com/Fixing+Installation+Problems).

The problem (at least for me) was that I do not have access to /tmp. It turns out to be related to a bit of code in initlib.php that doesn't check for an empty tempdir. I added additional code return ./tmp (and create it if necessary). See below. Code is commented "Safemode Fix".

static function tempdir()
{
static $tempdir;
if (!$tempdir) {
$tempfile = @tempnam(false, '');
$tempdir = dirname($tempfile);
@unlink($tempfile);
__ // Safemode Fix
if (!$tempdir) {
$tempdir = "./tmp";
if (!is_dir($tempdir)) {
mkdir($tempdir);
}
}__

}
return $tempdir;
}

There are three problems with the "Add messages from this email to the forum" when using notifications. Fixing these allows seamless integration with an email address without a separate receiver list.

# Outgoing email forum notifications should use a subject format that can be parsed into the right thread if someone replies to it if "Add messages from this email to the forum" is set.
# Outgoing email forum notifications should use the "Originating email address for mails from this forum" address so replies go to the right box (this should have worked, but didn't for me without a fix....)
# Replies have the "Re:" removed before posting to find the right thread. This needs to be added back or the resulting notification email is confusing.
# The "From" on notifications has the posters name while the email address is the forum address. This is confusing to users.

The fixes are only about 5 lines. I've attached the fixed notificationemaillib.php and commentslib.php. Fixes are marked with "AJH".

{syntax type="tiki" editor="plain"}
get_dsn_info and get_db_by_name doesnt support a connection to firebird because they firebird-connection-string is a little bit special (no host, everthing inside the dbname).

The solution contains also code for using params in the connectionstring.

I've added a test Report with the bug tracker sample data, seems to work fairly well, except that it's not listing open items (which trackerlist does).

Robert, maybe there is some bug around also for those simple examples?

Compare this:
http://demo.tiki.org/9x/Bug_Tracker#Bugs_list_using_Plugin_Tracker_List_

with that:
http://demo.tiki.org/9x/Bug_Tracker#Bugs_list_using_Plugin_Report_

Some fields display html code in the spreadsheet cells:
Like:

{CODE()}
Identificació - 319 ItemId - 320
<span class="hdrField" data-level="3" style="display:none;"></span> 1596
...
{CODE}

See screenshot here:
{img src="display66"}

The first column is a self-numbering field type, as main field (linked from the list to the item), and the one that says "Etiquetes lliures" refers to tags, which show hyperlinked tags, etc.
---
UPDATE: Still happening in 12.x {sign user="xavi" datetime="2013-11-17T08:47:04+00:00"}

Report doesn't seem to filter by date as it's supposed to do.

I select to list only values after a date (by the way, how does report know that this field is supposed to be the start date? just because is the first one of a couple of consecutive date fields in a tracker?), and value before that date are also shown.

I mean, we have a tracker with several date fields (4 in fact) for project management:
* when the project was requested
* when the project started
* when the project is due to be finished
* the date of the next deadline to meet within the project timeframe.

Ideally, the user should be offered the option to select which tracker field want to use as a start date for the filter, and which one as the end date for the filter. And not just the creation date or the modification date.

Right now, it seems to be using either the creation or modification date of the tracker item? (which is less useful and less versatile than what it could be with the previous improvement of the design)

The other things that might be affecting the missbehavior of the filtering by date is that the date field in a tracker can be set either by using the "Date and time" tracker field, and the "Date and time (Date Picker)" (jquery) tracker field.
See http://doc.tiki.org/Date+Tracker+Fields

They both seem (from the end user point of view) to have different way to store data:
* JQuery date picker from the tracker-field "Date and time (Date Picker)" seems to use this syntax for dates: __yyyy-mm-dd__
* JQuery date picker from the Report Builder (tiki-edit_report.php) Start and End dates, seems to use this syntax for dates: __dd/mm/yyyyy__

Maybe this is also interfering in the filtering by dates?

Using 9.2 (svn).

Tracker view item history doesn't display anything after an admin edited one field of one item

Reproduced here:
http://r-es.org/tiki-tracker_view_history.php?itemId=349

Fatal error: Maximum execution time of 300 seconds exceeded in /path/lib/smarty/libs/sysplugins/smarty_internal_data.php on line 54

Using report plugin, with a tracker with many data, etc
Ask xavi if you want to see the code to reproduce it, or a db dump to reproduce it in your localhost.

The Report feature doesn't seem to filter data if the filter applid refers to a "Item link" type of tracker field.

Scenario:
* Tracker 1 refers to a user tracker, and one of the fields is for province.
* Tracker 2 contains all the provicen names in a drop down field, and cities in a text field. (this is the common setup of a "dynamic items list" featur).

If you use report to list all items from tracker 1 which contain "province name" = "foo", you get nothing in the list. foo province exists in tracker 2. However, mysql table for tracker data seems to store the value for the province with a numeric id, instead of the string "foo" that the user knows. Therefore, there no way for the user to filter for that field.

9x dev.t.o/t5: Plain registered users can't rate tracker items; admins can. Obj & Global Perms seems ok though: bug?

Example:
As user xavi (plain regitered user) I added this bug report:
http://dev.tiki.org/tiki-view_tracker_item.php?trackerId=5&itemId=4330

I click on the stars field (field 62: Rating Stars (system) ) and my rating is not shown.

If I login as a user with admin privileges, then I can see the average rating, and I can rate also that item.

{syntax type="tiki" editor="plain"}
loss format text when user re-edit submission (use Wysiwyg)
ex:__abc__ -->abc

{syntax type="tiki" editor="plain"}
When clicking the "unsubscribe" link from a newsletter email the customer is immediately taken to the site where they receive a "You are not logged in" error. If the customer were to first log into the site and then click the newsletter "unsubscribe" link in the email it works fine.

A plugin requires approval. The fingerprint of the plugin is recorded, and if it is already approved, another user can use the plugin (in other words can display the page which contains the plugin).

But, if the plugin contains the fragment "/{/{user/}/}", for example
~np~{SQL(db="LOPC_XF")} SELECT `Date`, `Subject`, `From` FROM vwMessages WHERE `To` IS NULL OR `To`="/{/{user/}/}" {SQL}~/np~

then the plugin needs to be approved for each user individually.
NB - I had to put extra slashes in the above fragments to stop my username being substituted!

My guess is that the username is being substituted BEFORE the fingerprint is evaluated, which means that there is a different fingerprint for each user.

I consider that this is a bug, and that the fingerprint should be evaluated BEFORE the username is substituted, thereby allowing the plugin to be approved just once.

It ought to be a one-line fix - swap round the order of two actions - but I haven't been able to work out where in the code this fix is needed.

i have try tw 9.2 and have problem with plugin Source in wisywig editor. it give me sorce of not last version of page. How i can change it?

Set an arbitrary theme to Tiki's default (e.g. Arcturus or Fivealive). The W3C CSS Validator [http://jigsaw.w3.org/css-validator/|http://jigsaw.w3.org/css-validator/] throws a lot of errors and warnings.

Check this for [http://jigsaw.w3.org/css-validator/validator?uri=http%3A%2F%2Ftiki.org%2F&profile=css3&usermedium=all&warning=1&vextwarning=&lang=en|CSS validation http://tiki.org/]: 91 errors, 180 warnings.

In Spreadsheets' overview 'List Sheets' page date for 'Created' and 'Last Modif' are the actual date, not the real dates assigned to a sheet.

See:
http://fmg-11537-4338.show.tikiwiki.org/tiki-sheets.php

It'd be nice to have the possibility (at user's choice) to watch all items created or modified by a user automatically. For example, I'd like to autowatch all bugs filed in this tracker by myself without going to my own filed report and then clicking the 'Monitor' eye symbol. And I don't want to watch the complete tracker either.

Using the method desribed in documentation [http://doc.tiki.org/Clean+URLs|http://doc.tiki.org/Clean+URLs] (__Step 2: Configure Tiki to Produce Clean URLs__): activating search engine friendly url and choosing 'lang' for 'List of Url Parameters that should go to the path', editing a translated page will lead (save or cancel edit) to a not properly recognized pathname with /xy/ in it, where xy is the two letter language code.

{syntax type="tiki" editor="plain"}
There is a mouse over pop up ''short view of events'' in calendar module. Options there are export, edit, delete or view, and finally close the pop up. It seems the value of parameter __calitemId__ is missing there.
At the calendar page's click event pop up (which shows more information) the value is correct.

{syntax type="tiki" editor="plain"}
In a calendar event's (click) pop up (not calendar module with mouse over) there is a strange behaviour with URLs:

1) If event description starts with an external link, this link is shown with name of calender, further description ommittet.

2) If event description contains an external link, the description before this link is shown, the link is shown with name "Calendar: $name_of_calendar", and further description is omittet.

Maybe the problem extends to internal links (not tested yet).

{syntax type="tiki" editor="plain"}
Edit CSS feature produces CR/LF line terminators. This increases file size.

Edit CSS feature leads to file deletion in some cases, without warning:
- resulting file is larger than approx. 5300 bytes

CSS files with special characters in comments which are not UTF-8 encoded are not displayed. Edit leads to empty template.

Testfile was a copy of arcturus.css on a Debian/Squeeze.

File deletion can not be reproduced at demo.t.o 9x and 10x.

To be able to batch upload zip file to a file gallery with the file contents of the zip files that or in order.

For example.

if creating a "how to" page with screenshots, you save the screenshots as scr01.png, scr02.png, scr03.png, scr04.png, etc following the sense of the document

When you batch upload the zip file, they are randomly unzipped or assigned a file ID.

scr01.png = FileID 04
scr02.png = FileID 02
scr03.png = FileID 01
scr04.png = FileID 03

Therefore when editing the text, instead of typing in order

click here
img fileId="01"
type blah
img fileId="02"
click Ok
img fileId="03"
Click Finish
img fileId="04"

This current process greatly reduces the efficiency of editing a page with multiple successive file/image attachments. Instead of manually typing & logically augmenting the file ID sequentially knowing that it will be the next screenshot in order, you have to do several mouse clicks to chose the correct image/file, if you have a zip file with a hundred or so screenshots, this task becomes extremely burdensome.

I created a file gallery in my tiki installation and set all php *upload_size* etc. parameters in my .htaccess correctly. According to these parameters I can upload files up to a size of 8 MByte, which works without any problem, if I do this directly from the file gallery.

Now I try to use this file gal in a tracker via the tracker field "file". Everything seems to work well, uploads are shown with a progress indicator from 0 - 100%. But uploading quietly fails for files larger than 600 kByte.

The files are shown in the gallery, but on the server they have a size of 0 (zero) Bytes, files smaller than approx. 600 kByte work well.

To point it out, the problem is only existent from within a tracker using the new drag and drop (html5??) interface. With an older Internet Explorer, which does not show the progress indicator, uploading works well from within a tracker, too.

I cannot find a reason or a solution...thanks in advance...

Images uploaded to tracker field image do not respect multitiki paths.

When you upload an image to this type of field, they go to

__img/trackers/__

When you are in a multitiki of, let's say, site1.example.com and site2.example.com, you have a folder for site1 at:

__img/trackers/site1.example.com/__

but your image files don't get uploaded there, but to the general

__img/trackers/__

And the same with all the other multitiki sites.
When you want to backup files, or migate a site to a new server, you are in trouble to know which files belong to which site from the multiki installation.

For consistency with how multitiki works, they should be uploaded to, and used from, the multitiki-aware path:

__img/trackers/site1.example.com/__