[freeside] Unknown table
khoff at pc-intouch.com
Mon Jan 15 21:16:51 PST 2001
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:
> We had just upgraded freeside to 1.24 using the humongous patch from
> 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.
More information about the freeside-users