testimonial don't send email to customer when them add testimonial. Why?
Printable View
testimonial don't send email to customer when them add testimonial. Why?
You can search this thread and probably find the answer. Type in testimonial don't send email to see what comes up.Quote:
Originally Posted by 100asa
I don't found nothing of useful to solve issue. with smtp-auth the issue still remain.
Think about it how important is a email to the customer after they have left a testimonial. It's up to you to approve it or not. As long as you are getting one from admin letting you know you have a new testimonial that is all you really need. That function was not part of this module originally. Clyde built that part into the module afterwards. Some have had problems with that feature. It sends me a testimonial email letting me know someone has left one from admin that's all I'm concern with. I doubt the customer would really care if they got one back letting them know that it is now approved. This is not what you want to hear but that is the best I can explain it. If you are on a godaddy server like me that might be the problem.Quote:
Originally Posted by 100asa
I'm not on godaddy, I'm on hostgator.com
I would only to send an email to customer when he left testimonial, so I can give to him a discount coupon to redeem on next order.
Well that can be easily done. When they leave a testimonial, you will be notified from your admin letting you know a customer has left a testimonial. If you want to send a coupon to them click on Gift Certificate/Coupons and send them one.Quote:
Originally Posted by 100asa
Does anyone know how I can configure TM 1.5-2 to display testimonials in a particular order vs. its current random display method in the side-box?
I would greatly appreciate any suggestions.
Thanks all!
Thanks CountryCharm! I wish I read this before I installed the mod on 1.5. I just uploaded the current version of Testimonials. The sidebox and such shows up on the test site, but I don't see any links in the control panel. I eagerly await for the update!Quote:
Originally Posted by countrycharm
I sent you a PMQuote:
Originally Posted by CobraPlant
Just wanted to let everyone know that Testimonial Manager is now compatible with zen cart version 1.5.0. Testimonial Manager will still run on zen cart versions v1.3.8, v1.3.9. May also work with earlier versions. Testimonial Manager does not overwrite any core files.
========================================================
UPGRADING INSTALLATION FOR V1.5.0:
1) Testimonials Manager runs great, but if you have a TEST SERVER try it out before going live.
2) The files in admin/includes/boxes/extra_boxes/ is obsolete and should be deleted or rename to something else until you are confident all is well.
3) A define was added to admin/includes/extra_datafiles/testimonials_manager.php and to
amin/includes/languages/english/extra_definitions/testimonials_manager.php to make this work on zen cart 1.5.0.
4) Go into phpmyadmin and BACKUP THE DATABASE BEFORE INSTALLING.
5) Ensure you have carried out step 4)!
6) This is for v1.5.0 only. There has been a define added so you will have to re-upload the files
admin/includes/extra_definitions/testimonials_manager.php
admin/includes/languages/english/extra_definitions/testimonials_manager.php
Upgrading from 1.3x to zen cart v1.5.0
7) Run the included install_testimonials_manager 1.3.x_Upgrade.sql using the Zen-Cart Sql Patches tool
(admin -> tools -> install sql patches) If you are upgrading.
NEW INSTALLS
1) Upload all files in the zen_1.5.0 folder.
2) Run the included install_testimonials_manager new_install.sql using the Zen-Cart Sql Patches tool
(admin -> tools -> install sql patches) for New Installs
Enjoy.....
=========================================================
Hi CountryCharm,
Thank you for taking over this project. I am in the middle of adding a bunch of old testimonials from 2003-2011 and I don't have dates for them. I don't want them to all have today's date (the default if you leave "date" blank)... I was wondering if you could walk me through hacking things to have functionality like one of these ideas:
idea 1) When adding testimonials through the Admin interface, don't insert today's date if "date" is left blank, just have it leave that field empty so that nothing shows up.
idea 2) having some php that says basically, if date = "specific date" (which I'd set to something like january 1, 2000, 01:00:00--really generic and not likely to ever get used by chance) then echo "(sometime between 2003-2011)"
idea 3) combined with idea 1, if there is no date info in the date field, then have it display "(sometime between 2003-2011)"
Would any of these be possible? What file(s) would I edit? Because it's going to look a little ridiculous to have all of the old testimonials set to today's date. I tried clearing out that field in the database through PHPmyAdmin, but it wouldn't let me, it refilled it with a date. :(
Thanks in advance if you can help me with the above, or if you have any other ideas on how to hide the date for these old testimonials that I'm adding.
Quote:
Originally Posted by WebKat
The MOD uses the current date when adding testimonials. If you want to use older dates you'd have to use phpmyadmin and work directly with the database table for the testimonials and edit the date field.Quote:
I tried clearing out that field in the database through PHPmyAdmin, but it wouldn't let me, it refilled it with a date. :(
Countrycharm thank you for the updated version.
Posted via Mobile Device
No, you don't understand. I don't HAVE dates for these testimonials. I don't have an "older date" to use. I want to be able to have the date be empty and not show up for testimonials that have no date.Quote:
Originally Posted by countrycharm
I know what you are talking about, and It is probably possible but I don't have time to look into it yet. When time permits I will.Quote:
Originally Posted by WebKat
Quote:
Originally Posted by WebKat
and WebKat in the meantime, you will have to edit the DB and include a date in order to use this add-on..Quote:
Originally Posted by countrycharm
OR
if it's a showstopper item and you need it IMMEDIATELY, you can consider investing in paying a developer to make this change for you..
For now I just added some text saying "such and such a date really means '2003-20011'" that shows up underneath the date. It's a good enough solution for a little while, though I don't want to leave it like that indefinitely.
Thanks for your help.
Hello! I try to instal the SQL patch and i get this error
WARNING: An Error occurred, please refresh the page and try again.
i installed the version before this one but i deleted it a while ago. Now that it is compatible i thought i would install it again. I don't know what to do. i deleted everything from the last time i installed. please help! thank you!
Now when i go to my store catalog it also says this
WARNING: An Error occurred, please refresh the page and try again.
:( I'm freaking out.
What version of zen cart are you running? If you are running zen cart 1.5.0 did you use the 1.3.x_Upgrade patch or did you re-run the new.sql patch? You didn't give enough information.Quote:
Originally Posted by Serg
I'm using 1.5 and I did the new install because I deleted the 1.3 version so I figured that's what I needed to do.
Run the uninstall.sql and then re-run the new_install.sql see what happens.Quote:
Originally Posted by Serg
it didn't work. the Uninstall went through fine, but when i run the new_install, i get the error.
There is no way of knowing whats going on without looking at it. If you would PM me and send temporary access to your phpMyAdmin, admin, and ftp I will see what I can do to fix it for you. If not I wouldn't know.Quote:
Originally Posted by Serg
OK all fix now. You were coping and pasting the sql statement new_install.sql the top of the code is for information only and shouldn't have been copied. For example this part is for information only and shouldn't have been copied. It was throwing and error WARNING: An Error occurred, please refresh the page and try again. All fix now. You can see it on your site here.Quote:
Originally Posted by Serg
#Testimonials Manager install SQL
#Designed for: Zen Cart v1.5.0
#Author: Clyde Jones
Updated: By CountryChram
#Version: 1.5.3
#Updated: 1/28/2012
# run this sql patch using the Zen-Cart Sql Patches tool
# (admin -> tools -> install sql patches)
# New configuration options are added to the zen_configuration table.
# For best results, cut-and-paste the code into the query field and press 'Send' instead.
================================================================================ =========
Thank you countrycharm for taking over this add-on. This one really works with v1.50.Quote:
Originally Posted by countrycharm
visit my site: http://indyapparels.com
:oops: I did the same perhapes it would be an idea to remove that section. great mod upgrade once i twiged what i'd done it worked like a charm :clap: well doneQuote:
Originally Posted by countrycharm
OK all fix now. Fix the new.sql statement from throwing the error. Glade you like it enjoy. Waiting on zen to approve it.Quote:
Originally Posted by discoverytdi
Has anyone created an "auto-login" function, via a link, to automatically log a user in to the testimonials page?
I'm setting up a customer follow up email to send after each customer purchase. In the email I'll be asking users to submit a testimonial.
It would be VERY convenient to auto-login a user when they click the link so all they have to do is enter any text.
I know MailBeez has an auto-login feature that links to an individual product review page, and the login is restricted to work only on the review page and not any other account features.
It would be great if this was a feature of the testimonials manager.
I am setting up my website on my computer offline so that I can upgrade to version 1.5 with all the customizations and added mods before replacing my live site. One of the wonderful modifications I have on my live site is Testimonial Manager - a fabulous program!
I have a new install of Zen Cart 1.5 on my computer, with phpmyadmin version 3.4.5. I downloaded testimonial manager 1.5.3a and installed the files, and installed the new_install.sql patch through Admin>tools>install sql patches (without copying the top info part).
I received the following error:
1064 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 'TYPE=MyISAM' at line 1
in:
[CREATE TABLE PVtestimonials_manager ( testimonials_id int(11) NOT NULL auto_increment, language_id int(11) NOT NULL default '1', testimonials_title varchar(64) NOT NULL default '', testimonials_url VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_name text NOT NULL, testimonials_image varchar(254) NOT NULL default '', testimonials_html_text text, testimonials_mail text NOT NULL, testimonials_company VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_city VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_country VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_show_email char(1) default '0', status int(1) NOT NULL default '0', date_added datetime NOT NULL default '0000-00-00 00:00:00', last_update datetime NULL default NULL, PRIMARY KEY (testimonials_id) ) TYPE=MyISAM ;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Admin>configuration>testimonials manager has appeared and is editable.
Testimonials_manager has not appeared in the list under Admin>tools>layout boxes controller.
I have tried uninstalling and reinstalling, with the exact same results. I have no idea what this error message means.
Is there a more knowledgeable person available who can give me some idea of what to do to fix this?
Wendy:(
Hi Wendy I have tested this module and have found not bugs what so ever. I just downloaded the copy I uploaded and tried the new_install.sql statement and it works without any problems. I don't know why you are getting the error. Look in your cache folder to see what myDEBUG is telling you.Quote:
Originally Posted by LadyArlette
Is there a way to not have testimonials show the person's last name? Just for privacy reasons I'd much rather have it show them as "John" or "John S." than "John Smith"... is this a hack I could do easily?
Yes there is a way. Login to your admin/tools/testimonials and click on the persons name and delete the last name and update.Quote:
Originally Posted by WebKat
Oh thanks, I guess that is one solution!
I should not write up a problem report at 2 in the morning and expect to get it right! :oops:
I have installed version 1.3.9h on my computer with the intent to make it match my online system. Then I will figure out how to bring the system to 1.5 on my computer before doing it online.
So - I was installing zen_1.3.9 (not 1.5 as I said incorrectly in my previous post) when I received the error message.
Uninstalling with the sql uninstall patch works perfectly with no errors.
I tried installing the sql patch from the earlier version v1.5.2 of testimonial manager, and received the same error message.
I (finally) have gotten testimonial manager to show up in the admin>tools>layout boxes controller section (a small victory) - but on my catalog where the testimonial box should be I receive the following message instead of the testimonials:
1146 Table 'pillaged_zen.pvtestimonials_manager' doesn't exist
in:
[select testimonials_id, testimonials_image, testimonials_title, testimonials_html_text, date_added from PVtestimonials_manager where status = 1 and language_id = 1 order by rand(), testimonials_title limit 5]
:dontgetit When I installed this mod in my original, live site, I had no trouble at all... I just don't get it!
Although I am grateful that if I have to have trouble, it is on my test site, not on the live site!
So which version of testimonial manager did you download first and install? If you you downloaded version v1.5.3 and installed the folder zen_1.5.0 there is a difference in that version and zen_1.3.9 version. You would have to uninstall it just like you installed it. After that install the v.1.3.9. I think you have files left over from v1.5.0 if that is the original version you first installed.Quote:
Originally Posted by LadyArlette
I'm having a similar problem installing the SQL for a brand-new use of Testimonial Manager 1.5.3a. I've got a fresh 1.5.0 install on my local machine (PHP 5.3.8, mySQL 5.5.16) and ran the new_install.sql (without the lead-in comments) in my admin. Here's what's in my debug log:
[15-Mar-2012 13:44:58] PHP Fatal error: 1064: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 'TYPE=MyISAM' at line 1 :: CREATE TABLE testimonials_manager ( testimonials_id int(11) NOT NULL auto_increment, language_id int(11) NOT NULL default '1', testimonials_title varchar(64) NOT NULL default '', testimonials_url VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_name text NOT NULL, testimonials_image varchar(254) NOT NULL default '', testimonials_html_text text, testimonials_mail text NOT NULL, testimonials_company VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_city VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_country VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_show_email char(1) default '0', status int(1) NOT NULL default '0', date_added datetime NOT NULL default '0000-00-00 00:00:00', last_update datetime NULL default NULL, PRIMARY KEY (testimonials_id) ) TYPE=MyISAM ; in C:\xampp\htdocs\v1.5.0\includes\classes\db\mysql\query_factory.php on line 101
Any ideas?
I haven't tried Testimonial Manager on anything higher than a PHP Version 5.2.17. I don't know if it will run on a PHP 5.3 mySQL or above. I have no way of checking this out yet but I think this is whats causing this error you two are getting.. I'll have to download xampp and see whats going on.Quote:
Originally Posted by lat9
FWIW, the problem has nothing to do with the PHP version. If I copy & paste the install_sql data directly into phpMyAdmin, I get the following message:
The problem is with the creation of the testimonials table ...Code:Error
SQL query:
CREATE TABLE testimonials_manager(
'testimonials_id'int( 11 ) NOT NULL AUTO_INCREMENT ,
'language_id'int( 11 ) NOT NULL default '1',
'testimonials_title'varchar( 64 ) NOT NULL default '',
'testimonials_url'VARCHAR( 255 ) NULL DEFAULT NULL ,
'testimonials_name'text NOT NULL ,
'testimonials_image'varchar( 254 ) NOT NULL default '',
'testimonials_html_text'text,
'testimonials_mail'text NOT NULL ,
'testimonials_company'VARCHAR( 255 ) NULL DEFAULT NULL ,
'testimonials_city'VARCHAR( 255 ) NULL DEFAULT NULL ,
'testimonials_country'VARCHAR( 255 ) NULL DEFAULT NULL ,
'testimonials_show_email'char( 1 ) default '0',
'status'int( 1 ) NOT NULL default '0',
'date_added'datetime NOT NULL default '0000-00-00 00:00:00',
'last_update'datetime NULL default NULL ,
PRIMARY KEY ( 'testimonials_id' )
) TYPE = MYISAM ;
MySQL said: Documentation
#1064 - 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 ''testimonials_id' int(11) NOT NULL auto_increment,
'language_id' int(11) NOT N' at line 2
OK, I finally got it sorted out. I've attached my updated version (that worked for me on MySQL 5.5.16):
Essentially, it was (1) removing the quotes around the column names and (2) changing the TYPE= to ENGINE= on the table creation statement (TYPE= is deprecated).Code:#SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Testimonials Manager';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_TESTIMONIAL_STATUS';
INSERT INTO configuration_group VALUES (NULL, 'Testimonials Manager', 'Testimonials Manager Display Settings', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
#SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Testimonials Manager';
INSERT INTO configuration VALUES (NULL, 'Number Of Testimonials to display in Testimonials Sidebox', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', @t4, 1, NULL, now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Testimonial Title Minimum Length', 'ENTRY_TESTIMONIALS_TITLE_MIN_LENGTH', '2', 'Minimum length of link title.', @t4, 2, NULL, now(), NULL, NULL), (NULL, 'Testimonial Text Minimum Length', 'ENTRY_TESTIMONIALS_TEXT_MIN_LENGTH', '10', 'Minimum length of Testimonial description.', @t4, 3, NULL, now(), NULL, NULL), (NULL, 'Testimonial Text Maximum Length', 'ENTRY_TESTIMONIALS_TEXT_MAX_LENGTH', '1000', 'Maximum length of Testimonial description.', @t4, 3, NULL, now(), NULL, NULL), (NULL, 'Testimonial Contact Name Minimum Length', 'ENTRY_TESTIMONIALS_CONTACT_NAME_MIN_LENGTH', '2', 'Minimum length of link contact name.', @t4, 4, NULL, now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Display Truncated Testimonials in Sidebox', 'DISPLAY_TESTIMONIALS_MANAGER_TRUNCATED_TEXT', 'true', 'Display truncated text in sidebox', @t4, 5, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Length of truncated testimonials to display', 'TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH', '150', 'If Display Truncated Testimonials in Sidebox is true - set the amount of characters to display from the Testimonials in the Testimonials Manager sidebox.', @t4, 6, NULL, now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Number Of Testimonials to display on all testimonials page', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS', '5', 'Set the number of testimonials to display on the all testimonials page.', @t4, 7, NULL, now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Display Date Published on Testimonials page', 'DISPLAY_TESTIMONIALS_DATE_PUBLISHED', 'true', 'Display date published on testimonials page', @t4, 8, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Display View All Testimonials Link In Sidebox', 'DISPLAY_ALL_TESTIMONIALS_TESTIMONIALS_MANAGER_LINK', 'true', 'Display View All Testimonials Link In Sidebox', @t4, 9, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Display Add New Testimonial Link In Sidebox', 'DISPLAY_ADD_TESTIMONIAL_LINK', 'true', 'Display Add New Testimonial Link In Sidebox', @t4, 10, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Testimonial Image Width', 'TESTIMONIAL_IMAGE_WIDTH', '80', 'Set the Width of the Testimonial Image', @t4, 11, NULL, '2007-08-21 12:04:10', NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Testimonial Image Height', 'TESTIMONIAL_IMAGE_HEIGHT', '80', 'Set the Height of the Testimonial Image', @t4, 12, NULL, '2007-08-21 12:04:10', NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Testimonial Image Directory', 'TESTIMONIAL_IMAGE_DIRECTORY', 'testimonials/', 'Set the Directory for the Testimonial Image', @t4, 13, NULL, '2007-08-21 12:04:10', NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Display Company Name field', 'TESTIMONIALS_COMPANY', 'true', 'Display Company Name field', @t4, 14, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Display City field', 'TESTIMONIALS_CITY', 'true', 'Display City field', @t4, 15, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Display Country field', 'TESTIMONIALS_COUNTRY', 'true', 'Display Country field', @t4, 16, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Only registered customers may submit a testimonial', 'REGISTERED_TESTIMONIAL', 'true', 'Only registered customers may submit a testimonial', @t4, 17, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Display All Languages', 'TESTIMONIALS_DISPLAY_ALL_LANGUAGES', 'true', 'Display All Languages', @t4, 18, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Testimonial - Show Store Name and Address', 'TESTIMONIAL_STORE_NAME_ADDRESS', 'true', 'Include Store Name and Address', @t4, 19, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Define Testimonial Status', 'DEFINE_TESTIMONIAL_STATUS', '1', 'Enable the Defined Testimonial Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', @t4, 20, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');
INSERT INTO configuration VALUES (NULL, 'Testimonial Manager Version', 'TM_VERSION', '1.5.2', 'Testimonial Manager version', @t4, 21, NULL, now(), NULL, NULL);
DROP TABLE IF EXISTS testimonials_manager;
CREATE TABLE testimonials_manager (
testimonials_id int(11) NOT NULL auto_increment,
language_id int(11) NOT NULL default '1',
testimonials_title varchar(64) NOT NULL default '',
testimonials_url VARCHAR( 255 ) NULL DEFAULT NULL,
testimonials_name text NOT NULL,
testimonials_image varchar(254) NOT NULL default '',
testimonials_html_text text,
testimonials_mail text NOT NULL,
testimonials_company VARCHAR( 255 ) NULL DEFAULT NULL,
testimonials_city VARCHAR( 255 ) NULL DEFAULT NULL,
testimonials_country VARCHAR( 255 ) NULL DEFAULT NULL,
testimonials_show_email char(1) default '0',
status int(1) NOT NULL default '0',
date_added datetime NOT NULL default '0000-00-00 00:00:00',
last_update datetime NULL default NULL,
PRIMARY KEY (testimonials_id)
) ENGINE=MyISAM ;
INSERT INTO testimonials_manager VALUES (1, 1, 'Great', '', 'Clyde Designs', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', NULL, NULL, NULL, '0', 1, now(), NULL);
/*
zencart 1.5 mods
*/
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('TestimonialsManager', 'BOX_TOOLS_TESTIMONIALS_MANAGER', 'FILENAME_TESTIMONIALS_MANAGER', '', 'tools', 'Y', 35);
INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configTestimonialsManager','BOX_CONFIGURATION_TESTIMONIALS_MANAGER','FILENAME_CONFIGURATION',CONCAT('gID=',@t4), 'configuration', 'Y', @t4);
When I updated Clydes Testimonials Manager to run on zen cart version 1.5.0 I didn't change anything with the install.sql statement. I added a couple lines to run on v.1.5.0. I don't have any problem with the sql statement. This is why I think it has something to do with running on a PHP 5.3. I may be wrong but no one else is having this except you and LadyArlette. I'm going to to test this out tonight on php 5.3 and see whats going on. Thank you for your version of the sql statement that worked for you.Quote:
Originally Posted by lat9
But the SQL statement does have some issues that could cause issues with newer versions of mySQL (as lat9 pointed out TYPE= is indeed deprecated) and the SQL script also contains code that could inadvertently delete items from the configuration table.Quote:
Originally Posted by countrycharm
More importantly here is the reason why when lat9 removed the back quotes (not to be confused with single quotes) around the column names in the create table section of the script the problem was resolved. The syntax issue is the back quotes:
Removing the back quotes solves the issue.Quote:
The error 1064 occurs due to Mysql version mismatch,because differnt versions have differnt
reserved words,which if used by a previous version causes the error to occur.
Not a PHP compatibility issue or you would have seen an error relating to that instead of a SQL error which is indicative of invalid syntax being used in the SQL script.. Besides that Clyde himself certified that this add-on was PHP v5.3 ready with his last release of Testimonials Manager..Quote:
Originally Posted by countrycharm
The fact that you are not having an issue when you run the same script would only seem to indicate that your server is running an older version of mySQL which still supports some of this old (and now invalid) syntax..
and here is the full corrected script...
Oh and if anything I've posted is wrong, I am happy to have someone MUCH wiser than I correct me.. :laugh:Code:SELECT @t4:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Testimonials Manager';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_TESTIMONIAL_STATUS';
INSERT INTO configuration_group VALUES (NULL, 'Testimonials Manager', 'Testimonials Manager Display Settings', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SELECT @t4:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Testimonials Manager';
INSERT INTO configuration VALUES (NULL, 'Number Of Testimonials to display in Testimonials Sidebox', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', @t4, 1, NULL, now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Testimonial Title Minimum Length', 'ENTRY_TESTIMONIALS_TITLE_MIN_LENGTH', '2', 'Minimum length of link title.', @t4, 2, NULL, now(), NULL, NULL), (NULL, 'Testimonial Text Minimum Length', 'ENTRY_TESTIMONIALS_TEXT_MIN_LENGTH', '10', 'Minimum length of Testimonial description.', @t4, 3, NULL, now(), NULL, NULL), (NULL, 'Testimonial Text Maximum Length', 'ENTRY_TESTIMONIALS_TEXT_MAX_LENGTH', '1000', 'Maximum length of Testimonial description.', @t4, 3, NULL, now(), NULL, NULL), (NULL, 'Testimonial Contact Name Minimum Length', 'ENTRY_TESTIMONIALS_CONTACT_NAME_MIN_LENGTH', '2', 'Minimum length of link contact name.', @t4, 4, NULL, now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Display Truncated Testimonials in Sidebox', 'DISPLAY_TESTIMONIALS_MANAGER_TRUNCATED_TEXT', 'true', 'Display truncated text in sidebox', @t4, 5, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Length of truncated testimonials to display', 'TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH', '150', 'If Display Truncated Testimonials in Sidebox is true - set the amount of characters to display from the Testimonials in the Testimonials Manager sidebox.', @t4, 6, NULL, now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Number Of Testimonials to display on all testimonials page', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS', '5', 'Set the number of testimonials to display on the all testimonials page.', @t4, 7, NULL, now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Display Date Published on Testimonials page', 'DISPLAY_TESTIMONIALS_DATE_PUBLISHED', 'true', 'Display date published on testimonials page', @t4, 8, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Display View All Testimonials Link In Sidebox', 'DISPLAY_ALL_TESTIMONIALS_TESTIMONIALS_MANAGER_LINK', 'true', 'Display View All Testimonials Link In Sidebox', @t4, 9, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Display Add New Testimonial Link In Sidebox', 'DISPLAY_ADD_TESTIMONIAL_LINK', 'true', 'Display Add New Testimonial Link In Sidebox', @t4, 10, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Testimonial Image Width', 'TESTIMONIAL_IMAGE_WIDTH', '80', 'Set the Width of the Testimonial Image', @t4, 11, NULL, '2007-08-21 12:04:10', NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Testimonial Image Height', 'TESTIMONIAL_IMAGE_HEIGHT', '80', 'Set the Height of the Testimonial Image', @t4, 12, NULL, '2007-08-21 12:04:10', NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Testimonial Image Directory', 'TESTIMONIAL_IMAGE_DIRECTORY', 'testimonials/', 'Set the Directory for the Testimonial Image', @t4, 13, NULL, '2007-08-21 12:04:10', NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Display Company Name field', 'TESTIMONIALS_COMPANY', 'true', 'Display Company Name field', @t4, 14, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Display City field', 'TESTIMONIALS_CITY', 'true', 'Display City field', @t4, 15, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Display Country field', 'TESTIMONIALS_COUNTRY', 'true', 'Display Country field', @t4, 16, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Only registered customers may submit a testimonial', 'REGISTERED_TESTIMONIAL', 'true', 'Only registered customers may submit a testimonial', @t4, 17, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Display All Languages', 'TESTIMONIALS_DISPLAY_ALL_LANGUAGES', 'true', 'Display All Languages', @t4, 18, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Testimonial - Show Store Name and Address', 'TESTIMONIAL_STORE_NAME_ADDRESS', 'true', 'Include Store Name and Address', @t4, 19, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Define Testimonial Status', 'DEFINE_TESTIMONIAL_STATUS', '1', 'Enable the Defined Testimonial Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', @t4, 20, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');
INSERT INTO configuration VALUES (NULL, 'Testimonial Manager Version', 'TM_VERSION', '1.5.2', 'Testimonial Manager version', @t4, 21, NULL, now(), NULL, NULL);
DROP TABLE IF EXISTS testimonials_manager;
CREATE TABLE testimonials_manager (
testimonials_id int(11) NOT NULL auto_increment,
language_id int(11) NOT NULL default '1',
testimonials_title varchar(64) NOT NULL default '',
testimonials_url VARCHAR( 255 ) NULL DEFAULT NULL,
testimonials_name text NOT NULL,
testimonials_image varchar(254) NOT NULL default '',
testimonials_html_text text,
testimonials_mail text NOT NULL,
testimonials_company VARCHAR( 255 ) NULL DEFAULT NULL,
testimonials_city VARCHAR( 255 ) NULL DEFAULT NULL,
testimonials_country VARCHAR( 255 ) NULL DEFAULT NULL,
testimonials_show_email char(1) default '0',
status int(1) NOT NULL default '0',
date_added datetime NOT NULL default '0000-00-00 00:00:00',
last_update datetime NULL default NULL,
PRIMARY KEY (testimonials_id)
);
INSERT INTO testimonials_manager VALUES (1, 1, 'Great', '', 'Clyde Designs', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', NULL, NULL, NULL, 0, 1, now(), NULL);
/*
zencart 1.5 mods
*/
INSERT INTO admin_pages (page_key, language_key, main_page, page_params, menu_key, display_on_menu, sort_order) VALUES ('TestimonialsManager', 'BOX_TOOLS_TESTIMONIALS_MANAGER', 'FILENAME_TESTIMONIALS_MANAGER', '', 'tools', 'Y', 35);
INSERT INTO admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES ('configTestimonialsManager','BOX_CONFIGURATION_TESTIMONIALS_MANAGER','FILENAME_CONFIGURATION',CONCAT('gID=',@t4), 'configuration', 'Y', @t4);
Quote:
Originally Posted by DivaVocals
** deleted **
Quote:
Originally Posted by DivaVocals
I understood what he was saying. I was going to see and checkout for myself. And yes I was planing on updating the sql statement.. Just give me a little time Diva "please":DQuote:
Originally Posted by DivaVocals
I installed the PHP 5.3.8, mySQL 5.5.16 version of xampps. Yes this mySQL 5.5.16 version does has issues with the install.sql statement for Testimonials Manager. Thanks again lat9 for your updated version of the new_install.sql statement. I have updated Testimonials Managers sql.statement. It has been uploaded waiting for approval from the zen team.Quote:
Originally Posted by lat9
Thanks Diva for waiting on me.......:clap:
Sorry for the delay - work keeps getting in the way of progress. :blink:
I may have tried to install the patch for testimonial manager 1.5 initially, but I uninstalled completely more than once in trying to make it work. I had no problems with the uninstall sql, and did a Windows explorer "search and destroy" for any files containing the word "testimonial" too.
When I was uninstalling I did look at the tables to see if there were any testimonial tables, and I did not see any.
I am using:
Apache/2.2.21 (Win32)
PHP/5.3.8
MySQL/5.5.16
PHPmyAdmin/3.4.5
I entered the new updated sql patch into the SQL Query Executor on my computer and ran it, and received the following error:
1064 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 'TYPE=MyISAM' at line 7
in:
[CREATE TABLE PVPVupgrade_exceptions ( upgrade_exception_id smallint(5) NOT NULL auto_increment, sql_file varchar(50) default NULL, reason varchar(200) default NULL, errordate datetime default '0001-01-01 00:00:00', sqlstatement text, PRIMARY KEY (upgrade_exception_id) ) TYPE=MyISAM ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
(incidentally, PV is the table prefix for my database tables)
I brought up my website on my computer, and the testimonial manager appears to be working now! Yippee! :clap:
Since testimonial manager appears to be working, I am going to go forward now, and assume this error message is not something about which to be concerned.
Thank you very much for your help and the updated sql patch!
Wendy
No worries..:smile:Quote:
Originally Posted by countrycharm
FYI for future reference, the error message number is the hint that will tell you if it's a SQL error versus a PHP error.. 1064 is a mySQL syntax error message. And despite the long winded nature of error messages, the first part of most error messages really do tell you a good deal about an error and it's source: 1064:You have an error in your SQL syntax;
Additional reading on this (in case you're interested):smile::
https://www.google.com/search?q=mySQ...ient=firefox-a
http://dev.mysql.com/doc/refman/5.5/...es-server.html)
In the meantime, and MOST importantly you need to use the updated SQL script I posted for your update submission.. The one lat9 posted still contains code that could inadvertently delete records from the configuration table.. You can simply resubmit it you do not have to wait for the submission you posted today to be approved. Simply reply to the e-mail you got acknowledging your submission and let the admins know you will be submitting a replacement update.. Then re-submit it with the SQL I posted..
Specifically this part is problematic:
(The Zen Cart v1.5 threads on updating mods cover this and WHY it should NOT be included in SQL scripts for add-ons. If you recall I took this same kind of code out of the SQL for the Rewards points SQL)Code:#SET @t4=0;
SELECT (@t4:=configuration_group_id) as t4
FROM configuration_group
WHERE configuration_group_title= 'Testimonials Manager';
If you'll notice, I had turned the problematic SET statements into comments ... thus also removing the problem.Quote:
Originally Posted by DivaVocals
Hi Diva I basically redid sql statement like you said in the first place. The only thing I didn't do was take out the engine part. Thank You for pointing that out. :bigups: I did some reserch on MyISAM vs InnoDB and found out With the release of MySQL 5.5, InnoDB has become the default storage engine so thank you again. This will maybe cause others not to have the error when installing this module.Quote:
Originally Posted by DivaVocals
And thanks for the other 2 links for the sql errors.
Yes you did, but I we decided to remove them just in case others might not have understood what that was for.Quote:
Originally Posted by lat9
Has been updated and submitted to the downloads. Thanks again Diva, lat9 for the help you provided.Quote:
Originally Posted by countrycharm
You didn't specify InnoDB in your SQL did you?? It would be better to take out the engine altogether than to include one that may not be supported by the shopowner's host.. Not including an engine won't harm anything as the default will be used. Unless there is a reason why a specific DB engine is needed, not including it in the create table statement won't affect the add-on.. (You can take a look at other add-ons and see that it's not always included in create table statements)Quote:
Originally Posted by countrycharm
You're welcome..:smile:Quote:
Originally Posted by countrycharm
Na I didn't include and engine at all.Quote:
Originally Posted by DivaVocals
I was just letting you know what I read and learned.....:clap:
Cool!! :smile:Quote:
Originally Posted by countrycharm
I've got a multilingual site and enabled the "Display All Languages" in the Testimonial Manager admin section (TESTIMONIALS_DISPLAY_ALL_LANGUAGES is the database key). I had a couple of test testimonials in English and switched to a Spanish display ... and none were displayed. Turns out that the database key (above) isn't used at all.
Here's an updated version of /includes/modules/pages/display_all_testimonials/header_php.php that corrects the problem:
Code:<?php
/**
* Testimonials Manager
*
* @package Template System
* @copyright 2007 Clyde Jones
* @copyright Portions Copyright 2003-2007 Zen Cart Development Team
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: Testimonials_Manager.php v1.5.2 4-16-2010 Clyde Jones $
*/
require(DIR_WS_MODULES . 'require_languages.php');
$breadcrumb->add(NAVBAR_TITLE);
$which_languages = (TESTIMONIALS_DISPLAY_ALL_LANGUAGES == 'true') ? '' : (" and language_id = '" . (int)$_SESSION['languages_id'] . "'");
$testimonials_query_raw = "select * from " . TABLE_TESTIMONIALS_MANAGER . " where status = 1" . $which_languages . " order by date_added DESC, testimonials_title";
$testimonials_split = new splitPageResults($testimonials_query_raw, MAX_DISPLAY_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS);
//EOF
The reason that the customer email is not being sent is this line in /includes/languages/english/YOUR_TEMPLATE/testimonials_add.php:Quote:
Originally Posted by 100asa
The trailing "\n\n" causes the zen_mail function to abort the send because there are new-line characters in the email subject. Simply removing those characters as below enables the customer emails to be sent.Code:define('EMAIL_SUBJECT', 'Your Testimonial Submission At ' . STORE_NAME . '.' . "\n\n");
Code:define('EMAIL_SUBJECT', 'Your Testimonial Submission At ' . STORE_NAME . '.');
I would like to manually put all the testimonials in myself.
I would like to get rid of the "Author's name", "Author's email", and "Testimonial's Title" requirements.
I basically want it setup where I format the whole testimonial in the Testimonial box. I would want to put the name, and company of the testimonial here without their email address.
Also, how would I get rid of "view all testimonials" and "add a testimonial"?
I'm basically looking to use this sidebox to input my own text through the testimonials manager.
Thank you!
-Brian
@ Brian
you could use a blank sidebox available through the download section and set up a static page for your detailed testimonials. Putting a link in the sidebox to your page.
The admin editable sidebox would probably be better.. BUT if we continue this line of discussion (alternatives to this add-on) we should move it off of this support thread..Quote:
Originally Posted by BillyBoyle
I am currently busy with my site to convert to 139, but I am getting an error when installing this script.
I am currently working in Xampp for my site to get right before I go live
What am I doing wrong?
I get also this error by installing a new version of the software.
And the SQL version of Xampp is 5.5.20
Please help!!PHP Code:1064 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 'TYPE=MyISAM' at line 1
in:
[CREATE TABLE testimonials_manager ( testimonials_id int(11) NOT NULL auto_increment, language_id int(11) NOT NULL default '1', testimonials_title varchar(64) NOT NULL default '', testimonials_url VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_name text NOT NULL, testimonials_image varchar(254) NOT NULL default '', testimonials_html_text text, testimonials_mail text NOT NULL, testimonials_company VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_city VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_country VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_show_email char(1) default '0', status int(1) NOT NULL default '0', date_added datetime NOT NULL default '0000-00-00 00:00:00', last_update datetime NULL default NULL, PRIMARY KEY (testimonials_id) ) TYPE=MyISAM ;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Quote:
Originally Posted by mdo82
So you are installing testimonials manager on zen cart v1.3.9 correct?Quote:
I am currently busy with my site to convert to 139, but I am getting an error when installing this script.
The problem you are having is the engine type, TYPE=MyISAM.
in the install.sql. To correct this just remove the code
) TYPE=MyISAM ; to show );
Just copy this install.sql
PHP Code:SELECT @t4:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Testimonials Manager';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_TESTIMONIAL_STATUS';
INSERT INTO configuration_group VALUES (NULL, 'Testimonials Manager', 'Testimonials Manager Display Settings', '1', '1');
UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();
SELECT @t4:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Testimonials Manager';
INSERT INTO configuration VALUES (NULL, 'Number Of Testimonials to display in Testimonials Sidebox', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', @t4, 1, NULL, now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Testimonial Title Minimum Length', 'ENTRY_TESTIMONIALS_TITLE_MIN_LENGTH', '2', 'Minimum length of link title.', @t4, 2, NULL, now(), NULL, NULL), (NULL, 'Testimonial Text Minimum Length', 'ENTRY_TESTIMONIALS_TEXT_MIN_LENGTH', '10', 'Minimum length of Testimonial description.', @t4, 3, NULL, now(), NULL, NULL), (NULL, 'Testimonial Text Maximum Length', 'ENTRY_TESTIMONIALS_TEXT_MAX_LENGTH', '1000', 'Maximum length of Testimonial description.', @t4, 3, NULL, now(), NULL, NULL), (NULL, 'Testimonial Contact Name Minimum Length', 'ENTRY_TESTIMONIALS_CONTACT_NAME_MIN_LENGTH', '2', 'Minimum length of link contact name.', @t4, 4, NULL, now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Display Truncated Testimonials in Sidebox', 'DISPLAY_TESTIMONIALS_MANAGER_TRUNCATED_TEXT', 'true', 'Display truncated text in sidebox', @t4, 5, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Length of truncated testimonials to display', 'TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH', '150', 'If Display Truncated Testimonials in Sidebox is true - set the amount of characters to display from the Testimonials in the Testimonials Manager sidebox.', @t4, 6, NULL, now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Number Of Testimonials to display on all testimonials page', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS', '5', 'Set the number of testimonials to display on the all testimonials page.', @t4, 7, NULL, now(), NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Display Date Published on Testimonials page', 'DISPLAY_TESTIMONIALS_DATE_PUBLISHED', 'true', 'Display date published on testimonials page', @t4, 8, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Display View All Testimonials Link In Sidebox', 'DISPLAY_ALL_TESTIMONIALS_TESTIMONIALS_MANAGER_LINK', 'true', 'Display View All Testimonials Link In Sidebox', @t4, 9, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Display Add New Testimonial Link In Sidebox', 'DISPLAY_ADD_TESTIMONIAL_LINK', 'true', 'Display Add New Testimonial Link In Sidebox', @t4, 10, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Testimonial Image Width', 'TESTIMONIAL_IMAGE_WIDTH', '80', 'Set the Width of the Testimonial Image', @t4, 11, NULL, '2007-08-21 12:04:10', NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Testimonial Image Height', 'TESTIMONIAL_IMAGE_HEIGHT', '80', 'Set the Height of the Testimonial Image', @t4, 12, NULL, '2007-08-21 12:04:10', NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Testimonial Image Directory', 'TESTIMONIAL_IMAGE_DIRECTORY', 'testimonials/', 'Set the Directory for the Testimonial Image', @t4, 13, NULL, '2007-08-21 12:04:10', NULL, NULL);
INSERT INTO configuration VALUES (NULL, 'Display Company Name field', 'TESTIMONIALS_COMPANY', 'true', 'Display Company Name field', @t4, 14, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Display City field', 'TESTIMONIALS_CITY', 'true', 'Display City field', @t4, 15, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Display Country field', 'TESTIMONIALS_COUNTRY', 'true', 'Display Country field', @t4, 16, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Only registered customers may submit a testimonial', 'REGISTERED_TESTIMONIAL', 'true', 'Only registered customers may submit a testimonial', @t4, 17, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Display All Languages', 'TESTIMONIALS_DISPLAY_ALL_LANGUAGES', 'true', 'Display All Languages', @t4, 18, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Testimonial - Show Store Name and Address', 'TESTIMONIAL_STORE_NAME_ADDRESS', 'true', 'Include Store Name and Address', @t4, 19, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO configuration VALUES (NULL, 'Define Testimonial Status', 'DEFINE_TESTIMONIAL_STATUS', '1', 'Enable the Defined Testimonial Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', @t4, 20, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');
INSERT INTO configuration VALUES (NULL, 'Testimonial Manager Version', 'TM_VERSION', '1.5.2', 'Testimonial Manager version', @t4, 21, NULL, now(), NULL, NULL);
DROP TABLE IF EXISTS testimonials_manager;
CREATE TABLE testimonials_manager (
testimonials_id int(11) NOT NULL auto_increment,
language_id int(11) NOT NULL default '1',
testimonials_title varchar(64) NOT NULL default '',
testimonials_url VARCHAR( 255 ) NULL DEFAULT NULL,
testimonials_name text NOT NULL,
testimonials_image varchar(254) NOT NULL default '',
testimonials_html_text text,
testimonials_mail text NOT NULL,
testimonials_company VARCHAR( 255 ) NULL DEFAULT NULL,
testimonials_city VARCHAR( 255 ) NULL DEFAULT NULL,
testimonials_country VARCHAR( 255 ) NULL DEFAULT NULL,
testimonials_show_email char(1) default '0',
status int(1) NOT NULL default '0',
date_added datetime NOT NULL default '0000-00-00 00:00:00',
last_update datetime NULL default NULL,
PRIMARY KEY (testimonials_id)
);
INSERT INTO testimonials_manager VALUES (1, 1, 'Great', '', 'Clyde Designs', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', NULL, NULL, NULL, 0, 1, now(), NULL);
Quote:
Originally Posted by mdo82
TYPE is deprecatedCode:TYPE=MyISAM
use ENGINE instead
Code:ENGINE=MyISAM
Thank you that was the trick to solve it.Quote:
Originally Posted by gilby
But I'm against another problem.
In my Live store, I have under tools a button for testimonial manager , I miss this in version 1.39 and I can see him even to activate the testmonial sitebox.
Do I missing something?
I have also try the code from countrycharm
Could I ask .How difficult would it be to add the 5 star system to testimonials. As I find it so much easier than reviews
thanks
Quote:
Originally Posted by lat9
Quote:
Originally Posted by lat9
A new update has been submitted in the downloads for the above.Quote:
Originally Posted by DivaVocals
Updated the new_install.sql because TYPE is deprecated for
engine. Also updated and fix the Display All Languages header_php.php file
to display on a multilingual site. Also fix a bug for not sending out emails after a customer submits a Testimonial.
Also we are giving thanks to Diva and lat9 for there support in the updates.
Thank You! :yes:
An update to Testimonial Manager that I submitted recently has been activated, and is now available in the downloads. Details of the Testimonial Manager update are as follows:Quote:
Originally Posted by countrycharm
Title : Testimonial Manager
Version : 1.5.3c
There is no install.txt or upgrade.txt in the 1.5.0 folder. I am upgrading--what do I do differently than a fresh install? I've edited a few files so that customers' last names don't show up on their testimonials and I don't want to lose those changes...
I just downloaded a copy of Testimonial Manager Version : 1.5.3cQuote:
Originally Posted by WebKat
and it has the install.txt inside the folder of zen_1.5.0. You have to open the install.txt up and read it NEW AND UPGRADING INSTALLATION:
For all of you who doesn't know how......Quote:
Originally Posted by countrycharm
UPGRADING FROM PREVIOUS VERSIONS OF TESTIMONIALS MANAGER INSTALLATION:
===================================================================
1) Testimonials Manager Module runs great, but if you have a TEST SERVER try it out before going live.
2) The files in admin/includes/boxes/extra_boxes/ is obsolete and should be deleted or rename to something else until you are confident all is well.
3) A define was added to admin/includes/extra_datafiles/testimonials_manager.php and to
amin/includes/languages/english/extra_definitions/testimonials_manager.php to make this work on zen cart 1.5.0.
4) Go into phpmyadmin and BACKUP THE DATABASE BEFORE INSTALLING.
5) Ensure you have carried out step 4)!
6) This is for v1.5.0 only. There has been a define added so you will have to re-upload the files
admin/includes/extra_definitions/testimonials_manager.php
admin/includes/languages/english/extra_definitions/testimonials_manager.php
7) Run the included install_testimonials_manager 1.3.x_Upgrade.sql using the Zen-Cart Sql Patches tool
(admin -> tools -> install sql patches) For best results, copy-and-paste the code into the query field and press 'Send'.
Ok so what about the sql patch? The 139 folder has an upgrade folder with a upgrade_testimonial_manager.sql file in it... there is no upgrade sql file in the 150 folder. What do I do? Run the install patch? Run the 139 upgrade patch? I really think this would have been a much better release if it was consistent between the two ZC versions. It's very confusing when you read a file telling you to open a file that doesn't exist, for example.
This is all in the folder zen_1.5.0.Quote:
Originally Posted by WebKat
7) Run the included install_testimonials_manager 1.3.x_Upgrade.sql using the Zen-Cart Sql Patches tool
(admin -> tools -> install sql patches) For best results, copy-and-paste the code into the query field and press 'Send'.
The part that made this whole thing frustrating was the readme in the main folder of the unzipped file:
This should be made more clear, since it is NOT the correct directions for 1.5.0.Quote:
INSTALLATION:
See the install text depending on what version you are installing:
install.txt
upgrade.txt
uninstall.txt
And the bit you just quoted is for upgrading ZEN CART from 1.3x to 1.5.0, right? If not it's confusingly worded. I've never used ZC 1.3.x; I started out my whole Zen Cart odyssey with ZC 1.5.0--so in my case, what file do I run? If this is the one I'm supposed to run it's badly named: install_testimonials_manager new_install.sql since this is not a new install--I already have Testimonial Manager installed. On 1.5.0.
Actually, I can't even find that file anywhere. I found a 1.3.x_Upgrade.sql (which sounds wrong since I'm not, and never have been, on 1.3.x) and new_install.sql (which sounds wrong, since it's not a new install). So the instructions are not clear at ALL about how to upggrade Testimonial Manager under a ZC 1.5.0 installation. The directions in the 1.3.9 folder may be clearer, but they don't apply to me so that doesn't matter much.
See if these install instructions help:
Notes:
- BACKUP THE DATABASE BEFORE INSTALLING!!!
- You should test this on TEST SITE before going live
- Two files were added to make this work on zen cart 1.5.
- admin/includes/extra_datafiles/testimonials_manager.php
- admin/includes/languages/english/extra_definitions/testimonials_manager.ph
New Install Instructions
- Unzip the contribution.
- Open the New_installation folder
- Before uploading change the YOUR_TEMPLATE folders to match the name of your custom template.
- includes/languages/english/extra_definitions/YOUR_TEMPLATE
- includes/languages/english/YOUR_TEMPLATE
- includes/languages/english/html_includes/YOUR_TEMPLATE
- includes/modules/sideboxes/YOUR_TEMPLATE
- includes/templates/YOUR_TEMPLATE
- (The files are arranged in the same structure as Zen Cart so you can FTP the admin, images and includes folders to your server.)
- Login in to your admin panel admin -> tools -> layout boxes contoller and activate the new sidebox.
- Run the included new_install.sql using the Zen-Cart Sql Patches tool (admin -> tools -> install sql patches).
Upgrading Testimonial Manager from 1.3x compatible version to v1.5.0 ready version
- If you are upgrading from an older Zen Cart v1.3.x compatible version of Testimonial Manager run the included 1.3.x_Upgrade.sql using the Zen-Cart Sql Patches tool (admin -> tools -> install sql patches)
For best results, copy-and-paste the code into the query field and press 'Send'.- Delete the files in admin/includes/boxes/extra_boxes/ (these files are now are obsolete and should be deleted in their entirety!!)
Ok so the difference is that the previous Testimonials Manager was for 1.3.9 and the new one is for 1.5.0, and that is the upgrade they're referring to? That makes sense written out that way, but is not clear at all in the text file that came in the zip for the new version. Those instructions made it look like this is what you should do if you're upgrading ZC from 1.3.x to 1.5.0.
I hope I'm not coming across as cranky or anything (I'm not cranky, I promise!)--I am legitimately trying to help make the upgrade package more user-friendly which will lead to fewer people coming to the support thread asking questions, and less time for the developers to spend answering them. I have some suggestions for how to make this package better and confusion-proof.
Basically I recommend this:
The zen_1.3.9 folder is very well laid out:
That is so clear and unconfusing. The filenames are intuitive and it's obvious what they mean/do. There is a separate folder for install and upgrade (even though they likely have many duplicate files). This is a well put together package.Quote:
Folder structure:
/new_installation/admin/upgrade
/images
/includes
install_testimonials_manager.sql/admininstall.sql
/images
/includes
upgrade_testimonial_manager.sql
install.txt
uninstall.sql
uninstall.txt
upgrade.txt
The zen_1.5.0 folder, on the other hand, is much less organized and more confusing:
Quote:
Folder structure:
/admin
/images
/includes
1.3.x_Upgrade.sql
install.txt
new_install.sql
uninstall.sql
uninstall.txt
- The upgrade instructions are buried in a rather muddy way within the install instructions file--nonintuitive.
- The sql patch looks like it's for a different ZC version--nonintuitive.
- There is no obvious breakdown of which files need to be uploaded for an upgrade (probably some subset of the total new install files); a separate folder like the 1.3.9 folder would solve this cleanly. Putting the upgrade sql patch in that folder would make things much clearer as well.
- install.txt includes the instruction: "3) Run the included install_testimonials_manager new_install.sql using the Zen-Cart Sql Patches tool (admin -> tools -> install sql patches) for New Installs" yet there is no file with that name in the zipped package--erroneous text.
- Step 4 prefix "Upgrading from 1.3x to zen cart v1.5.0" is unclear--it should be reworded to make it clear that it's referring to the module compatibility version, not to your ZC install version--unclear.
- I'd rename "1.3.x_Upgrade.sql" to just "upgrade.sql" or "1-5-3c-upgrade.sql" or similar for clarity.
Sorry to be so long-winded, I just wanted to be extremely clear about what I am recommending be changed. If the package were set up the way I describe, I would not have needed to ask *any* questions in this thread, and would have been able to simply upgrade my module on my own, confident that I had done it correctly. I hope my advice is taken in the spirit in which it is offered and not as a slam of any kind.
If the package were reorganized using the 1.3.9 folder as a model for the 1.5.0 folder, and the instructions were broken down into install vs upgrade, etc--the changes I've suggested--and then upload that newly reorganized zip to the addons page, I bet you will experience many fewer support questions in this thread, and fewer frustrated users (it's always frustrating when you have to wait for your support question to be answered, in the meantime you can't proceed with your install/upgrade). Between the changes I've suggested and making the clarifications that the previous post made, this would be a much stronger release.
I apologize if this has sounded overly critical--it's just that I'm trying to be clear. When you've written instructions yourself, they always make sense to you. It's hard to gauge how a 3rd party will do with them until one tells you. You've gone 50% of the way with the well-organized 1.3.9 folder. Take it the rest of the way and organize the 1.5.0 folder just as well and you'll be golden. It's a great module--I have it installed on two different sites and really like it.
By the way, I hope it isn't considered bad form, but if you don't want your customers' last names to show up on their testimonials (privacy issues) you can follow these edits that I made to my installation which makes it just show the first name:
File to edit:
/includes/modules/pages/testimonials_add/header_php.php
Replace the default code to this new code; line numbers may be approximate--make sure the one you're replacing is very similar to the replacement code:
Line 126Line 132Code:$account_query = "select customers_firstname, customers_email_address
Line 150Code:$extra_info=email_collect_extra_info($name,$email_address, $account->fields['customers_firstname'] . ' ' . $account->fields[''] , $account->fields['customers_email_address'] );
Line 155Code:$sql = "SELECT c.customers_id, c.customers_firstname, c.customers_email_address, c.customers_default_address_id, c.customers_telephone, ab.customers_id, ab.entry_street_address, ab.entry_company, ab.entry_city, ab.entry_postcode, ab.entry_zone_id, ab.entry_country_id, z.zone_id, z.zone_code, cn.countries_id, cn.countries_name FROM " . TABLE_CUSTOMERS . " c, " . TABLE_ADDRESS_BOOK . " ab, " . TABLE_ZONES . " z, " . TABLE_COUNTRIES . " cn WHERE c.customers_id = :customersID AND ab.customers_id = :customersID AND ab.entry_country_id = cn.countries_id";
That should do it. It should never call their last name in the first place, so you don't need to "hide" it in the displayed testimonial, since that bit of information isn't there to begin with.Code:$testimonials_name = $check_customer->fields['customers_firstname'] . ' ' . $check_customer->fields[''];
And if you look JUST ABOVE your post I re-wrote the instructions to help make it clear what to do.. DO THEY make more sense to you?? (that would help the current author who is doing this in their FREE TIME)
or
Since you seem to have some very good and strong ideas here, how about contributing to the community by making the very changes you suggest including re-writing the readme instructions.. My first Zen Cart contributions were more about a reorganization of the files and a re-write of the readme files and less about upgrades and improvements.. why not make these changes you suggest and re-submit this add-on??
Quote:
Originally Posted by WebKat
Yes, I know--I acknowledged that and pointed out that your instructions were far easier to follow, and suggested that they change the instructions to be more like yours. Don't know why you're getting all worked up. I specifically said that with those instructions and better folder structure I'd have had no questions at all about the upgrade.Quote:
Originally Posted by DivaVocals
...is that kosher? I mean that seems like it could be stepping on some toes. Also, I don't have enough information. For example, I don't know which files need to be uploaded for upgrading and which can be left as the old versions.Quote:
Originally Posted by DivaVocals
Worked up?? Really?? that's what you got out of my post??? I always FAIL to understand how folks read emotions and sentiments into posts that JUST AREN'T there..:no: I just asked you a question because honestly in that long post you wrote I didn't see anything that looked like you had seen what I wrote.. (which is why I asked the question..) But okay.. thanks for the response..Quote:
Originally Posted by WebKat
It's open source.. which means it's OPEN to anyone who wants to volunteer to contribute.. Now if you want to make sure you're not stepping on anyone's toes you can approach it one of two ways..Quote:
Originally Posted by WebKat
- Contact the author and offer to help by implementing the suggestions you made. You guys can coordinate how you will work together..
OR
- post a message to the current author in the support thread of your desire/intent to make the changes you suggest.. Then again you guys can coordinate and decide how you will work together..
This is PRECISELY how I got started submitting updates to add-ons.. I offered publicly to help the person who was re-writing IH2 to be PHP 5.3 compatible. I offered to take on re-writing the user documents and reorganizing the installation files. It's how the current "team" of folks working on IH4 got together..
So YES you sure can do this! :yes:
I thought this was made clear in the sample instructions I posted.. Are you saying it's NOT??Quote:
Originally Posted by WebKat
Either way if you decide to contact the current author, you can work on this TOGETHER..
I will take what WebKat said into consideration. The install.txt could be bettered outline. to a upgrade.txt. Thanks Diva for that.Quote:
Originally Posted by DivaVocals
If you where already on a zen cart v1.5.0 and had Testimonials Manager installed why are you trying to install it again? That is what doesn't make since.Quote:
I've never used ZC 1.3.x; I started out my whole Zen Cart odyssey with ZC 1.5.0--so in my case, what file do I run? If this is the one I'm supposed to run it's badly named: install_testimonials_manager new_install.sql since this is not a new install--I already have Testimonial Manager installed. On 1.5.0.
Because it was a newer version, I figured some things had changed.Quote:
Originally Posted by countrycharm
Well, I said this "Ok so the difference is that the previous Testimonials Manager was for 1.3.9 and the new one is for 1.5.0, and that is the upgrade they're referring to? That makes sense written out that way, but is not clear at all in the text file that came in the zip for the new version." which I thought made it clear that I understood YOUR instructions but not the ones that came in the zip. As for why I thought you were worked up, it was the large font and the repeated use of ALL CAPS which made it seem that you were annoyed.Quote:
Originally Posted by DivaVocals
As for the files--no, it wasn't clear from either set of instructions whether any/some/none of the files needed to be uploaded. It appears now that you're saying that the only file change is getting rid of that folder, and that the only other change is an sql patch. If that's the case, it should be spelled out specifically; i.e. "No files need to be updated; remove the folder blah blah blah"
Anyway I'd be happy to help put together a new update package once I know for sure that I know what the details really are.
Oh, and it looks like it also says to re-upload these two files:
admin/includes/extra_definitions/testimonials_manager.php
admin/includes/languages/english/extra_definitions/testimonials_manager.php
However, saying to upload those two files isn't the same as saying to upload ONLY those two files, IMO. It's always best to err on the side of being more clear than assuming that someone will infer your meaning.
Like I said why don't you take a stab at making these updates?? You've got some ideas for improvements and if you feel that you can improve it, you should absolutely give it a shot..Quote:
Originally Posted by WebKat
Did you not see my post just above?Quote:
Originally Posted by DivaVocals
Quote:
Anyway I'd be happy to help put together a new update package once I know for sure that I know what the details really are.
I saw your post and my suggestions with this regard remain the same.. download the add-on and give updating it a shot.. contact the current author and work out how you can collaborate on this.. pretty easy peezy..:smile:Quote:
Originally Posted by WebKat
Oh I already did download and install the add-on, but now I'm confused because they said...so I'm not sure what is going on. Is this the same version I already had or not? I uploaded all the files and ran the upgrade patch, then added back in my modifications to remove the last name... but I'm not entirely sure based on that last comment what this upgrade is actually for. What it's upgrading from and what it's upgrading to. Since the developer seems to think it's strange that I upgraded at all... I'm just confused now.Quote:
If you where already on a zen cart v1.5.0 and had Testimonials Manager installed why are you trying to install it again? That is what doesn't make since.
Understood.. Maybe you guys should exchange emails offline and have a discussion so you can get an understanding???Quote:
Originally Posted by WebKat
Good call.
countrycharm, if you would like my help in setting up a distribution package for this upgrade I'd be happy to help... you can email me at webkat at webica.com.
Quote:
Originally Posted by countrycharm
All I was saying if everything was working fine for you in the first place why update. If you have read any of the thread a few pages back before you posted you would have seen that there were some minor things updated. Again if everything was working you didn't need to update. I will update this module sometime this coming week with the new install.txtQuote:
Originally Posted by WebKat
I'm generally in the habit of keeping modules/plugins/scripts/etc. up-to-date with the most recent version. If I see an updated version has been released I generally update my copy to stay current. It's a lesson I learned the hard way a few times by failing to do so.
Sounds like some good things are coming for this add-on.. I do think WebKat makes some good points and perhaps it makes sense for you giuys to work together on the next release to incorporate some of these ideas..:DQuote:
Originally Posted by countrycharm
I Will keep this in mind unless there is a demand for it. Since the original author wrote the module like this in the first place I think I will leave it as is. Thank you for the your input.Quote:
Originally Posted by WebKat
Quote:
Originally Posted by WebKat
Thanks you for your concern and support. Webkat you did have some valid points and thank you for bringing them up. I have created and upgrade folder and created a upgrade.txt file. Maybe this will be a lot easier for the installer. Thank AgainQuote:
Originally Posted by DivaVocals
Waiting on zen to approve it in the downloads.
You may want to put it in the install/upgrade/whatever text file as an optional modification. It seems like having your full name displayed on a testimonial might frighten off a lot of people who would otherwise write one, so it seems like the ability to set it to not display would be one a decent amount of people would like (who may not have thought of it before seeing it as an option). Several modules I've downloaded have had instructions for various tweak/hacks in their documentation, so it wouldn't be unusual.Quote:
Originally Posted by countrycharm
Great!!!:bigups:Quote:
Originally Posted by WebKat
Gonna say this again..:smile: YOU can also make these changes and submit them if you REALLY feel strongly that they should be a part of the add-on.. This would be an excellent place for you to make such a contribution!
Quote:
Originally Posted by WebKat
Yes that OK with me. Feel free to update and make the change. Just wait until I let you know that when the new update has been approved.Quote:
Originally Posted by DivaVocals
The blank sidebox worked great! Thank you!Quote:
Originally Posted by BillyBoyle
:bigups: your welcome.Quote:
Originally Posted by stoneroses6300
Quote:
Originally Posted by WebKat
Quote:
Originally Posted by DivaVocals
OK this update is now active in the downloads area. Webkat feel free to to do what you have suggested if you like to make such a contribution!Quote:
Originally Posted by countrycharm
Looks much better--much less confusing. I still made a few changes and sent you a PM with a download link to a new zip file.