phpBMS

Ticket #187 (closed defect: invalid)

Opened 4 years ago

Last modified 4 years ago

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;

Change History

Changed 4 years ago by brieb

  • status changed from new to closed
  • resolution set to invalid

More than likely your 0.71 version had failed some update in the past. Use the forums to help troubleshoot your install

Note: See TracTickets for help on using tickets.
Scanned by Orvant Copyright © 2010 Kreotek, LLC. All Rights reserved.