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 :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Register + Activate Account [message #168974] Mon, 12 August 2013 13:19 Go to next message
now_what is currently offline  now_what   Germany
Messages: 6
Registered: July 2013
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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!
Re: Register + Activate Account [message #168979 is a reply to message #168974] Tue, 13 August 2013 01:33 Go to previous messageGo to next message
naudefj is currently offline  naudefj   
Messages: 3654
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
This column is not supposed to have a NOT NULL constraint, please remove it.
Re: Register + Activate Account [message #168980 is a reply to message #168979] Tue, 13 August 2013 03: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
add to buddy list
ignore all messages by this user
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?
Re: Register + Activate Account [message #169176 is a reply to message #168980] Mon, 02 September 2013 13:18 Go to previous message
naudefj is currently offline  naudefj   
Messages: 3654
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
You can update the 0-values to NULL if you like.
Alternatively, just leave them as-is (next upgrade will fix them automatically).
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Fri Jun 22 22:56:49 EDT 2018

Total time taken to generate the page: 0.00618 seconds