what do you see when you view admin -> configuration -> testimonial managerQuote:
Originally Posted by kimsonvu
Printable View
what do you see when you view admin -> configuration -> testimonial managerQuote:
Originally Posted by kimsonvu
I see this:
Quote:
Title Value Action
Display Add New Testimonial Link In Sidebox true
Testimonial Image Height 550 Info
Testimonial Image Width 450 Info
Testimonial Image Directory testimonials/ Info
Display Company Name field true Info
Display City field true Info
Display Country field true
Can you share me the code or some guide to display testimonial in home page?I would like to add more testimonial but i can not control how many display in home page.
KIMSON
Thanks you !
I just sent you a PMQuote:
Originally Posted by kimsonvu
Please disregard the image fix posted here and use this one instead.
Attachment 2529
I was tested and see this:
Quote:
24 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.
Admin - config:
Quote:
Title Value Action
Testimonial Title Minimum Length 2 Info
Testimonial Text Minimum Length 10 Info
Testimonial Contact Name Minimum Length 2 Info
Display Add New Testimonial Link In Sidebox true Info
Testimonial Image Width 550 Info
Testimonial Image Height 450
Testimonial Image Directory testimonials/ Info
Display Company Name field true Info
Display City field true Info
Display Country field true
Once again check your PMQuote:
Originally Posted by kimsonvu
Clyde
I get these errors/messages when I run the latest upgrade_testimonials_manager.sql (from Downloads)
Firstly: I don't know what the upgrade exceptions table is!!Quote:
http://hohose.exphoster.com/store/ad...cons/error.gif ERROR: Cannot ADD column testimonials_url because it already exists. http://hohose.exphoster.com/store/ad...ns/warning.gif Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.
I don't suppose you could confirm whether there is a significance to any of these messages, or whether I can just ignore them? Of course, if there is a potential problem arising from these messages I would be most grateful if you could assist by giving me some guidance as to how to go about fixing any problems!!
It just means that it ignored one of the statements in the sql script because that particular table entry was already in the database.Quote:
Originally Posted by blag
There are no problems The mod should work.
Thanks!!Quote:
Originally Posted by clydejones
On my PittiVintage site I've added images to the testimonials. They appear within the testimonials themselves and at times in the sidebox. :huh:
I would like them to always appear in the sidebox, as well. Any idea why this may be occuring? I've just upgraded to testimonial_manager_1.4.3.2
thanks!
make sure you have the following line(s) of code near the top of the fileQuote:
Originally Posted by MeltDown
includes/templates/YOUR_TEMPLATE/sideboxes/tpl_testimonials_manager.php
PHP Code:if ($page_query_list[$i]['image'] != '') {
$content .= '<p class="testimonialImage">' . zen_image(DIR_WS_IMAGES . $page_query_list[$i]['image'], $page_query_list[$i]['name'], TESTIMONIAL_IMAGE_WIDTH, TESTIMONIAL_IMAGE_HEIGHT) . '</p>';
}
Quote:
Originally Posted by clydejones
Yes, that bit of code is in place but still no certainty of the image displaying. In your example I see the red highlighted bits - Should I somehow be modifying those areas?
To call the images (admin/configuration testimonial image directory) I've tried entering complete URL of the image file, as well.
Thanks
Just as a check - have you actually uploaded your graphics to images/testimonials?Quote:
Originally Posted by MeltDown
Yes, I have, and they are visible in the in the testimonials section online, just not in the sidebox.Quote:
Originally Posted by clydejones
Now that you mention it though, there was not a "testimonials" file created in /images/testimonials/. After seeing that the images were not appearing in the sidebox I did create one. Initially I had them in another folder but I also had the complete URL listed in admin/configuration/testimonials image directory. Again, they have always appeared on the main testimonials page no matter the configuration.
Thanks
in admin -> configuration -> testimonials manager -> image directory (setting)Quote:
Originally Posted by MeltDown
you only need to have /directoryname You don't need to use the full URL..
What are the height and width settings?
Quote:
Originally Posted by clydejones
Width 100
Height 60
Thanks
did you modify includes/modules/sideboxes/YOUR_TEMPLATE/template_manager.php so that it only shows on certain a certain page(s).Quote:
Originally Posted by MeltDown
If so can you provide the code you used.
Hmmm... I don't see that file in the specified location. Neither in my over-rides file or the file that it would over-ride. There is the testimonials_manager.php. Here is that entire page:Quote:
Originally Posted by clydejones
I am using Jade's Apple Zen template, however, which forces a single, right-hand only sidebox.PHP Code:<?php
/**
* Testimonials Manager - display Testimonials sidebox
*
* @package templateSystem
* @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 7-25-2007 clyde $
*/
// test if box should display
$page_query = $db->Execute("select testimonials_id, testimonials_image, testimonials_title, testimonials_html_text, date_added from " . TABLE_TESTIMONIALS_MANAGER . " where status = 1 order by rand(), testimonials_title limit " . MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES ."");
if ($page_query->RecordCount()>0) {
$title = BOX_HEADING_TESTIMONIALS_MANAGER;
$box_id = testimonials_manager;
$rows = 0;
while (!$page_query->EOF) {
$rows++;
$page_query_list[$rows]['id'] = $page_query->fields['testimonials_id'];
$page_query_list[$rows]['name'] = $page_query->fields['testimonials_title'];
$page_query_list[$rows]['story'] = $page_query->fields['testimonials_html_text'];
$page_query_list[$rows]['image'] = $page_query->fields['testimonials_image'];
$page_query->MoveNext();
}
$left_corner = false;
$right_corner = false;
$right_arrow = false;
$title_link = false;
require($template->get_template_dir('tpl_testimonials_manager.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_testimonials_manager.php');
require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
}
?>
Thats the right file and it looks like it is calling the things it should.Quote:
Originally Posted by MeltDown
what are your setting in admin -> configuration -> testimonial manager
for the following options:
Display Truncated Testimonials in Sidebox
Length of truncated testimonials to display
Quote:
Originally Posted by clydejones
Display Truncated Testimonials in Sidebox - True
Length of truncated testimonials to display - 25
I've just seen that if I set the truncated testimonial to false it shoves everything on the page to the right. :huh:
The sidebox displays only the title of the testimonial then "read more" and the links to the view and add page(s).Quote:
Originally Posted by MeltDown
What happens if you try the mod with another template?
Your testimonial images should be stored in your main images directory:Quote:
Originally Posted by clydejones
images/testimonials
and not in
includes/templates/YOUR_TEMPLATE/images/testimonials
I just installed it on my in-the-process-of-building zencart site. It works great!:clap:
One question: I am running a bilingual site. So ideally, if the customer leaves a testimonial in English, it should only be visible on the English language "view all testimonials" page and sidebox. And vice versa for a Chinese language visitor. But it seems like the Testimonial Manager is not set up this way.
Questions:
1. Am I correct is assuming it is not set up this way?
2. Is it possible to modify it to work this way?
As an example, I can point to the 5-star product review system that is a part of the standard 1.3.7 zencart. The 5-star review system only shows Chinese visitors the reviews entered by other Chinese language visitors, and only English reviews to English language visitors. Kind of a nifty feature that I would like to continue with Testimonials Manager.
Thanks!
Correct, at this time testimonials manager does not support multi-languagesQuote:
Originally Posted by thomasw98
I will look into adding this capability in a future upgrade.
This is a fairly big problem with languages like Chinese, since these turn into total gibberish when displayed on an English page. If it was French on an English page, it would not be such a big issue.Quote:
Originally Posted by clydejones
I am not going to use the sidebox for now anyways, so I will only display a menu link to "view all testimonials" on my Chinese header and leave this off of the English header. If some day you add the bilingual feature, I will then turn on the menu button on the English pages also.
Thanks for the nice contribution!:bigups:
The attached should allow you to use multi-languages with the testimonials MODQuote:
Originally Posted by thomasw98
The zip file contains only the files necessary to add multi-language capabilities.
as always, unzip the file, rename the YOUR_TEMPLATE directories to match the name of your custom template
includes/modules/sideboxes/YOUR_TEMPLATE
includes/templates/YOUR_TEMPLATE
Copy the upgrade_testimonials_manager.sql and paste it into
admin -> tools -> install sql patches and click the send button.
upload both the admin and includes folders to your server.
Attachment 2611
I'll include these changes in an upgrade in the downloads section very soon.
Wow, I really appreciate the fast work! Thanks again.:clap:
I'd been thinking about doing this for a while anyway, you just gave me the shove I needed.Quote:
Originally Posted by thomasw98
Installed it, and it works great!
Glad it working OKQuote:
Originally Posted by thomasw98
Hi Clyde,
I was looking in this thread to see if this contribution has the capability of emailing a customer and ask for there testimonial for the item they ordered, i was not able to find the information in the few pages i read, does it have? Thanks.
No, it doesn't. It will send an e-mail confirming that an a testimonial has been submitted.Quote:
Originally Posted by TamyA
Hi Clyde:
Is there any way I can turn off the need for the admin to moerate every testimonial (i.e. approve each one before they appear on the site)?
I have already adjusted the setting in admin/config/testimonials manager menu to allow users that are not logged in to leave testimonials. But I can not find anywhere to turn off moderation. I looked in the config menu and also the tools/tesimonials manager menu, but no luck.
Thanks,
Thomas
this thing caused my entire shop to break, there were SQL errors on every page. Had to immediately uninstall it. Sucks, because I really would have liked to use this mod, but not at the cost of breaking my shop.
I got it working with no problems at all, and I am not a real computer nerd (just a fake one!).Quote:
Originally Posted by KarmaCharms
Of course, with all of these zencart modules things, you have to be very careful when uploading all the new files and making the needed modifications. It is really easy to forget something or to put it in the wrong folder by accident. (the one that always confuses me is the temples/YOURTEMPLATENAME/templates folder...that just doesn't make sense to me...how can a "templates" folder be inside another "templates" folder?! Not very good librarian logic on that one).
Always backup any files that might be replaced and backup your database before starting. It sounds like you did that and were able to get back to square one, so that's good news.
If you want to give it another go, let us know first what version zencart you have and what version of testimonials manager you are trying to install. Also explain what problems your encountered last time.
Good luck! :bigups:
OK, I'm running ZC 1.3.7 and I'm trying to install the newest release of this mod. If it helps at all, I'm also running other mods that this might not be compatible with. I've got the Google Analytics mod on board as well as SEO Urls, a few custom pages, Google Sitemaps, Google Base Feeder, Referrals mod... I think that's it.
If you have some sort of instant messenger and would be willing to lend me a hand, I'd greatly appreciate it!
I don't have my template renamed as anything, I just made CSS edits to the original template and I'm pretty sure I uploaded all the files to the right directories (I have template folders called classic and template_default FWIW and most mods I have installed have gone in the template_default folders without issue).
Oh and I am also running Cross Sell mod
And Quick Updates LOL
OK I reuploaded everything double checking file structure, and reinstalled the SQL patch...
I get these errors:
Warning: Variable passed to each() is not an array or object in /home/karmarc/public_html/includes/classes/db/mysql/query_factory.php on line 114
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/karmarc/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/karmarc/public_html/includes/functions/sessions.php on line 108
Warning: Cannot modify header information - headers already sent by (output started at /home/karmarc/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/karmarc/public_html/includes/init_includes/init_templates.php on line 78
Warning: Division by zero in /home/karmarc/public_html/includes/classes/split_page_results.php on line 76
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 '-0, MAX_DISPLAY_PRODUCTS_LISTING' at line 7
in:
[select p.products_quantity, p.products_id, p.products_type, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '45' limit -0, MAX_DISPLAY_PRODUCTS_LISTING]
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 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUC' at line 13
in:
[select p.products_id, pd.products_name, products_date_available as date_expected from zen_products p, zen_products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' and p.products_date_available >=20071007 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]
Sounds like you will need to wait for "super Clyde" to help on this one since it is a mess of SQL errors. But I would bet money that he can figure it out for you. Sorry to not be able to help.
By the way, "Karma Charms" is a great name for your product and target customer. Nice marketing strategy!
Sorry, None of these errors has anything to do with Testimonial Manager.Quote:
Originally Posted by KarmaCharms
It appears to have something to do with displaying the upcoming products.
The status should be set to approved by default.Quote:
Originally Posted by thomasw98
But let me double check just to be sure.
thomasw98,Quote:
Originally Posted by clydejones
If you want to have the status to always be approved,
open includes/modules/pages/testimonials_add/header_php.php
find the following lines of code:
$insert_sql_data = array('date_added' => 'now()',
'status' => '0');
change the highlighted portion to 1
save the file and upload to your server.
Thanks again!
Quote:
Originally Posted by KarmaCharms
I just made sure that all settings for upcoming products were disabled and now I am getting a whole new slew of errors:Quote:
Originally Posted by clydejones
Header errors:
and then where my products should be:Quote:
Warning: Variable passed to each() is not an array or object in /home/karmarc/public_html/includes/classes/db/mysql/query_factory.php on line 114
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/karmarc/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/karmarc/public_html/includes/functions/sessions.php on line 108
Warning: Cannot modify header information - headers already sent by (output started at /home/karmarc/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/karmarc/public_html/includes/init_includes/init_templates.php on line 78
Take a look at my site if you can, I'm going to leave it for now with the errors so you can see what it's doing. The second I uninstall the testimonials SQL, everything works as it should, which leads me to believe it's the mod causing it.Quote:
Warning: Division by zero in /home/karmarc/public_html/includes/classes/split_page_results.php on line 76
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 '-0, MAX_DISPLAY_PRODUCTS_LISTING' at line 7
in:
[select p.products_quantity, p.products_id, p.products_type, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zen_products_description pd, zen_products p left join zen_manufacturers m on p.manufacturers_id = m.manufacturers_id, zen_products_to_categories p2c left join zen_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '2' limit -0, MAX_DISPLAY_PRODUCTS_LISTING]
Thanks! Karma is actually my dog and the name was a play on the product offering and the dog LOL!Quote:
Originally Posted by thomasw98
I checked your site and didn't see any of the errors you indicated.Quote:
Originally Posted by KarmaCharms
On which page (s) do they occur?
OK I had to disable it again as it was totally breaking the shop and I noticed that I had a ton of customers online. I'll reenable it now and you can feel free to click around.
Here's the super odd part... install the SQL patch for this mod, everything goes bonkers... uninstall it, everything works just fine. Didn't remove any of the uploaded files for this mod, they are all still there, so it has something to do with the SQL.
Thanks!
OK got the SQL reinstalled and plan to leave it now overnite (I'm in Spain so it's overnight for me) and will check this thread in the morning, hope we can figure this out because I REALLY want to use this mod.
Check your PMQuote:
Originally Posted by KarmaCharms
When you say SQL installed I'm not sure what you mean.Quote:
Originally Posted by KarmaCharms
All you need to do is copy the entire sql file and then
paste it into:
admin -> tools -> install sql patches and then click the send button.
That sql statement adds some admin options in the Zen Cart configuration table for Testimonial Manager and adds the testimonial manager admin interface in the tools menu and finally it creates the testimonials table in the database.
The sql statement does not run from the front end (shop) of your installation and is only a one time run from the ZC admin panel as indicated above.
So where are you "installing" the sql?
Exactly as the instructions said. Pasted the contents of the install sql file and hit send, then the problems start. If I then copy and paste the uninstall sql file and hit send, problems gone.
For anyone else having this problem:
The solution can be found hereQuote:
Warning: Variable passed to each() is not an array or object in /path/to/your catalog files/includes/classes/db/mysql/query_factory.php on line 114
Note: this error has nothing to do with the testimonial manager mod but rather with the db_cache table in the database.
I was totally clueless but you figured it out and fixed it. THANK YOU for taking the time to help a newbie, one day I hope to be able to pay it forward!
I have got problems to install this module. When I cut and paste the code of install_testimonials_manager.sql and press 'send', I always get this error:
Can you help me? What did I wrong?Quote:
1136 Column count doesn't match value count at row 1
in:
[INSERT INTO zen_configuration_group VALUES (NULL, 'Testimonials Manager', 'Testimonials Manager Display Settings', '1', '1');]
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.
Try running this: just copy the code and paste it into admin -> tools -> install sql patches and press the send button.Quote:
Originally Posted by Butterfliege
Code: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, 'Testimonial Title Minimum Length', 'ENTRY_TESTIMONIALS_TITLE_MIN_LENGTH', '2', 'Minimum length of link title.', @configuration_group_id, 2, NULL, now(), NULL, NULL), (NULL, 'Testimonial Text Minimum Length', 'ENTRY_TESTIMONIALS_TEXT_MIN_LENGTH', '10', 'Minimum length of link description.', @configuration_group_id, 3, NULL, now(), NULL, NULL), (NULL, 'Testimonial Contact Name Minimum Length', 'ENTRY_TESTIMONIALS_CONTACT_NAME_MIN_LENGTH', '2', 'Minimum length of link contact name.', @configuration_group_id, 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', @configuration_group_id, 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.', @configuration_group_id, 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.', @configuration_group_id, 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', @configuration_group_id, 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', @configuration_group_id, 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', @configuration_group_id, 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', @configuration_group_id, 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', @configuration_group_id, 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', @configuration_group_id, 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', @configuration_group_id, 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', @configuration_group_id, 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', @configuration_group_id, 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', @configuration_group_id, 17, 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 '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 AUTO_INCREMENT=2 ;
INSERT INTO `testimonials_manager` VALUES (1, 'Great', '', 'Clyde\'s Test Site', '', 'This is just a test submission to show you how it looks, great, eh?', '[email protected]', NULL, NULL, NULL, 0, 1, now(), '0000-00-00 00:00:00');
I have done it, and now I get tihs error:
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 'p_id=0' at line 1
in:
[p_id=0;]
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 Butterfliege
p_id=0 does NOT exist in the SQL statement provided for Testimonials Manager.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 'p_id=0' at line 1
in:
[p_id=0;]
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.
URL to your site please
Sorry, the site is on my local system, so I can't give you a url.
Do you have any ideas?
It might be a database problem (use phpmyadmin and repair/optimize the database)Quote:
Originally Posted by Butterfliege
ZC version?
php version?
Try re-uploading a clean version of the following file to admin (sqlpatch.php)
ok, the database is checked/optimized/repaired, ans no error was found.
I re-uploaded the sqlpatch.php. And it still doesn't work.
ZC version 1.3.7-german
PHP version 5.2.1
Does this module have newest version? :smile:Quote:
Originally Posted by clydejones
Thanks you!
Without being able to see or access the site, I'm not sure what the problem might be.Quote:
Originally Posted by Butterfliege
I seems to be a problem with the german version of ZC. I have installed the english version on another pc, and there I could install the testimonial manager without any problems.
In the english version there is no language_id in the database, but in the german version you can find it. So it is no wonder that i always get an error report.
With some help of my husband the sql patch now runs without problems. But i have to use the english language in the german version of zc to see the menue of testimonial manager.
I hope you understand what I mean.
Try the fix in this post that should give you multiple language support for Testimonial ManagerQuote:
Originally Posted by Butterfliege
Hi,
I'm having a small problem with the testimonial manager and was hoping someone could please help?
I am using the testimonial_image_update.zip that was posted on this forum. Now, when I go to https://www.handcrafteduk.com/testimonials_add.html the 'submit my feedback' link doesn't seem to work.
Can someone take a look and please let me know what's wrong?
Many thanks,
Gary :smile:
Just did a test submission and didn't have any problems.Quote:
Originally Posted by HandcraftedUK
Thanks Clyde. I was playing around with the site tonight and managed to sort it out. I had somehow managed to mess up the templates!
Thanks anyway.
Gary :smile:
Hi,
Can you tell me where to change the wide size ?
http://www.handicraft-vn.com/shop/te...timonials.html
KIMSON
Thanks you .
I'm not sure why the following code is included in (some) your testimonials, but if you eliminate/delete it that should correct the problem.Quote:
Originally Posted by kimsonvu
likewise I found this code snipit in the several places in the sidebox listing for testimonial managerCode:<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
<style type="text/css">
<!--
.style1 {color: #FF0000}
-->
</style>
</head>
<body>
....
</body>
</html>
Code:<html...
I do not understand this! What file i need to change?Quote:
Originally Posted by clydejones
KIMSON
Thanks you.
How were the testimonials entered? From the admin panel? Looks like you cut and pasted some of them.Quote:
Originally Posted by kimsonvu
Testimonials are stored in the database.
You'll have to go into the admin -> tools -> testimonial manager and edit each testimonial and remove those sections of code.
Please check image in this post to know my means in width size!
KIMSON
Thanks you.
I checked your site, so I know what you mean by the width size.Quote:
Originally Posted by kimsonvu
And as I said, you need to correct the errors I pointed out before anything else can be done.
Dear developer of this excellent mod,
Just wanna inform you that the included installation sql patch will delete configuration_key with configuration_group_id = 0
The effected keys are
PRODUCTS_OPTIONS_TYPE_SELECT
UPLOAD_PREFIX
TEXT_PREFIX
Deletion of above keys will effect the proper functionality of Zen Cart.
Thank you, I'll make changes to the install sql patch.Quote:
Originally Posted by surf7.net
For those already using Testimonial Manager, the following will correct this issue.
copy and paste the code into admin -> tools -> install sql patches and click the send button.
Code:INSERT INTO `configuration` VALUES (NULL, 'Product option type Select', 'PRODUCTS_OPTIONS_TYPE_SELECT', '0', 'The number representing the Select type of product option.', 0, NULL, '2006-09-04 09:22:39', '2006-09-04 09:22:39', NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, '2006-09-04 09:22:39', '2006-09-04 09:22:39', NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Text prefix', 'TEXT_PREFIX', 'txt_', 'Prefix used to differentiate between text option values and other option values', 0, NULL, '2006-09-04 09:22:39', '2006-09-04 09:22:39', NULL, NULL);
The newest release no longer has the YOUR_TEMPLATE dir to rename. Only classic. Is the proper install procedure to rename 'classic' to your custom template dir?
Thank you.
Sorry 'bout that error.Quote:
Originally Posted by kiddo
The answer is yes change "classic" to match the name of your template folder.
I'll correct this and add an update to the download section.
Thanks
Thanks Clydejones! I suspected that, but wasn't sure. And thanks much for a great contrib! I love it!
I was follow your guide but it still can not fix.Quote:
Originally Posted by clydejones
I remove all of testimonial in HTML and just add text but it seem nothing change .
Can you help me to fix that issues?
KIMSON
Thanks you & best regards,
Check your PMQuote:
Originally Posted by kimsonvu
@ Alex Clarke
Alex:
Just unzip the attachment and upload the entire includes folder to your server.
Hope it helps.
Attachment 2865
Good catch, surf7.net! I have been using it for a while and never bumped into any problems, but I will take your word for it (and Clyde's word and patch!).Quote:
Originally Posted by surf7.net
Thanks for the good neighbor support!
Thomas
Hi Clyde,Quote:
Originally Posted by clydejones
This fix doesn't seem to have worked. I noticed that when using the new tpl_testimonials_add_default.php file the customer details (email address and name) were not automatically completed (if the customer was logged in).
I tried to submit a testimonial and the same thing happened (it just refreshed the form when I clicked on the submit button).
I'll be looking into this problem today and let you know if I find the solution.
In the meantime, thanks for the help. :)
This should help with this issue:Quote:
Originally Posted by Alex Clarke
open tpl_testimonials_add_default.php find the following lines of code and add the highlighted portions
Code:<label class="inputLabel" for="testimonials_name"><?php echo TEXT_TESTIMONIALS_NAME; ?></label>
<?php echo zen_draw_input_field('testimonials_name', $name, 'size="18" id="testimonials_name"') . '<span class="alert">' . ENTRY_REQUIRED_SYMBOL . '</span>'; ?>
<br class="clearBoth" />
<label class="inputLabel" for="testimonials_mail"><?php echo TEXT_TESTIMONIALS_MAIL; ?></label>
<?php echo zen_draw_input_field('testimonials_mail', $email, 'size="18" id="testimonials_mail"') . '<span class="alert">' . ENTRY_REQUIRED_SYMBOL . '</span>'; ?>
<br class="clearBoth" />
I checked several more sites that are using testimonial manager and still can't reproduce this problemQuote:
I tried to submit a testimonial and the same thing happened (it just refreshed the form when I clicked on the submit button).
I'll be looking into this problem today and let you know if I find the solution.
In the meantime, thanks for the help. :)
Hi Clyde,
I've just tested Testimonial Manager 1.4.4 on a fresh install of Zen Cart 1.3.7.1 and ran into the same issues.
Both machines I've tested this on are running IIS version 5.
Do you, or does anyone else, know how I could troubleshoot this problem? Maybe there's a way to trace the events that are happening when I click on the submit button?
In the meantime, I'll continue to look into this.
I've only every worked on installs running apache.Quote:
Originally Posted by Alex Clarke
Sounds like it may be something with handling the "redirect" back to the "success" portion after clicking the submit button.
AlexQuote:
Originally Posted by clydejones
Here's another updated fix that may help.
I made a couple of code changes so check it out and let me know.
Attachment 2881
That did the trick!
Thanks Clyde. :)
Just a couple of suggestions for the next release.
While these are only small changes/features, I believe they will come in handy for most users of the contribution.
- Display the customers website URL next to their testimonial (maybe a switch in the admin could toggle this)
- Enable the separator (currently: ) between Company Name, City, State/Country to be changed via the admin
Anyway... thanks again for your time and help. :)
Not at all. Glad to help.Quote:
Originally Posted by Alex Clarke
There were privacy concerns (just like publishing the email address) with adding the web URL but maybe I can come up with a way of "hiding" the actual URL and still have a way of clicking through to the customer's web site.
The separator is an easy fix and I'll add something for the next update.
I have searched on this topic, and can't find anything about my particular issue.
I've got testimonials manager running great. One of the BEST contributions I've ever seen.
But - images aren't working right for me. They come up fine in small form, but when I try to click on them inside the actual testimonial, the URL is http:///
Where and what do I fix?
Thanks!
www.Shirts4Bowling.com
Check your PMQuote:
Originally Posted by mumzie
Here's a fix that should help.Quote:
Originally Posted by clydejones
Just unzip the file and upload the entire includes folder to your server.
Attachment 2941
I didn't see this issue posted, so forgive me if it's somewhere.
When I make changes in the "Pages Editor" for Add Testimonial's page, I don't see the text/changes on the frontend. How can I do this?
I'm using 1.3.7, the html_includes file is writable and there's a copy on the template override.
Copy the code and paste this sql statement from admin -> tools -> install sql patches then click the send button.Quote:
Originally Posted by ideasgirl
Code: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''),');
Has anyone found a way for a customer to upload a file from the testimonial form? or are there complications with this that make it not so wise?
thanks for any help:smile:
Great job Clyde!
You and this Mod are the Best!!
Foxxy Fashions for Less!
Shop FoxxyDiva.com
I'll look into implementing this in a future update.Quote:
Originally Posted by hitch