Category: 2.x

Tested the WYSIWYG in 1.10 works very well, much to like, especially how well is handles paste from word.

__Needed:__ A popup warning to prevent a lost edit if you switch from wysiwyg to normal editor, this currently causes a ((doc:lost edit))

__Would be nice:__ the buttons in paste from word popup should be more clear "clean up box" should be named "clear box" if that is what it does.

__Would be nicer:__ Word html to Wiki syntax conversion (ignores all unsupported formatting

possibilities:
http://phpmailer.codeworxtech.com/
http://www.swiftmailer.org/
http://framework.zend.com/manual/en/zend.mail.html


Related:
SMTP Configuration from inside Admin Interface
http://dev.tikiwiki.org/wish1711

If the default install, feature_multilingual is disabled since r11761. Nevertheless, change_language (Users can change site language) is still enabled by default.
Since r17625, controlling change_language is dependent on having feature_multilingual enabled.

This creates confusion, like luciash wondering where change_language was today. It's abnormal you have to enable a feature to disable another feature.

*.Tiki.org sites have a large number of external links. It would be nice to have a tool to check all the links and to report on status. Possibly this could be related to the cacheing feature.

See: ((Link Checker))

Please see:
http://en.opquast.com/bonnes-pratiques/

{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.

{THUMB(id=30, url="tiki-browse_image.php?imageId=30")}{THUMB}

Integrating a Simple Classifieds System with Categories and Subcategories would be nice. Each ad should be attached to the user that submitted it and possibly integrated with the user's "my page" so they can keep track of their ads, how many replies they've received and so forth. Nothing too complicated to start with...but it would be a fantastic addition to the software.


ML: Should this be a new feature or done with trackers? If done with trackers, it could distributed via the ((Profile Manager))

Labels for forum administration options to link a Forum and mailing list are very obtuse. Suggested cleanup as made in the documentation would help users.

Make 1.9.11 and 1.10 consistant
Remove less used quicktags and add some in the spirit of ((EditUIRevamp))

when you click on the polls icon on the Admin Home page, you are taken to the polls comments admin page instead of the polls admin page. User should not have to make an additional click to start work.

When you close an old tracker item, it shows up again in the since_last_visit_new module as new tracker item.
This also seems to happen when you change the status to "pending".

It happens also in dev.tikiwiki.org to me (user xavi)
See this one for pending: http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=1946

And this one for closed:
http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=2124&trackerId=5&show=view

I logged in Jan 16th, and they appeared as new to me (user xavi, at least).

---

UPDATE: Still present in 12.x. {sign user="xavi" datetime="2013-11-17T09:52:11+00:00"}

If you create a {CODE()} {CODE} block in a
wiki page or blog post which contains a "$" followed by a digit somewhere on the page, the page will not be rendered correctly. In fact, the text "($10), $0" will prevent the entire page from being rendered at all. In a blog post it can make the entire blog inaccessible.

Seen in v2.3.

Sounds identical to this closed tracker item: [http://dev.tikiwiki.org/tiki-view_tracker_item.php?trackerId=5&itemId=218&highlight=code|Wiki: CODE block may not contain "$0"]

When page content is too large, the browser is way too large or some content is truncated/hidden:
http://dev.tikiwiki.org/tiki-pagehistory.php?page=Hello%20World&preview=73

This is the good behavior in Firefox but not IE6:
http://www.wikicreole.org/wiki/TikiWikiCMSGroupware

Maybe CODE plugin should have wrap=1 by default, but with the horizontal scroll, it'll be OK.

Yeah, we're building a COBOL advocacy TikiWiki site. The CODE plugin removes leading indentation. FIXED format COBOL uses a 6 character sequence number, column 7 as a special indicator and actual code starting at column 8. The initial $code = trim($data); is inappropriate for COBOL, and perhaps for other snippets that need to be cut'n'pasted with indentation intact.

I'd almost just go ahead and commit the change, but I'm not experienced enough with the technical details of PHP, and worry that the solution I'm using locally is not an unacceptable performance hit or that using the > v4.1 charlist feature of the trimming functions breaks legacy Tiki installations. I doubt it, but I thought I'd start here and get expert opinions.

{img src=images/code.png}%%% {CODE(colors=>php, title='lib/wiki-plugins/wikiplugin_code.php')}
function wikiplugin_code($data, $params) {
if ( is_array($params) ) {
extract($params, EXTR_SKIP);
}
$code = trim($data);
$parse_wiki = ( isset($wiki) && $wiki == 1 );

// Detect if GeSHI (Generic Syntax Highlighter) is available
{CODE}

All that is required is changing trim($data); to rtrim(ltrim($data, "\n\r\0\x0B")); so that leading spaces and tabs (tabs, they should be removed ... just because ... but that's not playing nice with others) are left intact.

We're using GeSHi, but this trim occurs regardless.

Thanks for listening,
Brian

Say I want to use several RSS feeds in Tiki, I need to make a module for each. Or to add several calls in a wiki page. However, if I have some very active sites (like tikiwiki.org, and some not so active (like mobile.tikiwiki.org), the slow news sites is taking up precious screen space.

Now:
{CODE()}
{rss id=1 max=10}
{CODE}

Nicer:
{CODE()}
{rss id=1+2+5 max=10}
{CODE}

When editing a page on dev.tw.o, I will have proper grammar and punctuation, but after I save it, it appears that all of my commas "," are stripped out in the display. When I go to edit (or even a preview from an edit), the commas also disappear from the edit window.

While not really a high priority, bad, this will crash the app bug, I think it's pretty important for someone who typed in text with proper grammar to have that show up.

*** Also noticing in the tracker, that when I submitted this ticket I had selected something in the Data Type, Feature, and Version sections, but they didn't save, as well as Area and Related Project. ****

It is now possible to comment a file gallery. However, it would be more useful to be able to comment an individual file.

For example, someone uploads an audio or videoclip, others could comment.

suggestion by Yannick Boily

It is now possible to comment an image gallery. However, it would be more useful to be able to comment an individual image.

For example, to identify who are the people on the photo.

suggestion by luciash d' being aka Lukáš Mašek

Since this is vast project, we'll use a wiki page: ((CRM))

Some examples:
http://conf.phpquebec.com/en/horaire
http://code.google.com/events/io/sessions.html

{syntax type="tiki" editor="plain"}
The registration email seems to give boxed char when mail templates are in french.

I had to add utf8_encode()
to LINE 2727 of lib/userslib.php
$mail_data = utf8_encode($smarty->fetch("mail/$mailTemplate.tpl"));
in order to correct the text display problem.


But when I debug with
$mail_data = mb_detect_encoding($smarty->fetch("mail/$mailTemplate.tpl"));

It return the tpl as already in UTF-8, but I had to utf-8 it again to correct it, can someone look into this?

contributors (from contribution feature) are not listed on the contributors list at the bottom of a wiki page in view mode. (collaborative style set at wiki admin)

They are shown in history of the wiki page in a new column called "contributors", which is fine, but when viewing a page, and when wiki set up as collaborative style for listing contributors, author and those "contributors" should be included all together in the list of contributors.
Example:
http://www.iesbarcelona.org/ESSO350/tiki-index.php?page=2009s%20EAP%20Buses%20and%20Metro

listed three users (Authors) as contributors.
However, if you go to history:
http://www.iesbarcelona.org/ESSO350/tiki-pagehistory.php?page=2009s%20EAP%20Buses%20and%20Metro

you can see a fourth user in the contributors column.
That user can't see her name on the list of contributors, and requests for help to site admin due to that fact, etc.

Perhaps no one is using copyright management, but it totally doesn't work. The copyrights.php file says it can only be called as an include (and has access checking for that), yet it is in fact called directly by the copyright license page.

Also, there is an access check to see whether the feature is installed that appears to fail completely. As a hack I commmented it out to make it work.

Tied to that, the copyright module doesn't work - it looks for "copyrightpage" as the parameter, when the pagename is sent via "page"

I have no idea whether it was broken in 1.9, but looking at the code, I suspect so.

Removing an avatar results in an broken image link.

Reproduce:
* Hovering the mouse pointer on a user name reveals the user details.
* Create an avatar for that user.
* Hovering the mouse pointer on the user name now shows the user details including avatar.
* Delete the avatar.
* In place where the avatar was showing before, there's now a broken image in the user details.

Tiki site: http://list.vic-fontaine.com/
demo user/ password: smarty