1064 error sql syntax

[pjgscrap]

I'm sorry for starting a thread about this, but I read through all of the others and I still can't get rid of this problem. In maximum values the only value set to 0 is the order details (there possibly was a value set to 0 that my aunt went and changed back already). I tried repairing the db. I called the host, they have not updated php or mysql and there is still plenty of room on the server. No new mods have been added in quite some time. Zen cart is up to date, latest version. I get these errors almost everywhere in the admin panel. Here is the one from categories / products. I should also note that the store, other than admin seems to be fine.


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_type, p.products_id, pd.products_name, p.products_quantity, ' at line 1
in:
[select count(select p.products_type, p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.products_model, p.products_quantity_order_min, p.products_quantity_order_units, p.products_priced_by_attribute, p.product_is_free, p.product_is_call, p.products_quantity_mixed, p.product_is_always_free_shipping, p.products_quantity_order_max, p.products_sort_order from zen_products p, zen_products_description pd, zen_products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = \'1\' and p.products_id = p2c.products_id and p2c.categories_id = \'0\' order by p.products_sort_order, pd.products_name) as total ]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

[pjgscrap]

Again sorry about the post, but maybe this will help someone in the future. It's funny just as I was losing my mind and posting for help, I managed to fix this. For some reason the cause was the split_page_results.php in admin/includes/classes, all I did was replace this with a backup and everything started working again.

[haredo]

Pj,
Thanks for the update for us as fellow Zenners