Ticket #187 (closed defect: invalid)
error on update
| Reported by: | anonymous | Owned by: | brieb |
|---|---|---|---|
| Priority: | minor | Milestone: | |
| Component: | phpbms | Version: | 0.8 |
| Keywords: | Cc: |
Description
When I try to update from 0.7 I get this error and no invoices or orders are shown.
phpBMS Error: -420 Database Error Unknown table 'paymentmethods' in field list
Statement: SELECT DISTINCT invoices.id as theid,invoices.id as "id", invoices.readytopost as "RTP", invoices.type as "type", invoicestatuses.name as "status", invoices.weborder as "web", if(invoices.type="Invoice",invoices.invoicedate,invoices.orderdate) as "date", concat("<strong>",if(clients.lastname!="",concat(clients.lastname,", ",clients.firstname,if(clients.company!="",concat(" (",clients.company,")"),"")),clients.company),"</strong>") as "client name / company", paymentmethods.name as "payment", if(invoices.type!="VOID",invoices.totalti,"-----") as "total", if(invoices.type!="VOID",invoices.totalti-invoices.amountpaid,"-----") as "due" FROM ((invoices inner join clients on invoices.clientid=clients.id) inner join invoicestatuses on invoices.statusid=invoicestatuses.id) WHERE invoices.type+0<3 ORDER BY invoices.id DESC limit 0, 25;