Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2005
    Posts
    278
    Plugin Contributions
    0

    help question Urgent Code Issue - Help Please

    Hi,
    Does anyonw know what the following error code means, I purchased something for Zencart and installed all the files as informed to do so by the guidelines but the site comes up with the following error codes:

    Whats it mean and how do i Resolve it?

    Thanks,
    Adam.


    Warning: Variable passed to each() is not an array or object in /home/adam123/public_html/includes/classes/db/mysql/query_factory.php on line 114

    Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/adam123/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/adam123/public_html/includes/functions/sessions.php on line 108

    Warning: Cannot modify header information - headers already sent by (output started at /home/adam123/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/adam123/public_html/includes/init_includes/init_templates.php on line 78

    • Shipping Info
    • Featured Products
    • Specials
    • Site Search
    • Contact Us
    • Create an account
    • Customer login


    • HOME
    • NEW PRODUCTS
    • MY ACCOUNT
    • SHOPPING CART
    • CHECKOUT
    Worldwide drop shipping with A NO FEE MEMBERSHIP.
    New Products For November
    Featured Products
    Monthly Specials For November
    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 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCT' at line 7
    in:
    [select p.products_id, pd.products_name, products_date_available as date_expected from zen_products p, zen_products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' and p.products_date_available >=20071104 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

  2. #2
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: Urgent Code Issue - Help Please

    It means much what it says. A Zen Cart class was expected an array or object as a parameter but received something different (often a NULL value). As a result it can't complete what it is supposed to do to the array or object.

    From the SQL error further down it looks as there may be a language or definitions file missing. But not knowing anything about the product that you have bought, let alone your specific installation of it, it's not possible to comment further. In any case, your first port of call should be the vendor.
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  3. #3
    Join Date
    Nov 2005
    Posts
    278
    Plugin Contributions
    0

    Default Re: Urgent Code Issue - Help Please

    Quote Originally Posted by kuroi View Post
    It means much what it says. A Zen Cart class was expected an array or object as a parameter but received something different (often a NULL value). As a result it can't complete what it is supposed to do to the array or object.

    From the SQL error further down it looks as there may be a language or definitions file missing. But not knowing anything about the product that you have bought, let alone your specific installation of it, it's not possible to comment further. In any case, your first port of call should be the vendor.
    Thanks for the help,
    I decided to install the RSS feed from Zencart, but I get this now:

    Hi,
    I get this error message on my site:

    Warning: Variable passed to each() is not an array or object in /home/adam123/public_html/includes/classes/db/mysql/query_factory.php on line 114

    Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/adam123/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/adam123/public_html/includes/functions/sessions.php on line 108

    Warning: Cannot modify header information - headers already sent by (output started at /home/adam123/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/adam123/public_html/includes/init_includes/init_templates.php on line 78
    Shipping Info Featured Products
    Specials Site Search Contact Us Create an account Customer login
    Home New Products My Account Shopping Cart Checkout
    Worldwide drop shipping with A NO FEE MEMBERSHIP.
    New Products For NovemberFeatured ProductsMonthly Specials For November
    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 'EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCT' at line 7
    in:
    [select p.products_id, pd.products_name, products_date_available as date_expected from zen_products p, zen_products_description pd where p.products_id = pd.products_id and p.products_status = 1 and pd.language_id = '1' and p.products_date_available >=20071104 order by EXPECTED_PRODUCTS_FIELD EXPECTED_PRODUCTS_SORT limit MAX_DISPLAY_UPCOMING_PRODUCTS]

    This happens when it loads (It loads ok and sometimes) and when every I click on a product for it's details. How do I fix this?

    Can you help at all?

  4. #4
    Join Date
    Apr 2006
    Location
    London, UK
    Posts
    10,569
    Plugin Contributions
    25

    Default Re: Urgent Code Issue - Help Please

    It still looks to me as though you have a language or definitions file missing or misplaced. But as I'm not familiar with this mod, I can't be more specific.
    Kuroi Web Design and Development | Twitter

    (Questions answered in the forum only - so that any forum member can benefit - not by personal message)

  5. #5
    Join Date
    Nov 2005
    Posts
    278
    Plugin Contributions
    0

    Default Re: Urgent Code Issue - Help Please

    Quote Originally Posted by kuroi View Post
    It still looks to me as though you have a language or definitions file missing or misplaced. But as I'm not familiar with this mod, I can't be more specific.
    Hi the mode was the rss_feed by Andrew.

    I have now removed the files and still have the issue:

    Hi,
    My site shows the following error codes:

    Warning: Variable passed to each() is not an array or object in /home/adam123/public_html/includes/classes/db/mysql/query_factory.php on line 114

    Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/adam123/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/adam123/public_html/includes/functions/sessions.php on line 108

    Warning: Cannot modify header information - headers already sent by (output started at /home/adam123/public_html/includes/classes/db/mysql/query_factory.php:114) in /home/adam123/public_html/includes/init_includes/init_templates.php on line 78

    Would you know what is wrong and how I could fix this please?

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

    Default Re: Urgent Code Issue - Help Please

    You might read through this thread and see if there is anything related:
    http://www.zen-cart.com/forum/showth...y.php+line+114
    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!

 

 

Similar Threads

  1. Reward Points Module Urgent Help Please Please!
    By dariocdj in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 7 Apr 2011, 02:59 AM
  2. URGENT alignment issue Firfox/IE PLEASE!!
    By jill8026 in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 25 Apr 2008, 05:34 PM
  3. help w/ authorize.net seal code [URGENT]
    By dvenzo in forum Templates, Stylesheets, Page Layout
    Replies: 0
    Last Post: 24 Feb 2007, 08:59 AM
  4. Urgent Urgent help needed please
    By con-fused in forum General Questions
    Replies: 1
    Last Post: 12 Feb 2007, 09:41 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