[freeside] Unknown table

[Colin]

Yeh, it's currently being done on a test machine.
Thanks for your help :)


Kristian Hoffmann wrote:

> First of all, I hope this is a test machine.  Even thought I run that code
> on my production machine, I'd wait for Ivan to get it in CVS.
>
> On Tue, 16 Jan 2001, Colin wrote:
> > Hi
> >
> > We had just upgraded freeside to 1.24 using the humongous patch from
> > Kristian.
> >
> > A problem i encounter is that i received the following error when
> > viewing a customer's details. The customer details show up fine with the
> > error being displayed at the bottom of the screen.
>
> The default fs-setup does not create all of the required tables.  You can
> get the changes from the post I just made, or wait for the updated
> fs-setup to be added to CVS or posted by me.  If you do have all of the
> tables correctly added to the database, make sure you run bin/dbdef-create
> once to update your dbdef file.
>
> > "Unknown table cust_notes at
> > /usr/local/apache/htdocs/freeside/view/cust_main.cgi line 424"
> >
> > I have added all the required tables into our mysql database accordingly
> > and restarted mysql.
> > A similar error is shown when attempting to search for accounting usage
> > report -
> >
> > "Unknown table radacct at
> > /usr/local/apache/htdocs/freeside/report/svc_acct_usage.cgi line 21"
> >
> > This table is also present within our database.
>
> These usage reports rely on a modified ascend radius server.  It's
> actually the radius+mysql patch which we further modified to use the
> correct fields and such.
>
> -Kristian