Category: 12.x

Customized Homepage with profile "Personal Blog and Profile" cannot be reverted back to wiki homepage

To reproduce, apply this profile and attempt to revert back the custom homepage to use wiki homepage.

It didn't work either by means of setting a new homepage for registered users.
---
Reproduced here:
http://xavi-9794-5348.show.tikiwiki.org/tiki-view_blog.php?blogId=1

Custom homepage disabled, but anonymous visitors still get the blog homepage:
http://xavi-9794-5348.show.tikiwiki.org/tiki-view_blog.php?blogId=1

To logi:
u: admin
p: 12345

---
Reproduced in Tiki13 also.

I'm trying to upgrade a Tiki 12.9 site to Tiki 15.5 site. Composer runs fine, but when updating database I got several erros after run this command:

{CODE(colors="shell",wrap=0,ln=1)}
php console.php database:update
{CODE}

!! Error

{CODE(caption="php console.php database:update" theme="default")}Error 0 in 20151203_tiki_score_revamp_tiki
#Add needed columns
ALTER TABLE tiki_score change event event varchar(255); #increase varchar length
ALTER TABLE tiki_score ADD COLUMN data TEXT
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ALTER TABLE tiki_score ADD COLUMN data TEXT' at line 3
Error 1 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 'data' in 'field list'
Error 2 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 'data' in 'field list'
Error 3 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 'data' in 'field list'
Error 4 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 'data' in 'field list'
Error 5 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 'data' in 'field list'
Error 6 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 'data' in 'field list'
Error 7 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 'data' in 'field list'
Error 8 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 'data' in 'field list'
Error 9 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 'data' in 'field list'
Error 10 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 'data' in 'field list'
Error 11 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 'data' in 'field list'
Error 12 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 'data' in 'field list'
Error 13 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 'data' in 'field list'
Error 14 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 'data' in 'field list'
Error 15 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 'data' in 'field list'
Error 16 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 'data' in 'field list'
Error 17 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 'data' in 'field list'
Error 18 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 'data' in 'field list'
Error 19 in 20151203_tiki_score_revamp_tiki
#remove old scores from the tiki_score table
DELETE FROM tiki_score WHERE data is null
Unknown column 'data' in 'where clause'
{CODE}

!! System details

1. MySQL version
{CODE(colors="shell",wrap=0,ln=1)}
root@45af11331f6a:/# mysql --version
mysql Ver 15.1 Distrib 10.2.10-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2

root@45af11331f6a:/# mysqld --version
mysqld Ver 10.2.10-MariaDB-10.2.10+maria~jessie for debian-linux-gnu on x86_64 (mariadb.org binary distribution)
{CODE}

2. PHP Version
{CODE(colors="shell",wrap=0,ln=1)}
root@6575eef728ba:/var/www/html# php --version
PHP 5.6.33 (cli) (built: Jan 9 2018 02:55:39)
Copyright (c) 1997-2016 The PHP Group
Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
with Zend OPcache v7.0.6-dev, Copyright (c) 1999-2016, by Zend Technologies
with Xdebug v2.5.5, Copyright (c) 2002-2017, by Derick Rethans
{CODE}

3. PHP modules
{CODE(colors="shell",wrap=0,ln=1)}
root@6575eef728ba:/var/www/html# php -m
[PHP Modules]
apcu
calendar
Core
ctype
curl
date
dom
ereg
fileinfo
filter
ftp
gd
hash
iconv
json
libxml
mbstring
mcrypt
memcached
mysqli
mysqlnd
openssl
pcre
PDO
pdo_sqlite
Phar
posix
readline
Reflection
session
SimpleXML
SPL
sqlite3
standard
tokenizer
xdebug
xml
xmlreader
xmlwriter
Zend OPcache
zip
zlib

[Zend Modules]
Xdebug
Zend OPcache
{CODE}

Uploading of all files and pictures in file gallery root is the default for adding files to blogs. This tends to lead to a real messed up gallery. And leaving the user alone with navigation towards a special folder starting with gallery root every time will not work - nor did ever :-/.
Wouldn't it be nice to have the possibility to predefine a default folder for some functions - i.e. "Default folder for files and images of this blog" in every blogs "General options" tab? Giving there a path will lead to (or create, if not present) a subfolder into file gallery that will become the default path of every upload dialog in this blog.
In similar ways, default paths could be imagined to be added to a number of other functions.

''__To Do:__''
• Add a new property "DefaultFilePath" to blogs.
• Add a new input filed of type text/file path to general setting in blogs. Save into DefaultFilePath of blog
• "Save to…" file picker of "choose or upload images" or "choose or upload files" (which in fact is the same function) in blog editor will use this value as preset path.
• Tidy up: Reduce blog editors menu entries "choose or upload images" and "choose or upload files" to a single "upload image or file"

In 1.10 now we can set to login as e-mail and display realname wherever possible. But the user wiki page by default is set to 'UserCreate<e-mail>. We should still allow user to create his page with 'UserCreate<username/real name>'.

The recommended behaviour should be if user chooses e-mail to be private or it could be if admin sets to disaply realname wherever possible, then it should use 'UserCreate<realname>' other cases it can be based on e-mail.

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

I don't know why but images can not be uploaded to a text area (bug tracker text area in dev.t.o). File gallery view is elFinder, and response is:

{QUOTE()}
Invalid backend response. data is empty
{QUOTE}

See screenshot:
{img fileId="580"}
---
Yes, fixed, thanks. {sign user="xavi" datetime="2013-11-16T17:03:37+00:00"}

I don't know whether this is a regression or not, but we've just seen in dev.t.o tracker5 that the edition of field 'volunteered to solve' in an item doesn't show up in the item history

Example:
https://dev.tiki.org/item4918

At some point, Pascal (I guess) added robertplummer in the field 'Volunteered to solve' after I created the tracker item. This change is not shown in the tracker item history.
https://dev.tiki.org/tiki-tracker_view_history.php?itemId=4918

I uploaded a screenshot to a tracker item ([item5044]).

I tried to Draw on it the url
provided by the edit icon after the image:
http://dev.tiki.org/tiki-edit_draw.php?fileId=672

And I lost control over the popup window. I can't click anywhere to gain control over the popup.

{img fileId="673"}

Related to [item5044]: "dev.t.o: Can't upload images with elFinder"?

To reproduce:
* go to ((Make a wish))
* click at the icon to "Choose or upload images"
+ The pop up window entitle "Browse Files" will show up, with the elFinder interface.
* Click at the Button to upload files (disk icon with a green "plus" sign)
+ the focus goes to the search box, and the user can't do anything else than write into the search box. You can't close the popup window, nor move it, nor resize it.
* If you close the browser window, you'll loose all the information you already typed in the text area (it happened to me once :-/ )

Reproduced with Chrome and Firefox.

{img fileId="672"}
---
Retest:
{img fileId="699" thumb="y" rel="box[g]"}

There might be many emails from the bug tracker in dev.t.o (like in other tiki sites with heavy activity in one or several trackers).

Notification emails come with this type of common subject:
{CODE()}
"[Bugs & Wish list] (Tracker was modified at dev.tiki.org by userfoo)"
{CODE}

And content of the changed item brings the changed fields, but if there is no change in the title of the bug tracker (the first "isMain" field), the user getting the message still has no clue about the changed item.

Proposed solution:
* Add a new option in trackers to include the first "isMain" field (the first field linked to the full item view) in:
## the notification email subject first, before or instead the string needed for email filters "".
## the content of all emails frmo changes in items from that tracker

This would allow people like me, to clearly identify in which tracker items I'm requested to take some action, or help on the follow up on some topics, when you get many emails from the same source and currently with too similar subjects.

I tried to sort by priority in the bug tracker, but it doesn't list by number. So the priorities listed are
90
9
81
8

{img fileId="542"}

When displaying diff and you have some non-ascii characters in page content, e.g. "é" in French language or others, the characters do not show up in the diff output anymore. It happens when viewing diff in page history and also in the email notifications when you watch a page. The rest of the page source displays them though so it is only happening in the diff part.
Example of page with missing characters in diff:
http://tiki.org/tiki-pagehistory.php?page=Home,cs&history_offset=1&diff_style=sidediff&diff_style=sidediff&show_all_versions=y&compare=Compare&newver=0&oldver=23&tra_lang=sq&paginate=on&history_pagesize=50

When using the comment rating feature as described in [http://doc.tiki.org/Rating] -> "Users ratings in Comments", everything looks and works fine as long as I'm logged in as an administrator, but as soon as I'm logged in as a standard registered user, I cannot see the rating results anymore.

The obvious solution according to the documentation would be to just activate tiki > tiki_p_ratings_view_results for registered users.
The problem here is that this option cannot be chosen in the permissions' section - even when also the permissions for disabled features ared shown.

Use case: LDAP setups with numeric ID's for usernames: the admin needs to be able to switch to some user's account to check that settings and perms are as expected for that usergroup, etc. I know the co-worker names, but I don't know their ID's in the setup, other than manually checking at the users list and infer it's name from their email.

This line seems to control it at the template for the login box module:
{CODE()}
{autocomplete element="#login-switchuser_"|cat:$module_logo_instance type="username"}
{CODE}

which implies that there is a function.autocomplete.php smarty_tiki file.

I managed to make the userrealname display in the dropdown box. But I need that userrealname as label, while keeping the username as option to be used internally (otherwise the switch user does not work, as far as I could see)

1st attempt:
-------------------
I tried with this type of syntax, but it didnt' work:
{CODE()}
{autocomplete element="#login-switchuser_"|cat:$module_logo_instance type="userrealname" options="label:userrealname,value:username"}
{CODE}

since that is what I understood from here:
http://api.jqueryui.com/autocomplete/#option-source


2nd attempt:
-------------------
I also tried modifying function.autocomplete.php and the
mod-login_box.tpl to end up producing this syntax (as I could see in the
html source of the produced page):
{CODE()}
$("#login-switchuser_2").tiki("autocomplete", "userrealname", { source:[label:"userrealname",value:"username"] });
{CODE}

but it didnt' work either.

---


Any tips on how to write it in the proper jquery and smarty syntax?

Display Realname instead of login at the ((doc:Action Log)) for admins or non-admins with permission to see log reports (teachers seeing reports of their students, project managers seeing reports on their workers, etc)

For those cases (such as LDAP in which username can be just a numeric ID of the user but RealName is the meaningful info/name for that user) where the tiki admin chose to display Realname instead of login where possible.

Setting, for instance, at : tiki-wizard_admin.php?&stepNr=17&url=index.php (Set up User & Community features):
user_show_realnames : "Show user's real name instead of login (when possible)"

When nested more times, it stops working and breaks the whole page parsing.
This works:
{CODE()}{DIV(class="level1")}
{DIV(class="level2")}
{DIV(class="level3")}
{DIV(class="level4")}
{DIV(class="level5")}
{DIV(class="level6")}
{DIV(class="level7")}
Foo Bar
{DIV}
{DIV}
{DIV}
{DIV}
{DIV}
{DIV}
{DIV}{CODE}

This breaks:
{CODE()}{DIV(class="level1")}
{DIV(class="level2")}
{DIV(class="level3")}
{DIV(class="level4")}
{DIV(class="level5")}
{DIV(class="level6")}
{DIV(class="level7")}
{DIV(class="level8")}
Foo Bar
{DIV}
{DIV}
{DIV}
{DIV}
{DIV}
{DIV}
{DIV}
{DIV}{CODE}

See the SHOW instance.

__Expected behaviour:__
Parsing nested plugins should work flawlessly no matter how many levels are nested or be limited to e.g. 20 levels (ideally should be configurable) but should not break up to that max level; only if above the limit, it could show the unparsed syntax instead of breaking whole content rendering.

doc.t.o 12.x: print structure ("Tiki Reference Guide") stops after a two pages only or so.

Structure toc is something like this:
{CODE()}
Admin Home
General Admin
General Preferences
General Settings
...
...
{CODE}

and page General Preferences is the last one shown.
Url was like [https://doc.tiki.org/tiki-print_multi_pages.php?printstructures=%255B%25223610%2522%255D&find=&print=Print|this one]

In addition, tabs in the shown pages do not work. Maybe because js comes loaded at the end, and page didn't finish loading?

In any case, the best option for tabs in multiprint is that the __notabs__ option should be automagically implied when doing a multiprint.

doc.t.o 12.x: Printing a structure to PDF produces a PDF with "Your access to this page has expired"

Example:
"Tiki Reference Guide" at https://doc.tiki.org/tiki-print_pages.php

{img fileId="583"}

{syntax type="tiki" editor="plain"}
doc.t.o using 12.x r48406: tag cloud module shows as list & with ' ' between tags when in .s5 slideshow.

Example, for module freetags_most_popular :
http://doc.tiki.org/show:Documentation#s2

::{img fileId="576"}::

Using this code:
{CODE()}
{module module="freetags_most_popular" type="cloud" max="75" notitle="y"}
{CODE}

Another one, for plugin rss:
http://doc.tiki.org/show:Documentation#s7

::{img fileId="577"}::

produced with this:
{CODE()}
{rss id="1" max="10" date="1" showtitle="0"}
{CODE}

I saw this error when visiting this url: http://doc.tiki.org/preview564

{CODE()}
( ! ) Notice: MemcachePool::set() [<a href='memcachepool.set'>memcachepool.set</a>]: Server 127.0.0.1 (tcp 11211, udp 0) failed with: SERVER_ERROR object too large for cache (3) in /path/lib/cache/memcachelib.php on line 169
Call Stack
# Time Memory Function Location
1 0.0004 797536 {main}( ) ../route.php:0
2 0.0016 1069608 include( '/path/tiki-download_file.php' ) ../route.php:245
3 3.6856 80335592 Cachelib->cacheItem( ) ../tiki-download_file.php:369
4 3.6856 80335592 CacheLibMemcache->cacheItem( ) ../cachelib.php:44
5 3.6856 80335768 Memcachelib->set( ) ../cachelib.php:387
6 3.6856 80336192 set ( ) ../memcachelib.php:169
{CODE}

{img fileId="720" thumb="y" rel="box[g]"}

{syntax type="tiki" editor="plain"}
Background info:
http://tiki.org/tiki-view_forum_thread.php?comments_parentId=46281

So when you visit http://doc.tiki.org/Features, the actual list of features comes and goes.

You can see from the video below (I put a watch alert on that page) that it has been going on for months:
{flash type="url" movie="display251" width="1126" height="528"}

To reproduce, visit:
https://doc.tiki.org/tiki-index.php?page_ref_id=4565#Translation_through_Tiki_interface_database_

Then, click "print", and you will be at:
https://doc.tiki.org/tiki-print.php?page_ref_id=4565

But showing HomePage instead of
https://doc.tiki.org/tiki-print.php?page=Interface+translation

The help button in the Activity Stream plugin points to http://doc.tiki.org/PluginActivityStream
This page does not exist.

"File Galleries configuration templates" is an option in the General Settings. But there is no help icon and the documentation at https://doc.tiki.org/File+Gallery+General+Settings has no information.

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