При регистрации не возвращается json Node.js

db.query('SELECT * FROM users WHERE email = $1::text', [email] , (err, row) =>{

                if(err){
                    console.log('Error executing query', err.stack);
                }
                //console.log(row);
               let isTrue=false;
                if(row.rowCount){
                    for(let i=0; i < row.rows.length; i++){
                        if(row.rows[i].email === email){
                            isTrue = true;
                            break;              
                    }
                }
            }
            if(isTrue){
                res.json(row.rows[0].email)
            }else{
                //res.json({"message": "Регистрирую пользователя"})
                 if(pass==pass2){
                    //const hashPass = bcrypt.hashSync(pass, 15)
                    //const hashPass2 = bcrypt.hashSync(pass2, 15)
        
                    const newPerson = db.query('INSERT INTO users(name, surname, email, pass, pass2) values ($1, $2, $3, $4, $5) RETURNING *', [name, surname, email, pass, pass2])
                    res.json(newPerson.rows)
                }else{
                    res.json({"message" : "пароли не совпадают"})
                }
            }
                
              });

              
            
               
            

        } catch(e){
            console.log(e)
            res.send({message: "Server error"})

        }
        

    }

Возвращает 0 или пустой объект. При res.json(newPerson.rows[0]) происходит ошибка сервера

C:\Users\User\Desktop\Fullstack\server\node_modules\pg\lib\query.js:143 throw err ^

TypeError: Cannot read properties of undefined (reading '0') at C:\Users\User\Desktop\Fullstack\server\controller\user.controller.js:35:44 at Query. (C:\Users\User\Desktop\Fullstack\server\node_modules\pg-pool\index.js:421:18) at Query.handleReadyForQuery (C:\Users\User\Desktop\Fullstack\server\node_modules\pg\lib\query.js:139:14) at Client._handleReadyForQuery (C:\Users\User\Desktop\Fullstack\server\node_modules\pg\lib\client.js:290:19) at Connection.emit (node:events:527:28) at C:\Users\User\Desktop\Fullstack\server\node_modules\pg\lib\connection.js:114:12 at Parser.parse (C:\Users\User\Desktop\Fullstack\server\node_modules\pg-protocol\dist\parser.js:40:17) at Socket. (C:\Users\User\Desktop\Fullstack\server\node_modules\pg-protocol\dist\index.js:11:42) at Socket.emit (node:events:527:28) at addChunk (node:internal/streams/readable:315:12)


Ответы (0 шт):