2008-09-03, 10:26 AM
I have found a new bug with postgresql 
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.
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)