Category: Error

Critical error:
I created a brand new 1.10 tiki site (using cvs code from 13th june 2007): Profile: Basic enabled for easy use.
Using tikineat.css (or others), When I attempt to edit (cliking on the edit button next to the module):

http://yoursite/tiki-admin_modules.php?edit_assign=quick_edit&position=l&ord=2#assign

I change the position, click on save, but I get the Error message:

{CODE()}
An error occured in a database query!

Context:
File tiki-admin_modules.php
Url tiki-admin_modules.php
Query:
insert into `tiki_modules`(`name`,`title`,`position`,`ord`,`cache_time`,`rows`,`groups`,`params`,`type`) values(?,?,?,?,?,?,?,?,?)
Values:
0 quick_edit
1
2 l
3 20
4 0
5 0
6 a:1:{i:0;s:10:"Registered";}
7
8
Message:
Error Message Duplicate entry 'quick_edit' for key 1


Go back

Return to home page
{CODE}

{syntax type="tiki" editor="plain"}
When clicking the Assign white plus sign on green background icon in Admin modules User modules tab, PostgreSQL fails complaining:

The following error message was returned:

ERROR: invalid input syntax for integer: "mnu_application_menu"

The query was:
select * from "tiki_modules" where "moduleId"=?

Values:

1. mnu_application_menu

The built query was likely:
select * from "tiki_modules" where "moduleId"='mnu_application_menu'

Stacktrace:
* /var/www/tiki/trunk/tiki-admin_modules.php : 0 -> {main}(array ( ))
* /var/www/tiki/trunk/tiki-admin_modules.php : 63 -> get_assigned_module(array ( 'moduleId' => '\'mnu_application_menu\'', ))
* /var/www/tiki/trunk/lib/modules/modlib.php : 60 -> query(array ( 'query' => '\'select * from `tiki_modules` where `moduleId`=?\'', 'values' => 'array (0 => \'mnu_application_menu\')', 'numrows' => '', 'offset' => '', 'reporterrors' => '', ))
[...]


Indeed, the query would expect an integer argument, not a string. This is a regression from r8873, which changed modlib's interface. get_assigned_module() now expects its first argument to be a moduleId, not a module name.

In a new 24.x vcs master installation the tiki-admin_modules.php UI is broken.
The UI is kind of cut-off below the module zone tabs and there is no button to add new modules. The interface seems to have been reorganised, but not finalised yet.

When activating and deactivating (playing around) the tabs / no tabs buttons the button appears.
--I will try to confirm with show.tiki.org-- confirmed
There seems to be a conflict with two variants of the tab toggle (tab view / no tabs) and and a duplication of the admin module tabs. See attached screenshots.

I assume a template issue {sign user="Torsten" datetime="2021-12-06T07:09:50+00:00"}

{syntax type="tiki" editor="plain"}
In tiki-admin.php?page=login, help link from "Require users to fill in tracker information" goes to non-existent URL: https://doc.tiki.org/Force-Fill-Tracker

I believe the URL should go to: https://doc.tiki.org/Force-Filled-Tracker

On the Admin section -> Log In -> Authentication method: Tiki

The setting Users can register is uncheck.
All the sub setting are hidden but some setting seams to still applied.

Example : If "Validate new user registrations by email" is checked the user will be forced to validate his email.

tiki-admin.php?page=textarea#contentadmin_textarea-2 had its main section (Plugins) changed in r61597. It mostly works now, but there is still a problem when searching for short terms, i.e. those under [https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_ft_min_word_len|ft_min_word_len] (for MyISAM; the limit for InnoDB tables is controlled by a different variable).

If the query contains nothing but terms under the limit, all plugins are displayed. If the query contains at least one sufficiently long term, the too short terms are ignored.

One solution would be to display a warning about short terms next to "Plugins found containing: foo".

I am however wondering if we couldn't just go back to the previous code, which didn't have this problem (adapted to not show all plugins by default?). I guess one important reason for the change was to speed up page load, but page generation takes about 7 seconds here, which appears to be the same as, for example, Admin Profiles, so the gain is not obvious.

Trying to revert the change causes important conflicts.

Related: issue 6307

When creating a topic in admin topic (tiki-admin_topics.php) i have 2 fields to fill:
Topic Name
Upload Image

Only name is mandatory and saving is ok.

If i want to edit the created topic to modify it i see a third field appearing: Add Notification Email.
If i save without giving an email i got the following error : Invalid email.
I can't save. Best evasion course is to close or jump back from this page.

I don't recall having set a feature or an option that force emails for topic article notifications.

There is no reason why i should be forced to add an email ONLY on edit (if a feature were set for a mandatory email address) and the error message (if he is linked to a feature) should be more explicit.

If admin user get lots of php warnings. Eventually page will build. Other warnings depending on various DB requests. Not a cookie problem - deleted cookies. Not browser specific.

Typical warnings encountered.

Most everything:
Notice: Only variable references should be returned by reference in lib/adodb/adodb.inc.php on line 2797
Notice: Only variable references should be returned by reference in lib/adodb/adodb.inc.php on line 2802
Admin Menu:
Warning: usort(): Invalid comparison function. in lib/tikilib.php on line 1714
Notice: Only variable references should be returned by reference in /home/vamasono/public_html/cms/lib/pear/PEAR.php on line 425
Admin Groups:
Warning: Cannot modify header information - headers already sent by (output started at lib/adodb/adodb.inc.php:2797) in tiki-admingroups.php on line 254

Installed full v1.9.1 to a DB with 1.9.0. Ran 1.9.0->1.9.1.

{syntax type="tiki" editor="plain"}
I can´t use the "User Modules" tab under the "Admin Modules" (tiki-admin_modules.php).

I get a large screen, with the screen contents "lost" there (you need to pane to be able to see them) and the folowing message following "Dynamic content blocks:"

<a class=link href="javascript: ........... [<a href='function.unlink'>function.unlink</a>: No such file or directory .......>

I´m sorry not to copy the whole line but it is quite long and it does not allow me use "Cut and paste" neither with the mouse or using Ctrl-C, so I decided to copy the only place where I could find something strange, please let me know if I must inform the whole line.

new user can register but after admin validate his account user can't login because have no password in database

version: tikiwiki 1.9.9 - sirius
conf: allowRegister=y ; validateRegistration=y ; validateUsers=n

In templates/mail/moderate_validation_mail.tpl this line is converted badly by smarty:
{$mail_machine}?user={$mail_user|escape:'url'}&pass={$mail_apass}

Smarty removes the '?' char if it's directly after a '}' (no clue why).
So I always get a bad link like this:
http://<ip>/tikiwiki/tiki-login_validate.phpuser=xxx&pass=xxx

Any solution to this? I tried to use %3F but doesn't work very well...

{syntax type="tiki" editor="plain"}
Admin, Menus Feature

When I try and add a new menu I receive the following error:


An error occurred in a database query!

Message:
Unknown column 'icon' in 'field list'

This is see is a new field in 2.0. I then tried entering the folder information to the icons but the new menu will still not save.

After upgrading to 1.10, the icon to click to admin menu options does not appear in Admin...Menu. Need to reproduce and test.

When I go to administer modules I recieve this error.

An error occured in a database query!
Context:
File tiki-admin_modules.php
Url tiki-admin_modules.php

Message:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT `contentId`, count(*) AS `future` FROM `tiki_programmed_

This problems started after I upgraded to 2.0. I do not know what any of this means and need some direction.
Thanks
Cindy

The admin menu does not appear on first login after fresh install of 1.10

{syntax type="tiki" editor="plain"}
Administration, Features, Wiki


I can enable the 'Pictures:' feature in the 'Wiki Features', however when I then edit a page the 'Upload' feature does not appear.


I found if i remove the WYSIWYG editor feature, the Picture and File Upload becomes available when editing a page.

On the Control Panels page there is a new remarksbox to encourage using the advanced mode switch.

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

No matter how many times I moved the switch to advanced saving or not (Apply) it is not effective and back to the initial position.

The switch from the Preferences Filter is working fine.

{syntax type="tiki" editor="plain"}
Warning: mkdir() [function.mkdir]: SAFE MODE Restriction in effect. The script whose uid is 2003 is not allowed to access /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/mods owned by uid 2001 in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/tiki-mods.php on line 37

Warning: mkdir() [function.mkdir]: SAFE MODE Restriction in effect. The script whose uid is 2003 is not allowed to access /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/mods owned by uid 2001 in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/tiki-mods.php on line 40

Warning: mkdir() [function.mkdir]: SAFE MODE Restriction in effect. The script whose uid is 2003 is not allowed to access /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/mods owned by uid 2001 in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/tiki-mods.php on line 43

Warning: opendir() [function.opendir]: SAFE MODE Restriction in effect. The script whose uid is 2003 is not allowed to access /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/mods owned by uid 2001 in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/lib/mods/modslib.php on line 205

Warning: opendir(mods/Packages) [function.opendir]: failed to open dir: No such file or directory in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/lib/mods/modslib.php on line 205

Warning: readdir(): supplied argument is not a valid Directory resource in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/lib/mods/modslib.php on line 206

Warning: closedir(): supplied argument is not a valid Directory resource in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/lib/mods/modslib.php on line 211

Warning: fopen() [function.fopen]: SAFE MODE Restriction in effect. The script whose uid is 2003 is not allowed to access /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/mods owned by uid 2001 in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/lib/mods/modslib.php on line 212

Warning: fopen(mods/Packages/00_list.txt) [function.fopen]: failed to open stream: No such file or directory in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/lib/mods/modslib.php on line 212

Warning: fputs(): supplied argument is not a valid stream resource in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/lib/mods/modslib.php on line 229

Warning: fclose(): supplied argument is not a valid stream resource in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/lib/mods/modslib.php on line 231

Warning: opendir() [function.opendir]: SAFE MODE Restriction in effect. The script whose uid is 2003 is not allowed to access /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/mods owned by uid 2001 in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/lib/mods/modslib.php on line 205

Warning: opendir(mods/Installed) [function.opendir]: failed to open dir: No such file or directory in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/lib/mods/modslib.php on line 205

Warning: readdir(): supplied argument is not a valid Directory resource in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/lib/mods/modslib.php on line 206

Warning: closedir(): supplied argument is not a valid Directory resource in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/lib/mods/modslib.php on line 211

Warning: fopen() [function.fopen]: SAFE MODE Restriction in effect. The script whose uid is 2003 is not allowed to access /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/mods owned by uid 2001 in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/lib/mods/modslib.php on line 212

Warning: fopen(mods/Installed/00_list.txt) [function.fopen]: failed to open stream: No such file or directory in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/lib/mods/modslib.php on line 212

Warning: fputs(): supplied argument is not a valid stream resource in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/lib/mods/modslib.php on line 229

Warning: fclose(): supplied argument is not a valid stream resource in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/lib/mods/modslib.php on line 231

Warning: touch() [function.touch]: SAFE MODE Restriction in effect. The script whose uid is 2003 is not allowed to access /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/mods owned by uid 2001 in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/tiki-mods.php on line 108

Notice: Undefined variable: errmsg in /www/1stfreehosting.com/o/t/h/othman/htdocs/tikiwiki/lib/mods/modslib.php on line 117

On a new installation of TikiWiki 1.9.4 (installed via Fantastico on a LAMP server), I get the following error:

Notice: Only variable references should be returned by reference in /home/hocho/public_html/wiki/tikiwiki/lib/adodb/adodb.inc.php on line 834

Warning: Cannot modify header information - headers already sent by (output started at /home/hocho/public_html/wiki/tikiwiki/lib/adodb/adodb.inc.php:834) in /home/hocho/public_html/wiki/tikiwiki/tiki-adminusers.php on line 414


All I did was create a new group and try to assign the group to a new user.
I also don't know why it is using ADOdb when I am using MySQL.

All other functionality of TikiWiki seems fine.

According to http://phplens.com/lens/adodb/docs-session.htm, garbage collection is supposed to be automatic for adodb sessions, which are used in tiki when "store sessions in db" is turned on. But it does not seem to be working. Have to figure out why first, before I can fix.

Google adsense does not display.
This error occurred in FiveAlive and "thenews".
I tried using "Banners".
I tried using "Template".
I tried using "Module: AdSense".
I tried using "Module: User".
I tried using "HTML plug in".

In an Article and Blog, I used the HTML plug in, authorized the HTML, and nothing displayed.

By experimentation, I added the carat (box) around the plug in, and it displayed in PREVIEW mode. But when I saved it, an empty box with no adsense text displayed. (No, the carat didn't trigger it, just was the reason I previewed it.)

"Allow HTML" box is checked.

When I look at the page source, the HTML is there.

~np~<script type="text/javascript"><!--
~/np~~np~google_ad_client = "pub-0000000000000";
~/np~~np~/* 468x60 wiki */
~/np~~np~google_ad_slot = "9690243348";
~/np~~np~google_ad_width = 468;
~/np~~np~google_ad_height = 60;
~/np~~np~//-->
~/np~~np~<p></script>
~/np~~np~<script type="text/javascript"
~/np~~np~src="http://pagead2.googlesyndication.com/pagead
~/np~~np~/show_ads.js">
~/np~~np~<br /></script>
~/np~
The xhtml br / is the only discrepancy that I can find between the "PREVIEW" versus the "SAVED" version.

In/tiki-admin.php?page=module we have an advanced feature: "Users can configure modules".

Maybe "Theme Control" needs to be active.

When active, all modules have extra icons for moving them from left to right, or deleting, etc.
This is meant for allowing users to personally changes modules placement or visibility (not globally, just for them).

Advice: create a new user or backup the database.
When clicking on any such icons, table
"tiki_user_assigned_modules" gets values (this looks expected), and the whole display is immediately broken for this user because modules don't show up anymore. Especially the modules for login/logout or menus...

No obvious way of fixing except clearing table "tiki_user_assigned_modules".

Not the most useful feature and I don't know if it worked before, but it should either be fixed or tagged "experimental"...
Customers who hit this found no other way out than creating a new user :-(

Empty date tracker-field shows data through Mathematical calculation tracker field


An item from our intranet (item65 ) has no value at a date field (trkDeliveryDate). trkDeliveryDate is a date field (date picker) with only date, and no default value set in this preference.

Field trkDeliveryMonth is a Mathematical calculation tracker field, extracting the month from that date field, which should be empty, but it's not, it shows some month (current month, I don't know if by chance or by which means).

trkDeliveryMonth:
{CODE()}
(date (str y-m) trkDeliveryDate)
{CODE}

the "advanced" search function (which is the default search these days BTW) does not search through anything but Dutch Roman characters (eg the English American character set)

I have 4 pages with the Alón name on them as an example, searching for Alón or Alon shows no results, BTW the non advanced search works correctly

This is on Tiki 4.2

On a multilingual project this makes the search function totally redundant as far as I am concerned

Tested in v3.1 on XP/IEv6, Vista/IEv7, Vista/Firefox. The help button (blue circle w/ question mark) next to "Advanced Search" in the module search_box does not bring up any help info. Instead, it points to the anchor #advanced_search_help on whatever page the user is viewing, but the anchor doesn't exist. IE shows an "Error on page" in the browser status bar.

Tested in XP/IEv6 with "Floating Help" UI feature on - same result. Unknown if "Floating Help" changes results in IEv7 or FF.