Category: Error

multitiki not working if adding "?lang=ca" to tiki-install.php script => multitiki not i18n ready

If clicking on links at tiki-install.php, there is not language setting for the interface. And if you attempt to manually add the param, then when changing the new db settings for any child tiki install, the settings are saved in default db, not the child one.

{syntax type="tiki" editor="plain"}
I am trying out the MWtable plugin.
When I preview a table on a wikipage I am alerted :

This plugin was recently added or modified. Until an editor of the site validates the parameters, execution will not be possible. You are allowed to:
View arguments
Execute the plugin in preview mode (may be dangerous)
Approve the plugin for public execution
View Details

if I click on "view details" I am prsented with the option of approving the plugin. Clicking the button, however, will transfer me to the edit-mode of the Wiki Homepage

This happened after saving http://dev.tikiwiki.org/tiki-admin_trackers.php?trackerId=5 where I had checked "and display attachments in listing?" (sub-option of Tracker items allow attachments?). I was unable to reproduce thereafter.

However, I noticed after that the ratings column had moved from first (left-hand side) to last (right-hand side).

{THUMB(id=26, url="tiki-browse_image.php?imageId=26")}{THUMB}

This tracker item could not be found

Hello, I have been receiving this error ever since I upgraded to 2.0 (I have since upgraded to 2.1 and then 2.2). When I try to add a new user, I receive this MySQL error message. I have not found any workaround.

I did a clean install and clean database install and was unable to duplicate this error that way.
MySQL version 4.0.18 local on a Suse OES 1 box. TikiWiki 2.2, started occuring in 2.0.

{img src=show_image.php?id=62}



Thanks for the help!

Hello, I have been receiving this error ever since I upgraded to 2.0 (I have since upgraded to 2.1 and then 2.2). When I click on admin_categories, I receive this MySQL error message. I have not found any workaround.

I did a clean install and clean database install and was unable to admin_categories there either.
MySQL version 4.0.18 local on a Suse OES 1 box. TikiWiki 2.2, started occuring in 2.0.

{img src=show_image.php?id=60}


Please help! Thanks a lot!

Hello, I have been receiving this error ever since I upgraded to 2.0 (I have since upgraded to 2.1 and then 2.2). When I click on admin_modules, I receive this MySQL error message. I have not found any workaround.

I did a clean install and clean database install and was unable to admin_modules there either.
MySQL version 4.0.18 local on a Suse OES 1 box. TikiWiki 2.2, started occuring in 2.0.

{img src=show_image.php?id=61}



Please help! Thanks! Russ

I have another problem on TikiWiki 2.0RC2:

I have two similar TikiWiki-installations. One just for testing on my Linux-Server and the second on a WinNT-Server. The Windows-Server is the one we want to/have to use for our Wiki :-(

On my Linux-Server works everything without problems.

On the Win-Server don’t work "approve+staging".

If I wont approve changes it shows me this error:

An error occured in a database query!

Context:
File tiki-approve_staging_page.php
Url tiki-approve_staging_page.php?page=Baustelle_Test
Query:
update `tiki_pages` set `description`=? `data`=? `comment`=? `lastModif`=? `version`=? `user`=? `ip`=? `page_size`=? `is_html`=? `wysiwyg`=? `wiki_authors_style`=? `flag`=? `lockedby`=? where `pageName`=?
Values:
0
1 <p>Test</p>
2 [approved by ottonormal]
3 1217330865
4 6
5 ottonormal
6 10.40.153.101
7 225
8 1
9
10 NULL
11
12
13 Test
Message:

Built query was probably:
update `tiki_pages` set `description`='' `data`='<p>Test</p>' `comment`=' [approved by ottonormal]' `lastModif`='1217330865' `version`='6' `user`='ottonormal' `ip`='10.40.153.101' `page_size`='225' `is_html`='1' `wysiwyg`='' `wiki_authors_style`=NULL `flag`='' `lockedby`='' where `pageName`='Test'

{syntax type="tiki" editor="plain"}
Error "Out of range value for column 'entryId' at row 1" appears whenever modifying almost any content.

I have documented the problem and a workaround here:
* [https://doc.tiki.org/Troubleshooting?page_ref_id=4835#Ancient_Tiki_triggering_error_Out_of_range_value_for_column_entryId_at_row_1_on_every_change_advanced_|https://doc.tiki.org/Troubleshooting]

Maybe we should add a way of doing this automatically whenever necessary (every 10 years or so?)

I am unable to click any of the links on the top navigation while on my iPad. Entering full screen does not help. That includes the option to log-in or visit any area of the site using the main navigation.

Theme: Dev.tiki.org theme
Version: 15.3svn
iOS Version: 9.3.5

Chrome is also effected. One on one computer is completely broken, while on another, works fine.

*No Console Errors
*Same behaviour on working and non working chrome while JS disabled.
*No effect when all browser extensions are disabled
*Drop down navigation and Tabs effected
*Simple links not affected
*Browser updates url with what is clicked (in the case of tabs) but no action results
*Navigating to that link manually in the nav var has no effect
*Copy the url and navigate to it in another browser, and the correct page will load.
*Issue appears consistently, (my ipad and chrome are always broken) but not consistently across platforms (other chrome installs on other computers work fine)

To reproduce:


Make a super long wiki page using:

((my super duper long extra long wiki page name the never ends because it can be difficult to find the right words sometimes and some people may be tempted to just throw in a very large number of keywords in a wiki page name and hope that it will help with search engine indexing))

The wiki page offers a question mark to create the new page but TikiWiki is unable to create a page that size so it truncates to 160 characters: ((my super duper long extra long wiki page name the never ends because it can be difficult to find the right words sometimes and some people may be tempted to jus))


A nicer error message would be nice

When you load the administration page for the first time of a session, you cannot see all icons. It's like if the page was truncated.
So you need to load the administration page a second time in order to see all icons.

Hi,

It just occurred to me that when upgrading to 1.10, users will need a script or something to create tiki_p_edit_categories perms for each tiki_p_view_categories perm that category objects have in the db.

This is necessary to preserve backward compatible state when upgrading, because tiki_p_edit_categories does not exist in 1.9.

Anyone good enough in SQL to write this purely in SQL, or should this be part of the PHP in the upgrade/install script for 1.10?

Nested footnotes do not display in footnote area.

This is because footnote content is not evaluated until after footnote area renders it. Using a second footnote area will render the footnotes correctly, in the second footnote area, but the links to those footnotes in the second footnote area no longer function.

Evaluating footnote content within the footnote plugin should fix the error.

!!!Begin Footnote Test

non footnote area {FOOTNOTE()}Footnote 1 {FOOTNOTE()}Nested Footnote 2 {FOOTNOTE} Continuation of Footnote 1 {FOOTNOTE()} Nested Footnote 3 {FOOTNOTE()}Footnote Nested Twice 4{FOOTNOTE}{FOOTNOTE}{FOOTNOTE}
text after all footnotes

{footnotearea() /}

!!!Expected Result

non footnote area {SUP()}((1)){SUP} text after all footnotes

((1)). Footnote 1 {SUP()}((2)){SUP} Continuation of Footnote 1 {SUP()}((3)){SUP}
((2)). Nested Footnote 2
((3)). Nested Footnote 3 {SUP()}((4)){SUP}
((4)). Footnote Nested Twice 4

The expected result is for each footnote to appear once, each with there own footnote number, and referenced as such in the main body of the text. Additionally, using a footnote should not create a line break in the original text.

!!!End Footnote Test

This tracker item could not be found

If your users login has a ".", as in "firstname.lastname", the remember me feature breaks.

This is the snippets in tiki-login.php use to set the cookie:

{img src=images/code.png}%%% {CODE()}
// Now if the remember me feature is on and the user checked the rememberme checkbox then ...
if ($rememberme != 'disabled') {
if (isset($_REQUEST['rme']) && $_REQUEST['rme'] == 'on') {
$hash = $userlib->get_user_hash($_REQUEST['user']);
$hash = $userlib->create_user_cookie($_REQUEST['user']);
$time = substr($hash,strpos($hash,'.')+1);
setcookie($user_cookie_site, $hash.'.'.$user, $time, $cookie_path, $cookie_domain);
$logslib->add_log('login',"got a cookie for $remembertime seconds");
}
}
{CODE}


The cookie content has the following format:
{img src=images/code.png}%%% {CODE()}
md5($_SERVER['REMOTE_ADDR'].$_SERVER['HTTP_USER_AGENT']).(date('U') + $remembertime).$user
{CODE}

The following code in userslib.php parse the cookie content. This function will successfully returns
the user only if your users login does not have a ".", otherwise this function will always return
false, and users have to re-login everytime.

{img src=images/code.png}%%% {CODE()}
function get_user_by_cookie($hash) {
list($check,$expire,$userCookie) = explode('.',$hash);
if ($check == md5($_SERVER['REMOTE_ADDR'].$_SERVER['HTTP_USER_AGENT'])) {
$query = 'select `user` from `tiki_user_preferences` where `prefName`=? and `value`=? and `user`=?';
$user = $this->getOne($query, array('cookie',"$check.$expire", $userCookie));
if ($user) {
if ($expire < date('U')) {
$query = 'delete from `tiki_user_preferences` where `prefName`=? and `value`=?';
$user = $this->query($query, array('cookie',$hash));
return false;
} else {
return $user;
}
}
}
return false;
}

{CODE}

Basically what happens is when you try to create a new calendar item, when altering the Start and End times, there is some sort of bug occurring in how it calculates the time codes in the back end. If the times of the event start in the AM and end in the PM, it causes some sort of issue with the way the timecodes are calculated. As well, it appears to be an issue with the 'predictive' functionality it uses. When you select something like an 8AM Start time, it will automatically try to adjust the End time to something an hour in advance or so. This will cause it to get hung up thinking, and sometimes it automatically changes the year to some distant future date like in the year 2507.

As well, selecting a Start time in the AM, and an End time in the PM such as 9AM-9PM causes the calendar to say "Events cannot end before they start."

To test: simply go to the Test calendar on the Show Instance and try creating a new event. Play with the Hours on the Start and End times by just changing them around several times. This will always result in the calendar lagging out and sometimes an unresponsive page.

I will replicate this in a tiki show instance.

Thanks.

{syntax type="tiki" editor="plain"}
It will report a system error while saving a new file gallery

In 1.10, the page position is shown on the structure nav for page. It works perfectly for new pages, because of the fix applied in http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=889

However, structure pages created in 1.9 may have pos in db that remains non-contiguous. It will be better to have a way to clean this up.

I just installed a brand new tiki trunk on local (Ubuntu GNU/Linux 8.04, using Mysql 5.0.51a), and tiki-install.php returned those error messages:
{CODE()}
SELECT patch_name FROM tiki_schema
Table 'tikitrunk_svn.tiki_schema' doesn't exist
CREATE TABLE tiki_tracker_fields (
fieldId int(12) NOT NULL auto_increment,
trackerId int(12) NOT NULL default '0',
name varchar(255) default NULL,
options text,
type char(15) default NULL,
isMain char(1) default NULL,
isTblVisible char(1) default NULL,
position int(4) default NULL,
isSearchable char(1) NOT NULL default 'y',
isPublic char(1) NOT NULL default 'n',
isHidden char(1) NOT NULL default 'n',
isMandatory char(1) NOT NULL default 'n',
description text,
isMultilingual char(1) default 'n',
itemChoices text,
errorMsg text,
visibleBy text,
editableBy text,
descriptionIsParsed char(1) default 'n',
PRIMARY KEY (fieldId),
INDEX trackerId (trackerId),
) ENGINE=MyISAM AUTO_INCREMENT=1
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 ') ENGINE=MyISAM AUTO_INCREMENT=1' at line 23

#2008-11-05 rook1666
ALTER TABLE tiki_calendar_items ADD COLUMN allday tinyint(1) NOT NULL default '0'
Duplicate column name 'allday'
#2008-11-20 JohannesMoser
ALTER TABLE `tiki_polls` ADD `anonym` ENUM( 'a', 'u', 'i', 'c' ) NOT NULL DEFAULT 'u'
Duplicate column name 'anonym'
#2008-11-25 kerrnel22
ALTER TABLE tiki_tracker_fields CHANGE type type VARCHAR(15) default NULL
Table 'tikitrunk_svn.tiki_tracker_fields' doesn't exist
{CODE}

In Admin -> Login check both:
- Users can register:
- ... but need admin validation:

Admin validation isn't required, new users still can register and login immediately.

Topic says it:

- newly created user
- send message -> doesn't work, error message
- go to MyPreferences
- don't change anything
- just hit "Change Preferences"
- go send a message -> works

I don't know how anyone can use the Beta version - the links in ALL Wiki pages are wrong.

The correct link to a Wiki page "Cars" should be ..../tiki-index.php?Page=Cars

Instead ALL Wiki pages are wrong with the link ..../cars

Obviously no one is using Beta or this would have been fixed in 1 minute

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)

When I select "Admin > Wiki > Mandatory category in the category tree", the list of categories while editting a wiki page is blank, or it says no category is defined. However, if you click on "admin categories", they are defined indeed.

When you unselect this check box, and clean caches, categ. list is working fine again.

This is not a theme specific issue (reproduced with geo.css, tikineat.css, lesjetesdelencre.css, ...)

----
update: sylvieg fixed that months ago, I think. (thanks sylvie)