I get a whole bunch of errors that fills up the php log, all related to mysql.inc line 174.

---- Preview ------
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 ''') AND (ec_product.ptype IS NOT NULL) AND (node.created >= 1231048800 && node.c' at line 1 query: SELECT count(node.nid) FROM node node LEFT JOIN ec_product ec_product ON node.vid = ec_product.vid WHERE (. '') AND (ec_product.ptype IS NOT NULL) AND (node.created >= 1231048800 && node.created <= 1233813599) AND node.nid = 2242 in includes/database.mysql.inc on line 174

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 ''') AND (. '') AND node.nid = 6' at line 1 query: SELECT count(node.nid) FROM node node LEFT JOIN ec_product ec_product ON node.vid = ec_product.vid WHERE (. '') AND (. '') AND node.nid = 6 in includes/database.mysql.inc on line 174

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 ''') AND (. IN ('','')) AND (YEAR(from_UNIXTIME(event.event_start)) = YEAR(from_U' at line 1 query: SELECT count(node.nid) FROM node node LEFT JOIN event event ON node.nid = event.nid WHERE (. '') AND (. IN ('','')) AND (YEAR(from_UNIXTIME(event.event_start)) = YEAR(from_UNIXTIME(1233745054))) AND (MONTH(from_UNIXTIME(event.event_start)) >= MONTH(from_UNIXTIME(1233745054))) AND (DAYOFMONTH(from_UNIXTIME(event.event_start)) >= 1) AND node.nid = 2242 in includes/database.mysql.inc on line 174

And the list goes on FOREVER!!!!
Help please!!!!

Comments

dave reid’s picture

dave reid
he/him
Primary language English
Location Nebraska USA
commented
Priority: Critical » Normal

What kind of eCommerce/Event modules are you using? This doesn't look like a problem with Drupal core, so you might want to file issues for the problematic contrib modules.

OsterD’s picture

OsterD commented

I am using Address, Paypal, all of the Product Types (Apparel, Auction, Donate, EC Media, File Product, Generic Product, Parcel Product, Tangible Product) and Coupon,
E-Commerce Stats, EC Recurring, EC Role, EC Useracc, EC Views, Flexicharge, Invoice, Region, Role Discount, Shipcalc(Shipping API), Subproduct, Tax API

seaneffel’s picture

seaneffel commented

Start by peeling back some layers of ecommerce modules. Disable everything but the required modules and reenable them one by one, each time checking for which specific module might be causing the trouble. If you disable -all- of the EC modules and the problem goes away then its probably an EC problem and not core.

This will help get to the bottom of the issue.

OsterD’s picture

OsterD commented
Status: Active » Closed (fixed)
seaneffel’s picture

seaneffel commented

Hey, can't just close the ticket. Did you get it solved?