Loading...
 

Category: Installer (profiles, upgrades and server-related issues)

Installer (profiles, upgrades and server-related issues)
Show subcategories objects

Name Type
can't install tiki 4.0, whereas tiki 3.3 ok with no problem. what's missing at the server side?
I installed a tiki3.3 on a server ( pangea.org ) with no remarkable issues, and the tikis seem to work fine:
http://d-recerca.org


However, I attempted to install a spare tiki4.0 for testing on the same server, and I can't install it:
http://xavidp.pangea.org/tiki40/

I guess the server doesn't have pdo installed. I added the line in local.php to force tiki to use adodb instead (copied from tw.o forums, message from sylvie). With this change I can bo a bit further, but I cannot finish the installation proces. After the sql are run, I'm sent to the authentication page of tiki-install.php, instead of to the step of locking the installer and proceeding to tiki.

I went to the tiki-index.php then. and i could see it, and changed password for admin. But I can't login after that step neither with admin admin or with new admin pass..
tracker item
Parse error: syntax error, unexpected T_OBJECT_OPERATOR in tiki-index.php on line 225
This error was seen when using PHP4

Tiki should detect and provide better error message
tracker item
_htaccess should know which version of Tiki it is for
Good:

Since Tiki4, in tiki-admin_include_sefurl.php, Tiki detects if .htaccess is there and if contains tiki-index.php?page=$1

But:
If Tiki is upgraded, by installing over, there may be issues because Tiki is still using the old .htaccess without informing tiki admin


Proposal:
Have Tiki version number in _htaccess (and thus updated as part of the release procedure)
Test on this, and inform users when they forgot to upgrade their .htaccess file.




tracker item
.phar support is needed for Composer
tracker item
"Database `d01863d1` was created" shouldn't appear
tracker item
"Server Fitness" (tiki-check.php) Never Opens
tracker item
1.9.1 to 1.9.3.1 upgrade pb on tiki_score table
The install script says to run the 1.8to1.9 SQL upgrade when upgrading from a 1.9.x to another 1.9.x release.

I have and error in that script while creating the tiki_score table, which is normal because it already exists. Then, I have a bunch of errors in the following INSERT statements because the category column is missing (along ith the desription and ordd columns). Here is the output of the failed statements:

CREATE TABLE tiki_score (
event varchar(40) NOT NULL default '',
score int(11) NOT NULL default '0',
expiration int(11) NOT NULL default '0',
category text NOT NULL,
description text NOT NULL,
ord int(11) NOT NULL default '0',
PRIMARY KEY (event),
KEY ord (ord)
) TYPE=MyISAM
Message: Table 'tiki_score' already exists


Command: INSERT INTO tiki_score (event,score,expiration,category,description,ord) VALUES ('login',1,0,'General','Login',1)
Message: Unknown column 'category' in 'field list'

.... other similar failed INSERT


Here is the tiki_score table definition that is currently in my 1.9.1 database (extracted from a mysqldump):
CREATE TABLE tiki_score (
event varchar(40) NOT NULL default '',
score int(11) NOT NULL default '0',
expiration int(11) NOT NULL default '0',
PRIMARY KEY (event)
) TYPE=MyISAM;
tracker item
1.9to1.10 sql from cvs (August 1st 2007) still produces "too long key/column length" errors
Upgrading a previous 1.10 site with current cvs code (from August 1st, 2007) I get, while using
tiki_1.9to1.10.sql with -f param from command line:

^
(...)
ERROR 1071 at line 561: Specified key was too long. Max key length is 500
ERROR 1071 at line 585: Specified key was too long. Max key length is 500
(...)
ERROR 1074 at line 620: Too big column length for column 'value' (max = 255). Use BLOB instead
ERROR 1074 at line 627: Too big column length for column 'fieldname' (max = 255). Use BLOB instead
(...)
^

Plus some:
{CODE(wrap=>1)}
(...)
ERROR 1064 at line 497: 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 'user(100),serverId,groupName(100))' at line 1
ERROR 1064 at line 500: 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 'user(150),pageName(100))' at line 1
ERROR 1064 at line 506: 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 'user(100),id(100))' at line 1
ERROR 1064 at line 509: 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 'user(100),event,object(50))' at line 1
ERROR 1064 at line 513: 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 'user(120),friend(120))' at line 1
(...)
ERROR 1064 at line 597: 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 'user(120))' at line 1
(...)
ERROR 1064 at line 638: 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 `fieldId` FROM `tiki_webmail_contacts_fields` WHERE `fie
(...)
{CODE}

Sylvieg, if you review this, you can see it your own at ourproject.org server, uniwiki project, updating uniwiki2 database (the one for http://uniwiki.ourproject.org ).
tracker item
Update Notifier: many versions are misreporting available upgrades
tracker item
Tracker templates (import/export tracker definitions/structure)
If Trackers had the "tracker template" feature, it would allow for better pre-made extended features for Tiki at install time.
In tw.o forums, some people requested like: address books (imagine with the same basic fields as Mozilla Thunderbird & Evolution, etc. address books, ... Export from you local program (through csv), and import to your address book in Tiki (through csv).

The same for "Offers & Demands (linked or linkable)", that many people/communities would like to use like "out of the box" feature. I do have that kind of trackers made (basic, but working for production already: http://valldelcorb.org/trackers - http://valldelcorb.org/Comparteix (1.9.x) or http://intercanvis.net (1.10.x) using tracker plugins in a general Wiki page).

Since duplicate tracker is already coded in 1.10, and templates concept already exists in Tiki, Tracker templates would be a nice MUST in the MID and LONG run.

Tracker templates should be selectable at install time (in the new installer devs. are thinking/designing -> ((Install)) ), or at a later stage through Mods, maybe?

tracker item
12.0 fresh install: sh setup.sh tries and fails to install developer tools
tracker item
12.0 Step 7 of tiki-install.php : "Upgrade fix" is offered even on fresh install
tracker item
12.x - 15.x: Sheet profile Handler doesn't get sheet content added (following lastest available documentation)
tracker item
12.x: Fatal error: Unsupported operand types in lib/setup/prefs.php on line 406
tracker item
12.x: profile data defined for item link field do not get stored in local tiki where profile was applied
tracker item
13.1 and 14.0 installer keeps asking for validating my db credentials
tracker item
13.x next.tiki.org -> Database Version Problem
tracker item
13.x: applying a profile from Profiles Wizard doesn't send the user to the "Step2" indicated in the url (some steps anchors gone?)
tracker item
13.x: Default feature 'Contact us' (used in featured profiles) has broken display (too narrow fields and below right column)
tracker item
13.x: Profiles with "random header images" stopped working as expected compared to 12.x
tracker item
15.x Regression: Some Profiles (including featured) can't create some objects (wiki pages, tracker ids or fields, ...)
tracker item
15.x: Allow running console.php to apply profiles from behind a proxy (to run new R script to check errors when testing the application on all Profiles on several tiki branches)
tracker item
setup.sh does not work as documented on Debian
This script does not work with http servers that run under UNcommon user ID/GID. There is one good http server example in the Debian repos called yaws where the script becomes a problem. yaws runs under user ID/GID yaws/yaws. If one attempts to run setup.sh with a yaws http server, the script does not work.

1.Clicking on "Admin mods" after installation returns this error.
You need to run setup.sh :
./setup.sh $APACHEUSER all
Common Apache users are www-data, apache or nobody

2. Going to the command line and running setup.sh yaws all (because the username/gid is yaws, not the usual) returns no messages when in fact the script has already decided that the user will be www-data because I'm on Debian. About line 27 of the script. if [ -f /etc/debian_version]; ....

There's no message that says how the ownership has been changed after running the script. There's no message saying the user has been chosen for me because I'm on Debian either. In both cases, I'd still have problems because the userID/GID needs to be yaws/yaws in order to make tikiwiki work right.

Perhaps another way to address the problem is to check and see who owns the server process with an lsof -p :portNumber?
tracker item
18.x svn: Data too long for column 'log' at row 1
tracker item
Humphrey
Contributors
tracker item
jonnybradley
Contributors
tracker item
Quick Admin module no longer assigned by default (starting from Tiki 19)
tracker item
Installer fails when upgrading a 1.9 tiki
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


tracker item
tiki 2.0: db password should be hidden at typing time on upgrade through tiki-install.php
Using the released tiki 2.0: db password should be hidden at typing time on upgrade through tiki-install.php

Right now, password can be seen by others when the admin type it on the screen when first calling to tiki-install.php on an upgrade of running tiki site.
tracker item
tikiwiki only can install with default database
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.


tracker item
eddiem.com
Contributors
tracker item
omstefanov
Contributors
tracker item
Problem with new installation - v7 - cookies not enabled
I have been having problems upgrading from previous versions and decided to install a new blank install of v7. Everything works fine until I try and log in with the admin user name and password I created during the install process. I receive a message that cookies need to be enabled. This is not a message that I have had before on any prior versions and cookies are definitely enabled in my browser. I have tried with Chrome, FireFox and IE and the problem is the same on v7. I have seen various discussions on this topic in the forums but it seems there is no resolution for this one and no clear answer as to what is causing it. My URL's have no ~ in them.
tracker item
Windows install
Using the auto (or manual) installation procedures on a Windows server gives the error:

The directory 'd:\domain\www\tiki/img/wiki/' is not writeable by SYSTEM.

Since two of the slashes in the address are going in the wrong direction, I'm speculating that is the reason for the error.
tracker item
lacking instruction on manual install page
On the Manual database installation docs:
http://doc.tiki.org/Manual+Installation#Rename__htaccess_for_clean_URLs_optional_

Instruction 1.4 says
1.4. Rename _htaccess for clean URLs (optional)

You can rename _htaccess to .htaccess
-----

BUT in the files there is only htaccess.sh

SO, is this the same file as _htaccess?
Really want to change the name of htaccess.sh to .htaccess.sh?

Low priority since this is an Alternative. But it does prevent manual installations
from having clean URLs
tracker item
When upgrading old version of TikiWiki to 7.2, admin login no longer has admin permissions
Hello, former library employee now library volunteer who is helping a library update its tikiwiki 3.x intranet to 7.2 and encountered a strange bug that I am stuck on.

Upgrade seemed to go smooth, with a fresh directory install and pointed to the SQLi backend of the 3.x install in a test environment.

When I went to login with the known local admin account within tikiwiki, it allowed me to login but i could not access any of the admin modules without getting a lack of permissions error. Somehow the admin account is not associated with the admin group, although works fine in the 3.x live install.

Issue is compounded then that I cannot add admin to the admin group, because I cannot get access to the admin modules to do this!

I tried to do my own research on this, and actually did see some IRC logs where someone else had a very similiar issue although I did not see a resolution.

Any ideas how to fix this? Can someone give me some guidance into the tikiwiki sql structure whereby I might be able to change this within the table itself?
tracker item
403 Error on installaition
tracker item
404 Error instead of "Create Page" with unknown Wiki-page-name with IIS
~pp~
[19:57:51] <ReWoP> when i type tiki-index.php?page="some page name" there should be a error msg that would say "page does not exist, want to go back or grate page" now there is the browser error "The page cannot be found
[19:58:26] <sylvieg> did you type the url with the "
[19:58:37] <ReWoP> *(not "grate page" but "create page")
[19:58:42] <ReWoP> nop
[19:59:32] <ReWoP> i tryed to erase DB and re-intall tiki and nothing....
[20:00:14] <sylvieg> what url did it display at the error
[20:00:46] <ReWoP> u coul try it its online -> http://dme.uma.pt/jcardoso/Research/Projects/seed/tiki-index.php?page=fgbn
[20:02:35] <sylvieg> mdavey around?
[20:03:24] <sylvieg> I don't know why it is done like this but when there is an error the header sent is HTTP/1.0 404 Not FOund with the clssic tiki page
[20:03:49] <sylvieg> I suppose your browser catches the 404 and yop
[20:04:14] <sylvieg> better to ask mdavey ... I suppose it is himl that added that why this line is here
[20:04:40] <sylvieg> you can always try to delete the liens in tiki-index.php
[20:05:02] <ReWoP> could it be permitions on the folder ??
[20:05:26] <ReWoP> i gave the web server all perms...
[20:05:27] <sylvieg> I don't think so
[20:06:30] <ReWoP> ...
[20:06:37] <ReWoP> but i could be a server problem..
[20:07:15] <ReWoP> i tryed with polaris version and was woking
[20:07:47] <ReWoP> then i have a DB problem and re-intalled it and this error occured..
[20:08:05] <sylvieg> yes it is a conflict between server/ and tiki
[20:08:30] <ReWoP> now was trying it with -Sirius- version and not workig 2.
[20:08:50] <ReWoP> the server is nt2003 server
[20:09:38] <sylvieg> there is 2 lines I don't understrand in tiki-index.php (header("...404...") I am pretty sure there are the guilty ones
[20:09:48] <ReWoP> i thing that there is error only on this part, because i can create/edit modules, menus pages premitions...
[20:10:05] <ReWoP> mabe
[20:11:01] <ReWoP> but dosnt answer why worked on my 1st polaris version, and dind on my 2nd and on 1st Sirius.....
[20:11:14] <ReWoP> dont thing its code problem...
[20:11:38] <ReWoP> if it was mabe it wold be random error
[20:11:53] <ReWoP> after all it already worked once...
[20:11:59] <red_adair> nt2003 ? what's that ?
[20:12:20] <ReWoP> windows 2003 server :p
[20:12:21] <sylvieg> you can try to put into comment the 2 line header"... 404..) in tiki-index.php

Additional information:
[18:56:51] <ReWoP> i wanted to add that there is other tiki installed on the same server but it works !
~/pp~
tracker item
domain redirect from *.tikiwiki.org to *.tiki.org is not working
tracker item
A new pref: Canonical domain (overridable per perspective)
tracker item
Access denied for user 'tikiwiki'@'localhost' (using password: YES)
server: Apache 2.2.4
./configure --prefix=/usr/local/apache2 --enable-mods-shared=most

php 5.2.3
./configure --prefix=/usr/local/php --with-apxs2=/usr/local/apache2/bin/apxs --with-mysql=/usr/local/mysql --with-mysqli=/usr/local/mysql/bin/mysql_config --enable-force-cgi-redirect --with-zlib --with-expat-dir=/usr/local/expat

MySQL 5.0.45
./configure --prefix=/usr/local/mysql --localstatedir=/usr/local/mysql/data --disable-maintainer-mode --with-mysqld-user=mysql --enable-large-files-without-debug

in php writes that xml is enabled...
short tags are enabled too in php.ini

when i go to http://myhost/tikiwiki/tiki-install.php [version: 1.9.7]

it asks to make writeable dirs, so i make...

i get:{img src=http://doc.tikiwiki.org/img/wiki_up/tiki_installer.gif width= height= align= desc= link=http://doc.tikiwiki.org/img/wiki_up/tiki_installer.gif }

then it asks me to enter username and pass and db name of MySQL
i enter username and pass and db
and it shows me the same but with bonus message:

Access denied for user 'wiki'@'localhost' (using password: YES)

with the same username and pass i can connect over phpmyadmin...

ricks99
User was missing the db/local.php file. Without it, the installer could not contact the database.
-------------
what its source?

HELP!
tracker item
Add a grid / masonry display for the profiles in the Profiles Wizard with filters
tracker item
Add a more graceful error message for unmet dependencies
tracker item
Add json support check in tiki-check.php
tracker item
add language selection list on Installer page
When I start the installation of Tikiwiki, I wondered why it is only in English.

Later I read the documentation and know, I should use

http://your_host/tiki/tiki-install.php?lang=XX

instead of just enter

http://your_host/tiki/

to start the installer.

But, why make this trick so difficult to be known?
tracker item
Admin links gone....can't access admin
I upgraded from 1.85 to 1.9.0 without any problems. Things were working fine. Today, however, I logged in to access the admin area, and no admin links from the menu! All gone! What do I need to do to fix this? How can I access the admin area without links?
tracker item
admin user doesn't have permission to edit structures by default
After a clean install of r15460 w/ a new database, using the default enabled profile, i enabled structures via the wiki admin area.

Even though I was admin, I coulden't create / edit structures until I gave myself permission in the privileges settings.

The admin user should probably have most permissions by default, unless there is a particular reason to exclude a permission.

tracker item
admin user doesn't have permission to edit structures by default
After a clean install of r15460 w/ a new database, using the default enabled profile, i enabled structures via the wiki admin area.

Even though I was admin, I coulden't create / edit structures until I gave myself permission in the privileges settings.

The admin user should probably have most permissions by default, unless there is a particular reason to exclude a permission.

tracker item
Admins /mods failed
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
tracker item
after upgrade from 9.x to 12.x wiki pages with html code are reopened wrongly with wysiywg editor and no way to switch to normal through UI
tracker item
after upgrade with 32Mb at php.ini as suggested, still red box warns only 32Mb
I upgraded a site from 2.x to 3.0beta. I applied automatic update.
The server has 32Mb at php.ini for memory_limit, as reported by tiki-install.php. However, the red box warning:

^{DIV(bg=>red)} Tiki has detected your PHP memory limit at: 32 MB {DIV}^

is shown.
tracker item
Allow a user role or group to automatically generate a personal page, an image gallery, a weblog a
When I was testing various CMS/Wikis for a project, I ran across a module for another (Joomla or Drupal, can't remember which) CMS which allowed a user role or group to automatically generate a personal page, an image gallery, a weblog and any type of content page. It would be extremely useful for my project, but one of the few things missing from Tikiwiki (which is why I am implementing Tikiwiki, it has all of the other features I need in one install).
tracker item
Allow searching by categories and TAGS through the Profiles Control Panel in Tiki
tracker item
allow_comments or comments from a profile blog definition stopped working
tracker item
Announcements: There should be an easier way for ppl to stay up to date
Currently, an administrator of a Tikiwiki installation has to hunt for upgrades, updates, and security related information of his installation. It is often cumbersome and sometimes dangerous, think of the delay in fixing a crucial vulnerability, it has happened elsewhere before. It might also be nice to know that ppl are using current and feature complete software.
tracker item
Apache error with .htaccess files
When using the "_htaccess" files in Tikiwiki 1.9.5 you get an "Regex could not be compiled" access error in some of the directories when using Apache 2.2.
The Problem occurs, if the statement <FilesMatch "*"> is in the .htaccess file.
tracker item
Applying Profile thinks line with #foo selector in CSS code is a comment and omits it
tracker item
automatic rename of _htaccess to .htaccess by tiki-install.php causes issues
Perhaps this should be user choice?

So user can avoid this step if there is a problem.
tracker item
Automatic SVN commit of secdb and syncdb
This one should be run every time a php file is changed:
doc/devtools/tiki-create_md5.php

This should be automatic. Is there a way to this with SVN?
tracker item
Better protection against accidental site breakage with improper use of code in modules + template
One of the nice things about Tiki is that, once setup, all the configuration is done Web-based. No FTP access is necessary. However, it can happen that a Tiki admin breaks his site and locks him/herself out.

This can happen in Site Identity as well.

For example, if you use the following code
{CODE()}
{show_image.php?id=13}
{CODE}

in a module, you will get:

{CODE(wrap=>1)}
Fatal error: Smarty error: [in evaluated template line 1]: syntax error: unrecognized tag: show_image.php?id=13 (Smarty_Compiler.class.php, line 436) in lib/smarty/libs/Smarty.class.php on line 1088
{CODE}

and the site will be broken and you will be locked out of your Tiki site. (You need to go via phpmyadmin to delete the offending module)

I just added a warning to BRANCH-1-9 for modules but it would be much better that Tiki wouldn't break in this case.

More background info/ideas below
{CODE(wrap=>1)}
(01:17:27) marclaporte: I am wondering if there would be a way to avoid people locking themselves out of a Tiki site when putting invalid content in modules...
(01:22:27) chibaguy: One way of coping would be to include an admin_modules page (php and tpl files) that has no side columns, so people could input that URL admin their modules without the activated modules being displayed.
(01:23:28) chibaguy: Of course it would be more direct if the bad module just displayed without content when the content is bad, but is this possible?
(01:28:23) marclaporte: depends how bad I guess
(01:28:31) marclaporte: How about a test module page
(01:28:53) marclaporte: So you can test even before assigning
(01:29:18) chibaguy: Yes, if it opened in a new page, it wouldn't kill the main site.
(01:29:24) marclaporte: Some guy locked himself out using {show_image.php?id=13}
(01:29:42) marclaporte: It is very natural for the person to try this syntax
(01:31:27) marclaporte: instead he's locked out Fatal error: Smarty error: [in evaluated template line 1]: syntax error: unrecognized tag: show_image.php?id=13 (Smarty_Compiler.class.php, line 436) in lib/smarty/libs/Smarty.class.php on line 1088
(01:32:52) chibaguy: It does make sense to have a safe test zone for modules before they are assigned.
(01:33:17) chibaguy: Where failure doesn't lock up the site.
(01:33:38) chibaguy: Could that replace "preview"?
(01:33:52) chibaguy: Or "preview" be enhanced?
(01:37:17) marclaporte: where is preview?
(01:38:54) chibaguy: On Admin Modules page under "Assign new module" there's a "preview" button that displays the module in the center of the page.
(01:39:50) marclaporte: woah
(01:40:01) marclaporte: I never noticed that
(01:40:11) marclaporte: 4 years
(01:40:20) marclaporte: and I still discover stuff
(01:40:23) marclaporte: :-)
(01:40:33) chibaguy: Heh. Well, Tiki's got a lot of stuff.
(01:41:41) chibaguy: I'm not sure offhand how preview handles fatal error modules. With Opera, I just hit the back button and have the admin modules page again.
(01:41:56) marclaporte: I just tested
(01:42:03) marclaporte: it crashes
(01:42:11) chibaguy: Ouch
(01:42:31) chibaguy: What if preview previewed in another page or a popup?
(01:42:57) chibaguy: The user would still have control, I think.
(01:43:01) marclaporte: it crashes but just one page
(01:43:10) marclaporte: the site is still accessible
(01:43:17) chibaguy: OK.
(01:43:45) chibaguy: So users should be sure to preview first.
(01:44:29) chibaguy: Maybe Admin Modules needs some large warning messages.
(02:13:46) CIA-9: marclaporte BRANCH-1-9 * tiki/templates/tiki-admin_modules.tpl: Warning message about possibly breaking a Tiki site by improprer use of Smarty Syntax in modules
(02:13:48) marclaporte: incoming
{CODE}
---

Added on 2007-08-17:

Idea for modules:
Maybe tiki-admin_modules.php shouldn't show modules. So you could always get access to your Tiki to remove/fix modules. And it should offer a login box, when not logged in.

tiki-admin_modules.php could have some like (this doesn't work because modules are evaluated even in left & right columns are off, since a module could be in a wiki page):
{img src=images/code.png}%%% {CODE()}

$smarty->assign('feature_left_column', 'n');
$smarty->assign('feature_right_column', 'n');
{CODE}

But it is nice to see the result of what you are doing. We could have &showmodule=y in the URL (with a link next to assign module/left modules/right modules/etc

__Same thing when you use tiki-edit_templates.php__ ->

If I don't close an if, I get:
{img src=images/code.png}%%% {CODE()}
Fatal error: Smarty error: [in evaluated template line 1]: syntax error: unclosed tag {if} (opened line 1). (Smarty_Compiler.class.php, line 317) in lib/smarty/libs/Smarty.class.php on line 1095
{CODE}

Would there be a way that a Smarty error doesn't break Tiki completely? Here again, there could be a light version of tiki-edit_templates.php which has nothing which can break in a module. Maybe everything is hard-coded and it doesn't take any theme into account. And it shouldn't be possible to edit the tpl of tiki-edit_templates.tpl via tiki-edit_templates.php?template=tiki-edit_templates.tpl


__Maybe useful?__
Smarty validation class
http://www.phpriot.com/d/code/smarty/smarty-validator/index.html


Here is another very famous error: "Fatal error: Allowed memory size of 8388608 bytes exhausted"
http://tikiwiki.org/art82

And they often cause blank pages. How can we can catch them and render a simple & descriptive error page (not enough memory) instead of a blank page?


__Related:__
dynamic contents in userdefined modules crashes tiki
http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=851
tracker item
Broken images in featured profile and page is generally broken
tracker item
Broken link from the Tiki Installer
tracker item
BrowserTitle is empty after upgrading Tiki
tracker item
Browsertitle value wrong on Tik12 db update
tracker item
Bug Updating Imported DB on Upgrade
tracker item
buttons to enter tiki with or without locking it overlap
tracker item
Can not install on PostgreSQL
Hi,

I try to install Tikiwiki 3.1 on a PostgreSQL 8.3.5 database.
I create a local.php file and installer will find and connect the database.

After clicking on "continue" during the "Install profile" screen, the installer fails, printing the following message

Fatal error: Call to a member function fetchRow() on a non-object in /wiki/dev/3.1/appli/tikidev/installer/installlib.php on line 247


Looking at the shema database, there is only 5 tables
tiki_dynamic_variables
tiki_minichat
tiki_pages_changes
tiki_plugin_security
tiki_send_newletters_files


and 2 sequences

tiki_minichat_id_seq
tiki_sent_newletters_id_seq



Is there a fix ?


Regards,
Franck.
tracker item
Profile application via wizard or Suggested Profiles quietly fails on Tiki 17+
tracker item
Can't process through installer steps
tracker item
Change Admin Password Prompt Does Not Appear
tracker item
Change the release script to stop linking to ReleaseNotesXYZ (Use doc.tiki.org/TikiX instead)
tracker item
check_feature fields missing from tables when upgrading fom 2.1 to 5
When running the upgrade using tiki-install.php to upgrade from 2.1 to 5 33 database errors are reported. Several of these are "Unknown column 'feature_check' in 'field list'" errors.


During an upgrade, it is normal to have SQL failures resulting with Table already exists messages.

20091105_auth_tokens_tiki
-- 2009-11-05 lphuberdeau CREATE TABLE `tiki_auth_tokens` ( `tokenId` INT NOT NULL AUTO_INCREMENT, `creation` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `timeout` INT NOT NULL DEFAULT 0, `token` CHAR(32), `entry` VARCHAR(50), `parameters` VARCHAR(255), `groups` VARCHAR(255), PRIMARY KEY( `tokenId` ), KEY `tiki_auth_tokens_token` (`token`) ) Table 'tiki_auth_tokens' already exists

20091123_dns_permission_tiki
INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_dsn_query', 'Can execute arbitrary queries on a given DSN', 'admin', 'dsn', NULL, NULL) Unknown column 'feature_check' in 'field list'

20091124_fgal_backlink_tiki
CREATE TABLE `tiki_file_backlinks` ( `fileId` int(14) NOT NULL, `objectId` int(12) NOT NULL, KEY `objectId` (`objectId`), KEY `fileId` (`fileId`) ); Table 'tiki_file_backlinks' already exists

20091204_tiki_p_view_newsletter_tiki
INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_view_newsletter', 'Can view the archive of a newsletters', 'basic', 'newsletters', NULL, 'feature_newsletters') Unknown column 'feature_check' in 'field list'

20091214_perspective_management_tiki
INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_perspective_edit', 'Can edit the perspective', 'admin', 'perspective', NULL, 'feature_perspective') Unknown column 'feature_check' in 'field list' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_perspective_create', 'Can create a perspective', 'admin', 'perspective', NULL, 'feature_perspective') Unknown column 'feature_check' in 'field list' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_perspective_admin', 'Can admin perspectives', 'admin', 'perspective', 'y', 'feature_perspective') Unknown column 'feature_check' in 'field list'

20100107_payment_tiki
CREATE TABLE `tiki_payment_requests` ( `paymentRequestId` INT NOT NULL AUTO_INCREMENT, `amount` DECIMAL(7,2) NOT NULL, `amount_paid` DECIMAL(7,2) NOT NULL DEFAULT 0.0, `currency` CHAR(3) NOT NULL, `request_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, `due_date` TIMESTAMP NOT NULL, `cancel_date` TIMESTAMP NULL, `description` VARCHAR(100) NOT NULL, `actions` TEXT, PRIMARY KEY( `paymentRequestId` ) ) Table 'tiki_payment_requests' already exists CREATE TABLE `tiki_payment_received` ( `paymentReceivedId` INT NOT NULL AUTO_INCREMENT, `paymentRequestId` INT NOT NULL, `payment_date` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `amount` DECIMAL(7,2), `type` VARCHAR(15), `details` TEXT, PRIMARY KEY(`paymentReceivedId`), KEY `payment_request_ix` (`paymentRequestId`) ) Table 'tiki_payment_received' already exists INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_payment_admin', 'Can administer payments', 'admin', 'payment', 'y', 'payment_feature') Unknown column 'feature_check' in 'field list' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_payment_view', 'Can view payment requests and details', 'admin', 'payment', NULL, 'payment_feature') Unknown column 'feature_check' in 'field list' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_payment_manual', 'Can enter manual payments', 'admin', 'payment', NULL, 'payment_feature') Unknown column 'feature_check' in 'field list' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_payment_request', 'Can request a payment', 'admin', 'payment', NULL, 'payment_feature') Unknown column 'feature_check' in 'field list'

20100115_tiki_p_admin_modules_tiki
INSERT INTO users_permissions (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES ('tiki_p_admin_modules', 'User can Administer Modules', 'registered', 'tiki', NULL, NULL) Unknown column 'feature_check' in 'field list'

20100128_tiki_p_blog_view_ref_tiki
INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_blog_post_view_ref', 'Can view in module and feed the blog posts', 'basic', 'blogs', NULL, 'feature_blogs') Unknown column 'feature_check' in 'field list' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_blog_view_ref', 'Can view in module and feed the blog', 'basic', 'blogs', NULL, 'feature_blogs') Unknown column 'feature_check' in 'field list'

20100203_payment_detail_tiki
ALTER TABLE tiki_payment_requests ADD COLUMN detail TEXT Duplicate column name 'detail'

20100205_tiki_p_wiki_view_ref_tiki
INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_wiki_view_ref', 'Can view in module and feed the wiki pages reference', 'basic', 'wiki', NULL, 'feature_wiki') Unknown column 'feature_check' in 'field list'

20100211_rss_items_tiki
CREATE TABLE `tiki_rss_items` ( `rssItemId` INT NOT NULL AUTO_INCREMENT PRIMARY KEY, `rssId` INT NOT NULL, `guid` VARCHAR(255) NOT NULL, `url` VARCHAR(255) NOT NULL, `publication_date` INT UNSIGNED NOT NULL, `title` VARCHAR(255) NOT NULL, `author` VARCHAR(255), `description` TEXT, `content` TEXT, KEY `tiki_rss_items_rss` (`rssId`), UNIQUE `tiki_rss_items_item` (`rssId`, `guid`) ) Table 'tiki_rss_items' already exists ALTER TABLE `tiki_rss_modules` DROP COLUMN `content` Can't DROP 'content'; check that column/key exists ALTER TABLE `tiki_rss_modules` ADD COLUMN `sitetitle` VARCHAR(255) Duplicate column name 'sitetitle' ALTER TABLE `tiki_rss_modules` ADD COLUMN `siteurl` VARCHAR(255) Duplicate column name 'siteurl'

20100215_create_tiki_user_login_cookies_tiki
CREATE TABLE `tiki_user_login_cookies` ( `userId` INT NOT NULL, `secret` CHAR(64) NOT NULL, `expiration` TIMESTAMP NOT NULL, PRIMARY KEY (`userId`, `secret`) ) ENGINE=MyISAM AUTO_INCREMENT=1 Table 'tiki_user_login_cookies' already exists

20100215_rating_permissions_tiki
INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_rate_article', 'Can rate articles', 'basic', 'cms', NULL, 'feature_articles') Unknown column 'feature_check' in 'field list'

20100216_attributes_tiki
CREATE TABLE `tiki_object_attributes` ( `attributeId` INT PRIMARY KEY AUTO_INCREMENT, `type` varchar(50) NOT NULL, `itemId` varchar(255) NOT NULL, `attribute` varchar(25) NOT NULL, `value` varchar(100), UNIQUE `item_attribute_uq` ( `type`, `itemId`, `attribute` ), KEY `attribute_lookup_ix` (`attribute`, `value`) ) Table 'tiki_object_attributes' already exists

20100217_rating_config_tiki
CREATE TABLE `tiki_rating_configs` ( `ratingConfigId` INT PRIMARY KEY AUTO_INCREMENT, `name` VARCHAR(50) NOT NULL, `expiry` INT NOT NULL DEFAULT 3600, `formula` TEXT NOT NULL, `callbacks` TEXT ) Table 'tiki_rating_configs' already exists CREATE TABLE `tiki_rating_obtained` ( `ratingId` INT PRIMARY KEY AUTO_INCREMENT, `ratingConfigId` INT NOT NULL, `type` VARCHAR(50) NOT NULL, `object` INT NOT NULL, `expire` INT NOT NULL, `value` FLOAT NOT NULL, UNIQUE `tiki_obtained_rating_uq` (`type`, `object`, `ratingConfigId`) ) Table 'tiki_rating_obtained' already exists

20100218_auth_token_reuse_tiki
ALTER TABLE `tiki_auth_tokens` ADD COLUMN `hits` INT NOT NULL DEFAULT 1 AFTER `timeout` Duplicate column name 'hits'

20100224_object_relations_tiki
CREATE TABLE `tiki_object_relations` ( `relationId` INT PRIMARY KEY AUTO_INCREMENT, `relation` varchar(25) NOT NULL, `source_type` varchar(50) NOT NULL, `source_itemId` varchar(255) NOT NULL, `target_type` varchar(50) NOT NULL, `target_itemId` varchar(255) NOT NULL, KEY `relation_source_ix` (`source_type`, `source_itemId`), KEY `relation_target_ix` (`target_type`, `target_itemId`) ) Table 'tiki_object_relations' already exists

20100226_tracker_dump_perm_tiki
INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_tracker_dump', 'Can save a CSV backup of entire trackers', 'admin', 'trackers', NULL, 'feature_trackers') Unknown column 'feature_check' in 'field list'

20100419_bigbluebutton_tiki
INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_bigbluebutton_join', 'Can join a meeting', 'basic', 'bigbluebutton', NULL, 'bigbluebutton_feature') Unknown column 'feature_check' in 'field list' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_bigbluebutton_moderate', 'Can moderate a meeting', 'admin', 'bigbluebutton', NULL, 'bigbluebutton_feature') Unknown column 'feature_check' in 'field list' INSERT INTO `users_permissions` (`permName`, `permDesc`, `level`, `type`, `admin`, `feature_check`) VALUES('tiki_p_bigbluebutton_create', 'Can create a meeting', 'admin', 'bigbluebutton', NULL, 'bigbluebutton_feature') Unknown column 'feature_check' in 'field list'

If you think that the errors of a patch can be ignored, please check the checkbox associated to it before clicking on continue.
tracker item
clean install based on trunk shows 2 SQL errors
Clean install on a new (multitki) site based on trunk from today (Jan. 24th, 2009) shows 2 SQL errors:

{CODE()}
SELECT patch_name FROM tiki_schema
Table 'tikitrunk_etcs.tiki_schema' doesn't exist
#2008-11-20 JohannesMoser
ALTER TABLE `tiki_polls` ADD `anonym` ENUM( 'a', 'u', 'i', 'c' ) NOT NULL DEFAULT 'u'
Duplicate column name 'anonym'
{CODE}

tracker item
cnd
Contributors
tracker item
Company Profile 4.x installation causes duplicate entries.
Application of the Company_Intranet_4x after a new installation with the Barebones install, installs 2 profiles.
***Company_Intranet
***Company_Intranet_4x

The installation of both profiles completes successfully however it results in some duplicate content that is automatically created by the profile. (I.E. there are two "Support" Forums)


I have tested and confirmed this from revision number 22637-24054.
tracker item
Composer; warning when installing Tiki from git master
tracker item
composer.lock; automate the updates for each branch, from latest composer.json
tracker item
Connect & Redactor: use a pref attribute instead of maintaining lists of prefs
tracker item
Crash 7.x on leaving install update mode : index error in a
At the end of install in

URL:
http://<domain>/tiki-install.php?nolockenter&install_type=update

The crash ends with :
(xdebug track begins)

Zend_Session_Exception: session has already been started by session.auto-start or session_start() - on a try catch no problem
Notice: Undefined index: min_pass_length in D:\Trebly\teawik-ld8-7xSa\lib\tikilib.php on line 1612
Notice: Undefined index: pass_chr_special in D:\Trebly\teawik-ld8-7xSa\lib\tikilib.php on line 1614

(xdebug track ends).

Track file joined

Trebly

~~#390:''Remark out of subject :''~~
Into my notes and refs dates are often in not common format yymmdd with B1=2011 date=B10117 is 01/17/2011, B2 is 2012. I used this for the last twenty years, has been used to make able soft to hold 2000 years and sort date (kept stored on six chars with historical data compatibility)in yymmdd yy=98,99,A0,A1..... B0, B1,B2. Used to make able at the end of eighties an important soft to hold long term plans. I use it since this moment and this goes on naturally and can't changed on my computers and data and can be used till year 2370.
tracker item
Create a profile for an improved Issue Tracker (with linked trackers) using the latest improvements in 14x
tracker item
Cron option for when it's not possible to have a real cron job (like Poormanscron)
tracker item
Custom javascript: a future-proof way to handle
Tiki has a lot of features. But sometime, we have to hack it up with various things that we can't share back to the project.

So we want to modify Tiki, yet, keep upgrades easy.

It is already possible to add custom language strings.
It is possible to override Smarty .tpl files with our own
It will soon be possible to add custom CSS strings


It would be nice to have this for javascript as well.

A custom.js somewhere. If it can be kept in the database, it makes site migration and backup even easier

Or it could be in styles/*/custom.js


It would be nice to have the option of putting towards the top or towards the bottom. Maybe Site Identity custom areas already permit this?
tracker item
database error in image galery after migration from 2.3 to 4.1
After migration from 2.3 to 4.1 the following error occurs, if i try to open the image galerys with the link http://www.kfs-hg-test.de/tiki-galleries.php?filter=topgal:

select `sortorder`,`sortdirection` from `tiki_galleries` where `galleryId`='9'

The single pictures are available in the wiki oages as befiorder, but it is not possible to list the galerys.

tracker item
database mysql 3.23.58 install problems
10 MySQL "create table" commands are not compatible w/ the 3.23.58 version of MySQL

The last 2 use tables use ENGINE=MyISAM instead of TYPE=MyISAM and have a VARCHAR field of size 256 (255 is ok to use)

Here are those queries
Command: CREATE TABLE tiki_modules (
moduleId int(8) NOT NULL auto_increment,
name varchar(200) NOT NULL default '',
position char(1) default NULL,
ord int(4) default NULL,
type char(1) default NULL,
title varchar(255) default NULL,
cache_time int(14) default NULL,
rows int(4) default NULL,
params varchar(255) default NULL,
groups text,
PRIMARY KEY (name, position, ord),
KEY positionType (position, type),
KEY moduleId (moduleId)
) TYPE=MyISAM
Message: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead

Command: CREATE TABLE tiki_page_drafts (
user varchar(200) default '',
pageName varchar(255) NOT NULL,
data mediumtext,
description varchar(200) default NULL,
comment varchar(200) default NULL,
lastModif int(14) default NULL,
PRIMARY KEY (pageName(120), `user`(120))
) TYPE=MyISAM
Message: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead

Command: CREATE TABLE tiki_tracker_item_fields (
itemId int(12) NOT NULL default '0',
fieldId int(12) NOT NULL default '0',
lang char(16) default NULL,
value text,
PRIMARY KEY (itemId,fieldId,lang),
FULLTEXT KEY ft (value)
) TYPE=MyISAM
Message: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead

Command: CREATE TABLE tiki_user_assigned_modules (
name varchar(200) NOT NULL default '',
position char(1) default NULL,
ord int(4) default NULL,
type char(1) default NULL,
user varchar(200) NOT NULL default '',
PRIMARY KEY (name(30),user,position)
) TYPE=MyISAM
Message: All parts of a PRIMARY KEY must be NOT NULL; If you need NULL in a key, use UNIQUE instead

Command: CREATE TABLE `tiki_webmail_contacts_ext` (
`contactId` int(11) NOT NULL,
`fieldId` int(10) unsigned NOT NULL,
`value` varchar(256) NOT NULL,
`hidden` tinyint(1) NOT NULL,
KEY `contactId` (`contactId`)
) ENGINE=MyISAM
Message: Too big column length for column 'value' (max = 255). Use BLOB instead

Command: CREATE TABLE `tiki_webmail_contacts_fields` (
`fieldId` int(10) unsigned NOT NULL auto_increment,
`user` VARCHAR( 200 ) NOT NULL ,
`fieldname` VARCHAR( 256 ) NOT NULL ,
`order` int(2) NOT NULL default '0',
`show` char(1) NOT NULL default 'n',
PRIMARY KEY ( `fieldId` ),
INDEX ( `user` )
) ENGINE = MyISAM
Message: Too big column length for column 'fieldname' (max = 255). Use BLOB instead
tracker item
Database update; Updating a 21.5 database to 21.8 failed with errors
tracker item
DB error with new 1.10 install or upgrade over 1.9.9
I was running 1.9.9 on a SLES 10 linux box, and we are running MySQL on Novell Netware, MySQL version 4.0.26a.

I tried an upgrade directly over the top of 1.9.9, and I got that error. So, I tried a Clean install on a new database, and I got the same error.

As a troubleshooting step, I tried creating a blank database with the name that it specifies, but then it just gives the following error message
"Unknown column 'bits.translation_bit_id' in 'field list'".

I suspect the installer script isn't creating this table and fields properly.

This error occurs anytime any Page is clicked on, including the main index page. It is a major roadblock to basic functionality.
tracker item
db/tiki.sql has typo on line 1, bad comment formatting
Operations failed: 1 SQL queries. Display details.

During an upgrade, it is normal to have SQL failures resulting with Table already exists messages.

tiki
- --------------------------------------------------------
-- Database : Tiki
-- --------------------------------------------------------

DROP TABLE IF EXISTS `messu_messages`
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 '- --------------------------------------------------------
-- Database : Tiki
-' at line 1
tracker item
DefaultSettingsChanges in 1.10
We need to decide about ((tw:DefaultSettingsChanges)) in 1.10

Some of the new features are much better than previous ones (ex new diff engine). People upgrading their Tiki could conserve their setting. However, new installs should take advantage of the new features.

A note should be added in tiki-install.php This must be low maintenance for Tiki dev team.
tracker item
demo.tiki.org sites should reset every x days
tracker item
Detect BOM in a Tiki health check and in release process
tracker item
Directories missing in 2.0 installer
The directory "templates_c" is no longer contained in the installer zip file in versions 2.0 or 2.1. An error occurs when trying to run tiki-installer.php indicating that directory does not exist.

The installer also omits the directories "maps" and "mods" but it is unclear whether these directories are still required in this version (taken from the documentation on settingg directory permissions)
tracker item
Double check that User Tracker Profile works as expected also in 15.x
tracker item
During Installation Progress Bar runs runs twice
tracker item
End of Installation Pressing Continue to Site Produces "Tiki is not properly set up:" message
Hi,

I installed Tiki v4.2 on a Windows host. The installation appeared to go cleanly to the end with no issues. I selected the first continue button to website locking the installer and received an error message.

I am replacing the real folders with abbreviated ones for security and readability sake.

-------
Tiki is not properly set up:

The directory 'e:\a\b\c\d\e/dump/' does not exist.
The directory 'e:\a\b\c\d\e/img/wiki/' does not exist.
The directory 'e:\a\b\c\d\e/img/wiki_up/' does not exist.
The directory 'e:\a\b\c\d\e/modules/cache/' does not exist.
The directory 'e:\a\b\c\d\e/temp/' does not exist.
The directory 'e:\a\b\c\d\e/templates_c/' does not exist.
-------

My comment is of course the above will produce an error. TikiWiki should have never, even on its own made e:\a\b\c\d\e as a base of the site/tiki folder. The base should be:

e:\a\b\c\d\e\Wiki\tiki

The subdomain / domain points to:

e:\a\b\c\d\e\Wiki

I installed tiki naturally into a /tiki sub-folder. I ran the installer as

http://<mysubdomain>/tiki/tiki-installer.php (or whatever the file name is)

Going manually to the index page produces the same error screen.

How do I fix the bug?

Thanks in advance.
tracker item
Error 500 on https://dev.tiki.org/tiki-admin.php?page=packages
tracker item
Error in upgrade script (function upgrade_20120429_fix_collation_tiki)
tracker item
Error installing into UTF-8 MySQL database
When installing TikiWiki 3.0 into MySQL (I'm using 5.1.35 but I don't think it matters much) where the database has been created with a charset of 'utf-8' (typically because this is the server default), one table cannot be created and that command and subsequent inserts fail:

{CODE()}
CREATE TABLE `tiki_sefurl_regex_out` (
`id` int(11) NOT NULL auto_increment,
`left` varchar(256) NOT NULL,
`right` varchar(256) NULL default NULL,
`type` varchar(32) NULL default NULL,
`silent` char(1) NULL default 'n',
`feature` varchar(256) NULL default NULL,
`comment` varchar(256),
`order` int(11) NULL default 0,
PRIMARY KEY(`id`),
UNIQUE KEY `left` (`left`(256)),
INDEX `idx1` (silent, type, feature(30))
)
y was too long; max key length is 767 bytes
{CODE}

The issue is that the table key is too long when using UTF-8. See [http://bugs.mysql.com/bug.php?id=4541].
tracker item
Error just after profile is applied: Cache file temp/cache/modulexxx is not writable
tracker item
Error with composer switching branch from 16x to 17x
tracker item
(A blocker if confirmed) errors in trunk database upgrade through console.php keys too long and invalid default value
tracker item
Errors testing mail during install
If an address is specified to send the test mail to in step 3 of the installer, an error is displayed when attempting to send the test email:

Fatal error: Call to undefined function iconv_get_encoding() in /srv/http/projectwiki/lib/core/Zend/Validate/Hostname.php on line 535

If an address is provided, and the CC box is unchecked, the following error also appears:

Notice: Undefined index: email_test_cc in /srv/http/projectwiki/installer/tiki-installer.php on line 837

If the user does not provide an email address and attempts to send the test email, the mail is reported as sent (or displays a user friendly error message.)

I'm using PHP 5.3 and Archlinux, and starting a clean install of 7-beta-1. I haven't gotten far enough into the process to see if other emails can be sent.
tracker item
failed to set proper "include_path" in tw 1.9.8.x
Hello

I had a lot of warning when i upgraded to tw 1.9.8.1 this morning.
It talked about include_once() problem and include_path.

Many things to say about:
php in safe_mode (deprecated) cannot modify ini value !
ini value set in apache conf with php_admin_value cannot be modified !

all scripts using "TikiInit::prependIncludePath()" have to check the return value of the method because init_set and set_include_path can return FALSE.
In this case, an error message should be printed to the user, and/or logged.

Here is a list of files using this method.
- db/tiki-db.php
- tiki-install.php
- tiki-setup.php

tracker item
Fatal error trying to upgrade to Tiki 18 ("Call to a member function urldecode() on null")
tracker item
Fatal error Uncaught TypeError in_array Argument #2 $haystack must be of type array, bool given in binderlib.php 49
tracker item
Fatal error on Tiki 15 to 19 upgrade
tracker item
Fatal error rendering template file when missing Intl extension
tracker item
FATAL ERROR while upgrading
tracker item
Fatal error: Call to undefined method TikiDb_Pdo::setAttribute() in lib/tikisession-pdo.php on line 18
This happens in Tiki4 when using session_storage in the database (which was not the default) when using PDO (which is now the default in Tiki4)
tracker item
Fatal error: Cannot redeclare class Zend_Filter_Interface in /usr/lib/php/Zend/Filter/Interface.php
I had TikiWiki v2.2 installed and running fine on my website.

I used cpanel + Fantastico to automatically upgrade from v2.0 to v3.0. I followed the Fantastico on-screen instructions and when the update had finished I clicked on the "View site" link and got the following error:
Fatal error: Cannot redeclare class Zend_Filter_Interface in /usr/lib/php/Zend/Filter/Interface.php on line 30

I tried to do a brand new install of TikiWiki on another website that has never had a previous version of TikiWiki on it using cpanel + Fantastico. I followed the on-screen instructions and when I clicked on the "View site" link I got the same fatal error message.

I then installed TikiWiki v3.0 on my Ubuntu v8.04 desktop localhost Apache2 server and it works fine.

Then I installed TikiWiki v3.0 on my Windows Vista Ultimate laptop localhost Apache2 server and it works fine.

Two local installations of TikiWiki v3.0 work fine. The two attempts at using cpanel + Fantastico on remote servers both yield the same fatal error. One website had a previously installed version of TikiWiki (v2.2). The other website had never had TikiWiki installed.

tracker item
Fatal error: Uncaught Error: Call to a member function handleError() on null in
tracker item
Fatal error: Uncaught TypeError: count(): Argument #1 ($value) must be of type Countable|array, null given in
tracker item
fckeditor missing while updating previous 1.10tw
I have cvs update a previous tw1.10 the folder fckeditor is missing from the lib.
tracker item
Featured profiles missing for 13.x
tracker item
File galleries broken after 4.3 to 5.x upgrade
Yesterday I upgraded from 4.3 to 5.2, and everytying seemed to go ok (all upgrade operations were executed successfully). However, every time I try to edit or create a file gallery I get the same error message, which seems to be related to a missing field (show_lastDownload) in the tiki_file_galleries table.

I copy below one of such errors. Please, note that, according to the community forums [http://tikiwiki.org/tiki-view_forum_thread.php?comments_parentId=38578&topics_offset=2&topics_sort_mode=lastPost_desc&forumId=6|this issue was already reported for a 4.3 to 5.1 upgrade].

I think that a) somebody should check the upgrade for a possible bug, and if possible b) find a way to solve this issue for sites running tiki 5.x with this feature broken.

---

The following error message was returned:

Unknown column 'show_lastDownload' in 'field list'

The query was:
insert into `tiki_file_galleries`(`name`, `description`, `created`, `user`, `lastModif`, `maxRows`, `public`, `hits`, `visible`, `show_id`, `show_icon`, `show_name`, `show_description`, `show_created`, `show_hits`, `show_lastDownload`, `max_desc`, `type`, `parentId`, `lockable`, `show_lockedby`, `archives`, `sort_mode`, `show_modified`, `show_creator`, `show_author`, `subgal_conf`, `show_last_user`, `show_comment`, `show_files`, `show_explorer`, `show_path`, `show_slideshow`, `default_view`, `quota`, `image_max_size_x`, `image_max_size_y`, `backlinkPerms`, `show_backlinks`) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

Values:

1. mytestfilegallery
2.
3. 1285469672
4. jme
5. 1285469672
6. 25
7. n
8. 0
9. y
10. o
11. y
12. f
13. n
14. y
15. y
16. n
17. 1024
18. default
19. 19
20. n
21. n
22. -1
23.
24. y
25. o
26. o
27.
28. o
29. o
30. y
31. y
32. y
33.
34. list
35. 0
36. 0
37. 0
38. n
39. n

The built query was likely:
insert into `tiki_file_galleries`(`name`, `description`, `created`, `user`, `lastModif`, `maxRows`, `public`, `hits`, `visible`, `show_id`, `show_icon`, `show_name`, `show_description`, `show_created`, `show_hits`, `show_lastDownload`, `max_desc`, `type`, `parentId`, `lockable`, `show_lockedby`, `archives`, `sort_mode`, `show_modified`, `show_creator`, `show_author`, `subgal_conf`, `show_last_user`, `show_comment`, `show_files`, `show_explorer`, `show_path`, `show_slideshow`, `default_view`, `quota`, `image_max_size_x`, `image_max_size_y`, `backlinkPerms`, `show_backlinks`) values ('mytestfilegallery','','1285469672','jme','1285469672','25','n','0','y','o','y','f','n','y','y','n','1024','default','19','n','n','-1',NULL,'y','o','o',NULL,'o','o','y','y','y',NULL,'list','0','0','0','n','n')
tracker item
File names should not have tiki
tracker item
First install from svn fails silently on composer
tracker item
first login after new install fails after install in subdirectory (tiki-change_password.php not foun
Unverified bug . New install of 1.9.10.1 in subdirectory, e.g. http://my.domain.com/subdir

After typing in admin/admin to login for the first time, I was redirected to http://my.domain.com/tiki-change_password.php instead of the expected http://my.domain.com/subdir/tiki-change_password.php.
tracker item
fixperms.sh fix doesn't secure the linux server from allowing tikiadmins from installing Tiki Mods
After running "./fixperms.sh fix" on the server side (Debian based, having root perms on server), and using 1.10svn code from mid May 2008, admins of the tiki site can still install mods on the server through the Tiki admini mods interface.
It used to work before (months ago, when I last used that).
our server, afaik, has www-data and www-data as user and group.
We are using a multitiki installation, with tikis under subdirectories.

I'm afraid that admins of the other tikis from the same multitiki are able to remove mods that we are using and need, etc.
...
tracker item
Forum migration script
Does anyone know of a migration script / strategy for moving tiki forums
from one Tiki to another?

I want to move this Galaxia forum:
http://tikiwiki.org/tiki-view_forum.php?forumId=11
to:
http://workflow.tikiwiki.org/

The themes forum
http://tikiwiki.org/tiki-view_forum.php?forumId=14
to:
http://themes.tikiwiki.org/

And the Multilingual/i18n <tiki-view_forum.php?forumId=13> forum:
http://tikiwiki.org/tiki-view_forum.php?forumId=13
http://tikiwiki.org/tiki-view_forum.php?forumId=10
http://tikiwiki.org/tiki-view_forum.php?forumId=15
http://tikiwiki.org/tiki-view_forum.php?forumId=7
http://tikiwiki.org/tiki-view_forum.php?forumId=8
http://tikiwiki.org/tiki-view_forum.php?forumId=9
http://tikiwiki.org/tiki-view_forum.php?forumId=16
to an eventual i18n.tikiwiki.org
tracker item
galleryId property no longer set in list_galleries after 1.9.7 upgrade
Use this URL: http://www.flylac.org/tiki-galleries.php

Then hover the mouse over any of the galleries, the galleryId property is not set, this is an example shortcut:

http://www.flylac.org/tiki-browse_gallery.php?galleryId=

The galleryId is missing: ...browse_gallery.php?galleryId=

tracker item
Get nextthemes.tiki.org working (PHP 5.5 is required)
tracker item
Getting Things Done (GTD) profile
"__Getting Things Done__ (commonly abbreviated as __GTD__) is an action management method of the __David Allen Company__, and the title of the book by __David Allen__ that describes the method. Both __Getting Things Done__ and __GTD__ are registered trademarks of the David Allen Company.

__GTD__ rests on the principle that a person needs to ''move'' tasks out of the mind by ''recording'' them somewhere. That way, the mind is ''freed'' from the job of ''remembering'' everything that needs to be done, and can ''concentrate'' on actually '' performing'' those tasks. What distinguishes GTD from other time- or action-management systems is the idea of __''grouping tasks'' by the context__ (defined as a place or set of available resources) in which they are to be __performed__."

http://en.wikipedia.org/wiki/Getting_Things_Done


TikiWiki can be configured for this.

http://www.priacta.com/Articles/Comparison_of_GTD_Software.php
tracker item
Help hman set up automatic clone and upgrade via Tiki Manager
tracker item
Installation; HomePage not found error after new installation
tracker item
htaccess.sh is gone from Tiki26 and after the installation you may need to create the symlink manually
tracker item
http_build_query
In some PHP version, http_build_query would not work correctly and would not show correctly URL parameters for admin and edit options (in converting the templates from SMARTY).

Make sure that http_build_query function from php is working correctly as some version work only with 2 parameters (even it is said to be Php 5.1.1) and others 3 parameters.

See this issue reported in:

http://tikiwiki.org/tiki-view_forum_thread.php?topics_offset=1&forumId=6&comments_parentId=37095
tracker item
Icon missing for Plugin File (or to upload a file) in default and upgraded toolbars
tracker item
In htaccess, IfModule deflate_module is not picking up for ClearOS
tracker item
Incorrect base path detected when installing on IIS (Directory does not exist errors)
When running the installer on IIS the incorrect root path is detected. The directory tikiwiki is installed into is being stripped from the directory hierarchy.

The problem including the solution is referenced in the forum thread at http://tikiwiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=26943&highlight=directory%20does%20not%20exist
tracker item
Incorrect URLs on IIS installs in document root
This bug is tied to [http://example.com|http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=1964&trackerId=5&show=view]

I have had various issues navigating my wiki seemingly because $base_url is not getting built correctly, or at all. The first of these issues happens at login where the user puts in a bad username or password. The redirect to the error page fails on Firefox and has a URL with doubled forward slashes after the domain because the $base_url is not getting passed. URLs get built as follows (where 'example.com' is my domain):

Firefox:
{img src=images/code.png}%%% {CODE()} http://example.com\/tiki-error.php?error=Invalid+username {CODE}

IE:
{img src=images/code.png}%%% {CODE()} http://example.com//tiki-error.php?error=Invalid+username {CODE}

This happens with relative URLs all over tikiwiki in my installation, which is a WAMP with virtualHost entries in the httpd.conf to resolve 2 distict domains on the same server.
tracker item
Increase size of article title from 80 to 255 char
subtitles and topline have 255 characters so why is title limited?
tracker item
Indexing failed while processing "Update" (type wiki page) with the error "RemoteTransportException[
tracker item
Install fails on step 5 on Dreamhost shared hosting
tracker item
Install script should detect previous install (install instead of upgrade will wipe your database)
{img src=images/code.png}%%% {CODE(wrap=>1)}
(7:48:16 PM) marclaport1: polom
(7:48:21 PM) ***marclaport1 has an idea
(7:48:31 PM) marclaport1: to make tiki easier to install
(7:48:34 PM) marclaport1: and safer
(7:50:54 PM) marclaport1: say I point to tiki-install.php
(7:51:07 PM) marclaport1: on a tiki which is already in existence
(7:51:27 PM) marclaport1: i get a choice of clean install (tiki.sql) with various profiles
(7:51:59 PM) marclaport1: or to upgrade (1.8.x_to_1.9.x.sql)
(7:52:20 PM) marclaport1: why offer a clean install unless db is empty?
(7:53:33 PM) marclaport1: so if tiki-install.php can only can the upgrade sql (which is designed to be run over & over again) tiki becomes safer
(7:54:55 PM) marclaport1: if the database exists, there should be a note the admin to use phpmyadmin to go and empty the database of create a new one for tiki
(8:00:29 PM) ***marclaport1 feels that must be something wrong with this idea, or else all the smart people in tiki would have though about it.
(8:03:38 PM) ***marclaport1 has the impression that most tiki devs don't use the web installer
(8:04:21 PM) marclaport1: ...
{CODE}

{THUMB(image=>img/wiki_up/Smarter_Tiki_install.jpg,)/}
tracker item
installation bug
tracker item
Installation error - cannot create database "tiki_profile_symbols"
Sorry if I'm either reporting this in the wrong place, or reporting a known issue. I've looked around a bit but couldn't find my problem listed. I have two TW installations that have run fine for 2 years, and I just downloaded the latest version of TW for a new application.

Created a MySQL 4 database.
Ran the automatic installation routine.

Got told there were 1000+ OK SQL statements, and 1 that failed.

When I click on "details" I get:

Command: CREATE TABLE tiki_profile_symbols (
`domain` VARCHAR(50) NOT NULL,
`profile` VARCHAR(50) NOT NULL,
`object` VARCHAR(50) NOT NULL,
`type` VARCHAR(20) NOT NULL,
`value` VARCHAR(50) NOT NULL,
`named` ENUM('y','n') NOT NULL,
`creation_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY( `domain`, `profile`, `object` ),
INDEX(`named`)
)
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 'CURRENT_TIMESTAMP,
PRIMARY KEY( `domain`, `profile`, `object`

I did this a second time to make sure (brand new directory on the server, and brand new SQL database). I cannot access the Admin-Modules segment in my new TW installation; I get the following error. Everything else appears to work -- new setup is at http://dev.steadfastlutherans.org .. second setup is at http://dev.steadfastlutherans.com .. I can give anyone admin access if you need it.

Pretty standard linux install, using 1and1.com servers.

Any help appreciated!




An error occured in a database query!

Context:
File tiki-admin_modules.php
Url tiki-admin_modules.php
Query:
SELECT `tc`.*, tpcd.`data`, COALESCE(`tpcf`.`future`,0) AS `future`, COALESCE(`tpca`.`actual`,?) AS `actual`, COALESCE(`tpcn`.`next`,?) AS `next`, GREATEST(0, COALESCE(`tpco`.`old`,0) - 1) AS `old` FROM (`tiki_content` AS `tc` LEFT JOIN ( SELECT `contentId`, count(*) AS `future` FROM `tiki_programmed_content` WHERE `publishDate`>? GROUP BY contentId ) AS `tpcf` ON ( `tc`.`contentId` = `tpcf`.`contentId` ) LEFT JOIN ( SELECT `contentId`, max(`publishDate`) AS `actual` FROM `tiki_programmed_content` WHERE `publishDate`<=? GROUP BY contentId ) AS `tpca` ON ( `tc`.`contentId` = `tpca`.`contentId` ) LEFT JOIN ( SELECT `contentId`, min(`publishDate`) AS `next` FROM `tiki_programmed_content` WHERE `publishDate`>=? GROUP BY contentId ) AS `tpcn` ON ( `tc`.`contentId` = `tpcn`.`contentId` ) LEFT JOIN ( SELECT `contentId`, count(*) AS `old` FROM `tiki_programmed_content` WHERE `publishDate`<? GROUP BY contentId ) AS `tpco` ON ( `tc`.`contentId` = `tpco`.`contentId` ) LEFT JOIN ( SELECT `contentId`, `data`, `publishDate` FROM `tiki_programmed_content` ) AS `tpcd` ON ( `tc`.`contentId` = `tpcd`.`contentId` AND `tpcd`.`publishDate` = `tpca`.`actual` )) ORDER BY `contentId` desc
Values:
0 1229233709
1 1229233709
2 1229233709
3 1229233709
4 1229233709
5 1229233709
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_
tracker item
installation issues with v2.0 and MSSQL backend
I am having an issue with installing v2.0 on IIS with MSSQL backend.

After entering all of the info such as database server, name, and login info, it returns the following error:

PHP Fatal error: Call to a member function fetchRow() on a non-object in C:\inetpub\wwwroot\tikiwiki\installer\tiki-installer.php on line 43

This appears to be the MSSQL version of bug ID 1653.
tracker item
Installation on PostgreSQL: syntax error creating 'tiki_categorized_objects'
Installation error during table creates:

Command: CREATE TABLE "tiki_categorized_objects" (
"catObjectId" bigserial,
"type" varchar(50) default NULL,
"objId" varchar(255) default NULL,
"description" text,
"created" bigint default NULL,
"name" varchar(200) default NULL,
"href" varchar(200) default NULL,
"hits" integer default NULL,
PRIMARY KEY ("catObjectId"),
KEY(type, objId)
)
Message: ERROR: syntax error at or near "("
LINE 11: KEY(type, objId)
tracker item
Installation process of Tiki from git doesn't complete anymore and end with Fatal error
tracker item
Installation script problem
There is a small bug in install.php that makes installation screen completely white when user submits to second step.
The problem originates from difference between dbTiki and dbtiki, where in line 586 the database connection is made in dbtiki, but some where else the dbTiki is used.
tracker item
Installation script, Database update; Error when updating the database (from the install script)
tracker item
Installation script; locking the Tiki installer is now taking a lot of time
tracker item
Installation script; The process locked itself and using a different browser with incognito window is required
tracker item
Installation script; User interface could be improved for better user experience and readability
tracker item
Installation step 'Configure General Settings' looses i18n language choice
tracker item
Installation to Document Root Issues
The installation documentation (I referred to all pages linked from the main page plus several postgresql-specific ones) do not give any indication that TikiWiki is only usable if installed in document root (aka TikiWiki is greedy/must run the whole domain). This should be specified as a installation requirement.

A better solution (IMHO) would be to fix the coding (e.g. replace absolute paths by relative ones) so that TikiWiki would place nice if installed in a subdirectory.
tracker item
Installation with SQLite
With the choice of SQLite database

When installing
Fatal error: Call to a member function fetchRow() on a non-object in P:\xampp\htdocs\tiki10\installer\tiki-installer.php on line 50

When get tiki-index.php after installation
Unable to connect to the database !
SQL logic error or missing database
tracker item
Installation, Composer: Removing abandoned packages and folder than can't be scanned (cleanup)
tracker item
Installation, Setup; setup.sh text should be updated with git ways (not SVN)
tracker item
Installation; Clarification of the UTF-8 test/message after locking the Tiki
tracker item
Installation; Upgrading and using a git version, the database connection is lost and installation is stuck on the Tiki Installer Security Precaution
tracker item
Installation: 6.1 install fails using Mysql 5.5.9
Three queries fail during the installation of version 6.1 when using Mysql 5.5.9 because the deprecated syntax __timestamp(14)__ has been removed and should now be __timestamp__.

The queries that fail are the table creation queries for tiki_banning, tiki_friendship_requests, and tiki_users_score.

This is essentially a duplicate of Ticket ID 2213 except to clearly note the solution and that it affects TikiWiki 6.1 and Mysql version 5.5.9.
tracker item
Installer destroys admin PW
tracker item
Installer does not set language on new install
On a new installation (clean DB), Tiki does not set the site's default language.
tracker item
Installer encoding issue
tracker item
Installer Failes with german language selected
when you try to run the installer 5 beta 2 with german language selected, the creation of the DB failes.

you run the db installer, you get an empty screen. When reloading, it gives an SQL error.

it stops at "users_users" table.
tracker item
Installer fails against Oracle 10 DB
Hello,

we don't get tikiwiki installed into oracle database. we used instantclient_11_1, compiled oci8 against the libraries, loaded the extension in php.ini, configured apache2 environment (LD_LIBRARY_PATH etc). then we restarted apache2 and started tiki-installer.php. Connection seems to work, but then the installion process aborts with following error:

PHP Fatal error: Call to a member function fetchRow() on a non-object in /srv/www/htdocs.oracle/installer/tiki-installer.php on line 43, referer: http://192.168.5.37/ora-tiki/tiki-install.php

tracker item
Installer fails numerous sql creates with Incorrect sub part key or Specified key was too long error
Am trying to install 1.9-BRANCH (1.9.8) on my server. 1.9.7 worked fine, 1.10 worked fine after a tweak, but this 1.9.8 install seems to barf.

Running Mysql 4.1.1, and have even copied the db/tiki-1.9-mysql.sql contents for the create table segments that failed and used phpMyAdmin without success. A full example is:

Command: CREATE TABLE tiki_articles (
articleId int(8) NOT NULL auto_increment,
topline varchar(255) default NULL,
title varchar(80) default NULL,
subtitle varchar(255) default NULL,
linkto varchar(255) default NULL,
lang varchar(16) default NULL,
state char(1) default 's',
authorName varchar(60) default NULL,
topicId int(14) default NULL,
topicName varchar(40) default NULL,
size int(12) default NULL,
useImage char(1) default NULL,
image_name varchar(80) default NULL,
image_caption text default NULL,
image_type varchar(80) default NULL,
image_size int(14) default NULL,
image_x int(4) default NULL,
image_y int(4) default NULL,
image_data longblob,
publishDate int(14) default NULL,
expireDate int(14) default NULL,
created int(14) default NULL,
heading text,
body text,
hash varchar(32) default NULL,
author varchar(200) default NULL,
nbreads int(14) default NULL,
votes int(8) default NULL,
points int(14) default NULL,
type varchar(50) default NULL,
rating decimal(3,2) default NULL,
isfloat char(1) default NULL,
PRIMARY KEY (articleId),
KEY title (title),
KEY heading (heading(255)),
KEY body (body(255)),
KEY nbreads (nbreads),
KEY author (author(32)),
KEY topicId (topicId),
KEY publishDate (publishDate),
KEY expireDate (expireDate),
KEY type (type),
FULLTEXT KEY ft (title,heading,body)
) TYPE=MyISAM AUTO_INCREMENT=1
Message: Incorrect sub part key. The used key part isn't a string, the used length is longer than the key part or the storage engine doesn't support unique sub keys

and

Command: CREATE TABLE tiki_blogs (
blogId int(8) NOT NULL auto_increment,
created int(14) default NULL,
lastModif int(14) default NULL,
title varchar(200) default NULL,
description text,
user varchar(40) default NULL,
public char(1) default NULL,
posts int(8) default NULL,
maxPosts int(8) default NULL,
hits int(8) default NULL,
activity decimal(4,2) default NULL,
heading text,
use_find char(1) default NULL,
use_title char(1) default NULL,
add_date char(1) default NULL,
add_poster char(1) default NULL,
allow_comments char(1) default NULL,
show_avatar char(1) default NULL,
PRIMARY KEY (blogId),
KEY title (title),
KEY description (description(255)),
KEY hits (hits),
FULLTEXT KEY ft (title,description)
) TYPE=MyISAM AUTO_INCREMENT=1
Message: Specified key was too long. Max key length is 500

which ultimately cause:

Command: # --------------------------------------------------------
INSERT INTO tiki_modules (name,position,ord,cache_time,groups) VALUES ('login_box','r',1,0,'a:2:{i:0;s:10:"Registered";i:1;s:9:"Anonymous";}')
Message: Table 'tiki-19branch.tiki_modules' doesn't exist

because the table never gets created.

I'm not sure how to go about fixing this problem.
tracker item
Installer in Tiki6 is not ensuring utf-8 in new db and tables (only on upgrade)
If you install a brand new Tiki6 site, and your database was created with latin1 charset (by sys admin, phpmyadmin, by whatever means), Tiki doesn't warn you at installation time that the db is using latin1.

Only when you upgrade the Tiki6 site, tiki detects that db and tables are not utf-8, and allows converting them to utf-8.

This can be reproduced easily with the TikiLiveCD 0.6, which came (from a customized Slax GNU/Linuxd distro) with an empty db called "test" with latin1 charset, that is to be used for Tiki installation.
http://tiki.org/TikiLiveCD
tracker item
Installer language selection is wrongly changed by TIki
tracker item
Installer not ready for PHP 7.4 in Tiki 18.x
tracker item
Installer quiets errors in all database queries
Since r20087, database errors during the installer have an empty error handler, because failures in queries from upgrade scripts are already properly reported.

This unfortunately also has the bad effect of quieting all other errors in queries outside upgrade scripts.
tracker item
Installer steps list bad contrast
tracker item
Installer timeout issue
tracker item
Installer, Updating the database from the Tiki installer failed and need to be done using the console
tracker item
Installer: at end of successful install, big red PHP mem warning box can be inconsistent w text abov
After successful install,
final page suggests that PHP's memory_limit should be >= 16M.
But, big red box warns that the PHP memory_limit is 16M!

No problem technically, but confusing to new, non-tech, or inexperienced users. Installers are very important for the initial experience of new users.
tracker item
Internal Eror (500)
After unzipping and uploading, OR uploading and uncompressing, php pages doesnt open, with error

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.

Please contact the server administrator, webmaster@themediamonkeys.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.




http://themediamonkeys.com/tikibeta/


actual site is working fine at http://www.themediamonkeys.com
tracker item
Unknown column 'tweetId' in 'tiki_shoutbox'
Upgrading from 7.2 to 8.x revision 38517
Upgrading from 7.2 to 8.2 tweetId still missing

Operations failed: 1 SQL queries.

ALTER TABLE tiki_shoutbox modify tweetId BIGINT(20) UNSIGNED NOT NULL default 0
Unknown column 'tweetId' in 'tiki_shoutbox'
tracker item
At the end of installer from 4.x to now 8.1, the run of session crashes with an exception "session start"
At the end of the installer when launch is run we can get a crash with an exception :

__"Session already opened"__

This has been reported since two years may be six times.

I have not made various test, so may be it depends of the context which is :

#Data upgraded from existing connection
#Run without inhibiting installer

This should not have effect. So I don't understand why others don't seem to observe the problem that I had always.

I need to run again directly index.
tracker item
After an install with upgrade, tiki-admin displays the error "invalid database" ad-vitam
(Not yet checked for trunk)

After running installer with upgrade we get the message "Invalid database run installer..."

Running installer don't changes anything to database, but the message is still displayed.
It is a consistency "deadlock by soft".

The lonely thing generated by installer is a reset which needs to reset manually the admin account and clear all caches and cookies (see #4066 admin login problem).

~~#090:!!!Going on 12/06/2011~~

I need to check the soft.

The message is sent by "installer" $installer instance of class installer in installib
It checks before the validation of patches on db using $installer->recordPatch($patch) for each one.
recordPatch function in installer records the patch into tiki_schema as done with his full date.

The concerned (got by a var_dump) patch is "20110904_shoutbox_def_tweetid_tiki"
is not into the tiki_schema table.
So the test functions, but the tiki-install failed to make this patch on another version OK, as it is defined.

__~~#F00:When it runs now (installer at 8.1 level) it don't tries to make the upgrade. This is the deadlock.
__What is done if an old patch is not there !!!__

More there is no report at all.~~__



tracker item
Tiki 6.x to Tiki 8.x upgrade with Latin-1 to UTF-8 conversion
The conversion and upgrade went well except that page names were not converted

So I had to manually rename some pages for these characters:
é -> é
É -> É
à -> à
è -> è

Wiki page attachments were associated the corrected page name. Thus, if I didn't rename the page, attachment wasn't available.
tracker item
Tiki installer with Softaculous on webhostingpad.com: failure of regular click to apply featured profile
Install a Tiki 8.2 via Softaculous on a site managed by http://www.webhostingpad.com/

Then, after the install, click on the regular link to get the featured profiles, and you get an error message.

If you type a profile name in the search box, it works fine.

tracker item
Zend_Search_Lucene doesn't work on certain servers
To reproduce, search "wiki" in the admin panel here:
http://branding.tiki.org/tiki-admin.php

And you will get:
"No preferences were found for your search query."

Ideally, the problem is solved, but this is maybe tricky. It could be related to:

{QUOTE(replyto="http://framework.zend.com/manual/1.11/en/zend.search.lucene.index-creation.html")}"Zend_Search_Lucene uses flock() to provide concurrent searching, index updating and optimization. According to the PHP » documentation, "flock() will not work on NFS and many other networked file systems. Do not use networked file systems with Zend_Search_Lucene."{QUOTE}

At the very least, Tiki should detect and report to the site admin that he should use MySQL Full Text Search instead.

Ideally, MySQL Full Text Search would work for tiki-admin.php
tracker item
Search index could not be updated. The site is misconfigured. Contact an administrator.
__unified_incremental_update doesn't check for feature_search__

Unified Search with Lucene is awesome and is "the future of Tiki".

Now, on certain server configurations, it doesn't work well. An easy workaround is to simply revert to the legacy MySQL Full Text Search.

However, even when using MySQL Full Text Search, unified_incremental_update is defaulted to yes, and tried to update Lucene index, and generates an error message

Workaround is to deactivate unified_incremental_update, or even better, upgrade to 12.x and use Unified Index, with MySQL as storage.
---
Update: this issue has been reproduced in 12.x svn (and untested in 14.x so far, afaik) also with Mysql Full Text Search as unified search engine (on a multitiki install). See: [item5673] . {sign user="xavi" datetime="2015-05-19T09:10:57+00:00"}
tracker item
6.7 LTS: Possible security threat: Logging into Wiki A as admin may raise your privilege level in Wiki B
I looked if something like this has been reported previously, but didn't find something that completely fits, so I post this and apologize if I missed something.

Since I have already put some detail into a [http://tiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=44097#threadId44102|support request] and at the moment I believe it only concerns two Wikis belonging to the same admin, here is a description:

Steps to reproduce:
1) Take any Tiki installation and move a new directory
2) Create a new DB with a copy of the original DB
3) Upgrade and start it up
4) Log into the old installation as admin
5) Find out you're admin on the new one, too.

It may well be that for some admins this is a wanted behaviour like as a single-sign-on (SSO).

But it is my firm belief that any such behaviour is to be considerd a breach of security unless both admins have expressley activated this as a wanted behaviour. Possibly the problem also exists if two different admins operate two different Tikis on the same hosted volume, that somehow were created from one single predecessor, so maybe this is not as harmless as it might seem to be.

I do not know, but suspect, this could be a cookie issue.

Resolution could be that tiki-installer regenerates all security structures upon installation and/or upgrades, or at least asks the admin whether such should be reset. Also, there should be a button in the administration panel to reset this at any later time. In my opinion TikiWiki should at all times, if not told to behave otherwise, protect its instance against all other possible instances of itself...

At some point confusion may get so high to a user's browser that logging into Wiki B alone will not function, and you have to log into Wiki A to be able to access Wiki B. At the moment I experience this with my new 6.7 LTS and my old 1.9.8.3. sitting in different directories on the same volume, accessing to different MySQL DBs with differing user names and passwords...
tracker item
Fatal error: Cannot redeclare class Zend_Oauth_Consumer in /usr/share/php/libzend-framework-php/Zend/Oauth/Consumer.php on line 279
TikiWiki version 8.4
I attempted to apply the Company Intranet profile and my site (locally hosted) is no longer available.

Fatal error: Cannot redeclare class Zend_Oauth_Consumer in /usr/share/php/libzend-framework-php/Zend/Oauth/Consumer.php on line 279

((http://sis.dev.powerofu.net/tikiwiki/|http://sis.dev.powerofu.net/tikiwiki/))

tracker item
tiki 9.0 install dies with PHP Fatal error Uncaught exception 'SmartyException' in smarty_security.php:381
After I select to use the database connection, tiki-install returns blank page.

Error message logged during a few retries:
Jun 27 19:51:15 kernel apache2: PHP Notice: unserialize(): Error at offset 0 of 5 bytes in /var/www/localhost/htdocs/tikiwiki/lib/setup/prefs.php on line 377
Jun 27 19:51:16 kernel apache2: PHP Fatal error: Uncaught exception 'SmartyException' with message 'directory '' not allowed by security setting' in /var/www/localhost/htdocs/tikiwiki/lib/smarty/libs/sysplugins/smarty_security.php:381
Jun 27 19:51:16 kernel Stack trace:
Jun 27 19:51:16 kernel #0 /var/www/localhost/htdocs/tikiwiki/lib/smarty/libs/plugins/function.html_image.php(114): Smarty_Security->isTrustedResourceDir('img/icons/green...')
Jun 27 19:51:16 kernel #1 /var/www/localhost/htdocs/tikiwiki/lib/smarty_tiki/function.icon.php(212): smarty_function_html_image(Array, Object(Smarty_Internal_Template))
Jun 27 19:51:16 kernel #2 /var/www/localhost/htdocs/tikiwiki/templates_c/en18b660cf6951a7bde07357befc24a4e5^fa112beffbe935d6123ba78bf16e4de6898a7e56.file.tiki-browse_image.tpl.php(105): smarty_function_icon(Array, Object(Smarty_Internal_Template))
Jun 27 19:51:16 kernel #3 /var/www/localhost/htdocs/tikiwiki/lib/smarty/libs/sysplugins/smarty_internal_templatebase.php(180): content_4feb4814e9bb29_68835866(Object(Smarty_Internal_Template))
Jun 27 19:51:16 kernel #4 /var/www/localhost/htdocs/tikiwiki/lib/init/smarty.php(194): Smarty_Internal_TemplateBase->fetch('tiki-browse_ima...', 'en18b660c in /var/www/localhost/htdocs/tikiwiki/lib/smarty/libs/sysplugins/smarty_security.php on line 381
Jun 27 19:52:18 kernel apache2: PHP Fatal error: Uncaught exception 'SmartyException' with message 'directory '' not allowed by security setting' in /var/www/localhost/htdocs/tikiwiki/lib/smarty/libs/sysplugins/smarty_security.php:381
Jun 27 19:52:18 kernel Stack trace:
Jun 27 19:52:18 kernel #0 /var/www/localhost/htdocs/tikiwiki/lib/smarty/libs/plugins/function.html_image.php(114): Smarty_Security->isTrustedResourceDir('img/icons/green...')
Jun 27 19:52:18 kernel #1 /var/www/localhost/htdocs/tikiwiki/lib/smarty_tiki/function.icon.php(212): smarty_function_html_image(Array, Object(Smarty_Internal_Template))
Jun 27 19:52:18 kernel #2 /var/www/localhost/htdocs/tikiwiki/templates_c/899478d8f66ae50789ef4567806e9fba159fb70d.file.remarksbox.tpl.php(44): smarty_function_icon(Array, Object(Smarty_Internal_Template))
Jun 27 19:52:18 kernel #3 /var/www/localhost/htdocs/tikiwiki/lib/smarty/libs/sysplugins/smarty_internal_templatebase.php(180): content_4feb485289d963_55269745(Object(Smarty_Internal_Template))
Jun 27 19:52:18 kernel #4 /var/www/localhost/htdocs/tikiwiki/lib/smarty_tiki/block.remarksbox.php(82): Smarty_Internal_TemplateBase->fetch('remarksbox.tpl')
Jun 27 19:52:18 kernel #5 /var/www/localhost/htdocs/tikiwiki/tem in /var/www/localhost/htdocs/tikiwiki/lib/smarty/libs/sysplugins/smarty_security.php on line 381
Jun 27 19:52:56 kernel apache2: PHP Notice: unserialize(): Error at offset 0 of 5 bytes in /var/www/localhost/htdocs/tikiwiki/lib/setup/prefs.php on line 377
Jun 27 19:52:59 kernel apache2: PHP Fatal error: Uncaught exception 'SmartyException' with message 'directory '' not allowed by security setting' in /var/www/localhost/htdocs/tikiwiki/lib/smarty/libs/sysplugins/smarty_security.php:381
Jun 27 19:52:59 kernel Stack trace:
Jun 27 19:52:59 kernel #0 /var/www/localhost/htdocs/tikiwiki/lib/smarty/libs/plugins/function.html_image.php(114): Smarty_Security->isTrustedResourceDir('img/icons/green...')
Jun 27 19:52:59 kernel #1 /var/www/localhost/htdocs/tikiwiki/lib/smarty_tiki/function.icon.php(212): smarty_function_html_image(Array, Object(Smarty_Internal_Template))
Jun 27 19:52:59 kernel #2 /var/www/localhost/htdocs/tikiwiki/lib/smarty_tiki/block.self_link.php(132): smarty_function_icon(Array, Object(Smarty_Internal_Template))
Jun 27 19:52:59 kernel #3 /var/www/localhost/htdocs/tikiwiki/templates_c/en18b660cf6951a7bde07357befc24a4e5^484698837cbb46d4277f0d8a99265584d63a50a7.file.tiki.tpl.php(84): smarty_block_self_link(Array, '', Object(Smarty_Internal_Template), false)
Jun 27 19:52:59 kernel #4 /var/www/localhost/htdocs/tikiwiki/lib/smarty/libs/sysplugins/smarty_internal_templatebase.php(180): content_4feb487a692cb9_95479002(Object(Smarty_Internal_Te in /var/www/localhost/htdocs/tikiwiki/lib/smarty/libs/sysplugins/smarty_security.php on line 381
Jun 27 19:53:05 kernel apache2: PHP Fatal error: Uncaught exception 'SmartyException' with message 'directory '' not allowed by security setting' in /var/www/localhost/htdocs/tikiwiki/lib/smarty/libs/sysplugins/smarty_security.php:381
Jun 27 19:53:05 kernel Stack trace:
Jun 27 19:53:05 kernel #0 /var/www/localhost/htdocs/tikiwiki/lib/smarty/libs/plugins/function.html_image.php(114): Smarty_Security->isTrustedResourceDir('img/icons/green...')
Jun 27 19:53:05 kernel #1 /var/www/localhost/htdocs/tikiwiki/lib/smarty_tiki/function.icon.php(212): smarty_function_html_image(Array, Object(Smarty_Internal_Template))
Jun 27 19:53:05 kernel #2 /var/www/localhost/htdocs/tikiwiki/templates_c/899478d8f66ae50789ef4567806e9fba159fb70d.file.remarksbox.tpl.php(44): smarty_function_icon(Array, Object(Smarty_Internal_Template))
Jun 27 19:53:05 kernel #3 /var/www/localhost/htdocs/tikiwiki/lib/smarty/libs/sysplugins/smarty_internal_templatebase.php(180): content_4feb48816e5dc4_03329759(Object(Smarty_Internal_Template))
Jun 27 19:53:05 kernel #4 /var/www/localhost/htdocs/tikiwiki/lib/smarty_tiki/block.remarksbox.php(82): Smarty_Internal_TemplateBase->fetch('remarksbox.tpl')
Jun 27 19:53:05 kernel #5 /var/www/localhost/htdocs/tikiwiki/tem in /var/www/localhost/htdocs/tikiwiki/lib/smarty/libs/sysplugins/smarty_security.php on line 381
Jun 27 19:53:29 kernel apache2: PHP Notice: unserialize(): Error at offset 0 of 5 bytes in /var/www/localhost/htdocs/tikiwiki/lib/setup/prefs.php on line 377
Jun 27 19:53:33 kernel apache2: PHP Fatal error: Uncaught exception 'SmartyException' with message 'directory '' not allowed by security setting' in /var/www/localhost/htdocs/tikiwiki/lib/smarty/libs/sysplugins/smarty_security.php:381
Jun 27 19:53:33 kernel Stack trace:
Jun 27 19:53:33 kernel #0 /var/www/localhost/htdocs/tikiwiki/lib/smarty/libs/plugins/function.html_image.php(114): Smarty_Security->isTrustedResourceDir('img/icons/green...')
Jun 27 19:53:33 kernel #1 /var/www/localhost/htdocs/tikiwiki/lib/smarty_tiki/function.icon.php(212): smarty_function_html_image(Array, Object(Smarty_Internal_Template))
Jun 27 19:53:33 kernel #2 /var/www/localhost/htdocs/tikiwiki/templates_c/enbdb13e339b46aade55c78ddc060eb364^899478d8f66ae50789ef4567806e9fba159fb70d.file.remarksbox.tpl.php(35): smarty_function_icon(Array, Object(Smarty_Internal_Template))
Jun 27 19:53:33 kernel #3 /var/www/localhost/htdocs/tikiwiki/lib/smarty/libs/sysplugins/smarty_internal_templatebase.php(180): content_4feb489d7e3299_95750395(Object(Smarty_Internal_Template))
Jun 27 19:53:33 kernel #4 /var/www/localhost/htdocs/tikiwiki/lib/init/smarty.php(194): Smarty_Internal_TemplateBase->fetch('remarksbox.tpl', 'enbdb13e339b46a...', in /var/www/localhost/htdocs/tikiwiki/lib/smarty/libs/sysplugins/smarty_security.php on line 381

apache-2.2.22, php-5.4.4, gentoo install

tiki-8.4 runs fine
tracker item
sh setup.sh does not change directory permissions
Although the files are owned by the same user that runs the script the directory permissions do not get changed.


firedragonvbs@FiredragonVBS:~/public_html/cms/tiki-9.x$ sh setup.sh -u firedragonvbs -g firedragonvbs
You are not root or you are on a shared hosting account. You can now:

1- ctrl-c to break now.

or

2- If you press enter to continue, you will probably get some error messages
but it (the script) will still fix what it can according to the permissions
of your user. This script will now ask you some questions. If you don't know
what to answer, just press enter to each question (to use default value)
> Press enter to continue:
> Multi []:
Checking dirs :
db ... ok.
dump ... ok.
img/wiki ... ok.
img/wiki_up ... ok.
img/trackers ... ok.
modules/cache ... ok.
temp ... ok.
temp/cache ... ok.
temp/public ... ok.
templates_c ... ok.
templates ... ok.
styles ... ok.
maps ... ok.
whelp ... ok.
mods ... ok.
files ... ok.
tiki_tests/tests ... ok.
temp/unified-index ... ok.
Fix global perms ...
You are not root. We will not try to change the file owners.
Change group to firedragonvbs ... done.
Fix normal dirs ... done.
Fix special dirs ... done.

Tiki is not properly set up:

The directory '/home/firedragonvbs/public_html/cms/tiki-9.x/dump/' is not writeable by www-data.
The directory '/home/firedragonvbs/public_html/cms/tiki-9.x/img/wiki/' is not writeable by www-data.
The directory '/home/firedragonvbs/public_html/cms/tiki-9.x/img/wiki_up/' is not writeable by www-data.
The directory '/home/firedragonvbs/public_html/cms/tiki-9.x/modules/cache/' is not writeable by www-data.
The directory '/home/firedragonvbs/public_html/cms/tiki-9.x/temp/' is not writeable by www-data.
The directory '/home/firedragonvbs/public_html/cms/tiki-9.x/templates_c/' is not writeable by www-data.

tracker item
PHP Notice: Undefined index:
Running installer for: db/local.php
PHP Notice: Undefined index: session_protected in /home/firedragonvbs/public_html/cms/tiki-9.1/tiki-setup_base.php on line 73
PHP Notice: Undefined index: session_lifetime in /home/firedragonvbs/public_html/cms/tiki-9.1/tiki-setup_base.php on line 86
PHP Notice: Undefined index: tiki_cdn in /home/firedragonvbs/public_html/cms/tiki-9.1/tiki-setup_base.php on line 119
PHP Notice: Undefined index: feature_fullscreen in /home/firedragonvbs/public_html/cms/tiki-9.1/tiki-setup_base.php on line 146
PHP Notice: Undefined index: tikiroot in /home/firedragonvbs/public_html/cms/tiki-9.1/lib/prefs/cookie.php on line 30
tracker item
PHP Safe Mode Fix
The install fails if the server is running php safe mode. There are several references to this issue with work-arounds that didn't work for me (ex. http://twbasics.tikiforsmarties.com/Fixing+Installation+Problems).

The problem (at least for me) was that I do not have access to /tmp. It turns out to be related to a bit of code in initlib.php that doesn't check for an empty tempdir. I added additional code return ./tmp (and create it if necessary). See below. Code is commented "Safemode Fix".

static function tempdir()
{
static $tempdir;
if (!$tempdir) {
$tempfile = @tempnam(false, '');
$tempdir = dirname($tempfile);
@unlink($tempfile);
__ // Safemode Fix
if (!$tempdir) {
$tempdir = "./tmp";
if (!is_dir($tempdir)) {
mkdir($tempdir);
}
}__

}
return $tempdir;
}
tracker item
Unable to enter a fresh tiki install
After installing a new (WampDeveloper) server instance -- to make sure my server wasn't broken

I've just attempted to install Tiki trunk,
all appeared to go fine, installer progressed through to the
"enter Tiki" stage without complaint

upon attempting to enter Tiki (this is a new install, so change __admin__ password is the first page), I see a horribly disfigured Tiki page and an error message -- see attached image

the Error seen is:
"Required features: change_password. If you do not have the privileges to activate these features, ask the site administrator."

I'm running
Apache 2.2.23
PHP 5.3.17
MySQL 5.5.27-log

DB tables are INNOdb (server default)

at the populating the DB stage, only 881 queries were processed
tracker item
Composer install fails
After checking out trunk via SVN and receiving the new Composer files, running the composer install failed to download the zendframework1 requirement and I was unable to proceed to install Tiki.

Setup:
Windows 7 Pro (:redface:)
XAMPP 1.8.1
vhosts setup for each Tiki
Tiki runs from a subfolder "tiki" within webroot
"tiki" is a symlink to my checkout branch
tracker item
Tracker Field Factory Error: Pref ... required for field type ...
There are a few variants of this:

Tracker Field Factory Error: Pref "trackerfield_stars" required for field type "Tracker_Field_Rating"


This is caused because in more recent versions of Tiki, each tracker field type is a preference. It should have been handled by an upgrade script but there must be a bug:



Related:
http://thread.gmane.org/gmane.comp.cms.tiki.devel/26942
http://thread.gmane.org/gmane.comp.cms.tiki.devel/29596
http://thread.gmane.org/gmane.comp.cms.tiki.devel/23733/focus=23759

tracker item
Installation/Infrastructure
Features Classification
tracker item
11.x: composer fails behind a proxy
Fixed in trunk, at least.
tracker item
jCapture doesn't work via SSL when SSL is not valid (rest of Tiki is OK)
tracker item
Kanban_Board_25 profile produces non-working setup
tracker item
keep user information as the user selected on tw.o
I wonder how many times over the last years I've had to select my user profile to be public in my preferences at http://tikiwiki.org/tiki-user_preferences.php

I always change __User information:__ from private to "__public__".
But after some months (and tiki upgrades, maybe?), I find that that settings is at "__private__"

Thus, When I go to send a message to a user, I can't either send the message:

^You have to be able to receive messages in order to send them. Goto your user preferences and enable 'Allow messages from other users'^

Or I can't because that user has that setting as private (I realized that chibaguy now has that same setting, but I wonder whether he chose that or not, like me)
---

same on other settings that have changed without my content:
Messages per page: 2 (I had 10, at least)
Allow messages from other users: no (I had yes)
Note author when reading his mail: no (I had yes)
tracker item
koth
Contributors
tracker item
lib/shoutbox/shoutboxlib.php preg_replace
tracker item
LiveSupport broken in 1.9.3 CVS
LiveSupport seems broken in 1.9.3 CVS.

I can activate it OK via Admin|Features.
When I click on the LiveSupport admin link, I get the admin, I add myself (a regular user) as operator. Then when I try to open a Client window, I get a new popup window with this error:

Warning: Smarty error: unable to read resource: "tiki-live_support_message.tpl" in /usr/www/users/cafsu/networks/lib/smarty/libs/Smarty.class.php on line 1088
tracker item
Localized Installation with Admin Wizard ends in error 500
tracker item
Make it possible to have a message only visible on first run (ex.: u: admin p: admin)
In barebones profile and in featured profiles, there is intro text about 1st login being necessary with u: admin p: admin (good)

However, this message stays and needs to be deleted by admin (bad)

Perhaps we should have a module with is only visible if admin password has not yet been set.


tracker item
Make sure Tiki is offered by all server control panels
This is an ongoing effort:
https://tiki.org/Testing-Tiki-installations-on-major-Shared-Hosting-companies
https://tiki.org/Hosting-company
https://tiki.org/1-click-installers

https://tiki.org/Message-to-1-click-installers-about-Tiki-LTS
tracker item
sh setup.sh to run composer: should check PHP version before trying to run Composer
tracker item
Make Tiki more robust to open_basedir issues
Too many people are having issues:

[http://tikiwiki.org/tiki-searchindex.php?highlight=open_basedir&search=|tikiwiki.org open_basedir issues]
[http://dev.tikiwiki.org/tiki-searchindex.php?highlight=open_basedir&search=|dev open_basedir issues]
[http://doc.tikiwiki.org/tiki-searchindex.php?highlight=open_basedir&search=|doc open_basedir issues]


We need someone who is strong with server administration in a shared hosting context to solve all these issues once and for all.

[http://tikiwiki.org/tiki-view_forum_thread.php?forumId=6&comments_parentId=26696|maybe a hint to the solution?]
tracker item
Make tiki-mods.php report more detailed error
When going to Admin mods (tiki-mods.php) on a new install, make it report the directory name when the mods directory hasn't been created or lacks correct permissions.

The error reported asks to run ./setup.sh but is not specific about the directory affected here. This would be helpful to manually fix the individual directory instead of running ./setup.sh (which may not be possible in some situations like FTP installs).
tracker item
Make Unified Index optional
tracker item
#649
Contributors
tracker item
MediaWiki import script
For many people, Wikipedia (powered by MediaWiki) was their first contact with wikis. MediaWiki has a very nice interface and has done an amazing job to get Wikis known to the public, via Wikipedia. MediaWiki/Wikipedia is probably the best thing that happened to the Wiki world since Ward Cunningham invented the wiki in 1995.

MediaWiki is excellent to make an encyclopedia. However, it is not designed to be an Intranet/corporate wiki with an advanced permission system. Also, MediaWiki is "only" a wiki. It doesn't have extra features like forums, trackers, blogs, etc. Maybe these features will eventually be added to Mediawiki, but it doesn't seem imminent.

Users which want more can use some glueware to combine a Wiki and an existing full featured CMS (ex.: Drupal + MediaWiki or Xoops + MediaWiki) or they can choose Tiki Wiki/CMS/Groupware.

There are apparently millions of MediaWiki installs. In contrast, there are "only" tens of thousands installs of TikiWiki. While this number is very good, we can expect more & more people will want to migrate from MediaWiki to TikiWiki. Even if a small proportion of MediaWiki installs migrated to Tiki, it would still be a very large influx of users.

Tiki can already look like WikiPedia:
http://themes.tikiwiki.org/Tikipedia

One important step for Tiki's future is to have a converter from MediaWiki to TikiWiki so users can have a painless upgrade path and gain access to more features.

http://dev.tikiwiki.org/MediaWiki+to+TikiWiki+converter

Related:
*[wish1531|Wiki markup for icons]
*[wish1805|Universal Wiki Edit Button]
*[wish2102|Support some of the MediaWiki syntax that doesn't conflict with TikiWiki syntax]
*[wish1191|Wiki editing: Preview with diff, like Mediawiki]
*[wish1843|Infoboxes like MediaWiki/Wikipedia, but making use of trackers to be future-proof]
*[wish1781|Support for the Wiki creole markup (syntax)]
tracker item
Migrate binary files in between the file system and the database
Add a feature to move files in between the file system and the database

This feature:
tiki-admin.php?page=trackers
tiki-admin.php?page=fgal
tiki-admin.php?page=wikiatt

should be added here:
tiki-admin.php?page=gal

(In fact, it should be backported from 1.10) "Move images from filesystem storage to database storage"
tracker item
Migrating 18.8 to 21.4 fails utterly, breaks layout
tracker item
Missing fulltext index for trackers after upgrade 1.9.4 -> 1.9.5
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~
tracker item
Missing icon on tiki-install.php
tracker item
missing tiki_rss_items and unable to log
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?
tracker item
More graceful error message when database is unavailable or crashed
I got this on October 25th 2006:

Warning: mysql error: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (2) in query:

select count(*) from `tiki_banners` where `wed` = ? and `hourFrom`<=?
and `hourTo`>=? and
( ((`useDates` = ?) and (`fromDate`<=? and `toDate`>=?)) or
(`useDates` = ?) ) and
`impressions`<`maxImpressions` and `zone`=?

in lib/tikidblib.php on line 134


How could we show a more meaningful error message?


---

mysql tables sometimes crash.

When they do, the error message is cryptic, at best.

An average Tiki admin won't know what the problem is and could think it's Tiki's fault.


A graceful error message would inform the admin that:

"There are problems with the following tables: ". Please repair (link to how to repair)

Especially the tiki_sessions, which shuts down the site completely...

Some others are not so bad. Just a path disclosure.
{img src=images/code.png}%%% {CODE()}
Warning: mysql error: Can't open file: 'tiki_images.MYI' (errno: 145) in query: select count(*) from `tiki_images` where `galleryId`=? in lib/tikidblib.php on line 134
{CODE}
---

Another error to watch for:
{img src=images/code.png}%%% {CODE()}
Unable to connect to the database !
User droit_tiki has already more than 'max_user_connections' active connections
{CODE}
---
Maybe Tiki admin email should be in db/local.php? So the system could send email alerts when DB can't connect.
tracker item
Multi-domain: redirect all traffic to main domain
When a tiki is on a server which has several domain names, have an option to force a redirect to one in particular (similar to force with/without www). Should be a "permanent redirect" HTTP/1.1 301 Moved Permanently

This is related to the recently introduced feature to remove www or add www to Tiki sites

Specifically, all *.tikiwiki.org domains will progressively move *.tiki.org Both URLs will be kept forever but tiki.org should be the new main one that people see in their browser (and copy-paste from)
tracker item
multitiki cannot be installed with tiki-install.php in trunk
I attempted to install a multitiki on subdirectories, based on trunk (Nov 29, 2008), and it failed. I installed two subdir
{CODE()}
setup.sh
www-data
www-data
site1 site2
{CODE}

and through tiki-install.php, I clicked on site1, entered details, and clicked on enter as admin and lock installer.

I couldn't see the site1 tiki
tracker item
Multitiki customizations broken
1.9.0DR4 worked fine. 1.9.0 fails.
If you have a multitiki and create custom css/tpl files, they are not traversed. For example, If you have a multiwiki on www.foo.com and create a style called 'bar', the correct place to put the customized css files is
/styles/www.foo.com/bar.css
But this no longer works. It has to be in /styles/bar.css

The tpl files should be in
/templates/www.foo.com/styles/bar/
But this no longer works. It has to be in /templates/styles/bar

Please put back the old way. The current (broken) way prevents me from having styles of the same name on different multiwikis. each with customization.
tracker item
multitiki in subdirs broken in tiki3 proposed branch due to deleting templates_c at install time
In current tiki3 proposed branch , multitiki installation is broken.
At the last step of installation through tiki-install.php, the folders inside /templates_c for each domain are deleted.

Thus, when in this step:
http://localhost/site1/tiki-install.php?nolockenter

tiki reports that
The directory '/var/www/proposed/modules/cache/learning' does not exist.
The directory '/var/www/proposed/templates_c/learning' does not exist.

And they did exist in the step before (double checked), but not just after that step.

( see http://doc.tikiwiki.org/Manual+Installation of multitikis if needed )
----
Update in Oct'09: This is a duplicated bug report with [bug2271]
Closing.
tracker item
Native multi-site/multi-domain handling
moved to ((WikiFarm))
tracker item
natokpe
tracker item
Need way to auto assign tiki_p_edit_categories (for tiki_p_view_categories) on upgrade to 1.10
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?
tracker item
Neihter show_image.php?id=NN nor imageNN work as-is after upgrade from 9.x to 12.x
tracker item
new tikitrunk install (Nov29, 2008) shows sql errors on mysql 5.0.51a
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}
tracker item
nextdev.t.o Fatal error: Class 'TikiCachedContainer' not found in /path/www/lib/init/initlib.php on line 56
tracker item
Predogfood servers should include files; was:nextthemes.tiki.org/Themes slider shows super small images
tracker item
no progress dialog in tiki-21 installer
tracker item
Not happy change in the installer background
tracker item
Old password is not maintained in the Change PW screen
On a new 1.10 installation...

When logging in as the ADMIN for the first time, the Change Password Enforced page appears (requiring new admins to select a new password). The OLD PASSWORD field should be maintained (pre-filled) with the existing admins password (by default: ADMIN). This __used__ to be the case in 1.9.

Pre-populate the OLD PASSWORD field with the user's existing password. This field should be disabled, so the user cannot change it.
tracker item
On a fresh install, the page title of the Home Page should be hidden
tracker item
OPcache: add a test in tiki-check.php
tracker item
OpenSourceCMS type demo to test/develop and show off profiles
We are documenting some ((info:Use Cases)) which will become profiles. To be able to developer/test/improve these profiles, we would need a site like [http://www.opensourcecms.com/index.php?option=com_content&task=view&id=180|Open Source CMS] but for all profiles. This site only shows one profile.

These 20+ demo sites would provide admin access to easily test any profile. It would encourage people to generate and improve various profiles as well.

Related:
((Profile Manager))
((TRIM))
tracker item
Out of place "components" directory in SVN installs of 13.x
tracker item
output handler 'ob_gzhandler' cannot be used after 'URL-Rewriter' in tiki-setup.php on line 1890
Trying to test for this:
http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=1312

I got, on doc.tikiwiki.org:
{img src=images/code.png}%%% {CODE()}
Warning: ob_start() [ref.outcontrol]: output handler 'ob_gzhandler' cannot be used after 'URL-Rewriter' in tiki-setup.php on line 1890
{CODE}

I had this error once. Have been unable to duplicate.
I don't remember which browser.

I am putting here just in case...
tracker item
php 5.6+: featured profile collab community fails: "An error occurred: Column 'user' cannot be null"
tracker item
PHP Fatal error with ANY profile since 15.x: Search_MySql_LimitReachedException Incorrect datetime value: '0000-00-00 00:00:00' for column 'creation_date'
tracker item
Possible bug at creating base Tiki DB tables
tracker item
Problem with duplicate menus when running tiki_1.8to1.9.sql multiple times.
This code in db/tiki_1.8to1.9.sql used in upgrade script, is causing duplicate menu items.

{img src=images/code.png}%%% {CODE()} INSERT IGNORE INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Mobile','tiki-mobile.php',37,'feature_mobile','','');
{CODE}

{img src=images/code.png}%%% {CODE()} INSERT INTO tiki_menu_options (menuId,type,name,url,position,section,perm,groupname) VALUES (42,'o','Users map','tiki-gmap_usermap.php',36,'feature_gmap','',''); {CODE}


Duplicates also happen for 187, and 188, 900, 1191, 1235, and in a minor way, 189, 780,

See screenshot attached.
tracker item
Problem with Proxy autentication - download Profiles
Hello,

My english is very basic.

I am working into corporative network with proxy server conection. This conection required User and Password. But into TikiWiki's Proxy Configuration is not requiered.

For this reason I am not conect to download profiles from http://profiles.tiki.org/profiles.

I can not install de Profiles. How I can resolve it?

Help me,


Bye.
tracker item
Profile handler for wiki structures
tracker item
Profile not applied properly (after 1st image inserted) when init_files defined in a file gallery
tracker item
Profile preview fails with ugly CSRF error
tracker item
Profile Validation
When trying to execute a profile, validation simply cancels the execution request instead of showing a message with where the validation failed.

Previous versions of Tiki used to do this and is very helpful when testing and developing profiles.
tracker item
Profiles Repository URLs Are Not Connect
I have installed TikiWiki 3.3 in RHEL 4.
Everything works are successfull excepted only Profiles Repository updates. When I click 'list' buton at Profiles Admin pages, the 'Data Channels' are not updated. I think it related with proxy setting.

The newly installed TikiWiki is setted up inside network of proxy server. That is the TikiWiki be affected on proxy.

My question is that how to set up proxy information within Tikiwiki to successful communicate with 'http://profiles.tikiwiki.org/profiles'?
tracker item
Profiles and Profiles Wizard not working
tracker item
Profiles exporter exports only those custom modules which are assigned to a module zone
tracker item
Profiles wizard doesn't get profiles loaded successfully and no link to click on once in control panel
tracker item
Profiles, Wizard; Erronous link for a profile in the installation wizard for the timesheet profile
tracker item
Profiles: $profilerequest ignores user input when applying a profile
tracker item
Provide a tablesorter-powered list of profiles in the Profiles Wizard bundled in Tiki to filter on features, tags, names and such
tracker item
R_demo profile doens't get fully aplied in 15.x complaining of some prefs that are defined (Tracker Field Factory Error: Pref "trackerfield_file" required ....)
tracker item
Remove www automatically
using www.domain.com vs domain.com and it will not keep you logged in.

Plus, having www is no longer relevant nowadays


http://www.fabianlim.name/redirecting-non-www-domain-to-www-using-htaccess
http://arjaneising.nl/wp-content/uploads/htaccess-www.txt

{CODE(caption="Jonny says")}Finally - Marc, did you crack the www url problem? As you said, it would be nice to have as a pref in Tiki and i think the only way to do it for all cases (subdomains, subdirectories etc) is in PHP. For now we could just add it to local.php - stuff like:

if (strpos($_SERVER['HTTP_HOST'], 'www') === 0) {
// do stuff...{CODE}



Related:
{wish id=1611}
tracker item
Reporting errors (to tiki.org) system (like Firefox Talkback)
Some desktop applications have a way to report errors. This would help us know which bugs happen the most often. For example, we could check for sql errors or hard php errors.

Of course, this would be totally optional. Even better would be for people to be able to share their Tiki configuration (anonymously) at the same time so maybe we could detect that bug X only happens with a specific combination of on/off settings.

Firefox talkback:
http://www.mozilla.org/support/firefox/faq#talkback

Of course, knowing about all the bugs doesn't automagically fix them. However, some are super easy to fix if we notice them, like this one:
http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=1399

The same way TikiWiki community members can vote on bugs and feature request, the "crowdsourcing" of error reporting will make it easier to distinguish the most common issues. It would also be a hint that some very rarely reported issues are probably related to a rare server configuration.

The same way I invest to address the most voted on features/bugs, I would do the same here. Specifically, I would like to see reports of the top-10 Postgres-related errors. I am sure these are easy to fix and could make TikiWiki more useful to Postgres users. I would like to use Tiki on Postgres eventually.

http://yro.slashdot.org/article.pl?sid=09/01/24/1938224
tracker item
Review .htaccess from HTML5 Boilerplate for security and performance
tracker item
Robots.txt Disallow entries now must have leading slash
Although the RFC (for example, [http://www.robotstxt.org/wc/norobots-rfc.html]) doesn't explicitly require a leading slash (/) before the page name, I have found that, as of late Oct, 2005, many 'bots, including Googlebots, have started requiring them.

For example, before the change,

Disallow: tiki-pagehistory.php

would prevent well-behaved 'bots from trying to index tiki-pagehistory.php. However, after the change, I had to have:

Disallow: /tiki-pagehistory.php

in robots.txt, or else all my page history would be indexed! I verified this using my server log, and also by doing google searches against my site for phrases that only appeared in page history. I have every reason to believe this is a problem for all other TikiWiki-based sites.

Others have noticed this. There is discussion in the forums at:
* [http://tikiwiki.org/tiki-view_forum_thread.php?comments_parentId=13666&forumId=4|Googlebot ignoring robots.txt] -- includes a __graph of my bandwidth usage before and after__.
* [http://tikiwiki.org/tiki-view_forum_thread.php?topics_offset=1&forumId=4&comments_parentId=12342|Adding <meta name="robots" content="noindex,nofollow"> to History pages]
* [http://tikiwiki.org/tiki-view_forum_thread.php?topics_offset=1&forumId=4&comments_parentId=15004|Yahoo search indexes Print pages instead of Read pages]
tracker item
robots.txt should exclude ALL print-friendly pages
The robots.txt in the current distro (1.9.x Sirius) contains

Disallow: tiki-print.php

Should it not also contain

Disallow: tiki-print_article.php
Disallow: tiki-print_blog_post.php
Disallow: tiki-print_multi_pages.php
Disallow: tiki-print_pages.php
tracker item
RSS feed broken by backslash if tw in root of subdomain
If Tikiwiki 1.9.4 or 1.9.5 is installed in the wwwroot of a "real" subdomain that resides on its own (win)server (not an alias to a subfolder under the main-domain), then rsslib.php inserts an additional backslash after the domain-name.

Links of rss-feed then look like: ~~#FF0000: sub.domain.com\/tiki... ~~ and RSS feed gets obviously broken.

As a quick-fix for my site I resolved this in the file rsslib.php by deleting the string:
~~#FF0000: ~np~ .dirname( $urlarray["path"] ) ~/np~ ~~
in the variables:
~~#FF0000: $home, $img, $read, $cssStyleSheet, and $xslStyleSheet ~~
in order to get RSS-2.0 to work again.

Unfortunately I'm not any more a coder and don't know php good enough to fix this for everybody and contribute in the CVS (I did no more coding since turbo-pascal under DOS in the mid 90's, but at least still can read a little bit :-)

all the best,
Felix

PS: Thanks everybody here for this great software!!!

tracker item
Running upgrade from 1.9.x to 2.x requires being logged into the app before starting process
When upgrading to 2.0 rc4 from 1.9.11 install failed because I was not logged into the app. By the time I reached that stage, I was no longer able to login. Need to make note at the beginning of the upgrade procedure instructions to FIRST LOG INTO TIKIWIKI AS ADMIN
tracker item
Secdb automatic check with cron job
SecDB is very useful to check which files have changed and to detect suspicious files.
http://doc.tikiwiki.org/Security+Admin

Next step would be to run on a cron-job (or pseudo cron-job) and to send an email to the admin (with an easy way for the admin to report the issue to the tikiwiki security team) when it detects the presence of a new file.


Related:
[tiki-view_tracker_item.php?itemId=1410|Secdb for all files (not just php)]
tracker item
Secdb for all files (not just php)
SecDB is very useful to check which files have changed and to detect suspicious files.
http://doc.tikiwiki.org/Security+Admin

It is also useful when I upgrade a Tiki to see what has been altered or added. It would be nice to have this for all files (images, tpl, etc)


Related:
Secdb automatic check with cron job
http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=1354
tracker item
Security problem with sophisticated google hack on local.php (how to clean up after an intrusion)
Intruder injected code into local.php .. not sure whether they were able to actually log into server and change the file manually or were able to get scripts to do it. But the change had these characteristics:

1. when viewing the site directly, everything seems fine
2. on doing a google search on the site, links appear normal but...
3. when you click on the link, it hits the site and the modified TW returns a redirect to something like a random selection of porn servers or whatever.

since the addition is in local.php an upgrade does not overwrite it.

The hack checks for user agent and if it detects you came in from Google (or other search engines) it does the redirect. Otherwise it just exits.

(I've saved a copy of the code and will email to security team if they are interested)

tracker item
See PHP error logs from within Tiki
tracker item
SEF URL Search Engine Friendly URL
__A CMS without SEF URL means it is a Bug : Usability__

it's a by setup checkable standart in a high quality CMS
simple weblogs like http://www.s9y.org/ have such a feature

why :
google likes */this_is_a_very_god_page.html
and normaly google didn't index
*/mybugy.php?bestpage=my&t1=page&t2=is&t3=the&t4=best&indexed_by_SE=normalnever

i think the best webpage is nothing if SEFURL isn't working


the half way is done with the htaccess - ok
the next half way was a mod from http://www.coofercat.com/wiki/TikiURLtInstall

It's working in a root env with 1.9.x and 1.10cvs
that means only if /tmp is writable for the webserver - this is the bug

but online on a vserver this shit happens to me

Warning: mkdir(): open_basedir restriction in effect. File(/tmp/71) is not within the allowed path(s): (/srv/nww/webx/:/srv/nww/htdocs/phpMyAdmin/:/srv/nww/htdocs/confixx/html/gesperrt/) in /srv/nww/webx/html/wiki/lib/adodb/adodb.inc.php on line 1551

Warning: fopen(): open_basedir restriction in effect. File(/tmp/71/adodb_716f2422695ca15b221f4ce6f146321c.cache) is not within the allowed path(s): (/srv/nww/webx/:/srv/nww/htdocs/phpMyAdmin/:/srv/nww/htdocs/confixx/html/gesperrt/) in /srv/nww/webx/html/wiki/lib/adodb/adodb-csvlib.inc.php on line 298
......this msg repeats about 1000 times
did you know what's going on

I started to debug this problem
but it seams to get bigger and bigger

saved data titles must be renamed
becorce
http://localhost/HEAD/page-page%202.html
didn't result in
page 2
and so on
tracker item
sender_email can't be set as $profilerequest:sender_email$YourEmail@example.com$
tracker item
session_lifetime in tiki_preferences table causes system error. This causes migration to Tiki 5 to fail.
Upgrading a site from 4.x to 5.0 appeared to be successful (i.e. no error messages are given) but the site opens only with an error page. The message on the page is "System error. An error occured while performing the request."

I traced the problem to the presence of a record in the tiki_preferences database with name=session_lifetime and value=20. It appears that if the value is non-zero, the system error occurs. Deleting the record or setting the value to zero solve the problem.
tracker item
Setting User Tracker id login and registration fields from Profile fails
tracker item
Setting admin password in the installer, with option to force change at first login
nyloth: in my opinion, a password for admin should be asked inside the installer, no password change should be asked after that, and user should be already logged as admin just after the last step of the installer.

marclaporte: I agree but can we have a checkbox, like in admin-users to force admin user to change password at first run? So I deploy snapshot-copies of a lot of Tikis, I am sure that they don't all have same password.
tracker item
update.dogfoodserver.sh cannot be used in a non-interactive way
tracker item
setup.sh enters endless loop
tracker item
setup.sh fails with error 'wrong PHP version 52 but >= 55 necessary'
tracker item
setup.sh not utilizing found PHP version
tracker item
Setup.sh verbose need to be clarified and updated (php7.4)
tracker item
setup.sh: Hardcoded "php" entries
tracker item
Site Not Available Notice after running tiki-install.php
tracker item
SMTP Configuration from inside Admin Interface
A lot of people who install this aren't doing it via Fantastico and trying to change email settings to suit your hosting provider is a pain. Editing the php.ini isn't always wise either because what works for one app will break another. I know that you can copy the php.ini to the directory, but that's something of a security risk. There's a reason that the default php.ini is stored outside the web root directory.

I know that I see a lot of users posting on the TikiWiki forums with questions about configuring SMTP.
tracker item
Softaculous: On a fresh install, MyISAM is used instead of InnoDB
tracker item
Some DB tables are not created on MySQL 5.5 and above during install
I created a test environment with the following components:
Apache 2.2.10
PHP 5.2.8
MySQL 6.0.8 alpha

I was not able to get MySQL 5.1 working on my machine,
but I was abe to get 6.0.8alpha runnning smooth.

I checked out the latest code in TRUNK 15953
pointed Apache to the files.

I ran tiki-install.php without problems except the following 3 SQL problems
which I suppose is due to MySQL version 6.0.8alpha

As my SQL skills are not up to date...
Are there any solutions for these bug?

Do not propose, that version 6 of MySQL is not supported :-)

~np~CREATE TABLE tiki_banning (
banId int(12) NOT NULL auto_increment,
mode enum('user','ip') default NULL,
title varchar(200) default NULL,
ip1 char(3) default NULL,
ip2 char(3) default NULL,
ip3 char(3) default NULL,
ip4 char(3) default NULL,
user varchar(200) default '',
date_from timestamp(14) NOT NULL,
date_to timestamp(14) NOT NULL,
use_dates char(1) default NULL,
created int(14) default NULL,
message text,
PRIMARY KEY (banId)
) ENGINE=MyISAM AUTO_INCREMENT=1~/np~
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 '(14) NOT NULL,
date_to timestamp(14) NOT NULL,
use_dates char(1) default NUL' at line 10

~np~CREATE TABLE tiki_friendship_requests (
userFrom varchar(200) NOT NULL default '',
userTo varchar(200) NOT NULL default '',
tstamp timestamp(14) NOT NULL,
PRIMARY KEY (userFrom(120),userTo(120))
) ENGINE=MyISAM~/np~
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 '(14) NOT NULL,
PRIMARY KEY (userFrom(120),userTo(120))
) ENGINE=MyISAM' at line 4

~np~CREATE TABLE tiki_users_score (
user char(200) NOT NULL default '',
event_id char(200) NOT NULL default '',
expire int(14) NOT NULL default '0',
tstamp timestamp(14) NOT NULL,
PRIMARY KEY (user(110),event_id(110)),
KEY user (user(110),event_id(110),expire)
) ENGINE=MyISAM~/np~
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 '(14) NOT NULL,
PRIMARY KEY (user(110),event_id(110)),
KEY user (user(110),ev' at line 5
tracker item
some failed database operations following 3.0beta1 upgrade from 2.2
Doesn't seem to have had any adverse effects but did see these errors when upgrading a test site from 2.2 to 3.0beta1

#2008-10-19 sylvieg
ALTER TABLE tiki_users_score CHANGE event_id event_id char(200) NOT NULL default ''
Specified key was too long; max key length is 1000 bytes
ALTER TABLE tiki_users_score ADD PRIMARY KEY (user(110),event_id(110))
Incorrect sub part key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique sub keys
ALTER TABLE tiki_users_score ADD KEY user (user(110),event_id(110),expire)
Incorrect sub part key; the used key part isn't a string, the used length is longer than the key part, or the storage engine doesn't support unique sub keys
INSERT INTO users_permissions (permName, permDesc, level, type) VALUES ('tiki_p_search_categorized', 'Can search on objects of this category', 'basic', 'category')
Duplicate entry 'tiki_p_search_categorized' for key 1

tracker item
Some people on windows can't figure out how to install composer
tracker item
change the table definitions to support the new utf8mb4 character
tracker item
sql error "specified key was too long" during install with utf-8 InnoDB mysql engine
When my default mysql engine is InnoDB and default charset is utf8, I get these errors both during a clean 3.0 install and during a DB 2.4->3.0 upgrade (excluding duplicate key/item errors):

~pp~
CREATE TABLE `tiki_sefurl_regex_out` (
`id` int(11) NOT NULL auto_increment,
`left` varchar(256) NOT NULL,
`right` varchar(256) NULL default NULL,
`type` varchar(32) NULL default NULL,
`silent` char(1) NULL default 'n',
`feature` varchar(256) NULL default NULL,
`comment` varchar(256),
`order` int(11) NULL default 0,
PRIMARY KEY(`id`),
UNIQUE KEY `left`(`left`(256)),
INDEX `idx1` (silent, type, feature(30))
)
Specified key was too long; max key length is 767 bytes
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-index.php\\?page=(.+)', '$1', 'wiki', 'feature_wiki')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-slideshow.php\\?page=(.+)', 'show:$1', '', 'feature_wiki')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-read_article.php\\?articleId=(\\d+)', 'article$1', 'article', 'feature_articles')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-browse_categories.php\\?parentId=(\\d+)', 'cat$1', 'category', 'feature_categories')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_blog.php\\?blogId=(\\d+)', 'blog$1', 'blog', 'feature_blogs')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_blog_post.php\\?postId=(\\d+)', 'blogpost$1', 'blogpost', 'feature_blogs')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-browse_image.php\\?imageId=(\\d+)', 'browseimage$1', 'image', 'feature_galleries')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_chart.php\\?chartId=(\\d+)', 'chart$1', 'chart', 'feature_charts')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-directory_browse.php\\?parent=(\\d+)', 'directory$1', 'directory', 'feature_directory')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_faq.php\\?faqId=(\\d+)', 'faq$1', 'faq', 'feature_faqs')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-list_file_gallery.php\\?galleryId=(\\d+)', 'file$1', 'file', 'feature_file_galleries')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-download_file.php\\?fileId=(\\d+)', 'dl$1', 'file', 'feature_file_galleries')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_forum.php\\?forumId=(\\d+)', 'forum$1', 'forum', 'feature_forums')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-browse_gallery.php\\?galleryId=(\\d+)', 'gallery$1', 'gallery', 'feature_galleries')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('show_image.php\\?id=(\\d+)', 'image$1', 'image', 'feature_galleries')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('show_image.php\\?id=(\\d+)&scalesize=(\\d+)', 'imagescale$1/$2', 'image', 'feature_galleries')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-newsletters.php\\?nlId=(\\d+)', 'newsletter$1', 'newsletter', 'feature_newsletters')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-take_quiz.php\\?quizId=(\\d+)', 'quiz$1', 'quiz', 'feature_quizzes')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-take_survey.php\\?surveyId=(\\d+)', 'survey$1', 'survey', 'feature_surveys')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_tracker.php\\?trackerId=(\\d+)', 'tracker$1', 'tracker', 'feature_trackers')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-integrator.php\\?repID=(\\d+)', 'int$1', '', 'feature_integrator')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-view_sheets.php\\?sheetId=(\\d+)', 'sheet$1', 'sheet', 'feature_sheet')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`) VALUES('tiki-directory_redirect.php\\?siteId=(\\d+)', 'dirlink$1', 'directory', 'feature_directory')
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)\&calIds\\[\\]=(\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)', 'cal$1,$2,$3,$4,$5,$6,$7', '7', 'calendar', 'feature_calendar', 100)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)\&calIds\\[\\]=(\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)', 'cal$1,$2,$3,$4,$5,$6', '6', 'calendar', 'feature_calendar', 101)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)\&calIds\\[\\]=(\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)', 'cal$1,$2,$3,$4,$5', '5', 'calendar', 'feature_calendar', 102)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)\&calIds\\[\\]=(\\d+)\&callIds\\[\\](\\d+)\&callIds\\[\\](\\d+)', 'cal$1,$2,$3,$4', '4', 'calendar', 'feature_calendar', 103)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)\&calIds\\[\\]=(\\d+)\&callIds\\[\\](\\d+)', 'cal$1,$2,$3', '3', 'calendar', 'feature_calendar', 104)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)&calIds\\[\\]=(\\d+)', 'cal$1,$2', '2', 'calendar', 'feature_calendar', 105)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `comment`, `type`, `feature`, `order`) VALUES('tiki-calendar.php\\?calIds\\[\\]=(\\d+)', 'cal$1', '1', 'calendar', 'feature_calendar', 106)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-calendar.php', 'calendar', 'calendar', 'feature_calendar', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-view_articles.php', 'articles', '', 'feature_articles', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-list_blogs.php', 'blogs', '', 'feature_blogs', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-browse_categories.php', 'categories', '', 'feature_categories', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-list_charts.php', 'charts', '', 'feature_charts', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-contact.php', 'contact', '', 'feature_contact', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-directory_browse.php', 'directories', '', 'feature_directory', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-list_faqs.php', 'faqs', '', 'feature_faqs', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-file_galleries.php', 'files', '', 'feature_file_galleries', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-forums.php', 'forums', '', 'feature_forums', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-galleries.php', 'galleries', '', 'feature_galleries', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-login_scr.php', 'login', '', '', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-my_tiki.php', 'my', '', '', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-newsletters.php', 'newsletters', 'newsletter', 'feature_newsletters', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-list_quizzes.php', 'quizzes', '', 'feature_quizzes', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-stats.php', 'stats', '', 'feature_stats', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-list_surveys.php', 'surveys', '', 'feature_surveys', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-list_trackers.php', 'trackers', '', 'feature_trackers', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-mobile.php', 'mobile', '', 'feature_mobile', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
INSERT INTO `tiki_sefurl_regex_out` (`left`, `right`, `type`, `feature`, `order`) VALUES('tiki-sheets.php', 'sheets', '', 'feature_sheet', 200)
Table 'tiki3.tiki_sefurl_regex_out' doesn't exist
~/pp~

Possibly related bug: http://dev.tikiwiki.org/tiki-view_tracker_item.php?itemId=2346
tracker item
Kaltura-related SQL errors {installing/upgrading to} Tiki 18 alpha populating tiki_secdb
tracker item
SQL-Script for PostgreSQL failed
In the new version of tikiwiki 3.0 is the tiki-3.0-pgsql.sql wrong. It looks like a copy of the mysql file. BUT: not only the pgsql, also the sqlite and oci8-file.

There are still the ENGINE elements, and some special types from mysql like KEY instead of INDEX or Triger for pgsql
tracker item
Suggested htaccess file
And some cleanup of theses pages would be nice:
http://doc.tikiwiki.org/tiki-index.php?page=Rewrite+Rules
http://tikiwiki.org/TikiWikiRewriteRule
tracker item
Suggested shell backup procedure using existing scripts
tiki-backup.php was like performing surgery on yourself. It can work but it's risky.
tracker item
svn update FAILS to update on show.t.o instance linked to dev.t.o bug tracker item
tracker item
switch lang in installer does nothing
tracker item
Switching site language ignored in installer
tracker item
System error when attempting to enable blog comments on a blog created by a profile
tracker item
templates_c is not included in .zip file
In 1.9, templates_c existed with some administrative files (templates_c/index.php, etc.):
http://tikiwiki.cvs.sourceforge.net/tikiwiki/tiki/?pathrev=BRANCH-1-9

Since we moved to SVN, in time for 2.0, this was "lost"
http://tikiwiki.svn.sourceforge.net/viewvc/tikiwiki/branches/2.0/

This causes that people that install TikiWiki via FTP, from zip file, --need to manually create this folder (useless annoyance)-- Actually, it was created by tiki-install.php but I see no reason not bundle this folder.

People that use sh setup.sh to install are OK because this script creates this directory (and others?)

tracker item
templates_c should be part of the .zip (like it was in 1.9.x and before)
A lot of people install with FTP.

They do not have shell access and do not run setup.sh

Up to 1.9.11, templates_c was part of the .zip

However, for some reason, in 2.x and 3.x, --you need to manually create this directory.-- Oups, no, installer created. Nonetheless, the directory is back in 3.0

This should be restored to previous behavior.


1- It should have an index.php to prevent directory browsing
2- ((TRIM)) cleaner should not delete this index.php
3- clear caches in tiki-admin_system.php?do=templates_c should not delete this index.php
tracker item
tempnam() [function.tempnam]: open_basedir restriction in effect
The only things I can see in my home page was some errors :
The first error message on my site was :
{img src=images/code.png}%%% {CODE()}
Warning: tempnam() [function.tempnam]: open_basedir restriction in effect. File(/tmp) is not within the allowed path(s):
(/tmp/:/www/magowiz.net/:/var/lib/php5/:/var/lib/php4/:/usr/share/php:/usr/local/php4/share) in /www/magowiz.net/www/lib/init/initlib.php on line 101
{CODE}

tracker item
Test for PHP5 and provide graceful error message
Suggested message if PHP5 is not detected:

^
__TikiWiki 3.0 requires PHP 5.x__

Your currently detected PHP version is: (versionnumber)

Please contact your web host to request an upgrade. If there is no way you can have PHP 5.x, please use Tiki 2.x instead. Some features in Tiki 2.x, such as profiles and TikiTests require PHP5, but all the other hundreds of features work perfectly with PHP 4.1+

For more information:
http://www.gophp5.org/
http://tikiwiki.org/
^



(9:59:42 AM) marclaporte: turning on TikiTests crashed by site :
(9:59:42 AM) marclaporte: Parse error: syntax error, unexpected T_OBJECT_OPERATOR in /home/profiles/public_html/tiki_tests/tikitestslib.php on line 59
(9:59:53 AM) marclaporte: I suspect because I don't have php5
(10:00:01 AM) marclaporte: http://profiles.tikiwiki.org/
tracker item
Test if the db upgrade script has been run and put a note in tiki-admin.php
This would avoid this type of issue:
http://tikiwiki.org/tiki-view_forum_thread.php?topics_offset=1&forumId=6&comments_parentId=21274

Maybe at each release, we could add one test of the DB to see if the most recent sql additions were done.


phplist does this well. Once click and your DB is in the right format.
tracker item
Test server compatibility / System check tool
I upgraded from php4 to php5. I had some sites with white pages and nothing in the error log.

Finally, it was:

"this web application requires mysqli php extension. We have enabled it and it look ok now."

Tiki could have detected and reported this.

Move discussion here:
((Test server compatibility))
tracker item
Testing if GD or Imagick works, via Tiki
tiki-admin.php?page=gal tells me if GD or Imagick is installed. Nice.

But sometimes, it's installed, but it doesn't work as it should. To rule out that the problem is with Tiki, here is an example of a simple php to test GD in real life. It would be nice to add to tiki-admin.php?page=gal

{img src=images/code.png}%%% {CODE()}
<?php
header("Content-type: image/png");
$im = @imagecreate(110, 20)
or die("Cannot Initialize new GD image stream");
$background_color = imagecolorallocate($im, 0, 0, 0);
$text_color = imagecolorallocate($im, 233, 14, 91);
imagestring($im, 1, 5, 5, "A Simple Text String", $text_color);
imagepng($im);
imagedestroy($im);
?>
{CODE}
tracker item
The installation script should end with an automatic (optional) registration to Tiki.org
tracker item
The version lifecycle is not being respected
tracker item
Theme and Tools for MediaWiki migration
Maybe some of you will think of this as a "marketinhg" thing, but let's face it : for most users on the Web "wiki" is synonym with "MediaWiki-powered sites that look like wikipedia".

What I propose is to create the theme and tools to facilitate migration of mediawiki powered sites to tikiwiki the (very) easy way : fill a form during install that points to the Mediawiki database, and extract all the info to automagically populate the Tiki. I'm willing to participate, but I do not feel I have the required knowledge at this moment to be able to do something useful in the coding part : I know little to no PHP or MySQL stuff, I even wasn't able to install Tiki properly here (shame on me).

tracker item
Tighter integration with Apache's > .htaccess (error messages, etc.)
When you try to access a wiki page which doesn't exist, Tiki offers you a list of similarly named pages, to search for that word, to create the page, etc.

__Good.__

When you try to access other contents in Tiki (articles, blog posts, etc.) that don't exist (either have been deleted, moved, not yet published, protected, etc.), you get a Tiki error message.

__Good as well.__


But what if you try an URL which is just not possible?

Ex.: If you migrated from another system to Tiki and you are still getting hits with the previous URLs?

Of course, you could check your access logs and add nice redirects. But how can we make this easier for site admins?


The bundled _htaccess file (which you need to rename .htaccess to make active) has an example line:
{img src=images/code.png}%%% {CODE()}
ErrorDocument 404 /tiki-index.php?page=Page+not+found
{CODE}

__This is good.__

Now, how could we use this to provide the Tiki admin with a top-x error pages? And thus, it would help to detect broken links, etc.

Could .htaccess include some configuration info from Tiki? So a Tiki admin could add configuration information without using FTP, all in Tiki, possibly with a secret "system" wiki page.

Great inspiration:
https://github.com/h5bp/html5-boilerplate/blob/master/dist/.htaccess
tracker item
Tiki 12 CartoGraf Suggested Icons Source Link No Longer Valid
tracker item
tiki 25.1 Database 'xxxx'. Unable to connect to database (when 25.0 will connect)
tracker item
Tiki 5.0 install with import of 4.2 database - invalid database generated
Hello,

I have reached the end of an installation of 5.0 with à database upgrade by 4.2 installer form a 3.3 site.

To reach this point after one month, I need to find and make the patches of bugs form which 3 on 5 are corrected into the current 5.x (SVN repository)

After I could obtain the home page, this appends :

1 - the "main admin" sends the message :

__INVALID DATABASE run installer__,

2- You run installer again, the installer says __"Database upgraded successfully"__

3- You run normally tikiwiki and then come back to point 1, eternally

If I join documents they can be the HTML page capture from Zotero but I don't think that they will be useful or the .zip of the database (600ko) for test.

I have surely no information to try to understand this issue.

When I try to execute some command I have quite not any command which can be run without an error :
- All displays are like UTF8 on a latin1 display (while Firefox say Page encode UTF8)
- Try to edit user pref : -> system error table ".tiki_trk_1" not found
- Try to display Wiki page or article content : the url called misses any module (*.php) tu run and no query "?" but only a part of the query content (like "http://mysite/<article_name>.

- Modify-edit page or article leads to an empty page

etc.

Trebly
tracker item
Tiki 6.1 and later do not work under IIS 6, while 6.0 did
Using the same IIS web site:
*You can install 6.0 and successfully login as admin.
*Install 6.1 and 6.2 but neither of them are able to login as admin.

Additional details, as per forum post (http://tiki.org/tiki-view_forum_thread.php?comments_parentId=40416&topics_sort_mode=lastPost_desc&forumId=6):
Trying to use TW on our IIS web site. Have followed all references I could find but have not been able to get 6.1 going.

As a test, I have managed to get 6.0 going, so not sure why 6.1 and 6.2 has issues. Any guidance on how to debug this is appreciated.

Thanks.

Details are:
- Win2003 SP2 and IIS6
- MySQL 5.1 (tried both local and remote server)
- PHP 5.2.17
- Firefox 3.6
- No tildes in the URL
- Tried placing TW in the root of the web site and as a virtual directory
- Have granted the EVERYONE user READ,WRITE & MODIFY access to the web root and all sub folders.
- No PHP errors recorded in the PHP error log

Symptoms:
- Install proceeds successfully.
- DB install states that is is successful (both local and remote DB scenarios)
- Prompted with admin change password screen and successfully change the password.
- Prompted with the Home page, then login as admin and new password, only to be presented with the Home page again, which states:
"Congratulations
This is the default homepage for your Tiki. If you are seeing this page, your installation was successful.

You can change this page after logging in. Please review the wiki syntax(external link) for editing details."

- Try clearing cookies, then logging in and are presented with "You have to enable cookies to be able to login to this site".
tracker item
Tiki does not create tables uniformly with collation utf8_unicode_ci
tracker item
Tiki does not install clean on Oracle
many object names too long for oracle which has max size of 30 for any object (column, table, sequence, etc.)

able to modify some items such as sequence and trigger that are internal to db and not in tiki code.

initial oracle-1.9-oci8.sql had many errors including the use of datatype integer and auto-increment which doe not exist in oracle. additional insert to blob column not formed to use oracle utl_raw.cast_to_raw. oracle quote in sql field insert should be two quotes ('') instead of backslash quote (\')

main tables still not available
tiki_content_templates_sections
tiki_forums
because outbound_mails_for_inbound_mails column
tiki_live_support_message_comments

is there a workaround that if I change the object name in the database to be <=30, that the code will not abort.

- Usage of "CLOB" in Oracle different from "Text" in MySQL, so usage of every table has to be checked.
(especially where LOB-Index is used as a reference (e.g. tiki_languages))

- Oracle can not use CLOBs for indices so search functionality has to be checked (fulltext index?)
tracker item
Tiki Install Enter Tiki CSS issues
tracker item
Tiki Install, UI; Redundancy is not require and not nice on the security page
tracker item
Tiki install; Database name doesn't accept uppercase (anymore?), requirement are unstated and the error verbose is wrong
tracker item
Tiki install; The installer was able to detect previous database but unable to see it was populate and it reset existing data
tracker item
Tiki Installer Disabled
When I try to install on kop.bz hosted at unoeuro.com

I got the error below

Warning: tempnam() [function.tempnam]: Unable to access in /var/www/kop.bz/public_html/pjs/lib/init/initlib.php on line 135

Then I have this information
As a security precaution, the Tiki Installer has been disabled. To re-enable the installer:

There is no problem to install Tiki at my localhost

--------------------------
More information
PHP Version 5.2.13PHP Version 5.2.13


mysql

MySQL Support enabled
Active Persistent Links 0
Active Links 0
Client API version 4.1.18
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient

Directive Local Value Master Value
mysql.allow_persistent On On
mysql.connect_timeout 60 60
mysql.default_host no value no value
mysql.default_password no value no value
mysql.default_port no value no value
mysql.default_socket no value no value
mysql.default_user no value no value
mysql.max_links Unlimited Unlimited
mysql.max_persistent Unlimited Unlimited
mysql.trace_mode Off Off

mysqli

MysqlI Support enabled
Client API library version 4.1.18
Client API header version 4.1.18
MYSQLI_SOCKET /var/lib/mysql/mysql.sock

Directive Local Value Master Value
mysqli.default_host no value no value
mysqli.default_port 3306 3306
mysqli.default_pw no value no value
mysqli.default_socket no value no value
mysqli.default_user no value no value
mysqli.max_links Unlimited Unlimited
mysqli.reconnect Off Off
tracker item
Tiki installer does not set site title
Just installed fresh site, set the site title in installer but it didn't work and site displays default "Tiki 3.0" instead.
tracker item
Tiki installer fails with System error after the last step when MyISAM database engine is selected
tracker item
Tiki Installer Requires "The intl PHP Extension"
tracker item
Tiki Installer Security Precaution on Windows installing in document root
Installer is broken on 4.1 in Windows 2008 R2 with the environment described below. At least two of us have exactly the same problem, so the issue is not local to us.

At the bottom is someone else's description as taken off the Installer forum. My experience is exactly the same, except I am running MySQL 5.1.41 instead of 5.1.42.

A third party suggested it has something to do with directory or session permissions, or PHP configs. To test this, I uninstalled tw 4.1 and installed 3.4 in the same environment. 3.4 worked just fine. Then I upgraded to 4.1 over top of it and it reverted to previous bad behavior. So I believe it is a 4.x bug.

I've given this a high priority because the software is unusable if you can't install it, so you probably losing a lot of users.

Here's the other guy's description of the problem:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
I am trying to preform a fresh install of TW4.1 on Windows Server 08 R2, IIS 7.5, PHP 5.2.12 and MySQL 5.1.42. However, after filling in the page for the database information to populate the database, I reach a page entitled

__Tiki Installer Security Precaution__

You are attempting to run the Tiki Installer. For your protection, this installer can be used only by a site administrator.

To verify that you are a site administrator, enter your database credentials (database username and password) here.

If you have forgotten your database credentials, find the directory where you have unpacked your Tiki and have a look inside the db folder into the local.php file.

I enter the 'root' account information and hit 'Validate and Continue'. But it takes me back to the 'Welcome' page. Now any link I hit Takes me to the validation page and I enter the correct user (root) account info and I'm sent back to the 'Welcome' page. The install doesn't want to continue.

If you want, check out www.nerdzone.net to see the site.
tracker item
Tiki release script should indicate what libs were updated since last release
tracker item
Tiki site in a box (Profile Manager)
I think what's needed is a Gallery of "Tiki Sites in a Box". In other words, Tiki sites that are preconfigured to meet a particular kind of needs. The needs should be defined not in terms of features, but in terms of GOALS of the end user or organisation.

This could be a list of descriptions like this:

- I want a site to enable collaboration inside my organisation.
- I want a site to broadcast my ideas to the world and allow people to add to them and comment on them.
- I want a site that will act as an open knowledge base on a particular topic.
- etc...

Each of these could point to an example which would be a "fake" site that could act as a sandbox. People could go to this fake site, play around with it (but not reconfigure it), to see if it's what they are looking for.

This would allow easy single click configuration of Tiki. The user would simply click on one of the items in the Gallery, and the Tiki site would be configured accordingly.

One issue is: what happens if the user choose wrong and later wants to switch to a different model? I guess if no content has been created in the site it's fine, but what if content has already been created and that content is somewhat incompatible with the new model that the user is choosing?


Related:
*[tiki-view_tracker_item.php?itemId=1513|OpenSourceCMS type demo to test/develop and show off profiles]
*[http://info.tikiwiki.org/Use+Cases|Use Cases]

__Moving discussion of this wish to ((Profile Manager))__
tracker item
Tiki Upgrade, Composer; Composer command never complete on a Tiki21x installation from git
tracker item
Tiki upgrade; after a new installation Tiki should warn nicely the admin he needs to rebuild the index (or do it)
tracker item
Tiki Version, 24 Alpha; Was good installing is wrong on update
tracker item
tiki_install.php does not check php parameter memory_limit properly
tiki-install.php reports that memory_limit is not set, when in fact it is set incorrectly

Problem observed on platform: SuSE 10.0, PHP 4.4.0, Apache 2.0.52 (installed with OS)

Steps to re-create:
1. Leave memory_limit at the default value, 8M. in /etc/php.ini
2. Run phpinfo(), verify that memory limit is set to 8m
3. Run the following script, verify that memory_limit is set to 8M.
<?
echo 'memory_limit='.ini_get('memory_limit');
?>

4. Run tiki-install.php. Memory Limit check will report "green" and state that memory limit has not been set.

tracker item
tiki-check.php MySQL SSL test to tiki-check
tracker item
tiki-install only allows 16 characters in database username
tracker item
Tiki-install uncomplete translation
tracker item
tiki-install.php (= upgrade) fails with multitiki on subdirectories
Using tiki 2.1
I login to tiki-install.php as admin, and I see this error message:

Fatal error: Cannot redeclare extracttoppath() (previously declared in /home/httpd/tiki110/db/local.php:64) in /home/httpd/tiki110/db/local.php on line 67


We are using a multitiki in subdirectories
Example:
http://moviments.net/cursos

&

http://moviments.net/ilp

share the same multitiki installation
tracker item
tiki-install.php disables itself but gives error about not being able to do so
This occured during ReleaseProcess192
Check and fix, if real - perhaps dependant on ./setup.sh
tracker item
tiki-install.php should have a note about how to create db/local.php "manually"
If install script fails (for some reason), we should at least let user proceed with manual installation.
tracker item
tiki-install.php spits out many "variable undefined" errors
tiki-install.php spits out many "variable undefined" errors (they are not critical; Tiki will install and work fine).



note: someone please confirm with more details on this.
tracker item
tiki-install.php to create mysql user, mysql database and assign permissions
Like many web applications, to install TikiWiki, you need to have already created your database (via phpMyAdmin or cPanel).

Maybe TikiWiki could handle this task using the mysql root/super user account?


Otherwise, maybe try via cPanel API if available (TRIM as well could try this)

tracker item
tiki-install.php: "Upgrade fix" section should not be offered on fresh install of 12.x
tracker item
tiki-install.php: SELECT patch_name FROM tiki_schema Table 'tikiwiki3.tiki_schema' doesn't exist
Using a fresh checkout of r15460, and a clean database, install script reports:

Success Installation operations executed successfully: 1164 SQL queries.

Operations failed: 1 SQL queries.

SELECT patch_name FROM tiki_schema
Table 'tikiwiki3.tiki_schema' doesn't exist
tracker item
tiki-login.php generates 404 error
Newly created tikiwiki 2.0 site works all the way through setup and initial login. Subsequent http login attempts at http://dev.friendwich.com:100/tiki-login.php return a 404 error.

Expected behavior is a log in page with username/password fields. Actual behavior is 404 error. Oddly, clicking on the URL in this bug report gives the "no input file specified" in Firefox.

I can reproduce this always on firefox or IE7.
tracker item
tiki-mods_admin.php is broken.
As admin, I go to Admin -> Admin mods and select Mods Configuration.

If I Save the Tikiwiki Mods Configuration, I get an error "Notice: this variable may not be empty: username

This prevents me from changing the mods repository.
tracker item
tiki.org 13x : Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
tracker item
TikiInstall: After pushing Install Button, populates DB and then Blank stops... no other page would appear
TikiInstall in 6.0 RC1: After pushing Install Button, populates DB and then Blank stops... no other page would appear.

I have tried 2 Browsers: Chrome and IE7. Both on Windws Vista. The problem persists.

It does this with new database, fresh install. Before I run the install procedure, I make sure the DB is totally empty.

So it is a fresh DB install.

If I re-run the intaller, some SQL errors appear.

If I ignore them, then Tiki cannot be used to finishe set up: An error occured while performing the request" when trying to access the Tiki.

The problem persists if using MySQL Improved (mysqlli), and also using MySql Classic


About the server:
Running in Windows Plaform
128 mb ram
php version 5.2.6
mysql is ok

I have other tikis 5.3 running in same server with no problem.
tracker item
TikiSheet inoperable on 3.0 beta 4 with Company Intranet Profile
Freshly installed TikIWiki 3.0 beta 4 with the Company Intranet Profile.

Created a tiki sheet (either as admin or as a registered user, this happens in both cases).

Tried to insert a column.... it begins and then suddenly takes me to a new sheet labeled:

ERROR:

A SheetId is required.

-----
* __THIS HAPPENS ON SAFARI 3.2 (macOS)__
* __This behavior does not occur under Firefox 3__
tracker item
tikiwiki calls non-existent pear library without checking that library is installed
I have configured "tiki and pear::auth" in the login section of tikiwiki on a server which did not have the pear php libraries installed.
Next time I try to login with a user (not admin), I see a blank page.

This happens because on line 756 of file lib/userslib.php
$a = new Auth("LDAP", $options, "", false, $user, $pass);
just dies without any error message.
tracker item
Trailing backslash at domain in URLs when installed in DocumentRoot
In my installation, on some internal links that are represented in an absolute way, there is a backslash between the domain name and the first slash.

Eg when I try to login on http://mydomain.com/index.php, I get redirected to http://mydomain.com\/tiki-login.php, which the server cannot render.

Clean install of:
MS Windows Server 2003 SE SP2 on x86
Apache 2.2.10
MySQL 5.1.30
PHP 5.2.8
TikiWiki 2.2

Tiki resides directly in the DocumentRoot C:\tiki (as it is a dedicated server).

In tiki-setup.php, there is a line

{img src=images/code.png}%%% {CODE()} $tikiroot = dirname($_SERVER['PHP_SELF']); {CODE}

In the documentation of [http://www.php.net/dirname |((dirname))], they state that since PHP 4.3.0, dirname returns unexpected values. The example implies that on Windows dirname('/x') returns '\'.

Therefore, if you install Tiki in the DocumentRoot, _SERVER['PHP_SELF'] will be '/filename.php' and $tikiroot will be '\'.
tracker item
mysql5.7: ttif.value which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
tracker item
Unable to access themes.tw.o or info.tw.o with IE7
I am unable to access info.tikiwiki.org or themes.tikiwiki.org with IE7. (FF and Opera work fine.) I get the following error:
{CODE()}
Warning: session_start() [function.session-start]: open(/tmp/sess_4bf95c633abfec1c2db078c6c7e6cf23, O_RDWR) failed: Permission denied (13) in /home/themetw/public_html/tiki-setup_base.php on line 279

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/themetw/public_html/tiki-setup_base.php:279) in /home/themetw/public_html/tiki-setup_base.php on line 279
header already sent
{CODE}
tracker item
unable to connect to DB after upgrade to 4.0
Tikiwiki 2.3 was upgraded to 4.0. Upgrade went well, DB connection was found, DB was upgraded, installer locked. TW4.0 is unable to connect to the MySQL5 DB it was able to upgrade seconds before. See: http://tikiwiki.org/tiki-view_forum_thread.php?topics_offset=1&forumId=6&comments_parentId=35478
tracker item
unable to install RC2
Unable to install 5.0 RC2 just after setting the Database Connection I received this:
Fatal error: Undefined class constant 'MYSQL_ATTR_INIT_COMMAND' in C:\wamp\www\tiki-5.0.RC2\installer\tiki-installer.php on line 432
tracker item
Undefined index on trunk (innoDB) new install
tracker item
Update notification: Version 11.2 is still supported. However, a major upgrade to 9.0 is available
tracker item
Update notifier: deal better with SVN installs
tracker item
Update problems
I'm sure that nobody is really trying this, but the doc claims that an upgrade from 1.9 to 4.1 should work. When running the DB upgrade, I've hit four errors:
PHP Fatal error: Call to a member function fetchRow() on a non-object
in /var/www/tiki/installer/schema/20090923_mod_change_category_defaults_tiki.php on line 11, referer: http://dc-dev/spwiki/tiki-install.php

PHP Fatal error: Call to a member function fetchRow() on a non-object
in /var/www/tiki/installer/schema/20091004_last_tracker_items_modules_merge_tiki.php on line 11, referer: http://dc-dev/spwiki/tiki-install.php

PHP Fatal error: Call to a member function fetchRow() on a non-object
in /var/www/tiki/installer/schema/20091019_article_by_rating_modules_merge_tiki.php on line 11, referer: http://dc-dev/spwiki/tiki-install.php

Call to a member function fetchRow() on a non-object
in /var/www/tiki/installer/schema/20091019_last_articles_modules_merge_tiki.php on line 11, referer: http://dc-dev/spwiki/tiki
-install.php


Oops, didn't have alter privs on DB. Not sure if that's why this failed.
tracker item
Update to Tiki >= 5.3 fails on Windows ("Cannot execute queries while other unbuffered queries are active")
On updating Tiki 5.2 and earlier to 6 errors occur during installation.

^Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement
fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO MYSQL_ATTR_USE_BUFFERED_QUERY attribute.^

The problem is discussed [http://tiki.org/tiki-view_forum_thread.php?comments_parentId=39458&topics_offset=5&topics_sort_mode=lastPost_desc&forumId=6|over here]

--
Chealer:
This does not happen upgrading from a clean install of 5.3 to 6.0. But it happens when upgrading from 5.0 to 6.0. The most problematic script appears to be 20100927_better_column_fix_tiki. The first query (getOne() on information_schema) seems to be the sticky unbuffered query sometimes, since the following, second query fails. I tried but couldn't find how to confirm what query is stuck. It's odd that this problem only happens in the installer. getOne() just like query() use fetchAll() so we shouldn't see this problem. Setting MYSQL_ATTR_USE_BUFFERED_QUERY doesn't seem to help. After some 10 hours of debugging I'm under the impression this is a PDO bug. This looks like http://bugs.php.net/bug.php?id=44081 If anyone wants to try fixing, I recommend speaking to me first. The PDO documentation is very poor, making this really difficult.
20100927_better_column_fix_tiki was introduced in 5.3.

I found upgrades would work with PDO in certain environments. I had the bug on PHP 5.2.13 but upgrading to 5.3.3 fixed. PHP 5.3 can use mysqlnd, which I suspect doesn't have this problem. The upgrade worked for me on vanilla PHP 5.3.3 or PHP 5.3.3 from EasyPHP, both with mysqlnd. I have no clue why this problem seems to only affect Windows, but I saw reports of similar problems on Debian etch, so it may not be completely Windows-specific. Anyone who experiences this problem, please report your PHP version, and if you use PHP 5.3, indicate whether you use libmysql or mysqlnd.
tracker item
Update, Database; Error on local MAMP updating a previous Tiki25 database
tracker item
upgrade all databases in a multitiki installation in a single go with console.php
tracker item
Upgrade database gives a blank page
Upgrade database gives a blank page

With PHP memory_limit at: 256 MB.
max_execution_time 60
max_input_time 60

Looks like the upgrade does complete.
When reloading tiki-install.php and skip Install/Upgrade second time it is posible to complete the install.
tracker item
Upgrade from 20 to 21: PHP Fatal error: Uncaught Error: Call to undefined method Tiki\Command\ProfileExport\ActivityRuleSet::setHidden() in lib/core/Tiki/Command/ConsoleApplicationBuilder.php:543
tracker item
upgrade from 6.1 to 13.1 fails
tracker item
Upgrade from 9.x to 12.x headers & footers missing on nextbranding.tiki.org
tracker item
upgrading db with tiki-install.php breaks multitiki installs (removes /templates_c/ ...)
Using latest tikitrunk_svn from today (Jan. 24th, 2009)

I had a tiki site based on trunk from several weeks ago.
I added today another tiki site (using the same tiki files on server, thus using multitiki on subfolders)

Once the 2nd tiki site was up & running, I wanted to check the 1st tiki site, and it was complaining about mysql table missing, etc. So I went to run the "automatic database upgrade" ((doc:Tikiwiki 3)).
It needs to go through tiki-install.php, therefore so I did.
I had an (extracttoppath) issue, so that I attempted to go to tiki-admin.php from site one. The problem then was that tiki-index.php was complaining about:
^
The directory '/home/httpd/tikitrunk/modules/cache/javaoptics' does not exist.
The directory '/home/httpd/tikitrunk/templates_c/javaoptics' does not exist.
^

They seemed to have been deleted by the tiki-install.php script, since they were there a minute ago.
I tried also the other tiki site, and it happened the same, both folders were missing (deleted)

__Is this that tiki-install.php is not multitiki ready?__

---
duplicated bug report (by my mistake :-) ) with [bug2736]
tracker item
Upgrading makes impossible to access the wiki (see http://dev.tikiwiki.org/bug2865)
Steps:

1. Dump MYSQL tikiwiki 3.3 database (lets call "sql33")
2. Create a new environment where put tikiwiki 4.0 files
3. Import the dumped "sql33" into new sql db (lets call "sql40") through command line
4. Start the configurator of tikiwiki 4.0 and use the upgrade db feature.
5. Try to access the new tikiwiki 4.0 installation:

RESULT: Noone user can access the site. The admin also cannot access the site.

6. Try to reset the admin password:

UPDATE `users_users` SET `password`='admin', `hash`= md5('admin') WHERE `login`='admin';

RESULT: The admin cannot access the site.

During the db upgrade some warning happened, but nothing related with the problem above, I think.
I nevertheless post the messages:

INSERT INTO `tiki_menu_options` (`optionId`, `menuId`, `type`, `name`, `url`, `position`, `section`, `perm`, `groupname`, `userlevel`) VALUES (107,42,'s','Newsletters','tiki-newsletters.php',900,'feature_newsletters','tiki_p_list_newsletters','',0)
Duplicate entry '107' for key 1
-- 2009-09-18 lphuberdeau
ALTER TABLE `tiki_transitions` ADD COLUMN guards TEXT NOT NULL DEFAULT '[]'
BLOB/TEXT column 'guards' can't have a default value
UPDATE `users_objectpermissions` SET `permName`=? WHERE `permName`=?
Duplicate entry 'ef988117becd8cd60924ff5b97c73e43-category-Registered-tiki_p_view' for key 1


tracker item
Upgrading to 1.10 from 1.9 version prior to 1.9.8 requires tiki_1.8to1.9.sql
Installer needs to take into account that Upgrading to 1.10 from 1.9 version prior to 1.9.8 requires tiki_1.8to1.9.sql
tracker item
URL Rewriting Revamp: adding to Tiki log or error log so we catch them all through usage
tracker item
USB key version of Tiki
The goal is to have a USB key version of Tiki.

Possible uses:
#Easy testing on a Windows desktop
#Have a backup of your Tiki on your MP3 player
#etc


Possible partners:
http://www.easyphp.org/
http://portableapps.com/apps/development/xampp
http://www.uniformserver.com/
tracker item
User should know maintenance is coming before losing their work (Tiki Manager, php console.php or vcs:update included)
tracker item
Username can't have space in it for messageing system Bug
When user has spaces in their name they can`t use messaging system
try "test user" as username
tracker item
Using preg_replace with /e modifier
Tikiwiki is using preg_replace with /e modifier. On some systems this feature is disabled. You can neither access the installscript nor will there be any emails sent. The email-script simple dies with no further information.
tracker item
UTF-8 warning when upgrading Tiki18 to Tiki19
tracker item
Warning: error
The install seemed to go well, but I get this at the admin login page, and if i log in I get nothing except these three errors. Help please.

-bj




Warning: tempnam() [function.tempnam]: open_basedir restriction in effect. File(/tmp) is not within the allowed path(s): (/var/www/web1/) in /var/www/web1/web/tikiwiki/lib/init/initlib.php on line 95

Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /var/www/web1/web/tikiwiki/lib/init/initlib.php:95) in /var/www/web1/web/tikiwiki/tiki-setup_base.php on line 274

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /var/www/web1/web/tikiwiki/lib/init/initlib.php:95) in /var/www/web1/web/tikiwiki/tiki-setup_base.php on line 274
tracker item
Warning: strpos(): Empty needle in tiki-25.0/lib/cache/memcachelib.php on line 217
tracker item
When system runs out of disk space, Tiki user will not be able to login.
When the system (in this case was a Linux box) runs out of disk space, a Tiki user cannot login. Basically, the user is sent back to the home page. In other words, it looks like the user has authenticated, but is not logged in. So it looks like a PHP session issue. It could well be.

If the user enters a wrong password, a wrong password message is seen.

It would be nice if Tiki could detect that the disk space is low and alert admin users, especially during install. Low priority of course, but still nice to have.

MoinMoin example:
{THUMB(id=29, url="tiki-browse_image.php?imageId=29")}{THUMB}
tracker item
Wiki Ratings doesn't activate upgrading from 1.8.5
Wiki Ratings doesn't activate in wiki pages when turned on in the wiki admin - upgrading from 1.8.5
tracker item
Wishlist from Admin Interface
You can get to help easily enough, but it's kind of hard to find the "wishlist" page.
tracker item
Wrong feedback on database creation using tiki-install where the user exist already
tracker item
xavi
Contributors
tracker item
YAML: one line preference containing operand characters results in PHP fatal error when applying profile
tracker item

Keywords

The following is a list of keywords that should serve as hubs for navigation within the Tiki development and should correspond to documentation keywords.

Each feature in Tiki has a wiki page which regroups all the bugs, requests for enhancements, etc. It is somewhat a form of wiki-based project management. You can also express your interest in a feature by adding it to your profile. You can also try out the Dynamic filter.

Accessibility (WAI & 508)
Accounting
Administration
Ajax
Articles & Submissions
Backlinks
Banner
Batch
BigBlueButton audio/video/chat/screensharing
Blog
Bookmark
Browser Compatibility
Calendar
Category
Chat
Comment
Communication Center
Consistency
Contacts Address book
Contact us
Content template
Contribution
Cookie
Copyright
Credits
Custom Home (and Group Home Page)
Database MySQL - MyISAM
Database MySQL - InnoDB
Date and Time
Debugger Console
Diagram
Directory (of hyperlinks)
Documentation link from Tiki to doc.tiki.org (Help System)
Docs
DogFood
Draw -superseded by Diagram
Dynamic Content
Preferences
Dynamic Variable
External Authentication
FAQ
Featured links
Feeds (RSS)
File Gallery
Forum
Friendship Network (Community)
Gantt
Group
Groupmail
Help
History
Hotword
HTML Page
i18n (Multilingual, l10n, Babelfish)
Image Gallery
Import-Export
Install
Integrator
Interoperability
Inter-User Messages
InterTiki
jQuery
Kaltura video management
Kanban
Karma
Live Support
Logs (system & action)
Lost edit protection
Mail-in
Map
Menu
Meta Tag
Missing features
Visual Mapping
Mobile
Mods
Modules
MultiTiki
MyTiki
Newsletter
Notepad
OS independence (Non-Linux, Windows/IIS, Mac, BSD)
Organic Groups (Self-managed Teams)
Packages
Payment
PDF
Performance Speed / Load / Compression / Cache
Permission
Poll
Profiles
Quiz
Rating
Realname
Report
Revision Approval
Scheduler
Score
Search engine optimization (SEO)
Search
Security
Semantic links
Share
Shopping Cart
Shoutbox
Site Identity
Slideshow
Smarty Template
Social Networking
Spam protection (Anti-bot CATPCHA)
Spellcheck
Spreadsheet
Staging and Approval
Stats
Survey
Syntax Highlighter (Codemirror)
Tablesorter
Tags
Task
Tell a Friend
Terms and Conditions
Theme
TikiTests
Federated Timesheets
Token Access
Toolbar (Quicktags)
Tours
Trackers
TRIM
User Administration
User Files
User Menu
Watch
Webmail and Groupmail
WebServices
Wiki History, page rename, etc
Wiki plugins extends basic syntax
Wiki syntax text area, parser, etc
Wiki structure (book and table of content)
Workspace and perspectives
WYSIWTSN
WYSIWYCA
WYSIWYG
XMLRPC
XMPP




Useful Tools