Category: 3.x

{syntax type="tiki" editor="plain"}
I've just created a new page on a tiki 3.3 site with this content:
{CODE(wrap=1)}
{TRACKERLIST(trackerId="3",fields="41:42",sort="y",popup="43",stickypopup="n",showtitle="n",showlinks="y",showdesc="n",shownbitems="n",showinitials="n",showstatus="n",showcreated="n",showlastmodif="n",showfieldname="n",status="op",sort_mode="asc",max="15",more="n",moreurl="n",view="user",compute="42/sum:43/avg")}{TRACKERLIST}
{CODE}

That tracker exists, as well as fieldId's 41, 42 and 43.
And it produced this error:

{CODE(wrap=1)}
An error occured in a database query!

Context:
File tiki-index.php
Url tiki-index.php?page=Gradebook
Query:
SELECT tti.*, ttif.`value`, ttf.`type`, tti.`asc` 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`) WHERE tti.`trackerId` = ? and (`status`=? or `status`=?) AND ttif0.`fieldId`=? AND ttif0.`value`=? GROUP BY tti.`itemId` ORDER BY `sortvalue` asc
Values:
0 3
1 o
2 p
3 41
4 Xavi
Message:
Built query was probably:
SELECT tti.*, ttif.`value`, ttf.`type`, tti.`asc` 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`) WHERE tti.`trackerId` = '3' and (`status`='o' or `status`='p') AND ttif0.`fieldId`='41' AND ttif0.`value`='Xavi' GROUP BY tti.`itemId` ORDER BY `sortvalue` asc
{CODE}

---


Sorry, just testing once more the issue related to normal users loosing the ability edit their own items

When installing TikiWiki 3.0 into MySQL (I'm using 5.1.35 but I don't think it matters much) where the database has been created with a charset of 'utf-8' (typically because this is the server default), one table cannot be created and that command and subsequent inserts fail:

{CODE()}
CREATE TABLE `tiki_sefurl_regex_out` (
`id` int(11) NOT NULL auto_increment,
`left` varchar(256) NOT NULL,
`right` varchar(256) NULL default NULL,
`type` varchar(32) NULL default NULL,
`silent` char(1) NULL default 'n',
`feature` varchar(256) NULL default NULL,
`comment` varchar(256),
`order` int(11) NULL default 0,
PRIMARY KEY(`id`),
UNIQUE KEY `left` (`left`(256)),
INDEX `idx1` (silent, type, feature(30))
)
y was too long; max key length is 767 bytes
{CODE}

The issue is that the table key is too long when using UTF-8. See [http://bugs.mysql.com/bug.php?id=4541].

The error occurs when you delete a message in the inbox webmail

Fatal error: Call to undefined method Net_POP3::ixp() in /var/www/virtual/scpc.publinter.org/htdocs/tiki-webmail.php on line 286

saludos
Fran_gm

See two screenshots (error with thumbnails in File Gallery)
http://dev.tikiwiki.org/show_image.php?galleryId=1

After some time one or more thumbnails of uploaded images in the File Gallery cannot be displayed anymore. The link seems to be lost.
There an error on the page mentioning an error in tiki-js-sorttable.js. Please help.

{syntax type="tiki" editor="plain"}
When a user clicks on the little magnifying glass to view an event, I would recommend that the first two items displayed be "Title" and "Description". The other items that currently appear first ("Calendar", "Recurrence", "Start" and "End"), although important, are usually not why the user clicked on that event.

Usually, the user is interested in finding out more about what the event is - information included primarily in the "Description".

The event's "Title" is all that can be viewed initially for a given date and it includes only a few words. If the user's interest is piqued by those few words, the first thing the user would like to see is a fuller description.

Currently, the user clicks on the event and then has to click on the magnifying glass and then has to read half-way down the page before finding out more about the event proper.

Those other items could be more usefully placed below "Description" so that they can be read if the user is interested.

I would argue that this would make the calendar more user-friendly.

I would also encourage placement of the magnifying glass to the left of the "edit" icon (when the user first clicks on an event) for similar reasons. Many more people will want to view an item than edit it, so the magnifying glass (or "view" icon) would more usefully come first.

This could also be by via category system (with perms)

Should this be done with trackers with the new ((doc:Computed Tracker Field)) and deployed via the ((profile manager))?

It looks as though there is a Calendar import feature using CSV (tiki-calendar_import.php) however there are no options to export as CSV in tikiwiki 3.2. The only Calendar export option that I see is exporting to iCal (via tiki-calendar_export_ical.php) but that is not working for our group ([http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=3152]).

Can Calendar export to CSV be possible?

We are running in a multi tiki environment on Windows Server 2003, tikwiki 3.2 and php 5.3.

Exporting a tracker does not work when selecting a custom default sort order field for the tracker.
Fields that do work :
itemId
Created
Lastmodif

All other fields will result in a csv file containing the error page html code.

It seems that the order by value in the SQL statement is not properly generated.


File tiki-export_tracker.php
Url tiki-export_tracker.php
Query:
select * from `tiki_tracker_items` tti where tti.`trackerId`=? order by `` desc

Values:
0 4
Message:

Built query was probably:
select * from `tiki_tracker_items` tti where tti.`trackerId`='4' order by `` desc

{syntax type="tiki" editor="plain"}
When exporting tracker items, the generated csv file contains a blank line after every 100 items.

...
100 "180";"48";"13-06-2005";""
101 "133";"1";"30-04-2005";"5"
102
103 "179";"47";"31-01-2005";"0"
104 "178";"46";"31-01-2005";""

Currently (2.x), admins can configure new registrations to select specific groups during registration. I would like to request the following enhancments:

# Specify a default group. Currently, there is no default. I want to be able to configure a default group (i.e., adding checked="checked"...)
#Allow admins to confirm group requests. For example, I want to allow users to ''request'' to join an admin-level group upon registration, but I want the current admin to be able to verify this, before the user gets admin access.

The title for External wiki links in not parsed, for instance
~pp~ ((wp:Link|Title)) ~/pp~
will display __Link__ instead of __Title__

We need this for *.tikiwiki.org as well
{img src=images/code.png}%%% {CODE()}
((dev:EditUIRevamp|Improve the content editing interface))
((dev:AdminUIRevamp|Improve the admin interface))
{CODE}

Say I need to make a link such as:
{img src=images/code.png}%%% {CODE()}
[http://en.wikipedia.org/wiki/Argument_map|Argument map]
{CODE}

I could use an ((doc:external wiki)) link which is like this:

{img src=images/code.png}%%% {CODE()}
((wp:Argument map))
{CODE}

Even nicer would be an image (instead of {img src=img/icons/external_link.gif}) so the visitor knows he'll be sent to Wikipedia.

Also, would need:
*optional title: to explain what this site is about. (ex.: this is a sister community)
*option to open new window
these would be set centrally and you could override.


Perhaps the direction to take is to build with ((doc:plugin alias))

{syntax type="tiki" editor="plain"}
Here's what I did:

#Create user menu module
#Create menu
##Add items to menu
#Assign menu to menu module using {menu id=45}


[show_image.php?id=67&thumb=1|Here's an image]

New fade plugin is cool.
http://doc.tikiwiki.org/PluginFade

#If body is empty, plugin should not be clickable
#However, if there are line breaks in the body, the are no longer in the fade.
#Also, should have a setting, default to y for little icons:
{img src=images/code.png}%%% {CODE()}
[-] [+]
{CODE}

{syntax type="tiki" editor="plain"}
This happens when sending email. I can receive though.

Same config on a different server worked.

This is a huge problem

Not easy to solve. Would need ((WikiParser)) work?

When the FAQ feature is enabled, hovering over feature 'Blogs' in the 'Main' tab generates a floating box that says 'Wiki'. Likewise, hovering over 'Mini Chat' on the 'More Functionality' tab generates a floating box that says 'HTML Pages'

I had TikiWiki v2.2 installed and running fine on my website.

I used cpanel + Fantastico to automatically upgrade from v2.0 to v3.0. I followed the Fantastico on-screen instructions and when the update had finished I clicked on the "View site" link and got the following error:
Fatal error: Cannot redeclare class Zend_Filter_Interface in /usr/lib/php/Zend/Filter/Interface.php on line 30

I tried to do a brand new install of TikiWiki on another website that has never had a previous version of TikiWiki on it using cpanel + Fantastico. I followed the on-screen instructions and when I clicked on the "View site" link I got the same fatal error message.

I then installed TikiWiki v3.0 on my Ubuntu v8.04 desktop localhost Apache2 server and it works fine.

Then I installed TikiWiki v3.0 on my Windows Vista Ultimate laptop localhost Apache2 server and it works fine.

Two local installations of TikiWiki v3.0 work fine. The two attempts at using cpanel + Fantastico on remote servers both yield the same fatal error. One website had a previously installed version of TikiWiki (v2.2). The other website had never had TikiWiki installed.

No matter if you disable feature_wiki_1like_redirection
it in the "Wiki" part of Administration Page

the engine always tries to show you a page name
similar to the one you asked for.

This should be optional, like the rest.

But beware of:
[wish1697|permission "minor" seems useless on doc.tw.o: registered can't use it even if granted to them]

File gallery slideshow does not work.

editor is not defined
file4?&slideshow
Line 12

The file templates/file_gallery_slideshow.tpl requires lib/slideshow/slideshow.rc1.packed.js but the latter file is missing, as is the "icons" directory which it requires.

On a related note, the directory lib/slideshow now contains directories css and js but no instructions on their use.

Tested in v3.1. When choosing to store File Gallery items in a directory instead of the database, the directory field requires the full server path. If the abbreviated relative path to the wiki is entered, file uploads fail.

This conflicts with both doc.tw.o (as of today's rev) and Admin > Wiki, which allows the attachment directory to be specified relative to the wiki directory.

I tried the file gallery from tikiwiki 3.2. in opera 10, the loading screen (uploading) never stops and the image is not shown in the gallery (empty picture frame) or when used inside a wiki page. When clicking at the icon symbol or empty space shown there instead the invisible thumbnail is opened correctly though showing the full picture. Works fine in IE 7 and latest Firefox.

> As admin, I can't set the permissions on Registered users to: list_file_galleries or create_file_galleries, though other file galleries settings are selected, including view_file_gallery, download_files, upload_files, view_fgal_explorer, and view_fgal_path. I tried to deselect that last 2 since I don't understand what the file gallery explorer is and I don't know that they need to view the path, but I can't seem to deselect and save it successfully.
>
> When I log in as a Registered user and click on File Galleries, I get this Error message: Permission denied you cannot view this section.
>
> I see a link for Upload file, but when I click on it, I get: No gallery available. You have to create a gallery first! Create New Gallery.
>
> When I click on Create New Gallery, it gives me this Error message: Permission denied you cannot view this section.