By onderd on

hallo. i've some problems with my site after i installed gallery2 integration module:
i fixed some of them but this one i couldn't. when i try to search something: get this error:

* user warning: Operand should contain 1 column(s) query: CREATE TEMPORARY TABLE temp_search_results SELECT i.type, i.sid, 10 * (3,1405161662104 * i.relevance) + 10 * POW(2, (GREATEST(n.created, n.changed, c.last_comment_timestamp) - 1210077057) * 6.43e-8) AS score FROM temp_search_sids i INNER JOIN v5_search_dataset d ON i.sid = d.sid AND i.type = d.type INNER JOIN v5_node n ON n.nid = i.sid LEFT JOIN v5_node_comment_statistics c ON c.nid = i.sid WHERE (d.data LIKE '% deneme %') ORDER BY score DESC in /www/htdocs/w009d303/dr5/includes/database.mysql.inc on line 172.
* user warning: Table 'd007c40e.temp_search_results' doesn't exist query: SELECT COUNT(*) FROM temp_search_results in /www/htdocs/w009d303/dr5/includes/database.mysql.inc on line 172.

info: my host accepts CREATE TEMPORARY TABLE comments

⋅ Categories: Drupal 5.x

Comments

onderd’s picture

onderd commented

i've just changed my site language to english. then the search works. but when i change it to turkish i get the error above. what should i do. has anyone an idea

zeip’s picture

zeip commented

I had the same problem with Finnish language and the Gallery 2 module. I discovered that when I disabled the Gallery Menu module, the search started working OK.

mardersenf’s picture

mardersenf commented

Should I really decide between gallery and search? I use German as the default language.

Christian

http://keepy.net

physiotek’s picture

physiotek commented

i have the same problem here with french and gallery2. any1 have a solution?

physiotek’s picture

physiotek commented

ok i tried the solution proposed by zeip and it is working, and there is no huge deficit concerning gallery.
+1

robert00frag’s picture

robert00frag commented

I get the same error since upgrading Drupal to 5.8 on a german site. Before the update, everything worked well.
The Gallery module is an essential part of my site, so disabling it is not an option. Are there any new information about this issue?

fishclic’s picture

fishclic commented

Same error (no result with the search module on a drupal site in french language, with gallery2 embbended).

Same solution (disable the "Gallery2 Menu" module).

merilainen’s picture

merilainen commented

I get same kind of error "CREATE TEMPORARY TABLE temp_search_results" and I'm not using Gallery module. I have Finnish language as primary language, maybe it has something to do with that?

soeren.dohmen’s picture

soeren.dohmen commented

BUT: a floating-point formatting error.

I had a problem with search indexing!! Which is not exactly your problem. But it seems to be a localization error.

At least in Germany we don't have floating-point, but floating-comma.
The database query in my case was for example: "INSERT INTO search_index (word, sid, type, score) VALUES ('word', 10, 'something', 11,5679)". That couldn't work, because it tries to insert 5 values into a 4 column table.