<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>The documentation at <a
href="http://www.freeside.biz/mediawiki/index.php/Freeside:4:Documentation:Upgrading">http://www.freeside.biz/mediawiki/index.php/Freeside:4:Documentation:Upgrading</a>
says nothing about stopping freeside. You might want to add that
step.<br>
</p>
<br>
<div class="moz-cite-prefix">On 2017-03-30 06:45 PM, John Wilson
wrote:<br>
</div>
<blockquote
cite="mid:CAK2OcwUDr3BSXqiW=3R82JShoxxmcVb_8LzvRbEn4TQzYajswg@mail.gmail.com"
type="cite">
<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
moz-do-not-send="true" 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 moz-do-not-send="true"
class="m_-5817128069316130829moz-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">
</p>
</div>
<div text="#000000" bgcolor="#FFFFFF" class="gmail_msg">
<p class="gmail_msg"> Get:2 <a moz-do-not-send="true"
class="m_-5817128069316130829moz-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:3 <a moz-do-not-send="true"
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 moz-do-not-send="true"
class="m_-5817128069316130829moz-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:5 <a moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
class="m_-5817128069316130829moz-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 moz-do-not-send="true"
class="m_-5817128069316130829moz-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">
</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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
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="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="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="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="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="nowrap"><br
class="gmail_msg">
</td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top"
align="left" nowrap="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="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="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="nowrap"><br
class="gmail_msg">
</td>
</tr>
<tr class="gmail_msg">
<td class="gmail_msg" valign="top"
align="left" nowrap="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="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="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="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="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="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="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="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="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="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="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="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="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="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="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="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="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="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 moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true" 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 moz-do-not-send="true" 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 moz-do-not-send="true" 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 moz-do-not-send="true" 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 moz-do-not-send="true" 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 moz-do-not-send="true" href="http://handler.pl" class="gmail_msg" target="_blank">handler.pl</a> line 153
eval {...} at /usr/local/etc/freeside/<a moz-do-not-send="true" 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 moz-do-not-send="true"
href="mailto:freeside-users@freeside.biz"
class="gmail_msg" target="_blank">freeside-users@freeside.biz</a><br
class="gmail_msg">
<a moz-do-not-send="true"
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 moz-do-not-send="true" class="m_-5817128069316130829moz-txt-link-abbreviated gmail_msg" href="mailto:freeside-users@freeside.biz" target="_blank">freeside-users@freeside.biz</a>
<a moz-do-not-send="true" 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 moz-do-not-send="true"
href="mailto:freeside-users@freeside.biz" class="gmail_msg"
target="_blank">freeside-users@freeside.biz</a><br
class="gmail_msg">
<a moz-do-not-send="true"
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>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
freeside-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:freeside-users@freeside.biz">freeside-users@freeside.biz</a>
<a class="moz-txt-link-freetext" href="http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users">http://freeside.biz/cgi-bin/mailman/listinfo/freeside-users</a>
</pre>
</blockquote>
<br>
</body>
</html>