Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2025-06-01' AND `sale_datetime` <= '2025-06-31')...' at line 1

Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2025-06-01\' AND `sale_datetime` <= \'2025-06-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'

in Page /dashboard/reports/monthly-summary-report/report/ line 140

in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744

Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2025-07-01' AND `sale_datetime` <= '2025-07-31')...' at line 1

Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2025-07-01\' AND `sale_datetime` <= \'2025-07-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'

in Page /dashboard/reports/monthly-summary-report/report/ line 140

in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744

Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2025-08-01' AND `sale_datetime` <= '2025-08-31')...' at line 1

Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2025-08-01\' AND `sale_datetime` <= \'2025-08-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'

in Page /dashboard/reports/monthly-summary-report/report/ line 140

in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744

Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2025-09-01' AND `sale_datetime` <= '2025-09-31')...' at line 1

Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2025-09-01\' AND `sale_datetime` <= \'2025-09-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'

in Page /dashboard/reports/monthly-summary-report/report/ line 140

in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744

Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2025-10-01' AND `sale_datetime` <= '2025-10-31')...' at line 1

Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2025-10-01\' AND `sale_datetime` <= \'2025-10-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'

in Page /dashboard/reports/monthly-summary-report/report/ line 140

in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744

Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2025-11-01' AND `sale_datetime` <= '2025-11-31')...' at line 1

Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2025-11-01\' AND `sale_datetime` <= \'2025-11-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'

in Page /dashboard/reports/monthly-summary-report/report/ line 140

in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744

Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2025-12-01' AND `sale_datetime` <= '2025-12-31')...' at line 1

Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2025-12-01\' AND `sale_datetime` <= \'2025-12-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'

in Page /dashboard/reports/monthly-summary-report/report/ line 140

in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744

Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2026-01-01' AND `sale_datetime` <= '2026-01-31')...' at line 1

Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2026-01-01\' AND `sale_datetime` <= \'2026-01-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'

in Page /dashboard/reports/monthly-summary-report/report/ line 140

in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744

Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2026-02-01' AND `sale_datetime` <= '2026-02-31')...' at line 1

Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2026-02-01\' AND `sale_datetime` <= \'2026-02-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'

in Page /dashboard/reports/monthly-summary-report/report/ line 140

in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744

Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2026-03-01' AND `sale_datetime` <= '2026-03-31')...' at line 1

Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2026-03-01\' AND `sale_datetime` <= \'2026-03-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'

in Page /dashboard/reports/monthly-summary-report/report/ line 140

in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744

Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2026-04-01' AND `sale_datetime` <= '2026-04-31')...' at line 1

Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2026-04-01\' AND `sale_datetime` <= \'2026-04-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'

in Page /dashboard/reports/monthly-summary-report/report/ line 140

in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744

Exception: Syntax error near: 'NULL AND `sale_datetime` >= '2026-05-01' AND `sale_datetime` <= '2026-05-31')...' at line 1

Database Query Error (Syntax Error)

Debug Info:
- Query: 'SELECT `sale_id`, `sale_datetime`, `sale_title`, `sale_total` FROM commerce_sales WHERE (`sale_type` != \'adjustment\' AND `contact_id` IN NULL AND `sale_datetime` >= \'2026-05-01\' AND `sale_datetime` <= \'2026-05-31\') ORDER BY `sale_datetime` desc, `sale_id` desc'

in Page /dashboard/reports/monthly-summary-report/report/ line 140

in /usr/lib/php/Oncord/beta/Framework/Database/Connectors/MySQL/MySQL.inc.php line 744