Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[F] search does not work with postgresql
#1
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. 
Query:
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)


Messages In This Thread
[F] search does not work with postgresql - by Gibheer - 2008-09-03, 10:26 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)