Printable View
Quote:
Originally Posted by jonisolis
Here's a quick fix for this.Quote:
Originally Posted by Rabbcon
Just unzip the the attached, copy the sql statement to admin -> tools -> install SQL patches and click send.
Upload the entire admin folder to your server.
Attachment 2028
Hi Clyde,
Great work with this, just what I was looking for! :)
Just wondering... is it possible to display a link to the customers website (underneath their testimonial)?
Ok, I figured it out! :)
Here's what to do...
tpl_testimonials_manager_default.php at line 53 add:
tpl_testimonials_manager_all_testimonials_default.php at line 72 add:Code:<div id="testimonialLink"><?php echo '<a href="' . $page_check->fields[testimonials_url] . '" target="_blank">' . $page_check->fields[testimonials_url] . '</a>';?></div>
That's it!Code:<div id="testimonialLink"><?php echo '<a href="' . $testimonials->fields[testimonials_url] . '" target="_blank">' . $testimonials->fields[testimonials_url] . '</a>';?></div>
I hope this helps someone else.
Alex,Quote:
Originally Posted by Alex Clarke
Sorry I didn't get you an answer on this, I've been up to my hip-boots working on a clients site. Glad you got it working.
I didn't include this feature because I didn't want to have it on a web page without the author's express permission same with the e-mail address.
I'll work on this for a future release.
No problem Clyde. I hope the clients site is going well! :)
You've got a good point about the 'privacy issues' regarding posting website and/or email addresses.
Once again, thanks for your work on this contribution.
Its going fairly well, I've learned a good deal about Zen Cart can and can't do with and without modifications.Quote:
Originally Posted by Alex Clarke
Is it possible to use this to generate random quotes to the right of the main logo in the header area with an image behind the quotes?
Not really, a better choice would be a dedicated random quotes contribution which I don't believe is available.Quote:
Originally Posted by sircuss
Hello
I have downloaded the testimonial manager from download section but still it is not working, the problem is that there is no layout box appearing for this
The steps that i have done are
uploaded the relevant files to admin folder
uploaded the relelvant files to include folder changed the template name from Your_template to Classic as im using the default one
exceuted the SQL statements from the admin
but still not layout box
Just wondering I am using 1.3.6 so will it work on it
Have you turn the box on from your admin (tools | layout box controller)?
Hello
The problem is that there is no layout box controller to turn on or off. It doesn;t show any new box
Nice mod, I just added this to http://www.wiipeddler.com.
Great work.
One question, how do you make it scroll through the full testimonials, and keep recycling.
Thanks In advance.
The sidebox does not have "scrolling" capabilities. It will only show random testimonials. You can set the number of testimonials to display in admin->configuration->testimonial manager.Quote:
Originally Posted by teebo
does this mod have the ability to "que" posts for approval and create testimonials and approve or deny them from admin?
i did work on this one at osc http://www.oscommerce.com/community/...onials+manager and wanted to know if it was the same, would like one ready to plug in zen.
thanks
derek
hehe - new zenner...
It sounds like you have a file or two missing. Have you tried reinstalling Testimonial Manager?Quote:
Originally Posted by shop2buy
it has all of these features as well as the ability to configure several options.Quote:
Originally Posted by kwizshow
admin->configuration->testimonial manager
admin->tools->testimonial manager
GREAT thanks for the quick response.
:clap:nice work, easy install!!
glad to helpQuote:
Originally Posted by kwizshow
Would love to see this mod with a State/Country field. That way we can either add it or the customers can add the State and/or Country they are writing from, givfes some nice visuals for potential customers.
Example: Kerry J. Lancaster, U.K.
I'll look into implementing this feature in a future release.Quote:
Originally Posted by kwizshow
I notice you had a slideshow sidebox...looks good...where did you get it?Quote:
Originally Posted by skunkworx
Clyde,
I'm having a small issue when you view the testimonials page it has "HEADING_TITLE
TEXT_DISPLAY_NUMBER_OF_TESTIMONIALS_MANAGER_ITEMS"
At the top and bottom of the page. I searched the forum and didn't see an answer for this. Any ideas ?
Thanks
Sounds like you forgot to upload one or more of the files inQuote:
Originally Posted by wccomp
in languages/english/YOUR_TEMPLATE
Clyde,
Thanks that was it. I thought I had double checked all that but every now and then you just miss something.
Thanks
glad to helpQuote:
Originally Posted by wccomp
Hi Clyde,
Just downloaded the latest version of this contribution. I was upgrading from 3.0.2.
Anyway... after installing, when trying to access the links.php page from the admin I received the following error.
Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in C:\server\xampp\htdocs\zencart\admin\links.php on line 164
I had a quick look at the code and believe that line 161 of links.php should be changed to the following.
This error (the ' character) only appears in the upgrade links.php file and not the new installation one.Code:zen_mail($links_contact_name, $links_contact_email, EMAIL_TEXT_SUBJECT, $email, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS);
I hope this helps someone else! :)
Great work with this contribution.
Alex,Quote:
Originally Posted by Alex Clarke
Are you talking about Testimonial Manager or Links Manager
I'm talking about Links Manager and now realise that I've posted in the wrong thread. Silly me. I better get some sleep now.
Sorry about that!
I keep pimping it out, but there is a brilliant rewrite of Lightbox 2 that includes native slide-show functionality, and it wouldn't require a seperate sidebox. I'm hoping that it can be dropped into the Lightbox module without too much fuss. The Lightbox 2 site says that Lightbox 2 is called in the same way as the original Lightbox JS. However, in order to do a slideshow, you do have to change the call a bit so that it nows there are images in a series.Quote:
Originally Posted by sal4888
http://www.justinbarkhuff.com/lab/lightbox_slideshow/
I have a stupid question. Doesn't ZC have the ability for users/customers to leave reviews as is? So does this module just move those reviews into a sidebox, or are the testimonials new and seperate from the existing review system?
Testimonial is separate from the review system since it isn't tied to any particular product as are the reviews.Quote:
Originally Posted by enderandrew
Re: Cannot edit testimonials - 1054 Unknown column 'testimonials_url' in 'field list'
Hi Clyde and Everyone,
I have Testimonials Manager v1.4.2 installed with Zen-Cart v1.3.7
Problem is I cannot edit any testimonials
I go in Admin to Tools > Testimonials Manager
Select a testimonial and click "edit" on the right
Even if I don’t change anything when I click UPDATE I get this error message:
1054 Unknown column 'testimonials_url' in 'field list'
in:
[update testimonials_manager set testimonials_title = 'No Dramas', testimonials_url = 'http://', testimonials_name = 'John, Australia', testimonials_mail = '[email protected]', testimonials_html_text = 'I am completely happy with the service I got etc', date_added = now() where testimonials_id = '135']
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.
FYI any changes I make do not register because of this error.
I believe the problem is "Author's URL" on this testimonials manager edit page has an asterix for required, but on my submit testimonials page there is NO FIELD for the customer to enter a URL it is missing so maybe that is causing the error later. (field is filled with http:// if I change it to a real website or even leave blank, same error)
I want to be able to use the edit testimonials function but it always has that error, mainly I just want to fix some testimonials where the customer has put their name or title in the wrong field etc.
2) Also the old testimonials manager let the customer tick a box "Hide my email" or "Show my email" but that no longer appears with my v1.4.2 testimonials manager, how can I get this back? Also if it does show the email can it show in a spam proof way, such as link to john[AT]example.com instead of [email protected]?
3) While I am here I would also like on the submit testimonials page to change the text "Name" to "Name, Company, City, Country" and I have worked out how to change this text trouble is the width allows is so small it then goes over 2-3 lines which I don’t want, is there any way to make this text field wider? or is it easy to add some extra fields for this?
From your description above, sounds like you didn't run the upgrade sql.Quote:
Originally Posted by apemusic
copy and paste the following in you admin -> tools -> install SQL patches
Code:ALTER TABLE `testimonials_manager` ADD `testimonials_url` VARCHAR( 255 ) NULL DEFAULT NULL AFTER `testimonials_title` ;
Those options were deliberately left out because of privacy/spam issues.Quote:
2) Also the old testimonials manager let the customer tick a box "Hide my email" or "Show my email" but that no longer appears with my v1.4.2 testimonials manager, how can I get this back? Also if it does show the email can it show in a spam proof way, such as link to john[AT]example.com instead of [email protected]?
No easy way to add extra fields without re-writting some of the code and making changes to the database table (please note that this is being worked on for a future update)Quote:
3) While I am here I would also like on the submit testimonials page to change the text "Name" to "Name, Company, City, Country" and I have worked out how to change this text trouble is the width allows is so small it then goes over 2-3 lines which I don’t want, is there any way to make this text field wider? or is it easy to add some extra fields for this?
Version 1.4.3 of Testimonial Manager is now available in the download section.
This update adds options in admin to display "Company", "City" and "State/Country" fields on the Add testimonial page. admin -> configuration -> Testimonial Manager.
If you are upgrading from a previous version don't forget to run the upgrade.sql.
Hi Clyde!!
Wow thanks you are a champ!!
That worked, thanks for the quick help - I see you have a new version out already with those things added too, awesome!
cheers from Sydney, AUS!
Quote:
Originally Posted by clydejones
Hi Clyde
After uploading all the files to my demostore, I run the SQL , I got an error,
1146 Table 'tiledepo_zc1.zen_zen_testimonials_manager' doesn't exist
in:
[show fields from zen_zen_testimonials_manager]
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.
I try 3 time and re upload the fileS , I dubble check I changed my_template names,
well i must have forgat somthing, I alwyes do:smile:
Glad it worked out.Quote:
Originally Posted by apemusic
I'll check it.Quote:
Originally Posted by motti
Which version were you uploading?
Hi
I install Version 1.4.3 and i use the uppgrade folder with the U6grade SQL
Thank you Clyde
Is version 1.4.3 stable now?
I just (not more than 5 minutes ago) uploaded a minor bug fix to the download section. Once that is approved everything should be fine.Quote:
Originally Posted by lextechs
[FONT=Times New Roman]Hi Lextechs[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]From my end it is all perfect, Thanks to Clyde personal help.[/FONT]
[FONT=Times New Roman][/FONT]
[FONT=Times New Roman]Clyde is that bug fix on my version?[/FONT]
Yes it is!!Quote:
Originally Posted by motti
This is testimonial/feedback about the site, not a specific product.Quote:
Originally Posted by enderandrew
Hi Clyde,
I am trying to install the Testimonials Manager 1.4.3. When I run install_testimonials_manager.sql, the following error is produced:
1060 Duplicate column name 'testimonials_mail'
in:
[CREATE TABLE zen_testimonials_manager ( testimonials_id int(11) NOT NULL auto_increment,
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_mail VARCHAR( 255 )
NULL DEFAULT NULL, testimonials_mail VARCHAR( 255 ) NULL DEFAULT NULL, testimonials_mail VARCHAR(
255 ) NULL DEFAULT NULL, testimonials_show_email char(1) default '0', status int(1) NOT NULL
default '1', date_added datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY
(testimonials_id) ) TYPE=MyISAM AUTO_INCREMENT=2 ;]
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.
Is there any fix for this? The Zencart version is 1.3.7.
Many thanks,
Alex
Alex,Quote:
Originally Posted by AlexT
Run this:
Copy and paste into your ZC admin -> tools -> install sql patches
Code:#Testimonials Manager v1.4.3 upgrade SQL
# For Zen-Cart 1.3.7
# Last Updated: 7/25/2007
SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Testimonials Manager'
LIMIT 1;
DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
DELETE FROM configuration WHERE configuration_key = 'DEFINE_TESTIMONIAL_STATUS';
DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;
INSERT INTO configuration_group VALUES (NULL, 'Testimonials Manager', 'Testimonials Manager Display Settings', '1', '1');
SET @configuration_group_id=last_insert_id();
UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;
INSERT INTO configuration VALUES (NULL, 'Number Of Testimonials to display in Latest Testimonials box', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', @configuration_group_id, 1, 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', @configuration_group_id, 2, 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.', @configuration_group_id, 3, 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.', @configuration_group_id, 4, 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', @configuration_group_id, 5, 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', @configuration_group_id, 6, 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', @configuration_group_id, 7, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (NULL, 'Display Company Name field', 'TESTIMONIALS_COMPANY', 'true', 'Display Company Name field', @configuration_group_id, 8, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (NULL, 'Display City field', 'TESTIMONIALS_CITY', 'true', 'Display City field', @configuration_group_id, 9, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (NULL, 'Display Country field', 'TESTIMONIALS_COUNTRY', 'true', 'Display Country field', @configuration_group_id, 10, 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', @configuration_group_id, 11, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` VALUES (NULL, 'Define Testimonial', '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', 25, 999, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');
DROP TABLE IF EXISTS testimonials_manager;
CREATE TABLE testimonials_manager (
`testimonials_id` int(11) NOT NULL auto_increment,
`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 '1',
`date_added` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`testimonials_id`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;
INSERT INTO `testimonials_manager` VALUES (1, 'Great', '', 'Perfect Designing', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', 1, 1, now());
Hi Clyde,Quote:
Originally Posted by clydejones
Done. The error message is now:
1136 Column count doesn't match value count at row 1
in:
[INSERT INTO zen_testimonials_manager VALUES (1, 'Great', '', 'Perfect Designing', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', 1, 1, now());]
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.
Is it something important or I should ignore it?
Thank you,
Alex
Hello Clyde,
Another guy having problem installing your TM.
I downloaded the latest TM as of today, and I did the new installation procedures. I think I have done all in the install.txt file. CSS, SQL, renaming template, enabling inside Admin panel and what not.
I have not seen any new box appear in my site.
BTW, I have deleted that test testimonial lines inside the SQL patch because it returned some error when trying to patch it into ZC.
My site is : www.radiomeal.com
Hope you could help, thanks.
I have just installed testimonial manager for the first time (from downloads section), all seems to be working fine until it comes to review and update testimonials. When no country is added it is automatically filled with the customers email address, which is not a problem it can be deleted when updating.
But when i press update i get the following error:
From a previous post i think i can fix this by adding a last_update field to my database table. Before i try it can someone tell me if the following code is correct:Quote:
1054 Unknown column 'last_update' in 'field list'
in:
[update testimonials_manager set testimonials_title = 'test4', testimonials_url = 'http://', testimonials_name = 'test test', testimonials_mail = 'phil_king2##########################', testimonials_company = '', testimonials_city = '', testimonials_country = '', testimonials_html_text = 'test4', status = '1', last_update = now() where testimonials_id = '5']
i don't know SQL at all really. I would be very grateful for any help anyone could offer me with this.Quote:
ALTER TABLE `testimonials_manager` ADD `last_update` datetime NOT NULL default '0000-00-00 00:00:00 AFTER `testimonials_html_text ` ;
Thanks
Try running just this line:Quote:
Originally Posted by AlexT
Code:INSERT INTO `testimonials_manager` VALUES (1, 'Great', '', 'Perfect Designing', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', NULL, NULL, NULL, 1, 1, now());
The side box won't show because there is/are no testimonials to display in the sidebox.Quote:
Originally Posted by maza
run this sql statement:
Code:INSERT INTO `testimonials_manager` VALUES (1, 'Great', '', 'Perfect Designing', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', NULL, NULL, NULL, 1, 1, now());
Yes, Run that statement from your admin -> tools -> install sql patchesQuote:
Originally Posted by Phil020782
Thanks clyde that worked perfectly, fantastic contrib btw.
Quote:
Originally Posted by clydejones
Clyde,
Thanks for your help.
I ran this line and everyting seemed fine: I could add testimonials from both the webside and from Admin and they showed correctly. But, when I tried to edit a testimonial (I used your example and added city Perth), the following error message appeared:
1054 Unknown column 'last_update' in 'field list'
in:
[update zen_testimonials_manager set testimonials_title = 'Great', testimonials_url = 'http://', testimonials_name = 'Perfect Designing', testimonials_mail = '[email protected]', testimonials_company = '', testimonials_city = 'Perth', testimonials_country = '', testimonials_html_text = 'This is just a test submission to show you how it looks, great, eh?', status = '1', last_update = now() where testimonials_id = '1']
Am I supposed to be able to edit them?
Thanks,
Alex
Run this from admin -> tools -> insert sql patchesQuote:
Originally Posted by AlexT
I've fixed this in the download and will upload it ASAPCode:ALTER TABLE `testimonials_manager` ADD `last_update` datetime NOT NULL default '0000-00-00 00:00:00 AFTER `testimonials_html_text ` ;
Something is not quite right again, I've ran the line, the following message has appeared:Quote:
Originally Posted by clydejones
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 ''0000-00-00 00:00:00 AFTER testimonials_html_text' at line 1
in:
[ALTER TABLE zen_testimonials_manager ADD last_update datetime NOT NULL default '0000-00-00 00:00:00 AFTER testimonials_html_text ;]
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.
The versions are:
PHP Version: 5.2.1 (Zend: 2.2.0)
Database: MySQL 5.0.27-standard
Thank you,
Alex
Try this one:Quote:
Originally Posted by AlexT
Code:ALTER TABLE `testimonials_manager` ADD `last_update` datetime NOT NULL default '0000-00-00 00:00:00' AFTER `testimonials_html_text` ;
Quote:
Originally Posted by clydejones
Everything works fine now, thank you very much for your help!
Alex
Thanks Clyde, I got it worked now.
Hey Clyde, I have noticed new issue now.
I got a TEXT_FIELD_OPTIONAL appeared besides my 'fill in the blanks' form inside ZC admin.
Is TM giving this problem? Do you have any idea how to fix it?
Not sure it it is TM.Quote:
Originally Posted by maza
open admin/includes/functions/html_output.php
at around line 235 you should see:
if ($required == false) $field .= TEXT_FIELD_OPTIONAL;
Just delete this line and see if that clears that text string.
Due to the several "glitch" reports involving the "New Installation" section of Testimonial Manager, I'm in the process of tracking down and correcting them.
I'll re-work the the entire section and post an updated version in the next couple of days.
In the meantime the fixes listed in the last few post should correct most, if not all, of the problems.
I appoligize for any inconvenience this may have caused.
Oh yeah, it's gone now. Thanks a lot buddy!Quote:
Originally Posted by clydejones
Hi Cllyde
Am i supose to see the number of click on the link?
It show cCicks 0 , and myself I click few time and it is not changing
Tahnk you
If you haven't disabled them in admin, yes you will see themQuote:
Originally Posted by motti
The reason they don't change is because of new "direct link" capability of the mod.
I'll work on fixing this for the next update.
go to admin -> configuration -> links manager
Enable Click Count - set to false
Display Link Click Count - set to 0
Ok
I set it up to false and 0 now i dont see it on my page
I wait for you fix
Thank you
I see this problem - can someone tell me how to fix?Quote:
1054 Unknown column 'last_update' in 'field list'
in:
[update handicratestimonials_manager set testimonials_title = 'Re: Order Update #19', testimonials_url = 'http://', testimonials_name = 'Jim Benich', testimonials_mail = '[email protected]', testimonials_company = '', testimonials_city = '', testimonials_country = '', testimonials_html_text = 'Received, thank you. The box was damaged but the contents were OK. They are very nice. Keep up the good work! JB', status = '1', last_update = now() where testimonials_id = '3']
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.
run this sql statement from admin -> tools -> install sql patchesQuote:
Originally Posted by kimsonvu
Code:ALTER TABLE `testimonials_manager` ADD `last_update` datetime NOT NULL default '0000-00-00 00:00:00 AFTER `testimonials_html_text `;
After run it, i see this problem :Quote:
Originally Posted by clydejones
Quote:
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 ''0000-00-00 00:00:00 AFTER testimonials_html_text' at line 1
in:
[ALTER TABLE handicratestimonials_manager ADD last_update datetime NOT NULL default '0000-00-00 00:00:00 AFTER testimonials_html_text ;]
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 kimsonvu
Try running thisCode:ALTER TABLE `testimonials_manager` ADD `last_update` datetime NOT NULL default '0000-00-00 00:00:00' AFTER `testimonials_html_text `;
Hi Clyde, I love your contribution, its amazing. Small problem, when I click on view all testimonials in IE7, the "back" button and "add my testimonial" buttons are not visible. But they are in FF. Can you tell me how to fix this.
Also, how can I make the spacking between the testimonial titile and the actual testimonial smaller?
Thanks!
http://trendsdepot.com/index.php?mai...l_testimonials
for part 1 try this:Quote:
Originally Posted by james739
open tpl_testimonials_manager_all_testimonials_default.php
scroll down to the bottom of the file
add another <br class="clearBoth" /> right after the one that is already there.
for number 2 try:
open testimonials_manager_all_testimonials.css
add the declaration p {padding: 0; margin: 0;}
Quote:
Originally Posted by clydejones
Thanks you !
Thanks Clyde, works great!
I tried to install this, version 1.4.3.1
when I go to admin>tools>testimonial manager, i get the following message:
(xxxxxxx being the name of my database, I have removed from the error message)Quote:
1146 Table 'xxxxxxxx.testimonials_manager' doesn't exist
in:
[select count(*) as total from testimonials_manager]
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.
Is there something I am missing or did wrong?
Is this a fresh install or an upgrade?Quote:
Originally Posted by paperthreads
if a fresh install, did you run the install_testimonials_manager.sql
Fresh install, and yes, I ran it in the Admin>Install SQL Patches.
I just ran the SQL, 2 more times...
And the last time worked.....
Not sure why it didn't the first 2 attempts...but I'm good to go now..I hope!
glad you got it up and runningQuote:
Originally Posted by paperthreads
Dear all,
Can someone tell me how to configuration to display testimonial in homepage about 3 or 1 not all testimonial?
KIMSON
Thanks you & best regards,
http://www.handicraft-vn.com/shop/
By default the mod is not designed to include the display of testimonial(s) on the homepage. Thats the purpose of the sidebox.Quote:
Originally Posted by kimsonvu
You would have to do some custom coding to accomplish what you wish to achieve.
In todays world of spam, is it possible to keep the "email" off the results page, once an approval of the testimonial has been made? I have testimonial manager set so that non-registered users can add a testimonial, but they won't be happy to see their email addresses prominently displayed. I'd like to keep it in admin on the edit page, but not show it on the live page result side.
I found a way around it, but because I have to explain this to the owner, I'd rather just save her the step of removing the email in the admin edit page. (just using email@ on admin edit page removes email address from live site) but she may not always remember to change that email and she may want to have a copy of the email addresses people supply.
I'm well versed enough that I could remove this from the page in templates you tell me to remove, but I think it would be better if you add it as an option when one is setting there preferences for this addon. Even going so far as to allowing the admin person to display the items they want displayed.
Marian
By the way.. this is an amazing addon. One of the easiest installs.. and worked perfectly first time out of the gate. I added a testimonial with no problems. I would definitely rank it among one of the best addons for zencart.
One thing I did notice, it said there were no overwritten files, but it does want to overwrite a file in admin/includes/functions/html_output.php and possibly you could add that to the install file so people know to copy or back it up first before they overwrite it.
Marian
Sorry.. ignore, added this message so I could receive notification in my email. :/ No way to edit this when forgotten on forum.
By default NO e-mail address is is shown on either the single testimonial or all testimonial display pages.Quote:
Originally Posted by Seamstobesew
:oops: Thanks, That file will be removed at soon as I upload an update to the mod.Quote:
Originally Posted by Seamstobesew
I must have overlooked the removal of the file when I did the zip package for the mod.
Hi Clyde
I am trying to enter new testimonial, but when I try to upload a picture it dose not let me,
I don’t get any error, it is just not let me finish update until I remove the link of the picture I am trying to add
Also is it possible for me to create a new category in my /images/testimonial, so I can put my entire testimonial picture there?
Thank you
Check for e-mail!Quote:
Originally Posted by motti
Cool
Thank you Clyde you are the best
Hi,
I downloaded your TM and can't find a layout box for it in Admin? I noticed another guy had the same problem, but I couldn't find the response for it.
Steps taken,
1. Uploaded files and changed file name to match my template
2. Uploaded sequel patch via admin cut & paste
3. Able to see TM in Configuration
4. Able to see TM in Tools
But I can't see it in Sidebox Layout Controller. :cry:
Any ideas?
Vicky
as a double check make sure you've renamed the YOUR_TEMPLATE folder to match the name of your custom template. Here's a list:Quote:
Originally Posted by TrvlFox
includes/languages/english/YOUR_TEMPLATE
includes/languages/english/html_includes/YOUR_TEMPLATE
includes/modules/sideboxes/YOUR_TEMPLATE
includes/templates/YOUR_TEMPLATE
...boy am I having a blond moment.....:blink:
That was it. I didn't realize how many areas there were. You might want to consider listing it in the read me file.
Vicky
Is there anyway I can make email and URL optional?
admin side or catalog side?Quote:
Originally Posted by TrvlFox
I guess Admin side or both. I don't want to have people email my customers when they might not want that. I rather keep it optional
E-mail addresses do not (by default) appear in any testimonials. So no one reading a testimonial would be able to e-mail your customers. and is available on the admin side.Quote:
Originally Posted by TrvlFox
The e-mail address is there for you in case you would like to contact the author of the testimonial.
There is no URL option on the add testimonial page.
The URL option in admin is optional.
Here is an example of the testimonials mod in use. As you can see there are no email addresses anywhere.Quote:
Originally Posted by TrvlFox
http://www.moissaniteco.com/testimon...timonials.html
Hey thanks so much! See that now. So it all makes perfect sense to me.
I have it running on my site, and I'm adding last years emails. So I was only focusing on the admin side.
Thanks again
I love this... perfect to promote in general my store rather than using review for one item!:clap:
I know you said that the email on the customer side doesn't show up and it doesn't for me either, but I'd swear it did on my first test testimonial I wrote as a test, I think that might be why some people ask about that. It's odd, because I would swear I saw that on the customer side and wrote to you then about removing it, and then after seeing your response I saw you were right about how they don't show up, but it does make me curious why other people might be asking that same question.
Either or, that's not what I'm writing to about today, I am writing to ask if it's at all possible for you to allow us to set our own path for the images. I prefer that images don't go to images/ but instead I would have made a folder in images for testimonials so they'd go to images/testimonials or perhaps I'd use an already created folder.
I ask this because it can somtimes take folders along time to load after they get so many files in them and it would be nicer if we could sort these to a folder of our choice.
This is still an amazing addon, and my client loves it on her site.
Please give this a consideration.
Thank you,
Marian
Funny you should ask! I've been working on this as an added option. I haven't posted an update to the downloads section yet though. Two other options allow you to set the height and width of the image(s).Quote:
Originally Posted by Seamstobesew
So... Here you are.
As always Backup First. unzip the file, copy and paste the upgrade_testimonial_manager.sql to admin -> tools -> install sql patches and click the send button.
Rename the YOUR_TEMPLATE folder to match the name of your custom folder name. (includes/templates/YOUR_TEMPLATE)
upload the admin and includes folders to your server.
You will also have to reconfigure testimonial manager admin -> configuration -> testimonial manager
The image HEIGHT and WIDTH default to 80
The image directory defaults to "testimonials/"
Attachment 2527
I see this when update SQL:
Quote:
Success 23 statements processed.
Error ERROR: Cannot insert configuration_key "MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES" because it already exists
Error ERROR: Cannot insert configuration_key "DISPLAY_TESTIMONIALS_MANAGER_TRUNCATED_TEXT" because it already exists
Error ERROR: Cannot insert configuration_key "TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH" because it already exists
Error ERROR: Cannot insert configuration_key "MAX_DISPLAY_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS" because it already exists
Error ERROR: Cannot insert configuration_key "DISPLAY_TESTIMONIALS_DATE_PUBLISHED" because it already exists
Error ERROR: Cannot insert configuration_key "DISPLAY_ALL_TESTIMONIALS_TESTIMONIALS_MANAGER_LINK" because it already exists
Error ERROR: Cannot insert configuration_key "REGISTERED_TESTIMONIAL" because it already exists
Warning Note: 7 statements ignored. See "upgrade_exceptions" table for additional details.