Errors

[Guest]

I am getting these error in my admin area when I select the different areas list below with the error, don't know what happen, need help to fix it.

 

Currencies

 

Currency Code Value Action

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 'select currencies_id, title, code, symbol_left, symbol_right, decimal_point, tho' at line 1

 

select count(select currencies_id, title, code, symbol_left, symbol_right, decimal_point, thousands_point, decimal_places, last_updated, value from currencies order by title) as total

 

[TEP STOP]

 

 

Languages

 

Language Code Action

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 'select languages_id, name, code, image, directory, sort_order from languages ord' at line 1

 

select count(select languages_id, name, code, image, directory, sort_order from languages order by sort_order) as total

 

[TEP STOP]

 

 

Orders Status

 

Orders Status Action

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 'select orders_status_id, orders_status_name from orders_status where language_id' at line 1

 

select count(select orders_status_id, orders_status_name from orders_status where language_id = \'1\' order by orders_status_id) as total

 

[TEP STOP]

 

 

Report area

 

Best Viewed Products

 

No. Products Viewed

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 'select p.products_id, pd.products_name, pd.products_viewed, l.name from products' at line 1

 

select count(select p.products_id, pd.products_name, pd.products_viewed, l.name from products p, products_description pd, languages l where p.products_id = pd.products_id and l.languages_id = pd.language_id order by pd.products_viewed DESC) as total

 

[TEP STOP]

 

 

Best Products Purchased

 

No. Products Purchased

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 'select p.products_id, p.products_ordered, pd.products_name from products p, prod' at line 1

 

select count(select p.products_id, p.products_ordered, pd.products_name from products p, products_description pd where pd.products_id = p.products_id and pd.language_id = \'1\' and p.products_ordered > 0 group by pd.products_id order by p.products_ordered DESC, pd.products_name) as total

 

[TEP STOP]

 

 

Best Customer Orders-Total

 

No. Customers Total Purchased

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 'select c.customers_firstname, c.customers_lastname, sum(op.products_quantity * o' at line 1

 

select count(select c.customers_firstname, c.customers_lastname, sum(op.products_quantity * op.final_price) as ordersum from customers c, orders_products op, orders o where c.customers_id = o.customers_id and o.orders_id = op.orders_id group by c.customers_firstname, c.customers_lastname order by ordersum DESC) as total

 

[TEP STOP]

 

 

Newsletter Manager

 

Newsletter Manager

 

Newsletters Size Module Sent Status Action

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 'select newsletters_id, title, length(content) as content_length, module, date_ad' at line 1

 

select count(select newsletters_id, title, length(content) as content_length, module, date_added, date_sent, status, locked from newsletters order by date_added desc) as total

 

[TEP STOP]

 

 

Locations/Taxes

Countries

 

Country ISO Codes Action

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 'select countries_id, countries_name, countries_iso_code_2, countries_iso_code_3,' at line 1

 

select count(select countries_id, countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id from countries order by countries_name) as total

 

[TEP STOP]

 

 

 

Zones

 

Country Zones Code Action

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 'select z.zone_id, c.countries_id, c.countries_name, z.zone_name, z.zone_code, z.' at line 1

 

select count(select z.zone_id, c.countries_id, c.countries_name, z.zone_name, z.zone_code, z.zone_country_id from zones z, countries c where z.zone_country_id = c.countries_id order by c.countries_name, z.zone_name) as total

 

[TEP STOP]

 

 

Tax Zones

 

Tax Zones Action

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 'select geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_add' at line 1

 

select count(select geo_zone_id, geo_zone_name, geo_zone_description, last_modified, date_added from geo_zones order by geo_zone_name) as total

 

[TEP STOP]

 

 

Tax Classes

 

Tax Classes Action

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 'select tax_class_id, tax_class_title, tax_class_description, last_modified, date' at line 1

 

select count(select tax_class_id, tax_class_title, tax_class_description, last_modified, date_added from tax_class order by tax_class_title) as total

 

[TEP STOP

 

Tax Rates

 

Priority Tax Class Zone Tax Rate Action

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 'select r.tax_rates_id, z.geo_zone_id, z.geo_zone_name, tc.tax_class_title, tc.ta' at line 1

 

select count(select r.tax_rates_id, z.geo_zone_id, z.geo_zone_name, tc.tax_class_title, tc.tax_class_id, r.tax_priority, r.tax_rate, r.tax_description, r.date_added, r.last_modified from tax_class tc, tax_rates r left join geo_zones z on r.tax_zone_id = z.geo_zone_id where r.tax_class_id = tc.tax_class_id) as total

 

[TEP STOP]

 

 

 

Customers Search:

 

Last Name First Name Account Created Action

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 'select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_' at line 1

 

select count(select c.customers_id, c.customers_lastname, c.customers_firstname, c.customers_email_address, a.entry_country_id from customers c left join address_book a on c.customers_id = a.customers_id and c.customers_default_address_id = a.address_book_id order by c.customers_lastname, c.customers_firstname) as total

 

[TEP STOP]

 

 

Orders Order ID:

Status: All OrdersPendingProcessingDeliveredMailing in Payment

 

 

Customers Order Total Date Purchased Status Action

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 'select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last' at line 1

 

select count(select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = \'1\' and ot.class = \'ot_total\' order by o.orders_id DESC) as total

 

[TEP STOP]