Category: Release50

Many (most) websites require the use of both a main menu and a secondary menu.

{syntax type="tiki" editor="plain"}
Fact : when you submit "preview" for a new event, a great part of data are lost, there is no real preview, and when you return to creation most of optional data are lost.

Too many things don't function : the job is not ended.

{syntax type="tiki" editor="plain"}
The fact (analysis result) : view from the popup od calendar module has no data set up

Details :
When you actions the into modules calendar the event from a date, you get the popup (if prefs) which shows the events of the day, then :

1- there is no choice for an event if an alone or several
2- the data of the event are not set up
3- the action button "view" shows a "pseudo empty event" the lonely data are the default value for a new event...

The function is not completely implemented. Job not ended. Functionality not operational.

It had no time to look at 6.0.

I installed Tiki 5.3 from Fantastico and then ran the setup script.

I was able to create some new users and assign them to groups.

The problems manifested when I attempted to change the default admin password and the password that I forgot for one of the new users.

Upon clicking "Edit Account Settings" next to the user, tiki-adminusers.php is displayed with the user number (e.g. tiki-adminusers.php?user=3).

There are three buttons, clicking the one to "confirm" the action causes tiki-adminusers to display a form for editing the password, email, etc. for the user.

"Saving Changes" causes tiki-admin users to again present the three buttons, this time without any user number on the URL.

Clicking to "Confirm" adds a "#" sign to the end of the URL, but nothing seems to happen.

The original password is unchanged and other values entered on the form are unchanged.

We have a registered user X with right tiki_p_modify_tracker_items.
X tries to update a field using the tracker wiki plugin, and fails.
"You do not have permission to modify an item"
Please review my correction proposal. I am rather new with both php and TW.

Wiki pages links are case insensitive but the category permission check for wiki pages menu entry only works if the case of the link matches the case of the wiki page name.

Say you have a wiki page called "Foo" and the "Registered" group has view permission to this page granted by a category. If you create a menu entry linking to the "Foo" page and set the URL as "((Foo))" everything will work as expected. But if you set the URL as "((foo))" the menu option will not appear to the users of the "Registered" group. Obviously for this to happen the "Registered" group must not have global tiki_p_view.

This does not happen if object permissions, instead of category permissions, grant access to the "Foo" page.

Tracker 1
X text field
Y text field

Tracker 2
Y text field
Z text field

Tracker 3
R item link to 1,X
S dyn item list of 1,Y by linking R=X
T dyn item list of 2,Z by linking S=Y <-- this one does not work

Using latest trunk from today (Feb 1, 2010)
Installed blank new tiki site, enabled tiki sheets.
Wishes:

(1) When adding a new sheet, some hint could be shown about the chance to use jquery.sheet interface.

I enabled jquery.sheet plugin, but not ajax.

(2) If ajax is required for jquery.sheet to work (that's what I've been told, but I don't know for sure myself), jquery.sheet should report that ajax is needed and show a link to enable it.

{syntax type="tiki" editor="plain"}
When running the upgrade using tiki-install.php to upgrade from 2.1 to 5 33 database errors are reported. Several of these are "Unknown column 'feature_check' in 'field list'" errors.


During an upgrade, it is normal to have SQL failures resulting with Table already exists messages.

20091105_auth_tokens_tiki
-- 2009-11-05 lphuberdeau CREATE TABLE `tiki_auth_tokens` ( `tokenId` INT NOT NULL AUTO_INCREMENT, `creation` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `timeout` INT NOT NULL DEFAULT 0, `token` CHAR(32), `entry` VARCHAR(50), `parameters` VARCHAR(255), `groups` VARCHAR(255), PRIMARY KEY( `tokenId` ), KEY `tiki_auth_tokens_token` (`token`) ) Table 'tiki_auth_tokens' already exists

20091123_dns_permission_tiki
INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_dsn_query', 'Can execute arbitrary queries on a given DSN', 'admin', 'dsn', NULL, NULL) Unknown column 'feature_check' in 'field list'

20091124_fgal_backlink_tiki
CREATE TABLE `tiki_file_backlinks` ( `fileId` int(14) NOT NULL, `objectId` int(12) NOT NULL, KEY `objectId` (`objectId`), KEY `fileId` (`fileId`) ); Table 'tiki_file_backlinks' already exists

20091204_tiki_p_view_newsletter_tiki
INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_view_newsletter', 'Can view the archive of a newsletters', 'basic', 'newsletters', NULL, 'feature_newsletters') Unknown column 'feature_check' in 'field list'

20091214_perspective_management_tiki
INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_perspective_edit', 'Can edit the perspective', 'admin', 'perspective', NULL, 'feature_perspective') Unknown column 'feature_check' in 'field list' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_perspective_create', 'Can create a perspective', 'admin', 'perspective', NULL, 'feature_perspective') Unknown column 'feature_check' in 'field list' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_perspective_admin', 'Can admin perspectives', 'admin', 'perspective', 'y', 'feature_perspective') Unknown column 'feature_check' in 'field list'

20100107_payment_tiki
CREATE TABLE `tiki_payment_requests` ( `paymentRequestId` INT NOT NULL AUTO_INCREMENT, `amount` DECIMAL(7,2) NOT NULL, `amount_paid` DECIMAL(7,2) NOT NULL DEFAULT 0.0, `currency` CHAR(3) NOT NULL, `request_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `due_date` TIMESTAMP NOT NULL, `cancel_date` TIMESTAMP NULL, `description` VARCHAR(100) NOT NULL, `actions` TEXT, PRIMARY KEY( `paymentRequestId` ) ) Table 'tiki_payment_requests' already exists CREATE TABLE `tiki_payment_received` ( `paymentReceivedId` INT NOT NULL AUTO_INCREMENT, `paymentRequestId` INT NOT NULL, `payment_date` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `amount` DECIMAL(7,2), `type` VARCHAR(15), `details` TEXT, PRIMARY KEY(`paymentReceivedId`), KEY `payment_request_ix` (`paymentRequestId`) ) Table 'tiki_payment_received' already exists INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_payment_admin', 'Can administer payments', 'admin', 'payment', 'y', 'payment_feature') Unknown column 'feature_check' in 'field list' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_payment_view', 'Can view payment requests and details', 'admin', 'payment', NULL, 'payment_feature') Unknown column 'feature_check' in 'field list' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_payment_manual', 'Can enter manual payments', 'admin', 'payment', NULL, 'payment_feature') Unknown column 'feature_check' in 'field list' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_payment_request', 'Can request a payment', 'admin', 'payment', NULL, 'payment_feature') Unknown column 'feature_check' in 'field list'

20100115_tiki_p_admin_modules_tiki
INSERT INTO users_permissions (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES ('tiki_p_admin_modules', 'User can Administer Modules', 'registered', 'tiki', NULL, NULL) Unknown column 'feature_check' in 'field list'

20100128_tiki_p_blog_view_ref_tiki
INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_blog_post_view_ref', 'Can view in module and feed the blog posts', 'basic', 'blogs', NULL, 'feature_blogs') Unknown column 'feature_check' in 'field list' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_blog_view_ref', 'Can view in module and feed the blog', 'basic', 'blogs', NULL, 'feature_blogs') Unknown column 'feature_check' in 'field list'

20100203_payment_detail_tiki
ALTER TABLE tiki_payment_requests ADD COLUMN detail TEXT Duplicate column name 'detail'

20100205_tiki_p_wiki_view_ref_tiki
INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_wiki_view_ref', 'Can view in module and feed the wiki pages reference', 'basic', 'wiki', NULL, 'feature_wiki') Unknown column 'feature_check' in 'field list'

20100211_rss_items_tiki
CREATE TABLE `tiki_rss_items` ( `rssItemId` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, `rssId` INT NOT NULL, `guid` VARCHAR(255) NOT NULL, `url` VARCHAR(255) NOT NULL, `publication_date` INT UNSIGNED NOT NULL, `title` VARCHAR(255) NOT NULL, `author` VARCHAR(255), `description` TEXT, `content` TEXT, KEY `tiki_rss_items_rss` (`rssId`), UNIQUE `tiki_rss_items_item` (`rssId`, `guid`) ) Table 'tiki_rss_items' already exists ALTER TABLE `tiki_rss_modules` DROP COLUMN `content` Can't DROP 'content'; check that column/key exists ALTER TABLE `tiki_rss_modules` ADD COLUMN `sitetitle` VARCHAR(255) Duplicate column name 'sitetitle' ALTER TABLE `tiki_rss_modules` ADD COLUMN `siteurl` VARCHAR(255) Duplicate column name 'siteurl'

20100215_create_tiki_user_login_cookies_tiki
CREATE TABLE `tiki_user_login_cookies` ( `userId` INT NOT NULL, `secret` CHAR(64) NOT NULL, `expiration` TIMESTAMP NOT NULL, PRIMARY KEY (`userId`, `secret`) ) ENGINE=MyISAM AUTO_INCREMENT=1 Table 'tiki_user_login_cookies' already exists

20100215_rating_permissions_tiki
INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_rate_article', 'Can rate articles', 'basic', 'cms', NULL, 'feature_articles') Unknown column 'feature_check' in 'field list'

20100216_attributes_tiki
CREATE TABLE `tiki_object_attributes` ( `attributeId` INT PRIMARY KEY AUTO_INCREMENT, `type` varchar(50) NOT NULL, `itemId` varchar(255) NOT NULL, `attribute` varchar(25) NOT NULL, `value` varchar(100), UNIQUE `item_attribute_uq` ( `type`, `itemId`, `attribute` ), KEY `attribute_lookup_ix` (`attribute`, `value`) ) Table 'tiki_object_attributes' already exists

20100217_rating_config_tiki
CREATE TABLE `tiki_rating_configs` ( `ratingConfigId` INT PRIMARY KEY AUTO_INCREMENT, `name` VARCHAR(50) NOT NULL, `expiry` INT NOT NULL DEFAULT 3600, `formula` TEXT NOT NULL, `callbacks` TEXT ) Table 'tiki_rating_configs' already exists CREATE TABLE `tiki_rating_obtained` ( `ratingId` INT PRIMARY KEY AUTO_INCREMENT, `ratingConfigId` INT NOT NULL, `type` VARCHAR(50) NOT NULL, `object` INT NOT NULL, `expire` INT NOT NULL, `value` FLOAT NOT NULL, UNIQUE `tiki_obtained_rating_uq` (`type`, `object`, `ratingConfigId`) ) Table 'tiki_rating_obtained' already exists

20100218_auth_token_reuse_tiki
ALTER TABLE `tiki_auth_tokens` ADD COLUMN `hits` INT NOT NULL DEFAULT 1 AFTER `timeout` Duplicate column name 'hits'

20100224_object_relations_tiki
CREATE TABLE `tiki_object_relations` ( `relationId` INT PRIMARY KEY AUTO_INCREMENT, `relation` varchar(25) NOT NULL, `source_type` varchar(50) NOT NULL, `source_itemId` varchar(255) NOT NULL, `target_type` varchar(50) NOT NULL, `target_itemId` varchar(255) NOT NULL, KEY `relation_source_ix` (`source_type`, `source_itemId`), KEY `relation_target_ix` (`target_type`, `target_itemId`) ) Table 'tiki_object_relations' already exists

20100226_tracker_dump_perm_tiki
INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_tracker_dump', 'Can save a CSV backup of entire trackers', 'admin', 'trackers', NULL, 'feature_trackers') Unknown column 'feature_check' in 'field list'

20100419_bigbluebutton_tiki
INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_bigbluebutton_join', 'Can join a meeting', 'basic', 'bigbluebutton', NULL, 'bigbluebutton_feature') Unknown column 'feature_check' in 'field list' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_bigbluebutton_moderate', 'Can moderate a meeting', 'admin', 'bigbluebutton', NULL, 'bigbluebutton_feature') Unknown column 'feature_check' in 'field list' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_bigbluebutton_create', 'Can create a meeting', 'admin', 'bigbluebutton', NULL, 'bigbluebutton_feature') Unknown column 'feature_check' in 'field list'

If you think that the errors of a patch can be ignored, please check the checkbox associated to it before clicking on continue.

Created a tracker and a checkbox field in it next to some other fields.
Set appropriate permissions.
When submitting the form, the checkbox is always unchanged.

relevant html source fragment:
<form enctype="multipart/form-data" method="post" action="/tikiwiki-5.0.Beta1/tiki-index.php?page=Test&itemId=3">
<input type="hidden" name="trackit" value="3" />
<input type="hidden" name="iTRACKER" value="1" />
<input type="hidden" name="refresh" value="1" />
<input type="hidden" name="page" value="Test" />
<table class="wikiplugin_tracker">
<tr><td>Name</td><td>
<input type="text" id="track_55" name="track[55]" size="80" maxlength="80" value="My name is XY" /></td></tr>
<tr><td>Check this to confirm</td><td>
<input type="checkbox" name="track[72]" checked="checked"/></td></tr>
</table>
<div class="input_submit_container">
<input class='button submit' type='submit' name='action' value='Confirm' />
</div>
</form>

_REQUEST:
track[55] is available, while track[72] is not

used Firefox 3.6.6

When the 'rel="shadowbox"' parameter is used with a wiki image, the popup expands to the full size of the original image, so scrolling is needed to see all of the image. Previously, the popup size was limited to some percentage of the viewport size.

Also, the "prev/next" links are missing when 'rel="shadowbox[[gallery]' is used; this is also a regression from before.

{syntax type="tiki" editor="plain"}
there is still that issue sometimes with the error undefined "thread sort mode" if you preview an answer before posting it at tw. forums.

It heppened to me again when attempting to reply to a thread with a comment already, and I previewed my post first before attemptint to post it.
When I clicked on post, I saw that message.

TW.o is currently using tiki5beta1 r26677

I get several notices like this:

Deprecated: Assigning the return value of new by reference is deprecated in ...\branches\5.x\lib\ajax\xajax\xajax_core\xajaxAIO.inc.php on line 428

when opening the group permissions page (approximately r27704). This is on Windows with PHP 5.3.1.

{CODE(wrap=>1)}
(18:30:35) xavi: to reproduce: I did search for "Report" at the top bar search
(18:30:42) xavi: showing this url: http://dev.tikiwiki.org/tiki-searchresults.php?highlight=Report&search=Go
(18:30:47) xavi: with this error:
(18:31:14) xavi: [off] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? and ttif.`value`=? and ttifOut.`fieldId`=?' at line 2 The query was: select ttifOut.`value` from `tiki_tracker_item_fields` ttifOut, `tiki_tracker_item_fields` ttif where ttifOut.`itemId`= ttif.`itemId`and ttif.`fieldId`=? and ttif.`value`=? and ttifOut.`fieldId`=?
{CODE}

---
Update on March 31st 2010, using Last update from SVN (5.0alpha): Friday 26 March, 2010 09:12:40 CET - REV 26326 :

{img src=http://dev.tikiwiki.org/tiki-download_item_attachment.php?attId=236 desc="http://dev.tikiwiki.org/tiki-download_item_attachment.php?attId=236"}

{syntax type="tiki" editor="plain"}
dev.tw.o: users apparently can delete their tracker items but they are not deleted and no message

To reproduce:
* Log in as normal user to dev.tw.o (without admin perms) (ot test with user "xavi" if you prefer).
* report a bug/wish
* edit it in order to see the edit form
* click on the red cross to delete it
* after that, you are shown the list of tracker items, as if your tracker item was already deleted. No message indicating any problem is shown. However, the tracker item is not deleted.
+ Example: http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=2879

---
reported in comments as still around in tiki5 and tiki6

{syntax type="tiki" editor="plain"}
Tested on info.tw.o with FiveAlive theme...

Disabling the __Search box__ option on the Admin: Search page, Search Results tab (tiki-admin.php?page=search) will remove the Search bar from the menu.

This is incorrect behavior.

Calendar URLs are currently excluded for spiders and bots, for example:

/calendar?focus=1268089200&viewmode=week

excluded by entries:

Disallow: tiki-calendar.php
Disallow: /tiki-calendar.php

However, the URL /tiki-tell_a_friend.php?url=%2Fcalendar%3Ffocus%3D1268089200%26viewmode%3Dweek would be spidered instead.

{syntax type="tiki" editor="plain"}
I replied to a comment in the page WikiPedia. At that moment, there were already two comments. When I published my comment, the two other comments disappeared. The page still says there are three comments, but My browser can only see either zero or one (mine)

{syntax type="tiki" editor="plain"}
One of our users reported that she was receiving watch notifications whenever she clicked the "Discuss" button for a wiki page, even though she was not posting anything in the forum topic.

The cause was a Watch on "A user posts a forum topic (forum_post_topic)" for the Wiki Page Discussion forum. (Our Tiki uses a forum for page discussion instead of page comments.)

The preferred behavior is that this type of watch would only generate a notification the ===first=== time the Discuss button is clicked for a page, when the new topic is actually created, rather than just accessed on successive clicks.

Hello,

When you use an existing database (UTF8 coded but charset=latin1 and collate=latin1-swedish-ci) converted by tiki-install 5.0 :

1- the titles and contents are displayed : as pure utf8 is saying the French texts (tables defined charset=latin1) :

A- Titles of any item
"L'échec et ses conséquences" is displayed :
" L'échecs et ses conséquences"

B- Texts of dictionnary (language.php UTF8 encoded) as
"créé à partir d'une structure" (comment the update or creation origin of a document) is too displayed
"créé à partir d'une structure"

C- Contents of Wiki or articles : id

D- Menu options : are well displayed
The text comes from the same file language.php (fr)

E- Tiles of column of tables etc. : well displayed

F- Warning messages ?

Everything behaves like the titles and contents even defined as charset=latin1 are dsiplyed as UTF8 while the others are threated well.
Is it a relation with the fact that "modify" action never displays anything because of the query, I will try to understand.

Everything was displayed well in 4.x versions

trebly

!!phenomenon :
On a particular configuration, not identified yet, pieces of text are displayed as latin1 in a pagecode identified as utf-8 encoded.

!!test and facts :
# From a database well encoded utf8 and used with 5.0 on windows : export sql and look at encoding in hexa editor.
# Create from sql file two new database one on a windows installation, the other on Linux (OVH)
# Copy 5.3 to both installations.
# Run install and uses upgrade and convert
# Export databases to sql
# Compare the sql file : identical main data
# On loading the same page from the two servers we obtain two different displays :
## - Locally the delivered html page is clean and well displayed (sourcepage save and edited in hexa and firebug)
##__ - From the OVH server all the data from database are converted to latin1(where ?, probably served by mysql converted to latin1) while the text form system (language file) are displayed in utf8.__
# __ - The behaviour of the OVH installation is completely erratic (because the data are served converted and all indexes request and keys with accents become wrong)
# The Administrator general display says : "database error"__

!!question :
Why the data served to tikiwiki, with exactly the same parameters and data, are right on my server and converted into latin1 on the OVH configuration ?
I have not yet searched into the product, and I don't know, previously, how tikiwiki holds the encoding.

I think that who have developed these piece of product is able to tell me where the encoding to serve by mysql to the product is defined and which parameter can have an effect on the linux server and not on the one on windows.

{syntax type="tiki" editor="plain"}
Tracker plugin:
Imagine we would like to offer modification of a dynamic list field without offering modification of its reference field. In this case, the dynamic list should fall-back to a simple list with no selectValue calls in the js.

{syntax type="tiki" editor="plain"}
As the calculated size of the line, depends of the size of the panel (resizable) is wrong (too of some ... <unable to translate, in printing in french the length unit "point">).
Then the line is always too long of a few for the panel (words or half of words cut before splitting the line).

This makes the blog edition unusable in normal conditions because to edit a text we have to make horizontal scroll continuously.

Analysis : the calculation of the length of line written in text editors is always complex. Generally today there is no problem, but the system which is behind editors is very complex to take in account all display configurations.

(nota : For my own I had developed some years ago a draw system - for engineering, Computer Assisted Drawings - system for windows displaying HPGL2 language drawings with fonts conversion from HPGL2 fonts system to True type, then I know well in details the whole problem)

~~#F0C:__With this problem, I can't let use the tikiwiki 5.3 by my bloggers.__~~

So I have written a warning take care "sorry very difficult to use"

Only the 1st level of File Galleries are shown. Further sub-galleries at a deeper level are hided in the tree view.

this picture shows, that there is no selection box for the selection of a parent gallery for this (new) gallery presented at the form.