ManagePermissions fails on clean install of SMF2.0 RC4

[Hekalite]

• Version(s) of SMF


• SMF 2.0 RC4
• Your Setup:


• List any Modifications you have installed
• List any Themes you have installed
• List any non-English Language packs you have installed
• Are you using UTF-8? yes
• Any other related information?
• Server Software:


• Apache/IIS version?:
not sure, hosted

• PHP version?:
5.2.15

• Database type and version:
postgres 8.1.22

• Any other related server information?
• Where the Error Occurred


• File: /Sources/ManagePermissions.php
• Line: 310
• Any relevant errors in the SMF error log (if so please post them)?:

Code Select Expand

http://****/index.php?action=admin;area=permissionsDatabase
Error: ERROR: function find_in_set(smallint, character varying) is not unique
HINT: Could not choose a best candidate function. You may need to add explicit type casts.File: ***/Sources/ManagePermissions.php
Line: 317


• How to Reproduce this Error?:

Attempting to access any of the permissions will generate the error.

• Additional Information?

There are two FIND_IN_SET functions declared, one which takes "needle" text, "haystack" text and the other which takes "needle" integer, "haystack" text.  id_group is smallint.  I made the error go away on my site by casting to integer.

[kat]

Already reported.

Thankyou, though!