[3.3][BETA] Private Message Search

[NeoDev]

Extension Name
PM Search

Extension Description
Enables users to perform private message searching using Sphinx (Manticore) search engine or MySQL full text

Extension Version
0.4.0 Beta

Requirements
phpBB 3.3.0+ (3.2 versions may work, untested)
Sphinx 2.1+ or MySQL 5.7+

Features

• Search by keyword
• Search by users
• Search within subject line or message text
• Search within folders
• Real time updates

Screenshots

sample1.png

GitHub
Neo-CTC/pm-search

Extension Download
pmsearch_0.4.0-beta.zip

Installation

1. Download extension to root/ext/ directory
2. Unzip file
3. Enable extension ACP -> Customise -> Extension Management
4. Adjust settings ACP -> Extensions -> PM Search -> Settings
5. Create the index for the active backend ACP -> Extensions -> PM Search -> Status

[NeoDev]

Updated extension to include recipient (aka sent to) searching.

v0.2.0a

[P_I]

Are you aware of the previous efforts in viewtopic.php?f=501&t=2263011?

Is Sphinx a requirement or will this extension support MySQL Fulltext and phpBB Native Fulltext backends?

I ask because for those running phpBB on shared hosting plans the Sphinx backend often isn't available based on my limited investigation.

[NeoDev]

Yes I've seen that extension. This one's similar but with more features.

At the moment only Sphinx is support as it is what I'm most familiar with. Once the feature set is stable, I'll be able to start adapting the code for other backends.

[P_I]

At the moment only Sphinx is support as it is what I'm most familiar with. Once the feature set is stable, I'll be able to start adapting the code for other backends.

Thanks. This functionality is notably absent from phpBB core code so I'm interested in your efforts, particularly once the other backends are supported.

[igorbond]

Code: Select all

Fatal error: Uncaught OutOfBoundsException: Package "ocramius/proxy-manager" is not installed in /var/www/southklad/data/www/southklad.ru/forum/ext/crosstimecafe/pmsearch/vendor/composer/InstalledVersions.php:188 Stack trace: #0 /var/www/southklad/data/www/southklad.ru/forum/vendor/composer/package-versions-deprecated/src/PackageVersions/Versions.php(112): Composer\InstalledVersions::getPrettyVersion('ocramius/proxy-...') #1 /var/www/southklad/data/www/southklad.ru/forum/vendor/ocramius/proxy-manager/src/ProxyManager/Version.php(52): PackageVersions\Versions::getVersion('ocramius/proxy-...') #2 /var/www/southklad/data/www/southklad.ru/forum/vendor/ocramius/proxy-manager/src/ProxyManager/Factory/AbstractBaseFactory.php(80): ProxyManager\Version::getVersion() #3 /var/www/southklad/data/www/southklad.ru/forum/vendor/ocramius/proxy-manager/src/ProxyManager/Factory/LazyLoadingValueHolderFactory.php(45): ProxyManager\Factory\AbstractBaseFactory->generateProxy('phpbb\\template\\...', Array) #4 /var/www/southklad/data/www/southkl in /var/www/southklad/data/www/southklad.ru/forum/ext/crosstimecafe/pmsearch/vendor/composer/InstalledVersions.php on line 188
Error 1: Uncaught OutOfBoundsException: Package "ocramius/proxy-manager" is not installed in /var/www/southklad/data/www/southklad.ru/forum/ext/crosstimecafe/pmsearch/vendor/composer/InstalledVersions.php:188 Stack trace: #0 /var/www/southklad/data/www/southklad.ru/forum/vendor/composer/package-versions-deprecated/src/PackageVersions/Versions.php(112): Composer\InstalledVersions::getPrettyVersion('ocramius/proxy-...') #1 /var/www/southklad/data/www/southklad.ru/forum/vendor/ocramius/proxy-manager/src/ProxyManager/Version.php(52): PackageVersions\Versions::getVersion('ocramius/proxy-...') #2 /var/www/southklad/data/www/southklad.ru/forum/vendor/ocramius/proxy-manager/src/ProxyManager/Factory/AbstractBaseFactory.php(80): ProxyManager\Version::getVersion() #3 /var/www/southklad/data/www/southklad.ru/forum/vendor/ocramius/proxy-manager/src/ProxyManager/Factory/LazyLoadingValueHolderFactory.php(45): ProxyManager\Factory\AbstractBaseFactory->generateProxy('phpbb\\template\\...', Array) #4 /var/www/southklad/data/www/southkl at file /var/www/southklad/data/www/southklad.ru/forum/ext/crosstimecafe/pmsearch/vendor/composer/InstalledVersions.php line 188

[NeoDev]

I do not know why you are receiving that error. The error does not occur when installing the extension on a fresh install of phpBB 3.3.5. Furthermore, this extension does not use the "ocramius/proxy-manager" package, nor are those words found inside any file of the extension. Most likely it is a problem with your install of phpBB, ask again in the support forums.

[NeoDev]

Updated to version 0.3a.

Added support for searching using MySQL.

[Midway]

Hi,

when I do a search in my private messages I get this error

Code: Select all

SQL ERROR [ mysqli ]

Can't find FULLTEXT index matching the column list [1191]

SQL

SELECT SQL_CALC_FOUND_ROWS p.msg_id id FROM phpbb_privmsgs p JOIN phpbb_privmsgs_to t ON p.msg_id = t.msg_id WHERE t.user_id = 2 AND MATCH(message_text,message_subject) AGAINST('+blah' IN BOOLEAN MODE) AND p.author_id = 2 AND MATCH(p.to_address) AGAINST("u_2") AND t.folder_id in (0) GROUP BY p.msg_id ORDER BY message_time DESC LIMIT 0,10

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1023
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 202
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 345
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/crosstimecafe/pmsearch/controller/ucp_controller.php
LINE: 355
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/crosstimecafe/pmsearch/ucp/main_module.php
LINE: 60
CALL: crosstimecafe\pmsearch\controller\ucp_controller->display_messages()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: crosstimecafe\pmsearch\ucp\main_module->main()

FILE: [ROOT]/ucp.php
LINE: 440
CALL: p_master->load_active()

[NeoDev]

You need to create the indexes or you started the creation process but it did not finish. Go to the Extensions panel > PM Search > Status. Under MySQL it should give the status as either Index missing or Index incomplete. Keep hitting the Rebuild search index button until it says it finished.

[3Di]

Just a note,
The SQL_CALC_FOUND_ROWS query modifier and accompanying FOUND_ROWS() function are deprecated as of MySQL 8.0.17.
https://dev.mysql.com/doc/refman/8.0/en ... found-rows
Oh, btw.. are you the same kevinwalter as of viewtopic.php?p=15779661#p15779661 ?

[[Dimetrodon]]

On my test bench, I get an AJAX error service unavailable when trying to build a MySQL index.

[NeoDev]

It's some problem with the MySQL side of extension sending an error at same time as the AJAX request. Might be related to phpbb debugging if enabled. The MySQL functionality is less tested than the Sphinx search functions. I'll need to revisit the MySQL functions.

[isay]

Dear Neo,
Thank you for your work. The following error in all my searches:

Code: Select all

Problem connecting to search engine

Any help?
Best regards.

phpBB: v3.3.8
MySQL: v5.7.23
Theme: Prosilver
Another Extension: None

[[Dimetrodon]]

Hey isay,

I do not think you should be using this on a live board, especially since this is in [Alpha]. It's in its very early stages.