Комплекс подключения FLASK mysqlsserver

Приветствие всем разработчикам python и flask. Я пытаюсь создать приложение в flask, регистрация которого не работает. 1 основное приложение.

from flaskext.mysql import MySQL
app = Flask(__name__,static_url_path='/static')

mysql= MySQL()
app.config['MYSQL_DATABASE_USER'] = 'root'
app.config['MYSQL_DATABASE_PASSWORD'] = 'Nimnam*7'
app.config['MYSQL_DATABASE_DB'] = 'store'
app.config['MYSQL_DATABASE_HOST'] = '127.0.0.1'
mysql.init_app(app)
conn = mysql.connect()


@app.route('/')

def hello_world():
    return render_template('home.html')


@app.route('/signup/', methods=['GET','POST'])
def registeruser():
    if request.method == 'POST':
        cursor = conn.cursor()
        firstname= request.form.get('firstname')
        secondname=request.form.get('secondname')
        surname=request.form.get('surname')
        email=request.form.get('email')
        password=request.form.get('password')
        gender=request.form.get('gender')
        cursor.execute("insert into store.user values  (%s,%s,%s,%s,%s,%s)"%(firstname,secondname,surname,email,password,gender))
        cursor.commit()
        housenumber = request.form.get('housenumber')
        street = request.form.get('street')
        area= request.form.get('area')
        phonenumber1 = request.form.get('phone1')
        phonenumber2 = request.form.get('phone2')
        cursor.execute("insert into store.contact values (%s,%s,%s,%s,%s,%s)"%(phonenumber1,email,housenumber,street,area,phonenumber2))
        cursor.commit()
        return "weldone you are registerd"
    return render_template('signup.html')

if __name__ == '__main__':
    app.run()

Теперь вот форма, шаблон signup.html

  <h1>We are pleased to have you join our community </h1>
      <p>There are only three essential things we need to know about you our dear customer so that you make the best of our services</p>
      <p>Currently we are operating in lefke Gemikonagi and Guzelyurt</p>
      <h2>Where you live </h2>
       <form action='/signup/' method = "post">
           <fieldset>
                <legend>Identity: who you are</legend>
                <label>First name:
                     <input type = "text" name = "firstname" required>
                </label><br/> <br/>
                <label>Second name:
                     <input type = "text" name = "secondname" />
                </label><br/> <br/>
                <label>Surname:
                      <input type = "text" name = "surname" />
                </label>
           </fieldset><br/> <br/>
           <fieldset>
               <legend>Where you live :Adress</legend>
               <label>House number:
                    <input type = "text" name = "housenumber"  required >
               </label><br/> <br/>
               <label>Street:
                    <input type = "text" name = "street" placeholder = "street or avenue" required >
               </label><br/> <br/>
               <label>Area:
                    <input type = "text" name = "area" placeholder = "eg Lefke, Guz" required >
               </label><br/> <br/>
           </fieldset>
           <br/> <br/>
           <fieldset>
                <legend>Contact details</legend>
                <label>Phone number:
                     <input type = "tel" name = "phone1" pattern = "[0-9]{4}-[0-9]{3}-[0-9]{4}" placeholder = "Telsim or Turkcell" required>
                      <span class = "note">Format: 1234-456-7890</span>
                </label><br/> <br/>
                <label>Email:
                     <input type = "email" name = "email" placeholder= "eg nim@gmail" required>
                </label><br/> <br/>
                <label>Phone number2:
                     <input type = "tel" name = "phone2" placeholder = "optional"/>
                </label>

           </fieldset>
            <p>Select your gender<p>
                <label>
                    <input type = "radio" name = "gender" value = "F"/>
                 Male
                </label>
                <label>
                    <input type = "radio" name = "gender" value = "M" />
                    Female
                </label><br/> <br/>
                <input type = "submit" vlaue = "Sign up" class = "lgbtn"/>

        </form>

База данных хорошо подключена, и я не заметил ничего, что могло бы быть не так с таблицами, которые я использую mysql. но когда я пытаюсь заполнить свои собственные файлы, чтобы поместить данные в БД я встречаю эту странную ошибку

pymysql.err.ProgrammingError: (1064, "You have an error in your SQL syntax;  check the manual that corresponds to your MySQL server version for the right syntax to use near '@gmail.com,None,F)' at line 1")

127.0.0.1 - - [01.02.2019 01:10:08] "POST /signup/ HTTP/1.1" 500 - любой ответ будет откровением и будет принят с благодарностью Я новичок