social icon indicating copy to clipboard operation
social copied to clipboard

boolean = integer "oc_social_3_follow" fs.accepted on PostgreSQL

Open genofire opened this issue 4 years ago • 0 comments

Describe the bug A clear and concise description of what the bug is.

To Reproduce Steps to reproduce the behavior:

  1. Go to https://example.org/apps/social/timeline
  2. See error: Notification Failed to load more timeline entries✖

Expected behavior A clear and concise description of what you expected to happen.

Screenshots If applicable, add screenshots to help explain your problem.

Client details:

  • OS: [e.g. Linux]
  • Browser Firefox
  • Version [e.g. 22]
  • Device: desktop
Server details **Social app version:** 0.4.2

Operating system: Linux

Web server: Nginx

Database: postgres (PostgreSQL) 13.2

PHP version: 7.4.18-1

Nextcloud version: (see Nextcloud admin page) 21.0.2

Logs

Nextcloud log (data/nextcloud.log)

Equal to Browser log with b)

Browser log

a) The javascript console log b) The network log

{
    "status":-1,"exception":"Doctrine\\DBAL\\Exception\\DriverException",
    "message":"An exception occurred while executing a query: SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer\nLINE 1: ...OIN \"oc_social_3_follow\" \"fs\" ON (\"fs\".\"accepted\" = $2) AND ...\n                                                             ^\nHINT:  No operator matches the given name and argument types. You might need to add explicit type casts."
}

c) ...

genofire avatar Jun 25 '21 09:06 genofire