2022-04-14 16:14:05 - DEBUG --> Posts Date: 2022-04-14 2022-04-14 16:14:05 - DEBUG --> [pc00] - Inserted [31] Records with [1] errors and [65] invalid phone numbers 2022-04-14 16:18:26 - DEBUG --> Posts Date: 2022-04-14 2022-04-14 16:18:26 - DEBUG --> [pc00] - Inserted [31] Records with [1] errors and [65] invalid phone numbers 2022-04-14 16:21:40 - DEBUG --> Posts Date: 2022-04-14 2022-04-14 16:21:40 - DEBUG --> [pc00] - Inserted [31] Records with [1] errors and [65] invalid phone numbers 2022-04-14 16:25:36 - DEBUG --> Posts Date: 2022-04-14 2022-04-14 16:25:36 - DEBUG --> Data Count: 23 2022-04-14 16:25:36 - DEBUG --> Insert for 2148021662 2022-04-14 16:25:36 - DEBUG --> Insert for 3258294733 2022-04-14 16:25:36 - DEBUG --> Insert for 4692581089 2022-04-14 16:25:36 - DEBUG --> Insert for 5125632431 2022-04-14 16:25:36 - DEBUG --> Insert for 6103343486 2022-04-14 16:25:36 - DEBUG --> Insert for 6822341342 2022-04-14 16:25:36 - DEBUG --> Insert for 6825592948 2022-04-14 16:25:36 - DEBUG --> Insert for 6825835023 2022-04-14 16:25:36 - DEBUG --> Insert for 8064456922 2022-04-14 16:25:36 - DEBUG --> Insert for 8153269356 2022-04-14 16:25:36 - DEBUG --> Insert for 8172530547 2022-04-14 16:25:36 - DEBUG --> Insert for 8174012198 2022-04-14 16:25:36 - DEBUG --> Insert for 8175046647 2022-04-14 16:25:36 - DEBUG --> Insert for 8177147092 2022-04-14 16:25:36 - DEBUG --> Insert for 8177268132 2022-04-14 16:25:36 - DEBUG --> Insert for 8177273430 2022-04-14 16:25:36 - DEBUG --> Insert for 8177705798 2022-04-14 16:25:36 - DEBUG --> Insert for 8179050395 2022-04-14 16:25:36 - DEBUG --> Insert for 8454762405 2022-04-14 16:25:36 - DEBUG --> Insert for 9402555348 2022-04-14 16:25:36 - DEBUG --> Insert for 9403902010 2022-04-14 16:25:36 - DEBUG --> Insert for 9568677122 2022-04-14 16:25:36 - DEBUG --> Insert for 9724650438 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'e2cfe5506996d0073c3f8d9a5e53d610' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '6cd53b8955c92c5a1799b847ebf050d5' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '670973a755a7d7abc65a1df6f0cf8914' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '961203dd91d463c06a4bbeb5d50df15c' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'b0e3575de65e0eb452df3b1add71ee8c' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'd2450ccf18fda9cfe070779077666bb1' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'f8dff71e42b248e0562c6722cca85825' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'afc9d02348932a02d37f14f879bfff41' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'b472277e6d502160f9c9b311cb2260a7' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '980c31fb4a549ae0767699ed9178ad31' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '8d124247cdab8ae275264007c096ef23' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '178e720d8c9c95da394b2791533454e8' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'aff690e9e7b232a269263bfa9e1c82cb' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'ab266927492232e723cbd3f5141a7198' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '30c7e908df7949e8cabef2a69eb8707a' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '12357d38fea82438394e257ddc6f1cce' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '13d0cec34da86465462108bf2dcf3d42' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'f9052295a8b2c5430ba28d2e90a10f7a' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'c89f79c092d82e2f96abf54e546d8a0e' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '8fde1fe9e4b559f73a825080f6a813da' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '76e8d00dbc5035e030a38ea66e0a04ce' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'd1321a18535e3f4da3e128e2076a4910' for key 'slug' 2022-04-14 16:25:36 - ERROR --> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '3ae79f36d9c2a5ce978aa847af991a61' for key 'slug' 2022-04-14 16:25:36 - DEBUG --> [pc00] - Inserted [0] Records with [32] errors and [65] invalid phone numbers 2022-05-09 16:09:29 - ERROR --> Bad Data From Function 2022-05-09 16:10:59 - ERROR --> Bad Data From Function 2022-05-09 16:11:20 - ERROR --> Bad Data From Function 2022-05-09 16:14:01 - DEBUG --> Can't Execute The Points Report Query 2022-05-09 16:14:01 - ERROR --> Bad Data From Function 2022-05-09 16:14:28 - DEBUG --> Can't Execute The Points Report Query 2022-05-09 16:14:28 - ERROR --> Bad Data From Function 2022-05-09 16:14:58 - DEBUG --> PDO Exception Found 2022-05-09 16:14:58 - ERROR --> SQLSTATE[42S02]: Base table or view not found: 1146 Table 'kiosk_buykiosk.fivestarspoints' doesn't exist 2022-05-09 16:14:58 - ERROR --> Bad Data From Function 2022-05-09 16:16:20 - DEBUG --> PDO Exception Found 2022-05-09 16:16:20 - ERROR --> SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.fiveStarsPoints.id, date, ...' at line 2 2022-05-09 16:16:20 - ERROR --> Bad Data From Function 2022-05-09 16:17:35 - DEBUG --> PDO Exception Found 2022-05-09 16:17:35 - ERROR --> SQLSTATE[HY093]: Invalid parameter number: parameter was not defined 2022-05-09 16:17:35 - ERROR --> Bad Data From Function 2022-05-09 16:19:59 - ERROR --> Bad Data From Function 2022-05-09 16:20:20 - ERROR --> Bad Data From Function 2022-05-09 20:17:50 - ERROR --> Bad Request 2022-05-09 20:18:20 - ERROR --> Bad Request 2022-05-09 20:39:30 - ERROR --> Bad Request 2022-06-07 16:57:16 - DEBUG --> 2022-06-07 16:58:02 - DEBUG --> 2022-06-07 16:59:13 - DEBUG --> NULL 2022-06-07 17:06:03 - DEBUG --> /businesses/BuyerKiosk1/rewards/ 2022-06-07 17:06:06 - DEBUG --> NULL 2022-06-07 17:07:01 - DEBUG --> array(2) { ["items"]=> array(4) { [0]=> array(4) { ["meta"]=> array(2) { ["embed"]=> array(0) { } ["links"]=> array(1) { ["business_group"]=> array(2) { ["href"]=> string(61) "/api/unified/business-groups/a58e8c7d552646219c95daf27c64c54a" ["type"]=> string(8) "document" } } } ["perk"]=> string(12) "Free T-Shirt" ["point_cost"]=> int(10) ["uid"]=> string(32) "e1fa0ffda4aa4f3b9ee3b1dd31016770" } [1]=> array(4) { ["meta"]=> array(2) { ["embed"]=> array(0) { } ["links"]=> array(1) { ["business_group"]=> array(2) { ["href"]=> string(61) "/api/unified/business-groups/a58e8c7d552646219c95daf27c64c54a" ["type"]=> string(8) "document" } } } ["perk"]=> string(30) "10% Off Any Order (Up to $100)" ["point_cost"]=> int(20) ["uid"]=> string(32) "9895d3ff980f4178a5302ffee0fa8d7a" } [2]=> array(4) { ["meta"]=> array(2) { ["embed"]=> array(0) { } ["links"]=> array(1) { ["business_group"]=> array(2) { ["href"]=> string(61) "/api/unified/business-groups/a58e8c7d552646219c95daf27c64c54a" ["type"]=> string(8) "document" } } } ["perk"]=> string(26) "Buy One Get One Sunglasses" ["point_cost"]=> int(30) ["uid"]=> string(32) "aa4f41d1ab2b49069456c2364c6fc4d7" } [3]=> array(4) { ["meta"]=> array(2) { ["embed"]=> array(0) { } ["links"]=> array(1) { ["business_group"]=> array(2) { ["href"]=> string(61) "/api/unified/business-groups/a58e8c7d552646219c95daf27c64c54a" ["type"]=> string(8) "document" } } } ["perk"]=> string(20) "$20 Off Any Purchase" ["point_cost"]=> int(50) ["uid"]=> string(32) "2c448977ab9e44b78c2bd2e142c87edb" } } ["meta"]=> array(4) { ["limit"]=> int(20) ["next"]=> string(48) "/api/unified/shipped-hardware?limit=20&offset=20" ["offset"]=> int(0) ["previous"]=> NULL } } 2022-06-07 17:08:42 - DEBUG --> array(2) { ["items"]=> array(4) { [0]=> array(4) { ["meta"]=> array(2) { ["embed"]=> array(0) { } ["links"]=> array(1) { ["business_group"]=> array(2) { ["href"]=> string(61) "/api/unified/business-groups/a58e8c7d552646219c95daf27c64c54a" ["type"]=> string(8) "document" } } } ["perk"]=> string(12) "Free T-Shirt" ["point_cost"]=> int(10) ["uid"]=> string(32) "e1fa0ffda4aa4f3b9ee3b1dd31016770" } [1]=> array(4) { ["meta"]=> array(2) { ["embed"]=> array(0) { } ["links"]=> array(1) { ["business_group"]=> array(2) { ["href"]=> string(61) "/api/unified/business-groups/a58e8c7d552646219c95daf27c64c54a" ["type"]=> string(8) "document" } } } ["perk"]=> string(30) "10% Off Any Order (Up to $100)" ["point_cost"]=> int(20) ["uid"]=> string(32) "9895d3ff980f4178a5302ffee0fa8d7a" } [2]=> array(4) { ["meta"]=> array(2) { ["embed"]=> array(0) { } ["links"]=> array(1) { ["business_group"]=> array(2) { ["href"]=> string(61) "/api/unified/business-groups/a58e8c7d552646219c95daf27c64c54a" ["type"]=> string(8) "document" } } } ["perk"]=> string(26) "Buy One Get One Sunglasses" ["point_cost"]=> int(30) ["uid"]=> string(32) "aa4f41d1ab2b49069456c2364c6fc4d7" } [3]=> array(4) { ["meta"]=> array(2) { ["embed"]=> array(0) { } ["links"]=> array(1) { ["business_group"]=> array(2) { ["href"]=> string(61) "/api/unified/business-groups/a58e8c7d552646219c95daf27c64c54a" ["type"]=> string(8) "document" } } } ["perk"]=> string(20) "$20 Off Any Purchase" ["point_cost"]=> int(50) ["uid"]=> string(32) "2c448977ab9e44b78c2bd2e142c87edb" } } ["meta"]=> array(4) { ["limit"]=> int(20) ["next"]=> string(48) "/api/unified/shipped-hardware?limit=20&offset=20" ["offset"]=> int(0) ["previous"]=> NULL } } 2022-06-07 19:06:28 - DEBUG --> Posts Date: 2022-06-07 2022-06-07 19:06:28 - DEBUG --> Data Count: 19 2022-06-07 19:06:28 - DEBUG --> Insert for 2148021662 2022-06-07 19:06:28 - DEBUG --> Insert for 3258294733 2022-06-07 19:06:28 - DEBUG --> Insert for 4692581089 2022-06-07 19:06:28 - DEBUG --> Insert for 6103343486 2022-06-07 19:06:28 - DEBUG --> Insert for 6822341342 2022-06-07 19:06:28 - DEBUG --> Insert for 6825592948 2022-06-07 19:06:28 - DEBUG --> Insert for 6825835023 2022-06-07 19:06:28 - DEBUG --> Insert for 8064456922 2022-06-07 19:06:28 - DEBUG --> Insert for 8153269356 2022-06-07 19:06:28 - DEBUG --> Insert for 8172530547 2022-06-07 19:06:28 - DEBUG --> Insert for 8174012198 2022-06-07 19:06:28 - DEBUG --> Insert for 8175046647 2022-06-07 19:06:28 - DEBUG --> Insert for 8177147092 2022-06-07 19:06:28 - DEBUG --> Insert for 8177268132 2022-06-07 19:06:28 - DEBUG --> Insert for 8177273430 2022-06-07 19:06:28 - DEBUG --> Insert for 8179050395 2022-06-07 19:06:28 - DEBUG --> Insert for 8454762405 2022-06-07 19:06:28 - DEBUG --> Insert for 9402555348 2022-06-07 19:06:28 - DEBUG --> Insert for 9724650438 2022-06-07 19:06:28 - DEBUG --> [pc00] - Inserted [31] Records with [1] errors and [65] invalid phone numbers 2022-06-08 10:36:35 - DEBUG --> UID: e1fa0ffda4aa4f3b9ee3b1dd31016770 2022-06-08 10:37:22 - DEBUG --> UID: 9895d3ff980f4178a5302ffee0fa8d7a 2022-06-08 10:37:37 - DEBUG --> UID: 9895d3ff980f4178a5302ffee0fa8d7a 2022-06-08 10:39:48 - DEBUG --> UID: 9895d3ff980f4178a5302ffee0fa8d7a 2022-06-08 10:40:06 - DEBUG --> UID: 9895d3ff980f4178a5302ffee0fa8d7a 2022-06-08 10:40:26 - DEBUG --> UID: 9895d3ff980f4178a5302ffee0fa8d7a 2022-06-08 10:41:00 - DEBUG --> UID: 9895d3ff980f4178a5302ffee0fa8d7a 2022-06-08 10:41:00 - DEBUG --> {"phone":6825589968,"points":[{"amount":0}],"rewards":[{"uid":"9895d3ff980f4178a5302ffee0fa8d7a"}],"checkin":"partner"} 2022-06-08 10:42:01 - DEBUG --> UID: 9895d3ff980f4178a5302ffee0fa8d7a 2022-06-08 10:42:01 - DEBUG --> {"phone":"6825589968","points":[{"amount":0}],"rewards":[{"uid":"9895d3ff980f4178a5302ffee0fa8d7a"}],"checkin":"partner"} 2022-06-08 10:43:00 - DEBUG --> UID: 9895d3ff980f4178a5302ffee0fa8d7a 2022-06-08 10:43:00 - DEBUG --> {"phone":"6825589968","points":[{"amount":0}],"rewards":[{"uid":"9895d3ff980f4178a5302ffee0fa8d7a"}]} 2022-06-08 10:44:50 - DEBUG --> UID: 9895d3ff980f4178a5302ffee0fa8d7a 2022-06-08 10:44:50 - DEBUG --> {"phone":"6825589968","points":[{"amount":0}],"rewards":[{"uid":"9895d3ff980f4178a5302ffee0fa8d7a"}]} 2022-06-08 10:45:58 - DEBUG --> UID: 9895d3ff980f4178a5302ffee0fa8d7a 2022-06-08 10:45:58 - DEBUG --> {"phone":"6825589968","points":[{"amount":0}],"rewards":[{"uid":"9895d3ff980f4178a5302ffee0fa8d7a"}]} 2022-06-22 12:36:44 - DEBUG --> UID: 9895d3ff980f4178a5302ffee0fa8d7a 2022-06-22 12:36:44 - DEBUG --> {"phone":"6825589968","points":[{"amount":0}],"rewards":[{"uid":"9895d3ff980f4178a5302ffee0fa8d7a"}]} 2022-07-05 10:08:47 - DEBUG --> UID: e1fa0ffda4aa4f3b9ee3b1dd31016770 2022-07-05 10:08:47 - DEBUG --> UID: 2c448977ab9e44b78c2bd2e142c87edb 2022-07-05 10:08:47 - DEBUG --> {"phone":"2144919067","points":[{"amount":0}],"rewards":[{"uid":"e1fa0ffda4aa4f3b9ee3b1dd31016770"},{"uid":"2c448977ab9e44b78c2bd2e142c87edb"}]} 2026-02-13 15:56:56 - ERROR --> FiveStars customer lookup error: Missing required environment variables: FS_API_URL_DEV, FS_API_KEY_DEV, FS_API_SECRET_DEV 2026-02-13 15:56:59 - ERROR --> FiveStars customer lookup error: Missing required environment variables: FS_API_URL_DEV, FS_API_KEY_DEV, FS_API_SECRET_DEV