I have an up to date instatallion of Drupal and it's modules (stable releases).
I've created around 50 products in commerce (cursos), as well as one or two product display nodes .

I have been using Views to create a table of products. I can add some fields, and have set up a relationship to Content: Curso (this issue appears whether I do this or not. However when I add certain fields to the fields selection: (Content: Curso Appears in: node:product_display.)
I get this error:
SQLSTATE[42000]:Syntax error or access violation: 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 commerce_product_field_data_field_curso_, 'commerce_product' AS field_data_fi' at line 1


rszrama’s picture

Category: bug » support
Status: Active » Closed (cannot reproduce)

Sorry, without having the View or even the full query there's no way for us to diagnose this. I can't even tell from the message you've included what's invalid about the query unless it's ending the alias with an underscore. : ?