Category: Error

A user typo whilst creating a structure can create a new page which then isn't (easily) accessed.

Whilst creating a new structure and adding pages with aliases using the "Tree" feature, if hyphen space greater-than rather than simply hyphen greater-than is entered the new page is created without an alias but with a longer that expected page name.

For example
Test_01 -> Page1 creates new page called Test_01 and alias Page1 as expected.
But
Test_02 - > Page2 creates a new page called "Test_02 - > Page2" with no alias.

Accessing this page and removing it is challenging :-))

--(Can't currently create a show instance for you, no database connection available, but I can reproduce this on the demo 18x/system)--

Using the Structures "next page" button from page Test_01 causes a wiki error "Page not found" for "Test_02 - Page2" (sic without greater-than sign).

Likewise wikilink from toc generated on pages within the structure also results in "Page not found".

Adding the plugin listpages with options find="Test_0" to the root of the structure shows the pages as expected.

Note the wikilink URLs generated by toc and listpages are different, but wikilink from listpages also results in the same "Page not found error" for the same page "Test_02----Page2"

I was willing to test some feature in recent 18.x compared to trunk. Trunk worked fine, but 18.x complained with:
"Data too long for column 'log' at row 1"

The query was:
insert into `tiki_actionlog` (`action`, `object`, `lastModif`, `user`, `ip`, `comment`, `objectType`, `client`, `log`) values(?,?,?,?,?,?,?,?,?)

Steps to reproduce in 18.x: brand new install (r67615). MyISAM in db type.
* Login as admin, change pass
* Profiles Wizard > Demo of Interesting Use Cases > Bug Tracker
* click again in the profiles manager, since the profiles wizard didn't succeed showing you the button to apply the profile.
* next page shows that error message:
{CODE()}
The query was:
insert into `tiki_actionlog` (`action`, `object`, `lastModif`, `user`, `ip`, `comment`, `objectType`, `client`, `log`) values(?,?,?,?,?,?,?,?,?)

Values:

profile apply
Bug_Tracker_16
1537742078
admin
127.0.0.1
profile applied
system
Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:62.0) Gecko/20100101 Firefox/62.0
a:76:{i:0;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:1:"y";s:3:"old";s:1:"n";s:11:"description";s:16:"feature_trackers";}i:1;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:1:"y";s:3:"old";s:1:"n";s:11:"description";s:20:"feature_user_watches";}i:2;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:1:"y";s:3:"old";s:1:"n";s:11:"description";s:26:"feature_syntax_highlighter";}i:3;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:7:"default";s:3:"old";s:3:"off";s:11:"description";s:32:"feature_syntax_highlighter_theme";}i:4;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:1:"y";s:3:"old";s:1:"n";s:11:"description";s:16:"ajax_inline_edit";}i:5;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:1:"y";s:3:"old";s:1:"n";s:11:"description";s:26:"feature_jquery_tablesorter";}i:6;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:1:"y";s:3:"old";s:1:"n";s:11:"description";s:24:"feature_wiki_argvariable";}i:7;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:1:"y";s:3:"old";s:1:"n";s:11:"description";s:25:"tracker_change_field_type";}i:8;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:1:"y";s:3:"old";s:1:"n";s:11:"description";s:18:"tracker_clone_item";}i:9;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:1:"y";s:3:"old";s:1:"n";s:11:"description";s:27:"tracker_show_comments_below";}i:10;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:1:"y";s:3:"old";s:1:"n";s:11:"description";s:26:"trackerfield_dropdownother";}i:11;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:1:"y";s:3:"old";s:1:"n";s:11:"description";s:26:"trackerfield_groupselector";}i:12;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:1:"y";s:3:"old";s:1:"n";s:11:"description";s:21:"wikiplugin_pivottable";}i:13;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:1:"y";s:3:"old";s:1:"n";s:11:"description";s:12:"useGroupHome";}i:14;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:1:"y";s:3:"old";s:1:"n";s:11:"description";s:18:"limitedGoGroupHome";}i:15;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:1:"y";s:3:"old";s:1:"n";s:11:"description";s:8:"log_mail";}i:16;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:21:"YourEmail@example.com";s:3:"old";s:13:"xavi@tiki.org";s:11:"description";s:12:"sender_email";}i:17;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:1:"y";s:3:"old";s:1:"n";s:11:"description";s:21:"feature_wiki_comments";}i:18;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:1:"y";s:3:"old";s:1:"n";s:11:"description";s:23:"feature_inline_comments";}i:19;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:1:"y";s:3:"old";s:1:"n";s:11:"description";s:20:"comments_field_email";}i:20;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:1:"y";s:3:"old";s:1:"n";s:11:"description";s:22:"comments_field_website";}i:21;a:4:{s:4:"type";s:10:"preference";s:3:"new";s:1:"y";s:3:"old";s:1:"n";s:11:"description";s:18:"wikiplugin_comment";}i:22;a:4:{s:4:"type";s:9:"installer";s:3:"new";b:0;s:3:"old";b:0;s:11:"description";s:14:"tracker "Bugs"";}i:23;a:4:{s:4:"type";s:9:"installer";s:3:"new";b:0;s:3:"old";b:0;s:11:"description";s:26:"tracker_field "Bug status"";}i:24;a:4:{s:4:"type";s:9:"installer";s:3:"new";b:0;s:3:"old";b:0;s:11:"description";s:24:"tracker_field "Severity"";}i:25;a:4:{s:4:"type";s:9:"installer";s:3:"new";b:0;s:3:"old";b:0;s:11:"description";s:24:"tracker_field "Priority"";}i:26;a:4:{s:4:"type";s:9:"installer";s:3:"new";b:0;s:3:"old";b:0;s:11:"description";s:23:"tracker_field "Summary"";}i:27;a:4:{s:4:"type";s:9:"installer";s:3:"new";b:0;s:3:"old";b:0;s:11:"description";s:23:"tracker_field "Version"";}i:28;a:4:{s:4:"type";s:9:"installer";s:3:"new";b:0;s:3:"old";b:0;s:11:"description";s:27:"tracker_field "Description"";}i:29;a:4:{s:4:"type";s:9:"installer";s:3:"new";b:0;s:3:"old";b:0;s:11:"description";s:34:"tracker_field "Expected behaviour"";}i:30;a:4:{s:4:"type";s:9:"installer";s:3:"new";b:0;s:3:"old";b:0;s:11:"description";s:28:"tracker_field "Submitted by"";}i:31;a:4:{s:4:"type";s:9:"installer";s:3:"new";b:0;s:3:"old";b:0;s:11:"description";s:27:"tracker_field "Assigned to"";}i:32;a:4:{s:4:"type";s:9:"installer";s:3:"new";b:0;s:3:"old";b:0;s:11:"description";s:24:"tracker_field "Alert to"";}i:33;a:4:{s:4:"type";s:9:"installer";s:3:"new";b:0;s:3:"old";b:0;s:11:"description";s:35:"tracker_option "sort_default_field"";}i:34;a:4:{s:4:"type";s:9:"installer";s:3:"new";b:0;s:3:"old";b:0;s:11:"description";s:29:"tracker_option "popup_fields"";}i:35;a:4:{s:4:"type";s:4:"user";s:3:"new";O:19:"Tiki_Profile_Object":4:{s:25:"Tiki_Profile_Objectdata";a:2:{s:4:"type";s:4:"user";s:4:"data";a:5:

(...)

{CODE}

Btw, profile seems to have been applied successfully.{sign user="xavi" datetime="2018-09-23T22:51:34+00:00"}

{syntax type="tiki" editor="plain"}
http://wikisuite.org/tiki-pagehistory.php?page=ClearOS&newver=0&oldver=30

See also attached image

It's a ((WYSIWYCA)) bug. Anonymous users can't remove page versions, so interface shouldn't offer it.

@fabio: please coach team as needed

When a new user registered with anti-bot and user tracker for more user information getting error message that registration code is invalid.

Here are steps to reproduce the problem.

1) Setup user information tracker with couple of fields.
2) Go to registration page
3) Enter registration details and click 'register'
4) This will take you to new screen where user tracker information needs to be filled.
5) Once you fill the user tracker information and click 'Save'
6) You will get error message that registration code is invalid

The edit button (and switch to wysiwyg) link to nowhere (except back to homepage.)

This appears to be an ajax related problem many buttons/links do not work.

verified on my site and 110.tikiwiki.org

edit button links to:
http://sitename.com/#


switch to wysiwyg does not work, navigation buttons in list-pages,

I have a tracker with 80 items and one with 200 items. Latest code from SVN (updated 6/24).

Pagination fails completely - sometimes page 3 works, sometimes it doesn't. Page 2 fails all the time (that is - no movement)


This is with ajax on: firebug reports POST:
xajax=loadComponent&xajaxr=1214318443517&xajaxargs[]=tiki-view_tracker.tpl&xajaxargs[]=tiki-center

Even thought the param for offset is right, the data returned is always the same page I just sent.

As a result, nothing happens! Is there a way to turn ajax off in trackers only?

Without Ajax, the page changes, and if I manually put the URL in with the right offset, it goes to the right page

More details-
The error appears to be tied to the "insert new item" tab of a linked item.

IE reports an XML error, as does Firefox. The firefox console says this:
Error: not well-formed
Source File: http://www.casesofinterest.com/tiki/tiki-view_tracker.php?trackerId=8&offset=10
Line: 606, Column: 46
Source Code:
<option value="Technology and the Demand for Skill - An Analysis of Within an

The green arrow points to between the S and k in "Skill". Note the extra space - none appears in the linked field.

Even when I got rid of that item, AJAX pagination fails, but this time without a console error. What happens is that the window doesn't resize, and I get a "windowWidth is not defined" error, and the tabs never form.

Process: TikiWiki 2.0 installation from scratch
In the table definition for tiki_menues the field for 'icon' path is missing.
Which field definition should be used - (VARCHAR(254)- ok?

- Upload images to an image gallery, store in database
- create wiki page with tag {img src=show_image.php?id= }
- the images show for a while, but suddenly they do not show anymore

Wiki page draft requires AJAX.

I just tested in 2.0 RC2 and it's completely broken.
It conflicts with ((doc:Lost Edit)) protection

{THUMB(id=48,url=>show_image.php?id=48,original=y, sticky=y)}Major bug with wiki page draft{THUMB}

File tiki-mypages missing from bz2 file.
MyTiki Home... My pages results in error.

Plugin Pivottable inserts wrong codes in params data, rows and cols through plugin helper ui. Reproduced in 18.x and 19.x as of Jan 19 2019

I selected the name of the tracker in the dropdown shown, and a few of the tracker fields I chose for rows and columns, and the codes inserted in the wiki page sayed later were not the expected ones for each type of field:

Example of codes inserted (which fails to show data nor columns or rows):
{CODE()}
{PIVOTTABLE(data="1" rows="1:2" cols="3" ...)} {PIVOTTABLE}
{CODE}

Expected code to be inserted
{CODE()}
{PIVOTTABLE(data="tracker:1" rows="permNameA:permNameB" cols="permNameC" ...)} {PIVOTTABLE}
{CODE}
---
Reproduced in the show instance for 18.x
u: admin
p: admin
http://xavi-9794-6937.show.tikiwiki.org/tiki-index.php?page=HomePage

Search for javascript in 2.0 using search box performs search for "j-a-<-x->-s-c-r-i-p-t". Happens on tikiwiki.org.

http://tikiwiki.org/tiki-searchindex.php?highlight=javascript&search=

I have a TikiWiki site which requires being able to search text which includes web terms such as j-a-v-a-s-c-r-i-p-t but can't do such a search.

Someone said on IRC this is due to a protective input filter which is altering dangerous text input.

When defining a field in a mirrored Tracker, the Description of the field is not stored. This was in 2.0, and I'm told on IRC that mirrored trackers are not supported. But mirroring is an option in Admin>Trackers.

Installer broke (for me) trying to find the group home page when logging in as admin to run the update script.

Somewhere in tiki-login.php - SQL error lost i'm afraid

Installing BANNER in siteheader crashes with error message about unrecognised BANNER

The same banner works prefectly with 2.0 RC2 and RC4

I found TikiWiki's use of plugins to be an excellent substitute for the lack of built-in support for parameterized templates as found in MediaWiki - http://www.mediawiki.org/wiki/Help:Templates

I referred to the following instructions to create a php-based plugin:
http://dev.tikiwiki.org/tiki-index.php?page=Hello+World#To_create_a_new_plugin

They work great but with one caveat:
The use of double-quotes which are necessary for displaying strings with commas seems to create problems. For instance with a simple "HelloThere" plugin syntax {CODE()}{HELLOTHERE(firstname=>, lastname=>)}{HELLOTHERE}{CODE}:

This invokes the following simple function:

{CODE()}
function wikiplugin_hellothere($data $params) {
extract ($params EXTR_SKIP);
$strHello = "Hello there $firstname $lastname" ;
return $strHello;
}
{CODE}
(Squiggly brackets removed for display reasons)

{CODE()}{HELLOTHERE(firstname=>"Thurston", lastname=>Howell)}{HELLOTHERE}
{CODE}
yields
''Hello There Thurston Howell. ''
Great!

{CODE()}HELLOTHERE(firstname=>"Thurston", lastname=>"Howell III Esq. CPA")}{HELLOTHERE}{CODE} yields
''Hello There Thurston Thurston. ''
Not so great...

Namely adding double-quotes to get around the issue of commas within strings introduces a whole other problem of its own – repetition of the first variable. When there are 10 variables for instance the first quoted value will be repeated 10 times.

I am using TikiWiki 1.9.11; has anyone encountered this issue and if so is there a remedy?

File Galleries bug.

Uploaded a powerpoint document a few meg in size, with the name "The basics of leasing.ppt" and tikiwiki freaks out and tries to display the contents of the file on screen.

I have encountered a few snags after upgrading from Tiki 1.9.11 to 2.0

One of the problems is that I am unable to register / add users, because of the following error message:

An error occured in a database query!
Unknown column 'email_confirm' in 'field list'

This happens on
tiki-register.php (registration) and tiki-adminusers.php (batch upload / add)

Is there a fix for this?

Once saved, style changes (such as setting the font size or centering text) results in pages displaying like these:

My test starts here. Not much of yle="font-size: larger">interest going on though!
AND
yle="text-align: center">Home Page Test

Clicking to insert an image: dialog is displayed buyt clicking on the Browse server button results in the error "Error creating folder "" (Can't create directory)". Manually entering an image in source view mode (<img src="blah-blah">) and saving results in: img src=/home/lib/fckeditor/editor/blah-blah height=30 width=28 (surrounded by curely brackets)

Both related to parsing the html from the WSYWIG editor?

Clicking "Insert/Edit an internal wiki link" shows the "Insert Internal Link" popup but no content is displayed. The dialog briefly shows a cancel button and then the "wait squares" but nothing more.

Found with clean installs of 2.0RC4 on Windows Server 2003 x32 and also server 2008 x64. PHP 5.2.6 (x32); MySQL 5.0.51b (x32 and x64); Apache 2.2.9 (x32)

(sorry if these aren't sufficiently related and should be in separate bug reports)

When installed from source code, in panorama.freewebhosting247.com, there is only blank screen when:

1) using old 2.0rc4 user modifed "basic profile"
2) clean database with "basic profile"

I only see blank screen.

This is despite using header_simple.tpl and my own empty header.
The error must be in a script after the header but because by default, there is no error shown at all, this is impossible to guess.


When I reinstalled "default profile", it worked. It shows the menu. I can do some maintainance now, including changing passwords, and the admin menu.

If you show a list of image galleries and want to sort by images count you get an SQL query error.

Tiki outputs the following SQL Query

^select g.`galleryId`,g.`name`,g.`description`, g.`created`,g.`lastModif`,g.`visible`,g.`theme`,g.`user`, g.`hits`,g.`maxRows`,g.`rowImages`,g.`thumbSizeX`, g.`thumbSizeY`,g.`public`,g.`sortorder`,g.`sortdirection`, g.`galleryimage`,g.`parentgallery`,count(i.`imageId`) as numimages from `tiki_galleries` g, `tiki_images` i where i.`galleryId`=g.`galleryId` and `parentgallery`=? group by g.`galleryId`, g.`name`,g.`description`, g.`created`,g.`lastModif`,g.`visible`,g.`theme`,g.`user`, g.`hits`,g.`maxRows`,g.`rowImages`,g.`thumbSizeX`, g.`thumbSizeY`,g.`public`,g.`sortorder`,g.`sortdirection`, g.`galleryimage`,g.`parentgallery` order by `images` desc^

As you can see - the order by references an invalid column - because in the select list the field is named "numimages" and the order by uses "images".

The new "saved_msg=y" fails when SEFURL is on - both new pages and editing. It gives me a 404 not-found error. Makes SEFURL pretty useless. Example:
http://www.casesofinterest.com/tiki/Everything+is+Patentable&saved_msg=y

Following 2 separate/different upgrades from 1.9.11 to v2.0, in both cases the "Contact us" page is blank when it displays. The linkable page title shows OK at the top of the page but nothing else is displayed.

Both sites worked OK before the upgrade and everything else looks OK.

I've double checked that in both sites "Contact us" and "Contact us anonymously" are still set, plus the contact user is also still set with an e-mail address, but the blank page happens whether I'm logged in or not even when logged in as admin.

I originally posted this to the Features/Usability forum but xavi suggested it may be a bug so have now posted it here.

Have now also shown that this problem occurs with a new/clean install so doesn't seem to be related to the upgrade process.

The following code does not produce a table with one row with an image on the left and a toc on the right:

{img src=images/code.png}%%% {CODE()}
||::{img src=show_image.php?name=valmuer-henrikfalk.png }::|{toc type=fancy }||
{CODE}


The result is two rows with an ugly looking toc.

Worked fine with version 1.9.11

the button "insert internal link" (on the WYSIWYG-editor) doesn't work.

it opens a new window "local.php not found — This is normal if you have not run the tiki installer yet".


(but i run the tiki installer)