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;

Contributors

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)

Sometimes, it's nice to start over...

{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}

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.

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.