Category: Error

{syntax type="tiki" editor="plain"}
When a bug has been reported on dev.tikiwiki.org, the completion page http://dev.tikiwiki.org/your+wish+has+been+cast has a box which used to show the submitted report. Although the "LAST ITEMS" box is present, it is empty.

When installing I use a unique database name, not 'tiki'. I imported my old database and ran the installer. At the "Install & Upgrade" screen I chose "Upgrade". I then received a blank page with the following message:

MySQL INFORMATION_SCHEMA not available. Your MySQL version is too old to perform this operation. (upgrade_20120429_fix_collation_tiki)

Looking into the code for 20120429_fix_collation_tiki.php and doing a bit of debugging I found the following line to be causing the error:
{CODE()}if ( $results= $installer->fetchAll('SELECT DISTINCT(TABLE_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = ?', $dbs_tiki)
{CODE}
A debug_print_backtrace and a few php print statements later, I determined that the $dbs_tiki variable was being set to 'tiki' when it should have been set to my database name.

I believe the following check-ins are the area of concern:
http://sourceforge.net/p/tikiwiki/code/48422/tree//trunk/installer/installlib.php?diff=48171
http://sourceforge.net/p/tikiwiki/code/45334/tree//trunk/lib/init/initlib.php?diff=44846

From what I can tell the $dbs_tiki value is predefined as 'tiki' by initlib.php and the calling sequence in installlib.php is not correctly setting the database name from local.php.

I made the following changes to get around the issue. I do not know if this meets all the requirements for this function so I can not confirm that these changes are sufficient to correctly fix the issue.


{CODE(caption="installer/installlib.php")}# diff -u tiki-12.0/installer/installlib.php tiki-12.0-fix/installer/installlib.php
--- tiki-12.0/installer/installlib.php 2013-11-13 10:45:16.000000000 -0600
+++ tiki-12.0-fix/installer/installlib.php 2014-02-23 13:28:52.765490522 -0600
@@ -133,11 +133,13 @@
}

global $dbs_tiki;
- $local_php = TikiInit::getCredentialsFile();
- if (empty($dbs_tiki) && is_readable($local_php)) {
- require($local_php);
- unset($db_tiki, $host_tiki, $user_tiki, $pass_tiki);
- }
+ if (empty($dbs_tiki) ) {
+ $local_php = TikiInit::getCredentialsFile();
+ if (is_readable($local_php)) {
+ require($local_php);
+ unset($db_tiki, $host_tiki, $user_tiki, $pass_tiki);
+ }
+ }

if ( function_exists($standalone) ) {
$standalone($this);{CODE}

The following message from php appears when trying to sort a tracker by any given field. It clearly has to do with an undefined field variable.

Ocurrió un error en una consulta a la base de datos!

Context:
File /artiki/tiki-view_tracker.php
Url /artiki/tiki-view_tracker.php?status=&find=&trackerId=2&offset=0&sort_mode=_desc
Query:
select * from `tiki_tracker_items` where `trackerId`=? order by `` desc
Values:
0 2
array(3) {
[0]=>
array(6) {
["file"]=>
string(49) "/Users/historiarte/Sites/artiki/lib/tikidblib.php"
["line"]=>
int(84)
["function"]=>
string(9) "sql_error"
["class"]=>
string(10) "trackerlib"
["type"]=>
string(2) "->"
["args"]=>
array(3) {
[0]=>
&string(73) "select * from `tiki_tracker_items` where `trackerId`=? order by `` desc"
[1]=>
&array(1) {
[0]=>
int(2)
}
[2]=>
&bool(false)
}
}
[1]=>
array(6) {
["file"]=>
string(59) "/Users/historiarte/Sites/artiki/lib/trackers/trackerlib.php"
["line"]=>
int(43)
["function"]=>
string(5) "query"
["class"]=>
string(10) "trackerlib"
["type"]=>
string(2) "->"
["args"]=>
array(4) {
[0]=>
&string(73) "select * from `tiki_tracker_items` where `trackerId`=? order by `` desc"
[1]=>
&array(1) {
[0]=>
int(2)
}
[2]=>
&string(2) "10"
[3]=>
&string(1) "0"
}
}
[2]=>
array(6) {
["file"]=>
string(53) "/Users/historiarte/Sites/artiki/tiki-view_tracker.php"
["line"]=>
int(243)
["function"]=>
string(18) "list_tracker_items"
["class"]=>
string(10) "trackerlib"
["type"]=>
string(2) "->"
["args"]=>
array(6) {
[0]=>
&string(1) "2"
[1]=>
&string(1) "0"
[2]=>
&string(2) "10"
[3]=>
&string(5) "_desc"
[4]=>
&array(2) {
["data"]=>
&array(7) {
[0]=>
array(10) {
["fieldId"]=>
string(1) "6"
["trackerId"]=>
string(1) "2"
["name"]=>
string(8) "Profesor"
["options"]=>
string(0) ""
["type"]=>
string(1) "t"
["isMain"]=>
string(1) "n"
["isTblVisible"]=>
string(1) "y"
["options_array"]=>
array(1) {
[0]=>
string(0) ""
}
["ins_name"]=>
string(12) "ins_Profesor"
["value"]=>
string(0) ""
}
[1]=>
array(10) {
["fieldId"]=>
string(1) "7"
["trackerId"]=>
string(1) "2"
["name"]=>
string(7) "Materia"
["options"]=>
string(249) "Arte universal antiguo y medieval,Arte universal moderno y contemporáneo,Arte mexicano antiguo y colonial,Arte mexicano moderno y contemporáneo,Optativa de teoría,Seminario-taller general,Seminario-taller especializado,Seminario de investigación"
["type"]=>
string(1) "d"
["isMain"]=>
string(1) "n"
["isTblVisible"]=>
string(1) "n"
["options_array"]=>
array(8) {
[0]=>
string(33) "Arte universal antiguo y medieval"
[1]=>
string(39) "Arte universal moderno y contemporáneo"
[2]=>
string(32) "Arte mexicano antiguo y colonial"
[3]=>
string(38) "Arte mexicano moderno y contemporáneo"
[4]=>
string(19) "Optativa de teoría"
[5]=>
string(24) "Seminario-taller general"
[6]=>
string(30) "Seminario-taller especializado"
[7]=>
string(27) "Seminario de investigación"
}
["ins_name"]=>
string(11) "ins_Materia"
["value"]=>
string(0) ""
}
[2]=>
array(10) {
["fieldId"]=>
string(1) "8"
["trackerId"]=>
string(1) "2"
["name"]=>
string(9) "Subtitulo"
["options"]=>
string(0) ""
["type"]=>
string(1) "t"
["isMain"]=>
string(1) "y"
["isTblVisible"]=>
string(1) "y"
["options_array"]=>
array(1) {
[0]=>
string(0) ""
}
["ins_name"]=>
string(13) "ins_Subtitulo"
["value"]=>
string(0) ""
}
[3]=>
array(10) {
["fieldId"]=>
string(1) "9"
["trackerId"]=>
string(1) "2"
["name"]=>
string(7) "Horario"
["options"]=>
string(0) ""
["type"]=>
string(1) "t"
["isMain"]=>
string(1) "n"
["isTblVisible"]=>
string(1) "n"
["options_array"]=>
array(1) {
[0]=>
string(0) ""
}
["ins_name"]=>
string(11) "ins_Horario"
["value"]=>
string(0) ""
}
[4]=>
array(10) {
["fieldId"]=>
string(2) "10"
["trackerId"]=>
string(1) "2"
["name"]=>
string(11) "Descripcion"
["options"]=>
string(0) ""
["type"]=>
string(1) "a"
["isMain"]=>
string(1) "n"
["isTblVisible"]=>
string(1) "n"
["options_array"]=>
array(1) {
[0]=>
string(0) ""
}
["ins_name"]=>
string(15) "ins_Descripcion"
["value"]=>
string(0) ""
}
[5]=>
array(10) {
["fieldId"]=>
string(2) "11"
["trackerId"]=>
string(1) "2"
["name"]=>
string(24) "Requisitos_observaciones"
["options"]=>
string(0) ""
["type"]=>
string(1) "a"
["isMain"]=>
string(1) "n"
["isTblVisible"]=>
string(1) "n"
["options_array"]=>
array(1) {
[0]=>
string(0) ""
}
["ins_name"]=>
string(28) "ins_Requisitos_observaciones"
["value"]=>
string(0) ""
}
[6]=>
array(10) {
["fieldId"]=>
string(2) "12"
["trackerId"]=>
string(1) "2"
["name"]=>
string(15) "Semestre_2006-1"
["options"]=>
string(13) "2006-1,2006-2"
["type"]=>
string(1) "d"
["isMain"]=>
string(1) "n"
["isTblVisible"]=>
string(1) "n"
["options_array"]=>
array(2) {
[0]=>
string(6) "2006-1"
[1]=>
string(6) "2006-2"
}
["ins_name"]=>
string(19) "ins_Semestre_2006-1"
["value"]=>
string(0) ""
}
}
["cant"]=>
string(1) "7"
}
[5]=>
&string(0) ""
}
}
}

When I have two words side by side like this:
link1 link2

Then I select the first one and add a link to a file using the FILE tool tip in the edition bar and all is well and I get:
~np~{FILES( fileId="1")}link1{FILES} link2~/np~

Then I want to do the same with the second word. This does not work because it does not add it on the second word. Instead it replaces the first:
~np~{FILES( fileId="2")}link2{FILES} link2~/np~

The category browser becomes messed up if you add many levels of subdirectories. To reproduce:
1. delete all categs
2. create top categ A
3. create top categ B
4. create 2nd level categ A:A1
5. create 2nd level categ A:A1:A2
The problem should be apparent now. Top categ B appears to be a child of categ A.
The problem worsens if you add another level, A:A1:A2:A3. The entire rest of the screen becomes hidden.

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

I have yet id3127 id3148 explained the problems of the bug and wishes list.

I returns on the subject :
*before if you were clicking on the column headers, which function is to allow to sort the displayed list, you where generating a crash by an SQL request error.
Somebody have done something.

*Now : When you use this feature the list is simply cleared (if error then return).

Either this tool is without any interest for development or not at all.
If it is without interest it must be suppressed...
if not it must normally function even simply.
Actually the function are very simple but they don't functions.

!!The list sort problem : a display simply cleared...

If it is, anybody can understand that the impossibility to sort a list which is always displayed as playing card poker, makes impossible any revue of a subject.

This is the main problem.

!!Minimum enhancements in my opinion
__A really minimum list :__
*Display the "id" and the "author"
*Display a full date (the day)
*Allow a direct access by the "id"
*Allow selection by check box and display only checked items
*Send by mail the current list
*Optionally send by mail the content of an id

This could allow to check this list...

Trebly

Even though logged in, clicking on http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=2538&trackerId=5&show=view (which came up as a result of a bug search) results in the user being told "Error - Permission denied"

This should probably not be possible.

{syntax type="tiki" editor="plain"}
In the "user list" menu, the menu where I have the 10 top users, the "More.." button does not work, I get the message:

"This feature is disabled"

And I have enabled the permission "tiki_p_list_users"

Found a bug in the Button plugin, when using the colorbox feature. It just redirect to the href link, instead of opening the page in a colorbox

Can be seen in doc.tiki.org in https://doc.tiki.org/PluginButton , and also in https://doc.tiki.org/ColorBox

Thanks

1.10 svn Version from today (at least) May 25th is having a problem to show the tab to add items to a trackers through clicking on the link:
http://intercanvis.net/tiki-view_tracker.php?trackerId=8&cookietab=2

(intercanvis.net theme style is based on hec2 and the only customized tpl's are header.tpl and tiki-top_bar.tpl. Anyway, that link to add items to a trackers was working nicely weeks/months ago.)

On the contrary, doc.tw.o was updated a month ago or earlier, and the link is still working:
http://doc.tikiwiki.org/tiki-view_tracker.php?trackerId=8&cookietab=2

I have two site that I've upgraded from Tiki 5.3 to Tiki 6 and on both sites, clear cache function is no longer working since the upgrade. When I open the 'Exterminator of cached content' window, thit indicates that there are no cached files. I have confirmed via FTP that there are many cached files. Also, when I select 'clear cache', there is no effect on the cached files.

{syntax type="tiki" editor="plain"}
See this post:
http://themes.tikiwiki.org/tiki-view_forum_thread.php?topics_offset=1&forumId=2&comments_parentId=618

A user added some links to external images, which seem to be dinamically linked to cached copies by Tiki.

This is the external link itself:
http://neil.s.alexander.googlepages.com/tw19.jpg

This is the url to the cached image by themes.tw.o:
http://themes.tikiwiki.org/tiki-view_cache.php?u%72l=http%3A%2F%2Fneil.s.alexander.googlepages.com%2Ftw19.jpg

Cached images are broken, showing this on the browser:
{CODE(wrap=>y)}

ur‍l (Localitzador de Recurs Universal) http://neil.s.alexander.googlepages.com/tw19.jpg
Carregat en memòria cau Dimecres 03 de Desembre, 2008 17:07:06 CET

Aquesta és una versió en memòria cau de la pàgina (Cliqueu aquí per veure la memòria cau Google de la pàgina.)

�����JFIF��H�H�����Exif��MM�*������������Created with The GIMP���C� !"$"$���C����"���������������� ���p� �!1"AQUa���2ST����#Vbqt���346BRd�����$57rs����%Ceu��8Dcv���� &f�����EFW�'�G�����������������C�
(...)
{CODE}

Hello,

I come across a difference of results on what look to me the same thing and want to check if someone see an error on my side before posting a bug report.

When I run the following;

{LIST()}
{filter content="6" field="tracker_id"}
{filter field="tracker_status" content="p"}
{OUTPUT(report="y")}
{FANCYTABLE()}
Username | Duration
{CALC()}
(subtotal (list results) (group tracker_field_timeworkName) (aggregate tracker_field_timeworkCalculation) (formula add count) (separators (str |) (str ~nl~)))
{CALC}
{FANCYTABLE}
{OUTPUT}
{LIST}

It output wrong values:

Bernard | 38
Bernie | 9.5
Bernadette | 46
Bernardo | 46
…

When I run this

{LIST()}
{filter content="6" field="tracker_id"}
{filter field="tracker_status" content="p"}
{filter field="tracker_field_timeworkName" content="Bernard"}
{OUTPUT(report="y")}
{FANCYTABLE()}
Username | Duration
{CALC()}
(subtotal (list results) (group tracker_field_timeworkName) (aggregate tracker_field_timeworkCalculation) (formula add count) (separators (str |) (str ~nl~)))
{CALC}
{FANCYTABLE}
{OUTPUT}
{LIST}

It output:

Bernard | 92.5
And that’s the right number.

I am newbie on this. I found the error/bug when I added an event on the 28th of February. Newly added event did not show up on the monthly calendar but shows up in the View List.

Maybe this is resolved on version 3. i don't know. Just downloaded v 3 but did not install yet.

As to priority well, its passed February now, but next year target date is enough time.

Hi,

Calendar displays only this year when adding an event.
I can not select next year or any other year in start/end date box.

Regards,
Shigeru

Hi
Calendar can accept only this year when adding an event.
I can not select next year or any other year except this year.

Regards,
Shigeru

Not sure if intentional, as I cannot remember if the calendar used to do this, but I noticed some odd behavior with date highlighting.

When you are adding a new event and select a new date, the selected date is not highlighted properly. You can click it multiple times and the date is input to the date line correctly, but the box representing the date is not highlighted.

Example screenshot (from 15.x demo)
{img fileId="1104" thumb="box"}

But if you close the date selector and reopen it, the date you previously selected will be highlighted.

Example
{img fileId="1105" thumb="box"}

I think the expected behavior should be that when you click on a date it highlights.

On Month and Quarter Calendars, I have not managed to test semester. If the last day of the period is displayed in the bottom right corner of the grid it will not display any events. All other times it displays them.

{syntax type="tiki" editor="plain"}
When our users attempt run the Calendar export (either via tiki-calendar.php or tiki-calendar_params_ical.php) a 500 internal server error occurs.

From apache access.log:
{CODE(caption="access.log")}10.100.44.149 - - [30/Apr/2010:07:33:27 -0400] "POST /eiadwiki/tiki-calendar_export_ical.php HTTP/1.1" 500 - "http://eiadwiki/eiadwiki/tiki-calendar_params_ical.php" "Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3"{CODE}

From PHP error log:
No error reported log.

HTTP Request:
{CODE(caption="HTTP Request")}POST /eiadwiki/tiki-calendar_export_ical.php HTTP/1.1
Host: eiadwiki
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.3) Gecko/20100401 Firefox/3.6.3
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language: en-us,en;q=0.5
Accept-Encoding: gzip,deflate
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
Keep-Alive: 115
Referer: http://eiadwiki/eiadwiki/tiki-calendar.php
Cookie: javascript_enabled=y; menu=@menu42__50%3Ac@menu42__600%3Ac@menu42__1050%3Ao@menu42__200%3Ac@menu42__350%3Ac@filtercal%3Ao@exportcal%3Ao; tab=1; activeTabseiadwiki%2Ftiki-adminusers.php=tab1; local_tz=AM; PHPSESSID=mkiu7d2r4jlj74f7hlt2brvvj4
Content-Type: application/x-www-form-urlencoded
Content-Length: 41

export=y&calendarIds%5B%5D=1&valid=Export{CODE}

HTTP Response:
{CODE(caption="HTTP Response")}HTTP/1.0 500 Internal Server Error
Date: Fri, 30 Apr 2010 11:37:38 GMT
Server: Apache
X-Powered-By: PHP/5.3.2-dev
Expires: 0
Cache-Control: private
Pragma: dummy=bogus
Content-disposition: inline; filename=calendar.ics
Content-Length: 0
Content-Transfer-Encoding: quoted-printable
Connection: close
Content-Type: text/calendar; method=REQUEST; charset=iso-8859-15{CODE}

We are running in a multi tiki environment on Windows Server 2003, tikwiki 3.2 and php 5.3.

There are some entries in the forum, reporting that import into calandar failed. I never found any comment about a bug, or a solution. I tried with Tiki 15.0.The error message was:
"The file has incorrect syntax or is not a CSV file"
I located the point where the message is issued in calendarlib.php
and changed the appropriate check there:

old:
{CODE()
}if ($fields === false || !array_search('name', $fields)){
{CODE}

new:
{CODE()}
if (($fields === false) || (array_search('name', $fields) === false)) {
{CODE}

With this workaround, I can import CSV into calendars

I think that calendars are among the most import features that make the difference between a wiki and a groupware platform.

Calendar can not be linked to from a Wiki page. The Wiki Syntax parser for URLs does not recognize Calendar URLs, so they do not get linked. Apparently the brackets in such URLs cause problems: tiki-calendar.php?calIds[]=1

If I add an event for the 02/28/2009 the event does not display within the month mode, in list and week the event is shown.

{syntax type="tiki" editor="plain"}
Unable to add calendar module

Fatal error: Cannot use string offset as an array in /home/tiki/public_html/modules/mod-func-calendar_new.php on line 72

Changi.

Running brtiki theme on Tiki 1.9.7. The title of the calendar module displays in black, which is illegible against the dark green background. All other modules tested under this theme display their titles in white text against the green background.

http://tikiwiki.org/tiki-calendar.php -> calendar overlaps on right column