Testimonial Manager Support Thread (for ZC v1.5.x)

[davewest]

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

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.

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.

[DigitalShadow]

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 in

$dir = 'images/' . TESTIMONIAL_IMAGE_DIRECTORY . '/';

[shags38]

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

[shags38]

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 :) )

I hope you are doing well.

cheers,
Mike

[swguy]

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',

[swguy]

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

?

[davewest]

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.

I'll put down my Python3 cook book and get an update sent in... Or was there an issue with database mySQL versions!

[davewest]

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..

[swguy]

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.

[davewest]

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.