Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Ratings plugin not working
Hi!
I’m having trouble with the rating plugin tcm_rating by Working Idea. I’ve thoroughly reviewed every support thread on this forum that mentions the plugin, and the original reference material and downloads on the author’s site no longer seems to be available— not even using the Internet Archive . I see a screenshot of the plugin in Textpattern Solutions on page 366, and the file Rob was using there is clearly not in the download I have.
I set up a completely fresh install to make sure nothing else in the database could be causing my problem, but I get the same behavior. Here is my breadcrumb trail so that someone can hopefully tell me what I’m doing wrong:
1. Install Textpattern from repository:
svn checkout http://textpattern.googlecode.com/svn/releases/4.0.6/source
2. Diagnostic info from fresh install (files show as modified):
Textpattern version: 4.0.6 (r2805)
Last Update: 2008-06-02 02:21:27/2008-06-02 02:17:16
Document root: /Users/username/sites/example.dev (/Users/username/Sites/example.dev)
$path_to_site: /Users/username/Sites/example.dev
Textpattern path: /Users/username/Sites/example.dev/textpattern
Permanent link mode: section_id_title
upload_tmp_dir: /Applications/MAMP/tmp/php
Temporary directory path: /Users/username/Sites/example.dev/textpattern/tmp
Site URL: example.dev
PHP version: 5.2.5
GD Image Library: version bundled (2.0.34 compatible), supported formats: GIF, JPG, PNG
Server Local Time: 2008-06-01 22:22:36
MySQL: 5.0.41
Locale: en_US.UTF-8
Server: Apache/2.0.59 (Unix) PHP/5.2.5 DAV/2
Apache version: Apache/2.0.59 (Unix) PHP/5.2.5 DAV/2
PHP Server API: apache2handler
RFC 2616 headers:
Server OS: Darwin 8.11.1Pre-flight check:
————————————
Some Textpattern files have been modified: /../index.php, /css.php, /include/txp_admin.php, /include/txp_article.php, /include/txp_auth.php, /include/txp_category.php, /include/txp_css.php, /include/txp_diag.php, /include/txp_discuss.php, /include/txp_file.php, /include/txp_form.php, /include/txp_image.php, /include/txp_import.php, /include/txp_link.php, /include/txp_list.php, /include/txp_log.php, /include/txp_page.php, /include/txp_plugin.php, /include/txp_prefs.php, /include/txp_preview.php, /include/txp_section.php, /include/txp_tag.php, /index.php, /lib/IXRClass.php, /lib/admin_config.php, /lib/class.thumb.php, /lib/classTextile.php, /lib/constants.php, /lib/taglib.php, /lib/txplib_db.php, /lib/txplib_forms.php, /lib/txplib_head.php, /lib/txplib_html.php, /lib/txplib_misc.php, /lib/txplib_update.php, /lib/txplib_wrapper.php, /publish.php, /publish/atom.php, /publish/comment.php, /publish/log.php, /publish/rss.php, /publish/search.php, /publish/taghandlers.php, /update/_to_4.0.5.php, /update/_update.php
————————————.htaccess file contents:
————————————
#DirectoryIndex index.php index.html#Options +FollowSymLinks
#Options -Indexes<IfModule mod_rewrite.c> RewriteEngine On #RewriteBase /relative/web/path/
RewriteCond %{REQUEST_FILENAME} -f [OR] RewriteCond %{REQUEST_FILENAME} -d RewriteRule ^(.+) – [PT,L]
RewriteRule ^(.*) index.php
RewriteCond %{HTTP:Authorization} !^$ RewriteRule .* – [E=REMOTE_USER:%{HTTP:Authorization}]
</IfModule>#php_value register_globals 0
————————————
Charset (default/config): latin1/utf8
character_set_client: utf8
character_set_connection: utf8
character_set_database: latin1
character_set_filesystem: binary
character_set_results: utf8
character_set_server: latin1
character_set_system: utf8
character_sets_dir: /Applications/MAMP/Library/share/mysql/charsets/
17 Tables: OKPHP extensions: libxml, xsl/0.1, xmlwriter/0.1, dom/20031129, xmlreader/0.1, xml, tokenizer/0.1, session, pcre, SimpleXML/0.1, SPL/0.2, PDO/1.0.4dev, sockets, soap, SQLite/2.0-dev, standard/5.2.5, Reflection/0.1, posix, pdo_sqlite/1.0.1, mysqli/0.1, mysql/1.0, mbstring, ldap, json/1.2.1, iconv, hash/1.0, gd, ftp, filter/0.11.0, exif/1.4 $Id: exif.c,v 1.173.2.5.2.20 2007/06/10 20:12:45 iliaa Exp $, dbase, date/5.2.5, curl, ctype, calendar, bz2, bcmath, zlib/1.1, openssl, apache2handler, imap, yaz/1.0.12, mcrypt, gettext, pgsql, pdo_pgsql/1.0.2, pdo_mysql/1.0.2, Zend Optimizer
Apache modules: core, prefork, http_core, mod_so, mod_access, mod_auth, mod_auth_anon, mod_auth_dbm, mod_auth_digest, mod_file_cache, mod_echo, mod_charset_lite, mod_cache, mod_disk_cache, mod_mem_cache, mod_example, mod_case_filter, mod_case_filter_in, mod_ext_filter, mod_include, mod_deflate, mod_log_config, mod_env, mod_mime_magic, mod_cern_meta, mod_expires, mod_headers, mod_usertrack, mod_setenvif, mod_proxy, proxy_connect, proxy_ftp, proxy_http, mod_bucketeer, mod_mime, mod_dav, mod_status, mod_autoindex, mod_asis, mod_info, mod_cgi, mod_cgid, mod_dav_fs, mod_vhost_alias, mod_negotiation, mod_dir, mod_imap, mod_actions, mod_speling, mod_userdir, mod_alias, mod_rewrite, mod_php5
pretext_data: array ( ‘id’ => ‘’, ‘s’ => ‘’, ‘c’ => ‘’, ‘q’ => ‘’, ‘pg’ => ‘’, ‘p’ => ‘’, ‘month’ => ‘’, ‘author’ => ‘’, ‘request_uri’ => ‘/9a4ec9aa74225eaa1e4e22d8493e29c6/?txpcleantest=1’, ‘qs’ => ‘txpcleantest=1’, ‘subpath’ => ‘\\/’, ‘req’ => ‘/9a4ec9aa74225eaa1e4e22d8493e29c6/?txpcleantest=1’,
)/../index.php: r2774 (63204c2cf7301c4498746b9a59610e6d)
/css.php: r2772 (3c14e211afd638780323acb4c12c8da1)
/include/txp_admin.php: r2729 (848ed4d9895bb625d7eb403b3b9f1a03)
/include/txp_article.php: r2680 (8a5286dfad05bbd633e399ed1c9aa0bd)
/include/txp_auth.php: r2728 (77f92334f32703d7532f7bfe1e7c370d)
/include/txp_category.php: r2243 (ef5372eff9645e7121f814c9e1903e71)
/include/txp_css.php: r2730 (77246bb616a528a69aa9e468a3942832)
/include/txp_diag.php: r2791 (145fdd75e49d1fa97c5d3b161d062051)
/include/txp_discuss.php: r2774 (efc0041c04aefcadfeb0921aa471f9dc)
/include/txp_file.php: r2530 (6ddfc5900d8b5445377d2d10ed2ec756)
/include/txp_form.php: r1913 (11564cfe93042c4a1785f684799e848d)
/include/txp_image.php: r2668 (83dd37ddab1cc6d58fe34080881134ef)
/include/txp_import.php: r1238 (125c7a81381203d0a986d14fea3f7e07)
/include/txp_link.php: r2463 (dea3611bb917a3e3ca3da5641c7549a7)
/include/txp_list.php: r2725 (0b01372d2525c5126ff6666796cae3f6)
/include/txp_log.php: r2796 (ddaa38098529b0fdbe08c827ac069b45)
/include/txp_page.php: r2717 (6394b9cea432b257431b1cae0cc6c217)
/include/txp_plugin.php: r2774 (90d147baea66c4707a911a9bd410e19e)
/include/txp_prefs.php: r2528 (120f8f752c9ebb5be8783f589431257d)
/include/txp_preview.php: r1238 (152078a71991e6dad86f41f1ec6df6e7)
/include/txp_section.php: r2759 (bc1bda1402596efea1bde758b06b1294)
/include/txp_tag.php: r2774 (09e85235be51c929e51d17cab8be7ee3)
/index.php: r2805 (8c3ac04d8b713f8014c53cbda35fbbb8)
/lib/IXRClass.php: r765 (75abc1330b4f91487950f4e2000cb4f6)
/lib/admin_config.php: r1747 (f1300d28ce19cb37c54722271e4bb4d2)
/lib/class.thumb.php: r2329 (627e39aaaf4faef6f52ac1e0b342f888)
/lib/classTextile.php: r2779 (45930699aca80a5cd7c1092b1d3f354e)
/lib/constants.php: r2361 (fbe63ec9e269801f874d7f787898ea22)
/lib/taglib.php: r2612 (cd03f13f6ec4c63342975b6d4f08a105)
/lib/txplib_admin.php: r2726 (c4f65bac2ddef62867f5bfee97ad7dfe)
/lib/txplib_db.php: r2748 (cdbc89346a4c2027f58e7624e9488cde)
/lib/txplib_forms.php: r2759 (35b7fc377fe8a8510e9aaaa58a458311)
/lib/txplib_head.php: r2783 (be0e04f67c41ec7a3c7748700dbc1acc)
/lib/txplib_html.php: r2696 (df46c8e1f72ee25e4bf182689c084987)
/lib/txplib_misc.php: r2788 (8ce9df6874784b844d2132c085810f0f)
/lib/txplib_update.php: r1239 (fff6bd489020071753dfee45eabfbc80)
/lib/txplib_wrapper.php: r2800 (254f565586fb0401066800914a0d3783)
/publish.php: r2777 (99b39b074311989d995f5d2595249db7)
/publish/atom.php: r2774 (05d226550f7973694debfcac63b63a92)
/publish/comment.php: r2776 (4998d73d30a3a6b43c2ec8cae4f2552e)
/publish/log.php: r1637 (dbefeab2ddd1e7d8f1f2020e38ca47c3)
/publish/rss.php: r2793 (37625e40a3203d83e0ceac72db175d97)
/publish/search.php: r1748 (ab4fbbc6a64dcd8a5083b97d5e963f0d)
/publish/taghandlers.php: r2774 (6fe6654a7d15191176750de549b1e39c)
/update/_to_1.0.0.php: r711 (0f49fca8fbd8e6fca0fc48b0f69f0461)
/update/_to_4.0.2.php: r711 (e77c0e0d972868f19eaee4565bd0b4c4)
/update/_to_4.0.3.php: r711 (f5506cfd0fbc3ad4bd9a9b2299468775)
/update/_to_4.0.4.php: r711 (4d867b42ee87a7f11d2bff3a8e91bed0)
/update/_to_4.0.5.php: r2464 (a32b754451f2a7f9a17c1bb0b8d923cf)
/update/_to_4.0.6.php: r2464 (7e5ae73eb64c24438918697089a1f321)
/update/_update.php: r2792 (74b64722d9d5f4943b58b86ff1e818e9)
3. Download tcm_rating package from Textpattern Resources which includes the following files:
- Thumbs.db
- tcm_ratingoutput.txt
- tcm_ratinginput.txt
- ratings_sql.php
- ratings.php
- on.gif
- off.gif
4. Move ratings_sql.php and rating.php to the Textpattern directory (according to instructions).
5. Open ratings_sql.php in the browser (according to instructions):
Ratings Were Not Installed
6. It didn’t work; run the SQL query in phpMyAdmin:
MySQL said:
- - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘“CREATE TABLE “.$table_prefix.“txp_tcm_ratings (
ratingid int(6) NOT NULL a’ at line 1
There are no new tabs under Extensions as described by the text of Textpattern Solutions and the plugin’s main support thread, and activating the input/output plugins in the existing package doesn’t seem to give me an Extensions tab either. Any suggestions?
Last edited by johnstephens (2008-06-02 03:04:22)
Offline
Re: Ratings plugin not working
What version do you have? I’ve got 0.6b running on 4.0.6, but it’s been modified (can’t remember what though – did it a few years ago).
Offline
Re: Ratings plugin not working
I have the package that is presently available from Textpattern Resources which includes the following files:
- Thumbs.db
- tcm_ratingoutput.txt
- tcm_ratinginput.txt
- ratings_sql.php
- ratings.php
- on.gif
- off.gif
The package does not include a file called tcm_rating— based on what I gather looking at the screenshot in Textpattern Solutions, and the support thread here, that file is needed for the plugin to work. Does anyone know an active link to or copy of that file? Is it possible for someone with a working version to share their copy?
Versions are listed as follows for the input/output plugins:
tcm_ratinginput 0.3
tcm_ratingoutput 0.4
(I note that the description field for these plugins both say “ratings mod req.”)
Thanks for your support!
Last edited by johnstephens (2008-06-02 12:25:07)
Offline
Re: Ratings plugin not working
Also, I notice that my diagnostics always tell me that core files have been modified when I do a fresh install from svn. Is that normal?
Offline
Re: Ratings plugin not working
That diagnostics warning about modified files is normal in SVN. The checksums are only re-generated when we officially release a new version.
Offline
Re: Ratings plugin not working
ruud wrote:
That diagnostics warning about modified files is normal in SVN. The checksums are only re-generated when we officially release a new version.
That’s encouraging. Thanks!
Offline
Re: Ratings plugin not working
If the files in the tcm_rating package available from Textpattern Resources are sufficient to install and use the plugin, can anyone tell me what I can do to make it work?
Offline
Re: Ratings plugin not working
Not sure what you would do those versions works. My 0.6b is too modified to compile for others (unless you want new and broken :P).
If you’re not deploying to a fastcgi server (for a few weeks – rewriting it!), then you can give jmd_rate a shot. It works on PHP as Apache and CGI modules, so it’ll run on MAMP.
Offline
Re: Ratings plugin not working
jm,
Do you mean that the input output plugins work without the tcm_rating file?
Here’s a screenshot of my plugins tab in TXP:
Here is the tcm_rating package as downloaded from Textpattern Resources:
From plugin’s support thread tcm_rating v2 beta release seems to indicate that a file called tcm_rating is required to run the plugin, but the link to that file on the author’s site is dead. If it’s possible to run the plugin without that file, would anyone be willing to tell me what steps to follow?
I’ll give the jmd_rate plugin a try! Thanks for the tip!
I appreciate your guidance and support!
Offline
Re: Ratings plugin not working
0.6b is was a whole new plugin – just one file (tcm_rating.txt = only plugin) if I remember correctly.
Offline
Re: Ratings plugin not working
Thanks, jm!
Sounds like tcm_rating.txt is no longer available anywhere.
I haven’t delved into a complex implementation, but jmd-rate seems to be working great on both my dev and destination servers. How can I tell if I’m using a fastcgi server? How is your plugin different from tcm_rating? I appreciate your help!
Offline
Re: Ratings plugin not working
If you go view high diagnostics, you’ll see PHP Server API and either apache2handler (works), cgi (works), or fcgi-cgi (fails silently).
Compared to tcm_rating, jmd_rate doesn’t have an Extensions>ratings area nor does it have Ajax (why I’m rewriting it). Compared to css_rating, it is self contained, but again, lacks Ajax. At the moment, it also lacks a help file :P (need to upload the older version!). My goal with jmd_rate was to make it customizable, so I think that’s one area it excels. It does “back-rating” too, in the event change your total stars from 5 300, older votes are scaled.
Offline