System PHP Error Undefined variable $additional_statement
Checkpoint [2025-03-13 11:50:23.407753]: /home/websites/production/apps/www/lib/error_handling/error_handling.php {00188} show_error()
Full Coding Debug: Output Message:
SQL Selection Failure:
SQLSTATE[42S02]: Base table or view not found: 1146 Table
'parts_data.tbl_link_group_category' doesn't exist SQL Statement: SELECT C.key_id, C.category_name FROM tbl_category C INNER JOIN tbl_link_group_category GC ON GC.category_id = C.key_id WHERE GC.group_id = 2 ORDER BY C.category_name ASC
Debug Backtrace Info:
Checkpoint [2025-03-13 11:50:23.407199]: /home/websites/production/apps/www/lib/classes/db/db_functions.class.php {00232} pdo_query->prepare_query()
Warning: No prepared SQL statement System PHP Error Undefined property: pdo_query::$recordset
Checkpoint [2025-03-13 11:50:23.407868]: /home/websites/production/apps/www/lib/classes/db/db_functions.class.php {00422} pdo_query->fetch_as_array()
System PHP Error Undefined property: pdo_query::$recordset
Checkpoint [2025-03-13 11:50:23.407888]: /home/websites/production/apps/www/lib/classes/apps/parts.class.php {00282} parts::get_cat_list()
System PHP Error foreach() argument must be of type array|object, null given
Checkpoint [2025-03-13 11:50:23.407900]: /home/websites/production/apps/www/lib/classes/apps/parts.class.php {00282} parts::get_cat_list()
System PHP Error Undefined variable $additional_statement
Checkpoint [2025-03-13 11:50:23.409791]: /home/websites/production/apps/www/lib/error_handling/error_handling.php {00188} show_error()
Full Coding Debug: Output Message:
SQL Selection Failure:
SQLSTATE[42S02]: Base table or view not found: 1146 Table
'parts_data.tbl_link_category_item' doesn't exist SQL Statement: SELECT I.key_id, I.item_name FROM tbl_item I INNER JOIN tbl_link_category_item CI ON CI.item_id = I.key_id WHERE CI.category_id = 0 ORDER BY I.item_name ASC
Debug Backtrace Info:
Checkpoint [2025-03-13 11:50:23.409754]: /home/websites/production/apps/www/lib/classes/db/db_functions.class.php {00232} pdo_query->prepare_query()
Warning: No prepared SQL statement System PHP Error Undefined property: pdo_query::$recordset
Checkpoint [2025-03-13 11:50:23.409834]: /home/websites/production/apps/www/lib/classes/db/db_functions.class.php {00422} pdo_query->fetch_as_array()
System PHP Error Undefined property: pdo_query::$recordset
Checkpoint [2025-03-13 11:50:23.409849]: /home/websites/production/apps/www/lib/classes/apps/parts.class.php {00304} parts::get_item_list()
System PHP Error foreach() argument must be of type array|object, null given
Checkpoint [2025-03-13 11:50:23.409858]: /home/websites/production/apps/www/lib/classes/apps/parts.class.php {00304} parts::get_item_list()
System PHP Error Undefined variable $additional_statement
Checkpoint [2025-03-13 11:50:23.410673]: /home/websites/production/apps/www/lib/error_handling/error_handling.php {00188} show_error()
Full Coding Debug: Output Message:
SQL Selection Failure:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an
error in your SQL syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near 'ORDER BY
S.supplier_name ASC' at line 1 SQL Statement: SELECT S.key_id, S.supplier_name FROM tbl_supplier S INNER JOIN tbl_link_item_supplier ISU ON ISU.supplier_id = S.key_id WHERE ISU.item_id = ORDER BY S.supplier_name ASC
Debug Backtrace Info:
Checkpoint [2025-03-13 11:50:23.410644]: /home/websites/production/apps/www/lib/classes/db/db_functions.class.php {00232} pdo_query->prepare_query()
Warning: No prepared SQL statement System PHP Error Undefined property: pdo_query::$recordset
Checkpoint [2025-03-13 11:50:23.410745]: /home/websites/production/apps/www/lib/classes/db/db_functions.class.php {00422} pdo_query->fetch_as_array()
System PHP Error Undefined property: pdo_query::$recordset
Checkpoint [2025-03-13 11:50:23.410761]: /home/websites/production/apps/www/lib/classes/apps/parts.class.php {00325} parts::get_supp_list()
System PHP Error foreach() argument must be of type array|object, null given
Checkpoint [2025-03-13 11:50:23.410770]: /home/websites/production/apps/www/lib/classes/apps/parts.class.php {00325} parts::get_supp_list()
Part Test