Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
Here are the steps I followed:
I installed & activated the modules (shadow & views)
Once I visited one of my views pages I noticed that it appeared on admin/build/shadow/queries
clicked on the newly appeared title of the view, thus going to admin/build/shadow/queries/list/2
selected create new table, selected a few tables there and when I finally applied the changes, this message appeared:
Syntax error in definition: Parse error in state join_right_field at offset 33 (near *,content_).
Syntax error in definition: Parse error in state join_right_field at offset 24 (near *,uc_produ).
Syntax error in definition: Parse error in state join_right_field at offset 33 (near *,content_).
Needless to say, NO table was created in my database.
Any help? I really need this...
Comments
Comment #1
mauritsl CreditAttribution: mauritsl commentedI've made some improvements to the SQL parser, so please try again with the latest version. Can you provide the full query if you still get an error?
Comment #2
aristeides CreditAttribution: aristeides commentedThanks a lot for looking into this!
Using latest dev, (uninstalled previous version first, then uploaded and activated the dev) I selected create a new table and after submiting I got an error The website encountered an unexpected error. Please try again later.
On the log:
My query:
Comment #3
mauritsl CreditAttribution: mauritsl commentedHmm the "JOIN (subquery)" is very rare, didn't know yet that views used that syntax. Did you set it up with relations? It does not seem to be the reason why your query is slow anyway, just wondering...
I have to set borders to what Shadow can parse and what not. It cannot understand all possible SQL queries, but it has to in order to be able to rewrite them, but I will take a look if I can build in support for the "JOIN (subquery)" syntax.
Comment #4
Wolfgang Reszel CreditAttribution: Wolfgang Reszel commentedI've also problems with some queries, for example: