Jump to content

sftryeler

Members
  • Content count

    3
  • Joined

  • Last visited

Profile Information

  • Real Name
    B Perez
  1. sftryeler

    Abstract Zones

    I got it to work!! thanks for your support. I should have my site up and running in no time!
  2. sftryeler

    Abstract Zones

    Hello all! I'm fairly new to everything but can sometimes work my problems out. I installed the abstract zones contrib. and everything works fine except for when i go to my reports I get 2 errors. --------------------------------- #1 Best 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 '*) as total from products p, products_description pd where pd. select count(distinct *) as total from products p, products_description pd where pd.products_id = p.products_id and pd.language_id = '1' and p.products_ordered > 0 [TEP STOP] ---------------------------------#2 Best Customer Orders-Total 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 '*) as total from customers c, orders_products op, orders o whe select count(distinct *) as total from customers c, orders_products op, orders o where c.customers_id = o.customers_id and o.orders_id = op.orders_id [TEP STOP] I just don't know where to start. If someone could help me out I'd really appreciate it :lol:
  3. sftryeler

    Syntax Error!

    Hello all! I'm fairly new to everything but can sometimes work my problems out. I installed the abstract zones contrib. and everything works fine except for when i go to my reports I get 2 errors. --------------------------------- #1 Best 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 '*) as total from products p, products_description pd where pd. select count(distinct *) as total from products p, products_description pd where pd.products_id = p.products_id and pd.language_id = '1' and p.products_ordered > 0 [TEP STOP] ---------------------------------#2 Best Customer Orders-Total 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 '*) as total from customers c, orders_products op, orders o whe select count(distinct *) as total from customers c, orders_products op, orders o where c.customers_id = o.customers_id and o.orders_id = op.orders_id [TEP STOP] I just don't know where to start. If someone could help me out I'd really appreciate it :lol:
×