PDA

View Full Version : Errors in certain areas of my admin area



starview
06-04-2007, 06:17 PM
I am getting these error in my admin area when I select the different areas list below listed 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]

jpf
06-05-2007, 03:52 AM
Restore database from backup. Reinstall. Double check what you edited. Make sure all files are uploaded.

You did not say if it was working before or what has changed since. This looks like a SQL problem. Did your host upgrade the SQL to a newer version?

starview
06-05-2007, 05:07 AM
Restore database from backup. Reinstall. Double check what you edited. Make sure all files are uploaded.

You did not say if it was working before or what has changed since. This looks like a SQL problem. Did your host upgrade the SQL to a newer version?

I found the problem my "splite_page_results.php" was corrupted

heebeha
03-19-2008, 10:00 AM
Where is this file splite_page_results.php located? I cant find it anywhere. I am having the exact same issue. HELP.

Thanks.

Jeff Dean

starview
03-19-2008, 12:51 PM
The file "splite_page_results.php" is located in the admin area under admin/includes/classes.

if you are having the same problem, just replace this file with a new on from the oscommerce file. That is the best I can do, because I don't use Oscommerce any more.