Fulltextsearch upgrade fails 27.0.1 -> 27.1.4

[traxeon]

Current version: 27.0.1
Target version: 27.1.4
Running ./occ upgrade creates error:

An unhandled exception has been thrown:
Error: Call to a member function closeCursor() on null in /var/www/nextcloud/apps/fulltextsearch/lib/Migration/Version2801Date202309200001.php:91
Stack trace:
#0 /var/www/nextcloud/lib/private/DB/MigrationService.php(545): OCA\FullTextSearch\Migration\Version2801Date202309200001->postSchemaChange()
#1 /var/www/nextcloud/lib/private/DB/MigrationService.php(418): OC\DB\MigrationService->executeStep()
#2 /var/www/nextcloud/lib/private/Installer.php(154): OC\DB\MigrationService->migrate()
#3 /var/www/nextcloud/core/Command/App/Enable.php(111): OC\Installer->installApp()
#4 /var/www/nextcloud/core/Command/App/Enable.php(81): OC\Core\Command\App\Enable->enableApp()
#5 /var/www/nextcloud/3rdparty/symfony/console/Command/Command.php(298): OC\Core\Command\App\Enable->execute()
#6 /var/www/nextcloud/3rdparty/symfony/console/Application.php(1040): Symfony\Component\Console\Command\Command->run()
#7 /var/www/nextcloud/3rdparty/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#8 /var/www/nextcloud/3rdparty/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#9 /var/www/nextcloud/lib/private/Console/Application.php(211): Symfony\Component\Console\Application->run()
#10 /var/www/nextcloud/console.php(100): OC\Console\Application->run()
#11 /var/www/nextcloud/occ(11): require_once('...')
#12 {main}disco@flex:/var/www/nextcloud$

[traxeon]

This is preventing the upgrade from completing and leaving Nextcloud in a state of disrepair and will not start.

[ggallizia-AREA]

I have the same issue updating from 27.0.1 to 27.1.4. At the moment the only way I've found to complete the update is disabling fulltextsearch as a workaround via occ:

php occ app:disable fulltextsearch
php occ upgrade -v
php occ maintenance:mode --off

[traxeon]

Thank you. This work around at least has my instance running, but without the search index enabled.

I did try to:

sudo -u www-data php occ app:install fulltextsearch
sudo -u www-data php occ app:enable fulltextsearch

But I get the same error on enable.

[chrissi5120]

same result

[jacotec]

Commenting out the line which causes the error in ..\apps\fulltextsearch\lib\Migration\Version2801Date202309200001.php let me activate the app again, index is currently running ... hopefully it works afterwards.

// $result->closeCursor();

[small1]

This is still if you go to 28.

[traxeon]

Commenting out the line which causes the error in ..\apps\fulltextsearch\lib\Migration\Version2801Date202309200001.php let me activate the app again, index is currently running ... hopefully it works afterwards.

// $result->closeCursor();

Thanks. Let me know how the results. It'd be interesting to know what this line of code is supposed to do.

[traxeon]

I tried to do the following:

(in database - preserve tables in db)

RENAME TABLE `oc_fulltextsearch_indexes` to `oc_fulltextsearch_indexes_20231213_1556`;
RENAME TABLE `oc_fulltextsearch_index` to `oc_fulltextsearch_index_20231213_1556`;
RENAME TABLE `oc_fulltextsearch_ticks` to `oc_fulltextsearch_ticks_20231213_1556`;

(in terminal - remove the app)

sudo -u www-data php occ app:disable fulltextsearch
sudo -u www-data php occ app:remove fulltextsearch

(in database - this lets the installer reinstall the tables)

DELETE FROM oc_migrations WHERE app='fulltextsearch';
DELETE FROM oc_preferences WHERE appid='fulltextsearch';

(in terminal - reinstall the app; this does create the tables again)

sudo -u www-data php occ app:install fulltextsearch

So moving the tables out of the way and recreating them did not work either. I get another closeCursor() error when enabling the re-install.

[Tab3r]

Commenting out the line which causes the error in ..\apps\fulltextsearch\lib\Migration\Version2801Date202309200001.php let me activate the app again, index is currently running ... hopefully it works afterwards.

// $result->closeCursor();

This allow me to enable again the "fullsearchtext" app, but this is only a workaround...

[hschoepel]

Hello,

I confirm that i also have the exact same issue. The workaround does not work for me !

I get the error 'Error: This app cannot be enabled because it makes the server unstable'. I have to disable the app via cli else the website won't come up anymore.

","app":"PHP","method":"GET","url":"/index.php/login","message":"Declaration of OCA\Bookmarks_FullTextSearch\Provider\BookmarksProvider::generateIndexableDocuments(string $userId): array must be compatible with OCP\FullTextSearch\IFullTextSearchProvider::generateIndexableDocuments(string $userId, string $chunk): array at /var/www/html/nextcloud/apps/bookmarks_fulltextsearch/lib/Provider/BookmarksProvider.php#272",

I have to roll back to get it working again :/

Greetings,
Henrik

[yoru74]

I had the same problem going from 27.0.0 to 28.0.1. Better than commenting the line, you can move it 2 lines above, inside the "catch" block that is where it belongs (if there is no catch, $results is never initialized).

Otherwise the app is working for me.

[traxeon]

Is this code maintained? I noticed nothing has been done with it yet.

[zeigerpuppy]

Strangely, I am still getting this error when I try to enable fulltextsearch in NC 27.1.8

sudo -u www-data php /var/www/nextcloud/occ app:enable fulltextsearch
An unhandled exception has been thrown:
Error: Call to a member function closeCursor() on null in /var/www/nextcloud/apps/fulltextsearch/lib/Migration/Version2801Date202309200001.php:91
Stack trace:
#0 /var/www/nextcloud/lib/private/DB/MigrationService.php(543): OCA\FullTextSearch\Migration\Version2801Date202309200001->postSchemaChange()
#1 /var/www/nextcloud/lib/private/DB/MigrationService.php(418): OC\DB\MigrationService->executeStep()
#2 /var/www/nextcloud/lib/private/Installer.php(154): OC\DB\MigrationService->migrate()
#3 /var/www/nextcloud/core/Command/App/Enable.php(111): OC\Installer->installApp()
#4 /var/www/nextcloud/core/Command/App/Enable.php(81): OC\Core\Command\App\Enable->enableApp()
#5 /var/www/nextcloud/3rdparty/symfony/console/Command/Command.php(298): OC\Core\Command\App\Enable->execute()
#6 /var/www/nextcloud/3rdparty/symfony/console/Application.php(1040): Symfony\Component\Console\Command\Command->run()
#7 /var/www/nextcloud/3rdparty/symfony/console/Application.php(301): Symfony\Component\Console\Application->doRunCommand()
#8 /var/www/nextcloud/3rdparty/symfony/console/Application.php(171): Symfony\Component\Console\Application->doRun()
#9 /var/www/nextcloud/lib/private/Console/Application.php(218): Symfony\Component\Console\Application->run()
#10 /var/www/nextcloud/console.php(100): OC\Console\Application->run()
#11 /var/www/nextcloud/occ(11): require_once('...')