Great content. Some tips. I'd add a shortcut key to toggle VS Code's Activity Sidebar (all the icons on the left). Disabling that gives a little bit more space to adjust text size. I have that set to ALT + A. I also have the Project Explorer window toggle key set to SHIFT + SPACE, which is easy to smash in order to have even more code space. The rafce extension also has a control in its VS Code Extension Settings that allows you to omit the React import line, which is not really needed when you're rocking Next.js. Head to the Extensions Seettings for ES7 snippets and the first entry called 'React Snippets › Settings: Import React On Top" can be ticked on or off to omit this line when using snippets like rafce.
have you found a solution? I'm having the same issue. I've tried to rig up a query but I don't know how complex it would need to be. I thought select * from chatbots where clerk_user_id = $1 would work event with a function CREATE OR REPLACE FUNCTION getChatbotByUsers($clerk_user_id: String!) returns text[] $$ select * from chatbots where clerk_user_id = $1 $$ language SQL; but keep getting errors
tnx in advance I have only one IBM api and I'm sure I putted environment setup correctly but I still cant pass create-chatbot and my DATA >> is always undefined
Had the same issue, the problem was the created_at column which is required as a DateTime type. So you need to add the created_at alongside the id and the name column when carrying out your create-chatbot mutation
Loving these full stack builds that are new and very useful. Learning a lot and definitely recommending this PAPA fam channel to friends and family. University of Code such a great place!
I popped in the seed contents in the SQL environment on the Neon but the run button is still disabled and I cant click to run it, help me out here thanks
Any one having trouble with adding Characteristic to the chatbot? It keeps failing when I add and I have followed all the steps and the code is exact the same.
I am able to delete characteristics but not able to add, but I changed the variables on the removeCharacteristic to this in the try await removeCharacteristic({ variables: { characteristicId, }, and it worked
Nice good job. I’m working through a bug right now. Getting the following on the edit-chatbot page: “Error: Server response was missing for query ‘GetChatbotById’”
Let's add an option for pdf or csv as input feed bro 😮❤
Great suggestion!
that is the whole point of learning, make it an exercise to base it on your business needs 🎉
You are powerful Sonny
Hi Sonny.
Thanks so much for this.
How many months is the zero to Fullstack and at the end will I be able to Enterprise based software?
Super happy to see DaisyUI beginning to get the recognition it deserves. First used it in 2022.
Great tutorial. Please add an option to train a website url and/or PDF.
Thanks a lot!!
I also was thinking this!
Can you post the link to the entire project in here to be able to download it please
Is it uses any Paid API For this Project???
Is repo for this the same as challenge repo?
Got my first job with Microsoft via your guides Sonny! You are a hero!
That’s huge!!! Email me at sonny@papareact.com
I wanna chat about this!!
are there any other services like neon that can provide a free tier DB ? Something like MongoDB Atlas except with SQL databases.......
GREAT VIDEO THANKS SONNY
You’re absolutely welcome!!!
Great content. Some tips. I'd add a shortcut key to toggle VS Code's Activity Sidebar (all the icons on the left). Disabling that gives a little bit more space to adjust text size. I have that set to ALT + A. I also have the Project Explorer window toggle key set to SHIFT + SPACE, which is easy to smash in order to have even more code space.
The rafce extension also has a control in its VS Code Extension Settings that allows you to omit the React import line, which is not really needed when you're rocking Next.js. Head to the Extensions Seettings for ES7 snippets and the first entry called 'React Snippets › Settings: Import React On Top" can be ticked on or off to omit this line when using snippets like rafce.
This is so cool, I'm learning loads! Thank you for all this great free content
hey sonny there's no getchatbotsByUser query in my ibm api connect
have you found a solution? I'm having the same issue. I've tried to rig up a query but I don't know how complex it would need to be.
I thought select * from chatbots where clerk_user_id = $1 would work event with a function
CREATE OR REPLACE FUNCTION getChatbotByUsers($clerk_user_id: String!) returns text[] $$
select * from chatbots where clerk_user_id = $1
$$
language SQL; but keep getting errors
Hi guys, sorry about that!
Add this to the index.graphql file:
---
chatbotsByUser(clerk_user_id: String!): [Chatbots]
@dbquery(
type: "postgresql"
schema: "public"
query: """
SELECT * FROM chatbots WHERE clerk_user_id = $1
"""
configuration: "postgresql_config"
)
---
and then in queries.ts, add this:
---
export const GET_CHATBOTS_BY_USER = gql`
query GetChatbotsByUser($clerk_user_id: String!) {
chatbotsByUser(clerk_user_id: $clerk_user_id) {
id
name
created_at
chatbot_characteristics {
id
content
created_at
}
chat_sessions {
id
created_at
guest_id
messages {
id
content
created_at
}
}
}
}
`;
---
Hope that helps!
This is a great tool to have just on a personal level, Will be rolling this out to all my sites over time.
Amazing 🔥🔥
Is there a reason you use rfce as opposed to rafce or is it just personal preference?
tnx in advance
I have only one IBM api and I'm sure I putted environment setup correctly but I still cant pass create-chatbot and my DATA >> is always undefined
Any fix for this issue? I am also having this problem. I can connect to graphql via postman with no problems. Issue seems to be nextjs related.
Had the same issue, the problem was the created_at column which is required as a DateTime type. So you need to add the created_at alongside the id and the name column when carrying out your create-chatbot mutation
@@CharlesUkasoanyawas getting the error too! Going to try this. Thanks. Which file are you referring to specifically?
@@CharlesUkasoanya also use the type - DateTime!
@@pvm239 insertChatbots(clerk_user_id: $clerk_user_id, name: $name, created_at: $created_at) {
id
name
created_at
}
You missed created_at at the time of creating a bot
Loving these full stack builds that are new and very useful. Learning a lot and definitely recommending this PAPA fam channel to friends and family. University of Code such a great place!
Awesome thanks so much for the support im glad you like them!
Flight Radar clone??
I popped in the seed contents in the SQL environment on the Neon but the run button is still disabled and I cant click to run it, help me out here thanks
Remove all the comments from the seed file and paste it into the SQL editor again. The run button will show. This works for me.
You are just next level man.
Love it man ❤
This is what I was looking for
Awesome Sonny! A suggestion would be nice to have a video for short video generation using AI! :)
Thank you il consider it!
@@SonnySangha thanks using ffmpeg and AI could be cool!
Can we embed the created chatbot on an already built website? Great content as always!
Yes you can 100% embed the chat on an existing website!
Can you please tell how to do embed it?@@SonnySangha
Love from INDIA 😇
Any one having trouble with adding Characteristic to the chatbot? It keeps failing when I add and I have followed all the steps and the code is exact the same.
What is the error that you are getting?
@@pvm239 Not getting an errors just not adding the characteristics? I get a successful post of 200 to graphql
I am able to delete characteristics but not able to add, but I changed the variables on the removeCharacteristic to this in the try
await removeCharacteristic({
variables: {
characteristicId,
},
and it worked
Nice good job. I’m working through a bug right now. Getting the following on the edit-chatbot page:
“Error: Server response was missing for query ‘GetChatbotById’”
@@pvm239 the same thing happened to me and i fixed it with create_at in the mutation. when you create the chat bot
am mind blown cool content ..my goodness
this content is pure gold