SQL Error 1064??

[DrByte]

So, switching templates gets rid of the error.

That means something in one or more of your override files is causing the problem.

What files do you have in your /includes/modules/YOUR_CUSTOM_TEMPLATE/ folder?

[Zlink]

Hello, DrByte

Help, I do not know what I do!

Where does this look?


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 ')' at line 13
in:
[select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, p.products_date_added, p.products_price, p.products_type, p.master_categories_id from zen_products p, zen_products_description pd where p.products_id = pd.products_id and pd.language_id = '2' and p.products_status = 1 and p.products_id in ()]

Tanks

[DrByte]

Help, I do not know what I do!

Where does this look?


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 ')' at line 13
in:
[select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, p.products_date_added, p.products_price, p.products_type, p.master_categories_id from zen_products p, zen_products_description pd where p.products_id = pd.products_id and pd.language_id = '2' and p.products_status = 1 and p.products_id in ()]

Tanks

That's a completely different situation, which should remain in the original discussion in which you started it: http://www.zen-cart.com/forum/showthread.php?t=103576

[sethererm]

The only file I have in there is the product_listing.php

I've replaced that file with the original from the package that I downloaded - several times. I've also replaced the file product_listing.php with the original from the zen-cart download in the includes/modules/ directory as well.

[sethererm]

Well, I just went ahead and reinstalled the store to a new directory. For the moment it isn't broken and I have most of the store changed over already to look correctly. I have a new question that isn't related to this one. So I am going to make a new thread for it.

Thank you so much for looking and trying to help me Dr. Byte. Your intelligence and usefulness is unmatched.

If I ever have time to just mess around with some of the older directories and I figure out what it was that I did wrong I will make sure to come back to this forum and explain it to the best of my knowledge.

Thanks again!

[sethererm]

I FIGURED IT OUT!

Quite irritating because it was such an error that I never would have caught it intentionally.

In the admin section under configuration->product listing -> Product Listing Columns Per Row - the maximum amount of products you can have is 10. I don't know why...because I wanted all my products to be able to display on one page...but you can't. So..I had it set to 75...and that was a LOT to high and broke the sql. I found it out on my 3rd remake of this website. Glad to have figured it out but irritating that it broke the website.

Hope this will help someone else.

Thanks to everyone that helped me out with this - or looked into it.