Printable View
The same thing was happening to us on an epidemic level. I tried everything. Finally I seemed to completely eliminate the problem by installing a simple CAPTCHA into the form. The testimonial will now only submit if the person types a matching number from the CAPTCHA.Quote:
Originally Posted by Coins2012
That's something you might want to look into implementing to see if it helps/
Latest version of TM has avatar manager that is broken also testimonial uploaded images are being saved as
Code:Submited image: includes/classes/observers/auto.vat_for_eu_countries.php
Please read the posting guidelines and provide more info... not having any issues with it.Quote:
Originally Posted by DigitalShadow
Do you have mod Vat for EU countries installed?
no, but installed on a test site zc156c php7.3 with TM. Added the Vat mod and All works.. The script for images is setup to re-code image to strip out location info and ML bugs, then renames them for storage.. All done before sending to your server.Quote:
Originally Posted by DigitalShadow
I'm not running php 7+ due to a problem with the paypal code since 1.5.5 for payflow uk
Any chance the problem is with php 5.6.40?
Yes... Although untested, everything in the image rewrite PHP says is supported in php5 - 7+ however, I think the sql statements may throw errors too.. I don't have anything older then php7.2 installed right now to test with...Quote:
Originally Posted by DigitalShadow
Quote:
Originally Posted by davewest
Blast!
The issue only happens if the customer doesn't select to upload an image, if I choose to upload an image it works as expected, however if no image is uploaded the submitted image is saved as
Submited image:
includes/classes/observers/auto.vat_for_eu_countries.php
instead of a blank value
Also noted that when a testimonial is submitted the avatar is being saved with a double // in the database
So file saved as
avatars//img_01.jpg
I can not recreate the errors to even get a image save to come closes to that folder.. I don't see any configurations that would allow for that type of a cross up. I would switch off the image upload for now... I would guess theirs something going on with the old php that does not agree with the code.Quote:
Originally Posted by DigitalShadow
avatars setting in admin, remove the ending / or at lest check for doubles..
ok... so.. testimonials are sent with a selected avatar and not uploaded.. only an image of user selection is uploaded to go with the words... Avatars as at_10.png, only the at_#.png is allowed to be selected. This protects user submitted avatars which can only be uploaded within a logged in account holder, if you installed that addon code section.. not required. without, users can not add there own avatars.Quote:
Originally Posted by DigitalShadow
If you say img_#.jpg, then that would suggest you have the account addon installed..
In testimonial config is the setting to change/modify upload and avatar folder names/location.
If i remove the "/" from the avatar location in the admin then the avatars no longer show in the popup circle. I had to edit header_php in testimonials_add to put the "/" back inQuote:
Originally Posted by davewest
$dir = 'images/' . TESTIMONIAL_IMAGE_DIRECTORY . '/';
v1.5.5f php7.1 Testimonials v1.5.4 Westminster_New
Hi Dave,
so wondering if you can help me with this - on a mobile phone testimonials are showing up at the beginning of every category page, before category heading. How can I stop this from happening - using Westminster_New template however I haven't configured testimonials to show - I have testimonials sidebox switched on and it is the testimonial in that sidebox that is showing - any relationship there?
cheers,
Mike
Dave please disregard the above - amazing how as you are explaining a problem and providing information to someone that you start thinking about the problem differently - SHAZZAAMMMM !! .... it was a simple thing of a box ticked when it shouldn't have been ticked in sideboxes configuration (you know, the sidebox I mentioned above :) )Quote:
Originally Posted by shags38
I hope you are doing well.
cheers,
Mike
Users with MySQL 5.7 or higher: note that the table creation used in admin/includes/functions/extra_functions/testimonials_manager_functions.php needs to be changed from
date_added DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
to
date_added DATETIME NOT NULL DEFAULT '0001-01-01 00:00:00',
Dave, do you want the Github Repo for
https://www.zen-cart.com/downloads.php?do=file&id=299
to be set to
https://github.com/davesaddle/Testimonial-Manager
?
Actually.. now that you brought it to my mind front.. the errors are in how the date code is used and sensitized in admin/testimonials_manager.php that's in error.. I need to fix how it's used... the database change would be a band aid only.Quote:
Originally Posted by swguy
I'll put down my Python3 cook book and get an update sent in... Or was there an issue with database mySQL versions!
The default value for the date should be as it was..
date_added DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
The problem was in code I was testing for and setting a 0001-01-01 00:00:00 which is wrong.. I was stupid in my thinking when copying code.. We actually need to set a NOW date and not the 0001 thingy or even test for it... This also sets up the date picker correctly for now and not in the past or to far into the future.
Fixed in admin and add testimonial.. Date/time default now is used and not empty during SQL query's.
Fixed a bug in contact radio fields admin/testimonials_manager.php
Fixed an issue in add testimonial with avatar selection adding a double // in the image address.
Some code clean-up for responsive admin.. I like buttons to stay handy on any size screen.
I updated Github, but like to run a test install before uploading a copy here..
This does not work in MySQL 5.7. That's why there's a file called zero_dates_cleanup.sql in zc_install - to fix the old defaults of 0000-00-00 to 0001-01-01.
My bad... what happens when you're cracking one and rushing through another.. More to the point, this is not a problem with code, but a new version of MySQL and strict mode specifically NO_ZERO_DATE thingy... which I didn't read up on until now.. which I now have some others to fix... well update it with a sniffer for upgrades... thanks.Quote:
Originally Posted by swguy
Note that there is/was still some debate about what the proper "default" date/datetime should be. See https://github.com/zencart/zencart/issues/2397Quote:
Originally Posted by davewest
I was wondering about using NULL, for the date field right below it is set that way.. both really don't need a default for they're filled at the time data is feed to the table. The default is now not pulled into the code, so not used. With the blank form feeding the current date/time the date picker seems very happy. It was the only line using the default in the past which made the date picker time travel into the past..Quote:
Originally Posted by mc12345678
Thanks for the link...
hi, i have installed this plugin and i am getting this error as i test run the plugin ...
Not Acceptable!
An appropriate representation of the requested resource could not be found on this server. This error was generated by Mod_Security.
can anyone tell me how to fix this please?
i am using the latest zencart version and 7.1 php
thanks
Go through your server files and correctly set permissions... folders should be 755 and files 644..Quote:
Originally Posted by amebb
Hello,
I just installed the mod on my site at www.royal-fleur.com
I am currently using ZC 1.5.6 and the install went smoothly.
However, I am not able/cannot display the testimonial sideboxe. It is turned on in the admin and should set to left column but nothing.
What am I missing?
Thank you for the help
You need to have at least one testimonial active before the sidebox will show. You currently have 0.
My bad. I had testimonials but they were all hidden to public. It is all fine now. Thank you, your response pointed me in the right directionQuote:
Originally Posted by balihr
I have just installed Testimonials Manager for Zen Cart 1.5.6c and now my Configuration Admin Menu has two options saying 'Testimonials Manager' - one that doesn't have anything in it so I assume this was left over from the old install of Testimonials Manager that was running on Zen Cart 1.5.5f. How do I remove it?
Looks like I missed older install admin pages names.. fix and uploaded to Git, well work on an update later this month.. The only thing left over was the admin page so to remove you can download the updated admin functions page or use phpmyadmin or run this line in your admin sql tool.. if you are using a prefix on tables you would need to add it to the table name (zen_admin_pages)..Quote:
Originally Posted by Nick1973
I was more interested in keeping past testimonials while upgrading and forgot the change in admin pages.Code:DELETE FROM admin_pages WHERE page_key = 'configTestimonialsManager';
Anybody know why I can't select five stars on this page?
https://pawsandclawspettags.co.uk/in...stimonials_add
And also why the stars are boxes?
Your fontawesome 5 is not loaded correctly and this mod was not upgraded to 5 yet.. If you load FontAwesome 5 kit with version 4 enabled the stars would show.Quote:
Originally Posted by Nick1973
I use the kit and local/backup install as
I was working on a how-to but not posted yet..Code:<script src="https://kit.fontawesome.com/YOUR_KIT_ID.js" crossorigin="anonymous"></script>
<script type="text/javascript">
(function($){
var $span = $('<span class="fas" style="display:none"></span>').appendTo('body');
if ($span.css('font-family') !== 'Font Awesome 5 Free' ) {
// Fallback Link
$('head').append(<?php echo '\'<link rel="stylesheet" type="text/css" href="' . $template->get_template_dir('.css',DIR_WS_TEMPLATE, $current_page_base,'css') . '/' . 'font-awesome.css' . '" />\''; ?>);
$('head').append(<?php echo '\'<link rel="stylesheet" type="text/css" href="' . $template->get_template_dir('.css',DIR_WS_TEMPLATE, $current_page_base,'css') . '/' . 'all.css' . '" />\''; ?>);
}
$span.remove();
})(jQuery);
</script>
I have tried to install this on a 1.5.7 site, but even though there is one testimonial written up and active, the sidebox is not showing up. Wondering if a 1.5.7 version needs to come out before it can be used?
Any suggestions? Thanks in advance!
There are allot of minor updates to meet ZC1.5.7 admin and php7.4 which I'm working on. Once tested and packaged, I'll upload it.Quote:
Originally Posted by stellarweb
Thanks Dave!!
Just pushed an update to git for ZC157 ONLY I'm thinking about doing a new installer for ZC156 yet before uploading here...
Some new things going on in admin, some bug fixes, new switch to turn off the submit form.. This only works for ZC157!
Just sent in an update. I made a change in the star rating to make it simple to use. I tried switching over to emoji's but found that FTP transfer was changing the font. Changed to image png emoji's instead..
I updated my site if you want to see the emoji rating.
Hi davewest,
The coloured symbols under 'Status' don't work when you try to approve a testimonial. It goes to a blank page or 500 error.
https://yourdomainname.com/YOURADMIN...onials_manager
If you see the user-circle-o then you have FontAwesome 4 running,Quote:
Originally Posted by Nick1973
and the cmd in the address is a ZC1.5.7x thing..
I would need more info to guess at what's not working...
Tested with a clean install of ZC1.5.7b and a heavy modified one with FontAwesome4 and PHP7.4. Not designed for anything less then ZC1.5.7x without modifying files.
Nice update Dave!
Getting the classic 'headers already sent' error when operating the uninstall button:
--> PHP Warning: Cannot modify header information - headers already sent by (output started at /###/shop/zc_plugins/TestimonialManager/v2.5.0/Installer/ScriptedInstaller.php:168) in /###/shop/YOUR_ADMIN/includes/functions/general.php on line 19.
No cause/fix found yet.
Also, ScriptedInstaller.php updates needed:
Example Testimonial Image...
replace this:
avatars/cbgdave.png
with this:
avatars/cbg_dave.png
Uninstall...
replace this:
$sql = "DROP TABLE ' . $table_name . '";
with this:
$sql = "DROP TABLE $table_name ";
Zen Cart 1.57c running PHP 7.3.33
Upgrade testing found an error when upgrading using the plugin manager...
ScriptedInstaller.php updates needed:
replace this:
('Testimonial Manager Version','TM_VERSION',$version,'Testimonial Manager version', $tm_config_id, 21, NOW(), NOW(), NULL, NULL, NULL)";
with this:
('Testimonial Manager Version','TM_VERSION','.$version.','Testimonial Manager version', $tm_config_id, 21, NOW(), NOW(), NULL, NULL, NULL)";
The error only seemed to be relevant during manual upgrade (Un-Install then Install new version) automatic upgrade with the plugin manager button has been unsuccessful and also causes the headers already sent error - which also blanks the right configuration sidebox completely.
I assume the plugin manager Clean Up button is not working as a result of the processActionDoCleanup in the PluginManagerController.php being empty (stock 1.57c) which is a Zen Cart problem not a Testimonials Manager problem - the function is empty.
Testing continues!
Plugin Manager's upgrade functionality is not implemented in ZC 1.5.7x (there is the button but it does nothing). I think the same applies for the Clean Up feature (I don't remember if it works)Quote:
Originally Posted by twitchtoo
Indeed there are a collection of things missing from the Plugin Manager however that hasn't stopped me from updating this module to Testimonial Manager 2.5.1 with all the corrections needed to prevent any errors with the current stock Plugin Manager!
I'll package it up later this week and submit :clap:
Fixed:
- Install - Stock Zen Cart Plugin Manager errors
- Uninstall - Missing defines errors causing page load and sidebox load errors
- Failed star rating display
- CSS updates - mobile friendly
- FontAwesome - unsupported version errors
- Missing heading title error
- Corrected various spacing issues and spelling errors
Now built into Twitch Base7 [Sapphire] - a demo link is available for anyone wanting to see it in action - just email me directly and I'll send the link!
Just Submitted:
Testimonial Manager
Version 2.5.1 for Zen Cart 1.57c
Mar 28.2022 - Twitchtoo Media
Updates from my previous post have been included to ensure no errors when installed or uninstalled using the Zen Cart Plugin Manager.
Thanks for updating this. I just wonder if perhaps the add testimonial only works if another captcha isn't present? I can see it has non-captcha observer file, on the add testimonial page it doesn't show the boxes to add entries. I have Google Captch so perhaps this is the reason, but just wondered. Thanks :-)
Quote:
Originally Posted by HeathenMagic
Yes I noticed this module was hit and miss with that block of code. I left it in as it was useful in previous versions, however in the next release I'll be sure to rework it from the ground up.
Update for anyone that has not installed or perhaps uninstalled the new plugin based Testimonial Manager 2.5.1...
YOUR_ADMIN/ includes/modules/dashboard_widgets/TestimonialsDashboardWidget.php
old:
$tm_plugin = $db->Execute("SELECT status FROM " . TABLE_PLUGIN_CONTROL . " WHERE unique_key = 'TestimonialManager'");
$tmStatus = ($tm_plugin->fields['status'] == '2') ? 'off' : 'on';
//if ($tmstatus == 'on') {
$sql = "SELECT * FROM " . TABLE_TESTIMONIALS_MANAGER . " ORDER BY date_added DESC";
$testimonials = $db->Execute($sql, (int)$maxRows, true, 1800);
$totalTM = $db->Execute("select count(*) as count from " . TABLE_TESTIMONIALS_MANAGER . "");
?>
<div class="panel panel-default reportBox">
new:
$tm_plugin = $db->Execute("SELECT status FROM " . TABLE_PLUGIN_CONTROL . " WHERE unique_key = 'TestimonialManager'");
$tmStatus = ($tm_plugin->fields['status'] == '1') ? 'on' : 'off';
if ($tmStatus == 'on') {
$sql = "SELECT * FROM " . TABLE_TESTIMONIALS_MANAGER . " ORDER BY date_added DESC";
$testimonials = $db->Execute($sql, (int)$maxRows, true, 1800);
$totalTM = $db->Execute("select count(*) as count from " . TABLE_TESTIMONIALS_MANAGER . "");
?>
<div class="panel panel-default reportBox">
then at the bottom of this file...
change this:
</script>
<?php //} ?>
to this:
</script>
<?php } ?>
If you're using the manager this error will not present itself.
Hi everyone. I'm hoping someone can help with an issue I'm having.
I've installed installed Testimonial Manager v1.5.4. Fresh install to Zencart 1.5.7d, PHP 7.4.29 (Zend: 3.4.0)
Everything is working except the links that access to testimonials_add
The following error appears in my logs. Unfortunately I don't have the skills to resolve.
All help appreciated.
Thanks Greg
PHP Fatal error: require(): Failed opening required 'includes/languages/english/html_includes/define_testimonials_add.php' (include_path='.:/opt/alt/php74/usr/share/pear') in /home/MY_DIR/public_html/includes/templates/MY_TEMPLATE/templates/tpl_testimonials_add_default.php on line 32
Hoops1122, That error is saying the file doesn't exist. check that the file is actually on the sever and if uploading it doesn't work, delete it, and upload it again.
includes/languages/english/html_includes/define_testimonials_add.php
I have run into a couple of issues after installing this on 1.5.7d
First one is that the All Testimonials Page does not display any testimonials.
https://theengravingshop.co.uk/index...l_testimonials
Second One:
In the admin Configuration > Testimonials Manager - the page loads but doesn't have anything in it. It is completely blank.
I don't have any error logs either so I have no idea what is causing these issues.
This information should help.
https://docs.zen-cart.com/user/troub...ng/blank_page/
Actually it appears to be old testimonials that aren't showing up on front end. New ones appears to be going on there ok.Quote:
Originally Posted by dbltoe
I have managed to get a debug file.Quote:
Originally Posted by Nick1973
[30-Jun-2022 18:20:58 Europe/London] Request URI: /MYADMIN/index.php?cmd=testimonials_manager, IP address: 00000000000
#1 trigger_error() called at [/home/MYWEBSITE/public_html/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/home/MYWEBSITE/public_html/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/home/MYWEBSITE/public_html/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/home/MYWEBSITE/public_html/MYADMIN/includes/classes/split_page_results.php:39]
#5 splitPageResults->__construct() called at [/home/MYWEBSITE/public_html/MYADMIN/testimonials_manager.php:492]
#6 require(/home/MYWEBSITE/public_html/MYADMIN/testimonials_manager.php) called at [/home/MYWEBSITE/public_html/MYADMIN/index.php:11]
--> PHP Fatal error: 1146:Table 'MYWEBSITE_zen2022v157d.testimonials_manager' doesn't exist :: select count(*) as total from testimonials_manager ==> (as called by) /home/MYWEBSITE/public_html/MYADMIN/includes/classes/split_page_results.php on line 39 <== in /home/MYWEBSITE/public_html/includes/classes/db/mysql/query_factory.php on line 171.
The installer script doesn't appear to be installing testimonials manager into configuration. It appears to run ok for the other menu items.
Can somebody give me that piece of SQL so I can get Configuration > Testimonials Manager loaded properly please?
Seems like it's complaining about a missing table versus a setting in a field.Quote:
PHP Fatal error: 1146:Table 'MYWEBSITE_zen2022v157d.testimonials_manager' doesn't exist ::
Yes I know, I worked that one out. I don't think the installer is inserting all the tables in the database.Quote:
Originally Posted by dbltoe
Will Testimonials Manager work on 1.5.8?
It will work, but will produce a ton of php warnings. All easy to fix with isset or empty checks.Quote:
Originally Posted by ideasgirl
Yes, Testimonials Manager v3.0 with onlyQuote:
Originally Posted by balihr
Testimonials Manager for Zen Cart 1.5.8x ONLY
Tested with php 8.1 ==\\== ONLY ==//===
YES, there is new code with new admin stuff...
It's about to put a new with plugins, but I was creating a new idea with testimonials/reviews... even some new stuff for Return manager with new code...
@ davewest
Welcome back! I was beginning to worry about you.
Off subject, but do you have any additions to the DPU i managed to get from your github some time ago? https://github.com/dbltoe/Zen-Cart-D...dater/tree/158
Any hope on having this plugin to work with ZC 2.0?
Thank you
found an updated version that seems to work so far. ( no error logs) if anyone else is lookingQuote:
Originally Posted by nicksab
https://www.zen-cart.com/downloads.php?do=file&id=2369
Somehow it was not coming up when doing a search for "testimonial" in the plugin section
Thanks for hunting it down :-)
Trying to see if it would work with ZC 2.0 and Php 8.3:
I took care of a few errors but I have a stubborn one that keeps popping up:
Any helps would be appreciatedCode:
File Contents( /home/zch1akhw6q3m/public_html/logs/myDEBUG-20250113-135636-895033-warning.log)
[13-Jan-2025 13:56:36 America/Los_Angeles] Request URI: /index.php?main_page=testimonials_manager, IP address: 4.227.36.25, Language id 1
#0 /includes/modules/pages/testimonials_manager/header_php.php(20): zen_debug_error_handler()
#1 /index.php(36): require('/home/zch1akhw6...')
--> PHP Warning: Undefined array key "testimonials_id" in /includes/modules/pages/testimonials_manager/header_php.php on line 20.
Thank you