Thanks clyde, that made the trick.Quote:
Copy the code and paste this sql statement from admin -> tools -> install sql patches then click the send button.
Printable View
Thanks clyde, that made the trick.Quote:
Copy the code and paste this sql statement from admin -> tools -> install sql patches then click the send button.
Glad to helpQuote:
Originally Posted by ideasgirl
Customer are unable to add a testimonial from my site. On clicking the submit button the page just refreshes. I can however add testimonials from the admin end. Wonder what the problem is.
I'm having the same problem (as mentioned previously in this thread). I believe this to be related to IIS.Quote:
Originally Posted by mersonmathew
Can you confirm what web server you're running?
At the moment I'm still looking for a solution.
Quote:
Originally Posted by mersonmathew
Alex, mersonmathew,Quote:
Originally Posted by Alex Clarke
Try this fix and see if it helps.
Open the zip file, change the YOUR_TEMPLATE folder to match your custom template name, upload the entire includes folder to your server.
CLyde, Alex Thank you so much for your replies.
My server is Apache.
I've tried the fix but it doesn't solve the problem. Still on submit the page just refreshes with the defaults filled in.
I was thinking if its to do with the HTTP_POST_VARS in /includes/modules/pages/testimonials_add/header_php.php but in the fix it appears to have changed to _GET but still no success. I'm running php5. Should we be using _POST?
Do you have a URl to your site?Quote:
Originally Posted by mersonmathew
mersonmathew, alexQuote:
Originally Posted by clydejones
Try this fix and see if it helps.
Attachment 3100
Hi Clyde,
I've tried IISFIX2 but it hasn't solved the problem. My site url is http://discountperfumesuk.com Thanks for all your help!
I tried to create a test account on the site but was unable to do so because of the country restriction.Quote:
Originally Posted by mersonmathew
Hi Clyde,
I've changed the settings to allow posts without registering. You may try now.
Merson
Not sure why it would be doing this.Quote:
Originally Posted by clydejones
I have the same fix2 installed on my test site running php5 on an apache server and its working fine.
Never mind. I'll try and work on it and let you know if I succeed. Thanks!
Hey Clyde!
I'm having a bit of an awkward issue when i drop the files in their respective folders within the admin area of the site. Once i upload the files, my admin page will be completely blank. And by blank, i mean BLANK. Nada. Zip. White screen of death.
My admin directory does not have the name "admin" for security purposes. Could this be the cause?
What are your thoughts?
Thanks!!
Oh man! How goofy.
I fixed my problem. -- just needed to CHMOD the files to have some freedom.
Quote:
Originally Posted by mrmeech
My question is rather simple - I think...
If I choose to permit non-registered users to submit testimonials (because I sell on eBay as well), will this permit spiders and other unsavory varmint to submit spam as a testimonial?
Thanks for reading!
sabastina
Wonderful mod by the way; thank you very much for this contribution!
All testimonial submissions have to be approved (via the admin panel) before they are posted on your site. So, even if you receive such a submission you can always delete it.Quote:
Originally Posted by sabastina
Ahh...thank you...I should have realized that.
Sorry to use your time so needlessly, I will try to slow down and actually THINK about what I'm doing! Although it's hard when I get so excited as I am about my new Zen Cart.
Thank you for responding!
Kimberly
Not at all, glad to helpQuote:
Originally Posted by sabastina
I have installed the testimonial manger successfully, however I have hit a slight problem.
Although the testimonial sidebox shows etc. the only links that work are "View all testimonials" and "Add a testimonial".
If I click on either "Read more" or the title of the testimonial "Great" I get a 404 page not found error.
Any tips on how to resolve this?
Many thanks.
URL for your site?Quote:
Originally Posted by chris parker
Here it isQuote:
Originally Posted by clydejones
Many thanks.
Chris.
right off hand, it appears you may not have uploaded all the files.Quote:
Originally Posted by chris parker
you should have
includes/templates/YOUR_TEMPLATE/templates/tpl_testimonials_manager_default.php
(this file controls the single view of testimonials)
it also appears that you're missing the css files for testimonials manager.
Hi Clyde,Quote:
Originally Posted by clydejones
I have now made sure that everything is uploaded as it should be. I now have the testimonials correctly formatted with the CSS, but still have the problem of the linked titles and 'read more' links going to a 404?
Do you think it might be because I am hosting in a subfolder or something? I have no idea why this is happening but I've obviously missed something out along the way.
:(
P.S. One of the things that does not look right is that when I go to layout boxes controller, it says sideboxes/iC_AthemeJoomla/testimonials_manager.php with the sideboxes/iC_AthemeJoomla/ displayed in red, but I assume that is becuase I have installed it in a subfolder for my template?
I have checked and double check the new upload files to make sure I have not missed any. The admin is working correctly, the sidebox is turned on but nothing shows up.
Testimonials are in the database -- just not working.
Attention CLYDE:
I think I have this one figured out.
When I click on the "Read more" link, the url it leads to is dodgy. It reads like this:
When it should be this:Code:http://www.evaprofessional.co.uk/shop/index.php?main_page=testimonials_manager.php&testimonials_id=1
Whereabouts in the code is the URL string defined for the read more link?Code:http://www.evaprofessional.co.uk/shop/index.php?main_page=testimonials_manager&testimonials_id=1
I think it needs to be stripped of the .php.
Do you think that's it?
iC_AthemeJoomla this would be the name of your custom template.
Just as a double check -
You should have the following files located as indicated:
includes/languages/english/iC_AthemeJoomla/testimonials_add.php
includes/languages/english/iC_AthemeJoomla/testimonials_manager.php
includes/languages/english/iC_AthemeJoomla/testimonials_manager_all_testimonials.php
includes/languages/english/extra_definitions/iC_AthemeJoomla/testimonials_manager_defines.php
includes/languages/english/html_includes/testimonials_manager_defines.php
includes/languages/english/html_includes/iC_AthemeJoomla/testimonials_manager_defines.php
includes/modules/pages/testimonials_add/header_php.php
includes/modules/pages/testimonials_manager/header_php.php
includes/modules/pages/testimonials_manager_all_testimonials/header_php.php
includes/modules/sideboxes/iC_AthemeJoomla/testimonials_manager.php
includes/templates/iC_AthemeJoomla/templates/tpl_testimonials_add_default.php
includes/templates/iC_AthemeJoomla/templates/tpl_testimonials_manager_all_testimonials_default.php
includes/templates/iC_AthemeJoomla/templates/tpl_testimonials_manager_default.php
includes/templates/iC_AthemeJoomla/sideboxes/tpl_testimonials_manager.php
includes/templates/iC_AthemeJoomla/css/testimonials_add.css
includes/templates/iC_AthemeJoomla/css/testimonials_manager.css
includes/templates/iC_AthemeJoomla/css/testimonials_manager_all_testimonials.css
Ok Clyde, I have double checked all of those now, but still no luck.Quote:
Originally Posted by clydejones
The only time I can get to see the testimonial is if I manually copy, paste, then delete the .php part from the URL that the "Read More" link is directed to.
Any ideas?
ATT: CLYDE.
I think I've fixed it now.
In includes>>>extra_datafiles>>>testimonials_manager.php
the following appears at line 13 :
define('FILENAME_TESTIMONIALS_MANAGER', 'testimonials_manager.php');
?>
which I have edited to state:
define('FILENAME_TESTIMONIALS_MANAGER', 'testimonials_manager');
?>
and it seems to have done the trick.
I just hope it doesn't bugger up anything else! :)
That's very strange, The version of testimonials manager in the downloads section contains the correct define statement in includes/extra_datafilesQuote:
Originally Posted by chris parker
In any case I'm glad you got it working.
Hi Clyde,Quote:
Originally Posted by clydejones
I've just downloaded a new copy, and the problem remains the same. Perhaps you might check?
As you open up the zip file, new_installation>>>>admin>>>>includes>>>>extra_datafiles>>>>testimonials_manager .php
you will find the code above. Since correcting it the module works on my site.
And since you helped me upload the CSS file, it even looks nice too.
Thanks for providing what looks like it might be a really useful mod for my site. (I didn't realise you were the author of the mod until I checked just now).
:smile:
Here's the contents of the file from a new download of the mod from the forum downloads section:Quote:
Originally Posted by chris parker
PHP Code:<?php
/**
* Testimonials Manager - Filename Defines
*
* @package Pages
* @copyright 2007 Clyde Jones
* @copyright Portions Copyright 2003-2007 Zen Cart Development Team
* @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
* @version $Id: Testimonials_Manager.php v1.4.3.1 7-25-2007 Clyde Jones $
*/
define('FILENAME_TESTIMONIALS_MANAGER', 'testimonials_manager');
define('FILENAME_TESTIMONIALS_MANAGER_ALL', 'testimonials_manager_all_testimonials');
define('FILENAME_TESTIMONIALS_ADD', 'testimonials_add');
define('FILENAME_DEFINE_TESTIMONIALS_ADD', 'define_testimonials_add');
define('TABLE_TESTIMONIALS_MANAGER', DB_PREFIX . 'testimonials_manager');
?>
Hi Clyde,
That's not the file I changed. I believe that file is from:
\new_installation\includes\extra_datafiles\testimonials_manager_filenames.php
The file I had had to edit is this one:
\new_installation\admin\includes\extra_datafiles\testimonials_manager.php
It might just be my server settings though because nobody else seems to have this problem.
Chris. :)
that file shouldn't effect the functioning of the mod on the "store" side. It would effect the functioning of things on the admin side though.Quote:
Originally Posted by chris parker
Hello Clyde,
Yeah sorry about that, I have regained my senses and found the right thread! ha.
Basically, I get this error after I run the upgrade to update my existing testimonial manager install. I renamed template folders and made sure my files uploaded. I have experienced similar thing before and I don't know if it is to do with prefix. The SQL passed through perfectly though.
Thanks in advance! :smile:Quote:
1054 Unknown column 'language_id' in 'where clause'
in:
[select testimonials_id, testimonials_image, testimonials_title, testimonials_html_text, date_added from zen_testimonials_manager where status = 1 and language_id = 1 order by rand(), testimonials_title limit 5]
run this sql statement.Quote:
Originally Posted by HeathenMagic
copy and paste into:
admin -> tools -> install sql patches and click the send button
Code:ALTER TABLE `testimonials_manager` ADD `language_id` INT( 11 ) NOT NULL DEFAULT '0' AFTER `testimonials_id` ;
Many thanks Clyde,
That stopped the error showing up. The sidebox doesn't seem to show at the moment, and I checked the page that shows the testimonials and that has the bottom icons only.
http://www.thegemtree.com/index.php?...l_testimonials
Do I have to use the ALTER TABLE for other of the sql components do you think?
You'll need to update the testimonials to reflect the language id.Quote:
Originally Posted by HeathenMagic
run this sql statement:
copy and paste into admin -> tools -> install sql patches and click the send button.
Code:UPDATE `testimonials_manager` SET `language_id` = '1' WHERE `language_id` =0 ;
WOW! Thanks that did the trick! :smile:
Clyde,
Quick question on the mod...When I try to activate it thru admin, I get two different scenarios. ( there is a testimonial written )
1. when enabling for the right sidebox, nothing.
2. when enabling for the left sidebox, everything disappears except the information box, but that ends up in the center of the page.
If I knew how to post a screenshot, I would.
Here is a link though....http://hiddenhillsnursery.com/Shopping Cart
I have this mod working on two other sites, but for some reason, I cannot get this one to work on this site.
Zen 1.3.8
Mother Earth template
PHP 4.4.8
More Information sidebox mod
Testimonials manager mod
Information sidebox mod
editable sideboxes mod
Not that it has anything to do with this issue, but the ez pages won't show either, left or right....coincidence?????
what happens with other sideboxes?Quote:
Originally Posted by daneh
All sideboxes dissappear. I enabled the testimonial one so You can view the page. [URL="http://hiddenhillsnursery.com/Shopping Cart"].
I will leave it that way until I hear back from you.
What happens if you turn off testimonial manager sidebox and enable other sideboxes?Quote:
Originally Posted by daneh
HMMM...interesting....some show up, some don't
One more thing I forgot to mention...I have Write a review and Tell a Friend turned OFF, but it still shows up on certain pages...
I have all sideboxes turned on except the testimonials. I will see what it does when I turn that on...
Nothing when it is on the right....it doesn't even show up
When it is on the left, ALL sideboxes disappear. One thing has changed since I enabled all sideboxes...instead of the Information sidebox being the one that shows up in the center, it is now the New Products.
What happens if you switch to the classic template?Quote:
Originally Posted by daneh
well, it looks to do the same thing...I noticed that now that all sideboxes are enabled, then I enable testimonial, all sideboxes and main box disappear.
It did that with the other template too.
I just noticed that I have a few mods in my Mother Earth folders only...not in classic or default. When I switched to the classic template, Testimonial Manger was not an option on the sideboxes.
Clyde,
I got it. I missed a file when I uploaded. I missed the vssver.scc , whatever that does...LOL I knew the mod worked...it is on my other two sites, and works great.
Great job on the mod.
Hi clydejones,
thank you for the quick answer.
1. It is a new install (Vers. 1.4.4) on zc 1.3.7
2. yes, i copy and paste the sql statement into admin -> install SQL patches and then run the statement from there.
can i give you more information?
Thank you for your help
Gerd
Try running this statement: copy and paste into admin -> tools -> install SQL patches and click the send button.Quote:
Originally Posted by 27gerd27
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''),');
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, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, NULL, now(), 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, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Image Handler Version', 'IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL, now(), NULL, 'zen_cfg_textarea_small(');
DROP TABLE IF EXISTS testimonials_manager;
CREATE TABLE testimonials_manager (
`testimonials_id` int(11) NOT NULL auto_increment,
`language_id` int(11) NOT NULL default '0',
`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, 1, 'Great', '', 'Clyde\'s Test Site', '', 'This is just a test submission to show you how it looks, great, eh?', 'clyde@mysticmountainnaturals.com', NULL, NULL, NULL, 0, 1, now(), NULL);
Hi clydejones,
many Thanks for your quick answer.
I did it but i got this return:
1136 Column count doesn't match value count at row 1
in:
[INSERT INTO TSconfiguration_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.
Thanks for your try to help - can i give you more information?
Gerd
Do you have any mods installed that may have altered the configuration_group table?Quote:
Originally Posted by 27gerd27
Hi,
installed and ok:
e-mail Archive Manager
Image Handler 2
i installed but the sw does not run:
Testimonials Manager 1.4.4
Ligth Box
User tracking
Light Box is deinstalled
i do not know how to deinstall user tracking.
Many Thanks for your quick answer.
Greetings
Gerd
Check your PMQuote:
Originally Posted by 27gerd27
Hi i have an issue with my sidebox.
it simply doesnt want to show up - niether on the right side or the left side. I have defined all the paths correctly. Any idea what might be the issue?
im running ZC 1.3.8. and the latest version of Testimonial Manager.
My template name is iC_AthemeV1.3
In admin everything is fine. I didnt get any errors during the sql installation etc. I just cannot make the siebox to show up on my site
www.g2play.pl
Any tips are appriciated.
The sidebox won't show up until you have at least one testimonial.Quote:
Originally Posted by Moonq
i have 2 testimonials. any other ideas please?
I just sent you a test submission, approve it and see if the sidebox shows up.Quote:
Originally Posted by Moonq
You might also want to update the two you have already.
admin -> tools -> testimonial manager.
What I think happened is that the default language for the mod is english and in order for your testimonials to show up they need to be updated to reflect the language you are using on your site.
BRAVO! :smile:
Yes it works now. Interesting pooint for multilingual sites. Thank you for your help. Very appriciated. One of the best component ive ever seen!
Glad to helpQuote:
Originally Posted by Moonq
Hi clyde,
your program runs fantastically. but in my testimonials are all the text in "one line" that means return does not have any function - is that normal?
Thank you for your answer
greetings
Gerd
Can you post a URL for your site (again):blush:Quote:
Originally Posted by 27gerd27
Hi clyde,
wwww.tachyon-station.com
gerd
Not sure exactly you mean. I checked the site and the testimonials look fine to me.Quote:
Originally Posted by 27gerd27
Hi clyde,
i want that the testimonial looks like this
and not:
hi clyde, iwant that the...
so that the writers can a bit structure their writings
is that and how is that possible
greetings
gerd
Quote:
Originally Posted by 27gerd27
Yes, all the writer has to do is press the enter key when typing their testimonial.
If they don't press the enter key then everything will be on one line.
I just did a test submission. check it out.
Hi clyde,
please have a look at the new test Testimonial.
I wrote
test
test
test
and it appears:
test test test
what is wrong
greetings, gerd
Hi Clyde,
nave a look, just one line.
Do you have any idea?
greetings
gerd
I'll have to take a look and see what the problem might be.Quote:
Originally Posted by 27gerd27
BTW: If you have the translations of the german language files could you send them to me.
hi clyde,
tomorrow morning i will have a last look over the translation. There may be a few changes. Tomorrow evening (german time you will have the files, ok? And if there are any translations missed, do not hesitate, give me a mail and i will make the change.
greetings
Gerd
PS: your account are still open, if needed
Many thanksQuote:
Originally Posted by 27gerd27
Gerd,Quote:
Originally Posted by 27gerd27
I've managed to work out the issues that still remain and will package them up in a zip file of just the files that have changed.
I need the translations before I can do that.
Clyde,
Thanks for writing this. it works like a charm. :) That's it. :)
Kate
Glad you find it usefulQuote:
Originally Posted by libragear
For a non-programmer the Testimonial install.txt file is quite cryptic. And trhere seems to be a lot more then just installgin a mod. It says to edit the stylesheet.css file plus create an SQL database. The Hoek Zen Cart book doesn't really address mod installs and breifly discusses the style sheet. Are there any better install fiels out there? Where in the style sheet is this code inserted? What additional details are available for creating the Testimonial SQL database? Apparently use to be a simple install until the 1.3.7 upgrade??
The stylesheet:Quote:
Originally Posted by kevinmc3
The declarations can be pasted at the end of your stylesheet.css
The sql statement:
copy the information from:
install_testimonials_manager.sql
open admin -> tools -> install sql patches
Paste the information you just copied into the text area and click the send button
The same install procedures have been used in all versions.Quote:
Apparently use to be a simple install until the 1.3.7 upgrade??
NOTE: please post any other problems in the proper support forum for the Testimonial Manager
Thanks for creating and sharing this really useful module. It installed fine, first time.
One thing I can't figure out though ...
How would a person substitute an image for the heading in the Testimonial Manager sidebox ? (TM 1.4.5 on ZC 1.3.8).
I've experimented along the lines of this tutorial ...
http://www.www.zen-cart.com/tutorial...hp?article=135
... to no avail ... and I have visited many of the testimonial_manager phps ... :frusty: ... just can't figure out what to do and where ...
Thanks if anyone can help.
Thanks, this was very helpful.
This is my first MOD install, so I have a bit of anxiety as I have a rather large product database (yes, I did backup).
I have made an over-ride directory (Magic). So, the code:
includes/languages/english/extra_definitions/YOUR_TEMPLATE
includes/languages/english/YOUR_TEMPLATE
includes/languages/english/html_includes/YOUR_TEMPLATE
includes/modules/sideboxes/YOUR_TEMPLATE
includes/templates/YOUR_TEMPLATE
I think I would change to :
includes/languages/english/classic/extra_definitions/magic
includes/languages/english/classic/magic
includes/languages/english/classic/html_includes/magic
includes/modules/sideboxes/classic/magic
includes/templates/classic/magic
??
Or do I need to be AT the same level as "classic"?
Follow the instructions in the tutorial but look first in:Quote:
Originally Posted by baja123
includes/languages/english/extra_definitions/YOUR_TEMPLATE/testimonials_manager_defines.php
find:
define('BOX_HEADING_TESTIMONIALS_MANAGER', 'Testimonials');
and follow the instrucitons for changing this to your image.
Now open
includes/modules/sideboxes/YOUR_TEMPLATE/testimonials_manager.php
follow the instructions for changing the
$title = BOX_HEADING_TESTIMONIALS_MANAGER;
If you prefer the last option in the tutorial then
You would follow the instructions for creating an image and then adding the following to your stylesheet.css
#testimonials-managerHeading {
margin: 0em;
background: url(../images/your_background_image.jpg) #ff6699;
padding: 0.5em 0.2em;
}
Hope this helps
These would be your directoriesQuote:
Originally Posted by kevinmc3
includes/languages/english/extra_definitions/magic
includes/languages/english/magic
includes/languages/english/html_includes/magic
includes/modules/sideboxes/magic
includes/templates/magic
Thanks, I'm getting SQL errors, I think I am going to post for expert help, before I mess things up.
Kevin
What errors are you getting?Quote:
Originally Posted by kevinmc3
Since I wrote the mod I can probably help.
Here is the 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 'includes/languages/english/extra_definitions/magic includes/languages/english/ma' at line 1
in:
[includes/languages/english/extra_definitions/magic includes/languages/english/magic includes/languages/english/html_includes/magic includes/modules/sideboxes/magic includes/templates/magic ;]
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.
What is the sql statement you are entering that is causing this error?Quote:
Originally Posted by kevinmc3
The only sql statement you would enter from admin -> tools -> install sql patches is this one:
Code:#Testimonials Manager v1.4.4 upgrade SQL
# For Zen-Cart 1.3.7
# Last Updated: 10/16/2007
# 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.
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''),');
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, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Upload prefix', 'UPLOAD_PREFIX', 'upload_', 'Prefix used to differentiate between upload options and other options', 0, NULL, NULL, now(), 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, NULL, now(), NULL, NULL);
INSERT INTO `configuration` VALUES (NULL, 'Image Handler Version', 'IH_VERSION', '2.0', 'This is used by image handler to check if the database is up to date with uploaded image handler files.', 0, 100, NULL, now(), NULL, 'zen_cfg_textarea_small(');
DROP TABLE IF EXISTS testimonials_manager;
CREATE TABLE testimonials_manager (
`testimonials_id` int(11) NOT NULL auto_increment,
`language_id` int(11) NOT NULL default '0',
`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, 1, 'Great', '', 'Clyde\'s Test Site', '', 'This is just a test submission to show you how it looks, great, eh?', 'clyde@mysticmountainnaturals.com', NULL, NULL, NULL, 0, 1, now(), NULL);
I was folwoign the install.txt file below:
File Modifications:
Add the following declarations to your stylesheet.css.
.testimonial {
color: #000;
padding: 0 5px 5px 5px;
text-align:left;
}
.testimonial p {
margin: 0; padding: 5px 0;
}
.testimonial span {
float:right;
}
========================================================
Database Modifications:
A new database table needs to be created to store your testimonial items.
New configuration options are added to the zen_configuration table.
========================================================
NEW INSTALLATION:
Unzip the contribution.
Open the New_installation folder
run the included install_testimonials_manager.sql using the Zen-Cart Sql Patches tool
(admin -> tools -> install sql patches)
For best results, cut-and-paste the code into the query field and press 'Send'.
Before uploading change the YOUR_TEMPLATE directories to match the name of your custom directory.
includes/languages/english/extra_definitions/YOUR_TEMPLATE
includes/languages/english/YOUR_TEMPLATE
includes/languages/english/html_includes/YOUR_TEMPLATE
includes/modules/sideboxes/YOUR_TEMPLATE
includes/templates/YOUR_TEMPLATE
The files are arranged in the same structure as Zen Cart so you can FTP the admin and includes directories to your server.
Login in to your admin panel admin -> tools -> layout boxes contoller and activate the new sidebox.
So, instead I add the code you just gave me into the box:
Enter the query
to be executed:
The I was entering into the upload file at the same time:
install_testimonials_manager.sql
Oh yeah, spot on, poifect ! Now all I need to do is add a Testimonial to your zenlike goodness, poise and clarity of explanation ... :smile: Thanx heaps Clyde!
Before uploading change the YOUR_TEMPLATE directories to match the name of your custom directory.Quote:
Originally Posted by kevinmc3
includes/languages/english/extra_definitions/YOUR_TEMPLATE
includes/languages/english/YOUR_TEMPLATE
includes/languages/english/html_includes/YOUR_TEMPLATE
includes/modules/sideboxes/YOUR_TEMPLATE
includes/templates/YOUR_TEMPLATE
The files are arranged in the same structure as Zen Cart so you can FTP the admin and includes directories to your server.
You would change the YOUR_TEMPLATE directories to magic.
includes/languages/english/classic/extra_definitions/magic
includes/languages/english/classic/magic
includes/languages/english/classic/html_includes/magic
includes/modules/sideboxes/classic/magic
includes/templates/classic/magic
Now you upload/FTP the admin and includes directories to your server.
These DO NOT get included in the sql.
admin -> tools -> install sql patches
does not upload files to your server it only runs sql statements in order to change the database.
glad to helpQuote:
Originally Posted by baja123
What is this?:
You would change the YOUR_TEMPLATE directories to magic.
includes/languages/english/classic/extra_definitions/magic
includes/languages/english/classic/magic
includes/languages/english/classic/html_includes/magic
includes/modules/sideboxes/classic/magic
includes/templates/classic/magic
I thought you said in previous NOT to include the classic subfolder? Am I making two sets of magic over-ride folders?
Sorry, copied the wrong section.Quote:
Originally Posted by kevinmc3
includes/languages/english/extra_definitions/magic
includes/languages/english/magic
includes/languages/english/html_includes/magic
includes/modules/sideboxes/magic
includes/templates/magic
But in any case the folders and files do not get included with the sql
Sorry ofr being a pain. I copied the exact code. Got this 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 '; DELETE FROM configuration WHERE configuration_key = 'DEFINE_TESTIMONIAL_STATUS' at line 1
in:
[DELETE FROM zen1_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;]
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.
Check your PMQuote:
Originally Posted by kevinmc3
Its 1:00 am so if you'd like me to check as per the PM It'll have to be tomorrow.Quote:
Originally Posted by clydejones
.......
Good Morning,,
PM ?
Private message -Quote:
Originally Posted by kevinmc3
I have smoe problems with this module:
They doesn't show in Layout boxes controller so i made some changes I copy testimonials_manager.php from modules/template_default into modules and then testimonials_manager.php it's show in layout boxes controller. In pages it's show all lines like TABLE_HEADING_TESTIMONIALS not the value of this define. http://www.macedonium.net/index.php?...stimonials_add
I have 1.3.8 Zen Cart instaled
Sounds like you either didn't rename all of the YOUR_TEMPLATE folders or you didn't upload all of the necessary files.Quote:
Originally Posted by Macedonium
Make sure ALL of the following are installed:
includes/extra_datafiles/testimonials_manager_filenames.php
includes/functions/testimonials.php
includes/languages/english/extra_definitions/YOUR_TEMPLATE/testimonials_manager_defines.php
includes/languages/english/YOUR_TEMPLATE/testimonials_add.php
includes/languages/english/YOUR_TEMPLATE/testimonials_manager.php
includes/languages/english/YOUR_TEMPLATE/testimonials_manager_all_testimonials.php
includes/languages/english/html_includes/define_testimonials_add.php
includes/languages/english/html_includes/YOUR_TEMPLATE/define_testimonials_add.php
includes/modules/pages/testimonials_add
includes/modules/pages/testimonials_manager
includes/modules/pages/testimonials_manager_all_testimonials
includes/modules/sideboxes/YOUR_TEMPLATE/testimonials_manager.php
includes/templates/YOUR_TEMPLATE/sideboxes/tpl_testimonials_manager.php
includes/templates/YOUR_TEMPLATE/templates/tpl_testimonials_add_default.php
includes/templates/YOUR_TEMPLATE/templates/tpl_testimonials_manager_all_testimonials_default.php
includes/templates/YOUR_TEMPLATE/templates/tpl_testimonials_manager_default.php
includes/templates/YOUR_TEMPLATE/css/testimonials_add.css
includes/templates/YOUR_TEMPLATE/css/testimonials_manager.css
includes/templates/YOUR_TEMPLATE/css/testimonials_manager_all_testimonials.css