FUDforum: Bug Reports » Postgres error

Home » FUDforum Development » Bug Reports » Postgres error

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

Postgres error [message #8545]

Fri, 07 February 2003 01:31

ftzdomino

Messages: 2
Registered: February 2003

Karma:

Junior Member

Line 194 of compact.php:

q("ALTER TABLE ".$GLOBALS['DBHOST_TBL_PREFIX']."pmsg ADD INDEX(foff)");

This is a mysql call and will not work in postgres. It should read something like:

q("create index ".$GLOBALS['DBHOST_TBL_PREFIX']."pmsg_foff_idx on ".$GLOBALS['DBHOST_TBL_PREFIX']."pmsg (foff)");

Line 226 also must be changed to:

q("drop index ".$GLOBALS['DBHOST_TBL_PREFIX']."pmsg_foff_idx");

And line 195:
db_lock($GLOBALS['DBHOST_TBL_PREFIX'].'pmsg+, '.$GLOBALS['DBHOST_TBL_PREFIX'].'replace+');

Must also not be run as it creates recursive lock errors and this is an issue that should be handled in transactions instead.

[Updated on: Fri, 07 February 2003 01:34]

Report message to a moderator

[Message index]

		Postgres error By: ftzdomino on Fri, 07 February 2003 01:31
		Re: Postgres error By: Ilia on Tue, 11 February 2003 21:36
		Re: Postgres error By: ftzdomino on Tue, 11 February 2003 22:00
		Re: Postgres error By: Ilia on Tue, 11 February 2003 22:06

Previous Topic:	sql error when anonymous has no rights
Next Topic:	first page of such forum (threads list) is empty

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 08:00:18 GMT 2024

Total time taken to generate the page: 0.04531 seconds