FUDforum: Bug Reports » Postgres issues

Home » FUDforum Development » Bug Reports » Postgres issues

Show: Today's Messages :: Polls :: Message Navigator

Postgres issues [message #28203]

Thu, 13 October 2005 18:41

hawk259

Messages: 3
Registered: October 2005

Karma:

Junior Member

I am trying to convert a phpBB2 board over and found some issues. Let me know if this is not the best way to give details.

FUDforum/adm/admslist.php line ~45

u.alias need to be added to the GROUP BY or postgres has problems.

FUDforum/adm/admslist.php line ~50

u.alias need to be added to the GROUP BY or postgres has problems.

Once this is done the WHERE clause has problems in postgres:

ERROR: argument of WHERE must be type boolean, not type integer
SELECT u.id, u.alias FROM fud26_group_members g INNER JOIN fud26_users u ON u.id=g.user_id WHERE (g.group_members_opt & 131072) GROUP BY u.id, u.alias ORDER BY u.alias

Any idea on the best way to fix that?

Thanks,

Brian

Report message to a moderator

[Message index]

		Postgres issues By: hawk259 on Thu, 13 October 2005 18:41
		Re: Postgres issues By: Ilia on Thu, 13 October 2005 18:54
		Re: Postgres issues By: hawk259 on Thu, 13 October 2005 19:15
		Re: Postgres issues By: Ilia on Thu, 13 October 2005 19:28
		Re: Postgres issues By: hawk259 on Thu, 13 October 2005 20:03
		Re: Postgres issues By: Ilia on Mon, 17 October 2005 15:59

Previous Topic:	2.7.2 - 2.7.3rc2 with PDO
Next Topic:	exim and fud

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 23 20:57:29 GMT 2025

Total time taken to generate the page: 0.05152 seconds