iOS App not showing Passwords - "database execution statement failed"

Installation Issues
1

PB: Latest-Pro (4.9.1) (Docker)
iOS: 17.5.1
App: 1.19.0

Issue: After setting up the account via QR-Code on the iPhone the app shows no items.
When trying to refresh the following error is shown: “database execution statement failed”

Passbolt itself is working fine.

Anyone got an Idea on that?

Thanks!

2

Hello @plutzo :slight_smile:

We’ve seen similar issues on iOS, please could you run the cleanup shell script?

  • sudo su -s /bin/bash -c "/usr/share/php/passbolt/bin/cake passbolt cleanup" www-data
    • If you are on a RPM distribution, please replace www-data with nginx

Also, since you are a PRO customer, in the future you can definitely create a dedicated ticket through our contact form.

Best regards

3

@antony Thanks for the cleanup advice. Works like a charm now.

Posted it here so if others face this issue, they get the solution right here :slight_smile:

3 Likes
4

Good Morning,
i have the same problem since yesterday.
Cleanup dont work. I get the message “No issue found, data looks squeaky clean!”

iPadOS & iOS 18.2
Passbolt App 1.20.0
Passbolt 4.10.0

[2024-11-21 21:09:50] ⚠️ DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:138
⮑ "path": 138
⮑ "file": Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:135
⮑ "path": 135
⮑ "file": Database/SQLiteConnectionHandle.swift

Do you have any idea?

5

Hello,
I have the exact same problem everything works fine on the web / browser extension version but I have this message on iOS. And I can’t get any password.

The command “cake passbolt cleanup” responded with : “No issue found, data looks squeaky clean!” so there is no issue. And it didn’t work after the command.
I completely deleted the iOS app and installed it again, but it didn’t work either.

Regards

6

We also have this problem since installing the latest update.

Passbolt Server: 4.10.0
OS: 18.1.1
App: 1.20.0

The error on the iOS App is:
[2024-11-22 16:23:37] …resources data refresh failed!
[2024-11-22 16:23:37] :warning: DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:138
⮑ “path”: 138
⮑ “file”: Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:135
⮑ “path”: 135
⮑ “file”: Database/SQLiteConnectionHandle.swift
[2024-11-22 16:23:37] :warning: DatabaseIssue
DiagnosticsContext:
•DatabaseStatementExecutionFailure Database/SQLiteConnectionHandle.swift:138
⮑ “path”: 138
⮑ “file”: Database/SQLiteConnectionHandle.swift
•DatabaseIssue Database/SQLiteConnectionHandle.swift:135
⮑ “path”: 135
⮑ “file”: Database/SQLiteConnectionHandle.swift

cleanup does not work and we also tried to newly setup the account in the app as well as reinstalling the app which also did not help.

7

it happens for me after the 4.10.0 update as well.

8

Hey there, here’s the fix you can use: https://community.passbolt.com/t/there-was-an-error-updating-the-data-on-app-android-and-passbolt-ce/11436/3?u=ishan

Thanks for bringing it to our attention.

1 Like
9

I applied the fix and I can confirm it works:

DELETE FROM resource_types WHERE slug IN ('v5-default', 'v5-totp-standalone', 'v5-password-string', 'v5-default-with-totp');
1 Like
10

thank you, it worked !

regards

1 Like