Main page glitched O.o

[Ayperi]

Well, first off I'm new to the forum, though been lurking getting answers I've needed, but I came across something that I can't find an answer to. My store ran fine so far, been able to get most issues I had fixed, but I decided to go ahead and work some of the bug fixes for my current version 1.38a just incase so I don't get issues later and now on my main page I get an error

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 7
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 = '1' and p.products_status = 1 and p.products_id in ()] 

where my new products for the month would be shown in the center page. Granted I didn't use all the bug fixes since some didn't pertain to some of my uses.
I have some mods as of follows:
Admin Activity Report, contact_us subject mod, godaddy SSL, stock by attributes, captcha with phone number not required, option insurance with shipping, lightbox. I also have the free shipping rules but I'm not using it currently. Dunno if any of those makes any difference. So far as I can tell it effects the main page only.
Should I just go back and replace the files with the older original or is there any way to fix this? I already did a restore back up of my store and that didn't seem to work for some reason as the updated files didn't seem to be affected. I'm familiar with tinkering and stuff but by no means an expert lol So any help is appreciated with my thanks. If all comes to it, I can just try to replace the ones I "fixed" with the a default. Just don't see how the files could affect this.

[Ayperi]

forgot to mention that my right side sideboxes and footer has disappeared too. Left side boxes show up fine.

[Ayperi]

Nvm, I found that it was something involving the upcoming_products.php and the new_products.php files that glitched my main page when I tried to "update" it with the bug fixes. I'm thinking there's a mod I got that didn't like something there or I missed something in the code, but I simply just went back and replaced it with original files and it fixed that. ^-^;