History for Opera browser (on MacOS 13.5) does not seem to refresh

Hello,

I ran some maintenance scripts on Onyx for Mac OS 13.5 and now the history pull-up for this extension does not seem to be refreshing anymore. I've tried uninstalling and reinstalling the extension in Alfred and it does not seem to work. Is there a way to clear the cache for this extension? What else can I do to fix this?

e.g Here is the history in Opera

Here is the history pull up in Alfred

can you provide me with the debug log output when executing the workflow before you see the SQL query? In the log output, you can see which history files were being found. The cache dir is also logged in the output.

Here is what I see in the debugger when I invoke the history -> "h".

--- start --- [09:41:12.781] Logging Started... [09:41:17.353] Chromium Bookmarks and History Search[Script Filter] Queuing argument '' [09:41:18.422] Chromium Bookmarks and History Search[Script Filter] Script with argv '' finished [09:41:18.427] STDERR: Chromium Bookmarks and History Search[Script Filter] Cache Dir: /Users/mittala/Library/Caches/com.runningwithcrayons.Alfred/Workflow Data/com.apple.alfred.workflow.chromium-hist Data Dir: /Users/mittala/Library/Application Support/Alfred/Workflow Data/com.apple.alfred.workflow.chromium-hist PYTHON VERSION: 3.9.6 (default, May 7 2023, 23:32:44) [Clang 14.0.3 (clang-1403.0.22.14.1)] /Users/mittala/Library/Application Support/com.operasoftware.Opera/History → found

                SELECT DISTINCT urls.url, urls.title, urls.visit_count, (urls.last_visit_time/1000000 + (strftime('%s', '1601-01-01')))
                FROM urls, visits
                WHERE urls.id = visits.url AND
                urls.title IS NOT NULL AND
                urls.title != '' order by last_visit_time DESC;

Ok, all looks good.

I don't know what your Onyx script is doing, but the history data is not cached, means what Alfred returns is available in History. Did you delete History in Opera and try again?

So I just cleared ALL history on my browser and here is a disconnect.

Opera with cleared history.

Alfred w/ Chromium

Here is the debug info.

[07:30:42.249] Logging Started... [07:30:46.377] Chromium Bookmarks and History Search[Script Filter] Queuing argument '' [07:30:47.192] Chromium Bookmarks and History Search[Script Filter] Script with argv '' finished [07:30:47.198] STDERR: Chromium Bookmarks and History Search[Script Filter] Cache Dir: /Users/mittala/Library/Caches/com.runningwithcrayons.Alfred/Workflow Data/com.apple.alfred.workflow.chromium-hist Data Dir: /Users/mittala/Library/Application Support/Alfred/Workflow Data/com.apple.alfred.workflow.chromium-hist PYTHON VERSION: 3.9.6 (default, May 7 2023, 23:32:44) [Clang 14.0.3 (clang-1403.0.22.14.1)] /Users/mittala/Library/Application Support/com.operasoftware.Opera/History → found

                SELECT DISTINCT urls.url, urls.title, urls.visit_count, (urls.last_visit_time/1000000 + (strftime('%s', '1601-01-01')))
                FROM urls, visits
                WHERE urls.id = visits.url AND
                urls.title IS NOT NULL AND
                urls.title != '' order by last_visit_time DESC;

And all the results above are quite old and out-of-date.

Here are the Opera settings.

I'd appreciate any guidance you can provide to "reset" everything. Clearly there is some caching at play here.

Thanks for an otherwise extremely useful extension. It's a big part of my daily workflow.

Yes, I did exactly that as part of the history cleanup. Still the issue persists. It is quite confounding.

Did you create a profile an delete only the profile history?

Acidham / chromium-hist-bookmarks

History for Opera browser (on MacOS 13.5) does not seem to refresh #31