FUDforum: FUDforum Installation Issues » Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9

Home » FUDforum » FUDforum Installation Issues » Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9

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

Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 [message #168973 is a reply to message #168765]

Mon, 12 August 2013 16:24

now_what

Messages: 6
Registered: July 2013

Karma:

Junior Member

Thank you naudefj!

To proceed with the update, I removed all offending DELETE statements with OIDs in the update script.
The DELETE statements looked like they were meant prevent other SQL statements from complaining about index violations.

There were no index violations in the tables that mattered, though there was some complaints involving fud28_search,
but they looked as if they could safely be ignored.

As the rest of FUDforum does not use OIDs, I suggest you guys should stop using them in the update script.

No problems encountered for 4 weeks:
- my Chinese spammer friends were still able to register and post their dribble.
- I slapped them with Email and IP filters, now they can still register, but they are unable to post.

The whole point of updating was to get rid of spammers. The Captchas did not seem to help at all.
Also, I would have liked if the Email and IP filters had been able to block registration as well as posting.

There is another serious issue that came to my attention today, but it is unrelated to the upgrade process.
I will start a separate thread for this.

Cheers!

Report message to a moderator

[Message index]

		Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: now_what on Mon, 15 July 2013 11:50
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: naudefj on Fri, 19 July 2013 14:49
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: naudefj on Fri, 19 July 2013 15:13
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: now_what on Mon, 12 August 2013 16:24
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: naudefj on Sat, 17 August 2013 18:20
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: now_what on Mon, 19 August 2013 07:33
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: cpreston on Sat, 24 August 2013 17:42
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: naudefj on Sat, 07 September 2013 08:00
		Re: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9 By: naudefj on Sat, 07 September 2013 08:39

Previous Topic:	Register + Activate Account
Next Topic:	Error upgrade from 3.0.0 to 3.0.5

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 05:05:42 GMT 2024

Total time taken to generate the page: 0.05053 seconds