SMF Support > PostgreSQL and SQLite Support

Problem with Membergroups & Permissions

(1/2) > >>

ChaosX128:
Hi I just successfully installed this software on my site (ver 2.0.2).  I'm using PostgreSQL

I'm still trying to figure out how to set up everything the way I want it and have encounter 2 problems so far in regards to errors.

The first error occurs in the "Forum » Administration Center » Membergroups » Edit Membergroups" section.

I can add Membergroups and see them listed, but whenever I go to the Edit Membergroups I get this error:


--- Quote ---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: /home/chaosxfo/public_html/forum/Sources/Subs-Membergroups.php
Line: 736
--- End quote ---

No idea what to do there...

2nd error occurs in the "Forum » Administration Center » Permissions » General Permissions" section.

I get the error:


--- Quote ---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: /home/chaosxfo/public_html/forum/Sources/ManagePermissions.php
Line: 306
--- End quote ---

No idea what to do here either.

If anyone could please help or explain to me why or what these errors mean, I'd really appreciate it.

Thanks.

emanuele:
Hello ChaosX128 and welcome to sm.org! :)

find_in_set is a custom function created by SMF during the install.
Two find_in_set functions are created for two different type of data (string and integers).

What version of postgre are you using?

ChaosX128:

--- Quote from: emanuele on March 01, 2012, 03:44:47 PM ---Hello ChaosX128 and welcome to sm.org! :)

find_in_set is a custom function created by SMF during the install.
Two find_in_set functions are created for two different type of data (string and integers).

What version of postgre are you using?

--- End quote ---

It says version 8.1.23 on the phpPgAdmin page.

Oldiesmann:
If you go into phpPgAdmin and view the functions for that particular database, how many different "find_in_set" functions do you see listed?

There should only be two - one for "integer, character varying" and one for "text, text".

ChaosX128:
I wasn't sure exactly how to fix this problem... It only had two functions listed with the name "find_in_set" as you described.

However, I just reinstalled using mySQL instead and it works fine now.

Maybe a problem with the way I set up the PostgreSQL, idk...  :-\

Navigation

[0] Message Index

[#] Next page