Category: Release50

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

If you activate the function "check orthography" in params of a tiki page when editing it, When you save you get systematically the following error :


__!System error.__

Le message d'erreur suivant a été renvoyé :

__Table 'spacprottwk153.babl_words_fr' doesn't exist__

The query was :
select `word` from `babl_words_fr` where `word`=? or `word`=?

Valeurs :

1. Table
2. table

The built query was likely :
select `word` from `babl_words_fr` where `word`='Table' or `word`='table'

Things to check:

1.

Is your database up and running?
2.

Is your database corrupt? Please see how to repair your database
3.

Are your database credentials accurate? (username, database name, etc in db/local.php)
4.

Did you complete the Tiki Installer?

Please see the documentation for more information.

__The database is conform to update from 4.1 and validated__

User with Editor plus sheet edit permission tried to create a Tiki Sheet in v2.0RC4 -Arcturus-.

An error occured in a database query!

Context:
File tiki-sheets.php
Url tiki-sheets.php
Query:
INSERT INTO `tiki_sheets` ( `title`, `description`, `author` ) VALUES( ?, ?, ? )
Values:
0 testsheet
1 this is a test
2 NULL
Message:
Column 'author' cannot be null
Built query was probably:
INSERT INTO `tiki_sheets` ( `title`, `description`, `author` ) VALUES( 'testsheet', 'this is a test', NULL )

Email a periodic digest (report) of a tracker activity (new open, and changed to pending or closed).

For sites with low activity but high interest in the users on a specific tracker activity, such as Barter networks ( http://intercanvis.net and similar) such feature is needed for users, who register, but then, after a few months, they don't visit the tiki site any more to see notifications of changes (and they didn't know how to browse the categ. tree to select which categories to watch.

However, other (closed source) bartner software sends a monthly digest to registered users with new items added to each tracker. And this would be very welcome by users (usability)

Links to remove email notification messages come without hash (see below the live example from TikiFestNY)

http://tikiwiki.org/tiki-user_watches.php?hash=

{QUOTE()}
Edit article post: TikiFest NY by lindon at Tue 24 Nov. 2009 06:10 CET

View the article at:
http://tikiwiki.org/article179

If you don't want to receive these notifications follow this link:
http://tikiwiki.org/tiki-user_watches.php?hash=
__''Announcing the first ever TikiFest in New York City being held from January 14-18, 2010!''__

TikiFestNY is a big bug squash! The idea is to knock out as many bugs as possible and have as much fun as possible doing it. If a bug takes more than 30 minutes to fix, then we move on to the next one. Also, invites will be going out locally for an introduction to Tiki presentation on Saturday afternoon followed by refreshments. Hope lots of people can make it! Remote participation is also possible for those that can't. Find complete information at TikiFestNY.

%%%::__~~purple:{COUNTDOWN(enddate=>14-Jan-2010 locatetime=>off)} until TikiFestNY!{COUNTDOWN}~~__::

%%%::''__See you there!__''::
----------------------
{QUOTE}

{syntax type="tiki" editor="plain"}
External feeds don't show anymore the date of the feeded content, and they used to do while in Tiki3. After upgrade to Tiki4 and Tiki5 (or with new Tiki5 installs), dates are not shown any more.

The problem might be in the Tiki providing the feeds, not the tiki getting them.

E.g.:
http://moviments.net (using Tiki 3.5 by the time of this bug report) is set to fetch in a module in the right column (called "__Altres esdeveniments__") the feed from a site with Tiki 5rc2 (from svn) here:
http://intercanvis.net/tiki-calendars_rss.php?ver=2

Previously, the right modules in moviments.net was showing the dates properly of each calendar item fetched.

In tikilib.php, the external link icon is hardcoded:
{CODE(wrap="1",colors="php")} if ($prefs['feature_wiki_ext_icon'] == 'y' && !$options['suppress_icons']) {
$ext_icon = "<img border=\"0\" class=\"externallink\" src=\"img/icons/external_link.gif\" alt=\" (external link)\" />";
}{CODE}

That is not good if you want that icon to be different.
You have to overwrite img/icons/external_link.gif with your own, and remember to re-overwrite it when updated to a new Tiki.

It would be better to either allow the user/admin to give a link to an alternative icon, or even better: put it in CSS, so that it can be overwritten in themes.

A quick fix would be to change line 5806 and line 6245 from this:
{CODE(wrap="1",colors="php")}$ext_icon = "<img border=\"0\" class=\"externallink\" src=\"img/icons/external_link.gif\" alt=\" (external link)\" />";{CODE}
to this:
{CODE(wrap="1",colors="php")}$ext_icon = "<span class=\"externallink\">   </span>";
{CODE}
And then put a CSS class in design.css or other appropriate css file, so that it can be overridden by theme css:
{CODE(wrap="1",colors="css")}.externallink
{
background: url(img/icons/external_link.gif) no-repeat;
}{CODE}

feature alias (semantic links) is not SEF (search engine friendly) ready

Using 4.2.
See it here:
page:
http://gavarrespedia.org/pendent

has a few aliases such as:
{CODE()}
(alias(pendents))
{CODE}

If you have SEF feature off (btw, and htaccess rewrite rules on), when you type:
http://gavarrespedia.org/pendents

you get
http://gavarrespedia.org/pendent

However, if you enable SEF feature (to make tiki create also short urls), then:
http://gavarrespedia.org/pendents

shows error, page not found, maybe you were looking for pendent, etc.
and it should just show the page "pendent" straight away

Hello,

On my system :

__feature_sefurl don't functions normally.__

Important : Subject feature_sefurl : last version 5.1rc1 (current yesterday but may be before). The feature_sefurl don't functions normally (I have not searched why, I don't look at in details to this part).

__So if the option is activated all url(s) as

__''site/<page name> ''__

fail and any action, particularly page-object-display (magnifier icon) reaches a 404 error. __

nota : naturally, if the option is not activated the url generated for display of pages is :
__
''site/tiki-index.php?page=<page name> ''__

which functions normally.

trebly

ref-B00805-01

!!!Update: 2011-01-31
Recommend Closure
Problem apparently fixed with the upgrade to V6.1
~Speaker

__DESCRIPTION__
In a Forum, setting topic sort order to Topic (Ascend/Descend) results in an error screen (see pic2). This is true for global and Forum-specific settings (see pic1). As far as I can determine, the suggested actions have been completed (Installer, corruption, DB credentials). Also, the current BugReport only references an email address rather than the details shown for other reports on the page.

__PageText__
An error occured while performing the request.

Things to check:

1. Did you complete the Tiki Installer?
2. Is your database corrupt? Please see how to repair your database
3. Are your database credentials accurate? (username, database name, etc in
db/local.php)
__EndText__

Request this be corrected within the current development cycle (v6.x), ver 5.4 if possible or... point me to a fix if this is a configuration issue or, if needed, I may be able to incorporate a code fix.

__Pic1__
http://dev.tiki.org/tiki-browse_image.php?imageId=117
__Pic2__

This is an RSS feed:
http://sourceforge.net/export/rss2_projsummary.php?group_id=64258


It's not the traditional way of using RSS but it can be very useful :-) It permits us to get up to date info (Ex.: number of devs, number of downloads, etc.) from SourceForge, using RSS. We can then publish on http://info.tikiwiki.org/



This idea could be used for serving ads.
http://en.wikipedia.org/wiki/Ad_serving

This is also in the same idea as:
http://dev.tikiwiki.org/Connect
http://tikiwiki.org/Viral+Tiki

Two immediate uses
# Manage the footer of all *.tikiwiki.org sites from one place
# Permit to push news & calls to action (Current version of Tiki, vote for Tiki in an Award, new release, etc)


Tiki5 as of now:
http://tikiwiki.org/tiki-index_raw.php?page=rsstest

Tiki4 as of now:
http://info.tikiwiki.org/tiki-index_raw.php?page=DeployWikiPageContentAsRSS



Related
{wish id=1396}

Toggle interactive translation on.
Translation bar with the check box always makes the page load >10x slower. The page is loaded in 4 sec, but it still does something for 40+ seconds. Thereafter, the translation bar is loaded.
It is quite annoying so one tries to
Toggle interactive translation off.
It does not show that bar anymore. However, you still need to wait for the extra 40 seconds. Highly annoying.

TW5.0Beta1

{syntax type="tiki" editor="plain"}
When clicking on the Show Help button in tiki-article_types.tpl. The text appears then disappears right away. This makes the Help Button unusable. (Please keep in mind this bug is with the Show Help BUTTON not the help icon)

Uploading jpeg images with Internet Explorer (6,7,8) provokes a tiny small white image when trying to display it with colorbox.

It seems to be the Internet Explorer Bug which marks JPEG-Images at download time with mime-type "image/pjpeg" instead of "image/jpeg".

It concerns the Passwords match and do not match.
Chealer explained to me that there is a language.js file to be created in the lang/<yourlang> folder (as in ca).
Since my ajax is on, the password check is not run from
tiki-js.js, checkPasswordsMatch
but from
register_ajax.js (please also add a header to this file), check_pass.
The tr function is not defined there, so it would not work.

See also
http://irc.tikiwiki.org/irclogger_log/tikiwiki?date=2010-10-19,Tue

P.S. I rated this 9, because there will be people who want ajax and another language, but do not like to dig js files for such a basic functionality.

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

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

I am trying to test 5.0 RC1 on locahost, but after installing database i received this error message


''Table 'dbxxxxxx.tiki_rss_items' doesn't exist
The query was:
SELECT * FROM `tiki_rss_items` WHERE `rssId` IN( ? ) ORDER BY publication_date DESC
Values:

1. 8

The built query was likely:
SELECT * FROM `tiki_rss_items` WHERE `rssId` IN( '8' ) ORDER BY publication_date DESC''

It was the same with 5.0 beta 2, and when i look to my database tiki_rss_items doesn't exist.
Is it a new table with tiki 5? not install with upgrader?

{syntax type="tiki" editor="plain"}
Seen in Tiki 5 and Tiki 6:

#Missing images:
The path location that Tiki generates for the Infinite carousel icons (next/previous, play/pause, etc.) is incorrect. Tiki is generating:
{CODE()}
/js/infinitecarousel/images/..
{CODE}

But the correct path is:
{CODE()}
/lib/jquery/infinitecarousel/images/..
{CODE}

#Incorrect DIV height calculated
Tiki is calculating the height of the __div id="carousel" ..__ incorrectly -- the bottom 19px of all images is clipped. There needs to be an additional __19px__ added to overall height, to account for the play/pause button & padding

#Suggestion
Tiki should close the entire __div id="carousel" ..__ within another __div__ with __overflow:hidden__ property. This way, Tiki will no longer display ''all'' images on the initial load of a page. Note, that the additional 19px will need to be added to the div's height, too, as noted in #3.

{syntax type="tiki" editor="plain"}
It will report a system error while saving a new file gallery

We were trying to have the new antibot captcha working in a Tiki site based on Tiki trunk (during TikiFestBarcelona2 - mid July 2010), were a user tracker was set to collect more information from users at registration time.

when we enabled zend new antibot-captcha , no antibot code was shown at registration time, because there seems to be some conflict with the user tracker.
Once the user tracker was disabled, the antibot-captcha was shown properly, etc.

----
Update: disaled the new zend antibot catpcha, in order to use the former simple captchaimage, but that one is not working either, if user tracker is on.

One can ask for the realName "admin" and get it with no problem. In fact, all the 1000 users of a site could be called admin.
TW51

In general, wiki syntax is not parsed in notification mails. For example, the "New article post" notification email includes the full body of the newly posted article. However, Tiki includes the full wiki coding/syntax within the body of the message, and sends the mail message as plain text. Tiki should either:

1. Send the message as parsed HTML

or

2. Strip all formatting and send only the text.

{syntax type="tiki" editor="plain"}
number of tracker items shown by default: customizable in a tracker by tracker basis. To avoid (at least) the problems of huge memory consumption in big trackers (and thus, setting the default number of items shown to a small number), while keeping other trackers with more items shown by default

{syntax type="tiki" editor="plain"}
when selecting a parent gallery on a deep gallery structure it would be nice if
# galleries not which are not a direct child of the root gallery are marked with "..." at the beginning
# galleries are marked with the (ID) at the end.

there are scenarios where the two displayed levels in the selection box are ambiguous.

{syntax type="tiki" editor="plain"}
tikiwiki-5.0.Beta1\setup_smarty.php, line 251, in function get_filename:
$file = '';
may be replaced by
$file = '/';