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.
In views if you add a filter for the support ticket state views can't select the appropriate table in the database because the module doesn't check to see if the site has a table prefix.
I fixed mine by adding manually adding my prefix to line 11 of the file views_handler_filter_support_state.inc
Comment | File | Size | Author |
---|---|---|---|
#3 | support_views-fixing_sqls_without_curly_braces.patch | 1.8 KB | rsevero |
#1 | support_views-prefixing_sql_table_names.patch | 1.74 KB | rsevero |
Comments
Comment #1
rsevero CreditAttribution: rsevero commentedTables names aren't surrounded by {}. State, priority and client have the same problem.
The attached patch fixes this issue.
Comment #2
vietcoop CreditAttribution: vietcoop commentedThat patch works fine, but please also use 2 spaces instead of tabs.
Also notice that _support_states() is available:
Comment #3
rsevero CreditAttribution: rsevero commentedThis last attached patch uses 2 sapces in the lines that I changed. AFAICT the whole code for this modules uses tabs instead of spaces.
Changed the get_value_options() method to call _support_states() instead of running it's own SQL call.
Comment #4
MisterSpeed CreditAttribution: MisterSpeed commentedWorks + committed; thanks everyone !