Category: 3.x

I created a test environment with the following components:
Apache 2.2.10
PHP 5.2.8
MySQL 6.0.8 alpha

I was not able to get MySQL 5.1 working on my machine,
but I was abe to get 6.0.8alpha runnning smooth.

I checked out the latest code in TRUNK 15953
pointed Apache to the files.

I ran tiki-install.php without problems except the following 3 SQL problems
which I suppose is due to MySQL version 6.0.8alpha

As my SQL skills are not up to date...
Are there any solutions for these bug?

Do not propose, that version 6 of MySQL is not supported :-)

~np~CREATE TABLE tiki_banning (
banId int(12) NOT NULL auto_increment,
mode enum('user','ip') default NULL,
title varchar(200) default NULL,
ip1 char(3) default NULL,
ip2 char(3) default NULL,
ip3 char(3) default NULL,
ip4 char(3) default NULL,
user varchar(200) default '',
date_from timestamp(14) NOT NULL,
date_to timestamp(14) NOT NULL,
use_dates char(1) default NULL,
created int(14) default NULL,
message text,
PRIMARY KEY (banId)
) ENGINE=MyISAM AUTO_INCREMENT=1~/np~
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 '(14) NOT NULL,
date_to timestamp(14) NOT NULL,
use_dates char(1) default NUL' at line 10

~np~CREATE TABLE tiki_friendship_requests (
userFrom varchar(200) NOT NULL default '',
userTo varchar(200) NOT NULL default '',
tstamp timestamp(14) NOT NULL,
PRIMARY KEY (userFrom(120),userTo(120))
) ENGINE=MyISAM~/np~
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 '(14) NOT NULL,
PRIMARY KEY (userFrom(120),userTo(120))
) ENGINE=MyISAM' at line 4

~np~CREATE TABLE tiki_users_score (
user char(200) NOT NULL default '',
event_id char(200) NOT NULL default '',
expire int(14) NOT NULL default '0',
tstamp timestamp(14) NOT NULL,
PRIMARY KEY (user(110),event_id(110)),
KEY user (user(110),event_id(110),expire)
) ENGINE=MyISAM~/np~
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 '(14) NOT NULL,
PRIMARY KEY (user(110),event_id(110)),
KEY user (user(110),ev' at line 5

Doesn't seem to have had any adverse effects but did see these errors when upgrading a test site from 2.2 to 3.0beta1

#2008-10-19 sylvieg
ALTER TABLE tiki_users_score CHANGE event_id event_id char(200) NOT NULL default ''
Specified key was too long; max key length is 1000 bytes
ALTER TABLE tiki_users_score ADD PRIMARY KEY (user(110),event_id(110))
Incorrect sub part key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique sub keys
ALTER TABLE tiki_users_score ADD KEY user (user(110),event_id(110),expire)
Incorrect sub part key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique sub keys
INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_search_categorized', 'Can search on objects of this category', 'basic', 'category')
Duplicate entry 'tiki_p_search_categorized' for key 1

Trying to sort on any column in a tracker results in a blank screen with a single checkbox in the upper lefthand corner. The column sorting was working in 2.3 and 2.4, but does not work in 3.0 with either the "Tikipedia" or "thenews" themes.

Have had results of dual checkboxes with one being labeled "Select all". Strange. Sorting is a nice feature of trackers, and I miss it.

When you click on the header, it suppose (I assume this) that it will sort on that column/field.

It does not, obviously.

Here are some options
http://framework.zend.com/manual/en/zend.service.akismet.html
http://bad-behavior.ioerror.us/
http://antispam.typepad.com/
http://www.defensio.com/
http://mollom.com/

See: ((Spam Protection))

There are many common non-alphanumeric characters that, when part of the title of a wiki page, break the ability to link to that page using the ~np~((Name of page))~/np~ method.

Characters which cause this type of linking to break include: comma (,), apostrophe ('), hyphen (-), question mark (?), asterisk (*), and percent sign (%).

The consequence is (a) you're extremely limited in what characters you can include in titles or (b) you have to link to a page by its URL. (b) is very limiting, because when a page is renamed, all the links to it will break.

Test with this:
~np~
((test,test))

((test's test))

((test-test, hyphen))

((test? question mark))

((test*test asterisk))

((100% correct))

((this should work with no problems))

((test_underscore))
~/np~

You'll see:
~np~
((test,test))

((test's test))

((test-test, hyphen))

((test? question mark))

((test*test asterisk))

((100% correct))

this should work with no problems?

test_underscore?
~/np~
In other words, all but the last two page names ("this should work with no problems" and "test_underscore") were ''not'' treated correctly as being links to web pages.

{syntax type="tiki" editor="plain"}
Hi,

I do not know if this problem was already posted, but a search for php 5.3 only got me a blank page.

Ok the problem is the following:
We have an older test area with openSUSE 11.1 running and no problems so far. We back this server up to another server with the same OS and never had problems. Both running PHP 5.2.x and MySQL 5.0.x.

As we set up a server on an old pc for testing purposes with the latest openSUSE 11.2 and PHP 5.3 and MySQL 5.1.x and tried to copy the tiki on this machine all the special characters (Umlaute like &auml, &ouml or ü) wouldn't be displayed properly but like they are stored in the database like Ãœ (I hope it wouldn't be displayed as an Ü here but rather as it would be stored in the database).

This happened on several installations on different machines and on different virtual machines - it all works without problems in the old environment but has problems under the new.

I also hope that Ü will be displayed not as HTML Code but as the real character as i cannot type in the ue through this vncviewer.

It was tested with the 3.x release. And i guess we once tried it too with the 4.x release with the same problem.

As solution we downgraded to an older PHP Version. Also it is possible to write a small php script to replace all Ãœ to Üor ue and the same with the other special characters. But therefore you need to know all special characters with all the corresponding (I guess it would be) utf8 codes.

When my default mysql engine is InnoDB and default charset is utf8, I get these errors both during a clean 3.0 install and during a DB 2.4->3.0 upgrade (excluding duplicate key/item errors):

~pp~
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))
)
Specified key was too long; max key length is 767 bytes
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-index.php\\?page=(.+)', '$1', 'wiki', 'feature_wiki')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-slideshow.php\\?page=(.+)', 'show:$1', '', 'feature_wiki')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-read_article.php\\?articleId=(\\d+)', 'article$1', 'article', 'feature_articles')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-browse_categories.php\\?parentId=(\\d+)', 'cat$1', 'category', 'feature_categories')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_blog.php\\?blogId=(\\d+)', 'blog$1', 'blog', 'feature_blogs')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_blog_post.php\\?postId=(\\d+)', 'blogpost$1', 'blogpost', 'feature_blogs')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-browse_image.php\\?imageId=(\\d+)', 'browseimage$1', 'image', 'feature_galleries')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_chart.php\\?chartId=(\\d+)', 'chart$1', 'chart', 'feature_charts')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-directory_browse.php\\?parent=(\\d+)', 'directory$1', 'directory', 'feature_directory')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_faq.php\\?faqId=(\\d+)', 'faq$1', 'faq', 'feature_faqs')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-list_file_gallery.php\\?galleryId=(\\d+)', 'file$1', 'file', 'feature_file_galleries')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-download_file.php\\?fileId=(\\d+)', 'dl$1', 'file', 'feature_file_galleries')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_forum.php\\?forumId=(\\d+)', 'forum$1', 'forum', 'feature_forums')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-browse_gallery.php\\?galleryId=(\\d+)', 'gallery$1', 'gallery', 'feature_galleries')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('show_image.php\\?id=(\\d+)', 'image$1', 'image', 'feature_galleries')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('show_image.php\\?id=(\\d+)&scalesize=(\\d+)', 'imagescale$1/$2', 'image', 'feature_galleries')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-newsletters.php\\?nlId=(\\d+)', 'newsletter$1', 'newsletter', 'feature_newsletters')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-take_quiz.php\\?quizId=(\\d+)', 'quiz$1', 'quiz', 'feature_quizzes')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-take_survey.php\\?surveyId=(\\d+)', 'survey$1', 'survey', 'feature_surveys')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_tracker.php\\?trackerId=(\\d+)', 'tracker$1', 'tracker', 'feature_trackers')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-integrator.php\\?repID=(\\d+)', 'int$1', '', 'feature_integrator')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_sheets.php\\?sheetId=(\\d+)', 'sheet$1', 'sheet', 'feature_sheet')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-directory_redirect.php\\?siteId=(\\d+)', 'dirlink$1', 'directory', 'feature_directory')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)\&calIds\\[\\]=(\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)', 'cal$1,$2,$3,$4,$5,$6,$7', '7', 'calendar', 'feature_calendar', 100)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)\&calIds\\[\\]=(\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)', 'cal$1,$2,$3,$4,$5,$6', '6', 'calendar', 'feature_calendar', 101)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)\&calIds\\[\\]=(\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)', 'cal$1,$2,$3,$4,$5', '5', 'calendar', 'feature_calendar', 102)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)\&calIds\\[\\]=(\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)', 'cal$1,$2,$3,$4', '4', 'calendar', 'feature_calendar', 103)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)\&calIds\\[\\]=(\\d+)\&callIds\\[\\](\\d+)', 'cal$1,$2,$3', '3', 'calendar', 'feature_calendar', 104)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)&calIds\\[\\]=(\\d+)', 'cal$1,$2', '2', 'calendar', 'feature_calendar', 105)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)', 'cal$1', '1', 'calendar', 'feature_calendar', 106)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-calendar.php', 'calendar', 'calendar', 'feature_calendar', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-view_articles.php', 'articles', '', 'feature_articles', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-list_blogs.php', 'blogs', '', 'feature_blogs', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-browse_categories.php', 'categories', '', 'feature_categories', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-list_charts.php', 'charts', '', 'feature_charts', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-contact.php', 'contact', '', 'feature_contact', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-directory_browse.php', 'directories', '', 'feature_directory', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-list_faqs.php', 'faqs', '', 'feature_faqs', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-file_galleries.php', 'files', '', 'feature_file_galleries', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-forums.php', 'forums', '', 'feature_forums', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-galleries.php', 'galleries', '', 'feature_galleries', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-login_scr.php', 'login', '', '', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-my_tiki.php', 'my', '', '', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-newsletters.php', 'newsletters', 'newsletter', 'feature_newsletters', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-list_quizzes.php', 'quizzes', '', 'feature_quizzes', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-stats.php', 'stats', '', 'feature_stats', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-list_surveys.php', 'surveys', '', 'feature_surveys', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-list_trackers.php', 'trackers', '', 'feature_trackers', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-mobile.php', 'mobile', '', 'feature_mobile', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-sheets.php', 'sheets', '', 'feature_sheet', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
~/pp~

Possibly related bug: http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=2346

In the new version of tikiwiki 3.0 is the tiki-3.0-pgsql.sql wrong. It looks like a copy of the mysql file. BUT: not only the pgsql, also the sqlite and oci8-file.

There are still the ENGINE elements, and some special types from mysql like KEY instead of INDEX or Triger for pgsql

If staging & approval is enabled then staging pages are marked with * however even after saving the staging pages no link for approval of page is shown. one has to approve staging page only by manually calling tiki-approve.php

{syntax type="tiki" editor="plain"}
With Staging and Approval, you are required to setup a category for Staging, and one for Approval.

My site has other categories, lets call them A and B. I have things setup fairly tight so only people in group A can view/edit Category A content. I also want to restrict the approval process to only a few people in group C.

If someone in group A modifies a page in Category A, it gets assigned to the staging category.

<Enter the bug>

Once I Approve that change, the page now belongs to Category A AND the approval category. Since not all users have view/edit rights to the approval category, they are now unable to edit that page any further.

Dear All

There is a problem with wiki staging and approval on Tiki 3.0 namely that practically it can not be switched off once it was turned on.

Description:

The issue is that if I switch the feature off than edit an approved page than upon save all content of a wiki page gets duplicated. If I save again, it duplicates again and there is no escape. ("Preview" shows ok but "minor edit" makes the mistake too).

The same thing happens if staging and approval is switched on with the following setting:

''__Force bounce of editing of approved pages to staging__'' is NOT marked (preference wikiapproval block editapproved disabled)

Workaround: if a page gets messed up as described above, switch on staging and approval again, enable ''preference wikiapproval block editapproved'', make an edit of the page, deleted the duplicated content, approve and the official page will be fine again

Some more notes: I was working as admin, the site was on TW2.4 before, it was upgraded with the official 3.0 release only, Staging and approval was switch on the first time, it was __not__ used with 2.4 version

Please resolve this if possible,
Many thanks,
Gezza

---
Update:

actually it happens now also when we edit a staging page twice. If I edit once, than approve, all is fine. If I edit twice the staging copy content starts to get duplicated :(

A sticky topics would be really nice. When you guys are fixing the errors in the forums, make a change and implement the sticky topic

{img src=images/code.png}%%% {CODE(caption=current strikethrough syntax)}
{TAG(tag=>strike)}texte{TAG}
{CODE}

Suggested one for us:
--strike--

As suggested in wikicreole:
http://www.wikicreole.org/wiki/Strike

All wiki engines:
http://www.wikimatrix.org/syntax.php?i=27

This is very useful when using wiki pages for ((project management))

{syntax type="tiki" editor="plain"}
Structure numbering at the top of the Wiki pages differs to how it should display and is shown , for example, in the Structure modify page.
Xavi asked me to submit this as a bug.

{syntax type="tiki" editor="plain"}
Structure numbering at the top of the Wiki pages differs to how it should display and is shown , for example, in the Structure modify page.
Xavi asked me to submit this as a bug.

{syntax type="tiki" editor="plain"}
Goal

We want doc.tw.o to generate nice printed documnentation.

Problem
It's too difficult to detect which pages are not in a structure.


A new page may be created but not assigned to a structure and be lost, and not appear in the printer version.

It's ok that some pages are not in structures (notes, redirects, etc) though.


tiki-edit_structure.php -> list at the bottom should only show me pages that are not in current structure, otherwise, I can add the pages at two places in the structure.(feature or bug?) This could useful to move pages though because current system is too cumbersome for large structures like the one on doc.tikiwiki.org


Perhaps, the structure if should appear in list pages. So by sorting, we could find all orphan pages...

Documentation of Tiki (doc.tw.o) needs some help, as well as any other tiki site aiming to produce structured documentatation to be exported as "printer-ready" (.pdf, .odt, ...)

!!- (1). Original idea, as posted in devel list (but improved, and made it easier, below, in (2) )
I include here a copy of the [http://sourceforge.net/mailarchive/forum.php?thread_name=467565F1.9080905%40ub.edu&forum_name=tikiwiki-devel|original post at tiki-devel list]:

{QUOTE()}
[Tikiwiki-devel] New documentation file: Tiki198alpha.pdf
From: Xavier de Pedro Puente <xavier.depedro@ub...> - 2007-06-17 16:44

(...)

There are some issues that, it solved from coders, they would make
easier to produce next documents like the pdf ones:

(1) Page Title is not automatically shown on wiki pages on the server,
and thus, manual header1 was added everywhere (Almost). But when
printing to html, page title is duplicated. => if Show Page Title option
is disabled under "Admin > Wiki", Page title should not be added
automatically at print-to-html time.

(2) to produce the same structure (same level structure of headings) as
in table of contents http://doc.tikiwiki.org/Documentation , some hack
(optional) would be very welcome so that heading 1 in doc.tw.o pages is
not printed as heading 1 in through the multiprint, but as header 2, at
least. (optional).
This is, for instance, what is produced when printing a full structure
from a Workspace - AulaWiki Mod - : a coder could grab the code from
AulaWiki Mod as a reference....
In there, the description of the page is set as the Page title (header
2, I think), and the page title is included below for completeness (in
lower font, and with version number next to it)...

edutwo_ws_print_structure4.png

(3) Numbering of headings: somehow, in Workspaces this is handled
internally, and the user/documenter doesn't need to bother with manual
numbering: it's produced also at print time.
[http://edu.tikiwiki.org/tiki-workspaces_view_structure.php?print=4]

Example of print structure differences between Tiki's multi-print and
Workspaces print structure:

Print to html "Aula-Wiki Tutorial" from here:
[http://edu.tikiwiki.org/tiki-print_pages.php]

or from here:
[http://edu.tikiwiki.org/tiki-workspaces_view_structure.php?print=4]

Well, as you could imagine, some changes to the code to make the work of
documenters a bit easier would be very wellcome also... :-)

(...)

{QUOTE}

!! (2) Update July 20th: Easier solution
Easier solution: Get levels for first heading in each wiki page of the structure not from the content of the page.

^__Example__: a page may start with a "! Title of page" (first level heading), and after that, "!! Subtitle of page" (2nd level heading), ...

Imagine that this page corresponded to "2.3.1 Module whatever" as the level in the table of contents of such structure.

The solution would be then that "!Title of page" (in that page "2.3.1 Module whatever"), when sent to (or fetched by) tiki-print_pages.php as a whole structure, was converted to "!!! Title of page"; and "!! Subtitle of page", should be converted to "!!!! Subtitle of page"..., and this way sequentially for all the title headings on each page from the structure...
^

The procedure below should become a 1-click from wiki (structures) to[http://doc.tikiwiki.org/Tiki19beta.pdf|PDF]. Please see:[http://doc.tikiwiki.org/Printing+the+Documentation|How to produce the .pdf out of the .odt]

-----

Dec 13 2008. Update:
Previous problem is fixed. However, I notice that automatic numbering with heading within a page (!!#, !!!#, ...), should be also considered in the global autonumbering.

Plus width of wide images and tables would be better if not that wide when exported to html (maybe an option), for the case when you plan to import it to OpenOFfice, and they are too wide to the document. Should this be another RFE or bug report?

---
REOPENING BUG
update on Jan. 7th, 2009:
See the other bug report: autonumbering didn't work for me with doc.tw.o/Documentation, even if it did a month ago on another site/structure

Related (and newer) bug report/RFE:
[http://dev.tikiwiki.org/bug2255]

{syntax type="tiki" editor="plain"}
When the system is set up to use staging & approval and the Structures are turned on, pages/topics created using the Add Page feature included with Structures get created with a staging name. The structure fails/disappears when the page is approved (fails in that the structure loses the staging name and does NOT substitute in the page without the staging name).

{syntax type="tiki" editor="plain"}
If you turn on SEF all your links will be converted to SEF-links so far with the exception of the links the bradcrumb bar of the structure.

Tested on tiki 3.5

Suckerfish menu dropdown items flicker in IE6 (rapidly switch between being displayed and background showing), apparently due to a javascript conflict. This happens whether or not jquery (w/ or w/o superfish) is activated. This type of menu works fine in IE6 normally (such as at the Superfish demo site), so there seems to be a conflict with something in Tiki. A Google search turned up similar problems in Joomla and Drupal, and was caused there by some conflict with some the javascript used by some module or other. I tested CSS variations, to rule out the possibility of CSS being the cause - no change made a difference.

Assuming Tiki will move from php layers menus to suckerfish menus, and there will still be a significant number of IE6 users, this should be solved as soon as possible.

Please go to "Syntax Examples" here:
http://www.wikimatrix.org/compare/TikiWiki-CMS-Groupware+MediaWiki

Please also see:
http://meta.wikimedia.org/wiki/Help:Wikitext_examples

Some syntax could be supported as it doesn't really conflict with the existing.

__Basic formatting markup__
{img src=images/code.png}%%% {CODE()}
You can ''italicize text'' by putting 2 apostrophes on each side.

3 apostrophes will '''embolden the text'''.

5 apostrophes will '''embolden''' and ''italicize''
'''''the text'''''.
{CODE}


__Signature/timestamp__
{img src=images/code.png}%%% {CODE()} You should "sign" your comments
on talk pages:
- Three tildes gives your
signature: ~~~
- Four tildes give your
signature plus date/time: ~~~~
- Five tildes gives the
date/time alone: ~~~~~ {CODE}

__Section headings__
{img src=images/code.png}%%% {CODE()} == Section headings ==

''Headings'' organize your writing into
sections.
The ''Wiki'' <u>ab</u>
##software can automatically
generate a [[table of contents]] from them.

=== Subsection ===
Using more "equals" (=) signs creates a subsection.

==== A smaller subsection ====

Don't skip levels,
like from two to four equals signs.

Start with 2 equals signs not 1
because 1 creates H1 tags
which should be reserved for page title. {CODE}


However, links & images could be more problematic.

Related:
*[wish1531|Wiki markup for icons]
*[wish1191|Wiki editing: Preview with diff, like Mediawiki]
*[wish1843|Infoboxes like MediaWiki/Wikipedia, but making use of trackers to be future-proof]
*[wish1781|Support for the Wiki creole markup (syntax)]
*[wish1220|MediaWiki import script]

Syntax that should work inside a description term (the x in ";x:y") don't. This includes anything in a ':' in it even if it's nested within another syntax structure like a link or table. In a link, it's especially bad, since you can't use ~np~~np~~/np~ to fix it, e.g. you can't fix ~np~((a:b))~/np~. Also, ~np~~~color:x~~~/np~ doesn't work.

~pp~
!!!~np~;a:text~/np~
;a:text
works
%%%%%%%%%%%%
!!!~np~;~~red:a~~:text~/np~
;~~red:a~~:text
looks like ~np~;a:text~/np~
%%%%%%%%%%%%
!!!~np~;((a)):text~/np~
;((a)):text
works
%%%%%%%%%%%%
!!!~np~;((a:b)):text~/np~
;((a:b)):text
looks like ~np~;a:((a:b|b)):text~/np~
%%%%%%%%%%%%
!!!~np~;((a|b:c)):text~/np~
;((a|b:c)):text
looks like ~np~;b:((a|c)):text~/np~
%%%%%%%%%%%%
!!!~np~;((a|~np~b:c~/np~~/np~~np~)):text~/np~
;((a|~np~b:c~/np~)):text
works
%%%%%%%%%%%%
!!!~np~;__a__:text~/np~
;__a__:text
works
%%%%%%%%%%%%
!!!~np~;||a||:text~/np~
;||a||:text
works
%%%%%%%%%%%%
!!!~np~;||a:b||:text~/np~
;||a:b||:text
this just looks strange
~/pp~

I looked in the parser code, and it's pretty obvious why these bugs occur. The parser code, to put it bluntly, sucks. It uses regexps for most parsing instead of a proper context-free parser, so it's bound to have these types of bugs.

I instaled a tiki site using tiki 3 svn. Installed collaborative community profile (althought it might not affet the bug). Just in case, this implies: strasa.css

When the user goes to admin trackers i order to import a tracker from another tiki site, there is not tab for "import export" (at tiki-admin_trackers.php). However, the interface is under the tab "Duplicate tracker".

Later on, when you have trackers, you see the tab, but not at the beginning.

When creating a page, include quick tags in the Folksonomy Tags box. They show up in the Most popular tags module, but when clicked on in the cloud none of the tags entered on a Blog page can be found. Tags from gallery and wiki pages are found and listed, but nothing from any Blog page.

This is consistent across three Tikiwiki sites. Although they are all hosted on the same server.

Have tried it with Linux & Windows, Firefox, IE, Opera & W3M.

Tiki version: 3.1
PHP Version: 5.2.9
Apache version: 2.2.13 (Unix)
MySQL version: 4.1.22-standard