Category: Wiki Plugin (extends basic syntax)

Between Tiki2 and Tiki3, behavior of PlginFile changed, and is causing "No such attachment on this page" errors

http://www.google.com/search?hl=en&q=%22No+such+attachment+on+this+page%22+site%3ATikiwiki.org&aq=f&oq=&aqi=

Problem 1:
I created a Wiki page containing the following:

{img src=images/code.png}%%% {CODE()} {THUMB(id=5)}{THUMB} {CODE}

If I select Preview while in edit mode, the thumbnail is displayed, and placing the mouse cursor over thumbnail displays the fullsize image. After the page is saved and displayed, moving the mouse cursor over the thumbnail does not display the fullsize image.

Problem 2:
I created a Wiki page containing the following:

{img src=images/code.png}%%% {CODE()} {THUMB(image=>img/wiki_up/someimage.jpg)}{THUMB}
{THUMB(id=5)}{THUMB} {CODE}

If I select Preview while in edit mode and move the cursor over the first thumbnail, no fullsize image is displayed. If I move the cursor over the second thumbnail, the fullsize image corresponding to the second thumbnail is displayed. If I then move the cursor back over the first thumbnail, the fullsize image corresponding to the second thumbnail is displayed.

Using 1.10cvs from mid june 2007.
Plugin Tracker Filter doesn't find items (it is working fine for me in 1.9.x sites).
Example:
[http://www.moviments.net/intercanvis/tiki-pagehistory.php?page=Cercador%20ofertes&preview=1]

Related to [http://www.moviments.net/intercanvis/tracker2]

If any coder interested in taking care of this bug, send me a message and I'll manage an admin account there for you to look at or play with the configuration of the tracker, plugin, if needed.

Using 1.10cvs from mid June 2007

I'm using this code in here:
[http://www.moviments.net/intercanvis/Ofertes]

{CODE()}
!! 1.1. Oferiments de __Cursos__
{TRACKERLIST(trackerId=>2,fields=>9:12:20:11:19, showtitle=>n, showlinks=>y, showdesc=>n, showinitials=>y, showstatus=>y, status=>opc, max=>20, filterfield=>42, filtervalue=>, exactvalue=>6, goIfOne=>n)}Com????{TRACKERLIST}

!! 1.2. Oferiments d'__Habitatge__
{TRACKERLIST(trackerId=>2,fields=>9:12:20:11:19, showtitle=>n, showlinks=>y, showdesc=>n, showinitials=>y, showstatus=>y, status=>opc, max=>20, filterfield=>42, filtervalue=>45, exactvalue=>45, goIfOne=>n)}Com????{TRACKERLIST}
{CODE}

In the three cases cases I get
"incorrect filterfield"

Which I don't know why, since i follow indications at:
[http://doc.tikiwiki.org/PluginTrackerList]

I've tried with many more variants, just in case, with the same result (incorrect filterfield):
{CODE()}
{TRACKERLIST(trackerId=>2,fields=>9:12:20:11:19, showtitle=>n, showlinks=>y, showdesc=>n, showinitials=>y, showstatus=>y, status=>opc, max=>20, filterfield=>42, filtervalue=>6, exactvalue=>6, goIfOne=>n)}Com????{TRACKERLIST}

{TRACKERLIST(trackerId=>2,fields=>9:12:20:11:19, showtitle=>n, showlinks=>y, showdesc=>n, showinitials=>y, showstatus=>y, status=>opc, max=>20, filterfield=>42, filtervalue=>6, exactvalue=>, goIfOne=>n)}Com????{TRACKERLIST}

{TRACKERLIST(trackerId=>2,fields=>9:12:20:11:19, showtitle=>n, showlinks=>y, showdesc=>n, showinitials=>y, showstatus=>y, status=>opc, max=>20, filterfield=>42, filtervalue=>*, exactvalue=>6, goIfOne=>n)}Com????{TRACKERLIST}

{CODE}
In this tracker, field 42 is a category (id2), which has some more subcategories inside:
http://www.moviments.net/intercanvis/tiki-admin_categories.php?parentId=2

Categ 6 and categ 45 are subcategories of it.

Tracker 2, has many fields, but 2 examples for the "incorrect filterfield" behavior are:

^~pp~
Id posit name type options isMain Multil. Tbl vis Search. Public Hidden Mandat. Desc.
11 edit 30 Cursos category 6 n n n y y n n
16 edit 35 Habitatge category 45 n n n y y n n ~/pp~^

However, if I don't set any filterfield nor exact value, then I can list all items without problem.(but no pre-filtering). Example:
{CODE()}
{TRACKERLIST(trackerId=>2,fields=>9:42:12:20:19, showtitle=>n, showlinks=>y, showdesc=>n, showinitials=>y, showstatus=>y, status=>opc, max=>20, filterfield=>42, filtervalue=>, exactvalue=>, goIfOne=>n)}Com????{TRACKERLIST}
{CODE}

Some bug around filterfield param when using categories?

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

Contributors

Since upgrading dev.tikiwiki.org the "submitted by" is not recorded in bug reports

Can not reproduce the problem. Can you give an url ?
This url http://dev.tikiwiki.org/tiki-view_tracker_item.php is working for me

1- Go here as anonymous:
http://dev.tikiwiki.org/Upcoming+Events

2- Click on a link

You are requested to logon even though Anonymous has tiki_p_view_calendar permission

This was working fine in 1.9.11

But now in version 2.0, there are two permissions:

|| Can browse the calendar | tiki_p_view_calendar
Can view events details|tiki_p_view_events||