🌍
English
I just upgraded to 2.9.0RC1 from 2.9.0beta2 by just unzipping the latest archive over my existing folder. Site is working, but when I try to do a search, I get this error:
Piwigo encountered an unrecoverable error. [mysql error 1146] Table 'piwigo-beta.piwigo_user_cache_categories' doesn't exist SELECT * FROM categories INNER JOIN piwigo_user_cache_categories ON id = cat_id and user_id = 1 WHERE (name REGEXP '[[:<:]]lhs[[:>:]]' OR comment REGEXP '[[:<:]]lhs[[:>:]]' OR name REGEXP '[[:<:]]lh[[:>:]]' OR comment REGEXP '[[:<:]]lh[[:>:]]') #1 my_error /usr/local/piwigo-beta/include/dblayer/functions_mysqli.inc.php(147) #2 pwg_query /usr/local/piwigo-beta/include/functions_search.inc.php(1148) #3 qsearch_get_categories /usr/local/piwigo-beta/include/functions_search.inc.php(1390) #4 get_quick_search_results_no_cache /usr/local/piwigo-beta/include/functions_search.inc.php(1307) #5 get_quick_search_results /usr/local/piwigo-beta/include/functions_search.inc.php(1480) #6 get_search_results /usr/local/piwigo-beta/include/section_init.inc.php(356) #7 include /usr/local/piwigo-beta/index.php(27)
In my database, the table name is 'user_cache_categories' not 'piwigo_user_cache_categories' (none of my tables start with 'piwigo_').
This only seems to affect quick search from the menu. Searching from the search page seems to work fine.
Filed: [Github] Piwigo issue #647.
Last edited by windracer (2017-04-04 02:44:29)
Offline
Found the problem ... this incorrect table name is in include/functions_search.inc.php. I fixed that in my installation and quick search started working again.
Offline