Check if Existing User FAIL
# ๐Ÿคhelp
g
Only picking up the top table row for Find Records. Reproduced in multiple bots (including official tutorial). Ticket: 1f2e0c39-b352-4457-87e2-730293a538ed
I was running into issues trying to implement a different feature (in another bot that checks for existing users and updates their info as needed etc.) and I kept getting tripped up testing any user records that weren't the top row of the table. ๐Ÿคจ So, I tested it using @bumpy-butcher-41910 's (Check if user input already exists) tutorial bot just to isolate the Find Records issue; AND it's not working as intended here either. No love for stew. ๐Ÿšซ๐Ÿฒ

https://youtu.be/XdkXkb9Az28โ–พ

b
hmmm
lemme take a look
so on a fresh bot I was able to recreate the tutorial listed here
even for emails beyond the first record
but I can see that it didn't work in the video you provided
g
So far I've had this same issue in 3 bots. 1) a bigger bot i'm working on 2) a fresh bot to isolate problem ๐ŸŒˆ fav color bot (quick-yak) 3) interesting lapwing (tuto demo)
b
yeah I opened this on a fresh bot to try and isolate the issue too
g
this is the fresh bot. i went for fav colors as use case
b
hmmm
on a test just now, kc@sunshine.co works for me
g
Doesn't seem like a browser issue for me, but For reference, I'm using Safari... You using Chrome?
b
g
yeah that's not working
b
ooh I see, it should've gone down the other end
(yeah we use Chrome, and we recommend using Chrome too)
g
Okay, we can rule out browser since it's reproducible in both. (and not really something that would be affected by browsers..)
Thanks for verifying that I am, in fact, sane. ๐Ÿง˜๐Ÿปโ€โ™€๏ธ
b
the visual bug - the one we're dealing with on another thread - might be a browser related issue
those tend to produce visual bugs
but this is just. odd
you are very sane haha
g
Note: The favorite colors bot is a bit fast & loose build. I was testing several methods and a couple other things (mission creep happens)... By the end of the day I was pretty burned out and don't know how solid it is overall. For this bug, the Tooth Booth (interesting-lapwing) bot is a the purest example of the problem. ๐ŸคŒ๐Ÿผ
This issue has gotten even weirder. I created 2 (nearly) identical bots that collect user's email, name and favorite color and store the results in a Table. Now one of the bots has stopped providing ANY correct records, and the other still only finds the top record in the table.
Here's my buggy twin bots that don't behave the same
I use ab@testing.co as the top Table row for testing consistency... in the cloned bot, it still Finds Records (but only the top one) and can update them successfully. The other bot doesn't find anything at all -- even though they are built the same way.
Well, I built yet another bot to test this problem... and it's finally working without bugs. All other bots in this channel are ๐Ÿฅด REKT at finding records & applying logic... even though they're all built the EXACT SAME WAY.
b
๐Ÿ™ƒ
g
Will do more testing by rebuilding my Favorite Colors bots (from scratch) AGAIN. Hope there's a bug fix somewhere that can apply to existing bots... b/c I really don't want to redo the HUGE mulit-flow bot I have where I originally stumbled across this bug.
UPDATE: After much testing and obsessing... I have rebuilt my favorite colors test bot ๐ŸŒˆ yet AGAIN... and now it's working PERFECTLY! I have NO idea why it's suddenly not home to a haunted house worth of bugs, but it is bug free. I make no exaggeration when I say it's the EXACT same bot, built the EXACT same way as the previous ones in this thread... but it works now! Devs, if you're feeling like dipping your toes into some digital madness, try and see if you can find what the h-e-๐Ÿ’๐Ÿ’ is going on. Compare the bug & non-bug versions. ๐Ÿคช
b
hey @gentle-engine-13076! thanks for the persistence
I'm really impressed haha
I know we've been working behind-the-scenes on Tables, my best guess is a newly created bot is working with the latest bug fixes etc
g
โ˜บ๏ธ haha yes... I couldn't let it go. ๐Ÿ˜… Thanks to the behind the scenes team working to make Tables even better. ๐Ÿฆพ๐Ÿค–
O M G. This bug is back! In two flavors. ๐Ÿจ The test bots' Find Records has stopped working with any new user info. Instead of only recognizing the top row in the table, the filter is ignoring all new rows. (To test add a new row and go through the flow attempting to follow Existing User path.) For new bots (like the BIG one I just remade b/c the old bug was still present in it...) Find Records is back to only recognizing the top row of the table. ๐Ÿชฒ
b
o.o
g
o.O
Super interesting nuance to this undead bug. If I enter a row manually in the table, the filter will pick it up using Find Records. BUT, if I enter a new row using the Insert Record card, Find Records returns NADA.
Yup. Same undead bug behavior in the Fav Colors bot too. Seems like some wires are crossed when inserting table records via bot. All works properly when new records are manually entered into the table.
Spooky SZN continues ๐Ÿ™€
Yup. Also verified same undead bot behavior in my BIG bot (not shared in thread).
NOTE: The Insert Record card is correctly adding rows to the Table โœ… BUT rows added in this way are not being picked up by the Find Records filter ๐Ÿšซ
b
๐Ÿ”ฅ๐Ÿ™ƒ
g
New ticket created that includes the research gleaned from my experiments. Ticket number: 8f66a259-1568-49ac-b72f-9d23016d2c6d I don't know if it's the same issue as the original ticket or if I'm just gaining a better understanding of what makes this bug tick. ๐Ÿชฒโ˜บ๏ธ Stumbled across a pun for you Robert. ๐Ÿค“
Botpress entomologist reporting for duty. ๐Ÿคญ
For this test bot I added a column to denote the method by which the rows were added to the table. Recap: A manually entered row works great. A bot entered row fails to return the record.
After a month, I'm still seeing this Find Records bug ๐Ÿ› where a manually entered table row works great, but a bot entered table row fails to return the record.
Logs for Success: ``Executing AI query { filter: { type: 'AIQuery', template: 'Name is {params[0]}', params: [ 'Jean' ], types: [ 'string' ] } } {"scope":"table","tableName":"NamesAndGenresTable"} AI Query generated successfully { query: { c_1: 'Jean' }, generator: 'function (util, ...params) { return { // "Name is {params[0]}" \'c_1\': params[0] }; }' } {"scope":"table","tableName":"NamesAndGenresTable"} Execute operation findRecords({"filter":{"type":"AIQuery","template":"Name is {params[0]}","params":["Jean"],"types":["string"]}}) { id: 3, createdAt: '2023-12-08T22:52:21.561Z', updatedAt: '2023-12-08T22:52:21.561Z', Name: 'Jean', Music: 'Trance', Manual: true } {"scope":"table","tableName":"NamesAndGenresTable"}`` Logs for Fail: ``Executing AI query { filter: { type: 'AIQuery', template: 'Name is {params[0]}', params: [ 'Sara' ], types: [ 'string' ] } } {"scope":"table","tableName":"NamesAndGenresTable"} AI Query generated successfully { query: { c_1: 'Sara' }, generator: 'function (util, ...params) { return { // "Name is {params[0]}" \'c_1\': params[0] }; }' } {"scope":"table","tableName":"NamesAndGenresTable"} Execute operation findRecords({"filter":{"type":"AIQuery","template":"Name is {params[0]}","params":["Sara"],"types":["string"]}}) {"scope":"table","tableName":"NamesAndGenresTable"}``
b
._. thank you for your diligence @gentle-engine-13076
g
6 months ago: BP Tables didn't exist Today:
h
Hi, I guess the bug's still there since I'm having problem with Find Records ๐Ÿ˜ฟ
g
If you are using the Insert Record card to populate your Table, the Find Records card will not work properly. I tried debugging the Find Records card for a long time (using Execute Code to find records instead). But I could only find manually entered Table rows using either Find Records or Execute Code methods... ๐Ÿคจ I finally had a breakthrough when I started testing the Insert Records card! That's where I found the bug hiding. ๐Ÿชฒ๐Ÿ”๐Ÿ‘€ I've revised my Bug Hunt bot to demonstrate the issues with the Insert Record card. (For simplicity I only used Find Records in this example since Execute Code was working to find records too.) When I use an Execute Code card to add a record to the Table (instead of Insert Record), everything works perfectly with a Find Records card (or Execute Code card to find records). That's how I figured it that the problem is not Find Records, but the problem I kept seeing was with the Insert Record card. ๐Ÿซจ
@bumpy-butcher-41910 ๐Ÿ‘†๐Ÿผ
Should I submit a new ticket..?
2 Views