I created a custom field in the core 6.22 profile module. It's a checkbox value and I attempted to add this field to a view. This is where I ran into the issue. I don't know that views builds it's own SQL so if someone more knowledgeable believes this to be views, please say so. My views module is at 6.x-2.13.

The query being generated and warning is:
warning: pg_query(): Query failed: ERROR: operator does not exist: text <> integer at character 430 HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. in /data/site/includes/database.pgsql.inc on line 138.

user warning: query: SELECT users.uid AS uid, profile_values_profile_driver.value AS profile_values_profile_driver_value, users.mail AS users_mail, users.name AS users_name FROM drupal_users users LEFT JOIN drupal_profile_values profile_values_profile_driver ON users.uid = profile_values_profile_driver.uid AND profile_values_profile_driver.fid = '16' WHERE profile_values_profile_driver.value <> 0 LIMIT 10 OFFSET 0 in /data/www/vulcans/sites/all/modules/views/includes/view.inc on line 771

Of course, if I change the <> 0 to "= '1'" then I get my data.

Thanks!

Comments

Status: Active » Closed (outdated)

Automatically closed because Drupal 6 is no longer supported. If the issue verifiably applies to later versions, please reopen with details and update the version.