X
Xata•2mo ago
atharvgosling

I am trying to update the user record in my database in the callback function of oauth2. FetchError

The code works fine without the Xata logic, i.e only for authentication, but gives Fetch Error in the catch block when i try to update the record. I have checked my schema against this and its correct. 
exports.callback=async (req,res)=>{
    const code=req.query.code;
    
    try{
        const response=await axios.post(process.env.TOKEN_ENDPOINT,{
            code,
            client_id:process.env.CLIENT_ID,
            client_secret:process.env.CLIENT_SECRET,
            redirect_uri:process.env.REDIRECT_URI,
            grant_type:'authorization_code',
        });

        const {id_token, access_token}=response.data;
        
        const userInfo=await axios.get('https://www.googleapis.com/oauth2/v3/userinfo',{
            headers: { Authorization: `Bearer ${access_token}` }
        });

         // Checking if user exists in Xata database 
        let user = await xata.db.users.filter({ email: userInfo.data.email }).getFirst();
        console.log(user);
        // If user doesn't exist, creating a new user in Xata
        if (!user) {

        user = await xata.db.users.create({
            user_id: Date.now(),
            username: userInfo.data.name,
            password_hash: null,
            email: userInfo.data.email, 
        });
        console.log("now "+user);
        }

        // Generating JWT with Xata user ID and other user info
        const userToken = generateToken({ id: user.xata_id, ...userInfo.data }); 

        res.cookie('token',userToken,{httpOnly:true});

        res.redirect(process.env.FRONTEND_URL);
    }
    catch(err){
        console.error('Error in OAuth callback:', err);
        res.status(500).send("Error during OAuth callback")
    }
};
exports.callback=async (req,res)=>{
    const code=req.query.code;
    
    try{
        const response=await axios.post(process.env.TOKEN_ENDPOINT,{
            code,
            client_id:process.env.CLIENT_ID,
            client_secret:process.env.CLIENT_SECRET,
            redirect_uri:process.env.REDIRECT_URI,
            grant_type:'authorization_code',
        });

        const {id_token, access_token}=response.data;
        
        const userInfo=await axios.get('https://www.googleapis.com/oauth2/v3/userinfo',{
            headers: { Authorization: `Bearer ${access_token}` }
        });

         // Checking if user exists in Xata database 
        let user = await xata.db.users.filter({ email: userInfo.data.email }).getFirst();
        console.log(user);
        // If user doesn't exist, creating a new user in Xata
        if (!user) {

        user = await xata.db.users.create({
            user_id: Date.now(),
            username: userInfo.data.name,
            password_hash: null,
            email: userInfo.data.email, 
        });
        console.log("now "+user);
        }

        // Generating JWT with Xata user ID and other user info
        const userToken = generateToken({ id: user.xata_id, ...userInfo.data }); 

        res.cookie('token',userToken,{httpOnly:true});

        res.redirect(process.env.FRONTEND_URL);
    }
    catch(err){
        console.error('Error in OAuth callback:', err);
        res.status(500).send("Error during OAuth callback")
    }
};
error- 
Error in OAuth callback: FetcherError: Internal Error (Request ID: d38e69c1-681f-9f4a-9b1c-58923c0aa05a)
    at file:///C:/Users/athar/Documents/GitHub/mango-store/backend/node_modules/@xata.io/client/dist/index.mjs:2414:15 
Error in OAuth callback: FetcherError: Internal Error (Request ID: d38e69c1-681f-9f4a-9b1c-58923c0aa05a)
    at file:///C:/Users/athar/Documents/GitHub/mango-store/backend/node_modules/@xata.io/client/dist/index.mjs:2414:15
1 Reply
cmck
cmck•2mo ago
Hi! I'll take a look at the request ID and see what the issue might be. So I can see an error in our backend related to data types. Could you please enable support access to your workspace so I can take a look at the schema? https://support.xata.io/hc/en-us/articles/16775415603997-Allowing-Support-to-access-your-Workspace If you have already switched this on please turn it off and on again to resend the invite. Ah, I see you reached out to [email protected] with more information, I'll answer there.

Did you find this page helpful?