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

On a Debian Linux 10, Webmin version 1.984, Usermin version 1.834, Virtualmin version 6.17-3 (all latest) I tried to setup a Tiki git clone from master (Tiki24)
PHP 7.4.27


Errors and notice while using setup.sh to install Composer

{CODE()}
Package container-interop/container-interop is abandoned, you should avoid using it. Use psr/container instead.
Package montefuscolo/xmpp is abandoned, you should avoid using it. No replacement was suggested.
Package zendframework/zend-version is abandoned, you should avoid using it. Use ocramius/package-versions instead.
Package zendframework/zendservice-akismet is abandoned, you should avoid using it. No replacement was suggested.
Package phpunit/php-token-stream is abandoned, you should avoid using it. No replacement was suggested.
Package sensiolabs/security-checker is abandoned, you should avoid using it. Use https://github.com/fabpot/local-php-security-checker instead.
{CODE}

{CODE()}
Generating optimized autoload files
Class Rubix\ML\Exceptions\MissingExtension located in ./vendor/rubix/ml/src/Exceptions/MIssingExtension.php does not comply with psr-4 autoloading standard. Skipping.
{CODE}

It will be nice to clean them.

composer.lock needs to updated
* when composer.json is updated
* to get updates on any of our 100+ dependencies

Tiki developers sometimes waste time with this. Let's automate.

It should be ran with the right version of PHP (the lowest supported for that Tiki version)

Also, each branch needs to be run independently (you should't merge the results of one branch in another). So this should be excluded from the script at ((Semi-automatic merging period))

We need a robot SourceForge user name. Ex: tikicibot


One example: (up for discussion):
# Check all changes on composer.json and update immediately composer.lock (because a dev working on something likely wants to see immediate results)
# Update composer.lock every 10 days on supported branches. So we get somewhat frequent updates. Since composer.json is set for semantic versioning, it should not cause regressions.

Also, there is some weirdness where the composer.tiki.org URLs are changed to the external sources like Github.
http://sourceforge.net/p/tikiwiki/code/68089
This automation should keep everything on composer.tiki.org

This should also be done by the release script

{syntax type="tiki" editor="plain"}
Prefs that should be handled differently for:

* ((Redactor))
* ((Connect))
* Some prefs if you copy a site elsewhere and try to run like ((tw:Pre-Dogfood Server))
*** Elastic Search
*** CDN
*** memcache?

{syntax type="tiki" editor="plain"}
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.

Create a profile for an improved Issue Tracker (with linked trackers) using the latest improvements in 14x

See this discussion:
[http://irc.tiki.org/irclogger_log/tikiwiki?date=2015-03-17,Tue&sel=180#l176]

Like:
https://drupal.org/project/poormanscron

Useful for ((Update notifier)), Newsletter throttling, etc.

-------------------

{sign user="pascalstjean" datetime="2013-09-10T19:31:34+00:00"}
This will be important in order to make Unified Index default in Tiki (reindexing of the site every week or so)

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?

{syntax type="tiki" editor="plain"}
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 upgraded a Tiki21.5 from the release package to a 21.8.
Database upgrade failed with the following errors:

^
Update completed.
Failed: 20120423_add_page_refs_tiki
Failed: 20151203_tiki_score_revamp_tiki
Queries executed successfully: 14
Error in 20120423_add_page_refs_tiki
ALTER TABLE tiki_page_references ADD UNIQUE INDEX uk1_tiki_page_ref_biblio_code (page_id, biblio_code)
Duplicate key name 'uk1_tiki_page_ref_biblio_code'
Error in 20120423_add_page_refs_tiki
ALTER TABLE tiki_page_references ADD INDEX idx_tiki_page_ref_title (title)
Duplicate key name 'idx_tiki_page_ref_title'
Error in 20120423_add_page_refs_tiki
ALTER TABLE tiki_page_references ADD INDEX idx_tiki_page_ref_author (author)
Duplicate key name 'idx_tiki_page_ref_author'
Error in 20151203_tiki_score_revamp_tiki
ALTER TABLE tiki_score ADD COLUMN reversalEvent varchar(255)
Duplicate column name 'reversalEvent'
Error in 20151203_tiki_score_revamp_tiki
# Insert old values from tiki_score into new format
# Insert user stuff. Login, message, friend pts.
INSERT INTO tiki_score (event, data)
SELECT "tiki.user.login" AS event, concat('[{"ruleId":"User logs in","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='login'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.user.view" AS event, concat('[{"ruleId":"See other user''s profile","recipientType":"user","recipient":"user","score":"',max(case when event = 'profile_see' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Have your profile seen","recipientType":"user","recipient":"object","score":"',max(case when event = 'profile_is_seen' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.user.friend" AS event, concat('[{"ruleId":"Make friends","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='friend_new'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.user.message" AS event, concat('[{"ruleId":"Send message","recipientType":"user","recipient":"user","score":"',max(case when event = 'message_send' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Receive message","recipientType":"user","recipient":"object","score":"',max(case when event = 'message_receive' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
# Articles
INSERT INTO tiki_score (event, data)
SELECT "tiki.article.create" AS event, concat('[{"ruleId":"Publish new article","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='article_new'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.article.view" AS event, concat('[{"ruleId":"Read an article","recipientType":"user","recipient":"user","score":"',max(case when event = 'article_read' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Have your article read","recipientType":"user","recipient":"author","score":"',max(case when event = 'article_is_read' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
# File Gallery
INSERT INTO tiki_score (event, data)
SELECT "tiki.filegallery.create" AS event, concat('[{"ruleId":"Create new file gallery","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='fgallery_new'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.file.create" AS event, concat('[{"ruleId":"Upload new file to gallery","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='fgallery_new_file'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.file.download" AS event, concat('[{"ruleId":"Download other user''s file","recipientType":"user","recipient":"user","score":"',max(case when event = 'fgallery_download' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Have your file downloaded","recipientType":"user","recipient":"owner","score":"',max(case when event = 'fgallery_is_downloaded' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
# Image Gallery
INSERT INTO tiki_score (event, data)
SELECT "tiki.imagegallery.create" AS event, concat('[{"ruleId":"Create new image gallery","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='igallery_new'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.image.create" AS event, concat('[{"ruleId":"Upload new image to gallery","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='igallery_new_img'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.image.view" AS event, concat('[{"ruleId":"See other user''s image","recipientType":"user","recipient":"user","score":"',max(case when event = 'igallery_see_img' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Have your image seen","recipientType":"user","recipient":"owner","score":"',max(case when event = 'igallery_img_seen' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
#Blogs
INSERT INTO tiki_score (event, data)
SELECT "tiki.blog.create" AS event, concat('[{"ruleId":"Create new blog","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='blog_new'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.blogpost.create" AS event, concat('[{"ruleId":"Post in a blog","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='blog_post'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.blog.view" AS event, concat('[{"ruleId":"Read other user''s blog","recipientType":"user","recipient":"user","score":"',max(case when event = 'blog_read' then score else 0 end),'","validObjectIds":[""],"expiration":""},{"ruleId":"Have your blog read","recipientType":"user","recipient":"author","score":"',max(case when event = 'blog_is_read' then score else 0 end),'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score limit 1
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
# Wikis
INSERT INTO tiki_score (event, data)
SELECT "tiki.wiki.create" AS event, concat('[{"ruleId":"Create a wiki page","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='wiki_new'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.wiki.update" AS event, concat('[{"ruleId":"Edit an existing wiki page","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='wiki_edit'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
INSERT INTO tiki_score (event, data)
SELECT "tiki.wiki.attachfile" AS event, concat('[{"ruleId":"Attach file to wiki page","recipientType":"user","recipient":"user","score":"',score,'","validObjectIds":[""],"expiration":""}]') AS data FROM tiki_score WHERE event='wiki_attach_file'
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
# Remove unnecessary fields
ALTER TABLE tiki_score DROP COLUMN score
Can't DROP 'score'; check that column/key exists
Error in 20151203_tiki_score_revamp_tiki
ALTER TABLE tiki_score DROP COLUMN expiration
Can't DROP 'expiration'; check that column/key exists
Error in 20151203_tiki_score_revamp_tiki
ALTER TABLE tiki_score DROP COLUMN validObjectIds
Can't DROP 'validObjectIds'; check that column/key exists
Error in 20151203_tiki_score_revamp_tiki
# Import legacy score from users table
INSERT INTO tiki_object_scores (triggerObjectType, triggerObjectId, triggerUser, triggerEvent, ruleId, recipientObjectType, recipientObjectId, pointsAssigned, pointsBalance, date)
SELECT 'legacy_score', '0', login, 'tiki.legacy.score', 'Legacy Score', 'user', login, score, score, UNIX_TIMESTAMP() FROM users_users
Unknown column 'score' in 'field list'
Error in 20151203_tiki_score_revamp_tiki
# Drop users score column, we now use pointsBalance from tiki_object_scores table
ALTER TABLE users_users DROP COLUMN score
Can't DROP 'score'; check that column/key exists
^

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.

http://info.tiki.org/demo promotes the demo sites.

And a lot of people use so they are __very messy__. After a while, they become unusable. And a bad impression of Tiki.

In the past, it was important to keep the demo sites for a certain time because people would use them to demonstrate bugs. But now that we have ((tw:show.tiki.org)), it's no longer important.

Ideally, there would be a pop-up or something indicating when the next refresh will happen. Otherwise, some people may have data reset while they are working on it. But in practice, this is quite rare. As long as hour of refresh is indicated on demo.tiki.org, it's good. So a daily refresh would be OK I think, but it could also be weekly.

Once the demo site is refreshed, the script to set the password to 12345 should be run. And users should not have to go through the admin reset routine. So beyond setting the password to 12345, the script should do what it takes for Tiki not to think the admin password needs to be changed. This is a problem we have on ((show.tiki.org))

Discussion here: ((BOM))

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)

Double check that User Tracker Profile works as expected also in 15.x, since I got some feedback that it might not be working.
---
Please, see this page as anon:
http://xavi-9794-5865.show.tikiwiki.org/tiki-register.php#contentCustom_info-1

And read these instructions:
http://xavi-9794-5865.show.tikiwiki.org/tiki-index.php?page=User_Trackers#step2

The tricky thing was to use the right profile, which I updated a few years ago with some extra fields for demonstration purposes. Called "User_Trackers" (non-intuitive, imho, but it was not me the first author of that profile):
https://profiles.tiki.org/User_Trackers

And that is the one included in the ((doc:Profiles Wizard)) since Tiki12 (the ((doc:Wizards)) are your friends!")

This other one is not working properly (or uncomplete, and untested in recent tiki versions):
https://profiles.tiki.org/User_Tracker

The progress bar seams to run in two times when installing tiki, firstly It runs from zero up to 89+ % and than It runs down till 8% and restart increasing for the second time up to 100%

I use Firefox 65.0.1

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.

Maybe a server config issue? Packages are new so perhaps not yet robust to diverse use cases.

{syntax type="tiki" editor="plain"}
File ===installer/schema/20120429_fix_collation_tiki.php=== contains an error on line 20:

*if ( $results= $installer->fetchAll('SELECT DISTINCT(TABLE_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = ?', $dbs_tiki)

If the DB name has a character in it such as a dash, this returns FALSE and the script (incorrectly) reports that the MySQL version is too old.

I just hardcoded my DB name into the query, but the following code patch ''should'' work:
*if ( $results= $installer->fetchAll("SELECT DISTINCT(TABLE_NAME) FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = '$dbs_tiki'")

This problem has burned at least one other person, as can be seen on the forum: http://tiki.org/tiki-view_forum_thread.php?forumId=6&threadId=50478&comzone=show&display=&fullscreen=&PHPSESSID=

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

After applying a profile in 20.x, plenty of ugly error message notices are shown, regarding inability to create plenty of cache files:

Things like:
{QUOTE()} Error
Cache file temp/cache/module8756ab3c25fd45a0a55957e6d7bb1f16 is not writable
{QUOTE}

Very bad image for any one testing a brand new tiki site, and clicking for instance at any of the featured profiles.

On a Tiki 16.3 I did :
{CODE()}svn switch https://svn.code.sf.net/p/tikiwiki/code/branches/17.x .{CODE}

Then I did:

{CODE()}sh setup.sh{CODE}
Option c to update composer.

[ErrorException]
rename(/root/.composer/cache/composer-temp.phar,temp/composer.phar): No such file or directory

I retried, did another try on a different tiki after I deleted the folder "vendor" before switching. Same.

I deleted manually "composer.phar " and retried.

The error is gone but another came up:

- Installing matthiasmullie/minify (1.3.44): Loading from cache

[ErrorException]
file_put_contents(/var/www/virtual/xn--8dbcma7a7ale.com/bin/minifycss): failed to open stream: No such file or directory

In /var/www/virtual/xn--8dbcma7a7ale.com/bin/ I have wrong symlink:

lessc -> ../vendor/oyejorge/less.php/bin/lessc
minifycss -> ../vendor/matthiasmullie/minify/bin/minifycss
minifyjs -> ../vendor/matthiasmullie/minify/bin/minifyjs

I corrected minifycss and minifyjs to look into "../vendor_bundled/vendor/matthiasmullie/..."

Run setup.sh again and it complete the instal with 2 last warning:

- Applying patches for adodb/adodb-php
../installer/composer-patches/adodb-php__remove_references_to_adodb_extension.patch (Remove references to ADOdb Extension)
Could not apply patch! Skipping. The error was: Cannot apply patch ../installer/composer-patches/adodb-php__remove_references_to_adodb_extension.patch
../installer/composer-patches/adodb-php__remove-the-check-if-the-adodb-php_ext-is-enabled.patch (Remove the check for ADOdb Extension)
Could not apply patch! Skipping. The error was: Cannot apply patch ../installer/composer-patches/adodb-php__remove-the-check-if-the-adodb-php_ext-is-enabled.patch

- Installing jquery/jquery-sheet (3.1): Loading from cache
- Applying patches for jquery/jquery-sheet
../installer/composer-patches/jquery-sheet_fix-visibility-issues.patch (Fix visibility issues)
Could not apply patch! Skipping. The error was: Cannot apply patch ../installer/composer-patches/jquery-sheet_fix-visibility-issues.patch

I though it was done but no:

Fatal error: Uncaught exception 'Symfony\Component\DependencyInjection\Exception\InvalidArgumentException' with message 'You cannot set service "service_container".' in /var/www/virtual/xn--8dbcma7a7ale.com/vendor_bundled/vendor/symfony/dependency-injection/Container.php:170 Stack trace: #0 /var/www/virtual/xn--8dbcma7a7ale.com/temp/cache/container.php(33): Symfony\Component\DependencyInjection\Container->set('service_contain...', Object(TikiCachedContainer)) #1 /var/www/virtual/xn--8dbcma7a7ale.com/lib/init/initlib.php(84): TikiCachedContainer->__construct() #2 /var/www/virtual/xn--8dbcma7a7ale.com/lib/tikilib.php(59): TikiInit::getContainer() #3 /var/www/virtual/xn--8dbcma7a7ale.com/installer/tiki-installer.php(741): TikiLib::lib('smarty') #4 /var/www/virtual/xn--8dbcma7a7ale.com/tiki-install.php(96): include_once('/var/www/virtua...') #5 {main} thrown in /var/www/virtual/xn--8dbcma7a7ale.com/vendor_bundled/vendor/symfony/dependency-injection/Container.php on line 170

---

I check on tiki install side after entering credentials, same :

Fatal error: Uncaught exception 'Symfony\Component\DependencyInjection\Exception\InvalidArgumentException' with message 'You cannot set service "service_container".' in /var/www/virtual/xn--8dbcma7a7ale.com/vendor_bundled/vendor/symfony/dependency-injection/Container.php:170 Stack trace: #0 /var/www/virtual/xn--8dbcma7a7ale.com/temp/cache/container.php(33): Symfony\Component\DependencyInjection\Container->set('service_contain...', Object(TikiCachedContainer)) #1 /var/www/virtual/xn--8dbcma7a7ale.com/lib/init/initlib.php(84): TikiCachedContainer->__construct() #2 /var/www/virtual/xn--8dbcma7a7ale.com/lib/tikilib.php(59): TikiInit::getContainer() #3 /var/www/virtual/xn--8dbcma7a7ale.com/installer/tiki-installer.php(741): TikiLib::lib('smarty') #4 /var/www/virtual/xn--8dbcma7a7ale.com/tiki-install.php(96): include_once('/var/www/virtua...') #5 {main} thrown in /var/www/virtual/xn--8dbcma7a7ale.com/vendor_bundled/vendor/symfony/dependency-injection/Container.php on line 170

{syntax type="tiki" editor="plain"}
While creating a themed Tiki27 it is the second time (I have 2 Tiki27 🤗) I hit this error while running "npm run watch".

Error: ENOSPC: System limit for number of file watchers reached

May be it is possible to address this on our System Builder ?