Category: Trackers

Using 1.10cvs code from mid june 2007

I created several trackers. Enabled RSS for individual trackers. Created rss modules for two individual trackers (rss 1 and rss 2).
Granted common permissions for anon. (view, ...), and most tracker permissions for Registered group.

Added a call to rss plugin within a wiki page:
{CODE()}
{rss id=1}

{rss id=2}
{CODE}

When viewing the page as registered, I see:

^
Tiki RSS Feed Error Message: Permission denied you cannot view this section
^

Did I miss any special perm to be granted for registered? A bug?

(I granted all perms from tracker section - to them, or inherited from anonymous - except for tiki_p_admin_tracker)

Reported first Using 1.10cvs from mid June 2007. Reviewed and confirmed goal is still legitimate in Jan 2022 (15 years later).

The tracker field "subscription" should include an option to automatically send a notification message to them item autor (and "watchers" of the item, maybe?)

Because subscription field is very useful also in letting people show interest in whatever you offered or requested in a tracker, and might be an easy way to let users get in contact related to that offer or demand... etc.

Thanks Guilles for your nice contributions to Tiki code! :-)

An admiror of yor work, as ((tw:Sylvie)) once said... (:wink:)

1.10 (using cvs from Sept 9th, 2007): TRACKERFILTER not working for me (Unknown column 'Array' in 'where clause')

To reproduce, try selecting any field for the tracker filter here:
[http://www.moviments.net/intercanvisarxius/tiki-index.php?page=cercador+ofertes]

It produces:
{CODE(wrap=>1,wiki=>1)}
An error occured in a database query!

Context:
File tiki-index.php
Url tiki-index.php?page=cercador+ofertes
Query:
^
SELECT tti.*, ttif.`value`, ttf.`type`, tti.`lastModif` 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`) INNER JOIN `tiki_tracker_item_fields` ttif0 ON (ttif0.`itemId` = ttif.`itemId`) INNER JOIN `tiki_objects` tob13 ON (tob13.`itemId` = tti.`itemId`) INNER JOIN `tiki_category_objects` tco13 ON (tob13.`objectId` = tco13.`catObjectId`) WHERE tti.`trackerId` = ? and (`status`=? or `status`=? or `status`=?) AND ttif0.`fieldId`=? AND tob13.`type` = 'tracker 2' AND tco13.`categId` IN ( 0 ,? ) GROUP BY tti.`itemId` ORDER BY `sortvalue` desc
^
Values:
0 2
1 o
2 p
3 c
4 13
5
Message:
Unknown column 'Array' in 'where clause'
Builded query was probably:
^
SELECT tti.*, ttif.`value`, ttf.`type`, tti.`lastModif` 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`) INNER JOIN `tiki_tracker_item_fields` ttif0 ON (ttif0.`itemId` = ttif.`itemId`) INNER JOIN `tiki_objects` tob13 ON (tob13.`itemId` = tti.`itemId`) INNER JOIN `tiki_category_objects` tco13 ON (tob13.`objectId` = tco13.`catObjectId`) WHERE tti.`trackerId` = '2' and (`status`='o' or `status`='p' or `status`='c') AND ttif0.`fieldId`='13' AND tob13.`type` = 'tracker 2' AND tco13.`categId` IN ( 0 ,'Array' ) GROUP BY tti.`itemId` ORDER BY `sortvalue` desc
^
{CODE}

It was happening like that with code from months ago, and that's why I've tried today with updated code from cvs HEAD, plus upgrading db using tiki_1.9to1.10.sql script.

---
Fixed the 10/9/07

Using 1.10cvs from mid june 2007

I'm using the "Admin > login > Use tracker for more user information"
Created a simple tracker, with some fields, including the "username" field, but not the email, right now, since that was already introduced in the first registration screen.

2 improvements would be needed/very welcome:

(1) Username was not assigned to the item in the user tracker, even if the user had selected a username in the previous screen (first registration screen - tiki-register.php).

(fyi: later on, When I, as a registered user, edited my item afterwards, the username info was well selected automatically).

(2)
This user info tracker (tracker id 1) had those fields:
^
~pp~
Id position name type options isMain Multilingual Tbl vis Searchable Public Hidden Mandatory Description
1 edit 10 Nom text field 1 y n y y y n y Nom de la... remove down
2 edit 20 Cognoms text field n n y y y n y Cognoms de... remove down
3 edit 30 Usuari user selector 1 y n y y y n y Nom... remove down
4 edit 40 Telèfon text field 1,50,,,50 n n n y y n n Telèfon/s... remove down
5 edit 50 Correu-e email 1 n n n y y n n Correu-e... remove down
6 edit 60 Barri / Població textarea 1,50,10,1000,1000 n n n y y n y Barri i... remove down
7 edit 100 Foto image 80,80,400,400,400 y n y n y n n Fotografia remove down
8 edit 200 Comentaris textarea 1,50,10,1000,1000 n n y n y n n La teva... remove down
~/pp~^

At "Admin > login > Displays UserTracker information in user information page. Format: trackerId, fieldId1, fieldId2, …:", these was the field content:

^
1,1,2,4,6,7,8
^

I also tried includind field 3 - the user selector - (i.e.: 1,1,2,3,4,6,7,8), but similar effect: I couldn't see the username shown in the second screen, and It was not set on the tracker (confirmed as admin user)

Using 1.9.cvs and 1.10cvs from mid June 2007

Module last_tracker_items reports no results, but there are many tracker items inserted, in several trackers.

Tested here:
http://www.moviments.net/valldelcorb/tiki-index.php?page=prova2 (1.9.7cvs)
http://www.moviments.net/valldelcorb/trackers

http://www.moviments.net/intercanvis/tiki-index.php?page=HomePage (1.10cvs)
http://www.moviments.net/intercanvis/trackers


Btw, will it be possible to filter tracker item results in last_tracker_items by tracker id, passing it as argument to the module? (that would be great! :-)

----
UPDATE 9th july 2007:
Sylvieg, it still doesn't work as expected: I updated code from today 9th july 2007 at the 1.9.x site, and then it requested the params. missing (name and trackerID).

I modified the module call like this:
{CODE()}
{MODULE(module=>last_tracker_items,trackerId=>2,name=>Ofertes,status=>opc,nonums=>0)}{MODULE}
{CODE}
and now it shows an empty list:
http://www.moviments.net/valldelcorb/tiki-index.php?page=prova2 (1.9cvs)

Btw, it's a site with __Trackers with mirror tables__. If it's a config problem, then some lines are needed at:
http://doc.tikiwiki.org/Module+last_tracker_items

We can already send in content to Tiki via email:

add/edit wiki
add articles
via tiki-admin_mailin.php

and add forum posts via
tiki-admin_forums.php

I would like to be able to add tracker items or a newsletter via email.

Related: http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=999

If Trackers had the "tracker template" feature, it would allow for better pre-made extended features for Tiki at install time.
In tw.o forums, some people requested like: address books (imagine with the same basic fields as Mozilla Thunderbird & Evolution, etc. address books, ... Export from you local program (through csv), and import to your address book in Tiki (through csv).

The same for "Offers & Demands (linked or linkable)", that many people/communities would like to use like "out of the box" feature. I do have that kind of trackers made (basic, but working for production already: http://valldelcorb.org/trackers - http://valldelcorb.org/Comparteix (1.9.x) or http://intercanvis.net (1.10.x) using tracker plugins in a general Wiki page).

Since duplicate tracker is already coded in 1.10, and templates concept already exists in Tiki, Tracker templates would be a nice MUST in the MID and LONG run.

Tracker templates should be selectable at install time (in the new installer devs. are thinking/designing -> ((Install)) ), or at a later stage through Mods, maybe?

After 12.0 has been released (using r48863 in dev.t.o): First edit of a Tracker item comment is LOST (!); second attempt is saved successfully, it seems.

Reproduced twice in http://dev.tiki.org/tiki-view_tracker_item.php?itemId=5019&cookietab=2

* I edited the comment entitled "Licensing issues have NOT been resolved yet, some code needs to be rewritten":
+ http://dev.tiki.org/tiki-comment-edit?type=trackeritem&objectId=5019&threadId=3572

* I added at the begining this content (the one surrounded by QUOTE tags):
+ {CODE()}
{QUOTE()}
Now that licensing issues have been resolved, please move to the main code base.
{QUOTE}
{CODE}
+ I clicked at SAVE. Tiki refreshed the page as usual as if the comment was saved, but the content was not updated. Visiting again the page confirmed that the edition was not saved. Doing a second edition, saved that change successfully.

And I reproduced the same issue a few minutes later with another comment to the same tracker item:

* I edited the comment entitled "See r48864 from mods":
+ http://dev.tiki.org/tiki-comment-edit?type=trackeritem&objectId=5019&threadId=3574

* Changed "NEED REWRITING" with "NEEDS REWRITING", clicked at SAVE. Tiki refreshed the page as usual as if the comment was saved, but the content was not updated. Visiting again the page confirmed that the edition was not saved. Doing a second edition, saved that change successfully.

---
I wonder whether this might be considered a Blocker... I don't tag it as such myself, but feel free to add if you consider that it deserve that category also (unsure myself). {sign user="xavi" datetime="2013-12-01T10:36:09+00:00"}
---
Apparently, a duplicate of http://dev.tiki.org/item5007
(even if the title there was missleading to me) {sign user="xavidp" datetime="2013-12-01T16:59:45+00:00"}
---
Still reproduced here in dev.t.o, with a version from 20 January, 2014 16:44:28 CET- REV 49469. {sign user="xavi" datetime="2014-01-21T17:54:28+00:00"}
---
I removed the "duplicated" tag, since the other item is solved ( http://dev.tiki.org/item5007 ), but not this one.

See the associated show.t.o instance.

I created a site using trunk (future 14.x), applied a profile which created a long tracker (160+ fields), with long field names, etc.
When I tried to export a single file from the tracker, I get in a Tiki 12.x installation:
^
Request-URI Too Large

The requested URL's length exceeds the capacity limit for this server.
^

And if I try to do the same with trunk(Tiki14), I get the screen converted into a semi-transparent blackish window, as if something was to be shown, but the user can't see anything happening. Just no message, no tracker definition exported, etc.

See it reproduced here:
# Log in here: http://xavi-9794-5536.show.tikiwiki.org
** u: admin
** p: 12345
# Go to tracker fields:
+ http://xavi-9794-5536.show.tikiwiki.org/tiki-admin_tracker_fields.php?trackerId=1
# Select one (for instance, id 5, which is short and has no commas in the name, etc).
# Go down to the dropdown field at the bottom, and select "Export selected", and click at "Go".
** No field definition is exported.

I created a profile long ago to test nested tracker demo.
I applied it, and when reviewing the created tracker items, this is the error I get in a quite white screen (css broken):

^
Fatal error: Call to a member function getField() on a non-object in /var/www/12.x/lib/trackers/trackerlib.php on line 726
^

I've reproduced it in show.
u: admin
p: 12345

Visit this url:
http://xavi-9794-4888.show.tikiwiki.org/tiki-view_tracker.php?trackerId=2

---
The error comes from a defective profile, as I'm seing right now. However, it would be much nicer if there a more informative type of error reporting to the user that there is some syntax problem in the field definition, etc.

12.x html code embedded in a tracker item field text-area-with-wysiwyg lost after edition

See it in action here:
http://xavi-9794-5186.show.tikiwiki.org/tiki-view_tracker_item.php?itemId=1

u: admin
p: 12345

Code added (without the code plugin tags):

{CODE()}
{HTML()}<iframe src="http://www.slideshare.net/slideshow/embed_code/33417641" width="427" height="356" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" style="border:1px solid #CCC; border-width:1px 1px 0; margin-bottom:5px; max-width: 100%;" allowfullscreen> </iframe> <div style="margin-bottom:5px"> <strong> <a href="https://www.slideshare.net/xavi/140413-fs-cat2014xavierdepedroconeixementlliure" title="Hack-tivisme amb eines i continguts alliberats: beneficia-te&#x27;n!" target="_blank">Hack-tivisme amb eines i continguts alliberats: beneficia-te&#x27;n!</a> </strong> from <strong><a href="http://www.slideshare.net/xavi" target="_blank">Xavier de Pedro</a></strong> </div>{HTML}
{CODE}

After edition of that tracker item:

http://2014.forumsocialcatala.cat/item11

...in field: "Presentations", with wysiwyg enabled, the html code was lost, and only the non html code is present (converted to wiki) with the surrounding html plugin tags.

{CODE()}
{HTML( wiki="0")}__[https://www.slideshare.net/xavi/140413-fs-cat2014xavierdepedroconeixementlliure|Hack-tivisme amb eines i continguts alliberats: beneficia-te'n!]__ from __[http://www.slideshare.net/xavi|Xavier de Pedro]__{HTML}
{CODE}

(I had to add the html code again)

Plugin TrackerList accepts these params: filterfield & filtervalue
( see https://doc.tiki.org/PluginTrackerList )

In Tiki11 they still work fine. In Tiki12, they found nothing. See reproduced example in show.t.o; basically, applying the Bug_Tracker profile and changing the plugin tracker list code to something like:

{CODE()}
{trackerlist trackerId="1" fields="1:2:4" showlinks="y" popup="3" status="opc" filterfield="1" filtervalue="bug"}
{CODE}

Credentials for show.t.o:
u: admin
p: 12345
---
Update: Fixed, thanks! {sign user="xavi" datetime="2013-11-16T17:37:30+00:00"}

{flash type="url" movie="display554" width="677" height="443"}

PluginTrackerCalendar (fullcalendar resourceviews) stopped showing events when the Unified Search Engine is set to "Lucence (PHP)" (even if index is rebuilt).

There is a profile used to test the TrackerCalendar feature, where we could easily reproduce the expected behavior with PluginTracekrCalendar since Tiki10.

Applying that profile "((pr:Tracker_as_Calendar_10))" to current Tiki12 fails to show the events in the calendar widget anymore.

That is currently even more visible since that feature was added to one of the Featured profiles: "Collaborative Community_12x".

In short it will be reproduced in a show.t.o instance:
u: admin
p: 12345

Go to http://xavi-9794-5132.show.tikiwiki.org/tiki-index.php?page=Tracker_as_Calendar_10
and you will see that issue reproduced.

This was working in Tiki9, as far as I know.

12.x: profile data defined for item link field do not get stored in local tiki where profile was applied

Example: apply profile "Time_Sheet" ( https://profiles.tiki.org/Time_Sheet ), and notice that items "Watch TV" or "Setup of Tiki TimeSheet" had defined "General" in the field "Associated project", which is an item link field.

The field seems to have been well defined, since it allows the admin (once the profile has been applied) to edit a tracker "Time Sheet" item, and select the project from the drop down list (so far it only contains "General").

To be reproduced in short in a show.t.o instance associated with this item.
http://xavi-9794-4983.show.tikiwiki.org/tiki-view_tracker.php?trackerId=2
u: admin
p: 12345

Registration from within PluginTracker does not create a new user. (it has a field called "registration", which then shows the registration fields in the tracker form)

The same process from the registration script does work (user created, and item in user tracker created also).

Reproduced in the show instance:
u: admin
p: 12345

Add a new item through the Plugin Tracker, and the new user is not created, just the tracker item:
http://xavi-9794-5098.show.tikiwiki.org/tiki-index.php?page=Inscripcions&cookietab=2

Add a new user (and tracker item) through the registration form, and the user and tracker item are created successfully:
http://xavi-9794-5098.show.tikiwiki.org/tiki-register.php

The contents from the Tracker comments tab is not shown here in dev.t.o (using 12.x)

Clicking at the button "notabs" doesn't help either.

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

13.x dev.t.o: Print version for tracker item almost empty

Untested in trunk yet.
To reproduce, see a tracker item, such as:
http://dev.tiki.org/item5294

And see the printer-ready version of that item:
http://dev.tiki.org/item5294?print=y

Only this is shown:
{CODE()}
12.x & 13.x: Comments can't be posted (12.x) nor edited (12.x, 13.x) when codemirror is switched on (or 'disabled but switchable')


The original document is available at http://dev.tiki.org/item5294
{CODE}

13.x dev.t.o: Print version for tracker item almost empty

Untested in trunk yet.
To reproduce, see a tracker item, such as:
http://dev.tiki.org/item5294

And see the printer-ready version of that item:
http://dev.tiki.org/item5294?print=y

Only this is shown:
{CODE()}
12.x & 13.x: Comments can't be posted (12.x) nor edited (12.x, 13.x) when codemirror is switched on (or 'disabled but switchable')


The original document is available at http://dev.tiki.org/item5294
{CODE}

When visiting: https://dev.tiki.org/Trackers

The list of Pending & Closed issues appears, but not Open

{CODE(caption="The code is the same for all three")}!!Open
{wishes filtervalue="28" status="o"}

!!Pending
{wishes filtervalue="28" status="p"}

!!Closed
{wishes filtervalue="28" status="c"}{CODE}

{img fileId="815"}

'Add an item' for tracker field 'item link' does nothing when field displayed as multi select.

See it reproduced here:
http://xavi-9794-5317.show.tikiwiki.org/tiki-ajax_services.php?controller=tracker&action=insert_item&trackerId=1&modal=1

u: admin
p: 12345

::{img src="https://dev.tiki.org/display799"}::

13.x: dev.t.o fivealive-lite.css: images can't be uploaded or selected throught the toolbar icon from tracker textarea

{HTML()}
<video width="320" height="240" controls>
<source src="http://doc.tiki.org/dl1108" type="video/webm">
Your browser does not support the video tag.
</video>
{HTML}

{WEBDOCVIEWER(url=>http://doc.tiki.org/dl1108, width=>425, height=>350)}{WEBDOCVIEWER}

See: http://doc.tiki.org/dl1108

__140713_dev.t.o_13.x_bug_when_attempting_to_upload_or_select_image_from_textarea.webm__ - 5.69 Mb

13.x: email param from PluginTracker too difficult to get it working as expected for end users

* Maybe some more documentation in doc.t.o missing?
** param "emailformat" (indicated by a poweruser in an email) missing in the doc. page (since long ago)?
* Maybe some easier ready-to-use tpl bundled within tiki to work for that use case, if the default tracker_changed_notification.tpl doesn't work.
* Maybe some bug? (some devs said thatyou need to set the "copy activity to email" to something for that tracker to get those emails sent for the non-registered user submitting the tracker item?
* ...

Related doc so far:
http://doc.tiki.org/PluginTracker#Parameters (see "email" param)

An instance has been created linked to this wish, so that we can all have a look at a common instance to elucidate what the problem is, and then, as a consequence, how to improve it.

Instance design details:
# Feature Log mail in the tiki logs is enabled, so that we can check which emails were sent and which ones weren't.
+ http://xavi-9794-5470.show.tikiwiki.org/tiki-syslog.php
# "Contact us" page contains PluginTracker with this code:
+ {CODE(ln="1")}
{TRACKER(trackerId=1, fields=1:2:3:4, showmandatory=y, emailformat="html", sort="y",
email="real_email_from@example.com|3,a_second_real_email@example.com|tracker_changed_notification.tpl,tracker_changed_notification.tpl")}
!!! Thanks
...{TRACKER}
{CODE}
# Field 3 is the user selector, with "plain text" as the type of link.
# tracker_changed_notification.tpl is a valid tpl in the file tree, so I guess this should be a valid-enough file for basic demostration purposes, unless someone indicates the opposite for some reason.
# "Copy activity to email" has been set to a_third_real_email@example.com, just in case that was valid, as jonnyb suggested.


To reproduce:
# Come here as anon:
+ http://xavi-9794-5470.show.tikiwiki.org/tiki-index.php?page=Contact+us
+ and fill in the contact form, which is set to (in theory) send you a copy of the tracker item added.
# go to the tiki logs ([http://xavi-9794-5470.show.tikiwiki.org/tiki-syslog.php]) and you will that the email that has been sent is the one related to "Copy activity to email" ("a_third_real_email@example.com", xavi (a) tikiwiki.org in this case), but nothing else related to the email typed in the form (field 3) nor the "a_second_real_email@example.com" indicated in the param)


Finally, some hint (in case it matters):
* I tried first this approach in my localhost (linux box), and I got same behavior.
** Looking at the apache error log I saw a message complaining that I didn't have "sendmail", which is true (in purpose, for other reasons)
++ {CODE()}
sh: 1: /usr/sbin/sendmail: not found
{CODE}
** The curious thing is that those cases of error with sendmail were not recorded in tiki syslog as "mail error" lines, but nothing was loged. Only the email related to "copy activity to email" was recorded in the tiki syslog with at least a line saying "mail error", and all the details about that email.