Loading...
 
Skip to main content

Wiki text returned from plugn not parsed

  • Tracker item actions
Trackers
Items
Status
Closed
Subject
Wiki text returned from plugn not parsed
Version
6.x
Category
  • Regression
  • Usability
Feature
Wiki Plugin (extends basic syntax)
Wiki Syntax (text area, parser, external wiki, etc)
Resolution status
Invalid
Submitted by
Steve
Lastmod by
Ushindi Gedeon
Rating
(0)
Related-to
Description

Tiki: 6.1
Firefox:

Wiki text returned by the SQL plugin is not translated. I used the "Quote" plugin to verify if this problem exists for all plugins returning Wiki text and the value translated as specified in the data passed.

We make fairly extensive use of the SQL plugin on our internal department site. A technique for implementing this plugin we use is to enclose the return value of a column in double parenthesis. This enables us to have a web page reference for each of the returned rows.

This technique is used in several circumstances. One is that we select from our database stored information on hundreds of servers making the server name a link to a detailed info page. The example below is used to link to project detail pages describing individual active projects.

Example SQL
Copy to clipboard
select
   concat( '((', p.project_name, '))' ) as "Project Name",
   u.user_username as "Project Owner",
   tdv.value as "Project Status"
from
   projects p,
   departments d,
   project_departments pd,
   tsi_dp_valsets tdv,
   users u
where p.project_id = pd.project_id
and pd.department_id = d.dept_id
and d.dept_name = 'TSI-KPHC'
and u.user_id = p.project_owner
and tdv.ID = p.project_status
and tdv.value != 'Archived'
and tdv.value != 'Complete'
order by tdv.value;


This issue is not restricted to link specifications as bold (double underscores) no longer work when returned by SQL either.

I have rated this a "9" strictly from a personal importance perspective and not as a definition of impact to the overall Tiki project. The customers of our department rely on these returned links for information and updates.

I have been all through the Administrative areas hoping to find a feature flag to turn on wiki text parsing of plugins (before trying the above referenced "Quote test") and am also unable to find such a flag specific to the SQL plugin.

--Steve

Solution
Implement patch submitted as tracker item 3741
Workaround
None known
Importance
9
Priority
45
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
3727
Created
Thursday 30 December, 2010 21:39:29 UTC
by Steve
LastModif
Tuesday 30 June, 2026 13:07:07 UTC


Show PHP error messages