Thread: syntax error

Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2006
    Posts
    14
    Plugin Contributions
    0

    red flag syntax error

    I just uploaded a sample category and photos for testing.

    When I clicked on a name in the "manufacturers" side box I received this error message.

    Warning: constant(): Couldn't find constant in /home/outfit1/public_html/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 = 6' at line 2
    in:
    [select from where manufacturers_id = 6]


    I'm not sure how to handle this...

    Will each manufacturer require special attention or will the proper adjustments work globally an all manufacturers

    Thanks
    Last edited by outfitters; 13 Jul 2007 at 09:10 PM.

  2. #2
    Join Date
    Jun 2003
    Posts
    33,721
    Plugin Contributions
    0

    Default Re: syntax error

    How did you upload your samples? Is this a clean install or have you modified anything?
    Please do not PM for support issues: a private solution doesn't benefit the community.

    Be careful with unsolicited advice via email or PM - Make sure the person you are talking to is a reliable source.

  3. #3
    Join Date
    Jun 2006
    Posts
    14
    Plugin Contributions
    0

    Default Re: syntax error

    It was a clean install....

    We hired a fellow who created a .bat file to assemble everything for upload. I then FTP the files over...

    His bat file takes a tab spaced text data/product file, assembles the data and creates the list of graphics to match the data file and then I upload the photos.

    Well...the only thing I modified was that I changed to the "Sage" theme


    Thanks
    Last edited by outfitters; 13 Jul 2007 at 09:57 PM.

 

 

Similar Threads

  1. Replies: 1
    Last Post: 25 Aug 2011, 05:58 AM
  2. Login error and Parse error: Syntax error...
    By TzuLady in forum Basic Configuration
    Replies: 1
    Last Post: 15 Apr 2010, 07:32 AM
  3. Error message 1064 you have an error in your sql syntax
    By honrheart in forum General Questions
    Replies: 1
    Last Post: 11 Sep 2009, 02:38 AM
  4. Replies: 4
    Last Post: 30 Aug 2009, 09:26 PM
  5. SQL Syntax error: check for right syntax to use near '000000
    By gabyone in forum General Questions
    Replies: 2
    Last Post: 9 Feb 2008, 08:23 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