Category: ~Trackers (mirror)

{syntax type="tiki" editor="plain"}
Two person need to work on a tracker entry. Some fields are only editable byan admin, the others can be handled by registered users. When I now add data in the defined tracker fields as an admin, everything is fine.

Now the registered user takes over the case, wants to update/change the fields he has to. So far everything looks fine, he only can edit the one he has access to but as soon as he wants to save it, the fields only editable by the admin suddenly disappear:

[http://www.duenasworld.com/tikiwiki/one.jpg|before]
[http://www.duenasworld.com/tikiwiki/two.jpg|after]


Maybe it is on purpose designed like this, but then I just would not get the logic behind it.

If you use the tracker with mirror, when creating the fields, you cannot save any comments, options, descriptions. You have to do it directly in the Database, then it works.

If you use the tracker without mirror, it works just fine.

- Use mirror tables for trackers
- Create a tracker
- Create an item (default status open).
- It gets shown correctly in the list view
- click on the item -> status is shown as "pending"

It behaves this way only with mirror tables!

I've got this error while attempting to insert data in a tracker with mirror tables from a Wiki page through wikiplugin_tracker.php.

In fact, the wiki page return an error message, and it seems as if item was not inserted, then, but item is inserted. However, the field "user" (login user, 1) is not saved in the tracker (and I was logged in, and I could insert a tracer item from the same user account through the tracker directly).

Note: Tracker has less than 40 fields, and I included 40 consecutive field ids in the plugin syntax.

That's the code in the wiki page:
{CODE()}
{TRACKER(trackerId=>1,fields=>1:2:3:4:5:6:7:8:9:10:11:12:13:14:15:16:17:18:19:20:21:22:23:24:25:26:27:28:29:30:31:32:33:34:35:36:37:38:39:40,action=>Name of submit button,showtitle=>y,showdesc=>y,showmandatory=>y,embedded=>y)}Ben fet!{TRACKER}
{CODE}

Thant the error message:
{QUOTE()}Notice: Undefined index: name in /var/lib/gforge/chroot/home/groups/gclub/htdocs/carpetiki/lib/wiki-plugins/wikiplugin_tracker.php on line 138

Warning: mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '='prova4' where `itemId`='5'' at line 1 in query:

update tiki_trk_1 set =? where `itemId`=?


in /var/lib/gforge/chroot/home/groups/gclub/htdocs/carpetiki/lib/tikidblib.php on line 154

Warning: fread(): Length parameter must be greater than 0. in /var/lib/gforge/chroot/home/groups/gclub/htdocs/carpetiki/lib/cache/cachelib.php on line 47
{QUOTE}