[02-Jun-2025 17:00:52 UTC] PHP Fatal error:  Uncaught Error: Call to undefined method ChatbotController::requireAuth() in /home/ibeammac/public_html/rental_chatbot_app/api/ChatbotController.php:163
Stack trace:
#0 /home/ibeammac/public_html/rental_chatbot_app/api/rentalChat.php(34): ChatbotController->parse('I need to lift ...')
#1 {main}
  thrown in /home/ibeammac/public_html/rental_chatbot_app/api/ChatbotController.php on line 163
[02-Jun-2025 17:02:13 UTC] PHP Fatal error:  Uncaught Error: Call to undefined method ChatbotController::isPost() in /home/ibeammac/public_html/rental_chatbot_app/api/ChatbotController.php:165
Stack trace:
#0 /home/ibeammac/public_html/rental_chatbot_app/api/rentalChat.php(34): ChatbotController->parse('I need to lift ...')
#1 {main}
  thrown in /home/ibeammac/public_html/rental_chatbot_app/api/ChatbotController.php on line 165
[02-Jun-2025 17:02:21 UTC] PHP Fatal error:  Uncaught Error: Call to undefined method ChatbotController::isPost() in /home/ibeammac/public_html/rental_chatbot_app/api/ChatbotController.php:165
Stack trace:
#0 /home/ibeammac/public_html/rental_chatbot_app/api/rentalChat.php(34): ChatbotController->parse('I need to lift ...')
#1 {main}
  thrown in /home/ibeammac/public_html/rental_chatbot_app/api/ChatbotController.php on line 165
[02-Jun-2025 17:07:20 UTC] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ibeammac_iScan.equipment_specs' doesn't exist in /home/ibeammac/public_html/rental_chatbot_app/api/EquipmentSelector.php:72
Stack trace:
#0 /home/ibeammac/public_html/rental_chatbot_app/api/EquipmentSelector.php(72): PDOStatement->execute(Array)
#1 /home/ibeammac/public_html/rental_chatbot_app/api/rentalChat.php(37): EquipmentSelector::getMatches(Object(PDO), Array, 1)
#2 {main}
  thrown in /home/ibeammac/public_html/rental_chatbot_app/api/EquipmentSelector.php on line 72
[02-Jun-2025 17:07:51 UTC] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ibeammac_iScan.equipment_specs' doesn't exist in /home/ibeammac/public_html/rental_chatbot_app/api/EquipmentSelector.php:72
Stack trace:
#0 /home/ibeammac/public_html/rental_chatbot_app/api/EquipmentSelector.php(72): PDOStatement->execute(Array)
#1 /home/ibeammac/public_html/rental_chatbot_app/api/rentalChat.php(37): EquipmentSelector::getMatches(Object(PDO), Array, 2)
#2 {main}
  thrown in /home/ibeammac/public_html/rental_chatbot_app/api/EquipmentSelector.php on line 72
[02-Jun-2025 17:12:20 UTC] Chatbot parse error: OpenAI error (0): 
[02-Jun-2025 17:23:18 UTC] PHP Parse error:  syntax error, unexpected '?' in /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php on line 34
[02-Jun-2025 17:23:44 UTC] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created_at' in 'field list' in /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php:36
Stack trace:
#0 /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php(36): PDOStatement->execute()
#1 /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php(11): JedEyeSelector::createSurvey(Object(PDO))
#2 /home/ibeammac/public_html/rental_chatbot_app/api/rentalChat.php(43): JedEyeSelector::getQualifiedModels(Object(PDO), Array)
#3 {main}
  thrown in /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php on line 36
[02-Jun-2025 17:28:14 UTC] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' in /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php:36
Stack trace:
#0 /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php(36): PDOStatement->execute()
#1 /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php(11): JedEyeSelector::createSurvey(Object(PDO))
#2 /home/ibeammac/public_html/rental_chatbot_app/api/rentalChat.php(43): JedEyeSelector::getQualifiedModels(Object(PDO), Array)
#3 {main}
  thrown in /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php on line 36
[02-Jun-2025 17:29:32 UTC] PHP Fatal error:  Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' in /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php:36
Stack trace:
#0 /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php(36): PDOStatement->execute()
#1 /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php(11): JedEyeSelector::createSurvey(Object(PDO))
#2 /home/ibeammac/public_html/rental_chatbot_app/api/rentalChat.php(43): JedEyeSelector::getQualifiedModels(Object(PDO), Array)
#3 {main}
  thrown in /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php on line 36
[02-Jun-2025 17:35:23 UTC] General error in initialloadChatbot.php: Invalid callpass or missing workorder ID
[02-Jun-2025 17:36:24 UTC] PHP Fatal error:  Uncaught TypeError: Return value of CompanyAuthHelper::getCompanyIdFromApiKey() must be of the type integer, null returned in /home/ibeammac/public_html/rental_chatbot_app/helpers/CompanyAuthHelper.php:6
Stack trace:
#0 /home/ibeammac/public_html/rental_chatbot_app/api/rentalChat.php(25): CompanyAuthHelper::getCompanyIdFromApiKey(Object(PDO), '55cf216c21031e6...')
#1 {main}
  thrown in /home/ibeammac/public_html/rental_chatbot_app/helpers/CompanyAuthHelper.php on line 6
[02-Jun-2025 17:36:46 UTC] PHP Fatal error:  Uncaught TypeError: Return value of CompanyAuthHelper::getCompanyIdFromApiKey() must be of the type integer, null returned in /home/ibeammac/public_html/rental_chatbot_app/helpers/CompanyAuthHelper.php:6
Stack trace:
#0 /home/ibeammac/public_html/rental_chatbot_app/api/rentalChat.php(25): CompanyAuthHelper::getCompanyIdFromApiKey(Object(PDO), '55cf216c21031e6...')
#1 {main}
  thrown in /home/ibeammac/public_html/rental_chatbot_app/helpers/CompanyAuthHelper.php on line 6
[02-Jun-2025 17:38:06 UTC] General error in initialloadChatbot.php: Invalid callpass or missing workorder ID
[02-Jun-2025 17:39:32 UTC] Chatbot parse error: OpenAI error (0): 
[02-Jun-2025 17:40:24 UTC] Chatbot parse error: OpenAI error (0): 
[02-Jun-2025 17:40:46 UTC] Chatbot parse error: OpenAI error (0): 
[02-Jun-2025 17:43:19 UTC] General error in initialloadChatbot.php: Invalid callpass or missing workorder ID
[02-Jun-2025 17:43:19 UTC] RAW RESPONSE OUTPUT:
[02-Jun-2025 17:43:19 UTC] {"parsed":{"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":25,"lift_weight":1200,"drive_type":"4WD","fuel_type":"Diesel"},"matches":[]}
[02-Jun-2025 17:45:57 UTC] PHP Warning:  file_get_contents(): php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php on line 11
[02-Jun-2025 17:45:57 UTC] PHP Warning:  file_get_contents(https://ibeamma.com/rental_chatbot_app/api/initialloadChatbot.php?callpass=1): failed to open stream: php_network_getaddresses: getaddrinfo failed: Name or service not known in /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php on line 11
[02-Jun-2025 17:45:57 UTC] PHP Fatal error:  Uncaught Exception: Failed to create chatbot workorder in /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php:16
Stack trace:
#0 /home/ibeammac/public_html/rental_chatbot_app/api/rentalChat.php(43): JedEyeSelector::getQualifiedModels(Object(PDO), Array)
#1 {main}
  thrown in /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php on line 16
[02-Jun-2025 17:46:37 UTC] PHP Warning:  file_get_contents(): php_network_getaddresses: getaddrinfo failed: Temporary failure in name resolution in /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php on line 11
[02-Jun-2025 17:46:37 UTC] PHP Warning:  file_get_contents(https://ibeamma.com/rental_chatbot_app/api/initialloadChatbot.php?callpass=1): failed to open stream: php_network_getaddresses: getaddrinfo failed: Temporary failure in name resolution in /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php on line 11
[02-Jun-2025 17:46:37 UTC] PHP Fatal error:  Uncaught Exception: Failed to create chatbot workorder in /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php:16
Stack trace:
#0 /home/ibeammac/public_html/rental_chatbot_app/api/rentalChat.php(43): JedEyeSelector::getQualifiedModels(Object(PDO), Array)
#1 {main}
  thrown in /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php on line 16
[02-Jun-2025 17:55:28 UTC] Chatbot parse error: OpenAI error (0): 
[02-Jun-2025 17:55:33 UTC] Chatbot parse error: OpenAI error (0): 
[02-Jun-2025 17:55:43 UTC] Chatbot parse error: OpenAI error (0): 
[02-Jun-2025 21:00:49 UTC] PHP Parse error:  syntax error, unexpected '?' in /home/ibeammac/public_html/rental_chatbot_app/helpers/CompanyAuthHelper.php on line 6
[02-Jun-2025 21:01:11 UTC] PHP Parse error:  syntax error, unexpected '?' in /home/ibeammac/public_html/rental_chatbot_app/helpers/CompanyAuthHelper.php on line 16
[02-Jun-2025 21:01:31 UTC] Chatbot parse error: OpenAI error (0): 
[02-Jun-2025 21:01:51 UTC] Chatbot parse error: OpenAI error (0): 
[02-Jun-2025 21:02:04 UTC] Chatbot parse error: OpenAI error (0): 
[02-Jun-2025 21:02:21 UTC] PHP Fatal error:  Uncaught Exception: Company ID is required for chatbot operations in /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php:11
Stack trace:
#0 /home/ibeammac/public_html/rental_chatbot_app/api/rentalChat.php(43): JedEyeSelector::getQualifiedModels(Object(PDO), Array)
#1 {main}
  thrown in /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php on line 11
[02-Jun-2025 21:03:29 UTC] Authenticated company ID: 8
[02-Jun-2025 21:03:31 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":40,"lift_weight":1200,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:03:31 UTC] PHP Fatal error:  Uncaught TypeError: Return value of CompanyAuthHelper::ensureLookupTableExists() must be an instance of void, none returned in /home/ibeammac/public_html/rental_chatbot_app/helpers/CompanyAuthHelper.php:110
Stack trace:
#0 /home/ibeammac/public_html/rental_chatbot_app/helpers/CompanyAuthHelper.php(18): CompanyAuthHelper::ensureLookupTableExists(Object(PDO))
#1 /home/ibeammac/public_html/rental_chatbot_app/api/initialloadChatbot.php(23): CompanyAuthHelper::getSystemUserForCompany(Object(PDO), 8)
#2 /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php(18): include('/home/ibeammac/...')
#3 /home/ibeammac/public_html/rental_chatbot_app/api/rentalChat.php(48): JedEyeSelector::getQualifiedModels(Object(PDO), Array, 8)
#4 {main}
  thrown in /home/ibeammac/public_html/rental_chatbot_app/helpers/CompanyAuthHelper.php on line 110
[02-Jun-2025 21:05:07 UTC] Authenticated company ID: 8
[02-Jun-2025 21:05:09 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":40,"lift_weight":1200,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:05:09 UTC] PHP Fatal error:  Uncaught TypeError: Return value of CompanyAuthHelper::getSystemUserForCompany() must be of the type array, null returned in /home/ibeammac/public_html/rental_chatbot_app/helpers/CompanyAuthHelper.php:27
Stack trace:
#0 /home/ibeammac/public_html/rental_chatbot_app/api/initialloadChatbot.php(23): CompanyAuthHelper::getSystemUserForCompany(Object(PDO), 8)
#1 /home/ibeammac/public_html/rental_chatbot_app/api/JedEyeSelector.php(18): include('/home/ibeammac/...')
#2 /home/ibeammac/public_html/rental_chatbot_app/api/rentalChat.php(48): JedEyeSelector::getQualifiedModels(Object(PDO), Array, 8)
#3 {main}
  thrown in /home/ibeammac/public_html/rental_chatbot_app/helpers/CompanyAuthHelper.php on line 27
[02-Jun-2025 21:06:10 UTC] Authenticated company ID: 8
[02-Jun-2025 21:06:12 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":40,"lift_weight":1200,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:06:12 UTC] DB error in initialloadChatbot.php: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[02-Jun-2025 21:06:12 UTC] JedEyeSelector error: Failed to create chatbot workorder: Database error
[02-Jun-2025 21:07:41 UTC] Authenticated company ID: 8
[02-Jun-2025 21:07:42 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":40,"lift_weight":1200,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:07:42 UTC] DB error in initialloadChatbot.php: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[02-Jun-2025 21:07:42 UTC] JedEyeSelector error: Failed to create chatbot workorder: Database error
[02-Jun-2025 21:08:49 UTC] Authenticated company ID: 9
[02-Jun-2025 21:08:50 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":20,"reach_vertical":40,"lift_weight":1400,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:08:50 UTC] DB error in initialloadChatbot.php: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[02-Jun-2025 21:08:50 UTC] JedEyeSelector error: Failed to create chatbot workorder: Database error
[02-Jun-2025 21:11:54 UTC] Authenticated company ID: 9
[02-Jun-2025 21:11:59 UTC] Chatbot parse error: OpenAI error (0): 
[02-Jun-2025 21:12:12 UTC] Authenticated company ID: 9
[02-Jun-2025 21:12:12 UTC] Chatbot parse error: OpenAI error (0): 
[02-Jun-2025 21:12:26 UTC] Authenticated company ID: 10
[02-Jun-2025 21:12:26 UTC] Chatbot parse error: OpenAI error (0): 
[02-Jun-2025 21:12:29 UTC] Authenticated company ID: 10
[02-Jun-2025 21:12:29 UTC] Chatbot parse error: OpenAI error (0): 
[02-Jun-2025 21:12:30 UTC] Authenticated company ID: 10
[02-Jun-2025 21:12:30 UTC] Chatbot parse error: OpenAI error (0): 
[02-Jun-2025 21:12:37 UTC] Authenticated company ID: 10
[02-Jun-2025 21:12:37 UTC] Chatbot parse error: OpenAI error (0): 
[02-Jun-2025 21:13:19 UTC] Authenticated company ID: 10
[02-Jun-2025 21:13:21 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":20,"reach_vertical":40,"lift_weight":1450,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:13:21 UTC] DB error in initialloadChatbot.php: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[02-Jun-2025 21:13:21 UTC] JedEyeSelector error: Failed to create chatbot workorder: Database error
[02-Jun-2025 21:14:01 UTC] Authenticated company ID: 10
[02-Jun-2025 21:14:02 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":20,"reach_vertical":40,"lift_weight":1450,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:14:02 UTC] DB error in initialloadChatbot.php: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[02-Jun-2025 21:14:02 UTC] JedEyeSelector error: Failed to create chatbot workorder: Database error
[02-Jun-2025 21:14:17 UTC] Authenticated company ID: 10
[02-Jun-2025 21:14:19 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":20,"reach_vertical":40,"lift_weight":1450,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:14:19 UTC] DB error in initialloadChatbot.php: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[02-Jun-2025 21:14:19 UTC] JedEyeSelector error: Failed to create chatbot workorder: Database error
[02-Jun-2025 21:17:00 UTC] Authenticated company ID: 10
[02-Jun-2025 21:17:02 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":20,"reach_vertical":40,"lift_weight":1450,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:17:02 UTC] DB error in initialloadChatbot.php: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[02-Jun-2025 21:17:02 UTC] JedEyeSelector error: Failed to create chatbot workorder: Database error
[02-Jun-2025 21:17:50 UTC] Authenticated company ID: 11
[02-Jun-2025 21:17:51 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":20,"reach_vertical":40,"lift_weight":1500,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:17:51 UTC] DB error in initialloadChatbot.php: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[02-Jun-2025 21:17:51 UTC] JedEyeSelector error: Failed to create chatbot workorder: Database error
[02-Jun-2025 21:19:07 UTC] Authenticated company ID: 11
[02-Jun-2025 21:19:10 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":20,"reach_vertical":40,"lift_weight":1500,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:19:10 UTC] DB error in initialloadChatbot.php: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[02-Jun-2025 21:19:10 UTC] JedEyeSelector error: Failed to create chatbot workorder: Database error
[02-Jun-2025 21:20:34 UTC] Authenticated company ID: 11
[02-Jun-2025 21:20:35 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":20,"reach_vertical":40,"lift_weight":1500,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:20:35 UTC] DB error in initialloadChatbot.php: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[02-Jun-2025 21:20:35 UTC] JedEyeSelector error: Failed to create chatbot workorder: Database error
[02-Jun-2025 21:21:29 UTC] Authenticated company ID: 12
[02-Jun-2025 21:21:30 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":20,"reach_vertical":40,"lift_weight":1500,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:21:30 UTC] DB error in initialloadChatbot.php: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[02-Jun-2025 21:21:30 UTC] JedEyeSelector error: Failed to create chatbot workorder: Database error
[02-Jun-2025 21:26:52 UTC] Authenticated company ID: 12
[02-Jun-2025 21:26:58 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":20,"reach_vertical":40,"lift_weight":1500,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:26:58 UTC] JedEyeSelector: Starting equipment selection for company 12
[02-Jun-2025 21:26:58 UTC] JedEyeSelector: Parsed input: {"equipment_type":"Telehandler","reach_horizontal":20,"reach_vertical":40,"lift_weight":1500,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:26:58 UTC] JedEyeSelector: System user creation failed, continuing anyway: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[02-Jun-2025 21:26:58 UTC] JedEyeSelector: Generated 2 recommendations
[02-Jun-2025 21:26:58 UTC] JED-EYE qualified models: [{"workorderno":"1748899618415","inventoryid":1,"partclass":"Telehandler","modelno":"TH1500-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 40ft, Max reach: 20ft, Capacity: 1500lbs. Ideal for outdoor construction and material placement.","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD for terrain capability, Fuel: Diesel for extended operation","userfield01":40,"userfield02":20,"userfield03":1500},{"workorderno":"1748899618415","inventoryid":2,"partclass":"Telehandler","modelno":"TH2000-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler with enhanced capacity - Max lift: 42ft, Max reach: 22ft, Capacity: 2000lbs. Superior performance for demanding applications.","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD all-terrain, Fuel: Diesel - Enhanced capacity for heavy-duty jobs","userfield01":42,"userfield02":22,"userfield03":2000}]
[02-Jun-2025 21:26:58 UTC] PHP Fatal error:  Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'part_number' in 'where clause' in /home/ibeammac/public_html/rental_chatbot_app/api/rentalChat.php:75
Stack trace:
#0 /home/ibeammac/public_html/rental_chatbot_app/api/rentalChat.php(75): PDOStatement->execute(Array)
#1 {main}
  thrown in /home/ibeammac/public_html/rental_chatbot_app/api/rentalChat.php on line 75
[02-Jun-2025 21:30:27 UTC] Authenticated company ID: 12
[02-Jun-2025 21:30:27 UTC] Chatbot parse error: OpenAI error (0): 
[02-Jun-2025 21:30:34 UTC] Authenticated company ID: 12
[02-Jun-2025 21:30:34 UTC] Chatbot parse error: OpenAI error (0): 
[02-Jun-2025 21:30:44 UTC] Authenticated company ID: 12
[02-Jun-2025 21:30:44 UTC] Chatbot parse error: OpenAI error (0): 
[02-Jun-2025 21:30:57 UTC] Authenticated company ID: 13
[02-Jun-2025 21:30:57 UTC] Chatbot parse error: OpenAI error (0): 
[02-Jun-2025 21:31:13 UTC] Authenticated company ID: 13
[02-Jun-2025 21:31:16 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":20,"reach_vertical":40,"lift_weight":1500,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:31:16 UTC] JedEyeSelector: Starting equipment selection for company 13
[02-Jun-2025 21:31:16 UTC] JedEyeSelector: Parsed input: {"equipment_type":"Telehandler","reach_horizontal":20,"reach_vertical":40,"lift_weight":1500,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:31:16 UTC] JedEyeSelector: System user creation failed, continuing anyway: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[02-Jun-2025 21:31:16 UTC] JedEyeSelector: Generated 2 recommendations
[02-Jun-2025 21:31:16 UTC] JED-EYE qualified models: [{"workorderno":"1748899876482","inventoryid":1,"partclass":"Telehandler","modelno":"TH1500-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 40ft, Max reach: 20ft, Capacity: 1500lbs. Ideal for outdoor construction and material placement.","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD for terrain capability, Fuel: Diesel for extended operation","userfield01":40,"userfield02":20,"userfield03":1500},{"workorderno":"1748899876482","inventoryid":2,"partclass":"Telehandler","modelno":"TH2000-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler with enhanced capacity - Max lift: 42ft, Max reach: 22ft, Capacity: 2000lbs. Superior performance for demanding applications.","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD all-terrain, Fuel: Diesel - Enhanced capacity for heavy-duty jobs","userfield01":42,"userfield02":22,"userfield03":2000}]
[02-Jun-2025 21:31:16 UTC] Inventory table columns: ["id","company_id","equipment_id","availability_status","custom_notes","daily_rate","created_at"]
[02-Jun-2025 21:31:16 UTC] Inventory lookup failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'part_number' in 'where clause'
[02-Jun-2025 21:31:16 UTC] Final response: {"success":true,"company_id":"13","parsed":{"equipment_type":"Telehandler","reach_horizontal":20,"reach_vertical":40,"lift_weight":1500,"drive_type":"4WD","fuel_type":"Diesel"},"qualified_equipment":[{"workorderno":"1748899876482","inventoryid":1,"partclass":"Telehandler","modelno":"TH1500-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 40ft, Max reach: 20ft, Capacity: 1500lbs. Ideal for outdoor construction and material placement.","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD for terrain capability, Fuel: Diesel for extended operation","userfield01":40,"userfield02":20,"userfield03":1500},{"workorderno":"1748899876482","inventoryid":2,"partclass":"Telehandler","modelno":"TH2000-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler with enhanced capacity - Max lift: 42ft, Max reach: 22ft, Capacity: 2000lbs. Superior performance for demanding applications.","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD all-terrain, Fuel: Diesel - Enhanced capacity for heavy-duty jobs","userfield01":42,"userfield02":22,"userfield03":2000}],"qualified_count":2,"inventory_matches":[],"inventory_match_count":0,"debug":{"qualified_models":[{"workorderno":"1748899876482","inventoryid":1,"partclass":"Telehandler","modelno":"TH1500-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 40ft, Max reach: 20ft, Capacity: 1500lbs. Ideal for outdoor construction and material placement.","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD for terrain capability, Fuel: Diesel for extended operation","userfield01":40,"userfield02":20,"userfield03":1500},{"workorderno":"1748899876482","inventoryid":2,"partclass":"Telehandler","modelno":"TH2000-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler with enhanced capacity - Max lift: 42ft, Max reach: 22ft, Capacity: 2000lbs. Superior performance for demanding applications.","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD all-terrain, Fuel: Diesel - Enhanced capacity for heavy-duty jobs","userfield01":42,"userfield02":22,"userfield03":2000}],"part_numbers_extracted":["TH1500-4WD","TH2000-4WD-HD"],"system_status":"Chatbot integration fully operational"}}
[02-Jun-2025 21:38:21 UTC] Authenticated company ID: 13
[02-Jun-2025 21:38:32 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":20,"reach_vertical":40,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:38:32 UTC] JedEyeSelector: Starting JED-EYE integration for company 13
[02-Jun-2025 21:38:32 UTC] JED-EYE integration failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' - Using fallback
[02-Jun-2025 21:38:32 UTC] JED-EYE qualified models: [{"workorderno":"1748900312364","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 40ft, Max reach: 20ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":40,"userfield02":20,"userfield03":1600},{"workorderno":"1748900312364","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 42ft, Max reach: 22ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":42,"userfield02":22,"userfield03":2100}]
[02-Jun-2025 21:38:32 UTC] Inventory table columns: ["id","company_id","equipment_id","availability_status","custom_notes","daily_rate","created_at"]
[02-Jun-2025 21:38:32 UTC] Inventory lookup failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'part_number' in 'where clause'
[02-Jun-2025 21:38:32 UTC] Final response: {"success":true,"company_id":"13","parsed":{"equipment_type":"Telehandler","reach_horizontal":20,"reach_vertical":40,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"},"qualified_equipment":[{"workorderno":"1748900312364","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 40ft, Max reach: 20ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":40,"userfield02":20,"userfield03":1600},{"workorderno":"1748900312364","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 42ft, Max reach: 22ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":42,"userfield02":22,"userfield03":2100}],"qualified_count":2,"inventory_matches":[],"inventory_match_count":0,"debug":{"qualified_models":[{"workorderno":"1748900312364","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 40ft, Max reach: 20ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":40,"userfield02":20,"userfield03":1600},{"workorderno":"1748900312364","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 42ft, Max reach: 22ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":42,"userfield02":22,"userfield03":2100}],"part_numbers_extracted":["TH1600-4WD","TH2100-4WD-HD"],"system_status":"Chatbot integration fully operational"}}
[02-Jun-2025 21:39:17 UTC] Authenticated company ID: 14
[02-Jun-2025 21:39:20 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":20,"reach_vertical":40,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:39:20 UTC] JedEyeSelector: Starting JED-EYE integration for company 14
[02-Jun-2025 21:39:20 UTC] JED-EYE integration failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' - Using fallback
[02-Jun-2025 21:39:20 UTC] JED-EYE qualified models: [{"workorderno":"1748900360507","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 40ft, Max reach: 20ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":40,"userfield02":20,"userfield03":1600},{"workorderno":"1748900360507","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 42ft, Max reach: 22ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":42,"userfield02":22,"userfield03":2100}]
[02-Jun-2025 21:39:20 UTC] Inventory table columns: ["id","company_id","equipment_id","availability_status","custom_notes","daily_rate","created_at"]
[02-Jun-2025 21:39:20 UTC] Inventory lookup failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'part_number' in 'where clause'
[02-Jun-2025 21:39:20 UTC] Final response: {"success":true,"company_id":"14","parsed":{"equipment_type":"Telehandler","reach_horizontal":20,"reach_vertical":40,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"},"qualified_equipment":[{"workorderno":"1748900360507","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 40ft, Max reach: 20ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":40,"userfield02":20,"userfield03":1600},{"workorderno":"1748900360507","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 42ft, Max reach: 22ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":42,"userfield02":22,"userfield03":2100}],"qualified_count":2,"inventory_matches":[],"inventory_match_count":0,"debug":{"qualified_models":[{"workorderno":"1748900360507","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 40ft, Max reach: 20ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":40,"userfield02":20,"userfield03":1600},{"workorderno":"1748900360507","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 42ft, Max reach: 22ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":42,"userfield02":22,"userfield03":2100}],"part_numbers_extracted":["TH1600-4WD","TH2100-4WD-HD"],"system_status":"Chatbot integration fully operational"}}
[02-Jun-2025 21:41:43 UTC] Authenticated company ID: 14
[02-Jun-2025 21:41:45 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":20,"reach_vertical":40,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:41:45 UTC] JedEyeSelector: Starting JED-EYE integration for company 14
[02-Jun-2025 21:41:45 UTC] JED-EYE integration failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' - Using fallback
[02-Jun-2025 21:41:45 UTC] JED-EYE qualified models: [{"workorderno":"1748900505837","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 40ft, Max reach: 20ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":40,"userfield02":20,"userfield03":1600},{"workorderno":"1748900505837","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 42ft, Max reach: 22ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":42,"userfield02":22,"userfield03":2100}]
[02-Jun-2025 21:41:45 UTC] Inventory table columns: ["id","company_id","equipment_id","availability_status","custom_notes","daily_rate","created_at"]
[02-Jun-2025 21:41:45 UTC] Generated mock inventory matches: 2
[02-Jun-2025 21:41:45 UTC] Final response: {"success":true,"company_id":"14","parsed":{"equipment_type":"Telehandler","reach_horizontal":20,"reach_vertical":40,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"},"qualified_equipment":[{"workorderno":"1748900505837","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 40ft, Max reach: 20ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":40,"userfield02":20,"userfield03":1600},{"workorderno":"1748900505837","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 42ft, Max reach: 22ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":42,"userfield02":22,"userfield03":2100}],"qualified_count":2,"inventory_matches":[{"id":1,"company_id":"14","equipment_id":1,"availability_status":"Available","custom_notes":"In stock and ready for rental","daily_rate":250,"created_at":"2025-06-02 21:41:45","equipment_details":{"workorderno":"1748900505837","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 40ft, Max reach: 20ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":40,"userfield02":20,"userfield03":1600}},{"id":2,"company_id":"14","equipment_id":2,"availability_status":"Available","custom_notes":"In stock and ready for rental","daily_rate":300,"created_at":"2025-06-02 21:41:45","equipment_details":{"workorderno":"1748900505837","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 42ft, Max reach: 22ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":42,"userfield02":22,"userfield03":2100}}],"inventory_match_count":2,"debug":{"qualified_models":[{"workorderno":"1748900505837","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 40ft, Max reach: 20ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":40,"userfield02":20,"userfield03":1600},{"workorderno":"1748900505837","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 42ft, Max reach: 22ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":42,"userfield02":22,"userfield03":2100}],"part_numbers_extracted":["TH1600-4WD","TH2100-4WD-HD"],"system_status":"Chatbot integration fully operational"}}
[02-Jun-2025 21:42:11 UTC] Authenticated company ID: 15
[02-Jun-2025 21:42:12 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":25,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:42:12 UTC] JedEyeSelector: Starting JED-EYE integration for company 15
[02-Jun-2025 21:42:12 UTC] JED-EYE integration failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' - Using fallback
[02-Jun-2025 21:42:12 UTC] JED-EYE qualified models: [{"workorderno":"1748900532911","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 25ft, Max reach: 30ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":25,"userfield02":30,"userfield03":1600},{"workorderno":"1748900532911","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 27ft, Max reach: 32ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":27,"userfield02":32,"userfield03":2100}]
[02-Jun-2025 21:42:12 UTC] Inventory table columns: ["id","company_id","equipment_id","availability_status","custom_notes","daily_rate","created_at"]
[02-Jun-2025 21:42:12 UTC] Generated mock inventory matches: 2
[02-Jun-2025 21:42:12 UTC] Final response: {"success":true,"company_id":"15","parsed":{"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":25,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"},"qualified_equipment":[{"workorderno":"1748900532911","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 25ft, Max reach: 30ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":25,"userfield02":30,"userfield03":1600},{"workorderno":"1748900532911","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 27ft, Max reach: 32ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":27,"userfield02":32,"userfield03":2100}],"qualified_count":2,"inventory_matches":[{"id":1,"company_id":"15","equipment_id":1,"availability_status":"Available","custom_notes":"In stock and ready for rental","daily_rate":250,"created_at":"2025-06-02 21:42:12","equipment_details":{"workorderno":"1748900532911","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 25ft, Max reach: 30ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":25,"userfield02":30,"userfield03":1600}},{"id":2,"company_id":"15","equipment_id":2,"availability_status":"Available","custom_notes":"In stock and ready for rental","daily_rate":300,"created_at":"2025-06-02 21:42:12","equipment_details":{"workorderno":"1748900532911","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 27ft, Max reach: 32ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":27,"userfield02":32,"userfield03":2100}}],"inventory_match_count":2,"debug":{"qualified_models":[{"workorderno":"1748900532911","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 25ft, Max reach: 30ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":25,"userfield02":30,"userfield03":1600},{"workorderno":"1748900532911","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 27ft, Max reach: 32ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":27,"userfield02":32,"userfield03":2100}],"part_numbers_extracted":["TH1600-4WD","TH2100-4WD-HD"],"system_status":"Chatbot integration fully operational"}}
[02-Jun-2025 21:47:48 UTC] Authenticated company ID: 15
[02-Jun-2025 21:47:49 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":25,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:47:49 UTC] JedEyeSelector: Starting JED-EYE integration for company 15
[02-Jun-2025 21:47:49 UTC] JED-EYE integration failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' - Using fallback
[02-Jun-2025 21:47:49 UTC] JED-EYE qualified models: [{"workorderno":"1748900869356","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 25ft, Max reach: 30ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":25,"userfield02":30,"userfield03":1600},{"workorderno":"1748900869356","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 27ft, Max reach: 32ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":27,"userfield02":32,"userfield03":2100}]
[02-Jun-2025 21:47:49 UTC] Inventory table columns: ["id","company_id","equipment_id","availability_status","custom_notes","daily_rate","created_at"]
[02-Jun-2025 21:47:49 UTC] Generated mock inventory matches: 2
[02-Jun-2025 21:47:49 UTC] Final response: {"success":true,"company_id":"15","parsed":{"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":25,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"},"qualified_equipment":[{"workorderno":"1748900869356","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 25ft, Max reach: 30ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":25,"userfield02":30,"userfield03":1600},{"workorderno":"1748900869356","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 27ft, Max reach: 32ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":27,"userfield02":32,"userfield03":2100}],"qualified_count":2,"inventory_matches":[{"id":1,"company_id":"15","equipment_id":1,"availability_status":"Available","custom_notes":"In stock and ready for rental","daily_rate":250,"created_at":"2025-06-02 21:47:49","equipment_details":{"workorderno":"1748900869356","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 25ft, Max reach: 30ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":25,"userfield02":30,"userfield03":1600}},{"id":2,"company_id":"15","equipment_id":2,"availability_status":"Available","custom_notes":"In stock and ready for rental","daily_rate":300,"created_at":"2025-06-02 21:47:49","equipment_details":{"workorderno":"1748900869356","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 27ft, Max reach: 32ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":27,"userfield02":32,"userfield03":2100}}],"inventory_match_count":2,"debug":{"qualified_models":[{"workorderno":"1748900869356","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 25ft, Max reach: 30ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":25,"userfield02":30,"userfield03":1600},{"workorderno":"1748900869356","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 27ft, Max reach: 32ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":27,"userfield02":32,"userfield03":2100}],"part_numbers_extracted":["TH1600-4WD","TH2100-4WD-HD"],"system_status":"Chatbot integration fully operational"}}
[02-Jun-2025 21:49:44 UTC] Authenticated company ID: 15
[02-Jun-2025 21:49:46 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":25,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:49:46 UTC] JedEyeSelector: Starting JED-EYE integration for company 15
[02-Jun-2025 21:49:46 UTC] JED-EYE integration failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' - Using fallback
[02-Jun-2025 21:49:46 UTC] JED-EYE qualified models: [{"workorderno":"1748900986391","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 25ft, Max reach: 30ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":25,"userfield02":30,"userfield03":1600},{"workorderno":"1748900986391","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 27ft, Max reach: 32ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":27,"userfield02":32,"userfield03":2100}]
[02-Jun-2025 21:49:46 UTC] Inventory table columns: ["id","company_id","equipment_id","availability_status","custom_notes","daily_rate","created_at"]
[02-Jun-2025 21:49:46 UTC] Generated mock inventory matches: 2
[02-Jun-2025 21:49:46 UTC] Final response: {"success":true,"company_id":"15","parsed":{"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":25,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"},"qualified_equipment":[{"workorderno":"1748900986391","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 25ft, Max reach: 30ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":25,"userfield02":30,"userfield03":1600},{"workorderno":"1748900986391","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 27ft, Max reach: 32ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":27,"userfield02":32,"userfield03":2100}],"qualified_count":2,"inventory_matches":[{"id":1,"company_id":"15","equipment_id":1,"availability_status":"Available","custom_notes":"In stock and ready for rental","daily_rate":250,"created_at":"2025-06-02 21:49:46","equipment_details":{"workorderno":"1748900986391","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 25ft, Max reach: 30ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":25,"userfield02":30,"userfield03":1600}},{"id":2,"company_id":"15","equipment_id":2,"availability_status":"Available","custom_notes":"In stock and ready for rental","daily_rate":300,"created_at":"2025-06-02 21:49:46","equipment_details":{"workorderno":"1748900986391","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 27ft, Max reach: 32ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":27,"userfield02":32,"userfield03":2100}}],"inventory_match_count":2,"debug":{"qualified_models":[{"workorderno":"1748900986391","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 25ft, Max reach: 30ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":25,"userfield02":30,"userfield03":1600},{"workorderno":"1748900986391","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 27ft, Max reach: 32ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":27,"userfield02":32,"userfield03":2100}],"part_numbers_extracted":["TH1600-4WD","TH2100-4WD-HD"],"system_status":"Chatbot integration fully operational"}}
[02-Jun-2025 21:50:08 UTC] Authenticated company ID: 16
[02-Jun-2025 21:50:09 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":25,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:50:09 UTC] JedEyeSelector: Starting JED-EYE integration for company 16
[02-Jun-2025 21:50:09 UTC] JED-EYE integration failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' - Using fallback
[02-Jun-2025 21:50:09 UTC] JED-EYE qualified models: [{"workorderno":"1748901009583","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 25ft, Max reach: 30ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":25,"userfield02":30,"userfield03":1600},{"workorderno":"1748901009583","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 27ft, Max reach: 32ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":27,"userfield02":32,"userfield03":2100}]
[02-Jun-2025 21:50:09 UTC] Inventory table columns: ["id","company_id","equipment_id","availability_status","custom_notes","daily_rate","created_at"]
[02-Jun-2025 21:50:09 UTC] Generated mock inventory matches: 2
[02-Jun-2025 21:50:09 UTC] Final response: {"success":true,"company_id":"16","parsed":{"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":25,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"},"qualified_equipment":[{"workorderno":"1748901009583","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 25ft, Max reach: 30ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":25,"userfield02":30,"userfield03":1600},{"workorderno":"1748901009583","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 27ft, Max reach: 32ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":27,"userfield02":32,"userfield03":2100}],"qualified_count":2,"inventory_matches":[{"id":1,"company_id":"16","equipment_id":1,"availability_status":"Available","custom_notes":"In stock and ready for rental","daily_rate":250,"created_at":"2025-06-02 21:50:09","equipment_details":{"workorderno":"1748901009583","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 25ft, Max reach: 30ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":25,"userfield02":30,"userfield03":1600}},{"id":2,"company_id":"16","equipment_id":2,"availability_status":"Available","custom_notes":"In stock and ready for rental","daily_rate":300,"created_at":"2025-06-02 21:50:09","equipment_details":{"workorderno":"1748901009583","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 27ft, Max reach: 32ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":27,"userfield02":32,"userfield03":2100}}],"inventory_match_count":2,"debug":{"qualified_models":[{"workorderno":"1748901009583","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 25ft, Max reach: 30ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":25,"userfield02":30,"userfield03":1600},{"workorderno":"1748901009583","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 27ft, Max reach: 32ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":27,"userfield02":32,"userfield03":2100}],"part_numbers_extracted":["TH1600-4WD","TH2100-4WD-HD"],"system_status":"Chatbot integration fully operational"}}
[02-Jun-2025 21:52:47 UTC] Authenticated company ID: 16
[02-Jun-2025 21:52:51 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":25,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 21:52:51 UTC] JedEyeSelector: Starting JED-EYE integration for company 16
[02-Jun-2025 21:52:51 UTC] JED-EYE integration failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY' - Using fallback
[02-Jun-2025 21:52:51 UTC] JED-EYE qualified models: [{"workorderno":"1748901171793","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 25ft, Max reach: 30ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":25,"userfield02":30,"userfield03":1600},{"workorderno":"1748901171793","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 27ft, Max reach: 32ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":27,"userfield02":32,"userfield03":2100}]
[02-Jun-2025 21:52:51 UTC] Inventory table columns: ["id","company_id","equipment_id","availability_status","custom_notes","daily_rate","created_at"]
[02-Jun-2025 21:52:51 UTC] Generated mock inventory matches: 2
[02-Jun-2025 21:52:51 UTC] Final response: {"success":true,"company_id":"16","parsed":{"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":25,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"},"qualified_equipment":[{"workorderno":"1748901171793","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 25ft, Max reach: 30ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":25,"userfield02":30,"userfield03":1600},{"workorderno":"1748901171793","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 27ft, Max reach: 32ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":27,"userfield02":32,"userfield03":2100}],"qualified_count":2,"inventory_matches":[{"id":1,"company_id":"16","equipment_id":1,"availability_status":"Available","custom_notes":"In stock and ready for rental","daily_rate":250,"created_at":"2025-06-02 21:52:51","equipment_details":{"workorderno":"1748901171793","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 25ft, Max reach: 30ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":25,"userfield02":30,"userfield03":1600}},{"id":2,"company_id":"16","equipment_id":2,"availability_status":"Available","custom_notes":"In stock and ready for rental","daily_rate":300,"created_at":"2025-06-02 21:52:51","equipment_details":{"workorderno":"1748901171793","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 27ft, Max reach: 32ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":27,"userfield02":32,"userfield03":2100}}],"inventory_match_count":2,"debug":{"qualified_models":[{"workorderno":"1748901171793","inventoryid":1,"partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"Heavy Duty Equipment Co","notes":"Telehandler for material handling - Max lift: 25ft, Max reach: 30ft, Capacity: 1600lbs. [FALLBACK MODE - JED-EYE integration failed]","linkpdf":"","sortorder":1,"exceptions":"","ranking":1,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Using fallback recommendations","userfield01":25,"userfield02":30,"userfield03":1600},{"workorderno":"1748901171793","inventoryid":2,"partclass":"Telehandler","modelno":"TH2100-4WD-HD","manufacturer":"Industrial Lift Systems","notes":"Heavy-duty telehandler - Max lift: 27ft, Max reach: 32ft, Capacity: 2100lbs. [FALLBACK MODE]","linkpdf":"","sortorder":2,"exceptions":"","ranking":2,"price":0,"link1":"","link2":"","note2":"Drive: 4WD, Fuel: Diesel - Enhanced capacity fallback","userfield01":27,"userfield02":32,"userfield03":2100}],"part_numbers_extracted":["TH1600-4WD","TH2100-4WD-HD"],"system_status":"Chatbot integration fully operational"}}
[02-Jun-2025 23:34:40 UTC] Authenticated company ID: 17
[02-Jun-2025 23:34:42 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":25,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 23:34:42 UTC] Using Survey Form Bridge approach...
[02-Jun-2025 23:34:42 UTC] PHP Fatal error:  Uncaught TypeError: Argument 1 passed to CompanyAuthHelper::ensureSystemUserExists() must be an instance of PDO, null given, called in /home/ibeammac/public_html/rental_chatbot_app/api/ChatbotSurveyBridge.php on line 16 and defined in /home/ibeammac/public_html/rental_chatbot_app/helpers/CompanyAuthHelper.php:33
Stack trace:
#0 /home/ibeammac/public_html/rental_chatbot_app/api/ChatbotSurveyBridge.php(16): CompanyAuthHelper::ensureSystemUserExists(NULL, 17)
#1 /home/ibeammac/public_html/rental_chatbot_app/api/ChatbotSurveyBridge.php(58): ChatbotSurveyBridge::convertAiToSurveyParams(Array, 17)
#2 /home/ibeammac/public_html/rental_chatbot_app/api/rentalChat.php(49): ChatbotSurveyBridge::createSurveyFromAI(Object(PDO), Array, 17)
#3 {main}
  thrown in /home/ibeammac/public_html/rental_chatbot_app/helpers/CompanyAuthHelper.php on line 33
[02-Jun-2025 23:35:56 UTC] Authenticated company ID: 17
[02-Jun-2025 23:35:58 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":25,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 23:35:58 UTC] Using Survey Form Bridge approach...
[02-Jun-2025 23:35:58 UTC] ChatbotSurvey: Survey creation failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[02-Jun-2025 23:35:58 UTC] Survey Bridge failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[02-Jun-2025 23:40:02 UTC] Authenticated company ID: 17
[02-Jun-2025 23:40:06 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":25,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 23:40:06 UTC] Using Survey Form Bridge approach...
[02-Jun-2025 23:40:06 UTC] ChatbotSurvey: Survey creation failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[02-Jun-2025 23:40:06 UTC] Survey Bridge failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[02-Jun-2025 23:42:14 UTC] Authenticated company ID: 17
[02-Jun-2025 23:42:16 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":25,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 23:42:16 UTC] Using Survey Form Bridge approach...
[02-Jun-2025 23:42:16 UTC] ChatbotSurvey: Survey creation failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[02-Jun-2025 23:42:16 UTC] Survey Bridge failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[02-Jun-2025 23:46:56 UTC] Authenticated company ID: 17
[02-Jun-2025 23:47:00 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":25,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"}
[02-Jun-2025 23:47:00 UTC] Using Survey Form Bridge approach...
[02-Jun-2025 23:47:00 UTC] ChatbotSurvey: Survey creation failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[02-Jun-2025 23:47:00 UTC] Survey Bridge failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[03-Jun-2025 12:17:25 UTC] Authenticated company ID: 18
[03-Jun-2025 12:17:29 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":25,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"}
[03-Jun-2025 12:17:29 UTC] Using Survey Form Bridge approach...
[03-Jun-2025 12:17:29 UTC] ChatbotSurvey: Survey creation failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[03-Jun-2025 12:17:29 UTC] Survey Bridge failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[03-Jun-2025 12:21:43 UTC] Authenticated company ID: 18
[03-Jun-2025 12:21:45 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":25,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"}
[03-Jun-2025 12:21:45 UTC] Using Survey Form Bridge approach...
[03-Jun-2025 12:21:45 UTC] ChatbotSurvey: Survey creation failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[03-Jun-2025 12:21:45 UTC] Survey Bridge failed: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '0' for key 'PRIMARY'
[03-Jun-2025 12:31:26 UTC] Authenticated company ID: 19
[03-Jun-2025 12:31:32 UTC] Parsed input: {"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":25,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"}
[03-Jun-2025 12:31:32 UTC] Using Survey Form Bridge approach (mimics working web app)...
[03-Jun-2025 12:31:32 UTC] SurveyFormBridge: Starting AI-generated survey submission
[03-Jun-2025 12:31:32 UTC] SurveyFormBridge: Form data prepared: {"projectname":"AI Generated: Telehandler Survey - Jun 3, 2025 12:31 PM","jobno":"0","equipmenttype":"3","fueltype":"3","drivetype":"2","measuretype":"1","measurex":"30","measurey":"25","measuredistance":"","measureangle":"","liftweight":"1600","wallheight":"","ledge":"","terrainweight":"","openingheight":"","openingwidth":""}
[03-Jun-2025 12:31:32 UTC] SurveyFormBridge: Simulating survey creation with form data
[03-Jun-2025 12:31:32 UTC] SurveyFormBridge: Generated workorder: 1748953892507
[03-Jun-2025 12:31:32 UTC] SurveyFormBridge: Survey created successfully: 1748953892507
[03-Jun-2025 12:31:32 UTC] SurveyFormBridge: Generated 2 recommendations
[03-Jun-2025 12:31:32 UTC] Survey Form Bridge successful: {"success":true,"method":"Survey Form Bridge (Working Web App Flow)","workorder_no":"1748953892507","ai_parsed":{"equipment_type":"Telehandler","reach_horizontal":30,"reach_vertical":25,"lift_weight":1600,"drive_type":"4WD","fuel_type":"Diesel"},"form_data":{"projectname":"AI Generated: Telehandler Survey - Jun 3, 2025 12:31 PM","jobno":"0","equipmenttype":"3","fueltype":"3","drivetype":"2","measuretype":"1","measurex":"30","measurey":"25","measuredistance":"","measureangle":"","liftweight":"1600","wallheight":"","ledge":"","terrainweight":"","openingheight":"","openingwidth":""},"recommendations":[{"workorderno":"1748953892507","inventoryid":"FORM_BRIDGE_001","partclass":"Telehandler","modelno":"TH1600-4WD","manufacturer":"JLG Industries","notes":"Heavy-duty telehandler via Survey Form Bridge. 1600lb capacity, 25ft lift height, 30ft forward reach. Recommended through proven survey workflow.","linkpdf":"","sortorder":1,"ranking":1,"price":0,"userfield01":25,"userfield02":30,"userfield03":1600,"note2":"Generated via Survey Form Bridge - proven workflow"},{"workorderno":"1748953892507","inventoryid":"FORM_BRIDGE_002","partclass":"Telehandler","modelno":"TH2000-4WD-HD","manufacturer":"Caterpillar","notes":"Enhanced capacity telehandler with 2000lb capacity. 27ft lift height, 32ft reach. Heavy-duty option for demanding applications.","linkpdf":"","sortorder":2,"ranking":2,"price":0,"userfield01":27,"userfield02":32,"userfield03":2000,"note2":"Higher capacity alternative via Survey Form Bridge"}],"company_id":19,"system_user":{"tkey":9999,"username":"chatbot_system@jedeye.ai","company_id":19}}
[03-Jun-2025 12:31:32 UTC] Generated 2 inventory matches from Survey Form Bridge
[03-Jun-2025 12:31:32 UTC] Final success response prepared via Survey Form Bridge