I have created a view in Drupal 7 using views 3 and it is throwing some sql error in preview and the error message is not complete showing here. How can I check this sql complete error message? Is there any option to see SQL generated by view so that I can test the same on mysql client?

Thanks in advance for your help. Umar

  • I have explored views more to see the sql query from view settings. I can choose to display the query; it's a checkbox called "Show the SQL query" on the Views settings page (admin/structure/views/settings). The SQL error problem is still there. I want to see the sql error messeage. Thanks
    – Umar
    Commented Mar 7, 2012 at 5:28

1 Answer 1


Your recent log messages should show the complete error (if you click on the message link).

You can find recent log messages at http://YOURSITE.com/admin/reports/dblog, or by clicking -> Administration -> Reports -> Recent log messages

Not the answer you're looking for? Browse other questions tagged or ask your own question.