Loading...
 

Category: Score

Score
Show subcategories objects

Name Type
1.9.1 to 1.9.3.1 upgrade pb on tiki_score table
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;
tracker item
omstefanov
Contributors
tracker item
carsten.aevermann
tracker item
Community Currencies
wiki
Include option to separate voting on forums from karma or score system
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.
tracker item
9x dev.t.o/t5: Plain registered users can't rate tracker items; admins can. Obj & Global Perms seems ok though: bug?
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.
tracker item
10.x dev.t.o/t5: clicking at a star in the rating field of the Bug Tracker does nothing
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)
tracker item
Reset scores
Sometimes, it's nice to start over...
tracker item
Score conflicts with the File Gallery

{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}
tracker item
Score feature - page not loading
tracker item
Score Feature - Slow Database Queries
tracker item
Score feature got system error using MySQL 5.6.16
tracker item
Score feature useless
tracker item
Score Reset when username is changed
tracker item
Score system doesn't count scores
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!!
tracker item
Score system doesn't count scores
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.

tracker item
Scoring feature causes intermittent blog access error in v1.9.8.3
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.__~~
tracker item
Scoring Mods for PostGres installs
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();
tracker item
Tracker items should enhance users score
When customizing the Score system, there is no possibility to assign points to Tracker-activities.
tracker item

Keywords

The following is a list of keywords that should serve as hubs for navigation within the Tiki development and should correspond to documentation keywords.

Each feature in Tiki has a wiki page which regroups all the bugs, requests for enhancements, etc. It is somewhat a form of wiki-based project management. You can also express your interest in a feature by adding it to your profile. You can also try out the Dynamic filter.

Accessibility (WAI & 508)
Accounting
Administration
Ajax
Articles & Submissions
Backlinks
Banner
Batch
BigBlueButton audio/video/chat/screensharing
Blog
Bookmark
Browser Compatibility
Calendar
Category
Chat
Comment
Communication Center
Consistency
Contacts Address book
Contact us
Content template
Contribution
Cookie
Copyright
Credits
Custom Home (and Group Home Page)
Database MySQL - MyISAM
Database MySQL - InnoDB
Date and Time
Debugger Console
Directory (of hyperlinks)
Documentation link from Tiki to doc.tiki.org (Help System)
Docs
DogFood
Draw
Dynamic Content
Preferences
Dynamic Variable
External Authentication
FAQ
Featured links
Feeds (RSS)
File Gallery
Forum
Friendship Network (Community)
Group
Help
History
Hotword
HTML Page
i18n (Multilingual, l10n, Babelfish)
Image Gallery
Import-Export
Install
Integrator
Interoperability
Inter-User Messages
InterTiki
jQuery
Kaltura video management
Karma
Live Support
Logs (system & action)
Lost edit protection
Mail-in
Map
Menu
Meta Tag
Missing features
Visual Mapping
Mobile
Mods
Modules
MultiTiki
MyTiki
Newsletter
Notepad
OS independence (Non-Linux, Windows/IIS, Mac, BSD)
Organic Groups (Self-managed Teams)
Packages
Payment
PDF
Performance Speed / Load / Compression / Cache
Permission
Poll
Profiles
Quiz
Rating
Realname
Report
Revision Approval
Scheduler
Score
Search engine optimization (SEO)
Search
Security
Semantic links
Share
Shopping Cart
Shoutbox
Site Identity
Slideshow
Smarty Template
Social Networking
Spam protection (Anti-bot CATPCHA)
Spellcheck
Spreadsheet
Staging and Approval
Stats
Survey
Syntax Highlighter (Codemirror)
Tablesorter
Tags
Task
Tell a Friend, alert + Social Bookmarking
Terms and Conditions
Theme
TikiTests
Timesheet
Token Access
Toolbar (Quicktags)
Tours
Trackers
TRIM
User Administration
User Files
User Menu
Watch
Webmail and Groupmail
WebServices
Wiki History, page rename, etc
Wiki plugins extends basic syntax
Wiki syntax text area, parser, etc
Wiki structure (book and table of content)
Workspace and perspectives
WYSIWTSN
WYSIWYCA
WYSIWYG
XMLRPC
XMPP




Useful Tools