Simple Testimonial Star Rating

Permalink Browser Info Environment
Testing theme for potential client, first time I tried Simple Testimonials. When I created the block it threw an error about N requiring a number, which I came to determine was the star rating. Seems like I must add the star rating if the block is to be created. How can we avoid this?

http://dev.teknoziz.com:8888/mmarts...

Type: Discussion
Status: In Progress
TeKnoZiz
View Replies:
formigo replied on at Permalink Reply
formigo
Hi there,

Just tested this and could not replicate unfortunately. I could add the block without a rating? Can you offer any more info on this that may help us replicate please?
TeKnoZiz replied on at Permalink Reply
TeKnoZiz
I receive this error:

An unexpected error occurred. mysqlt error: [-9999: Numeric field type "N" requires numeric value.] in DOQUOTE(, ) < Back to Home
formigo replied on at Permalink Reply
formigo
OK thanks.

I have tested in an other environment and still no luck at replicating unfortunately.

I am running concrete5 5.6.2.1 and foundation 1.6.0. Could you confirm what version you are using please?

Thanks
TeKnoZiz replied on at Permalink Reply
TeKnoZiz
C5 3.6.3.3, Foundation 5 1.6.0
formigo replied on at Permalink Reply
formigo
Have a feeling this is related to the latest version of concrete5. Found a similar issue on an other add-on:

https://www.concrete5.org/marketplace/addons/simple-jwplayer-video-p...

We will continue to look in to this.
formigo replied on at Permalink Reply
formigo
There seems to be an issue with the rating helpers javascript in the latest version of concrete5...

You can side step this by opening the form_setup.php file within the simple testimonial block's folder and changing line 87 from
<?php echo $rt->rating('testimonialRating', $testimonialRating, $includeJavaScript = true);?>

to
<?php echo $rt->rating('testimonialRating', $testimonialRating, $includeJavaScript = false);?>

That will prevent using javascript and give you 5 radio buttons instead.
TeKnoZiz replied on at Permalink Reply
TeKnoZiz
Yes, but how then do you _remove_ a rating from an existing testimonial... lol.
formigo replied on at Permalink Reply
formigo
Well I guess you don't...

If you set a review on a testimonial, I guess this would not change? You could always delete the testimonial block if you really needed to.

The problem here is the issue appears to be within the conrete5 system as this block uses the core ratings functionality. If you really had to bottom this off you could always change the db.xml field type from 'f' to 'C' and give it a size - that would do it. Although this is a little hacky to be honest and I would not recommend it.
TeKnoZiz replied on at Permalink Reply
TeKnoZiz
I just recreated them and left off the rating. Works fine. Thanks.

concrete5 Environment Information

# concrete5 Version
5.6.3.3

# concrete5 Packages
Background Image (1.0), Dashboard Maximizer (2.0.4), Easy Accordion (1.1.2), Foundation 5 (1.6.0), List files from set (1.0.4), Page Auto Redirect (2.0), Pro Events (11.1.0), tnSpacer (1.3).

# concrete5 Overrides
blocks/ff_simple_document, blocks/list_files_from_set, languages/ar, languages/cs_CZ, languages/da_DK, languages/de_DE, languages/el_GR, languages/es_AR, languages/es_ES, languages/es_MX, languages/es_PE, languages/fa_IR, languages/fi_FI, languages/fr_FR, languages/it_IT, languages/ja_JP, languages/nb_NO, languages/nl_NL, languages/pt_PT, languages/ro_RO, languages/ru_RU, languages/sk_SK, languages/sl_SI, languages/sv_SE, languages/tr_TR, languages/vi_VN, languages/zh_TW, themes/foundation_5

# concrete5 Cache Settings
Block Cache - Off
Overrides Cache - Off
Full Page Caching - Off

# Server Software
Apache

# Server API
apache2handler

# PHP Version
5.6.2

# PHP Extensions
apache2handler, bcmath, bz2, calendar, Core, ctype, curl, date, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mcrypt, mysql, mysqli, openssl, pcre, PDO, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, Reflection, session, SimpleXML, soap, sockets, SPL, sqlite3, standard, tokenizer, wddx, xml, xmlreader, xmlwriter, xsl, yaz, zip, zlib.

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 20
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 128M
post_max_size - 32M
sql.safe_mode - Off
upload_max_filesize - 32M
ldap.max_links - Unlimited
mysql.max_links - Unlimited
mysql.max_persistent - Unlimited
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited
session.cache_limiter - nocache
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5

Browser User-Agent String

Mozilla/5.0 (iPad; CPU OS 8_1_3 like Mac OS X) AppleWebKit/600.1.4 (KHTML, like Gecko) Version/8.0 Mobile/12B466 Safari/600.1.4

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.