Issue with SLQ in testimonial Manager

I have Zen Cart 1.3.7, the web address to my site is www.godlytreasure.com. I downloaded and tried to install the testimonial manager, but when i try to add the Testimonial_Manager.slq to the Install SLQ Patches i get the following message:

1062 Duplicate entry 'DEFINE_TESTIMONIAL_STATUS' for key 2
in:
[INSERT INTO configuration VALUES ('', 'Define Testimonial', 'DEFINE_TESTIMONIAL_STATUS', '1', 'Enable the Defined Testimonial Link/Text?
0= Link ON, Define Text OFF
1= Link ON, Define Text ON
2= Link OFF, Define Text ON
3= Link OFF, Define Text OFF', 25, 900, '2006-07-29 18:33:01', '2005-11-19 23:07:18', NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''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.

I followed the directions as best i could and did not see anything i did wrong. however i know you need a new database for the testimonial manager and there was no place i seen to type in the table name, user name, and password. Also the the testimonial sidebox does not show in the layout box controller, but im sure its probably due to the whole slq error. Thanks for any help that you might be able to provide.

All that means is that that particular entry is already in the database.

If I remember correctly that is the last statement in the sql script so it should not affect anything.

check your admin -> configuration scroll through the menu list and make sure "testimonial manager" is listed.

also check your admin -> tools and make sure "testimonial manager" is listed as a menu option.

Yes, it does show in those two areas of the admin. but, it does not show in the in the layout box controll. I also never entered in my database info anywhere. i.e. user name, password , Ect. I guess if i already have added the slq file my question is how do i fix it so it shows up in the layout box controll.

Make sure you renamed all the YOUR_TEMPLATE folder to match the name of your custom template.

check that

includes/modules/sideboxes/YOUR_TEMPLATE/testimonials_manager.php

exists.

Here's a list of all the files you should have.

admin/testimonials_manager.php
admin/includes/boxes/extra_boxes/testimonials_manager_tools_dhtml.php
admin/includes/extra_datafiles/testimonials_manager.php
admin/includes/functions/extra_functions/testimonials_manager_functions.php
admin/includes/languages/english/testimonials_manager.php
admin/includes/languages/english/extra_definitions/testimonials_manager.php

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_manager_all_testimonials.php
includes/languages/english/YOUR_TEMPLATE/testimonials_manager.php
includes/languages/english/YOUR_TEMPLATE/testimonials_add.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_manager_all_testimonials_default.php
includes/templates/YOUR_TEMPLATE/templates/tpl_testimonials_manager_default.php
includes/templates/YOUR_TEMPLATE/templates/tpl_testimonials_add_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

Well i got it working, the problem i was having is the template was gloss_black and one of the folders i named black_gloss. I thank you so much for helping that list of files helped me figure out what the problem was, but now i have another problem. Once you enter the testimonial part and the button that reads "add my testimonial" has an x on it like the image isnt there or something. You can see it at www.Godlytreasure.com.

You should also have the following folder

includes/templates/YOUR_TEMPLATE/buttons/english

there should be these two files located there

button_submit_testimonials.gif
button_testimonials.gif

:blush: I forgot:

rename the button images as follows:

button_image_submit_testimonials.gif
button_image_testimonials.gif

Well both of the files are in the correct place and i tryed naming both of them to what you have listed but it seems to have no effect on the missing button.

OK, check includes/languages/english/extra_definitions/YOUR_TEMPLATE/testimonials_manager_defines.php

make sure the following defines are present:

define('BUTTON_IMAGE_TESTIMONIALS', 'button_image_testimonials.gif');
define('BUTTON_IMAGE_SUBMIT_TESTIMONIALS', 'button_image_submit_testimonials.gif');

Thanks zen doctor i got the image to show up on the add testimonial button, there's just 1 more thing then the testimonial pages will be perfect. For some reason when starting from the main page then enter the testimonial page the back button shows http://www.godlytreasure.com and does not work correctly. However it seem to work fine when starting from all other pages.

hai zen car,

I have a doubt in mysql foreign key table creation, while creating foreign key in mysql database version 3.23.54, foreign key name is not displayed in the key column whiel describing the table, can any body give me suggession about it.
And also i had tried it by changing the type (i.e., engine type) of the table as InnoDB and MyISAM even though foregin key is not created.

by
sanku,

Strange, it seems to take me back to your main page
http://www.godlytreasure.com/index.php?main_page=index
from both the single testimonial page as well as the all testimonial page

sanku:

hai zen car,

I have a doubt in mysql foreign key table creation, while creating foreign key in mysql database version 3.23.54, foreign key name is not displayed in the key column whiel describing the table, can any body give me suggession about it.
And also i had tried it by changing the type (i.e., engine type) of the table as InnoDB and MyISAM even though foregin key is not created.

by
sanku,

?????? huh ????????????

clydejones:

OK, check includes/languages/english/extra_definitions/YOUR_TEMPLATE/testimonials_manager_defines.php

make sure the following defines are present:

define('BUTTON_IMAGE_TESTIMONIALS', 'button_image_testimonials.gif');
define('BUTTON_IMAGE_SUBMIT_TESTIMONIALS', 'button_image_submit_testimonials.gif');

I was having the same problems and looked through the code. In your original code there are a few differences.

The first is that the button is named button_testimonials.gif instead of button_image_testimonials.gif.

Then in your file structure testimonials_manager_defines.php is located in extra_definitions and not extra_definitions/your_template (that folder doesn't exist in your contrib). I don't know if this matters at all.

Finally, in that defines file it reads the following way:

define('BUTTON_IMAGE_TESTIMONIALS', 'button_add_my_testimonial.gif');
define('BUTTON_IMAGE_SUBMIT_TESTIMONIALS', 'button_submit_my_testimonial.gif');

If you have mentioned these fixes elsewhere I apologise for being redundant.:smile:

So I changed everything you mentioned and now it all works like a charm! Thanks so much for all of your contributions, I have found them all to be very helpful and well designed.

Matt

lankeeyankee:

I was having the same problems and looked through the code. In your original code there are a few differences.

The first is that the button is named button_testimonials.gif instead of button_image_testimonials.gif.

Then in your file structure testimonials_manager_defines.php is located in extra_definitions and not extra_definitions/your_template (that folder doesn't exist in your contrib). I don't know if this matters at all.

Finally, in that defines file it reads the following way:

define('BUTTON_IMAGE_TESTIMONIALS', 'button_add_my_testimonial.gif');
define('BUTTON_IMAGE_SUBMIT_TESTIMONIALS', 'button_submit_my_testimonial.gif');

If you have mentioned these fixes elsewhere I apologise for being redundant.:smile:

So I changed everything you mentioned and now it all works like a charm! Thanks so much for all of your contributions, I have found them all to be very helpful and well designed.

Matt

Thanks Matt

There are bits and pieces scattered throughout the thread with various updates and corrections, so I guess its time for an update in the download section.