Testimonial Manager Support Thread

Printable View

Show 100 post(s) from this thread on one page

3 Apr 2012, 12:07 AM
countrycharm

Re: Testimonial Manager Support Thread

Quote:

Originally Posted by mdo82

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

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.

Please help!!

Quote:

I am currently busy with my site to convert to 139, but I am getting an error when installing this script.

So you are installing testimonials manager on zen cart v1.3.9 correct?

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? 0= Link ON, Define Text OFF 1= Link ON, Define Text ON 2= Link OFF, Define Text ON 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);
3 Apr 2012, 12:21 AM
gilby

Re: Testimonial Manager Support Thread

Quote:

Originally Posted by mdo82

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

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.

Please help!!

Code:

TYPE=MyISAM

TYPE is deprecated
use ENGINE instead

Code:

ENGINE=MyISAM
3 Apr 2012, 05:56 PM
mdo82

Re: Testimonial Manager Support Thread

Quote:

Originally Posted by gilby

Code:

TYPE=MyISAM

TYPE is deprecated
use ENGINE instead

Code:

ENGINE=MyISAM

Thank you that was the trick to solve it.
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
6 Apr 2012, 03:47 PM
Andy-C27

Re: Testimonial Manager Support Thread

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
6 Apr 2012, 04:55 PM
countrycharm

Re: Testimonial Manager Support Thread

Quote:

Originally Posted by lat9

The reason that the customer email is not being sent is this line in /includes/languages/english/YOUR_TEMPLATE/testimonials_add.php:

Code:

define('EMAIL_SUBJECT', 'Your Testimonial Submission At ' . STORE_NAME . '.' . "\n\n");

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 . '.');

Quote:

Originally Posted by lat9

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

Quote:

Originally Posted by DivaVocals

and here is the full corrected script...

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? 0= Link ON, Define Text OFF 1= Link ON, Define Text ON 2= Link OFF, Define Text ON 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);

Oh and if anything I've posted is wrong, I am happy to have someone MUCH wiser than I correct me.. :laugh:

A new update has been submitted in the downloads for the above.
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:
8 Apr 2012, 03:14 AM
countrycharm

Re: Testimonial Manager Support Thread

Quote:

Originally Posted by countrycharm

A new update has been submitted in the downloads for the above.
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:

Title : Testimonial Manager
Version : 1.5.3c
8 Apr 2012, 03:47 AM
WebKat

Re: Testimonial Manager Support Thread

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...
8 Apr 2012, 05:42 PM
countrycharm

Re: Testimonial Manager Support Thread

Quote:

Originally Posted by WebKat

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.3c
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:
8 Apr 2012, 05:55 PM
countrycharm

Re: Testimonial Manager Support Thread

Quote:

Originally Posted by countrycharm

I just downloaded a copy of Testimonial Manager Version : 1.5.3c
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......

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'.
8 Apr 2012, 07:24 PM
WebKat

Re: Testimonial Manager Support Thread

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.

Show 100 post(s) from this thread on one page