Results 1 to 2 of 2

Hybrid View

  1. #1
    Join Date
    Feb 2007
    Posts
    7
    Plugin Contributions
    0

    Default Google Froogle Syntax Error

    Hi Everyone,

    I have just installed the Froogles Merchant file and I get this two errors, can anybody help out?
    SQL query:
    SELECT @configuration_group_id := configuration_group_id
    FROM configuration_group
    WHERE configuration_group_title = 'Google Froogle Configuration'
    LIMIT 1 ;

    MySQL said:
    #1146 - Table 'aburime_zc1.configuration_group' doesn't exist

    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 'ORDER BY p.products_id ASC' at line 10
    in:
    [SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN zen_product_types pt ON (p.products_type=pt.type_id) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = ORDER BY p.products_id ASC]

  2. #2
    Join Date
    Feb 2007
    Posts
    7
    Plugin Contributions
    0

    Default Re: Google Froogle Syntax Error

    Quote Originally Posted by aburime View Post
    Hi Everyone,

    I have just installed the Froogles Merchant file and I get this two errors, can anybody help out?
    SQL query:
    SELECT @configuration_group_id := configuration_group_id
    FROM configuration_group
    WHERE configuration_group_title = 'Google Froogle Configuration'
    LIMIT 1 ;

    MySQL said:
    #1146 - Table 'aburime_zc1.configuration_group' doesn't exist

    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 'ORDER BY p.products_id ASC' at line 10
    in:
    [SELECT p.products_id, p.products_model, pd.products_name, pd.products_description, p.products_image, p.products_tax_class_id, p.products_price_sorter, GREATEST(p.products_date_added, p.products_last_modified, p.products_date_available) AS base_date, m.manufacturers_name, p.products_quantity, pt.type_handler FROM zen_products p LEFT JOIN zen_manufacturers m ON (p.manufacturers_id = m.manufacturers_id) LEFT JOIN zen_products_description pd ON (p.products_id = pd.products_id) LEFT JOIN zen_product_types pt ON (p.products_type=pt.type_id) WHERE p.products_status = 1 AND p.product_is_call = 0 AND p.product_is_free = 0 AND pd.language_id = ORDER BY p.products_id ASC]
    In addition to the above I have noticed that froogle's sql configuration_id is numbered 1 thru 8 and skipped 9 thru 11 to 12. Will that have been normal?
    I cannot find the above 'ORDER BY p.products_id ASC' in the file. Am I using the correct file?

 

 

Similar Threads

  1. Replies: 1
    Last Post: 25 Aug 2011, 05:58 AM
  2. Google Analytics syntax error
    By gnrocks2 in forum General Questions
    Replies: 2
    Last Post: 11 Jun 2009, 12:08 AM
  3. 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
  4. Error after installing Google Froogle module
    By dealbyethan.com in forum All Other Contributions/Addons
    Replies: 4
    Last Post: 1 Jun 2007, 06:28 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