Extension talk:CommunityVoice

Used Where?
Hi there, on what WM wiki is this used? SJ
 * I asked this very question yesterday, see User_talk:Trevor_Parscal, being used on http://usability.wikimedia.org/ -- Dr DBW |  talk  03:02, 27 February 2009 (UTC)

MySQL error
I receive this error: Error returned by MySQL database is «1146: Table 'YOURWIKI.cv_ratings_votes' doesn't exist (localhost)».

But what does the following mean?

''Check your privileges, one of the possibles reasons it is the user have enough rights to create the tables required. Then try to run manually the Initialize.php through the shell. Go to the Mediawiki extensions folder and write the following code.''

Could you explain it in detail?

--dvL 09:58, 2 March 2009 (UTC)


 * When using CommunityVoice, certain database tables need to exist in your database. To create these tables, you need to run some code. The code you need to run is not a web page though, so you need to have access to the command line. If you are installing on your local computer you can just open up a command prompt or terminal (depending what your operating system calls it) and type "cd " for example, where  is the full file path to your wiki installation. from there you can type "cd extensions/CommunityVoice/CLI" to change to the directory which contains the command line interface scripts for the CommunityVoice extension. Finally you can run the line mentioned above: "php Initialize.php --confirm=yes" which invokes the php program, tells it to run the Initialize.php script and passes yes as the value for the confirm argument. The script will run and create the database tables for you. Please note you may have to have root access to perform these operations - in which case you might need to use the sudo command before invoking php like "sudo php Initialize.php --confirm=yes". All of this information is part of a very common process for preparing your wiki for use with certain extensions. I hope that is clear and helpful. 75.149.49.114 17:35, 3 March 2009 (UTC)


 * Thanks, this was very helpful..
 * --dvL 08:14, 4 March 2009 (UTC)


 * Edit: I entered this as admin..
 * C:\xampp\php>php C:\xampp\htdocs\wiki\extensions\CommunityVoice\CLI\Initialize.php --confirm=yes

Strange behavior
Another question: The "strange behavior" problem (   message instead of the correct message 0 / 5 (0 votes cast)) that is mentioned on the main page seems to be resolved at the Wikimedia nomination site. What was changed?

--dvL 09:57, 4 March 2009 (UTC)

Yes, what was changed?? -- 15:15, 16 March 2009 (GMT)

Not working with IE and Opera
Only FF shows this extension corect..


 * This has been fixed in r48522. The cause was the use of null as a key in a JavaScript object.

Failing to register
Running MW 1.15aSVN and having set

in LocalSettings returns the following error:
 * 1) require_once( "$IP/extensions/ClientSide.php" );
 * 2) require_once( "$IP/extensions/CommunityVoice/CommunityVoice.php" );

Warning: call_user_func(CommunityVoice::registerModules) [function.call-user-func]: Unable to call CommunityVoice::registerModules in /chroots/dwadmin/home/dwadmin/htdocs/includes/Setup.php on line 310

Both files exist and are at their proper places :/

Was there a resolution to this?
I'm getting the same problem. Was there ever a resolution to this?

Quickie review
Couple quick notes...


 * Some functions in ClientSide look like they duplicate code in Xml.php
 * handleScaleVoteCall looks like it will return old data from slave, so reported total after vote will not include the vote (which has only just been inserted to the master)

-- brion 18:37, 13 May 2009 (UTC)

Is it possible to install the DB without Commandline-Access (phpMyAdmin)?
Hi,

i have no commandline on my webspace/server, but i can access the DB through phpMyAdmin.

Could anyone tell how exactly the table has to be named/formed?

78.52.99.77 17:51, 12 October 2009 (UTC)

Yes, it is.
I found this interesting looking file CommunityVoice/CommunityVoice.sql - and adapted it to my needs, using my "absolute-non-existing-MySQL-Trial-and-Error-Know-How".

This is how it went: CREATE TABLE yourtableprefix_cv_ratings_votes (   -- Category of item being rated    vot_category VARBINARY(255) NOT NULL default ,    -- Title of item being rated    vot_title VARBINARY(255) NOT NULL default ,    -- User who made the rating, 0 for anons (however it shoudn't be allowed)    vot_user INTEGER NOT NULL default 0,    -- Value of rating    vot_rating INTEGER NOT NULL default 0,    --     INDEX vot_category_title ( vot_category, vot_title ),    INDEX vot_category_title_user ( vot_category, vot_title, vot_user ),    INDEX vot_category_title_rating ( vot_category, vot_title, vot_rating ) );
 * Login to your phpMyAdmin
 * Click on SQL which gives you a Window where you can copy&paste some SQL-Commands
 * Copied this code into the window and executed it by clicking on OK (adapt yourtableprefix accordingly):

Works ;)

78.52.99.77 18:15, 12 October 2009 (UTC)