FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum » FUDforum Installation Issues » Register + Activate Account (FUDForum 2.8 -> 3.0.4, PGSQL 9.1.9)
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Register + Activate Account [message #168974] Mon, 12 August 2013 17:19 Go to next message
now_what is currently offline  now_what   Germany
Messages: 6
Registered: July 2013
Karma: 0
Junior Member
It seems activating an account does not work since after the Upgrade. See here:

(index.php:120
theme/default/emailconf.php:450
index.php:1360
) : ERROR: null value in column "conf_key" violates not-null constraint
Query: UPDATE fud28_users SET users_opt=(users_opt | 131072), conf_key=NULL WHERE id=889
_GET: array ( 't' => 'emailconf', 'conf_key' => '0bcbc802a8b9c25da0c6cb42dcd117ee', )
Database version: 9.1.9

Existing users (created with 2.8) have the conf_key field value set to '0'.

How to fix this:
- either remove constraint, and update all rows with '0' value in conf_key to 'NULL'?
- or fix the update statement in emailconf.php?

Thanks for any help!

Report message to a moderator

Re: Register + Activate Account [message #168979 is a reply to message #168974] Tue, 13 August 2013 05:33 Go to previous messageGo to next message
naudefj is currently offline  naudefj   
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
This column is not supposed to have a NOT NULL constraint, please remove it.

Report message to a moderator

Re: Register + Activate Account [message #168980 is a reply to message #168979] Tue, 13 August 2013 07:51 Go to previous messageGo to next message
now_what is currently offline  now_what   Germany
Messages: 6
Registered: July 2013
Karma: 0
Junior Member
Thanks.
ALTER TABLE fud28_users ALTER COLUMN conf_key DROP NOT NULL;

Done. Activate account seems to work again.

Should I take care of 0-values? What about Default 0?

Report message to a moderator

Re: Register + Activate Account [message #169176 is a reply to message #168980] Mon, 02 September 2013 17:18 Go to previous message
naudefj is currently offline  naudefj   
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
You can update the 0-values to NULL if you like.
Alternatively, just leave them as-is (next upgrade will fix them automatically).

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Install without sql possible?
Next Topic: Upgrade 3.0.0 -> 3.0.4 postgres 9.1.9
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 21 13:57:30 GMT 2024

Total time taken to generate the page: 0.02583 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software