[freeside] Unknown table

[Kristian Hoffmann]

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