Files
HotLunches/sql_error.log.bak
2026-10-19 15:22:52 -07:00

253 lines
26 KiB
Plaintext

==========================================
2026-10-12 22:23:47
DB: hotlunch
Duplicate entry '19964-85402-967466-43663' for key 'hotlunch_menu_dates_classes.PRIMARY'
SQL Query Error (/ajax.MenuDates.Update.php) copy-menu
INSERT into hotlunch_menu_dates_classes (school_num, schedule_num, menu_num, class_num) values (19964, 85402, 967466, 43663)
==========================================
2026-10-12 22:24:15
DB: hotlunch
Duplicate entry '19964-85402-967466-43663' for key 'hotlunch_menu_dates_classes.PRIMARY'
SQL Query Error (/ajax.MenuDates.Update.php) copy-menu
INSERT into hotlunch_menu_dates_classes (school_num, schedule_num, menu_num, class_num) values (19964, 85402, 967466, 43663)
==========================================
2026-10-13 07:21:58
DB: hotlunch
Out of range value for column 'amount_paid' at row 1
SQL Query Error (/index.php) user-account / insert
UPDATE user_account SET amount_paid = amount_paid + 5000 WHERE school_num = 19526 AND user_num = 1350526 AND record_num = 30407757
==========================================
2026-10-13 07:22:30
DB: hotlunch
Out of range value for column 'amount_paid' at row 1
SQL Query Error (/index.php) user-account / insert
UPDATE user_account SET amount_paid = amount_paid + 5000 WHERE school_num = 19526 AND user_num = 1350526 AND record_num = 30407757
==========================================
2026-10-13 08:16:26
DB: hotlunch
Out of range value for column 'amount_paid' at row 1
SQL Query Error (/index.php) user-account / insert
UPDATE user_account SET amount_paid = amount_paid + 5000 WHERE school_num = 19761 AND user_num = 1172800 AND record_num = 30455041
==========================================
2026-10-13 09:06:28
DB: hotlunch
Out of range value for column 'amount_paid' at row 1
SQL Query Error (/index.php) user-account / insert
UPDATE user_account SET amount_paid = amount_paid + 5000 WHERE school_num = 20256 AND user_num = 1484580 AND record_num = 33587467
==========================================
2026-10-13 09:06:53
DB: hotlunch
Out of range value for column 'amount_paid' at row 1
SQL Query Error (/index.php) user-account / insert
UPDATE user_account SET amount_paid = amount_paid + 5000 WHERE school_num = 20256 AND user_num = 1484580 AND record_num = 33587467
==========================================
2026-10-13 08:32:38
DB: hotlunch
Incorrect datetime value: '2026-10-13 0830' for column 'start_order_datetime' at row 1
SQL Query Error (/index.php) schedules / update
UPDATE hotlunch_schedules set school_num = 279, schedule_name = 'High School - Oct/Nov 2026', start_order_datetime = '2026-10-13 0830', end_order_datetime = '2026-10-14 1800', custom_menu_end_dates = 'N', schedule_start_date = '2026-10-29', schedule_end_date = '2026-11-27', default_menu_title = 'Hot Lunch', lunch_days = 'Mon,Tue,Thu', status = 'Active', schedule_type = 'Hot Lunch', schedule_prices = 'Y', order_button_text = 'Order', display_on_calendar = 'Y', schedule_for = 'Parents', edit_paid_orders = 'D', edit_complimentary_orders = 'D', edit_linked_menus = 'N', menu_display_mode = 'Calendar No Weekends', calendar_month_breaks = 'Y', display_title_or_label = 'Title', display_menu_title = 'Y', display_menu_headings = 'N', display_item_price = 'N', display_product_thumbnail = 'N', schedule_print_format = 'All Menus', schedule_receipts_description = 'N', allow_multiple_orders = 'N', check_for_missed_menus = 'Y', discount_offered = 0, discount_type = 'Amount', discount_order_minimum = 0, discount_expiry_date = '2026-09-13', paper_order_charge = 0, paper_order_message = '', late_charge = 0, late_charge_date = '2026-09-28', tax_rate = 0, tax_description = '', days_prior_to_order_date = 7, order_until_hour = '12', menu_cutoff_date = '2026-10-18', hide_unavailable_dates = 'N', additional_charge = 0, additional_charge_message = '', qty_warning_limit = 3, qty_absolute_limit = 10, display_menu_date = 'Y', display_instructions = 'N', description = '', paper_description = '', paper_footer = '', notification_email = '', email_message = '', order_entered_message = 'Please be sure to check out the High School Hot Lunch Volunteer signup. If you are able to help, we would love to have you.\r\nhttps://www.signupgenius.com/go/20F0D4AA9A72EA31-58072119-high', default_order_format = 'Quantity', volunteer_signup = 'D', schedule_volunteer_message = '', max_volunteers = 0, class_sort_field = 'D', implement_order_notes = 'N', order_notes_message = '', implement_order_notes2 = 'N', order_notes_message2 = '', supplier_num = 0 where record_num = 87441
==========================================
2026-10-13 08:32:50
DB: hotlunch
Incorrect datetime value: '2026-10-13 0830' for column 'start_order_datetime' at row 1
SQL Query Error (/index.php) schedules / update
UPDATE hotlunch_schedules set school_num = 279, schedule_name = 'High School - Oct/Nov 2026', start_order_datetime = '2026-10-13 0830', end_order_datetime = '2026-10-14 1800', custom_menu_end_dates = 'N', schedule_start_date = '2026-10-29', schedule_end_date = '2026-11-27', default_menu_title = 'Hot Lunch', lunch_days = 'Mon,Tue,Thu', status = 'Active', schedule_type = 'Hot Lunch', schedule_prices = 'Y', order_button_text = 'Order', display_on_calendar = 'Y', schedule_for = 'Parents', edit_paid_orders = 'D', edit_complimentary_orders = 'D', edit_linked_menus = 'N', menu_display_mode = 'Calendar No Weekends', calendar_month_breaks = 'Y', display_title_or_label = 'Title', display_menu_title = 'Y', display_menu_headings = 'N', display_item_price = 'N', display_product_thumbnail = 'N', schedule_print_format = 'All Menus', schedule_receipts_description = 'N', allow_multiple_orders = 'N', check_for_missed_menus = 'Y', discount_offered = 0, discount_type = 'Amount', discount_order_minimum = 0, discount_expiry_date = '2026-09-13', paper_order_charge = 0, paper_order_message = '', late_charge = 0, late_charge_date = '2026-09-28', tax_rate = 0, tax_description = '', days_prior_to_order_date = 7, order_until_hour = '12', menu_cutoff_date = '2026-10-18', hide_unavailable_dates = 'N', additional_charge = 0, additional_charge_message = '', qty_warning_limit = 3, qty_absolute_limit = 10, display_menu_date = 'Y', display_instructions = 'N', description = '', paper_description = '', paper_footer = '', notification_email = '', email_message = '', order_entered_message = 'Please be sure to check out the High School Hot Lunch Volunteer signup. If you are able to help, we would love to have you.\r\nhttps://www.signupgenius.com/go/20F0D4AA9A72EA31-58072119-high', default_order_format = 'Quantity', volunteer_signup = 'D', schedule_volunteer_message = '', max_volunteers = 0, class_sort_field = 'D', implement_order_notes = 'N', order_notes_message = '', implement_order_notes2 = 'N', order_notes_message2 = '', supplier_num = 0 where record_num = 87441
==========================================
2026-10-13 08:34:24
DB: hotlunch
Duplicate entry '19964-85402-967472-43651' for key 'hotlunch_menu_dates_classes.PRIMARY'
SQL Query Error (/ajax.MenuDates.Update.php) copy-menu
INSERT into hotlunch_menu_dates_classes (school_num, schedule_num, menu_num, class_num) values (19964, 85402, 967472, 43651)
==========================================
2026-10-13 21:18:07
DB: hotlunch
Incorrect date value: '' for column 'delivery_date' at row 1
SQL Query Error (/index.php) menu-details /
update supplier_order_header set estimated_total = 0, delivery_date = '' where school_num = 281 and schedule_num = 88455 and menu_num = 1002767
==========================================
2026-10-13 21:18:38
DB: hotlunch
Incorrect date value: '' for column 'delivery_date' at row 1
SQL Query Error (/index.php) menu-details /
update supplier_order_header set estimated_total = 0, delivery_date = '' where school_num = 281 and schedule_num = 88455 and menu_num = 1002767
==========================================
2026-10-14 08:31:43
DB: hotlunch
Duplicate entry '19862-aniezel.ere' for key 'users.PRIMARY'
SQL Query Error (/index.php) orders / insert
INSERT into users (school_num, userid, password, password_crypt, change_datetime, email, email2, email3, include_email1_on_list, include_email2_on_list, include_email3_on_list, email1_verified, email2_verified, email3_verified, type, status, date_added, last_login, can_order, has_order, num_orders, num_students, source, ordered, paid, balance_owing, account_balance, trx_status, posted_date, receive_emails, email_reminders, email_flag, available_to_volunteer, class_parent, school_directory, email_list, language, first_name, last_name, first_name2, last_name2, home_phone, daytime_phone, cell_phone, address, city, province, postal, additional1, additional2, bank_account_holder, institution_number, branch_number, account_number, bambora_payment_profile_id, supplier_num, added_time, user_ip, enable_translation, linked_to_student, linked_to_num, linked_to_type, linked_id, linked_time, user_notes) values (19862, 'aniezel.ere', 'aniezel.ere', '', '2026-10-14 08:31:43', 'aniezel_feb20@yahoo.com', '', '', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'Parent', 'Active', '2026-10-14', '2026-10-14 08:31:43', 'Yes', 'N', 0, NULL, 'Paper', NULL, NULL, 0, 0, '', NULL, 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', '', 'Aniezel', 'Ere', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '2026-10-14 08:31:43', '192.30.99.159', 'Y', '', NULL, 'Student', '', NULL, '')
==========================================
2026-10-14 13:24:30
DB: hotlunch
Duplicate entry '19961-88768-1005771-46986' for key 'hotlunch_menu_dates_classes.PRIMARY'
SQL Query Error (/ajax.MenuDates.Update.php) copy-menu
INSERT into hotlunch_menu_dates_classes (school_num, schedule_num, menu_num, class_num) values (19961, 88768, 1005771, 46986)
==========================================
2026-10-14 13:24:39
DB: hotlunch
Duplicate entry '19961-88768-1005771-46986' for key 'hotlunch_menu_dates_classes.PRIMARY'
SQL Query Error (/ajax.MenuDates.Update.php) copy-menu
INSERT into hotlunch_menu_dates_classes (school_num, schedule_num, menu_num, class_num) values (19961, 88768, 1005771, 46986)
==========================================
2026-10-14 13:24:41
DB: hotlunch
Duplicate entry '19961-88768-1005771-46986' for key 'hotlunch_menu_dates_classes.PRIMARY'
SQL Query Error (/ajax.MenuDates.Update.php) copy-menu
INSERT into hotlunch_menu_dates_classes (school_num, schedule_num, menu_num, class_num) values (19961, 88768, 1005771, 46986)
==========================================
2026-10-15 02:46:02
DB: hotlunch
Deadlock found when trying to get lock; try restarting transaction
SQL Query Error (/ajax.DataRecord.Update.php)
UPDATE user_account SET transaction_status = 'Closed' WHERE school_num = 20473 AND user_num = 1721908
==========================================
2026-10-15 06:46:14
DB: hotlunch
Lock wait timeout exceeded; try restarting transaction
SQL Query Error (/ppPayment.php)
UPDATE user_account SET amount_paid = transaction_amount WHERE school_num = 19761 AND record_num = 22434027
==========================================
2026-10-15 06:46:23
DB: hotlunch
Lock wait timeout exceeded; try restarting transaction
SQL Query Error (/index.php) user-account / list
UPDATE user_account SET transaction_status = 'Closed' WHERE school_num = 19761 AND user_num = 1074033 AND transaction_type = 'Order' AND (deleted != 'Y' OR deleted IS NULL)
==========================================
2026-10-15 09:54:18
DB: hotlunch
Duplicate entry '337-patrickrichard@cloud.edu.pe.ca' for key 'users.PRIMARY'
SQL Query Error (/index.php) orders / insert
INSERT into users (school_num, userid, password, password_crypt, change_datetime, email, email2, email3, include_email1_on_list, include_email2_on_list, include_email3_on_list, email1_verified, email2_verified, email3_verified, type, status, date_added, last_login, can_order, has_order, num_orders, num_students, source, ordered, paid, balance_owing, account_balance, trx_status, posted_date, receive_emails, email_reminders, email_flag, available_to_volunteer, class_parent, school_directory, email_list, language, first_name, last_name, first_name2, last_name2, home_phone, daytime_phone, cell_phone, address, city, province, postal, additional1, additional2, bank_account_holder, institution_number, branch_number, account_number, bambora_payment_profile_id, supplier_num, added_time, user_ip, enable_translation, linked_to_student, linked_to_num, linked_to_type, linked_id, linked_time, user_notes) values (337, 'patrickrichard@cloud.edu.pe.ca', 'patrickrichard@cloud.edu.pe.ca', '', '2026-10-15 09:54:18', 'patrickrichard@cloud.edu.pe.ca', '', '', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'Parent', 'Active', '2026-10-15', '2026-10-15 09:54:18', 'Yes', 'N', 0, NULL, 'On-Line', NULL, NULL, 0, 0, '', NULL, 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', '', 'Patrick Richard', 'Macdonald-Ross', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '2026-10-15 09:54:18', '24.224.240.110', 'Y', '', NULL, 'Student', '', NULL, '')
==========================================
2026-10-15 10:01:39
DB: hotlunch
Duplicate entry '337-patrickrichard@cloud.edu.pe.ca' for key 'users.PRIMARY'
SQL Query Error (/index.php) orders / insert
INSERT into users (school_num, userid, password, password_crypt, change_datetime, email, email2, email3, include_email1_on_list, include_email2_on_list, include_email3_on_list, email1_verified, email2_verified, email3_verified, type, status, date_added, last_login, can_order, has_order, num_orders, num_students, source, ordered, paid, balance_owing, account_balance, trx_status, posted_date, receive_emails, email_reminders, email_flag, available_to_volunteer, class_parent, school_directory, email_list, language, first_name, last_name, first_name2, last_name2, home_phone, daytime_phone, cell_phone, address, city, province, postal, additional1, additional2, bank_account_holder, institution_number, branch_number, account_number, bambora_payment_profile_id, supplier_num, added_time, user_ip, enable_translation, linked_to_student, linked_to_num, linked_to_type, linked_id, linked_time, user_notes) values (337, 'patrickrichard@cloud.edu.pe.ca', 'patrickrichard@cloud.edu.pe.ca', '', '2026-10-15 10:01:39', 'patrickrichard@cloud.edu.pe.ca', '', '', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'Parent', 'Active', '2026-10-15', '2026-10-15 10:01:39', 'Yes', 'N', 0, NULL, 'On-Line', NULL, NULL, 0, 0, '', NULL, 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', '', 'Patrick Richard', 'Macdonald-Ross', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '2026-10-15 10:01:39', '24.224.240.110', 'Y', '', NULL, 'Student', '', NULL, '')
==========================================
2026-10-15 10:13:43
DB: hotlunch
Duplicate entry '18460-AngSny' for key 'users.PRIMARY'
SQL Query Error (/index.php) orders / insert
INSERT into users (school_num, userid, password, password_crypt, change_datetime, email, email2, email3, include_email1_on_list, include_email2_on_list, include_email3_on_list, email1_verified, email2_verified, email3_verified, type, status, date_added, last_login, can_order, has_order, num_orders, num_students, source, ordered, paid, balance_owing, account_balance, trx_status, posted_date, receive_emails, email_reminders, email_flag, available_to_volunteer, class_parent, school_directory, email_list, language, first_name, last_name, first_name2, last_name2, home_phone, daytime_phone, cell_phone, address, city, province, postal, additional1, additional2, bank_account_holder, institution_number, branch_number, account_number, bambora_payment_profile_id, supplier_num, added_time, user_ip, enable_translation, linked_to_student, linked_to_num, linked_to_type, linked_id, linked_time, user_notes) values (18460, 'AngSny', 'AngSny', '', '2026-10-15 10:13:43', 'angsny@hotmail.ca', '', '', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'Parent', 'Active', '2026-10-15', '2026-10-15 10:13:43', 'Yes', 'N', 0, NULL, 'On-Line', NULL, NULL, 0, 0, '', NULL, 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', '', 'Angangie Snyder', 'Way', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL, '2026-10-15 10:13:43', '65.49.156.197', 'Y', '', NULL, 'Student', '', NULL, '')
==========================================
2026-10-15 09:20:44
DB: hotlunch
Incorrect date value: '' for column 'delivery_date' at row 1
SQL Query Error (/index.php) menu-details /
update supplier_order_header set estimated_total = 0, delivery_date = '' where school_num = 18653 and schedule_num = 88640 and menu_num = 1004510
==========================================
2026-10-15 09:20:59
DB: hotlunch
Incorrect date value: '' for column 'delivery_date' at row 1
SQL Query Error (/index.php) menu-details /
update supplier_order_header set estimated_total = 0, delivery_date = '' where school_num = 18653 and schedule_num = 88640 and menu_num = 1004510
==========================================
2026-10-15 17:28:06
DB: hotlunch
Data truncated for column 'ordered_by_type' at row 1
SQL Query Error (/index.php) orders / insert
INSERT into hotlunch_order_items (order_num, school_num, ordered_by_num, ordered_by_type, schedule_num, menu_num, menu_item_num, menu_item_price, qty, extended_price, taxable_item, options_ordered, options2_ordered, options3_ordered, active, item_added_date) values (0, 18400, 2343067, 'Parent', 87971, 998398, 16642450, 40, 1, 40, 'N', '', '', '', 'Y', '2026-10-15')
==========================================
2026-10-15 17:28:40
DB: hotlunch
Data truncated for column 'ordered_by_type' at row 1
SQL Query Error (/index.php) orders / insert
INSERT into hotlunch_order_items (order_num, school_num, ordered_by_num, ordered_by_type, schedule_num, menu_num, menu_item_num, menu_item_price, qty, extended_price, taxable_item, options_ordered, options2_ordered, options3_ordered, active, item_added_date) values (0, 18400, 2343067, 'Parent', 87971, 998398, 16642450, 40, 1, 40, 'N', '', '', '', 'Y', '2026-10-15')
==========================================
2026-10-15 17:30:17
DB: hotlunch
Data truncated for column 'ordered_by_type' at row 1
SQL Query Error (/index.php) orders / insert
INSERT into hotlunch_order_items (order_num, school_num, ordered_by_num, ordered_by_type, schedule_num, menu_num, menu_item_num, menu_item_price, qty, extended_price, taxable_item, options_ordered, options2_ordered, options3_ordered, active, item_added_date) values (0, 18400, 2343067, 'Parent', 87971, 998398, 16642450, 40, 1, 40, 'N', '', '', '', 'Y', '2026-10-15')
==========================================
2026-10-16 06:40:39
DB: hotlunch
Lock wait timeout exceeded; try restarting transaction
SQL Query Error (/index.php) orders / edit
UPDATE hotlunch_order_items SET order_num = 10815416 WHERE school_num = 20141 AND ordered_by_num = 2268381 AND schedule_num = 86357 AND order_num = 0
==========================================
2026-10-16 06:41:22
DB: hotlunch
Lock wait timeout exceeded; try restarting transaction
SQL Query Error (/index.php) orders / edit
UPDATE hotlunch_order_items SET order_num = 10865955 WHERE school_num = 20497 AND ordered_by_num = 2381896 AND schedule_num = 86225 AND order_num = 0
==========================================
2026-10-16 06:41:30
DB: hotlunch
Lock wait timeout exceeded; try restarting transaction
SQL Query Error (/index.php) orders / edit
UPDATE hotlunch_order_items SET order_num = 10815416 WHERE school_num = 20141 AND ordered_by_num = 2268381 AND schedule_num = 86357 AND order_num = 0
==========================================
2026-10-16 05:42:59
DB: hotlunch
Incorrect date value: 'NaN-NaN-NaN' for column 'menu_date' at row 1
SQL Query Error (/ajax.DataRecord.Update.php)
UPDATE hotlunch_menu_dates set school_num = 20225, schedule_num = 88792, menu_title = 'Hot Lunch', menu_date = 'NaN-NaN-NaN', menu_type = 'Regular', order_format = 'Quantity', display_supplier_code = 'N', num_volunteer_override = 'D', max_volunteers = 0, volunteer_msg = '', order_revenue = 0, other_revenue = 0, supplier_costs = 0, other_costs = 0, net_revenue = 330.45, menu_link = 'No', source_menu = 0, group_a = 0, group_a_min = 0, group_a_available = NULL, group_a_max_message = '', group_b = 0, group_b_available = NULL, group_b_a_required = 'N', group_b_mandatory = 'N', group_b_message = '', group_b_max_message = '', group_c = 0, group_c_available = NULL, group_c_a_required = 'N', group_c_mandatory = 'N', group_c_message = '', group_c_max_message = '', group_d = 0, group_d_available = NULL, group_d_a_required = 'N', group_d_mandatory = 'N', group_d_message = '', group_e = 0, group_e_available = NULL, group_e_a_required = 'N', group_e_mandatory = 'N', group_e_message = '', group_f = 0, group_f_available = NULL, group_f_a_required = 'N', group_f_mandatory = 'N', group_g = 0, group_g_available = NULL, group_g_a_required = 'N', group_g_mandatory = 'N', group_h = 0, group_h_available = NULL, group_h_a_required = 'N', group_h_mandatory = 'N', group_i = 0, group_i_available = NULL, group_i_a_required = 'N', group_i_mandatory = 'N', group_j = 0, group_j_available = NULL, group_j_a_required = 'N', group_j_mandatory = 'N', group_k = 0, group_k_available = NULL, group_k_a_required = 'N', group_k_mandatory = 'N', group_l = 0, group_l_available = NULL, group_l_a_required = 'N', group_l_mandatory = 'N', group_m = 0, group_m_available = NULL, group_m_a_required = 'N', group_m_mandatory = 'N', display_group_colors = 'D', display_group_letters = 'D', menu_instructions = '', email_message = '', active = 'Y' where record_num = 1006038
==========================================
2026-10-16 12:34:16
DB: hotlunch
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 'AND trx_num = 0 AND trx_result = '' AND authcode = '' AND record_num != 4636' at line 1
SQL Query Error (/thanks.php)
SELECT * FROM user_merchant_account_transactions WHERE school_num = AND trx_num = 0 AND trx_result = '' AND authcode = '' AND record_num != 4636
==========================================
2026-10-16 16:52:12
DB: hotlunch
Data truncated for column 'ordered_by_type' at row 1
SQL Query Error (/index.php) orders / insert
INSERT into hotlunch_order_items (order_num, school_num, ordered_by_num, ordered_by_type, schedule_num, menu_num, menu_item_num, menu_item_price, qty, extended_price, taxable_item, options_ordered, options2_ordered, options3_ordered, active, item_added_date) values (0, 19381, 2367589, 'Parent', 88625, 1004385, 16707003, 2.25, 1, 2.25, 'N', '', '', '', 'Y', '2026-10-16')
==========================================
2026-10-16 16:52:49
DB: hotlunch
Data truncated for column 'ordered_by_type' at row 1
SQL Query Error (/index.php) orders / insert
INSERT into hotlunch_order_items (order_num, school_num, ordered_by_num, ordered_by_type, schedule_num, menu_num, menu_item_num, menu_item_price, qty, extended_price, taxable_item, options_ordered, options2_ordered, options3_ordered, active, item_added_date) values (0, 19381, 2367589, 'Parent', 88625, 1004385, 16707003, 2.25, 1, 2.25, 'N', '', '', '', 'Y', '2026-10-16')
==========================================
2026-10-16 16:52:59
DB: hotlunch
Data truncated for column 'ordered_by_type' at row 1
SQL Query Error (/index.php) orders / insert
INSERT into hotlunch_order_items (order_num, school_num, ordered_by_num, ordered_by_type, schedule_num, menu_num, menu_item_num, menu_item_price, qty, extended_price, taxable_item, options_ordered, options2_ordered, options3_ordered, active, item_added_date) values (0, 19381, 2367589, 'Parent', 88625, 1004385, 16707003, 2.25, 1, 2.25, 'N', '', '', '', 'Y', '2026-10-16')
==========================================
2026-10-16 15:27:46
DB: hotlunch
Data truncated for column 'ordered_by_type' at row 1
SQL Query Error (/index.php) orders / insert
INSERT into hotlunch_order_items (order_num, school_num, ordered_by_num, ordered_by_type, schedule_num, menu_num, menu_item_num, menu_item_price, qty, extended_price, taxable_item, options_ordered, options2_ordered, options3_ordered, active, item_added_date) values (0, 18400, 2343067, 'Parent', 86395, 981385, 16556505, 3.15, 2, 6.3, 'N', '', '', '', 'Y', '2026-10-16')
==========================================
2026-10-16 15:27:55
DB: hotlunch
Data truncated for column 'ordered_by_type' at row 1
SQL Query Error (/index.php) orders / insert
INSERT into hotlunch_order_items (order_num, school_num, ordered_by_num, ordered_by_type, schedule_num, menu_num, menu_item_num, menu_item_price, qty, extended_price, taxable_item, options_ordered, options2_ordered, options3_ordered, active, item_added_date) values (0, 18400, 2343067, 'Parent', 86395, 981385, 16556505, 3.15, 2, 6.3, 'N', '', '', '', 'Y', '2026-10-16')
==========================================
2026-10-16 15:28:34
DB: hotlunch
Data truncated for column 'ordered_by_type' at row 1
SQL Query Error (/index.php) orders / insert
INSERT into hotlunch_order_items (order_num, school_num, ordered_by_num, ordered_by_type, schedule_num, menu_num, menu_item_num, menu_item_price, qty, extended_price, taxable_item, options_ordered, options2_ordered, options3_ordered, active, item_added_date) values (0, 18400, 2343067, 'Parent', 86395, 981385, 16556505, 3.15, 2, 6.3, 'N', '', '', '', 'Y', '2026-10-16')
==========================================
2026-10-16 15:32:56
DB: hotlunch
Data truncated for column 'ordered_by_type' at row 1
SQL Query Error (/index.php) orders / insert
INSERT into hotlunch_order_items (order_num, school_num, ordered_by_num, ordered_by_type, schedule_num, menu_num, menu_item_num, menu_item_price, qty, extended_price, taxable_item, options_ordered, options2_ordered, options3_ordered, active, item_added_date) values (0, 18400, 2343067, 'Parent', 86395, 981385, 16556505, 3.15, 1, 3.15, 'N', '', '', '', 'Y', '2026-10-16')
==========================================
2026-10-16 16:18:46
DB: hotlunch
Unknown column 'record_num' in 'where clause'
SQL Query Error (/ajax.DataRecord.Update.php)
UPDATE admin_user_access set school_num = 20558, access = 'Y' where record_num = 1740129
==========================================
2026-10-16 16:19:38
DB: hotlunch
Unknown column 'record_num' in 'where clause'
SQL Query Error (/ajax.DataRecord.Update.php)
UPDATE admin_user_access set school_num = 20558, access = 'Y' where record_num = 425627
==========================================
2026-10-17 13:25:41
DB: hotlunch
Duplicate entry '249-88848-1007155-52543' for key 'hotlunch_menu_dates_classes.PRIMARY'
SQL Query Error (/ajax.MenuDates.Update.php) copy-menu
INSERT into hotlunch_menu_dates_classes (school_num, schedule_num, menu_num, class_num) values (249, 88848, 1007155, 52543)