FUDforum: Bug Reports » FUDforum v2.8.0 errors

Home » FUDforum Development » Bug Reports » FUDforum v2.8.0 errors (PostgreSQL)

Thu, 16 April 2009 15:03

naudefj

Messages: 3771
Registered: December 2004

Karma:

Senior Member
Administrator
Core Developer

More info:

Somehow PostgresQL doesn't like queries like:

SELECT cat_opt, (cat_opt & 4)=4 FROM fud28_cat

MySQL returns:

cat_opt (cat_opt & 4)=4
3       0

But PgSQL returns:

cat_opt ?column?       
3       f

The problem was solved by removing the bitwise operation from the query and implementing it in PHP code.

		FUDforum v2.8.0 errors By: ganman on Tue, 03 March 2009 22:34
		Re: FUDforum v2.8.0 errors By: naudefj on Wed, 04 March 2009 05:05
		Re: FUDforum v2.8.0 errors By: ganman on Wed, 04 March 2009 18:00
		Re: FUDforum v2.8.0 errors By: naudefj on Wed, 04 March 2009 19:16
		Re: FUDforum v2.8.0 errors By: ganman on Wed, 04 March 2009 19:28
		Re: FUDforum v2.8.0 errors By: naudefj on Wed, 04 March 2009 19:40
		Re: FUDforum v2.8.0 errors By: naudefj on Thu, 16 April 2009 14:58
		Re: FUDforum v2.8.0 errors By: naudefj on Thu, 16 April 2009 15:03

Previous Topic:	Picture problem
Next Topic:	i18n characters not showing in dates! (utf-8)

Goto Forum:

]

Current Time: Wed Nov 27 21:29:59 GMT 2024

Total time taken to generate the page: 0.04275 seconds