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

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..

This error was seen when using PHP4

Tiki should detect and provide better error message

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.

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;

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 ).

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?

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?

Contributors

Contributors

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

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.

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.

Contributors

Contributors

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.

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.

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

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?

~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~

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!

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?

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?

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.

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.

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

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.

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).

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.

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.

Perhaps this should be user choice?

So user can avoid this step if there is a problem.

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.

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.

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}

Contributors

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.

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.

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?

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.

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

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.

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

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.

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)

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.

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].

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.

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

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)

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.

I have cvs update a previous tw1.10 the folder fckeditor is missing from the lib.

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')

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.

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.
...

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

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=

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

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

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

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.

subtitles and topline have 255 characters so why is title limited?

{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,)/}

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_

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.