Bug Report for TypeSense

[Marc]

Since upgrading to v11 I would periodically see the following error pop up randomly.

At first I thought it was something to do with v11 after upgrading but it turns out it is the TypeSense plugin. I realize it's unstable but figured I'd report my findings here to help the devs.

It would periodically pop up for me as an admin but it turns out other usergroups would get it all the time during a search. So it sometimes works for admin but doesn't work at all for other usergroups, at least on my Ubuntu 26.04 system.

[Jim Kirkpatrick]

Marc,

If you put:

# Error checking

$show_detailed_errors=true;

.. in your config.php, it will display more information below “Sorry, an error has occurred”. It’s often useful in figuring where the issue is.

Jim

--
ResourceSpace: Open Source Digital Asset Management
http://www.resourcespace.com
---
You received this message because you are subscribed to the Google Groups "ResourceSpace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to resourcespac...@googlegroups.com.
To view this discussion, visit https://groups.google.com/d/msgid/resourcespace/485617df-411c-4dec-ba9a-b3a87b7a30ecn%40googlegroups.com.

[Marc]

Thanks for that. The error generated is as follow:

#0 /var/www/html/include/database_functions.php(510): errorhandler(1, '...', '...', 296) #1 /var/www/html/include/database_functions.php(496): ps_query('...', Array, '', -1, false, 2, true, false) #2 /var/www/html/plugins/typesense_search/include/typesense_search_functions.php(296): ps_query('...', Array) #3 /var/www/html/plugins/typesense_search/include/typesense_search_functions.php(80): typesense_search_hydrate_refs(Array, 98, Array, false, Object(PreparedStatementQuery), '...') #4 /var/www/html/plugins/typesense_search/hooks/all.php(73): typesense_search_do_search('...', '...', Array, Array, false, Object(PreparedStatementQuery), '...', '...') #5 /var/www/html/include/general_functions.php(3689): HookTypesense_searchAllExternal_search('...', Array, Array, Array, '...', '...', Array, Array, '...', false, false, false, '', false, false, false, NULL, false, Object(PreparedStatementQuery), Object(PreparedStatementQuery), Object(PreparedStatementQuery)) #6 /var/www/html/include/general_functions.php(3765): hook('...', '...', Array, false) #7 /var/www/html/include/do_search.php(351): hook('...', '...', Array) #8 /var/www/html/pages/search.php(609): do_search('...', '...', '...', Array, Array, '...', false, 0, false, false, '', '', true, false, false, false, NULL, false, true) /var/www/html/plugins/typesense_search/include/typesense_search_functions.php line 296: Bad prepared SQL statement: SELECT r.hit_count score, r.ref, r.resource_type, r.has_image, r.is_transcoding, r.creation_date, r.rating, r.user_rating, r.user_rating_count, r.user_rating_total, r.file_extension, r.preview_extension, r.image_red, r.image_green, r.image_blue, r.thumb_width, r.thumb_height, r.archive, r.access, r.colour_key, r.created_by, r.file_modified, r.file_checksum, r.request_count, r.new_hit_count, r.expiry_notification_sent, r.preview_tweaks, r.file_path, r.modified, r.file_...(TRUNCATED TEXT)...8575,"i",78574,"i",78573,"i",78572,"i",78571,"i",78570,"i",78569,"i",78568,"i",78567,"i",78566,"i",78565,"i",78564,"i",78563,"i",78562,"i",78561,"i",78560,"i",78559,"i",78558,"i",78557,"i",78556,"i",78555,"i",78554,"i",78553,"i",78552,"i",78551,"i",78550,"i",78549,"i",78548,"i",78547,"i",51614,"i",46525,"i",46524,"i",46523,"i",46522,"i",28599,"i",11264,"i",6192,"i",6191,"i",6190,"i",6189,"i",6188,"i",6187,"i",6186,"i",6185,"i",6184,"i",6183,"i",6182] - Unknown column 'rca.access' in 'field list'