Requete INSERT ne fonctionne pas

if($rows == 0) {
                                    $date = date('Y-m-d');
                                    $tquery = "INSERT INTO users(id, pseudo, pass, mail, rang, avatar, join) VALUES('', :pseudo, :pass, :mail, :rang, :avatar, :join)";
                                    $query2 = $sql->prepare($tquery)    ;
                                    $array = array(
                                        ":pseudo" => $pseudo,
                                        ":pass" => $pass,
                                        ":mail" => $mail,
                                        ":rang" => "Membre",
                                        ":avatar" => "[https://cdn3.iconfinder.com/data/icons/softwaredemo/PNG/256x256/User1.png]",
                                        ":join" => $date
                                    );
                                    $query2->execute($array);
                                    echo "<pre>";
                                    print_r($array);
                                    echo "</pre>";
                                    $rows2 = $query2->rowCount();
                                    echo "$rows2 ligne insérée.";
                                    echo "<br />Enregistrement réussi ! Vous pouvez vous connecter <b><a href='login.php'>en cliquant ici.</a></b>";
                                }