Looking for help: no_external_url query returns no results

[GeorgeHahn]

I'm having trouble with the no_external_url:true query. It returns no results on my instance. This operator appears to be working correctly on the demo instance.

This is a poor bug report. Can you recommend any ways I could investigate further?

---

Debug information generated at 2022-03-08 21:15:11 America/Chicago for Firefly III version 5.6.16.

Scope	Version
Firefly III	5.6.16
Firefly III API	1.5.5
Build	113, 02-03-2022 19:39:22 CET
PHP	8.0.16
Host	Linux

System info	Value
Using docker?	true
Layout
System TZ	America/...
Browser TZ	America/...
App environment	local
App debug mode	false
App cache driver	file
App logging	debug, stack
Display errors	Off
Error reporting	ALL errors
Interface	apache2handler
Default language	en_US
Default locale	equal
BCscale	24
DB drivers	mysql, pgsql, sqlite
Current driver	pgsql
DB version	18 (exp. 18)
Login provider	eloquent
Trusted proxies (.env)

User info	Value
Session start	2022-03-01 00:00:00
Session end	2022-03-31 23:59:59
Session first	2018-03-30 00:00:00
User ID	1
User language	en_US
User locale	en_US
Attempt at "en_US.utf8"	'en_US.utf8'
Attempt at "en_US.UTF-8"	'en_US.UTF-8'

No url:

[2022-03-08 21:16:53] local.DEBUG: Constructed OperatorQuerySearch  
[2022-03-08 21:16:53] local.DEBUG: GroupCollector: The limit is now 50  
[2022-03-08 21:16:53] local.DEBUG: Now in parseQuery(no_external_url:true)  
[2022-03-08 21:16:53] local.DEBUG: Found 1 node(s)  
[2022-03-08 21:16:53] local.DEBUG: Now in handleSearchNode(Gdbots\QueryParser\Node\Field)  
[2022-03-08 21:16:53] local.DEBUG: Now handle Node class Gdbots\QueryParser\Node\Field  
[2022-03-08 21:16:53] local.DEBUG: Now in updateCollector("no_external_url", "true")  
[2022-03-08 21:16:53] local.DEBUG: "no_external_url" is not an alias.  
[2022-03-08 21:16:53] local.DEBUG: "no_external_url" is not an alias.  
[2022-03-08 21:16:53] local.DEBUG: Added operator type "no_external_url"  
[2022-03-08 21:16:54] local.DEBUG: Constructed OperatorQuerySearch  
[2022-03-08 21:16:54] local.DEBUG: GroupCollector: The limit is now 50  
[2022-03-08 21:16:54] local.DEBUG: Now in parseQuery(no_external_url:true)  
[2022-03-08 21:16:54] local.DEBUG: Found 1 node(s)  
[2022-03-08 21:16:54] local.DEBUG: Now in handleSearchNode(Gdbots\QueryParser\Node\Field)  
[2022-03-08 21:16:54] local.DEBUG: Now handle Node class Gdbots\QueryParser\Node\Field  
[2022-03-08 21:16:54] local.DEBUG: Now in updateCollector("no_external_url", "true")  
[2022-03-08 21:16:54] local.DEBUG: "no_external_url" is not an alias.  
[2022-03-08 21:16:54] local.DEBUG: "no_external_url" is not an alias.  
[2022-03-08 21:16:54] local.DEBUG: Added operator type "no_external_url"  
[2022-03-08 21:16:54] local.DEBUG: GroupCollector: page is now 1  
[2022-03-08 21:16:56] local.DEBUG: Trying to set en_US.utf8  
[2022-03-08 21:16:56] local.DEBUG: Trying to set en_US.UTF-8  

Any url:

[2022-03-08 21:27:09] local.DEBUG: Constructed OperatorQuerySearch  
[2022-03-08 21:27:09] local.DEBUG: GroupCollector: The limit is now 50  
[2022-03-08 21:27:09] local.DEBUG: Now in parseQuery(any_external_url:true)  
[2022-03-08 21:27:09] local.DEBUG: Found 1 node(s)  
[2022-03-08 21:27:09] local.DEBUG: Now in handleSearchNode(Gdbots\QueryParser\Node\Field)  
[2022-03-08 21:27:09] local.DEBUG: Now handle Node class Gdbots\QueryParser\Node\Field  
[2022-03-08 21:27:09] local.DEBUG: Now in updateCollector("any_external_url", "true")  
[2022-03-08 21:27:09] local.DEBUG: "any_external_url" is not an alias.  
[2022-03-08 21:27:09] local.DEBUG: "any_external_url" is not an alias.  
[2022-03-08 21:27:09] local.DEBUG: Added operator type "any_external_url"  
[2022-03-08 21:27:10] local.DEBUG: Constructed OperatorQuerySearch  
[2022-03-08 21:27:10] local.DEBUG: GroupCollector: The limit is now 50  
[2022-03-08 21:27:10] local.DEBUG: Now in parseQuery(any_external_url:true)  
[2022-03-08 21:27:10] local.DEBUG: Found 1 node(s)  
[2022-03-08 21:27:10] local.DEBUG: Now in handleSearchNode(Gdbots\QueryParser\Node\Field)  
[2022-03-08 21:27:10] local.DEBUG: Now handle Node class Gdbots\QueryParser\Node\Field  
[2022-03-08 21:27:10] local.DEBUG: Now in updateCollector("any_external_url", "true")  
[2022-03-08 21:27:10] local.DEBUG: "any_external_url" is not an alias.  
[2022-03-08 21:27:10] local.DEBUG: "any_external_url" is not an alias.  
[2022-03-08 21:27:10] local.DEBUG: Added operator type "any_external_url"  
[2022-03-08 21:27:10] local.DEBUG: GroupCollector: page is now 1  
[2022-03-08 21:27:12] local.DEBUG: Trying to set en_US.utf8  
[2022-03-08 21:27:12] local.DEBUG: Trying to set en_US.UTF-8  

[JC5]

It could be that the fields are still called external_uri in your database. I tested a routine to fix this, but that might be the problem. Could you check this in table journal_meta?

[GeorgeHahn]

Interesting, I don't have any journal_meta entries named external_uri or external_url

[JC5]

Weird, because that's where external URL's are supposed to end up. You have other meta entries in that table, I presume?

[GeorgeHahn]

I do. There are a bunch of external IDs and import related entries.

[JC5]

Found the bug, I'll pick it up on my side.