Problem A,
I wanted to create new filter.
I am using CCK Taxonomy.
Views - Filters - I add CCK Taxonomy: (some taxonomy) - I save It OK.
If I want to view filter - occurs message:
warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /www/doc/xxx/includes/database.mysql.inc on line 400.
I have MySQL database 5.0.22
PHP 4.4.2-1build1_a24_15_2
---------------------------------------------------
Problem B,
If I did the same with exposed filters and with:
MySQL database 4.1.15
PHP 5.1.2
Any message didn't occurs but filter doesn't works.

Comments

sentinelcz’s picture

sentinelcz commented

In point "A" helps update PHP from 4.4.2-1build1_a24_15_2 to 5.2.4.
In point "B" problem still exist.
Simply I created filter with CCK Taxonomy
I see this filter.
I select some value and press submit. Some nodes could hide (according to selected value), but I see everything.
Any nodes was hide.
Have somebody some idea ? Thank you.

catch’s picture

catch
he/him
Primary language English
commented
Project: Views (for Drupal 7) » CCK Taxonomy Fields
Version: 5.x-1.6 » 5.x-1.2

This sounds like a bug with cck taxonomy to me.

ryo’s picture

ryo commented

I have error messages like this;

warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /virtual/****/public_html/includes/database.mysql.inc on line 400.

I'm not sure but probably the upgrading to 1.6 of CCK might cause this uncompatibility...

sentinelcz’s picture

sentinelcz commented

Have you the same problem (Exposed Filters) or could you try to reproduce it?

sentinelcz’s picture

sentinelcz commented

Have you the same problem (Exposed Filters) or could you try to reproduce it?

ryo’s picture

ryo commented

Yes, I still have.

* warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /virtual/****/public_html/includes/database.mysql.inc on line 400.
* warning: mysql_real_escape_string() expects parameter 1 to be string, array given in /virtual/****/public_html/includes/database.mysql.inc on line 400.

emilyf’s picture

emilyf commented

I am also getting this error when searching an exposed text box filter in views:

warning: mysql_real_escape_string() expects parameter 1 to be
string, array given in /var/www/html/includes/database.mysql.inc on line
400.
* warning: mysql_real_escape_string() expects parameter 1 to be
string, array given in /var/www/includes/database.mysql.inc on line
400.

I don't have cck taxonomy installed, so I am more inclined to think this is a bug with Views. It's happening when I'm searching on text fields which have nothing to do with taxonomies. I have PHP 5.2.4, Views 5.1-dev version.