Category: Score

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;

This should be migrated to the community site, and handled with ((doc:Organic groups)) and ((doc:User Trackers))

This should be migrated to the community site, and handled with ((doc:Organic groups)) and ((doc:User Trackers))

Nowadays the voting on forums is confusing in educational or e-democracy scenarios, since it's not easy to understand why a voting of ! makes just 0.40, or a voting of 5 make 1.60, etc. as it may happen nowadays, since voting on forums seems to be linked to karma or score system.

There should be an option to unlink them, so taht a vote of 1, makes 1, and an option of 5 makes 5 to be included in the mean which is shown at the end on the rate value.

9x dev.t.o/t5: Plain registered users can't rate tracker items; admins can. Obj & Global Perms seems ok though: bug?

Example:
As user xavi (plain regitered user) I added this bug report:
http://dev.tiki.org/tiki-view_tracker_item.php?trackerId=5&itemId=4330

I click on the stars field (field 62: Rating Stars (system) ) and my rating is not shown.

If I login as a user with admin privileges, then I can see the average rating, and I can rate also that item.

As user "xavi" (plain registered user, I mean, not a user with admin privileges, etc), I created a new bug report here at dev.t.o/t5. Once saved, I attempted to:
* click at the Rating field - Stars (system), and I saw no effect.
* edit the tracker item, and clicked at one radio button option, and saved, but saw no effect.
In both cases, I still see that zero votes have been casted, etc.

As far as I remember, the choice of the user was stored, and showed somehow highlighted or similar. Nowadays, it seems as if nothing is stored.

Reproduced, as example, here:
http://dev.tiki.org/tiki-view_tracker_item.php?trackerId=5&itemId=4361

I confirm that these perms are granted to registered users on the tracker object permissions, as well as at global permissions:
* Can view rating result for tracker items (tiki_p_tracker_view_ratings)
* Can vote a rating for tracker items (tiki_p_tracker_vote_ratings)
* Can re-vote a rating for tracker items (tiki_p_tracker_revote_ratings)

The scoring system is untranslatable as a whole.

It relies on labels written in English, and unlike some module parameters, where translators can mock the interface by rendering the translation in the explanation of the parameter, that won't be possible here, so that scoring cannot be translated, and to admins who do not speak English this entire feature/module becomes unusable, because it will be incomprehensible.

My proposal for rebuild with the least amount of work needed is: Prefill with IDs and have the current text be a mere label, but rendered through tra().

{syntax type="tiki" editor="plain"}
Sometimes, it's nice to start over...

https://doc.tiki.org/Score-Details
https://doc.tiki.org/Score

{img src=images/code.png}%%% {CODE()} An error occured in a database query!

Context:
File tiki-download_file.php
Url tiki-download_file.php?fileId=32
Query:
insert into `tiki_users_score` (`user`, `event_id`, `expire`) values (?, ?, ?)
Values:
0 eric.auger
1 fgallery_is_downloaded_guillaume.samson:32
2 1224399721
Message:
Duplicate entry 'eric.auger-fgallery_is_downloaded_guillaume.samson:' for key 1
Built query was probably:
insert into `tiki_users_score` (`user`, `event_id`, `expire`) values
('eric.auger', 'fgallery_is_downloaded_guillaume.samson:32',
'1224399721') {CODE}

1. Enabled Score feature
2. Changed the way points are given to users
3. Applied the settings

After that the Score configuration page stopped loading. It appears that the feature is working, as users are being assigned a score, but I am unable to load the configuration page for Scoring. Meaning that I can't turn it off/on or make any changes to the feature.

It seems that the greater the number of users exist in the wiki, tied with a higher total score per user, generates very slow queries to the database, resulting in a very slow load time per page. I was experiencing 20 seconds + of load time per wiki page, as it was loading the scoring table every time.

Some samples from the database (not sure if useful).


# Time: 170131 16:54:54
# User@Host: giswikiadm[giswikiadm] @ clwp001.city.a.ottawa.ca [10.140.12.238] Id: 334497
# Query_time: 28.076675 Lock_time: 0.000208 Rows_sent: 10 Rows_examined: 4229506
SET timestamp=1485899694;
select `recipientObjectId` as `login`,
`pointsBalance` as `score`
from `tiki_object_scores` tos
where `recipientObjectType`='user'
and tos.`id` = (select max(id) from `tiki_object_scores` where `recipientObjectId` = tos.`recipientObjectId` and `recipientObjectType`='user' group by `recipientObjectId`)
group by `recipientObjectId` order by `score` desc LIMIT 10 OFFSET 0;
# User@Host: eiadwikiadm[eiadwikiadm] @ clwp001.city.a.ottawa.ca [10.140.12.238] Id: 344609
# Query_time: 21.994789 Lock_time: 0.000448 Rows_sent: 10 Rows_examined: 3325313
SET timestamp=1485955286;
select `recipientObjectId` as `login`,
`pointsBalance` as `score`
from `tiki_object_scores` tos
where `recipientObjectType`='user'
and tos.`id` = (select max(id) from `tiki_object_scores` where `recipientObjectId` = tos.`recipientObjectId` and `recipientObjectType`='user' group by `recipientObjectId`)
group by `recipientObjectId` order by `score` desc LIMIT 10 OFFSET 0;
# Time: 170201 8:21:56
# User@Host: eiadwikiadm[eiadwikiadm] @ clwp001.city.a.ottawa.ca [10.140.12.238] Id: 344614
# Query_time: 22.215687 Lock_time: 0.000448 Rows_sent: 10 Rows_examined: 3325313
SET timestamp=1485955316;
select `recipientObjectId` as `login`,
`pointsBalance` as `score`
from `tiki_object_scores` tos
where `recipientObjectType`='user'
and tos.`id` = (select max(id) from `tiki_object_scores` where `recipientObjectId` = tos.`recipientObjectId` and `recipientObjectType`='user' group by `recipientObjectId`)
group by `recipientObjectId` order by `score` desc LIMIT 10 OFFSET 0;
# Time: 170201 8:22:42
# User@Host: eiadwikiadm[eiadwikiadm] @ clwp001.city.a.ottawa.ca [10.140.12.238] Id: 344620
# Query_time: 21.846001 Lock_time: 0.000245 Rows_sent: 10 Rows_examined: 3325313
SET timestamp=1485955362;
select `recipientObjectId` as `login`,
`pointsBalance` as `score`
from `tiki_object_scores` tos
where `recipientObjectType`='user'
and tos.`id` = (select max(id) from `tiki_object_scores` where `recipientObjectId` = tos.`recipientObjectId` and `recipientObjectType`='user' group by `recipientObjectId`)
group by `recipientObjectId` order by `score` desc LIMIT 10 OFFSET 0;
# Time: 170201 8:23:33
# User@Host: citypediaadm[citypediaadm] @ clwp001.city.a.ottawa.ca [10.140.12.238] Id: 344638
# Query_time: 12.665043 Lock_time: 0.000552 Rows_sent: 10 Rows_examined: 2035464
use citypediap1;
SET timestamp=1485955413;
select `recipientObjectId` as `login`,
`pointsBalance` as `score`
from `tiki_object_scores` tos
where `recipientObjectType`='user'
and tos.`id` = (select max(id) from `tiki_object_scores` where `recipientObjectId` = tos.`recipientObjectId` and `recipientObjectType`='user' group by `recipientObjectId`)
group by `recipientObjectId` order by `score` desc LIMIT 10 OFFSET 0;
# Time: 170201 8:23:44
# User@Host: eiadwikiadm[eiadwikiadm] @ clwp001.city.a.ottawa.ca [10.140.12.238] Id: 344639
# Query_time: 22.066348 Lock_time: 0.000236 Rows_sent: 10 Rows_examined: 3325313
use eiadwikip1;
SET timestamp=1485955424;
select `recipientObjectId` as `login`,
`pointsBalance` as `score`
from `tiki_object_scores` tos
where `recipientObjectType`='user'
and tos.`id` = (select max(id) from `tiki_object_scores` where `recipientObjectId` = tos.`recipientObjectId` and `recipientObjectType`='user' group by `recipientObjectId`)
group by `recipientObjectId` order by `score` desc LIMIT 10 OFFSET 0;
# Time: 170201 8:23:52
# User@Host: citypediaadm[citypediaadm] @ clwp001.city.a.ottawa.ca [10.140.12.238] Id: 344642
# Query_time: 13.027229 Lock_time: 0.000440 Rows_sent: 10 Rows_examined: 2035464
use citypediap1;
SET timestamp=1485955432;
select `recipientObjectId` as `login`,
`pointsBalance` as `score`
from `tiki_object_scores` tos
where `recipientObjectType`='user'
and tos.`id` = (select max(id) from `tiki_object_scores` where `recipientObjectId` = tos.`recipientObjectId` and `recipientObjectType`='user' group by `recipientObjectId`)
group by `recipientObjectId` order by `score` desc LIMIT 10 OFFSET 0;

Installed and Setup Tiki 12.0 with MySQL 5.6.16.
Enabled Score feature.
Then posting to forum, I got System error. Error messages is ...
{CODE(caption="Tiki logs" wrap="1")}Field 'tstamp' doesn't have a default value - INSERT INTO...{CODE}

I think it would be relate to MySQL version.
Is it not certified with 5.6?

After upgrade from version 9.1 to version 12.0 the score feature does not work anymore. After login the score is is set to 1.

This bug started in r45775 where $table->increment($score) was removed.

Displaying a star behind the username was removed in r47705. Which makes the score feature more or less useless.

Using "Admin Users" it is possible to change the name of the User.

Doing so also resets the user's score back to zero which is not required and on our system is not desired.

--It may or may not be significant that we are moving away from requiring e-mail based usernames.
Deselecting "Use email as username" does not of itself cause the score to be reset. We are only observing this when we subsequently change from (for example) "test@example.com" to "TST0123"-- --Seems strike thru isn't working on the preceding text--

Your latest demo system also shows the same issue.

All users scores stay at 0 - nothing happens.

Score feature activated, scores entered.

I rated this that high, because it's imho a completely broken feature like this - please correct priority, if I overlooked something!!

You can see it not work here (latest BRANCH-1-9):
http://themes.tikiwiki.org/tiki-index.php

You need to be logged in to see the module "users_rank" with everyone at 0.

Hello,

We have 2 kind's similar features one is legacy but the interface is more user-friendly and one is modern and powerful with an unusual interface.


Score is a bit limited, use template, a set of badges, it is not possible to design the output, creating an event require file editing, etc...
https://doc.tiki.org/Score
https://doc.tiki.org/Score-Admin
https://doc.tiki.org/Score-Details
https://doc.tiki.org/Score-Details#Creating_new_event

Goal and recognition is better designed, use the rebuilt-index and relation, allow custom badges and goals, etc...
However the interface is not user friendly or consistent with usual Tiki admin interface.
https://doc.tiki.org/Goals
https://doc.tiki.org/Tutorial---Goals

Ideally we should be able to use the Score admin panel at tiki-admin.php?page=score to set the goal options


PS: I found this (what I Tiki Karma ??? ?): https://doc.tiki.org/Score-vs-Karma

Two users received the following error when trying to access a blog for which they have permissions in TW v1.9.8.3:
---
__An error occurred in a database query!__
Context:
File tiki-view_blog.php
Url tiki-view_blog.php?blogId=2
Query:
insert into 'tiki_users_score' ('user','event_id','expire') values (?,?,?)
Values:
0 [redacted username of blog creator]
1 blog_is_read_[redacted username of bug victim]:2
2 1200929940
Message:
Error Message Duplicate entry '[redacted blog creator]-blog_is_read_[redacted bug victim]' for key 1
---

No other users (~60) reported this error. The two affected users reported that other blogs were accessible.

~~#FF0000:__When Scoring was turned off, this error did not repeat until Scoring was turned back on.__~~

lib/tikilib and lib/score/scorelib.php functions send no timestamp argument to tiki_users_score isert queries. This results in query failure because tiki_users_score tstamp column in Tiki 1.9 distrib. contains a 'not null' constraint.

---


The following PostGres query sets the default timestamp of tiki_users_score alter column tstamp to 'now', which ensures against attempted insertion of NULL values from the tiki codebase:

alter table tiki_users_score alter column tstamp set default now();

When customizing the Score system, there is no possibility to assign points to Tracker-activities.