Category: 2.x

ON aVersion 2.2 installation on a Windows server.

When I use the WYSIWYG editor and select the insert internal link icon, the window appears titled "Tiki Link - insert internal link" and the squares indicating loading are blinking, but it hangs (and does not bring up the list of links).

The topic says it all. I am running SLES Linux 10 for wiki host and with MySQL on a Netware box on the back end. MySQL Version 4.0.26a over TCP/IP.

I hope this helps.

No XML RPC interface for Wiki

When saving a Smarty template for a specific theme using the TikiWiki admin GUI then all kinds of fake tags </x> are inserted in javascript.
It seems that the XSS filter is hitting here. It should not since it is a super-admin function and should not be XSS-filtered, of course.

I tried to edit tiki-editpage.tpl when this occured.

At http://tikiwiki.org/TikiWikiTV, the YOUTUBE plugin is being used, but the videos aren't displaying. A look at the finished page source shows that the movie src url is partially repeated, so broken. (The url in the page edit is the correct form, so then gets broken.) For comparison, the FLASH plugin works ok on that page, with no url distorting.

This is best explained with an example:

~pp~
Paragraphs are parsed

just fine here

{TAG(tag=ul)}foo{TAG}

but now

paragraphs and

line breaks aren't working!
~/pp~

This only happens for tag=ul, not even for tag=ol.

This happens regardless whether wiki paragraph formatting is enabled and regardless of whatever is inside the ~np~{TAG(tag=ul)}~/np~, even ~np~{TAG(tag=li)}~/np~'s.

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.

I think $exatvalue maybe should be $exactvalue

[r@s tw]# grep -nR exatv *
lib/wiki-plugins/wikiplugin_trackerlist.php:262: $exatvalue = array($exactvalue, $user);

[r@s tw]# head lib/wiki-plugins/wikiplugin_trackerlist.php
<?php
// $Id: /cvsroot/tikiwiki/tiki/lib/wiki-plugins/wikiplugin_trackerlist.php,v 1.40.2.12 2008-03-22 12:13:54 sylvieg Exp $
//

Using 1.10 cvs from mid september 2007. Using hec.css theme

At admin > login > Users Defaults, I've set
^
-=My Tiki=-
My pages V
My galleries
My messages V
My items V
^

Example of user page viewed by another user or anonymous:
http://intercanvis.net/tiki-user_information.php?userId=20

Issues:
# Wiki pages ("Pàgines del wiki") are wrong: they are not from that user (confirmed, even if you cannot see history on pages on that site)
# "My items" shoud show, at least, some items added by that user:
+ [http://intercanvis.net/tiki-view_tracker.php?trackerId=3&status=op&sort_mode=lastModif_desc&filtervalue%5B25%5D=&filtervalue%5B43%5D%5B%5D=6&filtervalue%5B43%5D%5B%5D=45&filtervalue%5B43%5D%5B%5D=7&filtervalue%5B43%5D%5B%5D=44&filtervalue%5B43%5D%5B%5D=8&filtervalue%5B43%5D%5B%5D=5&filtervalue%5B43%5D%5B%5D=55&filtervalue%5B26%5D=&filtervalue%5B28%5D=Anna&filtervalue%5B44%5D=y&filterfield=28&filter=Filtra|2 on one tracker]
+ [http://intercanvis.net/tiki-view_tracker_item.php?itemId=38&trackerId=2|and one on another tracker]

Forum messages are shown ok.

Using 1.10cvs from August 1st, 2007.
On easyphp-1.8 environment (thus, Window$ XP)

Steps I did:
* updated cvs code
* called tiki-install.php to create a new clean install over an old tiki110cvs databse (assuming it deletes all tables and re-creates them as needed), using basic profile for easy use
* installation says eveything ok, no sql queries failed.
* login to new site as admin/admin
* change password to another string (simple string with only letters, between 6 and 8 chars. in all my attempts)
* after password is changed, error produced:
** I cannot login to the site. Using the right admin/pass., I see the homepage again as anonymous (so I'm not logged in).
** If using a wrong pass, I see the user/pass error message.

Tried reinstalling several times with different passwords, no success.
* the funny thing is that the new admin pass. seems to be recorded ok, since I can re-access the tiki-install.php using that new admin password.

Freetags would be very nice on other Tiki objects, specially Tracker items, in order to make Tiki more 2.0 compliant... (and since trackers are used by users, which not always find their natural cateogries in the pre-fixed categories by an admin system in Tiki (through categories feature)

Using 1.10cvs from mid June 2007.

This problem is on at: http://moviments.net/intercanvis

User tracker is on, it's created and working (at registration time everything is ok and working, user sets new data for the user tracker info before ending registration, etc.). Well, at least for Registered users.

This morning I went (as a user with admin privileges) to User Preferences screen > Personal information > Your personal tracker information: "View extra information" (link to [http://www.moviments.net/intercanvis/tiki-view_tracker_item.php?view=+user] ),

but at that link I get this message:

^
-=ERROR=-
No tracker indicated
Go back
...
^
This user belongs to Admins, Editors and Registered groups, but has no one defined as default.
When defined a default group (Registered, the only one with user tracker defined), the link worked.

Using 1.10cvs from mid june 2007

I created a new tracker, with this option activated:
^
"Item creator can modify his items?
The tracker needs a user field with the option 1"
^

Then, I added many fields, and one of them, of course, user field with option 1, marked as compulsory.

As registered user, I created a new item. Ok.
I atempted to edit the item, and after cliking on save, I get the message that I need to select a user (or some similar text).
This should'nt happen, since the user field should be selected and prefilled by default either from the previous selection, or from the user id.

That's the server, tracker and item:
[http://www.moviments.net/intercanvis/tiki-view_tracker_item.php?itemId=2&show=view&status=o&trackerId=2&sort_mode=lastModif_desc]

I have unselected the compulsory checkbox for this field to make it work (but the bug is still there, if selected to be compulsory)

If using tabs, after creating a tracker, the user should be directed to the form of listing trackers ("Trackers" tab), and not remaining at the "Create trackers" tab, as it does right now, since the normal procedure after creating a tracker is either granting it with local perms of just creating fields for that tracker (so that you need to see the "action columnn" in the table at "Trackers" tab.

Using 1.10 cvs from mid june 2007

To reproduce:
# Create a new tracker with Google map field, plus other fields, on a tiki site created with basic profile for easy use.
# Log in as registered user (not admin)
# Insert an item (as registered).
# Edit the item, to click to "Google map locator" to geolocate the tracker item
# After cliking on the map (so that having coordinates and zoom for this item), you click on "Save clicked point" button
+ After that, you see on top: "OKOK", and the Google Map locator again.
"The OKOK" message should be removed, and I suggest that the user is automatically taken back to the tracker item after clicking on the "Save clicked point" button

Using recent 1.10 (end of november'07):
today December 8th 2007 I've set a new event at a calendar:
http://intercanvis.net/tiki-calendar.php?todate=1197068400

If you view this calendar as anonymous you see the correct date in both places:
# Focus: Dissabte 08/Desembre/2007 (08/12/07, Saturday)
# Cel (current and focus) date: 12/08

However, if you login as plain registered user, this same url:
http://intercanvis.net/tiki-calendar.php?todate=1197068400

...it takes you to: "Focus: Friday 07/December/2007" (user abel, for instance), which is wrong: it should be 08/Desembre/2007

And if you login as user with admin rights (user Xavi) , the same url shows:
# Focus: Dissabte 08/Desembre/2007 (08/12/07, Saturday)
# __BUT Cel (current and focus) date shows__: 12/07,
+ which is wrong: it should be 08/Desembre/2007
+ (if you click at teh event view, the date is set right: 08/12/07)
-----
Further Update:
This is kind of weird: I had prefference for new users as "site default", and site language was either English or Catalan, amnong the few allowed languages for users.
I checked language of user "abel", and it had "Arabic" (which was not among the pre-selected as available for users).

I changed default language for all users as Catalan, and ensure the only Catalan, Spanish, English and French were allowed. Then, again, tried viewing this date:
http://intercanvis.net/tiki-calendar.php?todate=1197068400

with user "usuari", which has language selected to English: date in calendar is shown fine.
# Focus: Dissabte 08/Desembre/2007 (08/12/07, Saturday)
# Cel (current and focus) date: 12/08

However, if I login as user "abel" (with Catalan interface), weird change in date shown is produced:
# Focus: Dissabte 08/Desembre/2007 (08/12/07, Saturday)
# Cel (current and focus) date: 12/07 __1 day less than it should__

I can enable an account there for any admin who want to track/hunt this bug, if needed.

Geolocating tracker items (through Google maps) are not working anymore, but they were before.

Using recent 1.10 update (from end of november or so) nowadays.
Example:
[http://intercanvis.net/tiki-view_tracker_item.php?itemId=2&trackerId=2&show=view]

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?

When posting to a forum in 1.10cvs (from mid june 2007), if you preview your post, you cannot see by default the html form to edit your content again. If you press on "new topic", the form opens with your content... (but it should be shown by default, as in previous releases)

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)

1.10: several module plugins in a wiki page show the same title for all of them (from the first call in the page)

Using 1.10cvs from mid june 2007

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