[freeside-users] New server upgrade

[Damon Vincent]

Ran into an issue which I have not resolved yet.  Posting a payment 
causes the following:

Error: error inserting FS::cust_pay=HASH(0xa6c9ae4): can't parse 
cust_pay.paynum default value for sequence name: 
nextval(('"cust_pay_paynum_seq"'::text)::regclass)

I dont understand the language of the 
nextval(('"cust_pay_paynum_seq"'::text)::regclass).  can someone explain 
this?  The cust_pay_paynum_seq table is populated and looks reasonable.


Damon Vincent wrote:
> Everything seems to have worked per your advice.. couple of things.
>
> in the upgrade10.html file i had to do the following in postgre8.1
>
> ALTER TABLE cust_main ALTER COLUMN payinfo TYPE varchar(512);
> ALTER TABLE h_cust_main ALTER COLUMN payinfo TYPE varchar(512);
>
> instead of
>
> ALTER TABLE cust_main ALTER COLUMN payinfo varchar(512) NULL;
> ALTER TABLE h_cust_main ALTER COLUMN payinfo varchar(512) NULL;
>
> Where is the config stored?  I thought it was in db?
>
>
> Ivan Kohler wrote:
>> You can probably just follow the instructions in the current 
>> upgrade10.html file, ignoring any schema changes that are already 
>> done in your database.
>>
>>   
>
> _______________________________________________
> freeside-users mailing list
> freeside-users at sisd.com
> http://420.am/cgi-bin/mailman/listinfo/freeside-users