[F] mybb1.4.2 and PostgreSQL

[kvikkjokk]

Anyone successfully using mybb1.4.2 (or previous 1.4.x versions) together with Postgres ? I'm using Postgres 8.2.3 and successfully installed mybb1.4.2. I can log in as admin. Unfortunately I get a lot of SQL errors while performing various tasks. Examples:

Register a new user
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
0 - ERROR: relation "mybb_userfields_ufid_seq" does not exist
Query:
SELECT currval('mybb_userfields_ufid_seq') AS last_value

Create a new group

SQL Error:
0 - ERROR: invalid input syntax for integer: ""
Query:
SELECT g.gid, COUNT(u.uid) AS users FROM mybb_users u LEFT JOIN mybb_usergroups g ON (','|| u.additionalgroups|| ',' LIKE '%,'|| g.gid|| ',%') WHERE g.gid != '' GROUP BY g.gid


Save a new group
SQL Error:
0 - ERROR: invalid input syntax for integer: ""
Query:
UPDATE mybb_usergroups SET type='2', title='SCO Staff', description='', namestyle='{username}', usertitle='', stars='0', starimage='images/star.gif', image='', isbannedgroup='0', canview='1', canviewthreads='1', canviewprofiles='1', candlattachments='1', canpostthreads='1', canpostreplys='1', canpostattachments='1', canratethreads='1', caneditposts='1', candeleteposts='1', candeletethreads='1', caneditattachments='1', canpostpolls='1', canvotepolls='1', canusepms='1', cansendpms='1', cantrackpms='1', candenypmreceipts='1', pmquota='100', maxpmrecipients='5', cansendemail='1', maxemails='4', canviewmemberlist='1', canviewcalendar='1', canaddevents='1', canbypasseventmod='0', canmoderateevents='0', canviewonline='1', canviewwolinvis='0', canviewonlineips='0', cancp='0', issupermod='0', cansearch='1', canusercp='1', canuploadavatars='1', canchangename='0', showforumteam='0', usereputationsystem='1', cangivereputations='1', reputationpower='1', maxreputationsday='5', attachquota='5000', cancustomtitle='0', canwarnusers='0', canreceivewarnings='1', maxwarningsday='0', canmodcp='0', candisplaygroup='' WHERE gid='8'

Anyone can help here ?

Thanks[/b]

[MattRogowski]

What is postgres?? And what plugins do you have installed??

[kvikkjokk]

(10-16-2008 03:18 PM)Matt_ Wrote:  What is postgres?? And what plugins do you have installed??

postgres = PostgreSQL is the database and I have no plugins installed (default 1.4.2 installation).

[MattRogowski]

Is it just me or is that not in the list of databases to select on installation??

[Dennis Tsang]

(10-16-2008 03:32 PM)Matt_ Wrote:  Is it just me or is that not in the list of databases to select on installation??

It's just you. MyBB 1.4 came with PostgreSQL and SQLite support.

[MattRogowski]

(10-16-2008 06:05 PM)DennisTT Wrote:  

(10-16-2008 03:32 PM)Matt_ Wrote:  Is it just me or is that not in the list of databases to select on installation??

It's just you. MyBB 1.4 came with PostgreSQL and SQLite support.

Would that only show on the list if it was installed on the server?? Because it wasn't on the list for me.

[Dennis Tsang]

(10-16-2008 06:12 PM)Matt_ Wrote:  

(10-16-2008 06:05 PM)DennisTT Wrote:  

(10-16-2008 03:32 PM)Matt_ Wrote:  Is it just me or is that not in the list of databases to select on installation??

It's just you. MyBB 1.4 came with PostgreSQL and SQLite support.

Would that only show on the list if it was installed on the server?? Because it wasn't on the list for me.

Yes.


For kvikkjokk, could you try this groups.php? Upload it to admin/modules/user/groups.php. It should fix the second and third problems.

[kvikkjokk]

(10-16-2008 06:18 PM)DennisTT Wrote:  

(10-16-2008 06:12 PM)Matt_ Wrote:  

(10-16-2008 06:05 PM)DennisTT Wrote:  

(10-16-2008 03:32 PM)Matt_ Wrote:  Is it just me or is that not in the list of databases to select on installation??

It's just you. MyBB 1.4 came with PostgreSQL and SQLite support.

Would that only show on the list if it was installed on the server?? Because it wasn't on the list for me.

Yes.


For kvikkjokk, could you try this groups.php? Upload it to admin/modules/user/groups.php. It should fix the second and third problems.

Hi Dennis,
wonderful !!! #2 and #3 solved. Superb work. Any thoughts about #1 ?

Thanks for your support

[Dennis Tsang]

Hi kvikkjokk

Just wondering, do you get the 1st error when a new user registers on the front end, and also when you try to create a user in the Admin CP?

[laie_techie]

Looks like the installation script forgot to create the proper sequences. For each table create a sequence using something like:

Code:

CREATE SEQUENCE mybb_userfields_ufid_seq