Category: Error

When a tracker was created, you can't afterwards switch the option "Use "explicit" names in the mirror table" on or off.

You get a lot of database errors. Best to try out and see yourself. Things get worse, when there are already fields defined in the tracker. Then the tracker is completely lost. Without any fields defined, you can still access and use the tracker - you just get errors in the top-bar

UPDATE: Switching back solves the problem - errors disappear and you can access the tracker again

While digging through some html I found the following:

{CODE()}<div class="rbox-data"">{CODE}

the line in remarksbox.tpl is:

{CODE()}<div class="rbox-data{$remarksbox_highlight}"{if !empty($remarksbox_width)} style="width:{$remarksbox_width}{/if}">{CODE}

When the second if statement evaluates to false an extra double-quote is still output.

Missing (12.x) or wrong (13.x) feedback to comment poster when Comments Moderation is on and post is not shown

However, in the show.t.o instance for 12.x, I couldn't get the same behavior I saw a few weeks in a 12.x in localhost.

Current issues reproduced in the show.t.o 12.x instance:
Adding a comment as anon to the homepage (with comments moderation enabled):
http://xavi-9794-5310.show.tikiwiki.org/tiki-index.php

{CODE()}
Notice: Array to string conversion in /var/www/xavi-9794-5310/vendor/bombayworks/zendframework1/library/Zend/Filter/Alnum.php on line 144
{CODE}

{CODE()}
Your comment was posted.

No object information provided.
{CODE}

In 13.x I saw the same output (without the initial array notice):
{CODE()}
Your comment was posted.

No object information provided.
{CODE}

This seems to be an error message:
{QUOTE()}
__No object information provided__
{QUOTE}

And "Your comment was posted." is a missleading information, since the comment is not visible yet (until moderation happens). So a better message could be shown in this case, something like:

"__Your comment was posted but is pending moderation, and until approval, it will not be shown__"

When viewing the page again, it says:
"There are no comments at this time."

when you would expect to see something like:

"__There are some comments hidden pending moderation__"
---
^ __And last, as registered users, there is no feedback of what happens in that tiki site that their comments are gone after clicking at "post".__ ^

{syntax type="tiki" editor="plain"}
Blog Title area, in FIVE ALIVE (grape) Theme, the TAGS do not display correctly.

This may be related to Ticket 3452, Blog Title Display Awry.

I had not found this bug earlier, because I had not used "TAGS". The data following the "TAGS:" is only visible if you highlight the area with a mouse.

EDIT @joel.magene 2026-06-02:-:
Original Grape tag issue is not exactly reproducible: tags are visible in FiveAlive/Grape. However, FiveAlive subthemes still have contrast issues on blog post pages. In Grape/Watermelon/Raspberry, blog post action menu items are nearly invisible. In Plum, blog post title area, metadata/tags, and section headers have very poor contrast and require highlighting to read. Updating ticket as a broader FiveAlive subtheme contrast issue.

I use ElasticSearch on a Tiki 22 and I have a weird error while browsing file gallery (in English).

{CODE()}Error
• Malformed search query: Parsing search query failed: "Field name does not exist in the current index. If this is a tracker field, the proper syntax is tracker_field_name."
{CODE}

Reproduced on local:
{img fileId="1568" thumb="box"}


I could track the error feedback that is generated from "lib/core/Search/Elastic/OrderBuilder.php" line 81.

Something in the condition : if ((empty($mapping) || empty((array)$mapping)) && $prefs['search_error_missing_field'] === 'y') {

Initiate the feedback.

---

It happened also while I was updating a field (f_174) using the tracker interface inline. (in Hebrew)
The field is a dropdown field type.
The field exist and the change was saved.

{CODE()}
שגיאה
Malformed search query: Parsing search query failed: "Field f_174 does not exist in the current index. If this is a tracker field, the proper syntax is tracker_field_f_174."
{CODE}

{img fileId="1569" thumb="box"}

''Now it keep showing each time I do anything on tracker, even listing them all.''


Still there on Tiki23:
{img fileId="1582" thumb="box"}

After upgrading from 1.9.11 to 2.0 an error occurs with a missing field (email_confirm) when trying to add a new user as summarised at the end of this post. This seems to be repeatable across several sites that I have upgraded from 1.9.11 so I am assuming something wrong with the upgrade script. Have checked the database using phpMyAdmin and whilst the field is present on a brand new install it is consistently missing in all the upgrades. Manually adding the field from phpMyAdmin rectifies the problem.

Would be very useful to have the full 2.0 data structure documented since I am seeing inconsistencies between the the number of tables in an upgraded site versus a new 2.0 site (upgrade had more tables) - some sort of test utility to validate the data structure would also be very very useful.



__ERRORS RECEIVED WHEN TRYING TO ADD A NEW USER:__

An error occured in a database query!

Context:
File tiki-adminusers.php
Url tiki-adminusers.php
Query:
insert into `users_users`(`login`, `password`, `email`, `provpass`, `registrationDate`, `hash`, `pass_confirm`, `email_confirm`, `created`, `valid`, `openid_url`, `lastLogin`, `waiting`) values(?,?,?,?,?,?,?,?,?,?,?,?,?)
Values:
0 testuser
1 testuser99
2 admin@enmoreservices.com
3
4 1221214268
5 $1$9LOB42RB$ZHSl8Al4i9Aw4KcLnHlpa.
6 0
7 1221214268
8 1221214268
9 NULL
10 NULL
11 NULL
12 NULL
Message:
Unknown column 'email_confirm' in 'field list'
Built query was probably:
insert into `users_users`(`login`, `password`, `email`, `provpass`, `registrationDate`, `hash`, `pass_confirm`, `email_confirm`, `created`, `valid`, `openid_url`, `lastLogin`, `waiting`) values('testuser','testuser99','admin@enmoreservices.com','','1221214268','$1$9LOB42RB$ZHSl8Al4i9Aw4KcLnHlpa.','0','1221214268','1221214268',NULL,NULL,NULL,NULL)

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

header.tpl should contain something like below for trackers.

{if $feature_directory eq 'y' and $rss_directories eq 'y'}
<link rel="alternate" type="application/xml" title="{tr}RSS Directories{/tr}" href="tiki-directories_rss.php?ver={$rssfeed_default_version}" />
{/if}

After upgrading 1.9.4 to 1.9.5, a search entire site returns the following error. I looked in db/fulltext.sql and didn't see a create fulltext index statement for tracker. What tables/columns should be indexed?

~pp~
in /home/lampp/htdocs/kniki/lib/tikidblib.php on line 134

Context:
File /kniki/tiki-searchresults.php
Url ///kniki/tiki-searchresults.php?highlight=draw&where=pages&search=go
Query:
SELECT ttif.`itemId` AS name, LEFT(tt.`name`, 240) AS data, tt.`trackerId` AS hits,
tti.`lastModif` AS lastModif, tti.`itemId` AS pageName,tti.`itemId` AS id1,1 AS id2,
MATCH(`value`) AGAINST ('draw') AS relevance FROM `tiki_tracker_item_fields` ttif LEFT
JOIN `tiki_tracker_items` tti ON (ttif.`itemId`=tti.`itemId`) LEFT JOIN `tiki_trackers`
tt ON (tti.`trackerId`= tt.`trackerId`) LEFT JOIN `tiki_tracker_fields` ttf ON
(ttf.`fieldId`= ttif.`fieldId`) WHERE ttf.`isSearchable` = "y" AND MATCH(`value`)
AGAINST ('draw') ORDER BY relevance desc, tt.`trackerId`

Values:
Message:
Error Message Can't find FULLTEXT index matching the column list
~/pp~

On tiki-install.php, in the install menu "help" the first icon is missing as it refer to "img/favicons/favicon-16x16.png" and there is no such folder or file.

{img fileId="1109" thumb="box"}

I created a tracker item a few days ago: https://dev.tiki.org/item5826 (highlighted text issue).
It should be displayed here : https://dev.tiki.org/tiki-user_information.php#contentuser_information-2

But it is not.

However another item I create a few days ago too : https://dev.tiki.org/item5822 is in my items page.

May be it is related to that the only difference is the lasmod (jonny).

At dev.org 2 days ago I had a pending item where I was the creator and someone else a modifier:
https://dev.tiki.org/item5028

It was not displayed on my items at :
https://dev.tiki.org/tiki-user_information.php#contentuser_information-2

Trying to pin-point I modified the item to be also the modifier but it didn’t help.

This is pretty critical and nearly a blocker.

When viewing the list of messages, no matter how many messages have been chosen to display, the system displays at the bottom

Page: 1/1

With no prev/next links

There is no way for users to access the rest of their messages. Sorting works, so they can reverse-sort the date etc... but this is hardly equivalent and anyway once they have more than 2x the display list size, the remaining messages are out of reach entirely.

With any Theme selected.

When editing a new File Gallery or modifying an existing Gallery, no Parent-Gallery Selection box is shown. Thus you can neither create new File Galleries nor move existing File Galleries to other parents. (See {img id=109})

Contrary to TikiWiki documentation (and contrary to TikiWiki common sense) it is NOT possible in a 3.0 wiki (specifically http://jiamcatt.ourwiki.net) to assign any permissions to Newsletters. This means that NO ONE, other than Admins can even see the list of Newsletters, to say nothing of viewing past newsletters (the archives). This is unacceptable – and contrary to TikiWiki documentation.

JIAMCATT is the community of IT-oriented managers of language (translation and interpretation) services of major International organizations and European multilateral bodies. After a slow start about a year ago this community has now agreed to try to use a TikiWiki-based system. Within the past month (since several of the TikiWiki team participated in the JIAMCATT annual meeting in Ottawa, Canada early May 2009) close to 200 users have joined up.
One key aspect of the work of JIAMCATT are Working Groups. One of these has just started work. It’s tools include wiki pages in the two working languages (En + Fr), a discussion forum (consisting already of 13 topics), and – last but NOT least – a Newsletter to keep everyone abreast of developments. This feature, it now turns out doesn’t work in a very bad way: NO ONE, other than Admins can even see the list of Newsletters, to say nothing of viewing past newsletters (the archives). This is unacceptable – and contrary to TikiWiki documentation.

I expect this should be a simple fix for a TikiWiki insider (the feature existed at the time the documentation was written); albeit impossible for someone not intimate with the insides of this system.

Screen shots are attached. The first – now shows as the last – called “ButtonsAvail-inJiamcatt-ourwiki-net-Newsletter-admin.gif” shows the buttons seen by an Admin user when trying to do “Admin Newsletters”. The second, called “MissingButton-from-doc-tikiwiki-org.gif” shows the buttons in doc.tikiwiki.org in the http://doc.tikiwiki.org/Newsletters section in the http://doc.tikiwiki.org/tiki-index.php?page=Newsletter+Admin&bl=y page, under the segment titled “Changing Existing Newsletters”. The third screen shows you what a non-Admin user who should have access to view newsletters and archives of this Working Group, sees (file: “Empty list of newsletters for (nonAdmin) WG members.gif”).

Unless someone can provide a fix quickly, this group will abandon TikiWiki as its working tool.

omstefanov

The database table tiki_user_assigned_modules is not created on install. I am using mysql version 5.7.17, but the error may occur on other versions.

The query that creates the table:
DROP TABLE IF EXISTS `tiki_user_assigned_modules`;
CREATE TABLE `tiki_user_assigned_modules` (
`moduleId` int(8) NOT NULL,
`name` varchar(200) NOT NULL default '',
`position` varchar(20) default NULL,
`ord` int(4) default NULL,
`type` char(1) default NULL,
`user` varchar(200) NOT NULL default '',
PRIMARY KEY (`name`(30),`user`,`position`, `ord`),
KEY `id` (moduleId)
) ENGINE=MyISAM;

mysql throws an error of Primary Key cannot have NULL values, and the table fails to be created.

The missing table was first noticed when trying to modify the modules listed in the Assigned Modules area of the tiki-admin_modules.php page.

Suggested fix:
This table seems similar to the tiki_modules table. I would suggest modifying the position and ord columns to have the NOT NULL DEFAULT '' and '0' to match that table. I don't know what affect this will have on the tiki code overall, but it does let the database table be created.

The suggested sql code then becomes:
DROP TABLE IF EXISTS `tiki_user_assigned_modules`;
CREATE TABLE `tiki_user_assigned_modules` (
`moduleId` int(8) NOT NULL,
`name` varchar(200) NOT NULL default '',
`position` varchar(20) NOT NULL default '',
`ord` int(4) NOT NULL default '0',
`type` char(1) default NULL,
`user` varchar(200) NOT NULL default '',
PRIMARY KEY (`name`(30),`user`,`position`, `ord`),
KEY `id` (moduleId)
) ENGINE=MyISAM;

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"}
I started today collaborating with translation into Portuguese language.
My first edition the page [http://doc.tikiwiki.org/tiki-editpage.php?page=Usando%20Páginas%20Wiki|Using Wiki Page (pt)]

the moment I clicked SAVE, I got an error page.
I created a PDF document from it.
As this is my first Bug report I hope I will be able to send the PDF attached to this Bug Report.

I tried the mod blogroll with an example opml file from wikipedia, and the rss icons doesn't link to the expected mp3 but to the same url as the url of the browser in tiki (tiki-list_file_gallery.php?galleryId=1, tiki-admin_modules.php, ...)

This happened with this blogroll:
[http://static.userland.com/gems/radiodiscuss/playlist.opml]

The one I used for documentation. After fixing the problem, if so, please, check documentation page to see if it's correct (I didn't understand that much about the whole thing myself ...):
[http://doc.tikiwiki.org/Mod+blogroll]


Moreover, with this other opml file:
[http://www.scripting.com/feeds/top100.opml]

The rss icons point to xml files, but no text is shown between the number of the item and the rss icon. (error). See attached image to this tracker item.

mod import-phpwiki (as it is from http://mods.tikiwiki.org) doesn't contain the php and tpl files.
Looking in cvs, the files are under a subdirectory of this mod (tikiroot): maybe that's why they didn't get packed inside the mod?

When using mod_last_modif_tracker_items on a tracker in mirror tables, then it just shows the item numbers, but not the content of the assigned field.

I looks like that:

1)
2)
3)
4)

Google changed their formula. module should now deal with:
google_ad_client = "pub-xxxxxxxx";
google_ad_slot = "02353245";
google_ad_width = 468;
google_ad_height = 15;


While we are playing here, the module should be re-organized and default should be a public service advertisement

Current Adsense module is too complicated to set-up as we can read here:
http://tikiwiki.org/Module+Adsense

There are way too many forum posts for something which should be really simple to set up:
http://tikiwiki.org/tiki-searchindex.php?highlight=adsense&where=forums

So, I suggest:

The public service advertisement should appear instead of the current "You forgot your Google ad_client number !" message. So people would know right away that the connection with Google is OK.

By default, it should be a fairly small ad so it fits nicely in a module.

And if the user is admin level (check for tiki_p_admin), then, add a link to documentation on how to set pub-xxxxxxxxxxxx and others...
http://doc.tikiwiki.org/tiki-index.php?page=Module+adsense

So, if no pub-xxx number is set, use pub-xxxxxxxxxxxx (which provides the public service advertisement) with a warning for admins.

If the admin specifically wants a public service advertisement, he can set the pub number as pub-xxxxxxxxxxxx. In which case, there should not be a warning to admins on how to set.

Finally, if the pub number is set normally (ex.: pub-1234...), no admin warning should appear.

Complete error-message is:
''Notice: Undefined variable: modcatlist in /modules/mod-change_category.php on line 72''

Steps to reproduce:

- assign mod-change_category.php to a column
- go to Admin->General or tiki-print.php
- see the error message

Editing my wiki HomePage I even had Tiki dieing completely with errors:

Notice: Undefined variable: modcatlist in /home/amette/public_html/tikiwiki-BRANCH-1-9/modules/mod-change_category.php on line 72

Warning: Cannot modify header information - headers already sent by (output started at /home/amette/public_html/tikiwiki-BRANCH-1-9/modules/mod-change_category.php:72) in /home/amette/public_html/tikiwiki-BRANCH-1-9/tiki-editpage.php on line 775

templates/modules/mod-events.tpl uses mktime and under php5 it needs to have all arguments as integers.
Simple patch:

For the Google Adsense Module:

Google Adsense Client IDs are in the format pub-0123456789012345
Line 42 of mod-func-adsense.php sets this data input type to 'alpha'.
When the user tries to assign the module, the numbers get stripped from the client ID, which is a required field.

I changed 'alpha' to 'striptags' to allow an alpha-numeric entry and then Adsense output works correctly.