Zen Cart Logo
Forums / General Questions / 1065 query was empty in []

1065 query was empty in []

Locked

Views: 1,003

Results 1 to 1 of 1
This thread is locked. New replies are disabled.
13 Dec 2010, 9:55 PM
#1
picandnix avatar

picandnix

Totally Zenned

Join Date:
Dec 2010
Location:
UK
Posts:
1,780
Plugin Contributions:
2

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 :cry: