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![]()



