Last 53 Keys: p y t h o n Space - u Space " c : \ U s e r s \ h s \ D e s k t o p \ F a c e R e c o g \ s t u d e n t . p y " Enter

[VineetTRI]

Prerequisites

• Write a descriptive title.
• Make sure you are able to repro it on the latest released version
• Search the existing issues, especially the pinned issues.

Exception report

System.ArgumentOutOfRangeException: The value must be greater than or equal to zero and less than the console's buffer size in that dimension.
Parameter name: left
Actual value was -2.
   at System.Console.SetCursorPosition(Int32 left, Int32 top)
   at Microsoft.PowerShell.Internal.VirtualTerminal.set_CursorLeft(Int32 value)
   at Microsoft.PowerShell.PSConsoleReadLine.ReallyRender(RenderData renderData, String defaultColor)
   at Microsoft.PowerShell.PSConsoleReadLine.Insert(Char c)
   at Microsoft.PowerShell.PSConsoleReadLine.SelfInsert(Nullable`1 key, Object arg)
   at Microsoft.PowerShell.PSConsoleReadLine.ProcessOneKey(ConsoleKeyInfo key, Dictionary`2 dispatchTable, Boolean ignoreIfNoAction, Object arg)
   at Microsoft.PowerShell.PSConsoleReadLine.InputLoop()
   at Microsoft.PowerShell.PSConsoleReadLine.ReadLine(Runspace runspace, EngineIntrinsics engineIntrinsics)

Screenshot

N/A

Environment data

PS Version: 5.1.19041.5737     
PS HostName: ConsoleHost       
PSReadLine Version: 2.0.0-beta2
PSReadLine EditMode: Windows
OS: 10.0.19041.1 (WinBuild.160101.0800)
BufferWidth: 173
BufferHeight: 43

Steps to reproduce

from tkinter import *
from tkinter import ttk
from PIL import Image,ImageTk
from tkinter import messagebox
import mysql.connector

class Student:
def init(self,root):
self.root = root
self.root.geometry("1530x790+0+0")
self.root.title("Face Recognition System")

    # ====================== Variables ======================
    self.var_dep = StringVar()
    self.var_course = StringVar()
    self.var_year = StringVar()
    self.var_semester = StringVar()
    self.var_std_id = StringVar()
    self.var_std_name = StringVar()
    self.var_div = StringVar()
    self.var_roll = StringVar()
    self.var_gender = StringVar()
    self.var_dob = StringVar()
    self.var_email = StringVar()
    self.var_phone = StringVar()
    self.var_address = StringVar()
    self.var_teacher = StringVar()

    #First image
    img = Image.open("C:/Users/hs/Desktop/FaceRecog/images/Student1.jfif")
    img = img.resize((500,130),Image.Resampling.LANCZOS)
    self.photoimg = ImageTk.PhotoImage(img)
    
    #Label for first image
    first_label = Label(self.root,image=self.photoimg)
    first_label.place(x=0,y=0,width=500,height=130)

    #Second image
    img2 = Image.open("C:/Users/hs/Desktop/FaceRecog/images/Student2.jpg")
    img2 = img2.resize((500,130),Image.Resampling.LANCZOS)
    self.photoimg2 = ImageTk.PhotoImage(img2)
    
    #Label for Second image
    first_label = Label(self.root,image=self.photoimg2)
    first_label.place(x=500,y=0,width=500,height=130)

    #Third image
    img3 = Image.open("C:/Users/hs/Desktop/FaceRecog/images/Student3.webp")
    img3 = img3.resize((550,130),Image.Resampling.LANCZOS)
    self.photoimg3 = ImageTk.PhotoImage(img3)
    
    #Label for third image
    first_label = Label(self.root,image=self.photoimg3)
    first_label.place(x=1000,y=0,width=550,height=130)

     #Background image
    img4 = Image.open("C:/Users/hs/Desktop/FaceRecog/images/bg.jpg")
    img4 = img4.resize((1530,710),Image.Resampling.LANCZOS)
    self.photoimg4 = ImageTk.PhotoImage(img4)
    
    #Label for Background image
    bg_img = Label(self.root,image=self.photoimg4)
    bg_img.place(x=0,y=130,width=1530,height=710)

     #Title of page
    title_label = Label(bg_img,text="STUDENT'S PAGE",font=("Times New Roman",35,"bold"),bg="green",fg="black")
    title_label.place(x=0,y=0,width=1530,height=45)

    #Frame
    main_frame = Frame(bg_img,bd=2,bg="white")
    main_frame.place(x=10,y=55,width=1500,height=600)

    #Left Label Frame
    Left_frame = LabelFrame(main_frame,bd=2,bg="white",relief=RIDGE,text="Student's Details",font=("times new roman",12,"bold"))
    Left_frame.place(x=15,y=10,width=730,height=580)

    # Left Label Image
    img_left = Image.open("C:/Users/hs/Desktop/FaceRecog/images/Student1.jfif")
    img_left = img_left.resize((720,130),Image.Resampling.LANCZOS)
    self.photoimg_left = ImageTk.PhotoImage(img_left)
    
    #Label for left label image
    first_label = Label(Left_frame,image=self.photoimg_left)
    first_label.place(x=5,y=0,width=720,height=130)
    
    #current course
    current_course_frame = LabelFrame(Left_frame,bd=2,bg="white",relief=RIDGE,text="Current Course Info",font=("times new roman",12,"bold"))
    current_course_frame.place(x=5,y=130,width=720,height=115)

    #department
    dep_label = Label(current_course_frame,text="Department",font=("times new roman",13,"bold"),bg="white")
    dep_label.grid(row=0,column=0,padx=10,sticky=W)

    dep_combo = ttk.Combobox(current_course_frame,textvariable=self.var_dep,font=("times new roman",13),width=17,state="read only")
    dep_combo["values"] = ("Select Department","CSE","IT","Civil","Mechanical","Electronics","Electrical")
    dep_combo.current(0)
    dep_combo.grid(row=0,column=1,padx=2,pady=10,sticky=W)

    #Course
    course_label = Label(current_course_frame,text="Course",font=("times new roman",13,"bold"),bg="white")
    course_label.grid(row=0,column=2,padx=10,sticky=W)

    course_combo = ttk.Combobox(current_course_frame,textvariable=self.var_course,font=("times new roman",13),width=17,state="read only")
    course_combo["values"] = ("Select Course","FE","SE","TE","BE")
    course_combo.current(0)
    course_combo.grid(row=0,column=3,padx=2,pady=10,sticky=W)

    #Year
    year_label = Label(current_course_frame,text="Year",font=("times new roman",13,"bold"),bg="white")
    year_label.grid(row=1,column=0,padx=10,sticky=W)

    year_combo = ttk.Combobox(current_course_frame,textvariable=self.var_year,font=("times new roman",13),width=17,state="read only")
    year_combo["values"] = ("Select Year","2021-22","2022-23","2023-24","2024-25")
    year_combo.current(0)
    year_combo.grid(row=1,column=1,padx=2,pady=10,sticky=W)

    #Semester
    semester_label = Label(current_course_frame,text="Semester",font=("times new roman",13,"bold"),bg="white")
    semester_label.grid(row=1,column=2,padx=10,sticky=W)

    semester_combo = ttk.Combobox(current_course_frame,textvariable=self.var_semester,font=("times new roman",13),width=17,state="read only")
    semester_combo["values"] = ("Select Semester","1","2","3","4","5","6","7","8")
    semester_combo.current(0)
    semester_combo.grid(row=1,column=3,padx=2,pady=10,sticky=W)

    #Class Student INformation
    class_student_frame = LabelFrame(Left_frame,bd=2,bg="white",relief=RIDGE,text="Class Student Info",font=("times new roman",13,"bold"))
    class_student_frame.place(x=5,y=250,width=720,height=300)

    #Student_ID
    studentID_label = Label(class_student_frame,text="StudentID:",font=("times new roman",13,"bold"),bg="white")
    studentID_label.grid(row=0,column=0,padx=10,pady=5,sticky=W)

    studentID_entry = ttk.Entry(class_student_frame,textvariable=self.var_std_id,width=20,font=("times new roman",13,"bold"))
    studentID_entry.grid(row=0,column=1,padx=10,pady=5,sticky=W)

    #Student Name
    studentName_label = Label(class_student_frame,text="Student Name:",font=("times new roman",13,"bold"),bg="white")
    studentName_label.grid(row=0,column=2,padx=10,pady=5,sticky=W)

    studentName_entry = ttk.Entry(class_student_frame,textvariable=self.var_std_name,width=20,font=("times new roman",13,"bold"))
    studentName_entry.grid(row=0,column=3,padx=10,pady=5,sticky=W)

    #Class Division
    class_div_label = Label(class_student_frame,text="Class Division:",font=("times new roman",13,"bold"),bg="white")
    class_div_label.grid(row=1,column=0,padx=10,pady=5,sticky=W)

    class_div_entry = ttk.Entry(class_student_frame,textvariable=self.var_div,width=20,font=("times new roman",13,"bold"))
    class_div_entry.grid(row=1,column=1,padx=10,pady=5,sticky=W)

    #Roll_no
    roll_no_label = Label(class_student_frame,text="Roll no:",font=("times new roman",13,"bold"),bg="white")
    roll_no_label.grid(row=1,column=2,padx=10,pady=5,sticky=W)

    roll_no_entry = ttk.Entry(class_student_frame,textvariable=self.var_roll,width=20,font=("times new roman",13,"bold"))
    roll_no_entry.grid(row=1,column=3,padx=10,pady=5,sticky=W)

    #Gender
    gender_label = Label(class_student_frame,text="Gender:",font=("times new roman",13,"bold"),bg="white")
    gender_label.grid(row=2,column=0,padx=10,pady=5,sticky=W)

    gender_entry = ttk.Entry(class_student_frame,textvariable=self.var_gender,width=20,font=("times new roman",13,"bold"))
    gender_entry.grid(row=2,column=1,padx=10,pady=5,sticky=W)

    #DOB
    dob_label = Label(class_student_frame,text="D.O.B:",font=("times new roman",13,"bold"),bg="white")
    dob_label.grid(row=2,column=2,padx=10,pady=5,sticky=W)

    dob_entry = ttk.Entry(class_student_frame,textvariable=self.var_dob,width=20,font=("times new roman",13,"bold"))
    dob_entry.grid(row=2,column=3,padx=10,pady=5,sticky=W)

    #Email
    email_label = Label(class_student_frame,text="E-mail:",font=("times new roman",13,"bold"),bg="white")
    email_label.grid(row=3,column=0,padx=10,pady=5,sticky=W)

    email_entry = ttk.Entry(class_student_frame,textvariable=self.var_email,width=20,font=("times new roman",13,"bold"))
    email_entry.grid(row=3,column=1,padx=10,pady=5,sticky=W)

    #Phone no
    phone_label = Label(class_student_frame,text="Phone:",font=("times new roman",13,"bold"),bg="white")
    phone_label.grid(row=3,column=2,padx=10,pady=5,sticky=W)

    phone_entry = ttk.Entry(class_student_frame,textvariable=self.var_phone,width=20,font=("times new roman",13,"bold"))
    phone_entry.grid(row=3,column=3,padx=10,pady=5,sticky=W)

    #Address
    address_label = Label(class_student_frame,text="Address:",font=("times new roman",13,"bold"),bg="white")
    address_label.grid(row=4,column=0,padx=10,pady=5,sticky=W)

    address_entry = ttk.Entry(class_student_frame,textvariable=self.var_address,width=20,font=("times new roman",13,"bold"))
    address_entry.grid(row=4,column=1,padx=10,pady=5,sticky=W)

    #Teacher's Name
    teacher_label = Label(class_student_frame,text="Teacher Name:",font=("times new roman",13,"bold"),bg="white")
    teacher_label.grid(row=4,column=2,padx=10,pady=5,sticky=W)

    teacher_entry = ttk.Entry(class_student_frame,textvariable=self.var_teacher,width=20,font=("times new roman",13,"bold"))
    teacher_entry.grid(row=4,column=3,padx=10,pady=5,sticky=W)

    #Radio button
    self.var_radio1 = StringVar()
    radiobtn1 = ttk.Radiobutton(class_student_frame,variable=self.var_radio1,text="Take photo sample",value="YES")
    radiobtn1.grid(row=6,column=0)

    radiobtn2 = ttk.Radiobutton(class_student_frame,variable=self.var_radio1,text="No photo sample",value="NO")
    radiobtn2.grid(row=6,column=1)

    #buttons Frame
    btn_frame = Frame(class_student_frame,bd=2,relief=RIDGE,bg="white")
    btn_frame.place(x=0,y=200,width=715,height=35)

    save_btn = Button(btn_frame,text="Save",command=self.add_data,width=17,font=("times new roman",13,"bold"),bg="blue",fg="white")
    save_btn.grid(row=0,column=0)

    update_btn = Button(btn_frame,text="Update",width=17,font=("times new roman",13,"bold"),bg="blue",fg="white")
    update_btn.grid(row=0,column=1)

    reset_btn = Button(btn_frame,text="Reset",width=17,font=("times new roman",13,"bold"),bg="blue",fg="white")
    reset_btn.grid(row=0,column=2)

    delete_btn = Button(btn_frame,text="Delete",width=17,font=("times new roman",13,"bold"),bg="blue",fg="white")
    delete_btn.grid(row=0,column=3)

    #Another button frame
    btn_frame1 = Frame(class_student_frame,bd=2,relief=RIDGE,bg="white")
    btn_frame1.place(x=0,y=235,width=715,height=35)

    take_photo_btn = Button(btn_frame1,text="Take Photo Sample",width=35,font=("times new roman",13,"bold"),bg="blue",fg="white")
    take_photo_btn.grid(row=0,column=0)

    update_photo_btn = Button(btn_frame1,text="Update Photo Sample",width=35,font=("times new roman",13,"bold"),bg="blue",fg="white")
    update_photo_btn.grid(row=0,column=1)

    #Right Label Frame
    Right_frame = LabelFrame(main_frame,bd=2,bg="white",relief=RIDGE,text="Student's Details",font=("times new roman",12,"bold"))
    Right_frame.place(x=760,y=10,width=720,height=580)

    #Right Label Iright
    img_right = Image.open("C:/Users/hs/Desktop/FaceRecog/images/Student2.jpg")
    img_right = img_right.resize((720,130),Image.Resampling.LANCZOS)
    self.photoimg_right = ImageTk.PhotoImage(img_right)
    
    #Label for right label image
    first_label = Label(Right_frame,image=self.photoimg_right)
    first_label.place(x=5,y=0,width=720,height=130)

    #============== Search System =================
    Search_frame = LabelFrame(Right_frame,bd=2,bg="white",relief=RIDGE,text="Search System",font=("times new roman",13,"bold"))
    Search_frame.place(x=5,y=135,width=710,height=70)

    Search_label = Label(Search_frame,text="Search by:",font=("times new roman",15,"bold"),bg="red",fg="white")
    Search_label.grid(row=0,column=0,padx=10,pady=5,sticky=W)

    search_combo = ttk.Combobox(Search_frame,font=("times new roman",13),width=17,state="read only")
    search_combo["values"] = ("Select","Roll No","Phone No")
    search_combo.current(0)
    search_combo.grid(row=0,column=1,padx=2,pady=10,sticky=W) 

    search_entry = ttk.Entry(Search_frame,width=15,font=("times new roman",13,"bold"))
    search_entry.grid(row=0,column=2,padx=10,pady=5,sticky=W)

    search_btn = Button(Search_frame,text="Search",width=12,font=("times new roman",12,"bold"),bg="blue",fg="white")
    search_btn.grid(row=0,column=3,padx=4)

    showAll_btn = Button(Search_frame,text="Show All",width=12,font=("times new roman",12,"bold"),bg="blue",fg="white")
    showAll_btn.grid(row=0,column=4,padx=4)

    #Table Frame
    table_frame = Frame(Right_frame,bd=2,bg="white",relief=RIDGE)
    table_frame.place(x=5,y=210,width=710,height=350)

    scroll_x = ttk.Scrollbar(table_frame,orient=HORIZONTAL)
    scroll_y = ttk.Scrollbar(table_frame,orient=VERTICAL)

    self.student_table = ttk.Treeview(table_frame,column=("dep","course","year","sem","id","name","div","roll","gender","dob","email","phone","address","teacher","photo"),xscrollcommand=scroll_x.set,yscrollcommand=scroll_y.set)
    scroll_x.pack(side=BOTTOM,fill=X)
    scroll_y.pack(side=RIGHT,fill=Y)
    scroll_x.config(command=self.student_table.xview)
    scroll_y.config(command=self.student_table.yview)

    self.student_table.heading("dep",text="Department")
    self.student_table.heading("course",text="Course")
    self.student_table.heading("year",text="Year")
    self.student_table.heading("sem",text="Semester")
    self.student_table.heading("id",text="Student_ID")
    self.student_table.heading("name",text="Name")
    self.student_table.heading("div",text="Division")
    self.student_table.heading("roll",text="Roll_No")
    self.student_table.heading("gender",text="Gender")
    self.student_table.heading("dob",text="D.O.B")
    self.student_table.heading("email",text="E-Mail")
    self.student_table.heading("phone",text="Phone")
    self.student_table.heading("address",text="Address")
    self.student_table.heading("teacher",text="Teacher")
    self.student_table.heading("photo",text="PhotoSampleStatus")
    self.student_table["show"] = "headings"

    self.student_table.column("dep",width=100)
    self.student_table.column("course",width=100)
    self.student_table.column("year",width=100)
    self.student_table.column("sem",width=100)
    self.student_table.column("id",width=100)
    self.student_table.column("name",width=100)
    self.student_table.column("div",width=100)
    self.student_table.column("roll",width=100)
    self.student_table.column("gender",width=100)
    self.student_table.column("dob",width=100)
    self.student_table.column("email",width=100)
    self.student_table.column("phone",width=100)
    self.student_table.column("address",width=100)
    self.student_table.column("teacher",width=100)
    self.student_table.column("photo",width=150)

    self.student_table.pack(fill=BOTH,expand=1)
    # self.fetch_data()
    

# =============== Function Declarations ==================
def add_data(self):
    if self.var_dep.get() == "Select Department" or self.var_std_name.get() == "" or self.var_std_id.get() == "":
        messagebox.showerror("Error","All fields are required",parent=self.root)
    else:
        try:
            print("connection starts")
            conn = mysql.connector.connect(host="localhost",port="3306",user="root",password="Vineet@888",database="face_recognizer")
            if conn.is_connected():
                print("Connected to the MySQL database successfully!")
            my_cursor = conn.cursor()
            my_cursor.execute("insert into student values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)",(
                self.var_dep.get(),
                self.var_course.get(),
                self.var_year.get(),
                self.var_semester.get(),
                self.var_std_id.get(),
                self.var_std_name.get(),
                self.var_div.get(),
                self.var_roll.get(),
                self.var_gender.get(),
                self.var_dob.get(),
                self.var_email.get(),
                self.var_phone.get(),
                self.var_address.get(),
                self.var_teacher.get(),
                self.var_radio1.get()
            ))
            conn.commit()
            # self.fetch_data()
            conn.close()
            messagebox.showinfo("Success","Student details are added successfully",parent=self.root)
        except Exception as es:
            messagebox.showerror("Error",f"Due to: {str(es)}",parent=self.root)


# =============== Fetch data =================
# def fetch_data(self):
#     conn = mysql.connector.connect(host="localhost",user="root",password="Vineet@888",database="face_recognizer")
#     my_cursor = conn.cursor()
#     my_cursor.execute("select * from student")
#     data = my_cursor.fetchall()

#     if(len(data)!=0):
#         self.student_table.delete(*self.student_table.get_children())
#         for i in data:
#             self.student_table.insert("",END,values=i)
#             conn.commit()
#         conn.close()

if name == "main":
root = Tk()
obj = Student(root)
root.mainloop()

Expected behavior

The code should open a GUI window and after entering the required fields and clicking on save button, the window should show a popup message and the data should be saved in the database.

Actual behavior

On clicking the save button, the window is getting closed and no data is getting saved in the database.

[github-actions]

This issue was already fixed (see #1306). Please upgrade to the 2.3.5 version of PSReadLine from PowerShell Gallery.
See the upgrading section for instructions. Please let us know if you run into the same issue with the latest version.