[freeside-users] Upgrading from 1.5.7 to 1.7.3

Amitay Isaacs amitay at gmail.com
Sat Feb 7 20:46:22 PST 2009


Hi Freeside users,

I am trying to upgrade the freeside database running 1.5.7 to newer
installation of freeside 1.7.3.

Following the instructions on the wiki page
Freeside:1.7:Documentation:Upgrading, I modified
the cust_pay_batch, h_cust_pay_batch and cust_main tables.

When I am trying to do the next step, freeside-upgrade, I get following
errors

DBD::Pg::db do failed: ERROR:  column "batchnum" contains null values at
/usr/lib/perl5/site_perl/5.8.8/DBIx/DBSchema.pm line 338.
Error: ERROR:  column "batchnum" contains null values
 executing: ALTER TABLE cust_pay_batch ALTER batchnum SET NOT NULL at
/usr/lib/perl5/site_perl/5.8.8/DBIx/DBSchema.pm line 338.

In addition there are messages about missing tables.

table h_reason does not exist.
table h_pay_batch does not exist.
table h_cdr does not exist.
table pay_batch does not exist.
table access_groupagent does not exist.
table payment_gateway_option does not exist.
table pkg_class does not exist.
table cdr_calltype does not exist.
table h_cdr_type does not exist.
table h_cust_main_note does not exist.
table h_cdr_carrier does not exist.
table access_usergroup does not exist.
table access_right does not exist.
table h_cust_pay_pending does not exist.
table h_agent_payment_gateway does not exist.
table h_banned_pay does not exist.
table cust_tax_exempt_pkg does not exist.
table h_cust_bill_pay_batch does not exist.
table h_access_groupagent does not exist.
table h_access_usergroup does not exist.
table cust_bill_pay_pkg does not exist.
table h_inventory_item does not exist.
table access_user does not exist.
table cdr_type does not exist.
table access_user_pref does not exist.
table registrar does not exist.
table h_cust_credit_bill_pkg does not exist.
table inventory_class does not exist.
table cust_pkg_reason does not exist.
table h_payment_gateway does not exist.
table h_access_user does not exist.
table h_cdr_calltype does not exist.
table h_cdr_upstream_rate does not exist.
table h_svc_phone does not exist.
table h_cust_tax_exempt_pkg does not exist.
table h_access_user_pref does not exist.
table reason_type does not exist.
table cust_credit_bill_pkg does not exist.
table h_registrar does not exist.
table inventory_item does not exist.
table svc_phone does not exist.
table cust_main_note does not exist.
table reason does not exist.
table cust_pay_pending does not exist.
table h_inventory_class does not exist.
table h_reason_type does not exist.
table cust_pkg_option does not exist.
table cdr_carrier does not exist.
table h_cust_bill_pay_pkg does not exist.
table h_part_pkg_taxclass does not exist.
table cdr does not exist.
table payment_gateway does not exist.
table cust_bill_pay_batch does not exist.
table part_pkg_taxclass does not exist.
table banned_pay does not exist.
table h_access_right does not exist.
table access_group does not exist.
table h_access_group does not exist.
table h_pkg_class does not exist.
table h_cust_pkg_reason does not exist.
table cdr_upstream_rate does not exist.
table h_payment_gateway_option does not exist.
table h_cust_pkg_option does not exist.
table agent_payment_gateway does not exist.

Are these errors or just messages?

The complete output of freeside-upgrade is attached.

Can anyone please point me in the right direction on how to go about
upgrading the database from freeside 1.5.7 to  freeside 1.7.3?

Thanks.

Amitay Isaacs.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://420.am/pipermail/freeside-users/attachments/20090208/a8acee65/attachment-0001.htm 
-------------- next part --------------
ALTER TABLE h_part_svc ALTER COLUMN svcpart DROP NOT NULL
ALTER TABLE cust_refund ADD COLUMN paymask varchar(80)   
CREATE  INDEX cust_refund1 ON cust_refund ( custnum )
CREATE  INDEX cust_refund2 ON cust_refund ( _date )
ALTER TABLE h_cust_credit ALTER COLUMN crednum DROP NOT NULL
ALTER TABLE h_cust_credit ADD COLUMN reasonnum int   
CREATE  INDEX h_cust_credit2 ON h_cust_credit ( _date )
ALTER TABLE cust_svc ADD COLUMN overlimit int   
ALTER TABLE h_rate ALTER COLUMN ratenum DROP NOT NULL
ALTER TABLE h_svc_domain ADD COLUMN suffix varchar(80)   
ALTER TABLE h_svc_domain ADD COLUMN parent_svcnum int   
ALTER TABLE h_svc_domain ADD COLUMN registrarnum int   
ALTER TABLE h_svc_domain ADD COLUMN registrarkey varchar(512)   
ALTER TABLE h_svc_domain ADD COLUMN setup_date int   
ALTER TABLE h_svc_domain ADD COLUMN renewal_interval int   
ALTER TABLE h_svc_domain ADD COLUMN expiration_date int   
table h_reason does not exist.
table h_pay_batch does not exist.
CREATE  INDEX cust_main_county3 ON cust_main_county ( country )
CREATE  INDEX cust_main_county2 ON cust_main_county ( state )
CREATE  INDEX cust_main_county1 ON cust_main_county ( county )
ALTER TABLE h_cust_credit_bill ALTER COLUMN creditbillnum DROP NOT NULL
table h_cdr does not exist.
table pay_batch does not exist.
ALTER TABLE h_cust_tax_exempt ALTER COLUMN exemptnum DROP NOT NULL
table access_groupagent does not exist.
table payment_gateway_option does not exist.
ALTER TABLE h_svc_broadband ADD COLUMN description varchar(80)   
ALTER TABLE h_svc_broadband ADD COLUMN mac_addr varchar(12)   
ALTER TABLE h_svc_broadband ADD COLUMN authkey varchar(32)   
ALTER TABLE h_svc_broadband ADD COLUMN latitude decimal   
ALTER TABLE h_svc_broadband ADD COLUMN longitude decimal   
ALTER TABLE h_svc_broadband ADD COLUMN altitude decimal   
ALTER TABLE h_svc_broadband ADD COLUMN vlan_profile varchar(80)   
table pkg_class does not exist.
ALTER TABLE h_queue_depend ALTER COLUMN dependnum DROP NOT NULL
ALTER TABLE h_addr_block ALTER COLUMN blocknum DROP NOT NULL
ALTER TABLE cust_pay ADD COLUMN otaker varchar(32)   
ALTER TABLE cust_pay ADD COLUMN paymask varchar(80)   
ALTER TABLE cust_pay ADD COLUMN paydate varchar(10)   
ALTER TABLE cust_pay ADD COLUMN payunique varchar(80)   
table cdr_calltype does not exist.
table h_cdr_type does not exist.
ALTER TABLE h_queue ALTER COLUMN jobnum DROP NOT NULL
table h_cust_main_note does not exist.
table h_cdr_carrier does not exist.
table access_usergroup does not exist.
table access_right does not exist.
ALTER TABLE h_part_virtual_field ALTER COLUMN vfieldpart DROP NOT NULL
table h_cust_pay_pending does not exist.
ALTER TABLE h_radius_usergroup ALTER COLUMN usergroupnum DROP NOT NULL
table h_agent_payment_gateway does not exist.
ALTER TABLE svc_domain ADD COLUMN suffix varchar(80)   
ALTER TABLE svc_domain ADD COLUMN parent_svcnum int   
ALTER TABLE svc_domain ADD COLUMN registrarnum int   
ALTER TABLE svc_domain ADD COLUMN registrarkey varchar(512)   
ALTER TABLE svc_domain ADD COLUMN setup_date int   
ALTER TABLE svc_domain ADD COLUMN renewal_interval int   
ALTER TABLE svc_domain ADD COLUMN expiration_date int   
DROP INDEX svc_domain1
CREATE  INDEX svc_domain1 ON svc_domain ( domain )
table h_banned_pay does not exist.
table cust_tax_exempt_pkg does not exist.
table h_cust_bill_pay_batch does not exist.
table h_access_groupagent does not exist.
ALTER TABLE h_cust_pkg ALTER COLUMN pkgnum DROP NOT NULL
ALTER TABLE h_cust_pkg ADD COLUMN adjourn int   
ALTER TABLE h_cust_pkg ADD COLUMN change_date int   
ALTER TABLE h_cust_pkg ADD COLUMN change_pkgnum int   
ALTER TABLE h_cust_pkg ADD COLUMN change_pkgpart int   
CREATE  INDEX h_cust_pkg3 ON h_cust_pkg ( setup )
CREATE  INDEX h_cust_pkg5 ON h_cust_pkg ( bill )
CREATE  INDEX h_cust_pkg9 ON h_cust_pkg ( cancel )
CREATE  INDEX h_cust_pkg10 ON h_cust_pkg ( change_date )
CREATE  INDEX h_cust_pkg8 ON h_cust_pkg ( expire )
CREATE  INDEX h_cust_pkg6 ON h_cust_pkg ( susp )
CREATE  INDEX h_cust_pkg4 ON h_cust_pkg ( last_bill )
CREATE  INDEX h_cust_pkg7 ON h_cust_pkg ( adjourn )
CREATE  INDEX h_cust_pkg2 ON h_cust_pkg ( pkgpart )
table h_access_usergroup does not exist.
table cust_bill_pay_pkg does not exist.
table h_inventory_item does not exist.
DROP INDEX cust_credit_refund1
CREATE  INDEX cust_credit_refund2 ON cust_credit_refund ( refundnum )
CREATE  INDEX cust_credit_refund1 ON cust_credit_refund ( crednum )
table access_user does not exist.
table cdr_type does not exist.
CREATE  INDEX cust_bill_pkg2 ON cust_bill_pkg ( pkgnum )
ALTER TABLE h_reg_code ALTER COLUMN codenum DROP NOT NULL
ALTER TABLE h_cust_credit_refund ALTER COLUMN creditrefundnum DROP NOT NULL
DROP INDEX h_cust_credit_refund1
CREATE  INDEX h_cust_credit_refund2 ON h_cust_credit_refund ( refundnum )
CREATE  INDEX h_cust_credit_refund1 ON h_cust_credit_refund ( crednum )
table access_user_pref does not exist.
ALTER TABLE h_part_pkg ALTER COLUMN pkgpart DROP NOT NULL
ALTER TABLE h_part_pkg ADD COLUMN classnum int   
ALTER TABLE h_part_pkg ADD COLUMN pay_weight real   
ALTER TABLE h_part_pkg ADD COLUMN credit_weight real   
table registrar does not exist.
ALTER TABLE h_domain_record ALTER COLUMN recnum DROP NOT NULL
table h_cust_credit_bill_pkg does not exist.
table inventory_class does not exist.
table cust_pkg_reason does not exist.
ALTER TABLE h_cust_pay ALTER COLUMN paynum DROP NOT NULL
ALTER TABLE h_cust_pay ADD COLUMN otaker varchar(32)   
ALTER TABLE h_cust_pay ADD COLUMN paymask varchar(80)   
ALTER TABLE h_cust_pay ADD COLUMN paydate varchar(10)   
ALTER TABLE h_cust_pay ADD COLUMN payunique varchar(80)   
ALTER TABLE h_part_export ALTER COLUMN exportnum DROP NOT NULL
table h_payment_gateway does not exist.
ALTER TABLE h_virtual_field ALTER COLUMN vfieldnum DROP NOT NULL
table h_access_user does not exist.
ALTER TABLE h_cust_bill_pay ALTER COLUMN billpaynum DROP NOT NULL
ALTER TABLE cust_main ADD COLUMN agent_custid varchar(80)   
ALTER TABLE cust_main ADD COLUMN stateid varchar(80)   
ALTER TABLE cust_main ADD COLUMN stateid_state varchar(80)   
ALTER TABLE cust_main ADD COLUMN birthdate int   
ALTER TABLE cust_main ADD COLUMN signupdate int   
ALTER TABLE cust_main ADD COLUMN paystart_month int   
ALTER TABLE cust_main ADD COLUMN paystart_year int   
ALTER TABLE cust_main ADD COLUMN payissue varchar(2)   
ALTER TABLE cust_main ADD COLUMN paystate varchar(80)   
ALTER TABLE cust_main ADD COLUMN paytype varchar(80)   
ALTER TABLE cust_main ADD COLUMN payip varchar(15)   
ALTER TABLE cust_main ADD COLUMN spool_cdr char(1)   
ALTER INDEX cust_main2 RENAME TO dbs_temp1
ALTER INDEX cust_main9 RENAME TO dbs_temp2
ALTER INDEX cust_main6 RENAME TO dbs_temp3
ALTER INDEX cust_main3 RENAME TO dbs_temp4
ALTER INDEX cust_main5 RENAME TO dbs_temp5
ALTER INDEX cust_main8 RENAME TO dbs_temp6
ALTER INDEX cust_main4 RENAME TO dbs_temp7
ALTER INDEX cust_main7 RENAME TO dbs_temp8
ALTER INDEX cust_main1 RENAME TO dbs_temp9
DROP INDEX cust_main10
DROP INDEX cust_main11
DROP INDEX cust_main12
CREATE  INDEX cust_main9 ON cust_main ( county )
CREATE  INDEX cust_main16 ON cust_main ( paydate )
CREATE  INDEX cust_main10 ON cust_main ( state )
CREATE  INDEX cust_main11 ON cust_main ( country )
CREATE  INDEX cust_main15 ON cust_main ( payby )
CREATE UNIQUE INDEX cust_main1 ON cust_main ( agentnum, agent_custid )
CREATE  INDEX cust_main12 ON cust_main ( zip )
ALTER INDEX dbs_temp1 RENAME TO cust_main3
ALTER INDEX dbs_temp2 RENAME TO cust_main14
ALTER INDEX dbs_temp3 RENAME TO cust_main7
ALTER INDEX dbs_temp4 RENAME TO cust_main4
ALTER INDEX dbs_temp5 RENAME TO cust_main6
ALTER INDEX dbs_temp6 RENAME TO cust_main13
ALTER INDEX dbs_temp7 RENAME TO cust_main5
ALTER INDEX dbs_temp8 RENAME TO cust_main8
ALTER INDEX dbs_temp9 RENAME TO cust_main2
table h_cdr_calltype does not exist.
ALTER TABLE cust_pay_void ADD COLUMN paymask varchar(80)   
ALTER TABLE svc_acct ADD COLUMN seconds_threshold int   
ALTER TABLE svc_acct ADD COLUMN upbytes bigint   
ALTER TABLE svc_acct ADD COLUMN upbytes_threshold bigint   
ALTER TABLE svc_acct ADD COLUMN downbytes bigint   
ALTER TABLE svc_acct ADD COLUMN downbytes_threshold bigint   
ALTER TABLE svc_acct ADD COLUMN totalbytes bigint   
ALTER TABLE svc_acct ADD COLUMN totalbytes_threshold bigint   
ALTER TABLE svc_acct ADD COLUMN last_login int   
ALTER TABLE svc_acct ADD COLUMN last_logout int   
ALTER TABLE h_part_export_option ALTER COLUMN optionnum DROP NOT NULL
ALTER TABLE h_type_pkgs ALTER COLUMN typepkgnum DROP NOT NULL
ALTER TABLE h_part_bill_event ALTER COLUMN eventpart DROP NOT NULL
ALTER TABLE h_part_bill_event ADD COLUMN freq varchar(80)   
ALTER TABLE h_part_bill_event ADD COLUMN reason int   
table h_cdr_upstream_rate does not exist.
ALTER TABLE h_cust_bill_pkg_detail ALTER COLUMN detailnum DROP NOT NULL
table h_svc_phone does not exist.
ALTER TABLE h_cust_bill_event ALTER COLUMN eventnum DROP NOT NULL
table h_cust_tax_exempt_pkg does not exist.
ALTER TABLE svc_broadband ADD COLUMN description varchar(80)   
ALTER TABLE svc_broadband ADD COLUMN mac_addr varchar(12)   
ALTER TABLE svc_broadband ADD COLUMN authkey varchar(32)   
ALTER TABLE svc_broadband ADD COLUMN latitude decimal   
ALTER TABLE svc_broadband ADD COLUMN longitude decimal   
ALTER TABLE svc_broadband ADD COLUMN altitude decimal   
ALTER TABLE svc_broadband ADD COLUMN vlan_profile varchar(80)   
table h_access_user_pref does not exist.
ALTER TABLE h_export_svc ALTER COLUMN exportsvcnum DROP NOT NULL
ALTER TABLE h_prepay_credit ALTER COLUMN prepaynum DROP NOT NULL
ALTER TABLE h_prepay_credit ADD COLUMN upbytes bigint   
ALTER TABLE h_prepay_credit ADD COLUMN downbytes bigint   
ALTER TABLE h_prepay_credit ADD COLUMN totalbytes bigint   
ALTER TABLE h_svc_acct ADD COLUMN seconds_threshold int   
ALTER TABLE h_svc_acct ADD COLUMN upbytes bigint   
ALTER TABLE h_svc_acct ADD COLUMN upbytes_threshold bigint   
ALTER TABLE h_svc_acct ADD COLUMN downbytes bigint   
ALTER TABLE h_svc_acct ADD COLUMN downbytes_threshold bigint   
ALTER TABLE h_svc_acct ADD COLUMN totalbytes bigint   
ALTER TABLE h_svc_acct ADD COLUMN totalbytes_threshold bigint   
ALTER TABLE h_svc_acct ADD COLUMN last_login int   
ALTER TABLE h_svc_acct ADD COLUMN last_logout int   
ALTER TABLE h_cust_bill ALTER COLUMN invnum DROP NOT NULL
table reason_type does not exist.
ALTER TABLE h_cust_pay_void ADD COLUMN paymask varchar(80)   
CREATE  INDEX rate_detail2 ON rate_detail ( ratenum, dest_regionnum )
table cust_credit_bill_pkg does not exist.
table h_registrar does not exist.
ALTER TABLE h_part_svc_column ALTER COLUMN columnnum DROP NOT NULL
table inventory_item does not exist.
table svc_phone does not exist.
ALTER TABLE h_agent_type ALTER COLUMN typenum DROP NOT NULL
table cust_main_note does not exist.
table reason does not exist.
table cust_pay_pending does not exist.
ALTER TABLE h_cust_svc ALTER COLUMN svcnum DROP NOT NULL
ALTER TABLE h_cust_svc ADD COLUMN overlimit int   
ALTER TABLE h_svc_www ALTER COLUMN usersvc DROP NOT NULL
ALTER TABLE h_svc_www ADD COLUMN config text   
table h_inventory_class does not exist.
table h_reason_type does not exist.
ALTER TABLE h_part_referral ALTER COLUMN refnum DROP NOT NULL
ALTER TABLE h_part_referral ADD COLUMN agentnum int   
ALTER TABLE h_cust_pay_refund ALTER COLUMN payrefundnum DROP NOT NULL
ALTER TABLE h_reg_code_pkg ALTER COLUMN codepkgnum DROP NOT NULL
ALTER TABLE svc_www ALTER COLUMN usersvc DROP NOT NULL
ALTER TABLE svc_www ADD COLUMN config text   
ALTER TABLE part_pkg ADD COLUMN classnum int   
ALTER TABLE part_pkg ADD COLUMN pay_weight real   
ALTER TABLE part_pkg ADD COLUMN credit_weight real   
ALTER TABLE cust_pay_batch ADD COLUMN batchnum int   
ALTER TABLE cust_pay_batch ALTER batchnum SET NOT NULL
ALTER TABLE cust_pay_batch ADD COLUMN payby char(4)   
ALTER TABLE cust_pay_batch ALTER payby SET NOT NULL
ALTER TABLE cust_pay_batch ALTER COLUMN payinfo SET NOT NULL
ALTER TABLE cust_pay_batch ADD COLUMN status varchar(80)   
ALTER INDEX cust_pay_batch2 RENAME TO dbs_temp1
ALTER INDEX cust_pay_batch1 RENAME TO dbs_temp2
CREATE  INDEX cust_pay_batch1 ON cust_pay_batch ( batchnum )
ALTER INDEX dbs_temp1 RENAME TO cust_pay_batch3
ALTER INDEX dbs_temp2 RENAME TO cust_pay_batch2
ALTER TABLE h_pkg_svc ALTER COLUMN pkgsvcnum DROP NOT NULL
table cust_pkg_option does not exist.
ALTER TABLE h_cust_refund ALTER COLUMN refundnum DROP NOT NULL
ALTER TABLE h_cust_refund ADD COLUMN paymask varchar(80)   
CREATE  INDEX h_cust_refund1 ON h_cust_refund ( custnum )
CREATE  INDEX h_cust_refund2 ON h_cust_refund ( _date )
ALTER TABLE h_nas ALTER COLUMN nasnum DROP NOT NULL
table cdr_carrier does not exist.
ALTER TABLE h_rate_detail ALTER COLUMN ratedetailnum DROP NOT NULL
CREATE  INDEX h_rate_detail2 ON h_rate_detail ( ratenum, dest_regionnum )
ALTER TABLE part_referral ADD COLUMN agentnum int   
table h_cust_bill_pay_pkg does not exist.
ALTER TABLE h_port ALTER COLUMN portnum DROP NOT NULL
table h_part_pkg_taxclass does not exist.
table cdr does not exist.
table payment_gateway does not exist.
table cust_bill_pay_batch does not exist.
ALTER TABLE agent ADD COLUMN ticketing_queueid int   
ALTER TABLE h_cust_main ALTER COLUMN custnum DROP NOT NULL
ALTER TABLE h_cust_main ADD COLUMN agent_custid varchar(80)   
ALTER TABLE h_cust_main ADD COLUMN stateid varchar(80)   
ALTER TABLE h_cust_main ADD COLUMN stateid_state varchar(80)   
ALTER TABLE h_cust_main ADD COLUMN birthdate int   
ALTER TABLE h_cust_main ADD COLUMN signupdate int   
ALTER TABLE h_cust_main ADD COLUMN paystart_month int   
ALTER TABLE h_cust_main ADD COLUMN paystart_year int   
ALTER TABLE h_cust_main ADD COLUMN payissue varchar(2)   
ALTER TABLE h_cust_main ADD COLUMN paystate varchar(80)   
ALTER TABLE h_cust_main ADD COLUMN paytype varchar(80)   
ALTER TABLE h_cust_main ADD COLUMN payip varchar(15)   
ALTER TABLE h_cust_main ADD COLUMN spool_cdr char(1)   
ALTER INDEX h_cust_main2 RENAME TO dbs_temp1
ALTER INDEX h_cust_main8 RENAME TO dbs_temp2
ALTER INDEX h_cust_main5 RENAME TO dbs_temp3
ALTER INDEX h_cust_main6 RENAME TO dbs_temp4
ALTER INDEX h_cust_main9 RENAME TO dbs_temp5
ALTER INDEX h_cust_main4 RENAME TO dbs_temp6
ALTER INDEX h_cust_main7 RENAME TO dbs_temp7
ALTER INDEX h_cust_main1 RENAME TO dbs_temp8
ALTER INDEX h_cust_main3 RENAME TO dbs_temp9
DROP INDEX h_cust_main10
DROP INDEX h_cust_main11
DROP INDEX h_cust_main12
CREATE  INDEX h_cust_main10 ON h_cust_main ( state )
CREATE  INDEX h_cust_main1 ON h_cust_main ( agentnum, agent_custid )
CREATE  INDEX h_cust_main12 ON h_cust_main ( zip )
CREATE  INDEX h_cust_main16 ON h_cust_main ( paydate )
CREATE  INDEX h_cust_main11 ON h_cust_main ( country )
CREATE  INDEX h_cust_main9 ON h_cust_main ( county )
CREATE  INDEX h_cust_main15 ON h_cust_main ( payby )
ALTER INDEX dbs_temp1 RENAME TO h_cust_main3
ALTER INDEX dbs_temp2 RENAME TO h_cust_main13
ALTER INDEX dbs_temp3 RENAME TO h_cust_main6
ALTER INDEX dbs_temp4 RENAME TO h_cust_main7
ALTER INDEX dbs_temp5 RENAME TO h_cust_main14
ALTER INDEX dbs_temp6 RENAME TO h_cust_main5
ALTER INDEX dbs_temp7 RENAME TO h_cust_main8
ALTER INDEX dbs_temp8 RENAME TO h_cust_main2
ALTER INDEX dbs_temp9 RENAME TO h_cust_main4
table part_pkg_taxclass does not exist.
table banned_pay does not exist.
ALTER TABLE h_cust_main_invoice ALTER COLUMN destnum DROP NOT NULL
ALTER TABLE h_svc_acct_pop ALTER COLUMN popnum DROP NOT NULL
ALTER TABLE part_bill_event ADD COLUMN freq varchar(80)   
ALTER TABLE part_bill_event ADD COLUMN reason int   
ALTER TABLE h_part_pop_local ALTER COLUMN localnum DROP NOT NULL
ALTER TABLE h_agent ALTER COLUMN agentnum DROP NOT NULL
ALTER TABLE h_agent ADD COLUMN ticketing_queueid int   
ALTER TABLE h_part_svc_router ALTER COLUMN svcrouternum DROP NOT NULL
table h_access_right does not exist.
ALTER TABLE h_queue_arg ALTER COLUMN argnum DROP NOT NULL
table access_group does not exist.
table h_access_group does not exist.
table h_pkg_class does not exist.
ALTER TABLE cust_credit ADD COLUMN reasonnum int   
CREATE  INDEX cust_credit2 ON cust_credit ( _date )
ALTER TABLE h_router ALTER COLUMN routernum DROP NOT NULL
ALTER TABLE h_part_pkg_option ALTER COLUMN optionnum DROP NOT NULL
ALTER TABLE h_msgcat ALTER COLUMN msgnum DROP NOT NULL
table h_cust_pkg_reason does not exist.
ALTER TABLE h_rate_prefix ALTER COLUMN prefixnum DROP NOT NULL
ALTER TABLE prepay_credit ADD COLUMN upbytes bigint   
ALTER TABLE prepay_credit ADD COLUMN downbytes bigint   
ALTER TABLE prepay_credit ADD COLUMN totalbytes bigint   
table cdr_upstream_rate does not exist.
ALTER TABLE cust_pkg ADD COLUMN adjourn int   
ALTER TABLE cust_pkg ADD COLUMN change_date int   
ALTER TABLE cust_pkg ADD COLUMN change_pkgnum int   
ALTER TABLE cust_pkg ADD COLUMN change_pkgpart int   
CREATE  INDEX cust_pkg5 ON cust_pkg ( bill )
CREATE  INDEX cust_pkg8 ON cust_pkg ( expire )
CREATE  INDEX cust_pkg9 ON cust_pkg ( cancel )
CREATE  INDEX cust_pkg10 ON cust_pkg ( change_date )
CREATE  INDEX cust_pkg7 ON cust_pkg ( adjourn )
CREATE  INDEX cust_pkg4 ON cust_pkg ( last_bill )
CREATE  INDEX cust_pkg6 ON cust_pkg ( susp )
CREATE  INDEX cust_pkg2 ON cust_pkg ( pkgpart )
CREATE  INDEX cust_pkg3 ON cust_pkg ( setup )
table h_payment_gateway_option does not exist.
ALTER TABLE h_rate_region ALTER COLUMN regionnum DROP NOT NULL
table h_cust_pkg_option does not exist.
ALTER TABLE h_cust_main_county ALTER COLUMN taxnum DROP NOT NULL
CREATE  INDEX h_cust_main_county3 ON h_cust_main_county ( country )
CREATE  INDEX h_cust_main_county2 ON h_cust_main_county ( state )
CREATE  INDEX h_cust_main_county1 ON h_cust_main_county ( county )
table agent_payment_gateway does not exist.
ALTER TABLE h_cust_pay_batch ALTER COLUMN paybatchnum DROP NOT NULL
ALTER TABLE h_cust_pay_batch ADD COLUMN batchnum int   
ALTER TABLE h_cust_pay_batch ALTER batchnum SET NOT NULL
ALTER TABLE h_cust_pay_batch ADD COLUMN payby char(4)   
ALTER TABLE h_cust_pay_batch ALTER payby SET NOT NULL
ALTER TABLE h_cust_pay_batch ALTER COLUMN payinfo SET NOT NULL
ALTER TABLE h_cust_pay_batch ADD COLUMN status varchar(80)   
ALTER INDEX h_cust_pay_batch1 RENAME TO dbs_temp1
ALTER INDEX h_cust_pay_batch2 RENAME TO dbs_temp2
CREATE  INDEX h_cust_pay_batch1 ON h_cust_pay_batch ( batchnum )
ALTER INDEX dbs_temp1 RENAME TO h_cust_pay_batch2
ALTER INDEX dbs_temp2 RENAME TO h_cust_pay_batch3
ALTER TABLE h_cust_bill_pkg ALTER COLUMN billpkgnum DROP NOT NULL
CREATE  INDEX h_cust_bill_pkg2 ON h_cust_bill_pkg ( pkgnum )
NOTICE:  CREATE TABLE will create implicit sequence "h_reason_historynum_seq" for serial column "h_reason.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_reason_pkey" for table "h_reason"
NOTICE:  CREATE TABLE will create implicit sequence "h_pay_batch_historynum_seq" for serial column "h_pay_batch.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_pay_batch_pkey" for table "h_pay_batch"
NOTICE:  CREATE TABLE will create implicit sequence "h_cdr_historynum_seq" for serial column "h_cdr.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_cdr_pkey" for table "h_cdr"
NOTICE:  CREATE TABLE will create implicit sequence "pay_batch_batchnum_seq" for serial column "pay_batch.batchnum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pay_batch_pkey" for table "pay_batch"
NOTICE:  CREATE TABLE will create implicit sequence "access_groupagent_groupagentnum_seq" for serial column "access_groupagent.groupagentnum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "access_groupagent_pkey" for table "access_groupagent"
NOTICE:  CREATE TABLE will create implicit sequence "payment_gateway_option_optionnum_seq" for serial column "payment_gateway_option.optionnum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "payment_gateway_option_pkey" for table "payment_gateway_option"
NOTICE:  CREATE TABLE will create implicit sequence "pkg_class_classnum_seq" for serial column "pkg_class.classnum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "pkg_class_pkey" for table "pkg_class"
NOTICE:  CREATE TABLE will create implicit sequence "cdr_calltype_calltypenum_seq" for serial column "cdr_calltype.calltypenum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "cdr_calltype_pkey" for table "cdr_calltype"
NOTICE:  CREATE TABLE will create implicit sequence "h_cdr_type_historynum_seq" for serial column "h_cdr_type.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_cdr_type_pkey" for table "h_cdr_type"
NOTICE:  CREATE TABLE will create implicit sequence "h_cust_main_note_historynum_seq" for serial column "h_cust_main_note.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_cust_main_note_pkey" for table "h_cust_main_note"
NOTICE:  CREATE TABLE will create implicit sequence "h_cdr_carrier_historynum_seq" for serial column "h_cdr_carrier.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_cdr_carrier_pkey" for table "h_cdr_carrier"
NOTICE:  CREATE TABLE will create implicit sequence "access_usergroup_usergroupnum_seq" for serial column "access_usergroup.usergroupnum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "access_usergroup_pkey" for table "access_usergroup"
NOTICE:  CREATE TABLE will create implicit sequence "access_right_rightnum_seq" for serial column "access_right.rightnum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "access_right_pkey" for table "access_right"
NOTICE:  CREATE TABLE will create implicit sequence "h_cust_pay_pending_historynum_seq" for serial column "h_cust_pay_pending.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_cust_pay_pending_pkey" for table "h_cust_pay_pending"
NOTICE:  CREATE TABLE will create implicit sequence "h_agent_payment_gateway_historynum_seq" for serial column "h_agent_payment_gateway.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_agent_payment_gateway_pkey" for table "h_agent_payment_gateway"
NOTICE:  CREATE TABLE will create implicit sequence "h_banned_pay_historynum_seq" for serial column "h_banned_pay.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_banned_pay_pkey" for table "h_banned_pay"
NOTICE:  CREATE TABLE will create implicit sequence "cust_tax_exempt_pkg_exemptpkgnum_seq" for serial column "cust_tax_exempt_pkg.exemptpkgnum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "cust_tax_exempt_pkg_pkey" for table "cust_tax_exempt_pkg"
NOTICE:  CREATE TABLE will create implicit sequence "h_cust_bill_pay_batch_historynum_seq" for serial column "h_cust_bill_pay_batch.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_cust_bill_pay_batch_pkey" for table "h_cust_bill_pay_batch"
NOTICE:  CREATE TABLE will create implicit sequence "h_access_groupagent_historynum_seq" for serial column "h_access_groupagent.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_access_groupagent_pkey" for table "h_access_groupagent"
NOTICE:  CREATE TABLE will create implicit sequence "h_access_usergroup_historynum_seq" for serial column "h_access_usergroup.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_access_usergroup_pkey" for table "h_access_usergroup"
NOTICE:  CREATE TABLE will create implicit sequence "cust_bill_pay_pkg_billpaypkgnum_seq" for serial column "cust_bill_pay_pkg.billpaypkgnum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "cust_bill_pay_pkg_pkey" for table "cust_bill_pay_pkg"
NOTICE:  CREATE TABLE will create implicit sequence "h_inventory_item_historynum_seq" for serial column "h_inventory_item.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_inventory_item_pkey" for table "h_inventory_item"
NOTICE:  CREATE TABLE will create implicit sequence "access_user_usernum_seq" for serial column "access_user.usernum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "access_user_pkey" for table "access_user"
NOTICE:  CREATE TABLE will create implicit sequence "cdr_type_cdrtypenum_seq" for serial column "cdr_type.cdrtypenum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "cdr_type_pkey" for table "cdr_type"
NOTICE:  CREATE TABLE will create implicit sequence "access_user_pref_prefnum_seq" for serial column "access_user_pref.prefnum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "access_user_pref_pkey" for table "access_user_pref"
NOTICE:  CREATE TABLE will create implicit sequence "registrar_registrarnum_seq" for serial column "registrar.registrarnum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "registrar_pkey" for table "registrar"
NOTICE:  CREATE TABLE will create implicit sequence "h_cust_credit_bill_pkg_historynum_seq" for serial column "h_cust_credit_bill_pkg.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_cust_credit_bill_pkg_pkey" for table "h_cust_credit_bill_pkg"
NOTICE:  CREATE TABLE will create implicit sequence "inventory_class_classnum_seq" for serial column "inventory_class.classnum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "inventory_class_pkey" for table "inventory_class"
NOTICE:  CREATE TABLE will create implicit sequence "cust_pkg_reason_num_seq" for serial column "cust_pkg_reason.num"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "cust_pkg_reason_pkey" for table "cust_pkg_reason"
NOTICE:  CREATE TABLE will create implicit sequence "h_payment_gateway_historynum_seq" for serial column "h_payment_gateway.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_payment_gateway_pkey" for table "h_payment_gateway"
NOTICE:  CREATE TABLE will create implicit sequence "h_access_user_historynum_seq" for serial column "h_access_user.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_access_user_pkey" for table "h_access_user"
NOTICE:  CREATE TABLE will create implicit sequence "h_cdr_calltype_historynum_seq" for serial column "h_cdr_calltype.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_cdr_calltype_pkey" for table "h_cdr_calltype"
NOTICE:  CREATE TABLE will create implicit sequence "h_cdr_upstream_rate_historynum_seq" for serial column "h_cdr_upstream_rate.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_cdr_upstream_rate_pkey" for table "h_cdr_upstream_rate"
NOTICE:  CREATE TABLE will create implicit sequence "h_svc_phone_historynum_seq" for serial column "h_svc_phone.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_svc_phone_pkey" for table "h_svc_phone"
NOTICE:  CREATE TABLE will create implicit sequence "h_cust_tax_exempt_pkg_historynum_seq" for serial column "h_cust_tax_exempt_pkg.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_cust_tax_exempt_pkg_pkey" for table "h_cust_tax_exempt_pkg"
NOTICE:  CREATE TABLE will create implicit sequence "h_access_user_pref_historynum_seq" for serial column "h_access_user_pref.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_access_user_pref_pkey" for table "h_access_user_pref"
NOTICE:  CREATE TABLE will create implicit sequence "reason_type_typenum_seq" for serial column "reason_type.typenum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "reason_type_pkey" for table "reason_type"
NOTICE:  CREATE TABLE will create implicit sequence "cust_credit_bill_pkg_creditbillpkgnum_seq" for serial column "cust_credit_bill_pkg.creditbillpkgnum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "cust_credit_bill_pkg_pkey" for table "cust_credit_bill_pkg"
NOTICE:  CREATE TABLE will create implicit sequence "h_registrar_historynum_seq" for serial column "h_registrar.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_registrar_pkey" for table "h_registrar"
NOTICE:  CREATE TABLE will create implicit sequence "inventory_item_itemnum_seq" for serial column "inventory_item.itemnum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "inventory_item_pkey" for table "inventory_item"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "svc_phone_pkey" for table "svc_phone"
NOTICE:  CREATE TABLE will create implicit sequence "cust_main_note_notenum_seq" for serial column "cust_main_note.notenum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "cust_main_note_pkey" for table "cust_main_note"
NOTICE:  CREATE TABLE will create implicit sequence "reason_reasonnum_seq" for serial column "reason.reasonnum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "reason_pkey" for table "reason"
NOTICE:  CREATE TABLE will create implicit sequence "cust_pay_pending_paypendingnum_seq" for serial column "cust_pay_pending.paypendingnum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "cust_pay_pending_pkey" for table "cust_pay_pending"
NOTICE:  CREATE TABLE will create implicit sequence "h_inventory_class_historynum_seq" for serial column "h_inventory_class.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_inventory_class_pkey" for table "h_inventory_class"
NOTICE:  CREATE TABLE will create implicit sequence "h_reason_type_historynum_seq" for serial column "h_reason_type.historynum"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "h_reason_type_pkey" for table "h_reason_type"
DBD::Pg::db do failed: ERROR:  column "batchnum" contains null values at /usr/lib/perl5/site_perl/5.8.8/DBIx/DBSchema.pm line 338.
Error: ERROR:  column "batchnum" contains null values
 executing: ALTER TABLE cust_pay_batch ALTER batchnum SET NOT NULL at /usr/lib/perl5/site_perl/5.8.8/DBIx/DBSchema.pm line 338.


More information about the freeside-users mailing list