Category: Release50

Users Information Tracker Fields Asked at Registration Time
(fieldIds separated with :)
corresponds with the Tracker plugin's fields

No autoassign is possible by the time of registration, while the plugin would offer that TW5<=.

When selecting a Machine Translation, the resulting page is "broken" -- the left & right columns appear after/under the center column.

Tested with 5.0SVN on http://info.tikiwiki.org with FiveAlive theme

To duplicate:

#Go to home page: http://info.tikiwiki.org/tiki-index.php?page=HomePage
#Select machine translation: __Spanish__
The left column in the Spanish translation is at the bottom of the page.

On open suse 11.0/1/2 using profile:intranet The calendar feature does not seem to show the newly created calendar.

warn user by means of e-email that his/her tracker item status is going to automatically change status in short if no modifications are made within the time frame specified (see 2) ). That warning message could be sent a week in advanced of the dead line (or some days specified by the tracker creator at the tracker definition).
---
This could be also applied to dev.tw.o/tracker5

When using articles on a tiki 5 site, using a thenews.css-based theme style, we don't see the horizontal menu at the top bar.
On all the other tiki features, that menu is shown as expected.
You can reproduce that here:
http://intercanvis.net

versus


http://intercanvis.net/articles

Try this:
{CODE()}
{GROUP(groups=>"xyz")}
{PLUGIN(that takes long) /}
{ELSE}
{ANOTHERPLUGIN(that takes long) /}
{GROUP}
{CODE}

The parser goes through both plugin and another plugin.

Related: 3134
http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=3134&trackerId=5&show=view

Is the parser improvement already on the TW6.0 blockers' list?

It is rather difficult to write plugins that embed other plugins. The reason is the wiki syntax of the plugins not expressing if it is a beginning or an ending clause. The default is the "{X} body {X}" syntax.
Instead, {X} body {/X} should be used.
While this latter syntax as well as the {X /} are accepted by $tikilib->parse_data, it does not process the embedded calls. E.g {X} {X /} {/X} does not work. It returns an empty body instead of {X /} or the result of {X /}.

* report about usability (& scary bug for the end user because WSoD)
** intro: you have one site with a custom theme in a tiki installation. No change of theme is allowed for users.
** problem (when): you upgrade from tiki3 to tiki5 to a new folder in your server or new server, without your new custom theme there yet.
** problem (what): after upgrade, anons. see the site in thenews.css (for instance). Good enough. But once you log in in the upgraded site, you get WSoD, until you are able to remove the .css seletions stored in tiki_preferences table.

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