Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[F] search does not work with postgresql
I have found a new bug with postgresql Rolleyes
In the file inc/function_search.php is a join, which does not work, because, a boolean can't be greater 0 on postgresql.
Lines: 462, 471, 478

If I change '> 0' into '= TRUE', I don't get the failuremessage, but I also don't get any records, only a message, which says, that nothing could be found.

MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
42883 - ERROR: operator does not exist: boolean > integer LINE 5: WHERE (','||parentlist||',' LIKE ',%0%,') > 0 AND act... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts. 
SELECT DISTINCT f.fid FROM zero_forums f LEFT JOIN zero_forumpermissions p ON (f.fid=p.fid AND p.gid='4') WHERE (','||parentlist||',' LIKE ',%0%,') > 0 AND active!=0 AND (p.fid IS NULL OR p.cansearch=1)
Thank you for your bug report.

This bug has been fixed in our internal code repository. Please note that the problem will not be fixed here until these forums are updated.

Forum Jump:

Users browsing this thread: 1 Guest(s)