Results 1 to 8 of 8

Hybrid View

  1. #1
    Join Date
    Jul 2006
    Posts
    19
    Plugin Contributions
    0

    Default Manufacturer Link Error

    When clicking on the Manufacturer link in the box to the right I get the error below. Does anyone know what is wrong and how I can fix it?


    Warning: constant(): Couldn't find constant in /hsphere/local/home/mcdennis/digitalscrapbookcountry.com/cart/includes/init_includes/init_add_crumbs.php on line 45

    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 'from where manufacturers_id = 13' at line 2
    in:
    [select from where manufacturers_id = 13]

    Thanks

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Manufacturer Link Error

    Check that you have applied all of the fixes for v1.3.5 ...

    http://www.zen-cart.com/forum/showthread.php?t=45377
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Oct 2006
    Posts
    151
    Plugin Contributions
    0

    Default Re: Manufacturer Link Error

    Where do you apply the following code to the database for this fix? I am having the same problem. I read the thread, but am not sure where to apply this. Any ideas?

    #
    # Updating table `get_terms_to_filter`
    #
    ALTER TABLE get_terms_to_filter ADD get_term_table varchar(64) NOT NULL;
    ALTER TABLE get_terms_to_filter ADD get_term_name_field varchar(64) NOT NULL;
    UPDATE get_terms_to_filter SET get_term_table = 'TABLE_MANUFACTURERS', get_term_name_field = 'manufacturers_name' where get_term_name = 'manufacturers_id';
    UPDATE get_terms_to_filter SET get_term_table = 'TABLE_MUSIC_GENRE', get_term_name_field = 'music_genre_name' where get_term_name = 'music_genre_id';
    UPDATE get_terms_to_filter SET get_term_table = 'TABLE_RECORD_COMPANY', get_term_name_field = 'record_company_name' where get_term_name = 'record_company_id';

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Manufacturer Link Error

    You could use the Tools ... Insert SQL Patches ... for that group to processes in the database ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  5. #5
    Join Date
    Oct 2006
    Posts
    151
    Plugin Contributions
    0

    Default Re: Manufacturer Link Error

    That did work for me, thank you for your help.

  6. #6
    Join Date
    Jul 2006
    Posts
    19
    Plugin Contributions
    0

    Default Re: Manufacturer Link Error

    Thank you for your help! That worked perfectly.

    Ladybug

 

 

Similar Threads

  1. Manufacturer image link
    By Jace in forum General Questions
    Replies: 4
    Last Post: 7 Oct 2011, 12:05 AM
  2. (Hyper)Link A Manufacturer?
    By mikeislearning in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 15 Sep 2011, 03:25 PM

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