2023-09-12 07:50:01.258 CEST [34195] lms@lms ERROR: relation "billtech_payment_links" does not exist at character 19
2023-09-12 07:50:01.258 CEST [34195] lms@lms STATEMENT: select token from billtech_payment_links where src_cash_id is null and src_document_id is null
2023-09-12 07:50:01.259 CEST [34195] lms@lms ERROR: relation "billtech_customer_info" does not exist at character 13
2023-09-12 07:50:01.259 CEST [34195] lms@lms STATEMENT: insert into billtech_customer_info (customer_id, last_cash_id)
select cu.id, 0
from customers cu
left join billtech_customer_info bci on bci.customer_id = cu.id
where bci.customer_id is null;
2023-09-12 07:50:01.260 CEST [34195] lms@lms ERROR: relation "billtech_customer_info" does not exist at character 75
2023-09-12 07:50:01.260 CEST [34195] lms@lms STATEMENT: select bci.customer_id
from customers cu
left join billtech_customer_info bci on bci.customer_id = cu.id
left join cash ca on ca.customerid = cu.id
group by bci.customer_id, bci.last_cash_id
having bci.last_cash_id <= coalesce(max(ca.id), 0);
2023-09-12 07:55:06.085 CEST [34293] lms@lms ERROR: relation "billtech_payment_links" does not exist at character 19
2023-09-12 07:55:06.085 CEST [34293] lms@lms STATEMENT: select token from billtech_payment_links where src_cash_id is null and src_document_id is null
2023-09-12 07:55:06.086 CEST [34293] lms@lms ERROR: relation "billtech_customer_info" does not exist at character 13
2023-09-12 07:55:06.086 CEST [34293] lms@lms STATEMENT: insert into billtech_customer_info (customer_id, last_cash_id)
select cu.id, 0
from customers cu
left join billtech_customer_info bci on bci.customer_id = cu.id
where bci.customer_id is null;
2023-09-12 07:55:06.086 CEST [34293] lms@lms ERROR: relation "billtech_customer_info" does not exist at character 75
2023-09-12 07:55:06.086 CEST [34293] lms@lms STATEMENT: select bci.customer_id
from customers cu
left join billtech_customer_info bci on bci.customer_id = cu.id
left join cash ca on ca.customerid = cu.id
group by bci.customer_id, bci.last_cash_id
having bci.last_cash_id <= coalesce(max(ca.id), 0);
2023-09-12 08:00:01.345 CEST [34385] lms@lms ERROR: relation "billtech_payment_links" does not exist at character 19
2023-09-12 08:00:01.345 CEST [34385] lms@lms STATEMENT: select token from billtech_payment_links where src_cash_id is null and src_document_id is null
2023-09-12 08:00:01.345 CEST [34385] lms@lms ERROR: relation "billtech_customer_info" does not exist at character 13
2023-09-12 08:00:01.345 CEST [34385] lms@lms STATEMENT: insert into billtech_customer_info (customer_id, last_cash_id)
select cu.id, 0
from customers cu
left join billtech_customer_info bci on bci.customer_id = cu.id
where bci.customer_id is null;
2023-09-12 08:00:01.346 CEST [34385] lms@lms ERROR: relation "billtech_customer_info" does not exist at character 75
2023-09-12 08:00:01.346 CEST [34385] lms@lms STATEMENT: select bci.customer_id
from customers cu
left join billtech_customer_info bci on bci.customer_id = cu.id
left join cash ca on ca.customerid = cu.id
group by bci.customer_id, bci.last_cash_id
having bci.last_cash_id <= coalesce(max(ca.id), 0);
Obecnie po włączeniu wtyczki dostajemy błąd:
Błąd jest bardzo trywialny. Po zaakceptowaniu https://github.com/BillTechPL/lms-billtech-plugin/pull/117 wrzucę PR z naprawą błędu.