The SimpleInvoices forum has moved to Google Plus - this forum is now read-only
Unable to update existing customer
  • parierparier October 2010

    When I make a change to a postal code and click SAVE, I get this:

    QLSTATE[HY093]: Invalid parameter number: Columns/Parameters are 1-basedDude, what happened to your query?:

    UPDATE si_customers SET name = :name, attention = :attention, street_address = :street_address, street_address2 = :street_address2, city = :city, state = :state, zip_code = :zip_code, country = :country, phone = :phone, mobile_phone = :mobile_phone, fax = :fax, email = :email, credit_card_holder_name = :credit_card_holder_name, credit_card_expiry_month = :credit_card_expiry_month, credit_card_expiry_year = :credit_card_expiry_year, notes = :notes, custom_field1 = :custom_field1, custom_field2 = :custom_field2, custom_field3 = :custom_field3, custom_field4 = :custom_field4, enabled = :enabled WHERE id = :id
    00000

    What can I do to correct this issue?

    Thank you,
    parier

  • justinjustin October 2010

    hey parier

    what version of Simple Invoices are you running
    -- check config/config.ini

    you might want to try with this version - a similar issue was fixed
    -- http://simpleinvoices.googlecode.com/files/simpleinvoices.2010.2.update-1.zip

    let us know how you go

    cheers

    justin

    SmarterInvoices.com :: Simple Invoices hosting | Kelly.org.au :: Simple Invoices custom development | justin.kelly.org.au
  • parierparier October 2010

    Perfect, will upgrade. Also, thank you for the swift reply. I will update my findings.

    Also, separate note. Is there a place where people collaborate on templates, specifically invoices (PDF output). I wanted (and did) to implement a custom footer for remitting payments and allow the customer to detach and send the invoice, customer, etc info along with payment. I have been testing this with the local copy of SimpleInvoices and that itself is awesome. Couldn't be happier with this app - keep up the great work.

Add a Comment

Categories