Redmine

Thank you for the response.

Mysql Version: mysql Ver 14.14 Distrib 5.1.45, for pc-linux-gnu (x86_64) using readline 5.1
Rake version: rake, version 0.8.7

Output from script/about:

About your application's environment
Ruby version              1.8.7 (x86_64-linux)
RubyGems version          1.3.7
Rack version              1.1
Rails version             2.3.8
Active Record version     2.3.8
Active Resource version   2.3.8
Action Mailer version     2.3.8
Active Support version    2.3.8
Application root          /home/redmine/redmine-1.0
Environment               production
Database adapter          mysql
Database schema version   20100819172912

Forgot to mention the install: this was an upgrade from version 0.9.3. Search was working fine before the upgrade.

The database clearly does not have a column text in the wiki_pages table for me. Instead, the wiki_contents table has the column. Perhaps the database upgrade script is not fully working?

Rails 2.3.8 is not supported yet. Can you please try with Rails 2.3.5 and tell us if it works better ? I don't have the same exact SQL query generated on my test environment with sqlite, and don't have currently access to the logs on my redmine/mysql server..

Thank you Jean-Baptiste for the responses.

I could try to use Rails 2.3.5 but I highly doubt that that is what's causing the issue. As I mentioned, in my database, the wiki_pages table does not have a column named text which is the cause of this problem. Please let me know if you still believe downgrading to Rails 2.3.5 might be a possible fix.

I believe this is a database migration issue. However, the wiki pages themselves work just fine.

Anything on this? Any help would be much appreciated.

i can confirm this issue (Redmine 1.0.1.devel.4087 (MySQL))

it looks like you are searching through the text field in wiki_contents but this table is not joined; this query (as taken from the logfile output) returns the same error as above:

 SELECT DISTINCT `wiki_pages`.id
FROM `wiki_pages`
LEFT OUTER JOIN `wikis` ON `wikis`.id = `wiki_pages`.wiki_id
LEFT OUTER JOIN `projects` ON `projects`.id = `wikis`.project_id
WHERE (
(
projects.status =1
AND projects.id
IN (

SELECT em.project_id
FROM enabled_modules em
WHERE em.name = 'wiki'
)
AND wikis.project_id
IN ( 9 )
)
AND (
(
(
LOWER( title ) LIKE '%serverkast%'
)
OR (
LOWER( text ) LIKE '%serverkast%'
)
)
)
)
ORDER BY wiki_pages.created_on DESC
LIMIT 11 

when i add the wiki_contents table manually it doesn't give an error anymore:

SELECT DISTINCT `wiki_pages`.id
FROM `wiki_pages`
LEFT OUTER JOIN `wikis` ON `wikis`.id = `wiki_pages`.wiki_id
LEFT OUTER JOIN `projects` ON `projects`.id = `wikis`.project_id
LEFT JOIN `wiki_contents` ON `wiki_contents`.page_id
WHERE (
(
projects.status =1
AND projects.id
IN (

SELECT em.project_id
FROM enabled_modules em
WHERE em.name = 'wiki'
)
AND wikis.project_id
IN ( 9 )
)
AND (
(
(
LOWER( title ) LIKE '%serverkast%'
)
OR (
LOWER( text ) LIKE '%serverkast%'
)
)
)
)
ORDER BY wiki_pages.created_on DESC
LIMIT 11

Hope this helps!

Downgrading Rails 2.3.8 to 2.3.5 solves this issue for me!
if it helps anybody: *here* you'll find how to downgrade.

best of luck!

Jaap

Same as Felix.

Sahand S wrote:

I could try to use Rails 2.3.5 but I highly doubt that that is what's causing the issue. As I mentioned, in my database, the wiki_pages table does not have a column named text which is the cause of this problem. Please let me know if you still believe downgrading to Rails 2.3.5 might be a possible fix.

Just to explain you a bit more : the "text" column is not in the table you think, but in an other one that should be joined in the query. Mysql (or whatever your database engine is) understands that there's no column named "text" in the wiki_pages table and take the one in the joined table. It's standard SQL behavior as long as there's no ambiguous column name.

The request is probably not generated the same way between 2.3.5 sql adapter and 2.3.8 one. We cannot support 2.3.8 now, we already have far too many OS/ruby versions/database engines/locales supported.

Hope you'll understand.

Understood. I downgraded rails to 2.3.5 and that solved the problem. Thank you all for the support.

I think I found a simple fix for this:

Class WikiPage => line 33:

acts_as_searchable :columns => ['title', 'wiki_contents.text'],

Where I just added the wiki_contents table indicator

Still needed with Rails 2.3.11 ?