Uploaded image for project: 'Prestashop 1.6'
  1. Prestashop 1.6
  2. PSCSX-6202

Found a big big big error on 1.6.1.0 order invoice process involving tables order_invoice, order_invoice_payment, order_invoice_tax Their data is missing with some orders

    Details

    • Impact:
      3

      Description

      Hi
      I get this problem only in one site, upgrading it from 1.6.0.14 to the last 1.6.1
      The problem is when the invoice is generated from an order status (the problem is also on the delivery slip pdf).
      into the invoice pdf there are many payment method and the pdf has normally 3 pages. First page with a long payment list, the second is void and the last with null data.
      The delivery slip is with payment method with no payment method text.
      The pdf made from order list and from the order page with the button "View Invoice" has a pdf named invoices.pdf or IN000000.pdf. Instead in the documents list is missing.

      Looking into the database, the problems are into three tables:
      order_invoice, order_invoice_payment, order_invoice_tax
      in the ps_order the invoice number is present, into these three tables is 0 or 1 and all their data is like 1 or 0

      I've seen that the data in the other order tables is ok and the order process in the front-office is ok, so it is only in the back-office

      CAUSE OF THIS ERROR:
      on the new 1.6.1 if the order status are configurated in mode that the invoice pdf is generated after the delivery pdf, the site will get this error and the delivery pdf will report any payment method.
      Instead if the invoice is created at the same time or before the delivery slip pdf, all will be ok and the 3 tables of invoice_order will have their data about the order. So the right configuration in on 1111.png
      Until to 1.6.0.14 it was without this type of error

      bye

        Attachments

        1. 000.png
          000.png
          168 kB
        2. 1100.png
          1100.png
          79 kB
        3. 111.png
          111.png
          81 kB
        4. 1110.png
          1110.png
          80 kB
        5. 1111.png
          1111.png
          121 kB
        6. 22.png
          22.png
          42 kB
        7. 222.png
          222.png
          172 kB
        8. 23.png
          23.png
          64 kB
        9. 333.png
          333.png
          179 kB
        10. 444.png
          444.png
          187 kB
        11. 555.png
          555.png
          115 kB
        12. 666.png
          666.png
          146 kB
        13. 777.png
          777.png
          74 kB
        14. 888.png
          888.png
          83 kB
        15. 999.png
          999.png
          43 kB

          Activity

            People

            • Assignee:
              Gregory Gregory
              Reporter:
              maofree maofree
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: