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: 0

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

Re: Postgres issues [message #28204 is a reply to message #28203]

Thu, 13 October 2005 18:54

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

These problems are already fixed in CVS, RC2 definately has this patch in it (check web cvs for patch).

As far as reporting problems, your format works well Smile

FUDforum Core Developer

Report message to a moderator

Re: Postgres issues [message #28205 is a reply to message #28204]

Thu, 13 October 2005 19:15

hawk259

Messages: 3
Registered: October 2005

Karma: 0

Junior Member

New error (after upgrade to RC2) for the Forum Consistency:

Warning: pg_query(): Query failed: ERROR: syntax error at or near "," at character 29 in FUDforum/include/theme/default/db.inc on line 94
(FUDforum/include/theme/default/db.inc:94
 FUDforum/include/theme/default/db.inc:55 
 FUDforum/adm/consist.php:152
) : ERROR: syntax error at or near "," at character 29
Query: LOCK TABLE fud26_action_log,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, fud26_users, fud26_forum, fud26_thread, fud26_poll, fud26_poll_opt, fud26_poll_opt_track, fud26_msg, fud26_pmsg, fud26_mod, fud26_thread_rate_track, fud26_msg_report, fud26_cat, fud26_forum_notify, fud26_thread_notify, fud26_buddy, fud26_user_ignore, fud26_msg, fud26_msg, fud26_users, fud26_users, fud26_attach, fud26_thr_exchange, fud26_read, fud26_mime, fud26_group_members, fud26_group_resources, fud26_groups, fud26_group_members, fud26_group_members, fud26_themes thm IN ACCESS EXCLUSIVE MODE
_POST: array ( 'conf' => 'Yes', 'S' => 'ee0203adb085d479714f67141ea9cac0', 'SQ' => 'c979e120e678af2d7493e7acec2bddbf', )
Server Version:
[Referring Page] <url>/adm/consist.php?S=

[Updated on: Thu, 13 October 2005 19:20]

Report message to a moderator

Re: Postgres issues [message #28206 is a reply to message #28205]

Thu, 13 October 2005 19:28

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7382

This patch should do the trick.

FUDforum Core Developer

Report message to a moderator

Re: Postgres issues [message #28207 is a reply to message #28206]

Thu, 13 October 2005 20:03

hawk259

Messages: 3
Registered: October 2005

Karma: 0

Junior Member

I had to tweak the patch:

$tbls = str_replace(array(' WRITE,', ' WRITE'), array('',''), $tables);

to

$tbls = str_replace(array(' WRITE,', ' WRITE'), array(',',''), $tables);

That is because it needs to leave the comma separator for the lock command.

I then had to tweak preg_replace from:

$tbls = preg_replace('!\s+\w+,!', ',', $tbls);

to

$tbls = preg_replace('!(\w+)\s+\w+(,|$)!', '\\1\\2', $tbls);

Brian

Report message to a moderator

Re: Postgres issues [message #28314 is a reply to message #28207]

Mon, 17 October 2005 15:59

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Fixed in CVS, here is the patch:
http://cvs.prohost.org/c/index.cgi/FUDforum/chngview?cn=7389

FUDforum Core Developer

Report message to a moderator

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 Nov 27 02:37:33 GMT 2024

Total time taken to generate the page: 0.02692 seconds