Serg:

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!

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.

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.

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.

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

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.

Serg:

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.

=========================================================================================

countrycharm:

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

countrycharm:

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.

=========================================================================================

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

discoverytdi:

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

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

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

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?

WebKat:

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.

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!

LadyArlette:

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.

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?

lat9:

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.

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:

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 

The problem is with the creation of the testimonials table ...