Testimonial Manager Support Thread

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

[countrycharm]

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.

[Serg]

it didn't work. the Uninstall went through fine, but when i run the new_install, i get the error.

[countrycharm]

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.

[countrycharm]

it didn't work. the Uninstall went through fine, but when i run the new_install, i get the error.

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.

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

[RJugalbot]

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

Thank you countrycharm for taking over this add-on. This one really works with v1.50.

visit my site: http://indyapparels.com

[discoverytdi]

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.

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

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 well done

[countrycharm]

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 well done

OK all fix now. Fix the new.sql statement from throwing the error. Glade you like it enjoy. Waiting on zen to approve it.

[IndyNeal]

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.

[LadyArlette]

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