the tax_exempt table has been in the software since 1.0, maybe there
was some error when it tried to create it?
Here is the table structure:
CREATE TABLE `tax_exempt` (
`id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`account_number` INT( 11 ) NOT NULL ,
`tax_rate_id` INT( 11 ) NOT NULL ,
`customer_tax_id` VARCHAR( 64 ) NULL ,
`expdate` DATE NULL
) TYPE=MyISAM ;
Paul
On 10/23/06, Michael Rulison <[EMAIL PROTECTED]> wrote:
>
> Paul Yasi wrote:
> > Try adding this ADODB debug line at the top of the function:
> > $DB->debug = true;
> > It should give you some verbose output about what it's doing.
> > Paul
> >
> Hooray. It does:
> 1146: Table 'citrus_db.tax_exempt' doesn't exist
> Thank You.
> > On 10/23/06, Michael Rulison <[EMAIL PROTECTED]> wrote:
> >
> >> I have checked the file include/billing.inc.php with PHPDesigner2007 as
> >> debugging editor; it reports no errors. But from Citrus menu, ...print
> >> invoices...
> >> Here is the block of code, ending with "die" and a modified error message.
> >>
> >> function add_taxdetails($DB, $billingdate, $bybillingid, $billingmethod,
> >> $batchid) {
> >>
> >> /*--------------------------------------------------------------------*/
> >> // Add taxes to the bill
> >> // database connector, billing date, billing method (invoice, prepay ,
> >>
> ++++++++++++++++++++snipped++++++++++++++++++++++++++
> >> LEFT JOIN billing b ON us.billing_id = b.id
> >> LEFT JOIN billing_types t ON b.billing_type = t.id
> >> WHERE b.id = '$bybillingid' AND us.removed <> 'y'";
> >> }
> >> $DB->SetFetchMode(ADODB_FETCH_ASSOC);
> >> $taxresult = $DB->Execute($query) or die ("Taxes Query Failed; Citrus
> >> 103") ;
> >>
> >> $taxresult produces the die side of the ''or' statement
> >> Could it be a problem with the $DB variable?
> >> How can I check it, please?
> >>
> >> -----------------------------------------------------------------------------
> >> Michael Rulison | 919/782-9576
> >> Raleigh NC 27607-6723
> >> -----------------------------------------------------------------------------
> >>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Citrusdb-users mailing list
> Citrusdb-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/citrusdb-users
>
--
The CitrusDB Project | http://www.citrusdb.org
Open Source Customer Care & Billing System
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Citrusdb-users mailing list
Citrusdb-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/citrusdb-users
