<p dir="ltr">I see you stopped Apache, but did you stop all Freeside processes as well? Ensure they are not running and run freeside-upgrade again.</p>
<br><div class="gmail_quote"><div dir="ltr">On Thu, Mar 30, 2017, 5:47 PM Ernie Dunbar <<a href="mailto:maillist@lightspeed.ca">maillist@lightspeed.ca</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF" class="gmail_msg">
<p class="gmail_msg">Okay, that failed badly. I restored from backups and started over
again, and what follows is the output I get from the upgrade
procedure. The final MySQL query evidently stalls the process and
it goes nowhere from there. I even let it "run" overnight to
ensure it wasn't just a very slow query. <br class="gmail_msg">
</p>
<p class="gmail_msg"><br class="gmail_msg">
</p>
<p class="gmail_msg">root@freeside-dev:/home/ernied# apt-get upgrade</p></div><div text="#000000" bgcolor="#FFFFFF" class="gmail_msg"><p class="gmail_msg"><br class="gmail_msg">
Reading package lists... Done<br class="gmail_msg">
Building dependency tree      <br class="gmail_msg">
Reading state information... Done<br class="gmail_msg">
Calculating upgrade... Done<br class="gmail_msg">
The following packages have been kept back:<br class="gmail_msg">
 freeside freeside-lib freeside-webui<br class="gmail_msg"></p></div><div text="#000000" bgcolor="#FFFFFF" class="gmail_msg"><p class="gmail_msg">
0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded.<br class="gmail_msg">
root@freeside-dev:/home/ernied# apt-get install freeside
freeside-lib freeside-webui</p></div><div text="#000000" bgcolor="#FFFFFF" class="gmail_msg"><p class="gmail_msg"><br class="gmail_msg">
Reading package lists... Done<br class="gmail_msg">
Building dependency tree      <br class="gmail_msg">
Reading state information... Done<br class="gmail_msg">
The following extra packages will be installed:<br class="gmail_msg">
 libbusiness-onlinepayment-perl libdatetime-event-ical-perl
libdatetime-event-recurrence-perl<br class="gmail_msg">
 libdatetime-format-ical-perl libgeo-streetaddress-us-perl
librest-client-perl<br class="gmail_msg">
Suggested packages:<br class="gmail_msg">
 libbusiness-onlinepayment-authorizenet-perl
libbusiness-onlinepayment-globalpayments-perl<br class="gmail_msg">
 libbusiness-onlinepayment-ippay-perl
libbusiness-onlinepayment-openecho-perl<br class="gmail_msg">
 libbusiness-onlinepayment-payconnect-perl
libbusiness-onlinepayment-payflowpro-perl<br class="gmail_msg">
 libbusiness-onlinepayment-paymentech-perl
libbusiness-onlinepayment-tclink-perl<br class="gmail_msg">
 libbusiness-onlinepayment-transactioncentral-perl
libbusiness-onlinepayment-usaepay-perl<br class="gmail_msg">
 libbusiness-onlinepayment-viaklix-perl<br class="gmail_msg">
The following NEW packages will be installed:<br class="gmail_msg">
 libbusiness-onlinepayment-perl libdatetime-event-ical-perl
libdatetime-event-recurrence-perl<br class="gmail_msg">
 libdatetime-format-ical-perl libgeo-streetaddress-us-perl
librest-client-perl<br class="gmail_msg">
The following held packages will be changed:<br class="gmail_msg">
 freeside freeside-lib freeside-webui<br class="gmail_msg">
The following packages will be upgraded:<br class="gmail_msg">
 freeside freeside-lib freeside-webui<br class="gmail_msg">
3 upgraded, 6 newly installed, 0 to remove and 0 not upgraded.<br class="gmail_msg">
Need to get 9,180 kB of archives.<br class="gmail_msg">
After this operation, 1,044 kB of additional disk space will be
used.<br class="gmail_msg">
Do you want to continue? [Y/n] y<br class="gmail_msg">
WARNING: The following packages cannot be authenticated!<br class="gmail_msg">
 librest-client-perl libgeo-streetaddress-us-perl freeside-lib
freeside-webui freeside<br class="gmail_msg">
Install these packages without verification? [y/N] y<br class="gmail_msg">
Get:1 <a class="m_-5817128069316130829moz-txt-link-freetext gmail_msg" href="http://freeside.biz/~ivan/freeside-jessie/" target="_blank">http://freeside.biz/~ivan/freeside-jessie/</a> ./
librest-client-perl 273-1 [10.3 kB]<br class="gmail_msg"></p></div><div text="#000000" bgcolor="#FFFFFF" class="gmail_msg"><p class="gmail_msg">
Get:2 <a class="m_-5817128069316130829moz-txt-link-freetext gmail_msg" href="http://freeside.biz/~ivan/freeside-jessie/" target="_blank">http://freeside.biz/~ivan/freeside-jessie/</a> ./
libgeo-streetaddress-us-perl 1.3-3 [21.5 kB]<br class="gmail_msg">
Get:3 <a class="m_-5817128069316130829moz-txt-link-freetext gmail_msg" href="http://ftp.ca.debian.org/debian/" target="_blank">http://ftp.ca.debian.org/debian/</a> jessie/main
libdatetime-event-recurrence-perl all 0.16-1 [18.7 kB]<br class="gmail_msg">
Get:4 <a class="m_-5817128069316130829moz-txt-link-freetext gmail_msg" href="http://freeside.biz/~jeremyd/freeside4-jessie-stable/" target="_blank">http://freeside.biz/~jeremyd/freeside4-jessie-stable/</a> ./
freeside-lib 4.2-1 [5,589 kB]Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â <br class="gmail_msg">
Get:5 <a class="m_-5817128069316130829moz-txt-link-freetext gmail_msg" href="http://ftp.ca.debian.org/debian/" target="_blank">http://ftp.ca.debian.org/debian/</a> jessie/main
libdatetime-event-ical-perl all 0.12-1 [14.0 kB]<br class="gmail_msg">
Get:6 <a class="m_-5817128069316130829moz-txt-link-freetext gmail_msg" href="http://ftp.ca.debian.org/debian/" target="_blank">http://ftp.ca.debian.org/debian/</a> jessie/main
libdatetime-format-ical-perl all 0.09-1 [12.5 kB]</p></div><div text="#000000" bgcolor="#FFFFFF" class="gmail_msg"><p class="gmail_msg"><br class="gmail_msg">
Get:7 <a class="m_-5817128069316130829moz-txt-link-freetext gmail_msg" href="http://ftp.ca.debian.org/debian/" target="_blank">http://ftp.ca.debian.org/debian/</a> jessie/main
libbusiness-onlinepayment-perl all 3.03-1 [33.0 kB]<br class="gmail_msg">
Get:8 <a class="m_-5817128069316130829moz-txt-link-freetext gmail_msg" href="http://freeside.biz/~jeremyd/freeside4-jessie-stable/" target="_blank">http://freeside.biz/~jeremyd/freeside4-jessie-stable/</a> ./
freeside-webui 4.2-1 [2,902 kB]<br class="gmail_msg">
Get:9 <a class="m_-5817128069316130829moz-txt-link-freetext gmail_msg" href="http://freeside.biz/~jeremyd/freeside4-jessie-stable/" target="_blank">http://freeside.biz/~jeremyd/freeside4-jessie-stable/</a> ./
freeside 4.2-1 [579 kB]<br class="gmail_msg"></p></div><div text="#000000" bgcolor="#FFFFFF" class="gmail_msg"><p class="gmail_msg">
Fetched 9,180 kB in 1s (5,179 kB/s)</p></div><div text="#000000" bgcolor="#FFFFFF" class="gmail_msg"><p class="gmail_msg"><br class="gmail_msg">
Reading changelogs... Done<br class="gmail_msg">
Selecting previously unselected package
libdatetime-event-recurrence-perl.<br class="gmail_msg"></p></div><div text="#000000" bgcolor="#FFFFFF" class="gmail_msg"><p class="gmail_msg">
(Reading database ... 86797 files and directories currently
installed.)</p></div><div text="#000000" bgcolor="#FFFFFF" class="gmail_msg"><p class="gmail_msg"><br class="gmail_msg">
Preparing to unpack
.../libdatetime-event-recurrence-perl_0.16-1_all.deb ...<br class="gmail_msg">
Unpacking libdatetime-event-recurrence-perl (0.16-1) ...<br class="gmail_msg">
Selecting previously unselected package
libdatetime-event-ical-perl.<br class="gmail_msg">
Preparing to unpack .../libdatetime-event-ical-perl_0.12-1_all.deb
...<br class="gmail_msg">
Unpacking libdatetime-event-ical-perl (0.12-1) ...<br class="gmail_msg">
Selecting previously unselected package
libdatetime-format-ical-perl.<br class="gmail_msg">
Preparing to unpack
.../libdatetime-format-ical-perl_0.09-1_all.deb ...<br class="gmail_msg">
Unpacking libdatetime-format-ical-perl (0.09-1) ...<br class="gmail_msg">
Selecting previously unselected package librest-client-perl.<br class="gmail_msg">
Preparing to unpack .../librest-client-perl_273-1_all.deb ...<br class="gmail_msg">
Unpacking librest-client-perl (273-1) ...<br class="gmail_msg">
Selecting previously unselected package
libgeo-streetaddress-us-perl.<br class="gmail_msg">
Preparing to unpack .../libgeo-streetaddress-us-perl_1.3-3_all.deb
...<br class="gmail_msg">
Unpacking libgeo-streetaddress-us-perl (1.3-3) ...<br class="gmail_msg">
Selecting previously unselected package
libbusiness-onlinepayment-perl.<br class="gmail_msg">
Preparing to unpack
.../libbusiness-onlinepayment-perl_3.03-1_all.deb ...<br class="gmail_msg">
Unpacking libbusiness-onlinepayment-perl (3.03-1) ...<br class="gmail_msg">
Preparing to unpack .../freeside-lib_4.2-1_all.deb ...<br class="gmail_msg">
Unpacking freeside-lib (4.2-1) over (4.1-20160805) ...<br class="gmail_msg">
Preparing to unpack .../freeside-webui_4.2-1_all.deb ...<br class="gmail_msg">
Unpacking freeside-webui (4.2-1) over (4.1-20160805) ...<br class="gmail_msg">
Processing triggers for man-db (2.7.0.2-5) ...<br class="gmail_msg">
Setting up libdatetime-event-recurrence-perl (0.16-1) ...<br class="gmail_msg">
Setting up libdatetime-event-ical-perl (0.12-1) ...<br class="gmail_msg">
Setting up libdatetime-format-ical-perl (0.09-1) ...<br class="gmail_msg">
Setting up librest-client-perl (273-1) ...<br class="gmail_msg">
Setting up libgeo-streetaddress-us-perl (1.3-3) ...<br class="gmail_msg">
Setting up libbusiness-onlinepayment-perl (3.03-1) ...<br class="gmail_msg">
Setting up freeside-lib (4.2-1) ...<br class="gmail_msg">
Installing new version of config file
/opt/rt3/etc/RT_SiteConfig.pm ...<br class="gmail_msg">
texhash: Updating /usr/local/share/texmf/ls-R... <br class="gmail_msg">
texhash: Done.<br class="gmail_msg"></p></div><div text="#000000" bgcolor="#FFFFFF" class="gmail_msg"><p class="gmail_msg">
(Reading database ... 86882 files and directories currently
installed.)</p></div><div text="#000000" bgcolor="#FFFFFF" class="gmail_msg"><p class="gmail_msg"><br class="gmail_msg">
Preparing to unpack .../freeside_4.2-1_all.deb ...<br class="gmail_msg">
usermod: no changes<br class="gmail_msg">
Unpacking freeside (4.2-1) over (4.1-20160805) ...<br class="gmail_msg">
Processing triggers for systemd (215-17+deb8u6) ...<br class="gmail_msg">
Setting up freeside-webui (4.2-1) ...<br class="gmail_msg">
Installing new version of config file
/etc/apache2/conf-available/freeside-base2.4.conf ...<br class="gmail_msg">
Setting up freeside (4.2-1) ...<br class="gmail_msg"></p></div><div text="#000000" bgcolor="#FFFFFF" class="gmail_msg"><p class="gmail_msg">
root@freeside-dev:/home/ernied# /etc/init.d/apache2 stop<br class="gmail_msg">
[ ok ] Stopping apache2 (via systemctl): apache2.service.<br class="gmail_msg">
root@freeside-dev:/home/ernied# su freeside<br class="gmail_msg">
freeside@freeside-dev:/home/ernied$ freeside-upgrade freeside<br class="gmail_msg">
Subroutine JSON::XS::Boolean::(++ redefined at
/usr/share/perl/5.20/<a href="http://overload.pm" class="gmail_msg" target="_blank">overload.pm</a> line 50.<br class="gmail_msg">
Subroutine JSON::XS::Boolean::(0+ redefined at
/usr/share/perl/5.20/<a href="http://overload.pm" class="gmail_msg" target="_blank">overload.pm</a> line 50.<br class="gmail_msg">
Subroutine JSON::XS::Boolean::(-- redefined at
/usr/share/perl/5.20/<a href="http://overload.pm" class="gmail_msg" target="_blank">overload.pm</a> line 50.<br class="gmail_msg">
FS::part_event::Condition::payby is disabled; skipping<br class="gmail_msg">
Upgrade startup completed in 4 seconds<br class="gmail_msg">
UPDATE cust_main SET agent_custid = NULL where agent_custid = ''<br class="gmail_msg">
UPDATE h_cust_main SET agent_custid = NULL where agent_custid = ''<br class="gmail_msg">
<br class="gmail_msg">
     SELECT SETVAL( 'upgrade_journal_upgradenum_seq',<br class="gmail_msg">
                    ( SELECT MAX(upgradenum) FROM upgrade_journal
)<br class="gmail_msg">
                  )<br class="gmail_msg">
   <br class="gmail_msg">
Upgrading cust_bill_pkg_detail schema...<br class="gmail_msg">
 committing<br class="gmail_msg">
 done in 0 seconds<br class="gmail_msg">
Upgrading TicketSystem schema...<br class="gmail_msg">
 committing<br class="gmail_msg">
 done in 0 seconds<br class="gmail_msg">
Upgrading access_user_log schema...<br class="gmail_msg">
NOTICE:Â table "h_access_user_log" does not exist, skipping<br class="gmail_msg">
 committing<br class="gmail_msg">
 done in 0 seconds<br class="gmail_msg">
Upgrading password_history schema...<br class="gmail_msg">
 committing<br class="gmail_msg">
 done in 0 seconds<br class="gmail_msg">
Upgrading cust_pay_pending schema...<br class="gmail_msg">
 committing<br class="gmail_msg">
 done in 0 seconds<br class="gmail_msg">
Upgrading pkg_referral schema...<br class="gmail_msg">
 committing<br class="gmail_msg">
 done in 0 seconds<br class="gmail_msg">
Upgrading cust_bill_pkg_discount schema...<br class="gmail_msg">
 committing<br class="gmail_msg">
 done in 0 seconds<br class="gmail_msg">
Upgrading cust_msg schema...<br class="gmail_msg">
 committing<br class="gmail_msg">
 done in 0 seconds<br class="gmail_msg">
Upgrading cust_bill_pay_batch schema...<br class="gmail_msg">
 committing<br class="gmail_msg">
 done in 0 seconds<br class="gmail_msg">
Upgrading cust_event_fee schema...<br class="gmail_msg">
 committing<br class="gmail_msg">
 done in 0 seconds<br class="gmail_msg">
Upgrading radius_attr schema...<br class="gmail_msg">
 committing<br class="gmail_msg">
 done in 0 seconds<br class="gmail_msg">
Upgrading queue_depend schema...<br class="gmail_msg">
 committing<br class="gmail_msg">
 done in 0 seconds<br class="gmail_msg">
Upgrading cust_pkg schema...<br class="gmail_msg">
 committing<br class="gmail_msg">
 done in 0 seconds<br class="gmail_msg">
Custom fields schema upgrade completed at
/usr/bin/freeside-upgrade line 172.<br class="gmail_msg">
CREATE TABLE rt_field_charge (<br class="gmail_msg">
 rtfieldchargenum serial NOT NULL ,<br class="gmail_msg">
 pkgnum int NOT NULL ,<br class="gmail_msg">
 ticketid int NOT NULL ,<br class="gmail_msg">
 rate decimal(10,2) NOT NULL ,<br class="gmail_msg">
 units decimal(10,4) NOT NULL ,<br class="gmail_msg">
 charge decimal(10,2) NOT NULL ,<br class="gmail_msg">
 _date int  ,<br class="gmail_msg">
 PRIMARY KEY (rtfieldchargenum)<br class="gmail_msg">
)<br class="gmail_msg">
<br class="gmail_msg">
CREATEÂ INDEX rt_field_charge1 ON rt_field_charge ( pkgnum,
ticketid )<br class="gmail_msg">
CREATE TABLE saved_search (<br class="gmail_msg">
 searchnum serial NOT NULL ,<br class="gmail_msg">
 usernum int  ,<br class="gmail_msg">
 searchname varchar(80) NOT NULL ,<br class="gmail_msg">
 path varchar(80) NOT NULL ,<br class="gmail_msg">
 params text  ,<br class="gmail_msg">
 disabled char(1)  ,<br class="gmail_msg">
 freq varchar(16)  ,<br class="gmail_msg">
 last_sent int  ,<br class="gmail_msg">
 format varchar(32)  ,<br class="gmail_msg">
 PRIMARY KEY (searchnum)<br class="gmail_msg">
)<br class="gmail_msg">
<br class="gmail_msg">
ALTER TABLE h_cust_pay_pending ALTER COLUMN custnum DROP NOT NULL,
ADD COLUMN is_tokenized char(1)Â Â <br class="gmail_msg">
CREATEÂ INDEX h_cust_pay_pending8 ON h_cust_pay_pending (
is_tokenized )<br class="gmail_msg">
ALTER TABLE h_cdr_termination ADD COLUMN rated_granularity int  <br class="gmail_msg">
ALTER TABLE cdr ADD COLUMN src_lrn varchar(15)Â Â , ADD COLUMN
dst_lrn varchar(15)Â Â <br class="gmail_msg">
ALTER INDEX cdr10 RENAME TO dbs_temp1<br class="gmail_msg">
ALTER INDEX cdr9 RENAME TO dbs_temp2<br class="gmail_msg">
ALTER INDEX cdr16 RENAME TO dbs_temp3<br class="gmail_msg">
ALTER INDEX cdr8 RENAME TO dbs_temp4<br class="gmail_msg">
ALTER INDEX cdr12 RENAME TO dbs_temp5<br class="gmail_msg">
ALTER INDEX cdr7 RENAME TO dbs_temp6<br class="gmail_msg">
ALTER INDEX cdr15 RENAME TO dbs_temp7<br class="gmail_msg">
ALTER INDEX cdr20 RENAME TO dbs_temp8<br class="gmail_msg">
ALTER INDEX cdr11 RENAME TO dbs_temp9<br class="gmail_msg">
ALTER INDEX cdr17 RENAME TO dbs_temp10<br class="gmail_msg">
ALTER INDEX cdr18 RENAME TO dbs_temp11<br class="gmail_msg">
ALTER INDEX cdr6 RENAME TO dbs_temp12<br class="gmail_msg">
ALTER INDEX cdr19 RENAME TO dbs_temp13<br class="gmail_msg">
ALTER INDEX cdr14 RENAME TO dbs_temp14<br class="gmail_msg">
ALTER INDEX cdr13 RENAME TO dbs_temp15<br class="gmail_msg">
CREATEÂ INDEX cdr8 ON cdr ( cdrtypenum )<br class="gmail_msg">
CREATEÂ INDEX cdr9 ON cdr ( calltypenum )<br class="gmail_msg">
CREATEÂ INDEX cdr7 ON cdr ( duration )<br class="gmail_msg">
CREATEÂ INDEX cdr6 ON cdr ( startdate )<br class="gmail_msg">
ALTER INDEX dbs_temp1 RENAME TO cdr14<br class="gmail_msg">
ALTER INDEX dbs_temp2 RENAME TO cdr13<br class="gmail_msg">
ALTER INDEX dbs_temp3 RENAME TO cdr20<br class="gmail_msg">
ALTER INDEX dbs_temp4 RENAME TO cdr12<br class="gmail_msg">
ALTER INDEX dbs_temp5 RENAME TO cdr16<br class="gmail_msg">
ALTER INDEX dbs_temp6 RENAME TO cdr11<br class="gmail_msg">
ALTER INDEX dbs_temp7 RENAME TO cdr19<br class="gmail_msg">
ALTER INDEX dbs_temp8 RENAME TO cdr24<br class="gmail_msg">
ALTER INDEX dbs_temp9 RENAME TO cdr15<br class="gmail_msg">
ALTER INDEX dbs_temp10 RENAME TO cdr21<br class="gmail_msg">
ALTER INDEX dbs_temp11 RENAME TO cdr22<br class="gmail_msg">
ALTER INDEX dbs_temp12 RENAME TO cdr10<br class="gmail_msg">
ALTER INDEX dbs_temp13 RENAME TO cdr23<br class="gmail_msg">
ALTER INDEX dbs_temp14 RENAME TO cdr18<br class="gmail_msg">
ALTER INDEX dbs_temp15 RENAME TO cdr17<br class="gmail_msg">
ALTER TABLE cdr_termination ADD COLUMN rated_granularity int  <br class="gmail_msg">
CREATE TABLE h_rt_field_charge (<br class="gmail_msg">
 historynum serial NOT NULL ,<br class="gmail_msg">
 history_date int  ,<br class="gmail_msg">
 history_user varchar(80)  ,<br class="gmail_msg">
 history_usernum int  ,<br class="gmail_msg">
 history_action varchar(80) NOT NULL ,<br class="gmail_msg">
 rtfieldchargenum INT  ,<br class="gmail_msg">
 pkgnum int NOT NULL ,<br class="gmail_msg">
 ticketid int NOT NULL ,<br class="gmail_msg">
 rate decimal(10,2) NOT NULL ,<br class="gmail_msg">
 units decimal(10,4) NOT NULL ,<br class="gmail_msg">
 charge decimal(10,2) NOT NULL ,<br class="gmail_msg">
 _date int  ,<br class="gmail_msg">
 PRIMARY KEY (historynum)<br class="gmail_msg">
)<br class="gmail_msg">
<br class="gmail_msg">
CREATEÂ INDEX h_rt_field_charge1 ON h_rt_field_charge ( pkgnum,
ticketid )<br class="gmail_msg">
CREATEÂ INDEX h_rt_field_charge_srckey2 ON h_rt_field_charge (
history_date, rtfieldchargenum )<br class="gmail_msg">
CREATEÂ INDEX h_rt_field_charge_user ON h_rt_field_charge (
history_user )<br class="gmail_msg">
CREATEÂ INDEX h_rt_field_charge_usernum ON h_rt_field_charge (
history_usernum )<br class="gmail_msg">
CREATEÂ INDEX h_rt_field_charge_srckey ON h_rt_field_charge (
history_action, rtfieldchargenum )<br class="gmail_msg">
ALTER TABLE h_cust_refund ADD COLUMN is_tokenized char(1)Â Â <br class="gmail_msg">
CREATEÂ INDEX h_cust_refund4 ON h_cust_refund ( is_tokenized )<br class="gmail_msg">
ALTER TABLE cust_main ADD COLUMN paycardtype varchar(80)Â Â , ADD
COLUMN is_tokenized char(1)Â Â , ADD COLUMN force_prorate_day
char(1)Â Â <br class="gmail_msg">
CREATEÂ INDEX cust_main13 ON cust_main ( paycardtype )<br class="gmail_msg">
CREATEÂ INDEX cust_main14 ON cust_main ( is_tokenized )<br class="gmail_msg">
ALTER TABLE part_referral ADD COLUMN title varchar(80)Â Â <br class="gmail_msg">
ALTER INDEX part_referral2 RENAME TO dbs_temp1<br class="gmail_msg">
ALTER INDEX part_referral1 RENAME TO dbs_temp2<br class="gmail_msg">
CREATE UNIQUE INDEX part_referral1 ON part_referral ( agentnum,
title )<br class="gmail_msg">
ALTER INDEX dbs_temp1 RENAME TO part_referral3<br class="gmail_msg">
ALTER INDEX dbs_temp2 RENAME TO part_referral2<br class="gmail_msg">
ALTER TABLE cacti_page ADD COLUMN thumbnail text  <br class="gmail_msg">
ALTER TABLE cust_pay_pending ALTER COLUMN custnum DROP NOT NULL,
ADD COLUMN is_tokenized char(1)Â Â <br class="gmail_msg">
CREATEÂ INDEX cust_pay_pending8 ON cust_pay_pending ( is_tokenized
)<br class="gmail_msg">
ALTER TABLE h_part_referral ADD COLUMN title varchar(80)Â Â <br class="gmail_msg">
ALTER INDEX h_part_referral2 RENAME TO dbs_temp1<br class="gmail_msg">
ALTER INDEX h_part_referral1 RENAME TO dbs_temp2<br class="gmail_msg">
CREATEÂ INDEX h_part_referral1 ON h_part_referral ( agentnum,
title )<br class="gmail_msg">
ALTER INDEX dbs_temp1 RENAME TO h_part_referral3<br class="gmail_msg">
ALTER INDEX dbs_temp2 RENAME TO h_part_referral2<br class="gmail_msg">
ALTER TABLE svc_phone ADD COLUMN lnp_portid varchar(80)Â Â , ADD
COLUMN lnp_signature char(1)Â Â , ADD COLUMN lnp_bill char(1)Â Â <br class="gmail_msg">
ALTER TABLE cust_pay_void ADD COLUMN is_tokenized char(1)Â Â <br class="gmail_msg">
CREATEÂ INDEX cust_pay_void4 ON cust_pay_void ( is_tokenized )<br class="gmail_msg">
ALTER TABLE cust_pay ADD COLUMN is_tokenized char(1)Â Â <br class="gmail_msg">
CREATEÂ INDEX cust_pay6 ON cust_pay ( is_tokenized )<br class="gmail_msg">
CREATE TABLE h_saved_search (<br class="gmail_msg">
 historynum serial NOT NULL ,<br class="gmail_msg">
 history_date int  ,<br class="gmail_msg">
 history_user varchar(80)  ,<br class="gmail_msg">
 history_usernum int  ,<br class="gmail_msg">
 history_action varchar(80) NOT NULL ,<br class="gmail_msg">
 searchnum INT  ,<br class="gmail_msg">
 usernum int  ,<br class="gmail_msg">
 searchname varchar(80) NOT NULL ,<br class="gmail_msg">
 path varchar(80) NOT NULL ,<br class="gmail_msg">
 params text  ,<br class="gmail_msg">
 disabled char(1)  ,<br class="gmail_msg">
 freq varchar(16)  ,<br class="gmail_msg">
 last_sent int  ,<br class="gmail_msg">
 format varchar(32)  ,<br class="gmail_msg">
 PRIMARY KEY (historynum)<br class="gmail_msg">
)<br class="gmail_msg">
<br class="gmail_msg">
CREATEÂ INDEX h_saved_search_user ON h_saved_search ( history_user
)<br class="gmail_msg">
CREATEÂ INDEX h_saved_search_srckey2 ON h_saved_search (
history_date, searchnum )<br class="gmail_msg">
CREATEÂ INDEX h_saved_search_usernum ON h_saved_search (
history_usernum )<br class="gmail_msg">
CREATEÂ INDEX h_saved_search_srckey ON h_saved_search (
history_action, searchnum )<br class="gmail_msg">
ALTER TABLE cust_payby ADD COLUMN is_tokenized char(1)Â Â <br class="gmail_msg">
CREATEÂ INDEX cust_payby2 ON cust_payby ( is_tokenized )<br class="gmail_msg">
ALTER TABLE h_cust_pay_void ADD COLUMN is_tokenized char(1)Â Â <br class="gmail_msg">
CREATEÂ INDEX h_cust_pay_void4 ON h_cust_pay_void ( is_tokenized )<br class="gmail_msg">
ALTER TABLE h_svc_phone ADD COLUMN lnp_portid varchar(80)Â Â , ADD
COLUMN lnp_signature char(1)Â Â , ADD COLUMN lnp_bill char(1)Â Â <br class="gmail_msg">
ALTER TABLE cust_refund ADD COLUMN is_tokenized char(1)Â Â <br class="gmail_msg">
CREATEÂ INDEX cust_refund4 ON cust_refund ( is_tokenized )<br class="gmail_msg">
ALTER TABLE h_cdr ADD COLUMN src_lrn varchar(15)Â Â , ADD COLUMN
dst_lrn varchar(15)Â Â <br class="gmail_msg">
ALTER TABLE h_cust_pay ADD COLUMN is_tokenized char(1)Â Â <br class="gmail_msg">
CREATEÂ INDEX h_cust_pay6 ON h_cust_pay ( is_tokenized )<br class="gmail_msg">
ALTER TABLE h_cust_main ADD COLUMN paycardtype varchar(80)Â Â , ADD
COLUMN is_tokenized char(1)Â Â , ADD COLUMN force_prorate_day
char(1)Â Â <br class="gmail_msg">
CREATEÂ INDEX h_cust_main13 ON h_cust_main ( paycardtype )<br class="gmail_msg">
CREATEÂ INDEX h_cust_main14 ON h_cust_main ( is_tokenized )<br class="gmail_msg">
ALTER TABLE h_cust_payby ADD COLUMN is_tokenized char(1)Â Â <br class="gmail_msg">
CREATEÂ INDEX h_cust_payby2 ON h_cust_payby ( is_tokenized )<br class="gmail_msg">
ALTER TABLE rt_field_charge ADD FOREIGN KEY ( pkgnum ) REFERENCES
cust_pkg ( pkgnum ) <br class="gmail_msg">
<br class="gmail_msg">
</p></div><div text="#000000" bgcolor="#FFFFFF" class="gmail_msg">
<br class="gmail_msg">
<div class="m_-5817128069316130829moz-cite-prefix gmail_msg">On 2017-03-27 06:09 PM, John Wilson
wrote:<br class="gmail_msg">
</div>
<blockquote type="cite" class="gmail_msg">
<p dir="ltr" class="gmail_msg">Run Freeside upgrade script again to update database
tables to new version. You ran it before you updated packages.</p>
<br class="gmail_msg">
<div class="gmail_quote gmail_msg">
<div dir="ltr" class="gmail_msg">On Mon, Mar 27, 2017, 3:16 PM Ernie Dunbar <<a href="mailto:maillist@lightspeed.ca" class="gmail_msg" target="_blank">maillist@lightspeed.ca</a>>
wrote:<br class="gmail_msg">
</div>
<blockquote class="gmail_quote gmail_msg" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF" class="gmail_msg">
<p class="gmail_msg">Hi everyone.</p>
<p class="gmail_msg">With the failure of the upgrade to v4.2
in my previous message, I did some poking around and found
that several apt upgrades were being held back:<br class="gmail_msg">
<br class="gmail_msg">
root@freeside:/home/ernied# apt-get upgrade<br class="gmail_msg">
Reading package lists... Done<br class="gmail_msg">
Building dependency tree      <br class="gmail_msg">
Reading state information... Done<br class="gmail_msg">
Calculating upgrade... Done<br class="gmail_msg">
<b class="gmail_msg">The following packages have been kept
back:</b><b class="gmail_msg"><br class="gmail_msg">
</b><b class="gmail_msg">Â freeside freeside-lib
freeside-webui</b><b class="gmail_msg"><br class="gmail_msg">
</b><b class="gmail_msg">The following packages will be
upgraded:</b><b class="gmail_msg"><br class="gmail_msg">
</b><b class="gmail_msg">Â libjbig2dec0</b><br class="gmail_msg">
1 upgraded, 0 newly installed, 0 to remove and 3 not
upgraded.<br class="gmail_msg">
Need to get 60.1 kB of archives.<br class="gmail_msg">
After this operation, 43.0 kB of additional disk space
will be used.<br class="gmail_msg">
Do you want to continue? [Y/n] y<br class="gmail_msg">
Get:1 <a class="m_-5817128069316130829m_-4045307787267181161moz-txt-link-freetext gmail_msg" href="http://security.debian.org/" target="_blank">http://security.debian.org/</a>
jessie/updates/main libjbig2dec0 amd64 0.13-4~deb8u1 [60.1
kB]<br class="gmail_msg">
Fetched 60.1 kB in 0s (208 kB/s)Â <br class="gmail_msg">
Reading changelogs... Done<br class="gmail_msg">
apt-listchanges: Mailing root: apt-listchanges: news for
freeside<br class="gmail_msg">
(Reading database ... 87774 files and directories
currently installed.)<br class="gmail_msg">
Preparing to unpack
.../libjbig2dec0_0.13-4~deb8u1_amd64.deb ...<br class="gmail_msg">
Unpacking libjbig2dec0 (0.13-4~deb8u1) over
(0.11+20120125-1) ...<br class="gmail_msg">
Setting up libjbig2dec0 (0.13-4~deb8u1) ...<br class="gmail_msg">
Processing triggers for libc-bin (2.19-18+deb8u7) ...<br class="gmail_msg">
</p>
<p class="gmail_msg">So I stupidly went ahead and installed
them, hoping that it would make the upgrade to v4.2
actually work:<br class="gmail_msg">
<br class="gmail_msg">
root@freeside:/home/ernied# apt-get install freeside
freeside-lib freeside-webui<br class="gmail_msg">
Reading package lists... Done<br class="gmail_msg">
Building dependency tree      <br class="gmail_msg">
Reading state information... Done<br class="gmail_msg">
The following extra packages will be installed:<br class="gmail_msg">
 libbusiness-onlinepayment-perl
libdatetime-event-ical-perl
libdatetime-event-recurrence-perl
libdatetime-format-ical-perl libgeo-streetaddress-us-perl
librest-client-perl<br class="gmail_msg">
Suggested packages:<br class="gmail_msg">
 libbusiness-onlinepayment-authorizenet-perl
libbusiness-onlinepayment-globalpayments-perl
libbusiness-onlinepayment-ippay-perl
libbusiness-onlinepayment-openecho-perl
libbusiness-onlinepayment-payconnect-perl<br class="gmail_msg">
 libbusiness-onlinepayment-payflowpro-perl
libbusiness-onlinepayment-paymentech-perl
libbusiness-onlinepayment-tclink-perl
libbusiness-onlinepayment-transactioncentral-perl
libbusiness-onlinepayment-usaepay-perl<br class="gmail_msg">
 libbusiness-onlinepayment-viaklix-perl<br class="gmail_msg">
The following NEW packages will be installed:<br class="gmail_msg">
 libbusiness-onlinepayment-perl
libdatetime-event-ical-perl
libdatetime-event-recurrence-perl
libdatetime-format-ical-perl libgeo-streetaddress-us-perl
librest-client-perl<br class="gmail_msg">
The following held packages will be changed:<br class="gmail_msg">
 freeside freeside-lib freeside-webui<br class="gmail_msg">
The following packages will be upgraded:<br class="gmail_msg">
 freeside freeside-lib freeside-webui<br class="gmail_msg">
3 upgraded, 6 newly installed, 0 to remove and 0 not
upgraded.<br class="gmail_msg">
Need to get 9,180 kB of archives.<br class="gmail_msg">
After this operation, 1,044 kB of additional disk space
will be used.<br class="gmail_msg">
Do you want to continue? [Y/n] y<br class="gmail_msg">
WARNING: The following packages cannot be authenticated!<br class="gmail_msg">
 librest-client-perl libgeo-streetaddress-us-perl
freeside-lib freeside-webui freeside<br class="gmail_msg">
Install these packages without verification? [y/N] y<br class="gmail_msg">
Get:1 <a class="m_-5817128069316130829m_-4045307787267181161moz-txt-link-freetext gmail_msg" href="http://freeside.biz/%7Eivan/freeside-jessie/" target="_blank">http://freeside.biz/~ivan/freeside-jessie/</a>
./ librest-client-perl 273-1 [10.3 kB]<br class="gmail_msg">
Get:2 <a class="m_-5817128069316130829m_-4045307787267181161moz-txt-link-freetext gmail_msg" href="http://ftp.ca.debian.org/debian/" target="_blank">http://ftp.ca.debian.org/debian/</a>
jessie/main libdatetime-event-recurrence-perl all 0.16-1
[18.7 kB]<br class="gmail_msg">
Get:3 <a class="m_-5817128069316130829m_-4045307787267181161moz-txt-link-freetext gmail_msg" href="http://freeside.biz/%7Eivan/freeside-jessie/" target="_blank">http://freeside.biz/~ivan/freeside-jessie/</a>
./ libgeo-streetaddress-us-perl 1.3-3 [21.5 kB]<br class="gmail_msg">
Get:4 <a class="m_-5817128069316130829m_-4045307787267181161moz-txt-link-freetext gmail_msg" href="http://ftp.ca.debian.org/debian/" target="_blank">http://ftp.ca.debian.org/debian/</a>
jessie/main libdatetime-event-ical-perl all 0.12-1 [14.0
kB]<br class="gmail_msg">
Get:5 <a class="m_-5817128069316130829m_-4045307787267181161moz-txt-link-freetext gmail_msg" href="http://ftp.ca.debian.org/debian/" target="_blank">http://ftp.ca.debian.org/debian/</a>
jessie/main libdatetime-format-ical-perl all 0.09-1 [12.5
kB]Â <br class="gmail_msg">
Get:6 <a class="m_-5817128069316130829m_-4045307787267181161moz-txt-link-freetext gmail_msg" href="http://freeside.biz/%7Ejeremyd/freeside4-jessie-stable/" target="_blank">http://freeside.biz/~jeremyd/freeside4-jessie-stable/</a>
./ freeside-lib 4.2-1 [5,589 kB]<br class="gmail_msg">
Get:7 <a class="m_-5817128069316130829m_-4045307787267181161moz-txt-link-freetext gmail_msg" href="http://ftp.ca.debian.org/debian/" target="_blank">http://ftp.ca.debian.org/debian/</a>
jessie/main libbusiness-onlinepayment-perl all 3.03-1
[33.0 kB]<br class="gmail_msg">
Get:8 <a class="m_-5817128069316130829m_-4045307787267181161moz-txt-link-freetext gmail_msg" href="http://freeside.biz/%7Ejeremyd/freeside4-jessie-stable/" target="_blank">http://freeside.biz/~jeremyd/freeside4-jessie-stable/</a>
./ freeside-webui 4.2-1 [2,902
kB]Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
<br class="gmail_msg">
Get:9 <a class="m_-5817128069316130829m_-4045307787267181161moz-txt-link-freetext gmail_msg" href="http://freeside.biz/%7Ejeremyd/freeside4-jessie-stable/" target="_blank">http://freeside.biz/~jeremyd/freeside4-jessie-stable/</a>
./ freeside 4.2-1 [579
kB]Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
<br class="gmail_msg">
Fetched 9,180 kB in 30s (297
kB/s)Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â
<br class="gmail_msg">
Reading changelogs... Done<br class="gmail_msg">
Selecting previously unselected package
libdatetime-event-recurrence-perl.<br class="gmail_msg">
(Reading database ... 87775 files and directories
currently installed.)<br class="gmail_msg">
Preparing to unpack
.../libdatetime-event-recurrence-perl_0.16-1_all.deb ...<br class="gmail_msg">
Unpacking libdatetime-event-recurrence-perl (0.16-1) ...<br class="gmail_msg">
Selecting previously unselected package
libdatetime-event-ical-perl.<br class="gmail_msg">
Preparing to unpack
.../libdatetime-event-ical-perl_0.12-1_all.deb ...<br class="gmail_msg">
Unpacking libdatetime-event-ical-perl (0.12-1) ...<br class="gmail_msg">
Selecting previously unselected package
libdatetime-format-ical-perl.<br class="gmail_msg">
Preparing to unpack
.../libdatetime-format-ical-perl_0.09-1_all.deb ...<br class="gmail_msg">
Unpacking libdatetime-format-ical-perl (0.09-1) ...<br class="gmail_msg">
Selecting previously unselected package
librest-client-perl.<br class="gmail_msg">
Preparing to unpack .../librest-client-perl_273-1_all.deb
...<br class="gmail_msg">
Unpacking librest-client-perl (273-1) ...<br class="gmail_msg">
Selecting previously unselected package
libgeo-streetaddress-us-perl.<br class="gmail_msg">
Preparing to unpack
.../libgeo-streetaddress-us-perl_1.3-3_all.deb ...<br class="gmail_msg">
Unpacking libgeo-streetaddress-us-perl (1.3-3) ...<br class="gmail_msg">
Selecting previously unselected package
libbusiness-onlinepayment-perl.<br class="gmail_msg">
Preparing to unpack
.../libbusiness-onlinepayment-perl_3.03-1_all.deb ...<br class="gmail_msg">
Unpacking libbusiness-onlinepayment-perl (3.03-1) ...<br class="gmail_msg">
Preparing to unpack .../freeside-lib_4.2-1_all.deb ...<br class="gmail_msg">
Unpacking freeside-lib (4.2-1) over (4.1-20160805) ...<br class="gmail_msg">
Preparing to unpack .../freeside-webui_4.2-1_all.deb ...<br class="gmail_msg">
Unpacking freeside-webui (4.2-1) over (4.1-20160805) ...<br class="gmail_msg">
Processing triggers for man-db (2.7.0.2-5) ...<br class="gmail_msg">
Setting up libdatetime-event-recurrence-perl (0.16-1) ...<br class="gmail_msg">
Setting up libdatetime-event-ical-perl (0.12-1) ...<br class="gmail_msg">
Setting up libdatetime-format-ical-perl (0.09-1) ...<br class="gmail_msg">
Setting up librest-client-perl (273-1) ...<br class="gmail_msg">
Setting up libgeo-streetaddress-us-perl (1.3-3) ...<br class="gmail_msg">
Setting up libbusiness-onlinepayment-perl (3.03-1) ...<br class="gmail_msg">
Setting up freeside-lib (4.2-1) ...<br class="gmail_msg">
Installing new version of config file
/opt/rt3/etc/RT_SiteConfig.pm ...<br class="gmail_msg">
texhash: Updating /usr/local/share/texmf/ls-R... <br class="gmail_msg">
texhash: Done.<br class="gmail_msg">
(Reading database ... 87860 files and directories
currently installed.)<br class="gmail_msg">
Preparing to unpack .../freeside_4.2-1_all.deb ...<br class="gmail_msg">
usermod: no changes<br class="gmail_msg">
Unpacking freeside (4.2-1) over (4.1-20160805) ...<br class="gmail_msg">
Processing triggers for systemd (215-17+deb8u6) ...<br class="gmail_msg">
Setting up freeside-webui (4.2-1) ...<br class="gmail_msg">
Installing new version of config file
/etc/apache2/conf-available/freeside-base2.4.conf ...<br class="gmail_msg">
Setting up freeside (4.2-1) ...<br class="gmail_msg">
root@freeside:/home/ernied# /etc/init.d/apache2 restart<br class="gmail_msg">
[ ok ] Restarting apache2 (via systemctl):
apache2.service.<br class="gmail_msg">
</p>
<p class="gmail_msg">Well, this is now what the Freeside
login page looks like:<br class="gmail_msg">
<br class="gmail_msg">
</p>
<p class="gmail_msg" align="center"><font class="gmail_msg" face="Verdana, Arial, Helvetica, sans-serif"><b class="gmail_msg">System error</b></font></p>
<table class="gmail_msg" cellpadding="1" cellspacing="0" border="0">
<tbody class="gmail_msg">
<tr class="gmail_msg">
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica, sans-serif"><b class="gmail_msg">error:</b>Â </font></td>
<td class="gmail_msg" valign="top" align="left"><font class="gmail_msg" size="-2" face="Verdana, Arial,
Helvetica, sans-serif">Can't call method
"disabled" without a package or object reference
at /var/www/html/freeside/elements/menu.html line
92.<br class="gmail_msg">
</font></td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica, sans-serif"><b class="gmail_msg">context:</b>Â </font></td>
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica, sans-serif">
<table class="gmail_msg" cellpadding="0" cellspacing="0" border="0">
<tbody class="gmail_msg">
<tr class="gmail_msg">
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">...</b>Â </font></td>
<td class="gmail_msg" valign="top" align="left" nowrap><br class="gmail_msg">
</td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">88:</b>Â </font></td>
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica,
sans-serif">my $curuser =
$FS::CurrentUser::CurrentUser;</font></td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">89:</b>Â </font></td>
<td class="gmail_msg" valign="top" align="left" nowrap><br class="gmail_msg">
</td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">90:</b>Â </font></td>
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica,
sans-serif"># saved searches</font></td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">91:</b>Â </font></td>
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica,
sans-serif">tie my
%report_saved_searches, 'Tie::IxHash';</font></td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">92:</b>Â </font></td>
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica,
sans-serif"><font class="gmail_msg" color="red">if ( my @searches = grep {
$_->disabled eq '' }
$curuser->saved_search ) {</font></font></td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">93:</b>Â </font></td>
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica,
sans-serif">foreach my $search
(@searches) {</font></td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">94:</b>Â </font></td>
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica,
sans-serif">$report_saved_searches{
$search->searchname } = [</font></td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">95:</b>Â </font></td>
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica,
sans-serif"># don't use query_string
here; we don't want to override the
format</font></td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">96:</b>Â </font></td>
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica,
sans-serif">$fsurl . $search->path .
'?' . $search->params , ''</font></td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica,
sans-serif"><b class="gmail_msg">...</b>Â </font></td>
<td class="gmail_msg" valign="top" align="left" nowrap><br class="gmail_msg">
</td>
</tr>
</tbody>
</table>
</font></td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica, sans-serif"><b class="gmail_msg">code stack:</b>Â </font></td>
<td class="gmail_msg" valign="top" align="left" nowrap><font class="gmail_msg" size="-2" face="Verdana, Arial, Helvetica, sans-serif">/var/www/html/freeside/elements/menu.html:92<br class="gmail_msg">
/usr/share/perl5/FS/Mason.pm:527<br class="gmail_msg">
/var/www/html/freeside/elements/header-full.html:44<br class="gmail_msg">
/var/www/html/freeside/elements/header.html:5<br class="gmail_msg">
/var/www/html/freeside/index.html:4<br class="gmail_msg">
/var/www/html/freeside/autohandler:1<br class="gmail_msg">
</font></td>
</tr>
</tbody>
</table>
<a href="https://freeside.lightspeed.ca/freeside/index.html#raw" class="gmail_msg" target="_blank">raw error</a><br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<br class="gmail_msg">
<a name="m_-5817128069316130829_m_-4045307787267181161_raw" class="gmail_msg"></a><span class="gmail_msg"></span>
<pre style="color:rgb(0,0,0);font-style:normal;font-variant-ligatures:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;word-spacing:0px;text-decoration-style:initial;text-decoration-color:initial" class="gmail_msg">Can't call method "disabled" without a package or object reference at /var/www/html/freeside/elements/menu.html line 92.
Trace begun at /usr/share/perl5/HTML/Mason/Exceptions.pm line 129
HTML::Mason::Exceptions::rethrow_exception('Can\'t call method "disabled" without a package or object reference at /var/www/html/freeside/elements/menu.html line 92.^J') called at /var/www/html/freeside/elements/menu.html line 92
HTML::Mason::Commands::__ANON__('freeside_baseurl', '<a class="m_-5817128069316130829m_-4045307787267181161moz-txt-link-freetext gmail_msg" href="https://freeside.lightspeed.ca/freeside/" target="_blank">https://freeside.lightspeed.ca/freeside/</a>', 'position', 'top', 'nocss', 0, 'mobile', '') called at /usr/share/perl5/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fde554059e8)', 'freeside_baseurl', '<a class="m_-5817128069316130829m_-4045307787267181161moz-txt-link-freetext gmail_msg" href="https://freeside.lightspeed.ca/freeside/" target="_blank">https://freeside.lightspeed.ca/freeside/</a>', 'position', 'top', 'nocss', 0, 'mobile', '') called at /usr/share/perl5/HTML/Mason/Request.pm line 1305
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, undef, 'freeside_baseurl', '<a class="m_-5817128069316130829m_-4045307787267181161moz-txt-link-freetext gmail_msg" href="https://freeside.lightspeed.ca/freeside/" target="_blank">https://freeside.lightspeed.ca/freeside/</a>', 'position', 'top', 'nocss', 0, 'mobile', '') called at /usr/share/perl5/HTML/Mason/Request.pm line 1358
HTML::Mason::Request::scomp('FS::Mason::Request=HASH(0x7fde55371490)', 'menu.html', 'freeside_baseurl', '<a class="m_-5817128069316130829m_-4045307787267181161moz-txt-link-freetext gmail_msg" href="https://freeside.lightspeed.ca/freeside/" target="_blank">https://freeside.lightspeed.ca/freeside/</a>', 'position', 'top', 'nocss', 0, 'mobile', '') called at /usr/share/perl5/FS/Mason.pm line 527
HTML::Mason::Commands::include('menu.html', 'freeside_baseurl', '<a class="m_-5817128069316130829m_-4045307787267181161moz-txt-link-freetext gmail_msg" href="https://freeside.lightspeed.ca/freeside/" target="_blank">https://freeside.lightspeed.ca/freeside/</a>', 'position', 'top', 'nocss', 0, 'mobile', '') called at /var/www/html/freeside/elements/header-full.html line 44
HTML::Mason::Commands::__ANON__('Billing Main') called at /usr/share/perl5/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fde55410d90)', 'Billing Main') called at /usr/share/perl5/HTML/Mason/Request.pm line 1305
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, 'Billing Main') called at /var/www/html/freeside/elements/header.html line 5
HTML::Mason::Commands::__ANON__('Billing Main') called at /usr/share/perl5/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fde553de850)', 'Billing Main') called at /usr/share/perl5/HTML/Mason/Request.pm line 1305
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, 'Billing Main') called at /var/www/html/freeside/index.html line 4
HTML::Mason::Commands::__ANON__ at /usr/share/perl5/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fde553751b8)') called at /usr/share/perl5/HTML/Mason/Request.pm line 1305
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, undef) called at /usr/share/perl5/HTML/Mason/Request.pm line 958
HTML::Mason::Request::call_next('FS::Mason::Request=HASH(0x7fde55371490)') called at /var/www/html/freeside/autohandler line 1
HTML::Mason::Commands::__ANON__ at /usr/share/perl5/HTML/Mason/Component.pm line 138
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x7fde553c4308)') called at /usr/share/perl5/HTML/Mason/Request.pm line 1303
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 1295
HTML::Mason::Request::comp(undef, undef, undef) called at /usr/share/perl5/HTML/Mason/Request.pm line 484
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 484
eval {...} at /usr/share/perl5/HTML/Mason/Request.pm line 436
HTML::Mason::Request::exec('FS::Mason::Request=HASH(0x7fde55371490)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 165
HTML::Mason::Request::ApacheHandler::exec('FS::Mason::Request=HASH(0x7fde55371490)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 831
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x7fde51d7c150)', 'Apache2::RequestRec=SCALAR(0x7fde528bc488)') called at /usr/local/etc/freeside/<a href="http://handler.pl" class="gmail_msg" target="_blank">handler.pl</a> line 153
eval {...} at /usr/local/etc/freeside/<a href="http://handler.pl" class="gmail_msg" target="_blank">handler.pl</a> line 153
HTML::Mason::handler('Apache2::RequestRec=SCALAR(0x7fde528bc488)') called at -e line 0
eval {...} at -e line 0</pre>
<p class="gmail_msg">It's a good thing that we're not in
production quite yet!</p>
<p class="gmail_msg">Any help would be appreciated.<br class="gmail_msg">
</p>
</div>
_______________________________________________<br class="gmail_msg">
freeside-users mailing list<br class="gmail_msg">
<a href="mailto:freeside-users@freeside.biz" class="gmail_msg" target="_blank">freeside-users@freeside.biz</a><br class="gmail_msg">
<a href="http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users" rel="noreferrer" class="gmail_msg" target="_blank">http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users</a><br class="gmail_msg">
</blockquote>
</div>
<br class="gmail_msg">
<fieldset class="m_-5817128069316130829mimeAttachmentHeader gmail_msg"></fieldset>
<br class="gmail_msg">
<pre class="gmail_msg">_______________________________________________
freeside-users mailing list
<a class="m_-5817128069316130829moz-txt-link-abbreviated gmail_msg" href="mailto:freeside-users@freeside.biz" target="_blank">freeside-users@freeside.biz</a>
<a class="m_-5817128069316130829moz-txt-link-freetext gmail_msg" href="http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users" target="_blank">http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users</a>
</pre>
</blockquote>
<br class="gmail_msg">
</div>
_______________________________________________<br class="gmail_msg">
freeside-users mailing list<br class="gmail_msg">
<a href="mailto:freeside-users@freeside.biz" class="gmail_msg" target="_blank">freeside-users@freeside.biz</a><br class="gmail_msg">
<a href="http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users" rel="noreferrer" class="gmail_msg" target="_blank">http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users</a><br class="gmail_msg">
</blockquote></div>