Category: Error

{syntax type="tiki" editor="plain"}
{img fileId="361"}

Using tiki 2.1

Attempting to edit a tracker item,
the "field is hidden" option has specified viewable and editable for group editors, only. I want to change that setting to a "viewable only by creator and admin", and set the other two multiselect fields, left as blank (selecting the first option wich is blank), but I get this error on save:

{CODE()}
Context:
File tiki-admin_tracker_fields.php
Url tiki-admin_tracker_fields.php
Query:
update `tiki_tracker_fields` set `name`=? ,`type`=?,`isMain`=?,`isSearchable`=?, `isTblVisible`=?,`isPublic`=?,`isHidden`=?,`isMandatory`=?,`position`=?,`options`=?,`isMultilingual`=?, `description`=?, `itemChoices`=?, `errorMsg`=?, visibleBy=?, editableBy=? where `fieldId`=?
Values:
0 Correu-e
1 m
2 n
3 n
4 n
5 y
6 c
7 y
8 29
9 1
10 n
11
12
13
14
15
16 59
Message:
Unknown column 'Array' in 'field list'
Built query was probably:
update `tiki_tracker_fields` set `name`='Correu-e' ,`type`='m',`isMain`='n',`isSearchable`='n', `isTblVisible`='n',`isPublic`='y',`isHidden`='c',`isMandatory`='y',`position`='29',`options`='1',`isMultilingual`='n', `description`='', `itemChoices`='', `errorMsg`='', visibleBy='Array', editableBy='Array' where `fieldId`='59'
{CODE}

the url is:
http://www.moviments.net/cursos/tiki-admin_tracker_fields.php?trackerId=4&max=100&sort_mode=position_asc&fieldId=59

{syntax type="tiki" editor="plain"}
Define a tracker with a drop down field (called "Location" in this example). Set the list of values so that one or more values have an embedded space like this:{CODE()}
Kitchen,Living Room,Half Bath,Study{CODE}
Now create a tracker item and set the Location field to "Living Room". When you save the item, the Location will be set to "Living Room" when you view the item. But when you edit the item, the Location will be changed to "Study".
The only workaround is to not create drop down values with spaces in them.

Since 1.9.6, when I post a new article ("Edit article"; I'm user with admin privileges on that site) I 'm returned to a page saying: "Article not found", and this is the url shown on the browser: http://www.moviments.net/tiki-read_article.php?articleId=

However, the article has been posted successfully .
Hoiwever, users get confused and re-submit the article several times, ... and end up with the idea that Tiki is "kind-of-broken"...

This is the message of the post, in case it matters:

Title:
Nous cursos GRATUÏTS: Wiki i Portals Web col·laboratius (TikiWiki CMS/Groupware)

Author name:
Xavi

Theme:
a theme called "Projecte_cursos", as with earlier tiki versions, working fine that them, associated img, etc.

Type:
Article

text floating around image

no categ selected

Header: (inside code box here on dev.tw.o; without on my site)
{CODE()}
Es torna a fer una nova tongada de cursos __GRATUÏTS__ sobre
* __Redacció col·laborativa__ de documents a través d'Internet emprant __Wikis__, i
* __Administració de portals web dinàmics i col·laboratius__, basats en __TikiWiki CMS/Groupware__, en nivell inicial, intermig i avançat.

Més informació sobre dies i hores a sota (o directament a http://moviments.net/cursos )
{CODE}

Body:
{CODE()}
------------------------------------------------------------------------------------
* Curs de __Wiki__: Redacció col·laborativa de documents per Internet (__nivell I__: iniciació) . DATES:
** 27, 29 de novembre, i 1, 4 i 5 de desembre. 10-13h,
++ ó
** 28, 29, 30 de novembre, i 1, 5 de desembre. 17-20h
------------------------------------------------------------------------------------
* Curs d'__Admin. Tiki CMS/Groupware__: portals web dinàmics i col·laboratius (__nivell I__, iniciació).
** 11, 13, 15, 19 i 21 de desembre. 10-13h
++ó
** 28, 29, 30 de novembre, 1 i 5 de desembre. 10-13h
------------------------------------------------------------------------------------
* Curs d'__Admin. Tiki CMS/Groupware__: portals web dinàmics i col·laboratius (__nivell II__, intermig).
** 11, 13, 15, 19 i 21 de desembre. 10-13h
++ ó
** 11, 13, 15, 19 i 21 de desembre. 17-20h
------------------------------------------------------------------------------------
* Curs d'__Admin. Tiki CMS/Groupware__: portals web dinàmics i col·laboratius (__nivell III__, avançat).
** 27, 29 de novembre, 1, 4 i 5 de desembre. 10-13h
++ ó
** 11, 13, 15, 19 i 21 de desembre. 17-20h
------------------------------------------------------------------------------------

Més informació (i pre-inscripcions, si t'interessa):
http://moviments.net/cursos

Exemple de nous "espais de treball" (nova funcionalitat del Tiki):
http://moviments.net/cursos/ws5

Fins aviat,

Xavier de Pedro
Projecte Cursos,
AlterComs SCCL
{CODE}

Can be duplicated on tikiwiki.org

start and end time in tiki-calendar.php (add or edit mode) takes the GMT time, even if the current user is in local time.

This is not such a problem when adding an event because the user is expected to choose the time.

However, when someone edits an existing event, the start & end times are reverted back to GMT. When the user saves the event, the time is several hours off.

--

Related:
Also affects tiki-edit_article.php, tiki-edit_submission.php and tiki-view_tracker.php (when submitting a tracker)

To duplicate the bug, you must be in a different timezone than your server.

{syntax type="tiki" editor="plain"}
Editing a calendar item via
tiki-calendar_edit_item.php
resets its hours and minutes to strange values.

This is my first bug report here, I could not find the issue somewhere and believe some experienced developer should review my fix.

Use "~" for Namespace separator as advised/ suggested by tiki-doc.
Create Workspace Template, generate Workspace from it.
Produces "template~workspace" as workspace name for category, group, perspective.

Now such a workspace needs permissions changed from the default of the template.
Admin Category, hit "Permissions", edit entries for the dedicated group(s), save.

In the Permissions UI the save is not reflected, it's the same as before.
In the DB the table "users_objectpermissions" received new entries for "template" rather than "template~workspace".

Haven't verified yet whether it's related to "~" as Namespace separator or not.

With the WYSIWYG editor enabled (but html not checked in the wiki settings), I am unable to use wiki syntax in the normal editor when I save or preview. That is, the wiki markup shows up as text on the page.

It switches back to WYSIWYG after pressing preview as well.

If I enter html in the Normal editor it works fine.

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

{syntax type="tiki" editor="plain"}
If you filter on a category field in trackers, you cannot edit any viewed tracker items. The system returns a SQL error because filterfield is set, and filtervalue is null. If you filter on other fields, you can save, with no errors.

I have traced the problem to the calling of trklib->list_items (this holds the query that fails). This function is used to call and order the other tracker items for easy pagination of the filtered tracker items after a save.

However, the real problem is that $_REQUST['filtervalue'] and $tryfiltervalue get lost in tiki-view_tracker_item.php when the save submit action is done on the form. Other URL query parameters appear to be stored as hidden fields on save action in tiki-view_tracker_item.

For whatever reason, non-array filtervalue fields (e.g. plain text fields) are remembered and thus the pagination and call to list_items works just fine.

However, when there is an array filtervalue (like there is with category fields), then filtervalue gets lost on the save action, and the save fails on a malformed query.

Using the Tiki's built-in TPL file editor to change a title on a TPL page (e.g. "Admin Tracker" to "Administer Reports" for "tiki-admin_tracker.tpl" file) causes insertion of "" character sequence at several places throughout the modified "tiki-admin_tracker.tpl" file. The original "tiki-admin_tracker.tpl" is unmodified. The modified "tiki-admin_tracker.tpl" file contains "" in such places as "javascript" (rather than "javascript"), which breaks the links on the Admin Tracker tabs.

{syntax type="tiki" editor="plain"}
After upgrade to 27.5 (I have not observer this in 27.2), edits made to Wiki Plugins on any given Wiki Page cause PHP errors related to missing language definition.
# Assigned language of the Wiki Page is removed (causing a PHP error, and "No language assigned" message)
# Page Description is removed
The above can be reverted using History, but it's practically impossible to edit Plugins without causing data loss (description).
User is forced to manually re-assign language (which fixes PHP errors), and insert new Page Description.
Tested on fresh install of 27.5

PHP errors shown on affected page are related to translated-lang.tpl (missing language)
^<?php echo $_smarty_tpl->getSmarty()->getModifierCallback('escape')($_smarty_tpl->getValue('trads')[0]['langName']);?>
(<?php echo $_smarty_tpl->getSmarty()->getModifierCallback('escape')($_smarty_tpl->getValue('trads')[0]['lang']);?>^

Adding or changing a Wiki page has the error "A contribution is mandatory" when saving.

Can't get past this error

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 )

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 )

{syntax type="tiki" editor="plain"}
I have a problem, i dont know how fix it
In tiki4.2 in wiki pages (others doesn’t show this error) editor wysiwyg, does insert an image but it change the code with this code
{…}, (I know cos I saw it , in the html view)
But when I save it doesn’t recognize the image, If I return to the html editor and change the {…} With <…>, it works

Somebody can help me??
(:wink:)

I login to edu.tw.o with my admin account (it's user "xavi", with admin rights on edu.tw.o, but not on tw.o, where this user "xavi" was already registered, as plain "Registered" user). Intertiki is activated as slave.

I login to edu.tw.o as user "xavi" (without realm on the right), and pass. I login. (I couldn't previous days... :-/ )
Then I see a notice on top of each page saying:
{CODE()}
Notice: unserialize(): Error at offset 245 of 250 bytes in /var/lib/gforge/chroot/home/groups/edutiki/htdocs/tiki-setup.php on line 1446{CODE}

Then, I edit a page (or other actions), and I get after cliking to save button:

{CODE()}Notice: unserialize(): Error at offset 245 of 250 bytes in /var/lib/gforge/chroot/home/groups/edutiki/htdocs/tiki-setup.php on line 1446

Warning: Cannot modify header information - headers already sent by (output started at /var/lib/gforge/chroot/home/groups/edutiki/htdocs/tiki-setup.php:1446) in /var/lib/gforge/chroot/home/groups/edutiki/htdocs/tiki-editpage.php on line 764{CODE}

Followed by "blank". So tiki is stuck there showing nothing else, and no link to go back, etc.

Please, help!, since it doesn't look nive for users trying tiki....

Btw, The category "FEature" ehre in dev.tw.o is missing "Login" + Intertiki" , plus another category for "Mods", contanining all the mods released in cvs sf.net.

It seems some internal code in tiki to use elastic search needs to be updated to work with ElasticSearch 5.x:

Installed a blank new tiki, changed unified search engine to ElasticSearch (using v5.0.2 in Ubuntu 16.04 with their elasticsearch repository to have updated packages), and I applied Collaborative_Community_12 profile. I saw these errors just above the instructions page:

{CODE()}
Error(s)

Indexing failed while processing "HomePage" (type wiki page) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "Instructions" (type wiki page) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "Community" (type wiki page) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "Wiki Help" (type wiki page) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "1" (type forum) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "1" (type tracker) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "1" (type trackerfield) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "2" (type trackerfield) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "3" (type trackerfield) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "4" (type trackerfield) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "5" (type trackerfield) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "6" (type trackerfield) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "1" (type trackeritem) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "2" (type trackeritem) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "3" (type trackeritem) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "4" (type trackeritem) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "5" (type trackeritem) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "6" (type trackeritem) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "7" (type trackeritem) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "8" (type trackeritem) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "Community Members HomePage" (type wiki page) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "Anonymous" (type group) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "Registered" (type group) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "Editors" (type group) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "SubAdmins" (type group) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
Indexing failed while processing "Admins" (type group) with the error "The [string] type is removed in 5.0 and automatic upgrade failed because parameters [term_vector] are not supported for automatic upgrades. You should now use either a [text] or [keyword] field instead for field [title]"
{CODE}

And when I reindex, I get these other error messages:
{CODE()}
Error

all shards failed
×
Error

Indexing failed while processing "Community" (type wiki page) with the error "no such index"
×
Error

Indexing failed while processing "1" (type forum) with the error "no such index"
×
Error

Indexing failed while processing "1" (type file gallery) with the error "no such index"
×
Error

Indexing failed while processing "1" (type trackeritem) with the error "no such index"
×
Error

Indexing failed while processing "1" (type tracker) with the error "no such index"
×
Error

Indexing failed while processing "1" (type trackerfield) with the error "no such index"
×
Error

Indexing failed while processing "admin" (type user) with the error "no such index"
×
Error

Indexing failed while processing "Admins" (type group) with the error "no such index"
Rebuild Index
Your index was last fully rebuilt on Wednesday November 30, 2016 09:55:03 UTC.
×
Indexed

wiki page: 5
forum post: 0
forum: 1
file: 0
file gallery: 3
trackeritem: 8
tracker: 1
trackerfield: 6
comment: 0
user: 1
group: 5
{CODE}

When I am using the calendar on mouseover the month the year changes colour. The normal colour of the month seems to be a red rather than the standard white and so cannot be seen against the blue background. You can see this at my site www.granthamlions.org.uk. Thanks

When I am using the calendar on mouseover the month the year changes colour. The normal colour of the month seems to be a red rather than the standard white and so cannot be seen against the blue background. You can see this at my site www.granthamlions.org.uk. Thanks

When using ElFinder as the gallery viewer, browsing for images does not work. ElFinder returns the img plugin syntax instead of the image URL.

The show instance does not work too well. So, I made a screencast
{flash type="url" movie="display437" width="759" height="753"}

Adding CkEditor image toolbar button to show, too.

Note: This is when using HTML WYSIWYG and the CKEditor Image tool, but will have a go {sign user="jonnybradley" datetime="2013-10-30T17:18:39+00:00"}

http://doc.tiki.org/tiki-list_file_gallery.php?galleryId=1686

{img fileId="609"}

In clean installs of both 1.9.7 and 1.10 I found that the email address entered in Tiki-Admin:General (Sender email)is reflected in Tiki-Contact the format user(AT)address(DOT)com. Example: the doc pages lead to the example at: http://security.tikiwiki.org/tiki-contact.php were the email address is also shown as: "click here to send us an email: security(AT)tikiwiki(DOT)org". All of my email clients parse this to an address of: AT DOT <securitytikiwikiorg>, which obviously does not work. I have viewed my pages on several different Linux and WinXP machines, all with the same results.

If have not gotten far enough in my setup to see if this "problem" surfaces elsewhere.

As I have not seen a bug report, nor other question on this issue I wonder if I am doing something wrong.

Thank you for for this fantastic project!

pmor

Email notification don't work except if "watch minor" is checked