Results 1 to 1 of 1

Hybrid View

  1. #1
    Join Date
    Dec 2010
    Location
    UK
    Posts
    1,771
    Plugin Contributions
    3

    Default 1065 query was empty in []

    Hi, as you can see I am a newbie so please be gentle with me.
    I have been building my store (clean install of 1.3.9f with a few add-ons) happily by reading this forum heaps and plenty of google action, but now I'm totally stumped...

    The following happens on my test and my live (in maintenance mode) site. I complete a test purchase, then return to 'my account' then click 'view' (account_history_info) then I get a blank page in my browser displaying

    1065 Query was empty
    in:
    []

    I have seen similar posts but not the same and no solutions, I have been banging my head for almost a week now on this one, please help.
    De-bug log gives me the following report....



    I AM HERE
    sidebox:

    Explain
    select configuration_key as cfgkey, configuration_value as cfgvalue
    from product_type_layout;



    I AM HERE
    sidebox:

    Explain
    select value
    from sessions
    where sesskey = '22ce61acf7198c6e9c83097xxxxxxxxx'
    and expiry > '1292158349';



    I AM HERE
    sidebox:

    Explain
    select code, title, symbol_left, symbol_right, decimal_point,
    thousands_point, decimal_places, value
    from currencies;



    and also....



    I AM HERE account_history_info
    sidebox:

    Explain
    select template_dir
    from template_select
    where template_language = 0;



    I AM HERE account_history_info
    sidebox:

    Explain
    select template_dir
    from template_select
    where template_language = '1';



    I AM HERE account_history_info
    sidebox:

    Explain
    select code
    from currencies
    where code = 'GBP' LIMIT 1;



    I AM HERE account_history_info
    sidebox:

    Explain
    select customers_firstname, customers_lastname
    from customers
    where customers_id = '2';



    I AM HERE account_history_info
    sidebox:

    Explain
    select count(*) as count
    from whos_online
    where session_id = '22ce61acf7198c6e9c83097xxxxxxxx' and ip_address='xxx.xxx.xxx.xxx';



    I AM HERE account_history_info
    sidebox:

    Explain
    select banners_id, date_scheduled
    from banners
    where date_scheduled != 'NULL';



    I AM HERE account_history_info
    sidebox:

    Explain
    select b.banners_id, b.expires_date, b.expires_impressions,
    sum(bh.banners_shown) as banners_shown
    from banners b, banners_history bh
    where b.status = 1
    and b.banners_id = bh.banners_id
    group by b.banners_id, b.expires_date, b.expires_impressions;



    I AM HERE account_history_info
    sidebox:

    Explain
    select *
    from get_terms_to_filter;



    I AM HERE account_history_info
    sidebox:

    Explain
    SELECT project_version_major, project_version_minor FROM project_version WHERE project_version_key = 'Zen-Cart Database';



    I AM HERE account_history_info
    sidebox:

    Explain
    select startdate, counter, session_counter from counter_history where startdate='20101212';



    I AM HERE account_history_info
    sidebox:

    Explain
    SELECT * FROM counter_history WHERE startdate = '20101212' AND counter = 1 AND session_counter = 1 LIMIT 1;



    I AM HERE account_history_info
    sidebox:

    Explain
    select startdate, counter from counter;



    I AM HERE account_history_info
    sidebox:

    Explain
    SELECT customers_id
    FROM orders
    WHERE orders_id = 1983;



    I AM HERE account_history_info
    sidebox:

    Explain
    SELECT os.orders_status_name, osh.date_added, osh.comments
    FROM orders_status os, orders_status_history osh
    WHERE osh.orders_id = 1983
    AND osh.orders_status_id = os.orders_status_id
    AND os.language_id = 1
    AND osh.customer_notified >= 0
    ORDER BY osh.date_added;



    I AM HERE account_history_info
    sidebox:

    Explain
    select customers_id, customers_name, customers_company,
    customers_street_address, customers_suburb, customers_city,
    customers_postcode, customers_state, customers_country,
    customers_telephone, customers_email_address, customers_address_format_id,
    delivery_name, delivery_company, delivery_street_address, delivery_suburb,
    delivery_city, delivery_postcode, delivery_state, delivery_country,
    delivery_address_format_id, billing_name, billing_company,
    billing_street_address, billing_suburb, billing_city, billing_postcode,
    billing_state, billing_country, billing_address_format_id,
    payment_method, payment_module_code, shipping_method, shipping_module_code,
    coupon_code, cc_type, cc_owner, cc_number, cc_expires, currency, currency_value,
    date_purchased, orders_status, last_modified, order_total, order_tax, ip_address
    from orders
    where orders_id = '1983';



    I AM HERE account_history_info
    sidebox:

    Explain
    select title, text, class
    from orders_total
    where orders_id = '1983'
    order by sort_order;



    I AM HERE account_history_info
    sidebox:

    Explain
    select count(*) as total
    from sessions
    where sesskey = '22ce61acf7198c6e9c83097xxxxxxxxx';



    From what I can work out (I may be wrong) it's to do with a SQL database error, but thats as much as I (think) I have managed to understand.
    Any and all help would be gratefully received
    Last edited by picandnix; 13 Dec 2010 at 10:59 PM.

 

 

Similar Threads

  1. v151 "PHP Fatal error: 1065:Query was empty" in admin
    By plot0808 in forum General Questions
    Replies: 2
    Last Post: 4 Feb 2014, 09:42 AM
  2. 1317 Query execution was interrupted
    By yannl in forum General Questions
    Replies: 1
    Last Post: 23 Apr 2011, 04:54 PM
  3. 1317 Query execution was interrupted (GoDaddy)
    By indigobnb in forum General Questions
    Replies: 1
    Last Post: 12 Sep 2010, 05:44 PM
  4. sending email error "Query was empty"
    By chac416 in forum General Questions
    Replies: 4
    Last Post: 8 Jun 2006, 04:42 AM

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