FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Upgrade from 2.5.0 to 2.5.2 does not work
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Re: Upgrade from 2.5.0 to 2.5.2 does not work [message #12323 is a reply to message #12317] Mon, 04 August 2003 17:20 Go to previous messageGo to previous message
lstep is currently offline  lstep   France
Messages: 50
Registered: June 2003
Karma:
Member

prottoss wrote on Mon, 04 August 2003 18:13

lstep wrote on Mon, 04 August 2003 03:44


On the SQL upgrade, it chokes/stops on a new error:
PostgreSQL Error: ERROR: ALTER TABLE: Attribute "pm_notify" contains NULL values 
Query: ALTER TABLE fud25_users ALTER COLUMN pm_notify SET NOT NULL

What's supposed to be in this pm_notify? I just see it's a sequence.


Hmm strange error this is the last item in SQL upgrading and it shouldn't have failed since the table has a default value for that column that should've been set upon the column addition.



You're right, it's very strange. The record is set up to reveice a value from a sequence, so it should be ok:
fudbase=# select pm_notify from fud25_users limit 1;
 pm_notify
-----------

(1 row)


May I do a update fud25_users set pm_notify = 1; ? What's the use of that pm_notify? (I've got 2 users, that not really a problem I guess)
[Message index]
 
Read Message
Read Message
Read Message icon5.gif
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Problems posting messages...
Next Topic: 2.5.2 upgrade problem
Goto Forum:
  

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

Current Time: Fri Nov 22 18:06:00 GMT 2024

Total time taken to generate the page: 0.04869 seconds