Category: Category

{syntax type="tiki" editor="plain"}
Hi,

I have set the following permissions for Anonymous

tiki_p_view
tiki_p_view_categories
tiki_p_view_categorized
etc

and the following category permissions

Anonymous tiki_p_view_categories
Registered tiki_p_admin_categories

Assign permissions automatically: Yes

Despite this neither Anonymous or Registered can view pages that have been categorized, the categories appear empty. Only way I can change this is by changing permissions on each individual page.
I've tried and tested this on 3 different installs, same problem each time. I am quite new to this but have spent many hours on this issue and would appreciate any advice.
I'm sure that there's a way but how?
Cheers

Wiki in question can be viewed at www.paddypaedia.com

Some users are using categories and sub-categories to file wiki pages.

An idea for consideration:
be able to order items within a category listing

__This feature request was accidently submitted twice.__
__Please use only [item6469]__

See here:

https://dev.tiki.org/Newsletter#Roadmap

__Per user/group newsletter administration__ based on category permission or on object permission.
* It should (shall) be possible for specified groups to provide an own group-newsletter created by a superuser, which then could (shall) be administrated by one or more specified group members / group admins whilst the newsletter admin of one group cannot (shall not) administrate or alter the newsletter(s) of another group.
* This could be accomplished by adding to the code the opportunity to categorise newsletters and to add certain admin-permissions like tiki_p_batch_subscribe_email, tiki_p_send_newsletters, tiki_p_subscribe_email, tiki_p_subscribe_newsletters, tiki_p_view_newsletter, tiki_p_list_newsletters to the category permissions (not tiki_p_admin_newsletters)
* There should be a distinction between tiki_p_admin_newsletters which includes the permission to create a new newsletter and the now not (yet) existing tiki_p_admin_newsletter which would limit admin permissions to the specific newsletter.

See here:

https://dev.tiki.org/Newsletter#Roadmap

__Per user/group newsletter administration__ based on category permission or on object permission.
* It should (shall) be possible for specified groups to provide an own group-newsletter created by a superuser, which then could (shall) be administrated by one or more specified group members / group admins whilst the newsletter admin of one group cannot (shall not) administrate or alter the newsletter(s) of another group.
* This could be accomplished by adding to the code the opportunity to categorise newsletters and to add certain admin-permissions like tiki_p_batch_subscribe_email, tiki_p_send_newsletters, tiki_p_subscribe_email, tiki_p_subscribe_newsletters, tiki_p_view_newsletter, tiki_p_list_newsletters to the category permissions (not tiki_p_admin_newsletters)
* There should be a distinction between tiki_p_admin_newsletters which includes the permission to create a new newsletter and the now not (yet) existing tiki_p_admin_newsletter which would limit admin permissions to the specific newsletter.

Permission from category are not applied for tiki_p_edit (Can edit/create pages) even if group "Default category assigned to uncategorized object edited by a user with this default group" is set.
Unless GLOBAL permission for tiki_p_edit is set (which is wrong as user of this group will be now able to create and edit any page anywhere without being locked in their category:structure).

Real life case:
I have a tiki with several section (shop, store, marketing).
I create a category for each section.
For each section i also create group of user so each each group can edit is own section only.
I set 3 structures so user can also create page in his structure/category/section.

In group preference, i set each group to have "Default category assigned to uncategorized object edited by a user with this default group" with the relevant category (group_shop to category_shop, etc).

As things should work.
If a member of group_shop create a (child) page from a page in structure_shop having tiki_p_edit checked for category_shop, tiki should understand that the new page should inherit from the same category permission (category_shop) and create/edit the page.

But this is not happening. Tiki see the new page to be create has "non-categorised" yet therefor doesn't allow the creation for a usergroup with tiki_p_edit uncheck in global permissions.

Summary: When creating a new page, tiki should check user group category permission and apply them prior the page exist (applying inheritance on a create state page - not saved yet).

Using 1.9.7, I think.

This page
[http://www.moviments.net/precarios/Comisi%C3%B3n%20Carrera%20Investigadora]

is showing categorized objects (through the usage of Plugin Category) with old names (i.e.: "foro (forum): Carrear Investigadora"), even if the forum was renamed to "Carrera Investigadora".
[http://www.moviments.net/precarios/tiki-view_forum.php?forumId=3]

Plugin List fails to find a match for the category Profiles Wizard (292) in dev.t.o

This item
https://dev.tiki.org/item6374 - "Can't apply a Profile from the Profiles Wizard! (only through profiles control panel): ticket missing?"

is categorized against category 292: "Wizards - Profiles Wizard"

This wiki page has a plugin list call to show items in this category (with equivalent syntax that it's working with no problems - apparently - in other pages in dev.t.o):
https://dev.tiki.org/Profiles-Wizard

and it fails to list that tracker item (and any others tagged against that category, if any).

Plugin List or TrackerList unable to show tracker items with category 50 (PDF) in dev.t.o
AFAIR, this used to work in previous Tiki versions (at least Tiki12 and presumably Tiki15)
See the edits I did on this page ((PDF)) :
https://dev.tiki.org/tiki-pagehistory.php?page=PDF&newver=0&oldver=17

However, in both cases, there were no results shown. There were items in the past assigned to category 50 (PDF), as shown here:
https://dev.tiki.org/cat50

See also this one added today:
https://dev.tiki.org/item6407

The "Show Child Links" option is supposed to "Show links to browse_category on the children categories. "

When enabled, there are no links for the child categories.

--Note: I tried to set up a show.tiki to demonstrate this, but only the categories directly under "top" are shown in Admin Categories. Something is wrong with the show.tiki instance.-- After logging out and back in, Admin Categories shows all the categories. The "Show Child Links" option still does not work.

I had this plugin working in Tiki9:

{CODE()}
{TRACKERSTAT(trackerId="2", fields="42", show_percent="n", show_bar="y", status="op", show_link="n")}{TRACKERSTAT}
{CODE}

Field 42 is a Category, with a few children.

It was working nicely in Tiki9.

Once upgraded to Tiki12.x svn, it stopped showing results.

If I change the field to a text field, results are shown as expected for that text field, os it seems a regression with categories.

Reproduced here:
http://xavi-9794-5261.show.tikiwiki.org/tiki-index.php?page=HomePage

u: admin
p: 12345

Tracker 1 has some items. Field 1 is title, field 3 category. No results shown for field 3.

~tc~ Reproduced also here: http://intercanvis.net/proves ~/tc~
---
Still buggy, as of April 18th, 2015 {sign user="xavi" datetime="2015-04-19T10:25:36+00:00"}

!Presentation of the category dependant objets (CategObjects template) [ENH]

This [ENH] changes a little the template to make it easily readable :

A user said "what's that ?" then I enhanced the template :
!! Separates the links to object blocks with the "|" char it could be "•" with blanks
!! Changes in style (common = layout) to separate each category concerned by the object
!! Add comments for reading clearly and understand the content and why this is displayed and how to use.

In my opinion the comments could be optional if a new feature should be introduced "help level related the user habit of using the product with dynamical ability of change"

You can see the effect on screenshots joined

Ready to commit for 6.x proposal and 7.x

!!!Changes in :
*categobjects.tpl
*language.php
*layout.css

trebly
(ref:B10125-05)

I get this error when upgrading to the latest version 1.9.3 from my current version (I checked my current version out from CVS as BRANCH-1-9).

Warning: mysql error: Unknown column 'type' in 'where clause' in query:
select `catObjectId` from `tiki_categorized_objects` where `type`=? and `objId`=?
in /var/www/html/cefn.com/cefntiki/lib/tikidblib.php on line 134

This error can be previewed (for the time being) at
http://cefn.com/cefntiki-1.9.3/tiki-galleries.php

My installation worked fine before this, except for some problem in gallery browsing - images don't show - a javascript issue I'll document separately.

So basically if I replace all files with the 1.9.3 version (gzipped tar release), and point the new installation at the database from the pre-existing installation, I get this error. I've experienced this for a while, but assumed it was because I was upgrading to the latest CVS HEAD, and that it was a transient issue (not worth filing as a bug until now - you can't miss it, as practically all page refreshes for anything with categories reveal it).

Below is a snapshot of my top level CVS/Entries file, indicating the latest versions of all files I'm currently running. Any ideas how I've got trapped with an inconsistent database setup, and what I can do about it. I don't remember doing anything fancy, except adding the <span style="color:black;background-color:#ffff66;">freetags</span> library and turning on <span style="color:black;background-color:#ffff66;">freetags</span>.

/.cvsignore/1.11/Wed May 18 10:58:51 2005//
/INSTALL/1.16/Mon Nov 7 21:42:28 2005//
/README/1.15/Mon Nov 7 21:42:28 2005//
/_htaccess/1.3/Fri Feb 17 15:10:30 2006//
/about.php/1.6/Thu Sep 8 00:55:16 2005//
/article_image.php/1.16/Thu Sep 8 01:13:15 2005//
/banner_click.php/1.9/Wed May 18 10:58:51 2005//
/banner_image.php/1.14/Thu Sep 8 01:17:55 2005//
/categorize.php/1.19/Mon Jan 16 12:31:27 2006//
/categorize_list.php/1.17/Sat Jan 21 18:51:58 2006//
/changelog.txt/1.171/Mon Dec 12 15:18:46 2005//
/comments.php/1.63/Thu Mar 16 15:58:31 2006//
/commxmlrpc.php/1.19/Thu Aug 18 16:23:04 2005//
/contribution.php/1.4/Fri Mar 10 15:24:02 2006//
/copyright.txt/1.10/Mon Nov 7 21:42:29 2005//
/copyrights.php/1.10/Thu Aug 25 20:50:04 2005//
/display_banner.php/1.15/Wed May 18 10:58:51 2005//
/favicon.png/1.3/Thu Jun 16 20:10:49 2005/-kb/
/fixperms.sh/1.7/Thu Oct 27 20:12:31 2005//
/freetag_apply.php/1.5/Sat Dec 17 19:32:51 2005//
/freetag_list.php/1.4/Sat Dec 17 19:32:50 2005//
/function.js_maxlength.php/1.8/Thu Aug 25 20:50:04 2005//
/get_strings.php/1.45/Mon Nov 7 16:20:21 2005//
/green.favicon.png/1.2/Sat Mar 12 16:48:56 2005/-kb/
/help.php/1.4/Thu Sep 8 01:33:00 2005//
/index.php/1.7/Wed May 18 10:58:52 2005//
/jhot.php/1.12/Thu Feb 16 17:42:44 2006//
/license.txt/1.2/Sun Sep 19 19:36:25 2004//
/messu-archive.php/1.4/Thu Sep 8 01:45:05 2005//
/messu-broadcast.php/1.26/Wed Nov 2 18:23:32 2005//
/messu-compose.php/1.32/Wed Nov 9 16:31:46 2005//
/messu-mailbox.php/1.18/Fri Feb 17 15:10:30 2006//
/messu-read.php/1.22/Thu Sep 15 14:52:33 2005//
/messu-read_archive.php/1.4/Thu Sep 8 01:45:05 2005//
/messu-read_sent.php/1.4/Thu Sep 8 01:45:05 2005//
/messu-sent.php/1.4/Thu Sep 8 01:45:05 2005//
/parse_tiki.php/1.6/Thu Sep 8 01:45:05 2005//
/poll_categorize.php/1.4/Thu Aug 25 20:50:04 2005//
/received_article_image.php/1.8/Wed May 18 10:58:52 2005//
/remote.php/1.3/Fri Feb 17 15:10:30 2006//
/robots.txt/1.8/Fri Jan 20 09:54:53 2006//
/select_banner.php/1.9/Wed May 18 10:58:52 2005//
/setup.sh/1.38/Fri Aug 26 00:16:50 2005//
/setup_smarty.php/1.37/Fri Feb 17 15:10:30 2006//
/show_image.php/1.29/Wed May 18 10:58:52 2005//
/testrpc.php/1.11/Wed May 18 10:58:52 2005//
/textareasize.php/1.4/Thu Aug 25 20:50:04 2005//
/tiki-admin.php/1.109/Fri Jan 20 09:54:53 2006//
/tiki-admin_actionlog.php/1.12/Fri Mar 3 14:09:29 2006//
/tiki-admin_banning.php/1.10/Wed May 18 10:58:52 2005/-ko/
/tiki-admin_calendars.php/1.23/Mon Aug 29 03:14:43 2005//
/tiki-admin_categories.php/1.42/Mon Oct 3 17:21:43 2005//
/tiki-admin_chart_items.php/1.12/Wed May 18 10:58:53 2005//
/tiki-admin_charts.php/1.12/Wed May 18 10:58:53 2005//
/tiki-admin_chat.php/1.13/Wed May 18 10:58:53 2005//
/tiki-admin_content_templates.php/1.17/Wed May 18 10:58:53 2005//
/tiki-admin_contribution.php/1.4/Thu Mar 9 16:28:30 2006//
/tiki-admin_cookies.php/1.14/Fri Aug 12 13:01:58 2005//
/tiki-admin_drawings.php/1.17/Wed Sep 7 22:23:21 2005//
/tiki-admin_dsn.php/1.12/Thu Aug 25 20:50:04 2005//
/tiki-admin_external_wikis.php/1.12/Thu Aug 25 20:50:04 2005//
/tiki-admin_forums.php/1.37/Wed Sep 7 22:23:21 2005//
/tiki-admin_hotwords.php/1.18/Wed Sep 7 22:23:21 2005//
/tiki-admin_html_page_content.php/1.12/Wed May 18 10:58:53 2005//
/tiki-admin_html_pages.php/1.13/Wed May 18 10:58:53 2005//
/tiki-admin_include_blogs.php/1.13/Wed Jan 18 14:45:47 2006//
/tiki-admin_include_calendar.php/1.4/Fri Mar 17 18:45:02 2006//
/tiki-admin_include_cms.php/1.13/Wed May 18 10:58:53 2005//
/tiki-admin_include_community.php/1.3/Wed May 18 10:58:53 2005//
/tiki-admin_include_directory.php/1.10/Wed May 18 10:58:53 2005//
/tiki-admin_include_faqs.php/1.10/Wed May 18 10:58:53 2005//
/tiki-admin_include_features.php/1.47/Thu Mar 2 15:15:51 2006//
/tiki-admin_include_fgal.php/1.13/Wed May 18 10:58:53 2005//
/tiki-admin_include_forums.php/1.10/Wed May 18 10:58:53 2005//
/tiki-admin_include_<span style="color:black;background-color:#ffff66;">freetags</span>.php/1.4/Sun Jan 29 04:04:01 2006//
/tiki-admin_include_gal.php/1.17/Wed Jan 18 14:45:47 2006//
/tiki-admin_include_general.php/1.46/Fri Jan 20 09:54:53 2006//
/tiki-admin_include_intertiki.php/1.3/Fri Feb 17 15:10:30 2006//
/tiki-admin_include_jukebox.php/1.6/Wed May 18 10:58:54 2005//
/tiki-admin_include_login.php/1.39/Sun Jan 22 21:45:08 2006//
/tiki-admin_include_maps.php/1.14/Mon Nov 7 21:42:29 2005//
/tiki-admin_include_metatags.php/1.5/Wed May 18 10:58:54 2005//
/tiki-admin_include_polls.php/1.11/Wed May 18 10:58:54 2005//
/tiki-admin_include_rss.php/1.15/Fri Feb 17 15:10:30 2006//
/tiki-admin_include_score.php/1.3/Sat Jan 1 00:16:31 2005//
/tiki-admin_include_search.php/1.17/Mon Nov 14 22:22:39 2005//
/tiki-admin_include_siteid.php/1.5/Thu Aug 25 20:50:04 2005//
/tiki-admin_include_trackers.php/1.12/Wed May 18 10:58:54 2005//
/tiki-admin_include_userfiles.php/1.10/Wed May 18 10:58:54 2005//
/tiki-admin_include_webmail.php/1.10/Wed May 18 10:58:54 2005//
/tiki-admin_include_wiki.php/1.59/Tue Mar 28 07:41:45 2006//
/tiki-admin_include_wikiatt.php/1.3/Wed May 18 10:58:54 2005//
/tiki-admin_integrator.php/1.19/Wed May 18 10:58:54 2005//
/tiki-admin_integrator_rules.php/1.24/Wed May 18 10:58:54 2005//
/tiki-admin_layout.php/1.15/Wed May 18 10:58:54 2005//
/tiki-admin_links.php/1.18/Wed May 18 10:58:54 2005//
/tiki-admin_mailin.php/1.20/Thu Jun 16 20:10:49 2005//
/tiki-admin_menu_options.php/1.20/Wed May 18 10:58:54 2005//
/tiki-admin_menus.php/1.16/Thu Aug 25 20:50:04 2005//
/tiki-admin_modules.php/1.42/Mon Oct 3 17:21:43 2005//
/tiki-admin_newsletter_subscriptions.php/1.16/Tue Sep 27 22:05:23 2005//
/tiki-admin_newsletters.php/1.14/Fri Aug 12 13:01:58 2005//
/tiki-admin_notifications.php/1.14/Wed May 18 10:58:54 2005//
/tiki-admin_poll_options.php/1.19/Wed May 18 10:58:54 2005//
/tiki-admin_polls.php/1.17/Wed May 18 10:58:54 2005//
/tiki-admin_quicktags.php/1.16/Mon Mar 20 16:36:07 2006//
/tiki-admin_rssmodules.php/1.20/Wed May 18 10:58:54 2005//
/tiki-admin_score.php/1.4/Fri Oct 8 09:59:44 2004//
/tiki-admin_security.php/1.8/Mon Dec 12 15:18:46 2005//
/tiki-admin_shoutbox_words.php/1.3/Wed May 18 10:58:54 2005//
/tiki-admin_structures.php/1.22/Wed May 18 10:58:54 2005//
/tiki-admin_survey_questions.php/1.15/Wed May 18 10:58:54 2005//
/tiki-admin_surveys.php/1.17/Wed May 18 10:58:54 2005//
/tiki-admin_system.php/1.24/Thu Aug 25 20:50:04 2005//
/tiki-admin_topics.php/1.19/Wed May 18 10:58:55 2005//
/tiki-admin_tracker_fields.php/1.36/Fri Jan 20 09:54:53 2006//
/tiki-admin_trackers.php/1.42/Wed May 18 10:58:55 2005//
/tiki-admingroups.php/1.53/Thu Jan 5 17:59:27 2006//
/tiki-adminusers.php/1.60/Fri Feb 17 15:10:30 2006//
/tiki-ajax.php/1.4/Tue Mar 14 22:59:02 2006//
/tiki-ajax_example.php/1.1/Mon Mar 6 05:24:34 2006//
/tiki-article_types.php/1.15/Wed May 18 10:58:55 2005//
/tiki-articles_rss.php/1.26/Wed May 18 10:58:55 2005//
/tiki-assignpermission.php/1.24/Wed May 18 10:58:55 2005//
/tiki-assignuser.php/1.20/Fri Jan 20 09:54:53 2006//
/tiki-atom.php/1.8/Wed May 18 10:58:55 2005//
/tiki-backlinks.php/1.11/Wed May 18 10:58:55 2005//
/tiki-backup.php/1.17/Wed May 18 10:58:55 2005//
/tiki-batch_upload.php/1.4/Thu Jun 16 20:10:49 2005//
/tiki-blog_post.php/1.43/Fri Feb 17 15:10:30 2006//
/tiki-blog_rankings.php/1.15/Wed May 18 10:58:55 2005//
/tiki-blog_rss.php/1.29/Thu Jan 5 17:16:37 2006//
/tiki-blogs_rss.php/1.29/Wed May 18 10:58:55 2005//
/tiki-browse_categories.php/1.27/Fri Feb 17 15:10:30 2006//
/tiki-browse_<span style="color:black;background-color:#ffff66;">freetags</span>.php/1.11/Sat Feb 11 15:00:24 2006//
/tiki-browse_gallery.php/1.35/Wed Sep 14 21:45:38 2005//
/tiki-browse_image.php/1.35/Fri Feb 17 15:10:30 2006//
/tiki-browse_users.php/1.1/Wed Dec 14 17:40:31 2005//
/tiki-calendar.php/1.53/Fri Feb 17 15:10:31 2006//
/tiki-calendar_import.php/1.2/Wed May 18 10:58:55 2005//
/tiki-calendar_setup.php/1.2/Fri Mar 17 18:45:02 2006//
/tiki-calendars_rss.php/1.2/Fri Feb 17 15:10:31 2006//
/tiki-categpermissions.php/1.14/Wed May 18 10:58:55 2005//
/tiki-change_password.php/1.17/Fri Sep 23 08:19:45 2005//
/tiki-charts.php/1.11/Wed May 18 10:58:55 2005//
/tiki-chat.php/1.11/Wed May 18 10:58:55 2005//
/tiki-chat_box.php/1.10/Wed May 18 10:58:55 2005//
/tiki-chat_center.html/1.3/Sat Nov 15 14:34:35 2003//
/tiki-chat_loader.php/1.17/Tue Jan 24 06:11:52 2006//
/tiki-chat_users.php/1.13/Wed May 18 10:58:55 2005//
/tiki-chatroom.php/1.14/Fri Feb 17 15:10:31 2006//
/tiki-cms_rankings.php/1.14/Wed May 18 10:58:55 2005//
/tiki-config_pdf.php/1.13/Wed Feb 8 11:54:44 2006//
/tiki-contact.php/1.22/Fri Feb 17 15:10:31 2006//
/tiki-cookie-jar.php/1.2/Thu Jul 8 12:50:33 2004//
/tiki-create_webhelp.php/1.8/Wed Jan 5 19:22:41 2005/-ko/
/tiki-custom_home.php/1.15/Wed May 18 10:58:55 2005//
/tiki-debug_console.php/1.8/Wed May 18 10:58:55 2005//
/tiki-directories_rss.php/1.5/Wed May 18 10:58:55 2005/-kb/
/tiki-directory_add_site.php/1.18/Mon Dec 12 15:18:46 2005//
/tiki-directory_add_tiki_site.php/1.3/Sat Mar 12 16:48:58 2005//
/tiki-directory_admin.php/1.10/Wed May 18 10:58:55 2005//
/tiki-directory_admin_categories.php/1.16/Wed May 18 10:58:55 2005//
/tiki-directory_admin_related.php/1.14/Wed May 18 10:58:55 2005//
/tiki-directory_admin_sites.php/1.17/Wed May 18 10:58:55 2005//
/tiki-directory_browse.php/1.13/Mon Dec 12 15:18:46 2005//
/tiki-directory_ranking.php/1.9/Wed May 18 10:58:55 2005//
/tiki-directory_redirect.php/1.7/Wed May 18 10:58:55 2005//
/tiki-directory_rss.php/1.4/Wed May 18 10:58:55 2005/-kb/
/tiki-directory_search.php/1.9/Wed May 18 10:58:55 2005//
/tiki-directory_validate_sites.php/1.15/Wed May 18 10:58:55 2005//
/tiki-download_file.php/1.22/Fri Oct 28 15:44:44 2005//
/tiki-download_forum_attachment.php/1.11/Wed May 18 10:58:55 2005//
/tiki-download_item_attachment.php/1.12/Thu Oct 27 20:12:31 2005//
/tiki-download_userfile.php/1.8/Wed May 18 10:58:55 2005//
/tiki-download_wiki_attachment.php/1.14/Mon Nov 7 21:42:29 2005//
/tiki-edit_article.php/1.53/Fri Jan 20 09:54:53 2006//
/tiki-edit_banner.php/1.21/Mon Nov 7 21:42:29 2005//
/tiki-edit_blog.php/1.30/Fri Feb 17 15:10:31 2006//
/tiki-edit_css.php/1.12/Wed May 18 10:58:56 2005//
/tiki-edit_image.php/1.16/Thu Jul 14 13:59:49 2005//
/tiki-edit_languages.php/1.21/Tue Jul 19 01:07:12 2005//
/tiki-edit_programmed_content.php/1.16/Wed May 18 10:58:56 2005//
/tiki-edit_question_options.php/1.14/Wed May 18 10:58:56 2005//
/tiki-edit_quiz.php/1.18/Wed May 18 10:58:56 2005//
/tiki-edit_quiz_questions.php/1.20/Wed May 18 10:58:56 2005//
/tiki-edit_quiz_results.php/1.13/Wed May 18 10:58:56 2005//
/tiki-edit_structure.php/1.28/Wed May 18 10:58:56 2005//
/tiki-edit_submission.php/1.48/Fri Feb 17 15:10:31 2006//
/tiki-edit_templates.php/1.19/Fri Feb 17 15:10:31 2006//
/tiki-edit_topic.php/1.5/Wed May 18 10:58:56 2005//
/tiki-edit_translation.php/1.9/Mon Dec 12 15:18:46 2005//
/tiki-edit_wiki_section.php/1.3/Mon Dec 19 13:53:57 2005//
/tiki-editdrawing.php/1.18/Wed May 18 10:58:56 2005//
/tiki-editpage.php/1.139/Mon Mar 20 21:39:18 2006//
/tiki-eph.php/1.14/Wed May 18 10:58:56 2005//
/tiki-eph_admin.php/1.11/Wed May 18 10:58:56 2005//
/tiki-error.php/1.16/Mon Oct 10 17:46:31 2005//
/tiki-error_simple.php/1.6/Fri Oct 15 15:54:42 2004//
/tiki-export_pdf.php/1.16/Wed Feb 8 11:54:44 2006//
/tiki-export_pdf_reader.php/1.1/Wed Feb 8 11:55:07 2006//
/tiki-export_sheet.php/1.5/Wed May 18 10:58:56 2005//
/tiki-export_wiki_pages.php/1.10/Wed May 18 10:58:56 2005//
/tiki-faq_questions.php/1.24/Wed Oct 26 15:11:02 2005//
/tiki-featured_link.php/1.13/Wed May 18 10:58:56 2005//
/tiki-file_galleries.php/1.23/Sat Jan 22 22:54:54 2005//
/tiki-file_galleries_rankings.php/1.13/Wed May 18 10:58:56 2005//
/tiki-file_galleries_rss.php/1.25/Wed May 18 10:58:56 2005//
/tiki-file_gallery_rss.php/1.25/Wed May 18 10:58:56 2005//
/tiki-forum_queue.php/1.14/Wed May 18 10:58:56 2005//
/tiki-forum_rankings.php/1.12/Wed May 18 10:58:56 2005//
/tiki-forum_rss.php/1.18/Wed May 18 10:58:56 2005//
/tiki-forums.php/1.15/Mon Nov 7 21:42:29 2005//
/tiki-forums_reported.php/1.9/Wed Jan 5 19:22:41 2005/-ko/
/tiki-forums_rss.php/1.20/Wed May 18 10:58:56 2005//
/tiki-freetag3d_xmlrpc.php/1.6/Sat Jan 28 20:51:09 2006//
/tiki-freetag_list_objects_ajax.php/1.4/Tue Jan 31 00:32:53 2006//
/tiki-friends.php/1.7/Fri Feb 17 15:10:31 2006//
/tiki-g-admin_activities.php/1.16/Thu Mar 16 13:43:09 2006//
/tiki-g-admin_graph.php/1.4/Fri Jan 20 09:54:53 2006//
/tiki-g-admin_instance.php/1.11/Wed May 18 10:58:56 2005//
/tiki-g-admin_instance_activity.php/1.4/Fri Jan 20 09:54:53 2006//
/tiki-g-admin_processes.php/1.12/Wed May 18 10:58:56 2005//
/tiki-g-admin_roles.php/1.13/Wed May 18 10:58:56 2005//
/tiki-g-admin_shared_source.php/1.10/Wed May 18 10:58:56 2005//
/tiki-g-monitor_activities.php/1.11/Wed May 18 10:58:56 2005//
/tiki-g-monitor_instances.php/1.12/Wed May 18 10:58:56 2005//
/tiki-g-monitor_processes.php/1.11/Wed May 18 10:58:56 2005//
/tiki-g-monitor_workitems.php/1.12/Fri Feb 17 15:10:31 2006//
/tiki-g-my_activities.php/1.1/Sun Jan 25 01:34:20 2004//
/tiki-g-my_instances.php/1.1/Sun Jan 25 01:34:20 2004//
/tiki-g-run_activity.php/1.16/Thu Mar 16 13:43:09 2006//
/tiki-g-save_process.php/1.7/Wed May 18 10:58:56 2005//
/tiki-g-user_activities.php/1.12/Thu Mar 16 13:43:09 2006//
/tiki-g-user_instances.php/1.13/Thu Mar 16 13:43:09 2006//
/tiki-g-user_processes.php/1.11/Thu Mar 16 13:43:09 2006//
/tiki-g-view_comment.php/1.2/Sat Mar 12 16:48:59 2005//
/tiki-g-view_workitem.php/1.10/Wed May 18 10:58:56 2005//
/tiki-galleries.php/1.50/Fri Feb 17 15:10:31 2006//
/tiki-galleries_rankings.php/1.14/Wed May 18 10:58:56 2005//
/tiki-graph_formula.php/1.2/Wed May 18 10:58:56 2005//
/tiki-graph_sheet.php/1.7/Tue Dec 27 16:09:16 2005//
/tiki-handlers.php/1.8/Wed May 18 10:58:56 2005//
/tiki-history_sheets.php/1.3/Wed May 18 10:58:56 2005//
/tiki-im_ajax.php/1.1/Mon Feb 13 01:49:37 2006//
/tiki-image_galleries_rss.php/1.26/Wed May 18 10:58:57 2005//
/tiki-image_gallery_rss.php/1.24/Wed May 18 10:58:57 2005//
/tiki-imexport_languages.php/1.17/Wed May 18 10:58:57 2005//
/tiki-import_sheet.php/1.4/Wed May 18 10:58:57 2005//
/tiki-import_structuredtext.php/1.6/Wed May 18 10:58:57 2005//
/tiki-index.php/1.158/Mon Mar 20 21:47:09 2006//
/tiki-index_p.php/1.21/Fri Jan 20 09:54:53 2006//
/tiki-index_raw.php/1.22/Fri Jan 20 09:54:53 2006//
/tiki-install.php/1.78/Sun Oct 16 14:35:09 2005//
/tiki-integrator.php/1.18/Wed May 18 10:58:57 2005//
/tiki-jscalendar.php/1.5/Fri Jan 20 09:54:53 2006//
/tiki-lastchanges.php/1.15/Wed May 18 10:58:57 2005//
/tiki-layout_options.php/1.7/Wed May 18 10:58:57 2005//
/tiki-likepages.php/1.12/Wed May 18 10:58:57 2005//
/tiki-list_articles.php/1.23/Mon Nov 7 21:42:29 2005//
/tiki-list_banners.php/1.14/Wed May 18 10:58:57 2005//
/tiki-list_blogs.php/1.26/Mon Nov 7 21:42:29 2005//
/tiki-list_cache.php/1.12/Wed May 18 10:58:58 2005//
/tiki-list_comments.php/1.1/Fri Oct 14 13:50:34 2005//
/tiki-list_contents.php/1.15/Wed May 18 10:58:58 2005//
/tiki-list_faqs.php/1.16/Wed May 18 10:58:58 2005//
/tiki-list_file_gallery.php/1.29/Wed Sep 14 21:45:38 2005//
/tiki-list_gallery.php/1.23/Fri Feb 17 15:10:31 2006//
/tiki-list_games.php/1.25/Wed May 18 10:58:58 2005//
/tiki-list_integrator_repositories.php/1.13/Wed May 18 10:58:58 2005//
/tiki-list_posts.php/1.15/Wed May 18 10:58:58 2005//
/tiki-list_quizzes.php/1.13/Wed May 18 10:58:58 2005//
/tiki-list_submissions.php/1.16/Wed May 18 10:58:58 2005//
/tiki-list_surveys.php/1.15/Wed May 18 10:58:58 2005//
/tiki-list_trackers.php/1.15/Wed May 18 10:58:58 2005//
/tiki-list_users.php/1.8/Thu Jul 14 13:59:50 2005//
/tiki-listmovies.php/1.4/Mon Jun 28 16:16:24 2004//
/tiki-listpages.php/1.27/Mon Mar 20 16:36:10 2006//
/tiki-live_support_admin.php/1.15/Wed Jan 5 19:22:42 2005/-ko/
/tiki-live_support_chat_frame.php/1.5/Sat Jan 1 00:16:33 2005/-ko/
/tiki-live_support_chat_window.php/1.9/Sat Jan 1 00:16:33 2005/-ko/
/tiki-live_support_client.php/1.10/Sat Jan 1 00:16:33 2005/-ko/
/tiki-live_support_console.php/1.11/Sat Mar 12 16:49:00 2005/-ko/
/tiki-live_support_message.php/1.7/Sat Jan 1 00:16:33 2005/-ko/
/tiki-live_support_server.php/1.13/Sat Jan 1 00:16:33 2005/-ko/
/tiki-live_support_transcripts.php/1.7/Wed Jan 5 19:22:42 2005/-ko/
/tiki-login.php/1.51/Fri Feb 17 15:10:31 2006//
/tiki-login_scr.php/1.12/Fri Feb 17 15:10:31 2006//
/tiki-login_validate.php/1.17/Sun Oct 16 14:35:09 2005//
/tiki-logout.php/1.20/Wed May 18 10:58:58 2005//
/tiki-mailin-code.php/1.17/Mon Nov 7 16:20:21 2005//
/tiki-mailin.php/1.8/Wed May 18 10:58:58 2005//
/tiki-map.phtml/1.37/Fri Feb 17 15:10:31 2006//
/tiki-map_download.phtml/1.12/Mon Nov 7 21:42:29 2005//
/tiki-map_edit.php/1.21/Wed Sep 7 12:35:39 2005//
/tiki-map_history.php/1.3/Wed May 18 10:58:58 2005//
/tiki-map_rss.php/1.11/Wed May 18 10:58:58 2005//
/tiki-map_upload.php/1.16/Mon Nov 7 21:42:29 2005//
/tiki-minical.php/1.18/Wed May 18 10:58:58 2005//
/tiki-minical_export.php/1.6/Wed May 18 10:58:58 2005//
/tiki-minical_prefs.php/1.14/Wed May 18 10:58:58 2005//
/tiki-minical_reminders.php/1.11/Wed May 18 10:58:58 2005//
/tiki-mobile.php/1.11/Thu Aug 18 16:23:05 2005//
/tiki-mods.php/1.6/Wed May 18 10:58:58 2005//
/tiki-mods_admin.php/1.3/Wed May 18 10:58:58 2005//
/tiki-module_controls.php/1.15/Mon Dec 19 17:27:12 2005//
/tiki-modules.php/1.53/Mon Dec 19 17:44:34 2005//
/tiki-my_tiki.php/1.23/Wed Nov 23 21:47:13 2005//
/tiki-mytiki_shared.php/1.6/Wed May 18 10:58:58 2005//
/tiki-newsletter_archives.php/1.5/Mon Dec 12 15:18:46 2005//
/tiki-newsletters.php/1.24/Mon Dec 12 15:18:46 2005//
/tiki-newsreader_groups.php/1.15/Wed May 18 10:58:58 2005//
/tiki-newsreader_news.php/1.19/Wed May 18 10:58:58 2005//
/tiki-newsreader_read.php/1.14/Wed May 18 10:58:58 2005//
/tiki-newsreader_servers.php/1.18/Wed May 18 10:58:58 2005//
/tiki-notepad_get.php/1.8/Wed May 18 10:58:58 2005//
/tiki-notepad_list.php/1.19/Fri Feb 17 15:10:31 2006//
/tiki-notepad_read.php/1.15/Mon Nov 7 21:42:29 2005//
/tiki-notepad_write.php/1.11/Wed May 18 10:58:58 2005//
/tiki-objectpermissions.php/1.13/Sun Oct 16 14:35:09 2005//
/tiki-old_polls.php/1.12/Wed May 18 10:58:58 2005//
/tiki-orphan_pages.php/1.10/Wed May 18 10:58:58 2005//
/tiki-page.php/1.13/Fri Aug 12 13:01:58 2005//
/tiki-page_loader.php/1.11/Wed May 18 10:58:58 2005//
/tiki-pagehistory.php/1.30/Thu Mar 2 15:15:51 2006//
/tiki-pagepermissions.php/1.23/Wed May 18 10:58:58 2005//
/tiki-pagesetup.php/1.17/Wed May 18 10:58:58 2005//
/tiki-pagination.php/1.8/Thu Jan 5 17:16:37 2006//
/tiki-pdf.php/1.13/Sun Oct 16 14:35:09 2005//
/tiki-phpinfo.php/1.8/Wed May 18 10:58:58 2005//
/tiki-pick_avatar.php/1.24/Mon Oct 3 17:21:43 2005//
/tiki-poll_form.php/1.16/Fri Jan 20 09:54:53 2006//
/tiki-poll_results.php/1.17/Wed May 18 10:58:58 2005//
/tiki-print.php/1.24/Fri Jan 20 09:54:53 2006//
/tiki-print_article.php/1.9/Wed May 18 10:58:58 2005//
/tiki-print_blog_post.php/1.12/Wed May 18 10:58:58 2005//
/tiki-print_multi_pages.php/1.11/Thu Aug 18 16:23:05 2005//
/tiki-print_pages.php/1.15/Mon Nov 7 21:42:29 2005//
/tiki-pv_chart.php/1.11/Wed May 18 10:58:58 2005//
/tiki-quiz_download_answer.php/1.2/Sat Mar 12 16:49:00 2005//
/tiki-quiz_edit.php/1.16/Wed May 18 10:58:58 2005//
/tiki-quiz_result_stats.php/1.13/Wed May 18 10:58:58 2005//
/tiki-quiz_stats.php/1.13/Wed May 18 10:58:58 2005//
/tiki-quiz_stats_quiz.php/1.15/Wed May 18 10:58:58 2005//
/tiki-random_num_img.php/1.6/Sat Jan 1 00:16:35 2005/-ko/
/tiki-read_article.php/1.50/Mon Nov 7 21:42:29 2005//
/tiki-received_articles.php/1.18/Wed May 18 10:58:59 2005//
/tiki-received_pages.php/1.15/Wed May 18 10:58:59 2005//
/tiki-referer_stats.php/1.13/Wed May 18 10:58:59 2005//
/tiki-register.php/1.61/Fri Feb 17 15:10:31 2006//
/tiki-register_ajax.php/1.1/Thu Dec 15 20:21:55 2005//
/tiki-register_site.php/1.3/Mon Mar 15 21:27:27 2004//
/tiki-remind_password.php/1.26/Fri Jan 20 09:54:53 2006//
/tiki-remote_backup.php/1.8/Wed May 18 10:58:59 2005//
/tiki-removepage.php/1.14/Thu Mar 2 15:15:51 2006//
/tiki-rename_page.php/1.15/Wed May 18 10:58:59 2005//
/tiki-replicate.php/1.3/Wed May 18 10:58:59 2005//
/tiki-replicate_console.php/1.4/Wed May 18 10:58:59 2005//
/tiki-rollback.php/1.16/Wed May 18 10:58:59 2005//
/tiki-rss_error.php/1.5/Wed May 18 10:58:59 2005//
/tiki-search_stats.php/1.12/Wed May 18 10:58:59 2005//
/tiki-searchindex.php/1.12/Wed May 18 10:58:59 2005//
/tiki-searchresults.php/1.36/Mon Dec 12 15:18:47 2005//
/tiki-section_options.php/1.11/Wed May 18 10:58:59 2005//
/tiki-send_blog_post.php/1.15/Fri Feb 17 15:10:31 2006//
/tiki-send_newsletters.php/1.26/Wed Aug 10 15:56:00 2005//
/tiki-send_objects.php/1.20/Sun Oct 16 14:35:09 2005//
/tiki-setup.php/1.301/Mon Mar 20 07:03:37 2006//
/tiki-setup_base.php/1.95/Thu Mar 16 13:43:09 2006//
/tiki-sheets.php/1.9/Wed May 18 10:58:59 2005//
/tiki-shoutbox.php/1.15/Wed May 18 10:58:59 2005//
/tiki-show_calendar.php/1.3/Mon Feb 13 20:55:30 2006//
/tiki-show_raw_links.php/1.1/Thu Apr 1 00:27:09 2004//
/tiki-show_user_avatar.php/1.9/Wed May 18 10:58:59 2005//
/tiki-slideshow.php/1.21/Wed May 18 10:58:59 2005//
/tiki-slideshow2.php/1.14/Wed May 18 10:58:59 2005//
/tiki-special_chars.php/1.2/Wed May 18 10:58:59 2005//
/tiki-stats.php/1.15/Fri Aug 12 13:01:58 2005//
/tiki-survey_stats.php/1.14/Wed May 18 10:58:59 2005//
/tiki-survey_stats_survey.php/1.14/Wed May 18 10:58:59 2005//
/tiki-switch_lang.php/1.7/Mon Feb 27 17:21:14 2006//
/tiki-switch_theme.php/1.3/Sun Sep 19 19:36:25 2004//
/tiki-syslog.php/1.6/Thu Jul 28 15:20:18 2005//
/tiki-take_quiz.php/1.20/Mon Dec 12 15:18:47 2005//
/tiki-take_survey.php/1.14/Wed May 18 10:58:59 2005//
/tiki-tc.php/1.11/Fri Jan 20 09:54:53 2006//
/tiki-theme_control.php/1.14/Mon Oct 3 17:21:43 2005//
/tiki-theme_control_objects.php/1.17/Mon Oct 3 17:21:43 2005//
/tiki-theme_control_sections.php/1.11/Mon Oct 3 17:21:43 2005//
/tiki-tracker_rss.php/1.3/Fri Feb 17 15:10:31 2006//
/tiki-upload_file.php/1.33/Wed May 18 10:58:59 2005//
/tiki-upload_image.php/1.38/Wed May 18 10:58:59 2005//
/tiki-usage_chart.php/1.9/Wed Sep 7 12:35:39 2005//
/tiki-user_assigned_modules.php/1.15/Wed May 18 10:58:59 2005//
/tiki-user_bookmarks.php/1.16/Wed May 18 10:58:59 2005//
/tiki-user_cached_bookmark.php/1.9/Wed May 18 10:58:59 2005//
/tiki-user_information.php/1.33/Sun Jan 22 21:45:08 2006//
/tiki-user_preferences.php/1.80/Fri Feb 17 15:10:31 2006//
/tiki-user_tasks.php/1.20/Fri Feb 17 15:10:31 2006//
/tiki-user_watches.php/1.16/Thu Mar 2 11:34:11 2006//
/tiki-userfiles.php/1.15/Wed May 18 10:59:00 2005//
/tiki-usermenu.php/1.11/Wed May 18 10:59:00 2005//
/tiki-users3d_xmlrpc.php/1.1/Wed Dec 14 17:40:31 2005//
/tiki-userversions.php/1.14/Wed May 18 10:59:00 2005//
/tiki-view_articles.php/1.31/Mon Nov 7 21:42:29 2005//
/tiki-view_banner.php/1.21/Wed May 18 10:59:00 2005//
/tiki-view_blog.php/1.51/Mon Dec 12 15:18:47 2005//
/tiki-view_blog_post.php/1.33/Sun Dec 11 15:27:04 2005//
/tiki-view_blog_post_image.php/1.7/Wed May 18 10:59:00 2005//
/tiki-view_cache.php/1.11/Wed May 18 10:59:00 2005//
/tiki-view_chart.php/1.17/Wed May 18 10:59:00 2005//
/tiki-view_chart_item.php/1.12/Wed May 18 10:59:00 2005//
/tiki-view_eph.php/1.5/Wed May 18 10:59:00 2005//
/tiki-view_faq.php/1.20/Wed May 18 10:59:00 2005//
/tiki-view_forum.php/1.99/Mon Mar 13 14:13:41 2006//
/tiki-view_forum_thread.php/1.82/Mon Nov 7 21:42:29 2005//
/tiki-view_irc.php/1.13/Wed May 18 10:59:00 2005//
/tiki-view_minical_topic.php/1.6/Wed May 18 10:59:00 2005//
/tiki-view_sheets.php/1.10/Wed May 18 10:59:00 2005//
/tiki-view_tracker.php/1.90/Fri Jan 20 09:54:53 2006//
/tiki-view_tracker_item.php/1.91/Fri Feb 17 15:10:31 2006//
/tiki-view_tracker_more_info.php/1.7/Mon Nov 7 21:42:29 2005//
/tiki-wap.php/1.7/Sat Jan 1 00:16:35 2005/-ko/
/tiki-webmail.php/1.29/Wed May 18 10:59:01 2005//
/tiki-webmail_contacts.php/1.11/Wed May 18 10:59:01 2005//
/tiki-webmail_download_attachment.php/1.8/Wed May 18 10:59:01 2005//
/tiki-wiki3d.php/1.3/Sat May 29 20:50:39 2004//
/tiki-wiki3d_xmlrpc.php/1.5/Thu Aug 18 16:23:05 2005//
/tiki-wiki_rankings.php/1.13/Wed May 18 10:59:01 2005//
/tiki-wiki_rss.php/1.32/Wed May 18 10:59:01 2005//
/tiki-xajax_example.php/1.1/Fri Mar 10 02:15:52 2006//
/tiki-xmlrpc_services.php/1.13/Thu Aug 18 16:23:05 2005//
/topic_image.php/1.15/Thu Sep 8 01:48:45 2005//
/xmlrpc.php/1.26/Mon Dec 12 15:18:47 2005//

Steps to reproduce:

Use admin rights for the following steps

1. Create at least 2 categories
2. Give Registered (default no rights changed) User group access to one of them and deny access to the other
3. Now create 1 Wiki site in each Category
4. Link both pages from the tiki.index.php via Wiki link

5. Log in as the Registered user now
6. Try viewing both Sites via the Wiki link on one u get the error that u dont have permission to do so
7. Now click on the Link
Create this page (page will be orphaned)
8. Now u can view the page even though u arent allowed to do so
9. Uncheck the category change the site and u are even able to save the edits u did even though u dont have permission to do so

In Tiki 3, the feature_category_reinforce allowed Tiki to evaluate category permissions with AND operator, to determine if a user can view an object in the category.

This __"Permission to all (not just any) of an object's categories is required for access"__ option was removed in Tiki 4 & 5. Now Tiki always evaluates category permission conflicts with OR operator.

I would like the feature_category_reinforce option re-instated for Tiki 5 & 6.

Imagine you have 2 wiki pages. Page A and Page B, and Page B is assigned to category X.
In page A you use the CATEGORY plugin to list all objects from category X, and thus, it lists the "Page B" name, which links to it.

Then you rename Page B to Page C. In page A, the plugin category still shows name and link to "Page B", and not the updated name and link: "Page C".

This bug has been here for almost a year, and it is present in 1.9 and 1.10
---
bug still alive on tiki 2.1, and confirmed also after deleting pages, and clearing tiki caches.

It can be tested on (production) site for registered users at:
http://uniwiki.sima.ourproject.org

Using workspaces, when changing workspace names after creation, editing the category to rename its elements works OK for wiki pages and file galleries, but perspectives' names are not changed.
Seems "profile_symbols" & "objects" tables are not updated.

{include page=Roles and Permissions}

At doc.tw.o (upgraded to 1.10svn April 12th), I went to admin categories.
Selected "Editorial Board Meeting" (already existed), to add pages to it.
At the filter box I set "Editorial Board Meeting" and a mysql error is returned:


{BOX()}
~pp~
~np~
An error occured in a database query!

Context:
File tiki-admin_categories.php
Url tiki-admin_categories.php?find_objects=Editorial+Board+Meeting&parentId=10&search_objects=Filter&sort_mode=name_asc&offset=0&find=
Query:
SELECT tab.*, tfgp.`name` as `parentName` FROM (SELECT 1 as `isgal`, tfg.`galleryId` as `id`, tfg.`parentId`, tfg.`name`, tfg.`description`, 0 as `size`, tfg.`created`, tfg.`name` as `filename`, tfg.`type`, tfg.`user` as `creator`, '' as `author`, tfg.`hits`, tfg.`votes`, tfg.`points`, '' as `path`, '' as `reference_url`, '' as `is_reference`, '' as `hash`, tfg.`name` as `search_data`, tfg.`lastmodif` as `lastmodif`, '' as `last_user`, '' as `lockedby`, '' as `comment`, 0 as `archiveId`, tfg.`visible`, tfg.`public`, tfg.`galleryId` as `fileId`, tfg.`parentId` as `galleryId`, 0 as `filesize`, tfg.`type` as `filetype`, tfg.`user`, '' as `lastModifUser`, count(distinct tfc.`fileId`) as `files` FROM `tiki_file_galleries` as tfg LEFT JOIN `tiki_files` tfc ON (tfg.`galleryId` = tfc.`galleryId`) GROUP BY tfg.`galleryId`) as tab LEFT OUTER JOIN `tiki_file_galleries` tfgp ON (tab.`parentId` = tfgp.`galleryId`) WHERE (upper(`name`) LIKE upper(?) OR upper(`description`) LIKE upper(?) OR upper(`filename`) LIKE upper(?)) ORDER BY `isgal` desc, tab.`name` desc
Values:
0 %Editorial Board Meeting%
1 %Editorial Board Meeting%
2 %Editorial Board Meeting%
Message:
Column 'name' in where clause is ambiguous
Built query was probably:
SELECT tab.*, tfgp.`name` as `parentName` FROM (SELECT 1 as `isgal`, tfg.`galleryId` as `id`, tfg.`parentId`, tfg.`name`, tfg.`description`, 0 as `size`, tfg.`created`, tfg.`name` as `filename`, tfg.`type`, tfg.`user` as `creator`, '' as `author`, tfg.`hits`, tfg.`votes`, tfg.`points`, '' as `path`, '' as `reference_url`, '' as `is_reference`, '' as `hash`, tfg.`name` as `search_data`, tfg.`lastmodif` as `lastmodif`, '' as `last_user`, '' as `lockedby`, '' as `comment`, 0 as `archiveId`, tfg.`visible`, tfg.`public`, tfg.`galleryId` as `fileId`, tfg.`parentId` as `galleryId`, 0 as `filesize`, tfg.`type` as `filetype`, tfg.`user`, '' as `lastModifUser`, count(distinct tfc.`fileId`) as `files` FROM `tiki_file_galleries` as tfg LEFT JOIN `tiki_files` tfc ON (tfg.`galleryId` = tfc.`galleryId`) GROUP BY tfg.`galleryId`) as tab LEFT OUTER JOIN `tiki_file_galleries` tfgp ON (tab.`parentId` = tfgp.`galleryId`) WHERE (upper(`name`) LIKE upper('%Editorial Board Meeting%') OR upper(`description`) LIKE upper('%Editorial Board Meeting%') OR upper(`filename`) LIKE upper('%Editorial Board Meeting%')) ORDER BY `isgal` desc, tab.`name` desc
~/np~
~pp~
{BOX}

Nothing was added to that category. I had to add them selecting them from the multiple select box showing all pages in doc.tw.o (at least nowadays all pages are listed :-) - thanks to the coders who improved that )

Error message with search function in category.
PHP (4.3.10-18) ERROR (E_USER_WARNING):
File: tikidblib.php
Line: 181
Type: mysql error: Column 'name' in where clause is ambiguous in query:

SELECT DISTINCT c.*, o.* FROM `tiki_category_objects` c, `tiki_categorized_objects` co, `tiki_objects` o LEFT JOIN `users_objectpermissions` u ON u.`objectId`=MD5(CONCAT(o.`type`,LOWER(o.`itemId`))) AND u.`objectType`=o.`type` WHERE c.`catObjectId`=o.`objectId` AND o.`objectId`=co.`catObjectId` AND c.`categId`=? AND (`name` LIKE ? OR `description` LIKE ?) AND (( u.`objectId` IS NULL AND (o.`type` IN ('',?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) OR o.`type` like ?) OR (((o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`permName`=?) OR (o.`type`=? AND u.`perm

{syntax type="tiki" editor="plain"}
I have Staging + Approval Setup for File Galleries. Browsing the Galleries works fine, Registered Users can see Approved files, Admins can see both Approved and Staging.

When I do a search, Registered Users cannot see any of the Approved files in File Gallery. If I turn on Global Permissions, File (tiki_p_download_files), then Registered Users can see both Approved and Staging. In the Approved category, Registered Users have the download files permission.

Something is funny in the permissions for Searching. This does not appear to follow the category permissions.

SORRY for frequent Bug Tracker infomails - something weird is going on on this server/website or tracker.

Tiki version: Last update from SVN (12.0svn): Monday 28 October, 2013 18:41:51 CET - REV 48198 (MyISAM)

Category: "Bug Regression" / Version "Tiki 12" Features: "Tracker, Category, TIM/show.t.o"

=> This time it saved Category "Bug Regression" - so I try again {sign user="Torsten" datetime="2013-10-29T23:38:58+00:00"}

---

--I keep the status "open" for a moment, as the buggy behaviour just partly disappeared magically.--

Buggy behaviour appears and disappears here on item4829 and stays on item4828 - two same tracker items and different behaviour on both??? - maybe somebody works on the server and there are no real bugs? WEIRD! I will recheck tomorrow and ask in the dev-list.

---

--When I create a bug report, categories "Category, Version and Feature" are not saved.--

Update: Now categories are saved (here in item4829, not yet in item4828), but when re-editing the tracker item, the category fields are empty
Update 2: categories stay saved in item4829, stay disappearing in item4828

---

Error Messages after saving/uploading:

Saving a tracker item leads to a colored table with a lot of error messages like: Fatal error: Call to a member function setSubject() on a non-object in /var/local/dev.tiki.org/www/lib/webmail/tikimaillib.php on line 71

--Update: saving goes well now (I did nothing different) - another magical self repair?--

Update 2: see the different error messages in the __attachment__ - I have no clue whats going on. Database errors, scripts missing or not loading, errors appearing and disappearing without means ...

---

Show Instances:

When I create a show instance, the installation via TIM fails.

Update: the installation of 12.0alpha fails - the installation of 12.x works well.

Cannot show 12.0alpha, because show fails. Sucks.

__Here the log of a failed installation of a Tiki12.0alpha show.t.o instance:__

{CODE()}
########################################################################################

== TIM Wed Oct 30 00:24:19 CET 2013 : TIM command: CREATE
########################################################################################


== TIM Wed Oct 30 00:24:19 CET 2013 : Starting instance creation

== TIM Wed Oct 30 00:24:19 CET 2013 : Unpacking tarball

== TIM Wed Oct 30 00:24:19 CET 2013 : Chown-ing everything to TIM user and group

== TIM Wed Oct 30 00:24:19 CET 2013 : Running setup.sh
sh: 0: Can't open setup.sh

== TIM Wed Oct 30 00:24:19 CET 2013 : Creating database

== TIM Wed Oct 30 00:24:19 CET 2013 : Setting GRANTs on database

== TIM Wed Oct 30 00:24:19 CET 2013 : Creating local.php
/usr/local/sbin//tim-create: line 145: /var/www/torsten-11143-4828/db/local.php: No such file or directory
chown: cannot access `/var/www/torsten-11143-4828/db/local.php': No such file or directory

== TIM Wed Oct 30 00:24:19 CET 2013 : Old Tiki - populating database via tiki.sql
/usr/local/sbin//tim-create: line 168: /var/www/torsten-11143-4828/db/tiki.sql: No such file or directory

== TIM Wed Oct 30 00:24:19 CET 2013 : Starting extra steps special to show instances. Anything done below is not part of a standard Tiki installation.
cat: /var/www/torsten-11143-4828/info.txt: No such file or directory

== TIM Wed Oct 30 00:24:19 CET 2013 : Creating file http://torsten-11143-4828.show.tikiwiki.org/info.txt with extra info for developers
/var/www/torsten-11143-4828

== TIM Wed Oct 30 00:24:19 CET 2013 : Inserting extra info for developers in a box at the beginning of homepage
ERROR 1146 (42S02) at line 1: Table 'torsten_11143_4828.tiki_pages' doesn't exist

== TIM Wed Oct 30 00:24:19 CET 2013 : FAILED INSTALL
Exiting /usr/local/sbin//tim-create with exit status: 1
{CODE}

---

{syntax type="tiki" editor="plain"}
With a Tiki build-in module like logo.
In Visibility you can set a parameter to filter to have the module used with specific object categories.
For cat22 and cat23 you should add a semi-colon like this : "22:23".
On save the semi-columns are deleted and the filter is not working at all.

{img fileId="3091" thumb="box"}

---
~~#F00:See Solution (for the custom modules)~~

With a custom module you had to add a parameter per category to have the same behavior.

On a custom module in the parameter field if I set several category like this:
-+nobox=y&category=22&category=23+-

In the modules once saved it look like this as before.

{img fileId="3092" thumb="box"}

But only the last category entered will have the effect to display the module.
All previous categories will be omitted unlike before and this is a regression.

{syntax type="tiki" editor="plain"}
If you activate both the SEFURLs and the very useful "Show category objects", the urls generated by the category browser are not correct for trackers and file galleries.

In both cases it only gives the numeric identifier, without the "tracker" or "file" part.

Here is what it produces:
http://site-name.com/2

Here is what it should produce:
http://site-name.com/tracker2

Show Category Path + Show Category Objects was implemented a long time ago, and somewhat in a rush. One of those temporary things which became permanent. It only works in wiki pages, yet it would be logical to have this throughout the various features.

Seeing the list of items in the same category is very useful as contextual navigation.

Every Time, i use the Categories-Feature in File-Galleries or when uploading Pictures, it got the following error:

Notice: Undefined offset: 20 in categorize_list.php on line 38

Notice: Undefined index: categId in categorize_list.php on line 44

The Item itself is categorized