Empty Auto-Contribute and Tipping sections in brave://rewards

[fmarier]

Description

The Auto-Contribute and Tipping sections of brave://rewards are empty in my profile.

even though I just tipped my blog to test this out.

Brave version (brave://version info)

Brave | 0.68.142 Chromium: 77.0.3865.90 (Official Build) (64-bit)
Revision | 58c425ba843df2918d9d4b409331972646c393dd-refs/branch-heads/3865@{#830}
OS | Linux

Version/Channel Information:

• Can you reproduce this issue with the current release?
• Can you reproduce this issue with the beta channel?
• Can you reproduce this issue with the dev channel?
• Can you reproduce this issue with the nightly channel?

[fmarier]

I see a lot of sqlite errors when I start Brave:

[8797:8823:1002/133123.376848:ERROR:database.cc(1598)] publisher_info_db sqlite error 1, errno 0: no such column: pi.verified, sql: SELECT pi.publisher_id, pi.name, pi.url, pi.favIcon, pi.provider, pi.verified, pi.excluded, (SELECT IFNULL(percent, 0) FROM activity_info WHERE publisher_id = ? AND reconcile_stamp = ? ) as percent FROM publisher_info AS pi WHERE pi.publisher_id = ? LIMIT 1
[8797:8823:1002/133123.377250:ERROR:database.cc(1598)] publisher_info_db sqlite error 1, errno 0: table publisher_info has no column named verified, sql: INSERT OR REPLACE INTO publisher_info (publisher_id, verified, excluded, name, url, provider, favIcon) VALUES (?, ?, ?, ?, ?, ?, (SELECT IFNULL( (SELECT favicon FROM publisher_info WHERE publisher_id = ?), "")))
[8797:8823:1002/133123.377642:ERROR:database.cc(1598)] publisher_info_db sqlite error 1, errno 0: no such column: pi.verified, sql: SELECT ai.publisher_id, ai.duration, ai.score, ai.percent, ai.weight, pi.verified, pi.excluded, pi.name, pi.url, pi.provider, pi.favIcon, ai.reconcile_stamp, ai.visits FROM activity_info AS ai INNER JOIN publisher_info AS pi ON ai.publisher_id = pi.publisher_id WHERE 1 = 1 AND ai.reconcile_stamp = ? AND ai.duration >= ? AND pi.excluded != ? AND ai.visits >= ?
[8797:8823:1002/133123.377991:ERROR:database.cc(1598)] publisher_info_db sqlite error 1, errno 0: no such column: verified, sql: SELECT publisher_id, name, url, favIcon, provider, verified, excluded FROM publisher_info WHERE publisher_id=?

[NejcZdovc]

@fmarier did you maybe moved from versions to version (back and forward). We changed verified field to status and I see that you are still querying for verified field where db has status

[fmarier]

Good question, that's possible.

In any case, the sites are back, so it's not an issue in my browser profile anymore.