Got Error when do search

[kopox]

i got this error when using search function

Fatal error [400]: SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list
Triggered in /app/lib/classes/class.listing.php at line 219

Stack trace:
#0 /app/routes/route.user.php(236): CHV\Listing->exec()
#1 /lib/G/classes/class.handler.php(206): G\Handler->{closure}(G\Handler)
#2 /lib/G/classes/class.handler.php(110): G\Handler->processRequest()
#3 /app/loader.php(256): G\Handler->__construct(Array)
#4 /index.php(20): include_once('/app/loader.php')

 

[Rodolfo]

Did you run /install ?

 

[kopox]

pardon?

you can check on my website

http://g.jualanposter.com/jualposter

when you do seacrh function that below "3486 images | 107 albums", i got that error i mentioned earlier. but if you do search that located in above menu beside "explorer" it will do just fine.

 

[Rodolfo]

Seems to be a bug in the system, I will check it out.

 

[Rodolfo]

Is just a small error in app/routes/route.user.php

Replace this:

$where = $user["search"]["type"] == "images" ? "WHERE image_user_id=:user_id AND MATCH(image_name, image_description, image_original_filename) AGAINST(:q)" : "WHERE album_user_id=:user_id AND MATCH(album_name) AGAINST(:q)";

With this:

$where = $user["search"]["type"] == "images" ? "WHERE image_user_id=:user_id AND MATCH(image_name, image_title, image_description, image_original_filename) AGAINST(:q)" : "WHERE album_user_id=:user_id AND MATCH(album_name) AGAINST(:q)";

This patch will be included in 3.5.12

 

[kopox]

thank you. it's working now.