Skip to content

My webstie suddnly accurence 'Database Error' as follows #67

@gaile

Description

@gaile

Could not execute query [Native Error: 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 ProductPrice.price <= 24) AS "1", SUM(ProductPrice.price >= 25 AND ProductPr' at line 1] [User Info: SELECT SUM(ProductPrice.price >= AND ProductPrice.price <= 24) AS "1", SUM(ProductPrice.price >= 25 AND ProductPrice.price <= 49) AS "2", SUM(ProductPrice.price >= 50 AND ProductPrice.price <= 99) AS "3", SUM(ProductPrice.price >= 100 AND ProductPrice.price <= 199) AS "4", SUM(ProductPrice.price >= 200 AND ProductPrice.price <= 499) AS "5", SUM(ProductPrice.price >= 500 AND ProductPrice.price <= 999) AS "6", SUM(ProductPrice.price >= 1000 AND ProductPrice.price <= 1999) AS "7", SUM(ProductPrice.price >= 2000 AND ProductPrice.price <= 4999) AS "8", SUM(ProductPrice.price >= 5000 AND ProductPrice.price <= 9999) AS "9", SUM(ProductPrice.price >= 10000 AND ProductPrice.price <= 10000000000.00) AS "10" FROM Product LEFT JOIN ProductPrice AS ProductPrice ON Product.ID = ProductPrice.productID AND (ProductPrice.currencyID = "USD") LEFT JOIN Category AS Category ON Product.categoryID = Category.ID WHERE (((Category.lft>=2 AND (Category.rgt<=89)) AND (Product.isEnabled=1))) ORDER BY Product.dateCreated DESC]

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions