Quicksearch, the used table doesn't support fulltext...

Found a bug? Tell us!!
Galen
Regular
Posts: 6
Joined: Wed Oct 14, 2009 3:04 pm

Quicksearch, the used table doesn't support fulltext...

Post by Galen » Thu Feb 11, 2010 12:28 pm

Hello,

i just updated my Serendipity version from 1.5 beta 1 to 1.5.2.
In 1.5.-beta1 i always received this message when trying to use Quicksearch on MySQL:

Code: Select all

The search function did not work as expected. Notice for the administrator of this blog: This may happen because of missing index keys in your database. On MySQL systems your database user account needs to be privileged to execute this query:

CREATE FULLTEXT INDEX entry_idx on serendipity_entries (title,body,extended)

The specific error returned by the database was:

The used table type doesn't support FULLTEXT indexes


After the update, it's still the same problem.

Greetings and many thanks for seredipity
Galen

User avatar
garvinhicking
Core Developer
Posts: 30014
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Quicksearch, the used table doesn't support fulltext...

Post by garvinhicking » Thu Feb 11, 2010 1:07 pm

Hi!

Did you read the error mesage? :)

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

Galen
Regular
Posts: 6
Joined: Wed Oct 14, 2009 3:04 pm

Re: Quicksearch, the used table doesn't support fulltext...

Post by Galen » Thu Feb 11, 2010 3:03 pm

Yep Garvin,

I've read the errormessage, i just can't believe that s9y under mysql doesn't support full text search.
It tells me, that the table doesn't support full text indicees. In fact, when i saw this error, i tried to create the index myself with the mysql root user, and the same error message comes up.
Well, does that mean, that the search function is not available when using the mysql database? Or is it because the version that I use (and used) maybe created a bad database table type? I remember that i've read somwhere, that this was a bug under the 1.5. beta1 version.

Greetings, Galen

Galen
Regular
Posts: 6
Joined: Wed Oct 14, 2009 3:04 pm

Re: Quicksearch, the used table doesn't support fulltext...

Post by Galen » Thu Feb 11, 2010 3:55 pm

Hi Garvin,

solved the problem:
ALTER TABLE serendipity_entries ENGINE = MYISAM;

However, why it was not running on MyISAM, i don't know.

Greetings, Galen

User avatar
garvinhicking
Core Developer
Posts: 30014
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Quicksearch, the used table doesn't support fulltext...

Post by garvinhicking » Thu Feb 11, 2010 4:56 pm

Hi!

s9y uses the mysql default table type, if you set that to InnoDB in your configuration, yes, this might have side effects. Great you found this out. :)

Regards,
Garvin
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

kento
Regular
Posts: 31
Joined: Sun Mar 20, 2011 1:38 pm
Contact:

Re: Quicksearch, the used table doesn't support fulltext...

Post by kento » Wed Mar 23, 2011 12:55 am

have same problem in the new version of the blog, where do i correct that line and in what file?`
hope you can helt :D

User avatar
Timbalu
Regular
Posts: 4598
Joined: Sun May 02, 2004 3:04 pm

Re: Quicksearch, the used table doesn't support fulltext...

Post by Timbalu » Wed Mar 23, 2011 8:48 am

Hi Kento

No panic. Take PhpMyAdmin, a very nice tool to work in the database and open the db where serendipity is in.
Now you just add ALTER TABLE serendipity_entries ENGINE = MYISAM; to the sql form field and submit.
Maybe you need to do this with some more tables, to solve your search issue.
Regards,
Ian

Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian

User avatar
Timbalu
Regular
Posts: 4598
Joined: Sun May 02, 2004 3:04 pm

Re: Quicksearch, the used table doesn't support fulltext...

Post by Timbalu » Wed Mar 23, 2011 8:58 am

Sorry, I overread you are using workbench. Is there any command panel inside to put in mysql commands? Or maybe you just select the table and convert it it to MyIsam. Is it a working or a connection tool?
Regards,
Ian

Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian

kento
Regular
Posts: 31
Joined: Sun Mar 20, 2011 1:38 pm
Contact:

Re: Quicksearch, the used table doesn't support fulltext...

Post by kento » Wed Mar 23, 2011 8:59 am

Timbalu wrote:Hi Kento

No panic. Take PhpMyAdmin, a very nice tool to work in the database and open the db where serendipity is in.
Now you just add ALTER TABLE serendipity_entries ENGINE = MYISAM; to the sql form field and submit.
Maybe you need to do this with some more tables, to solve your search issue.
im using workbench and have this:
-- Trigger DDL Statements
DELIMITER $$

USE `serendipity`$$

is that the one?

kento
Regular
Posts: 31
Joined: Sun Mar 20, 2011 1:38 pm
Contact:

Re: Quicksearch, the used table doesn't support fulltext...

Post by kento » Wed Mar 23, 2011 9:06 am

kento wrote:
Timbalu wrote:Hi Kento

No panic. Take PhpMyAdmin, a very nice tool to work in the database and open the db where serendipity is in.
Now you just add ALTER TABLE serendipity_entries ENGINE = MYISAM; to the sql form field and submit.
Maybe you need to do this with some more tables, to solve your search issue.
im using workbench and have this:
-- Trigger DDL Statements
DELIMITER $$

USE `serendipity`$$

is that the one?

found this by right click the table:
send to sql editor and then insert sql statement
the it show me this:

INSERT INTO `serendipity`.`serendipity_entries`
(`id`,
`title`,
`timestamp`,
`body`,
`comments`,
`trackbacks`,
`extended`,
`exflag`,
`author`,
`authorid`,
`isdraft`,
`allow_comments`,
`last_modified`,
`moderate_comments`)
VALUES
(
{id: INT},
{title: VARCHAR},
{timestamp: INT UNSIGNED},
{body: TEXT},
{comments: INT UNSIGNED},
{trackbacks: INT UNSIGNED},
{extended: TEXT},
{exflag: INT},
{author: VARCHAR},
{authorid: INT},
{isdraft: ENUM},
{allow_comments: ENUM},
{last_modified: INT UNSIGNED},
{moderate_comments: ENUM}
);

kento
Regular
Posts: 31
Joined: Sun Mar 20, 2011 1:38 pm
Contact:

Re: Quicksearch, the used table doesn't support fulltext...

Post by kento » Wed Mar 23, 2011 9:17 am

ok timbalu :D
have opened the db with phpadmin and can se the tables of the blog in the structure label
then what? (havent used phpadmin before)

kento
Regular
Posts: 31
Joined: Sun Mar 20, 2011 1:38 pm
Contact:

Re: Quicksearch, the used table doesn't support fulltext...

Post by kento » Wed Mar 23, 2011 9:30 am

belive i made it :D
thanx again timbalu :D
you talked about i maby need to do this to other tables?

kento
Regular
Posts: 31
Joined: Sun Mar 20, 2011 1:38 pm
Contact:

Re: Quicksearch, the used table doesn't support fulltext...

Post by kento » Wed Mar 23, 2011 9:36 am

maby this need to be fixed so users dont need to change it manuly :D

User avatar
Timbalu
Regular
Posts: 4598
Joined: Sun May 02, 2004 3:04 pm

Re: Quicksearch, the used table doesn't support fulltext...

Post by Timbalu » Wed Mar 23, 2011 9:47 am

fixed it? Good!
By the way, good music. I love things like Anne Wylie (Deep Water)...
Regards,
Ian

Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian

kento
Regular
Posts: 31
Joined: Sun Mar 20, 2011 1:38 pm
Contact:

Re: Quicksearch, the used table doesn't support fulltext...

Post by kento » Wed Mar 23, 2011 10:01 am

Timbalu wrote:fixed it? Good!
By the way, good music. I love things like Anne Wylie (Deep Water)...
Surre is :D and there is alot more to lissen to ;-)

Timbalu, i have the user login plugin and tryed it, but the logout didn't work, is there a special url that need to be added in the logout in the plugin (the default dosn't seam to work propperly) ???

Must say, the more that is up and running the more i love using the blog "thumps up" for this blog system :D

Post Reply