Deployed Logic-Invoice recently and the whole platform works seamlessly so far.
But when we create a Recurring Payment, lets say, monthly, after the cron job runs,
we get that invoice was created.
but we click on the invoice we get a Page Not Found!
"The page you are looking for could not be found! Please contact your system administrator if the problem persists."
We checked logs and spotted some errors like the following
ERROR LOGS-----------------------------------------------------------
2020-10-07 1:35:52 - PHP Fatal Error: "continue 2" targeting switch is equivalent to "break 2". Did you mean to use "continue 3"? in /home/billing/public_html/vqmod/vqmod.php on line 675
2020-10-07 1:38:52 - PHP Fatal Error: "continue 2" targeting switch is equivalent to "break 2". Did you mean to use "continue 3"? in /home/billing/public_html/vqmod/vqmod.php on line 675
2020-10-07 1:40:41 - PHP Fatal Error: "continue 2" targeting switch is equivalent to "break 2". Did you mean to use "continue 3"? in /home/billing/public_html/vqmod/vqmod.php on line 675
2020-10-07 1:40:43 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/billing/public_html/system/library/database/mysqli.php on line 18
2020-10-07 1:40:43 - PHP Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM oxlar_status s WHERE s.status_id = i.status_id) AS status FROM oxlar_invoice i LEFT JOIN oxlar_customer c ON c.customer_id = i.customer_id WHERE invoice_id = '5' in /home/billing/public_html/system/library/database/mysqli.php on line 40
2020-10-07 1:40:43 - PHP Notice: Trying to get property 'num_rows' of non-object in /home/billing/public_html/admin/model/billing/invoice.php on line 153
2020-10-07 1:41:04 - PHP Notice: Undefined index: directory in /home/billing/public_html/admin/cron.php on line 180
2020-10-07 1:41:04 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 244
2020-10-07 1:41:04 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/recurring.php on line 86
2020-10-07 1:41:04 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 226
2020-10-07 1:41:04 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/invoice.php on line 22
2020-10-07 1:41:04 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 244
2020-10-07 1:41:04 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/invoice.php on line 40
2020-10-07 1:42:01 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/billing/public_html/system/library/database/mysqli.php on line 18
2020-10-07 1:42:01 - PHP Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM oxlar_status s WHERE s.status_id = i.status_id) AS status FROM oxlar_invoice i LEFT JOIN oxlar_customer c ON c.customer_id = i.customer_id WHERE invoice_id = '5' in /home/billing/public_html/system/library/database/mysqli.php on line 40
2020-10-07 1:42:01 - PHP Notice: Trying to get property 'num_rows' of non-object in /home/billing/public_html/admin/model/billing/invoice.php on line 153
2020-10-07 1:42:19 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/billing/public_html/system/library/database/mysqli.php on line 18
2020-10-07 1:42:19 - PHP Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM oxlar_status s WHERE s.status_id = i.status_id) AS status FROM oxlar_invoice i LEFT JOIN oxlar_customer c ON c.customer_id = i.customer_id WHERE invoice_id = '5' in /home/billing/public_html/system/library/database/mysqli.php on line 40
2020-10-07 1:42:19 - PHP Notice: Trying to get property 'num_rows' of non-object in /home/billing/public_html/admin/model/billing/invoice.php on line 153
2020-10-07 1:42:29 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/billing/public_html/system/library/database/mysqli.php on line 18
2020-10-07 1:42:29 - PHP Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM oxlar_status s WHERE s.status_id = i.status_id) AS status FROM oxlar_invoice i LEFT JOIN oxlar_customer c ON c.customer_id = i.customer_id WHERE invoice_id = '5' in /home/billing/public_html/system/library/database/mysqli.php on line 40
2020-10-07 1:42:29 - PHP Notice: Trying to get property 'num_rows' of non-object in /home/billing/public_html/admin/model/billing/invoice.php on line 153
2020-10-07 1:42:36 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/billing/public_html/system/library/database/mysqli.php on line 18
2020-10-07 1:42:36 - PHP Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM oxlar_status s WHERE s.status_id = i.status_id) AS status FROM oxlar_invoice i LEFT JOIN oxlar_customer c ON c.customer_id = i.customer_id WHERE invoice_id = '5' in /home/billing/public_html/system/library/database/mysqli.php on line 40
2020-10-07 1:42:36 - PHP Notice: Trying to get property 'num_rows' of non-object in /home/billing/public_html/admin/model/billing/invoice.php on line 153
2020-10-07 1:45:11 - PHP Notice: Undefined index: directory in /home/billing/public_html/admin/cron.php on line 180
2020-10-07 1:45:11 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/billing/public_html/system/library/database/mysqli.php on line 18
2020-10-07 1:45:11 - PHP Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM oxlar_status s WHERE s.status_id = i.status_id) AS status FROM oxlar_invoice i LEFT JOIN oxlar_customer c ON c.customer_id = i.customer_id WHERE i.invoice_id = '6' AND i.status_id > 0 in /home/billing/public_html/system/library/database/mysqli.php on line 40
2020-10-07 1:45:11 - PHP Notice: Trying to get property 'num_rows' of non-object in /home/billing/public_html/application/model/billing/invoice.php on line 152
2020-10-07 1:45:11 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 244
2020-10-07 1:45:11 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/recurring.php on line 86
2020-10-07 1:45:11 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 226
2020-10-07 1:45:11 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/invoice.php on line 22
2020-10-07 1:45:11 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 244
2020-10-07 1:45:11 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/invoice.php on line 40
2020-10-07 1:45:22 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/billing/public_html/system/library/database/mysqli.php on line 18
2020-10-07 1:45:22 - PHP Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM oxlar_status s WHERE s.status_id = i.status_id) AS status FROM oxlar_invoice i LEFT JOIN oxlar_customer c ON c.customer_id = i.customer_id WHERE invoice_id = '6' in /home/billing/public_html/system/library/database/mysqli.php on line 40
2020-10-07 1:45:22 - PHP Notice: Trying to get property 'num_rows' of non-object in /home/billing/public_html/admin/model/billing/invoice.php on line 153
2020-10-07 1:45:27 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/billing/public_html/system/library/database/mysqli.php on line 18
2020-10-07 1:45:27 - PHP Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM oxlar_status s WHERE s.status_id = i.status_id) AS status FROM oxlar_invoice i LEFT JOIN oxlar_customer c ON c.customer_id = i.customer_id WHERE invoice_id = '6' in /home/billing/public_html/system/library/database/mysqli.php on line 40
2020-10-07 1:45:27 - PHP Notice: Trying to get property 'num_rows' of non-object in /home/billing/public_html/admin/model/billing/invoice.php on line 153
2020-10-07 1:46:22 - PHP Notice: Undefined offset: 2 in /home/billing/public_html/admin/model/content/email_template.php on line 174
2020-10-07 1:46:22 - PHP Notice: Undefined offset: 2 in /home/billing/public_html/admin/model/content/email_template.php on line 175
2020-10-07 1:46:22 - PHP Notice: Undefined offset: 2 in /home/billing/public_html/admin/model/content/email_template.php on line 185
2020-10-07 1:46:22 - PHP Notice: Undefined offset: 2 in /home/billing/public_html/admin/model/content/email_template.php on line 174
2020-10-07 1:46:22 - PHP Notice: Undefined offset: 2 in /home/billing/public_html/admin/model/content/email_template.php on line 175
2020-10-07 1:46:22 - PHP Notice: Undefined offset: 2 in /home/billing/public_html/admin/model/content/email_template.php on line 185
2020-10-07 1:46:29 - PHP Notice: Undefined index: directory in /home/billing/public_html/admin/cron.php on line 180
2020-10-07 1:46:29 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/billing/public_html/system/library/database/mysqli.php on line 18
2020-10-07 1:46:29 - PHP Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM oxlar_status s WHERE s.status_id = i.status_id) AS status FROM oxlar_invoice i LEFT JOIN oxlar_customer c ON c.customer_id = i.customer_id WHERE i.invoice_id = '7' AND i.status_id > 0 in /home/billing/public_html/system/library/database/mysqli.php on line 40
2020-10-07 1:46:29 - PHP Notice: Trying to get property 'num_rows' of non-object in /home/billing/public_html/application/model/billing/invoice.php on line 152
2020-10-07 1:46:29 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 244
2020-10-07 1:46:29 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/recurring.php on line 86
2020-10-07 1:46:29 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 226
2020-10-07 1:46:29 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/invoice.php on line 22
2020-10-07 1:46:29 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 244
2020-10-07 1:46:29 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/invoice.php on line 40
2020-10-07 1:46:34 - PHP Notice: Undefined index: directory in /home/billing/public_html/admin/cron.php on line 180
2020-10-07 1:46:48 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 244
2020-10-07 1:46:48 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/recurring.php on line 86
2020-10-07 1:46:48 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 226
2020-10-07 1:46:48 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/invoice.php on line 22
2020-10-07 1:46:48 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 244
2020-10-07 1:46:48 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/invoice.php on line 40
2020-10-07 1:46:58 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/billing/public_html/system/library/database/mysqli.php on line 18
2020-10-07 1:46:58 - PHP Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM oxlar_status s WHERE s.status_id = i.status_id) AS status FROM oxlar_invoice i LEFT JOIN oxlar_customer c ON c.customer_id = i.customer_id WHERE invoice_id = '8' in /home/billing/public_html/system/library/database/mysqli.php on line 40
2020-10-07 1:46:58 - PHP Notice: Trying to get property 'num_rows' of non-object in /home/billing/public_html/admin/model/billing/invoice.php on line 153
Website was tested on Apache with php 7.3 (also php 7.4), with all the needed php extensions, but same result every time.
Deployed Logic-Invoice recently and the whole platform works seamlessly so far.
But when we create a Recurring Payment, lets say, monthly, after the cron job runs,
we get that invoice was created.
but we click on the invoice we get a Page Not Found!
"The page you are looking for could not be found! Please contact your system administrator if the problem persists."
We checked logs and spotted some errors like the following
ERROR LOGS-----------------------------------------------------------
2020-10-07 1:35:52 - PHP Fatal Error: "continue 2" targeting switch is equivalent to "break 2". Did you mean to use "continue 3"? in /home/billing/public_html/vqmod/vqmod.php on line 675
2020-10-07 1:38:52 - PHP Fatal Error: "continue 2" targeting switch is equivalent to "break 2". Did you mean to use "continue 3"? in /home/billing/public_html/vqmod/vqmod.php on line 675
2020-10-07 1:40:41 - PHP Fatal Error: "continue 2" targeting switch is equivalent to "break 2". Did you mean to use "continue 3"? in /home/billing/public_html/vqmod/vqmod.php on line 675
2020-10-07 1:40:43 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/billing/public_html/system/library/database/mysqli.php on line 18
2020-10-07 1:40:43 - PHP Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM oxlar_status s WHERE s.status_id = i.status_id) AS status FROM oxlar_invoice i LEFT JOIN oxlar_customer c ON c.customer_id = i.customer_id WHERE invoice_id = '5' in /home/billing/public_html/system/library/database/mysqli.php on line 40
2020-10-07 1:40:43 - PHP Notice: Trying to get property 'num_rows' of non-object in /home/billing/public_html/admin/model/billing/invoice.php on line 153
2020-10-07 1:41:04 - PHP Notice: Undefined index: directory in /home/billing/public_html/admin/cron.php on line 180
2020-10-07 1:41:04 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 244
2020-10-07 1:41:04 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/recurring.php on line 86
2020-10-07 1:41:04 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 226
2020-10-07 1:41:04 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/invoice.php on line 22
2020-10-07 1:41:04 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 244
2020-10-07 1:41:04 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/invoice.php on line 40
2020-10-07 1:42:01 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/billing/public_html/system/library/database/mysqli.php on line 18
2020-10-07 1:42:01 - PHP Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM oxlar_status s WHERE s.status_id = i.status_id) AS status FROM oxlar_invoice i LEFT JOIN oxlar_customer c ON c.customer_id = i.customer_id WHERE invoice_id = '5' in /home/billing/public_html/system/library/database/mysqli.php on line 40
2020-10-07 1:42:01 - PHP Notice: Trying to get property 'num_rows' of non-object in /home/billing/public_html/admin/model/billing/invoice.php on line 153
2020-10-07 1:42:19 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/billing/public_html/system/library/database/mysqli.php on line 18
2020-10-07 1:42:19 - PHP Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM oxlar_status s WHERE s.status_id = i.status_id) AS status FROM oxlar_invoice i LEFT JOIN oxlar_customer c ON c.customer_id = i.customer_id WHERE invoice_id = '5' in /home/billing/public_html/system/library/database/mysqli.php on line 40
2020-10-07 1:42:19 - PHP Notice: Trying to get property 'num_rows' of non-object in /home/billing/public_html/admin/model/billing/invoice.php on line 153
2020-10-07 1:42:29 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/billing/public_html/system/library/database/mysqli.php on line 18
2020-10-07 1:42:29 - PHP Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM oxlar_status s WHERE s.status_id = i.status_id) AS status FROM oxlar_invoice i LEFT JOIN oxlar_customer c ON c.customer_id = i.customer_id WHERE invoice_id = '5' in /home/billing/public_html/system/library/database/mysqli.php on line 40
2020-10-07 1:42:29 - PHP Notice: Trying to get property 'num_rows' of non-object in /home/billing/public_html/admin/model/billing/invoice.php on line 153
2020-10-07 1:42:36 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/billing/public_html/system/library/database/mysqli.php on line 18
2020-10-07 1:42:36 - PHP Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM oxlar_status s WHERE s.status_id = i.status_id) AS status FROM oxlar_invoice i LEFT JOIN oxlar_customer c ON c.customer_id = i.customer_id WHERE invoice_id = '5' in /home/billing/public_html/system/library/database/mysqli.php on line 40
2020-10-07 1:42:36 - PHP Notice: Trying to get property 'num_rows' of non-object in /home/billing/public_html/admin/model/billing/invoice.php on line 153
2020-10-07 1:45:11 - PHP Notice: Undefined index: directory in /home/billing/public_html/admin/cron.php on line 180
2020-10-07 1:45:11 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/billing/public_html/system/library/database/mysqli.php on line 18
2020-10-07 1:45:11 - PHP Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM oxlar_status s WHERE s.status_id = i.status_id) AS status FROM oxlar_invoice i LEFT JOIN oxlar_customer c ON c.customer_id = i.customer_id WHERE i.invoice_id = '6' AND i.status_id > 0 in /home/billing/public_html/system/library/database/mysqli.php on line 40
2020-10-07 1:45:11 - PHP Notice: Trying to get property 'num_rows' of non-object in /home/billing/public_html/application/model/billing/invoice.php on line 152
2020-10-07 1:45:11 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 244
2020-10-07 1:45:11 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/recurring.php on line 86
2020-10-07 1:45:11 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 226
2020-10-07 1:45:11 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/invoice.php on line 22
2020-10-07 1:45:11 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 244
2020-10-07 1:45:11 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/invoice.php on line 40
2020-10-07 1:45:22 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/billing/public_html/system/library/database/mysqli.php on line 18
2020-10-07 1:45:22 - PHP Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM oxlar_status s WHERE s.status_id = i.status_id) AS status FROM oxlar_invoice i LEFT JOIN oxlar_customer c ON c.customer_id = i.customer_id WHERE invoice_id = '6' in /home/billing/public_html/system/library/database/mysqli.php on line 40
2020-10-07 1:45:22 - PHP Notice: Trying to get property 'num_rows' of non-object in /home/billing/public_html/admin/model/billing/invoice.php on line 153
2020-10-07 1:45:27 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/billing/public_html/system/library/database/mysqli.php on line 18
2020-10-07 1:45:27 - PHP Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM oxlar_status s WHERE s.status_id = i.status_id) AS status FROM oxlar_invoice i LEFT JOIN oxlar_customer c ON c.customer_id = i.customer_id WHERE invoice_id = '6' in /home/billing/public_html/system/library/database/mysqli.php on line 40
2020-10-07 1:45:27 - PHP Notice: Trying to get property 'num_rows' of non-object in /home/billing/public_html/admin/model/billing/invoice.php on line 153
2020-10-07 1:46:22 - PHP Notice: Undefined offset: 2 in /home/billing/public_html/admin/model/content/email_template.php on line 174
2020-10-07 1:46:22 - PHP Notice: Undefined offset: 2 in /home/billing/public_html/admin/model/content/email_template.php on line 175
2020-10-07 1:46:22 - PHP Notice: Undefined offset: 2 in /home/billing/public_html/admin/model/content/email_template.php on line 185
2020-10-07 1:46:22 - PHP Notice: Undefined offset: 2 in /home/billing/public_html/admin/model/content/email_template.php on line 174
2020-10-07 1:46:22 - PHP Notice: Undefined offset: 2 in /home/billing/public_html/admin/model/content/email_template.php on line 175
2020-10-07 1:46:22 - PHP Notice: Undefined offset: 2 in /home/billing/public_html/admin/model/content/email_template.php on line 185
2020-10-07 1:46:29 - PHP Notice: Undefined index: directory in /home/billing/public_html/admin/cron.php on line 180
2020-10-07 1:46:29 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/billing/public_html/system/library/database/mysqli.php on line 18
2020-10-07 1:46:29 - PHP Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM oxlar_status s WHERE s.status_id = i.status_id) AS status FROM oxlar_invoice i LEFT JOIN oxlar_customer c ON c.customer_id = i.customer_id WHERE i.invoice_id = '7' AND i.status_id > 0 in /home/billing/public_html/system/library/database/mysqli.php on line 40
2020-10-07 1:46:29 - PHP Notice: Trying to get property 'num_rows' of non-object in /home/billing/public_html/application/model/billing/invoice.php on line 152
2020-10-07 1:46:29 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 244
2020-10-07 1:46:29 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/recurring.php on line 86
2020-10-07 1:46:29 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 226
2020-10-07 1:46:29 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/invoice.php on line 22
2020-10-07 1:46:29 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 244
2020-10-07 1:46:29 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/invoice.php on line 40
2020-10-07 1:46:34 - PHP Notice: Undefined index: directory in /home/billing/public_html/admin/cron.php on line 180
2020-10-07 1:46:48 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 244
2020-10-07 1:46:48 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/recurring.php on line 86
2020-10-07 1:46:48 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 226
2020-10-07 1:46:48 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/invoice.php on line 22
2020-10-07 1:46:48 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/model/billing/invoice.php on line 244
2020-10-07 1:46:48 - PHP Warning: Invalid argument supplied for foreach() in /home/billing/public_html/application/controller/api/invoice.php on line 40
2020-10-07 1:46:58 - PHP Warning: mysqli::query(): (21000/1242): Subquery returns more than 1 row in /home/billing/public_html/system/library/database/mysqli.php on line 18
2020-10-07 1:46:58 - PHP Notice: Error: Subquery returns more than 1 row
Error No: 1242
SELECT *, CONCAT(c.firstname, ' ', c.lastname) AS customer, i.firstname AS firstname, i.lastname AS lastname, i.company AS company, i.website AS website, i.email AS email, i.date_modified AS date_modified, (SELECT name FROM oxlar_status s WHERE s.status_id = i.status_id) AS status FROM oxlar_invoice i LEFT JOIN oxlar_customer c ON c.customer_id = i.customer_id WHERE invoice_id = '8' in /home/billing/public_html/system/library/database/mysqli.php on line 40
2020-10-07 1:46:58 - PHP Notice: Trying to get property 'num_rows' of non-object in /home/billing/public_html/admin/model/billing/invoice.php on line 153
Website was tested on Apache with php 7.3 (also php 7.4), with all the needed php extensions, but same result every time.