Page 1 of 2 12 LastLast
Results 1 to 10 of 15
  1. #1
    Join Date
    Feb 2007
    Posts
    9
    Plugin Contributions
    0

    database error 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.

  2. #2
    Join Date
    Nov 2005
    Location
    Colorado Springs, CO USA
    Posts
    7,033
    Plugin Contributions
    31

    Default Re: Issue with SLQ in testimonial Manager

    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.

  3. #3
    Join Date
    Feb 2007
    Posts
    9
    Plugin Contributions
    0

    Default Re: Issue with SLQ in testimonial Manager

    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.

  4. #4
    Join Date
    Nov 2005
    Location
    Colorado Springs, CO USA
    Posts
    7,033
    Plugin Contributions
    31

    Default Re: Issue with SLQ in testimonial Manager

    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

  5. #5
    Join Date
    Feb 2007
    Posts
    9
    Plugin Contributions
    0

    Default Re: Issue with SLQ in testimonial Manager

    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.

  6. #6
    Join Date
    Nov 2005
    Location
    Colorado Springs, CO USA
    Posts
    7,033
    Plugin Contributions
    31

    Default Re: Issue with SLQ in testimonial Manager

    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

  7. #7
    Join Date
    Nov 2005
    Location
    Colorado Springs, CO USA
    Posts
    7,033
    Plugin Contributions
    31

    Default Re: Issue with SLQ in testimonial Manager

    I forgot:

    rename the button images as follows:

    button_image_submit_testimonials.gif
    button_image_testimonials.gif

  8. #8
    Join Date
    Feb 2007
    Posts
    9
    Plugin Contributions
    0

    Default Re: Issue with SLQ in testimonial Manager

    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.

  9. #9
    Join Date
    Nov 2005
    Location
    Colorado Springs, CO USA
    Posts
    7,033
    Plugin Contributions
    31

    Default Re: Issue with SLQ in testimonial Manager

    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');

  10. #10
    Join Date
    Feb 2007
    Posts
    9
    Plugin Contributions
    0

    Default Re: Issue with SLQ in testimonial Manager

    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.

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Testimonial Manager Support Thread
    By clydejones in forum All Other Contributions/Addons
    Replies: 1500
    Last Post: 4 Feb 2021, 04:12 PM
  2. Testimonial Manager V. 1.5.1 - Removing Date
    By jorsara in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 26 Mar 2010, 02:40 AM
  3. About Testimonial Manager
    By Squashman in forum General Questions
    Replies: 1
    Last Post: 23 Mar 2010, 09:56 PM
  4. Testimonial Manager Problem
    By LordGemz in forum All Other Contributions/Addons
    Replies: 8
    Last Post: 21 Sep 2009, 04:19 AM
  5. testimonial manager sidebox error
    By ctcentralinfo in forum Addon Templates
    Replies: 12
    Last Post: 27 Jun 2008, 03:39 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR