Brand new to views so I'm unsure if it's a bug or I just broke the internet, but when I attempted to limit an unsorted list (block) to a particular user (one that doesn't exist yet, if that's important) I got an SQL syntax error but it appears that the transaction completed successfully. I didn't save the SQL error from the views configuration page but I do remember the relevant query ended in "LIKE '' Now whenever I visit the views page itself I'm greeted with this wonderful error:
Debug:
'Exception: 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 \'LIKE \'Flickist\' ESCAPE \'\\\\\') ))) subquery\' at line 1'
in views_plugin_query_default->execute() (line 1380 of /home/joeldavis84/flicks/sites/all/modules/views/plugins/views_plugin_query_default.inc).
I should be available if you need any more diagnostic information. I'm likely to undo this, though just so I can continue with my project and attempt to find a workaround, but I will be glad to provide you with any platform information that you may need.
Drupal Version: 7.2
Views Version: 7.x-3.0-rc1
OS: Linux (unsure of the variant as of yet)
| Comment | File | Size | Author |
|---|---|---|---|
| #3 | exported-view.txt | 4.84 KB | joeldavis |
| #1 | phpinfo.txt | 16.43 KB | joeldavis |
Comments
Comment #1
joeldavis commentedattaching PHP info from the server
Comment #2
dawehnerMost time the phpinfo isn't really helpful.
Better is a) an export of the view b) the full sql query generated by views. You can find it if you enable the sql preview on the views settings.
Comment #3
joeldavis commentedAttached is the exported view. I can't find the "SQL preview" portion though, where is it in the View's settings page?
Comment #4
dawehneron admin/structure/views/settings "Show the SQL query"
Comment #5
joeldavis commentedI found the check box but there doesn't seem to be a change in the output from what I can see. This is on a development server with little to no production data, if you want I can send you a login information for a test administrator account so you can see if somehow I did something wrong (even though it seems like just clicking the checkbox should do it).
Comment #6
joeldavis commentedn/m I was looking on the wrong page:
SELECT node.created AS node_created, node.nid AS nid
FROM
{node} node
WHERE (( (node.status = '1') AND (node.status = 1 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0 AND ***VIEW_OWN_UNPUBLISHED_NODES*** = 1) OR ***ADMINISTER_NODES*** = 1) AND (.authname LIKE 'Flickist' ESCAPE '\\') ))
ORDER BY node_created DESC
Comment #7
dawehnerThis is already fixed in the dev version.
Comment #9
bbeyer commentedSo has this fix made it into in 7.x-3.0-rc1?