为什么我的python应用程序继续获得500内部服务器错误？

我正在尝试将我的app.py与MySQL数据库链接，但我不断收到以下错误 . 我的存储库的链接在这里：https://github.com/trhubwork/python-mysql-proj.git

我正在运行python 3.5.1

控制台错误：

jquery-1.11.2.js：9659 POST [runningonlocalhost] / signUp 500（INTERNAL SERVER ERROR）发送@jquery-1.11.2.js：9659ajax @jquery-1.11.2.js：9210（匿名函数）@ signUp . js：4dispatch @jquery-1.11.2.js：4665elemData.handle @jquery-1.11.2.js：4333 signUp.js：12 Object {readyState：4，responseText：“↵”，status：500，statusText：“INTERNAL服务器错误”}

Gitbash终端错误：

在[localhost]上运行：5002 /（按CTRL C退出）127.0.0.1 - - [29 / Sep / 2016 22:06:17]“GET / HTTP / 1.1”200 - 127.0.0.1 - - [29 / 2016年9月22:06:20]“GET / showSignUp HTTP / 1.1”200 - [2016-09-29 22:06:22,142]应用程序中出现错误：/ signUp [POST] Traceback（最近一次调用最后一次）：文件“C：\ Users \ TR \ AppData \ Local \ Programs \ Python \ Python35-32 \ lib \ site-packages \ flask \ app.py”，第1988行，在wsgi_app response = self.full_dispatch_request（）文件“C： \ Users \ TR \ AppData \ Local \ Programs \ Python \ Python35-32 \ lib \ site-packages \ flask \ app.py“，第1641行，在full_dispatch_request中rv = self.handle_user_exception（e）文件”C：\ Users \在handle_user_exception重新提取（exc_type，exc_value，tb）文件“C：\ Users \ TR \ AppData”中的TR \ AppData \ Local \ Programs \ Python \ Python35-32 \ lib \ site-packages \ flask \ app.py“，第1544行\ Local \ Programs \ Python \ Python35-32 \ lib \ site-packages \ flask_compat.py“，第33行，在重新加注值文件”C：\ Users \ TR \ AppData \ Local \ Programs \ Python \ Python35-32 \ lib \ site-packages \ flask \ app.py“，第1639行，在full_dispatch_request中rv = self.dispatch_request（）文件“C：\ Users \ TR \ AppData \ Local \ Programs \ Python \ Python35-32 \ lib \ site-packages \ flask \ app.py”，第1625行，在dispatch_request中返回self .view_functionsrule.endpoint文件“app.py”，第54行，in signUp cursor.close（）UnboundLocalError：在赋值127.0.0.1之前引用的局部变量'cursor' - [29 / Sep / 2016 22:06:22]“POST / signUp HTTP / 1.1“500 - [2016-09-29 22：09：03,808]应用程序中出现错误：/ signUp [POST]回溯异常（最近一次调用最后一次）：文件”C：\ Users \ TR \ AppData \ Local \ Programs \ Python \ Python35-32 \ lib \ site-packages \ flask \ app.py“，第1988行，在wsgi_app response = self.full_dispatch_request（）文件”C：\ Users \ TR \ AppData \ Local \ Programs \ Python \ Python35-32 \ lib \ site-packages \ flask \ app.py“，第1641行，在full_dispatch_request中rv = self.handle_user_exception（e）文件”C：\ Users \ TR \ AppData \ Local \ Programs \ Python \ Python35 -32 \ lib \ site-packages \ flask \ app.py“，第1544行，在handle_user_exception中重新加载（exc_type，exc_value，tb）文件”C： \ Users \ TR \ AppData \ Local \ Programs \ Python \ Python35-32 \ lib \ site-packages \ flask_compat.py“，第33行，在重新加注值文件”C：\ Users \ TR \ AppData \ Local \ Programs \ Python \ Python35-32 \ lib \ site-packages \ flask \ app.py“，第1639行，在full_dispatch_request中rv = self.dispatch_request（）文件”C：\ Users \ TR \ AppData \ Local \ Programs \ Python \ Python35-在dispatch_request中的32 \ lib \ site-packages \ flask \ app.py“，第1625行返回self.view_functionsrule.endpoint文件”app.py“，第54行，在signUp cursor.close（）中UnboundLocalError：局部变量'cursor'在分配127.0.0.1之前引用 - - [29 / Sep / 2016 22:09:03]“POST / signUp HTTP / 1.1”500 -

这是我的app.py.

from flask import Flask, render_template, json, request
from flaskext.mysql import MySQL
from werkzeug import generate_password_hash, check_password_hash

mysql = MySQL()
app = Flask(__name__)

# MySQL configurations
app.config['MYSQL_DATABASE_USER'] = 'jay'
app.config['MYSQL_DATABASE_PASSWORD'] = 'jay'
app.config['MYSQL_DATABASE_DB'] = 'BucketList'
app.config['MYSQL_DATABASE_HOST'] = 'localhost'
mysql.init_app(app)


@app.route('/')
def main():
    return render_template('index.html')

@app.route('/showSignUp')
def showSignUp():
    return render_template('signup.html')


@app.route('/signUp',methods=['POST','GET'])
def signUp():
    try:
        _name = request.form['inputName']
        _email = request.form['inputEmail']
        _password = request.form['inputPassword']

        # validate the received values
        if _name and _email and _password:

            # All Good, let's call MySQL

            conn = mysql.connect()
            cursor = conn.cursor()
            _hashed_password = generate_password_hash(_password)
            cursor.callproc('sp_createUser',(_name,_email,_hashed_password))
            data = cursor.fetchall()

            if len(data) is 0:
                conn.commit()
                return json.dumps({'message':'User created successfully !'})
            else:
                return json.dumps({'error':str(data[0])})
        else:
            return json.dumps({'html':'<span>Enter the required fields</span>'})

    except Exception as e:
        return json.dumps({'error':str(e)})
    finally:
        cursor.close()
        conn.close()

if __name__ == "__main__":
    app.run(port=5002)

    enter code here

Signup.html

<!DOCTYPE html>
<html lang="en">
  <head>
    <title>Python Flask Bucket List App</title>


    <link href="http://getbootstrap.com/dist/css/bootstrap.min.css" rel="stylesheet">

    <link href="http://getbootstrap.com/examples/jumbotron-narrow/jumbotron-narrow.css" rel="stylesheet">
    <link href="../static/css/signup.css" rel="stylesheet">
    <script src="../static/js/jquery-1.11.2.js"></script>
    <script src="../static/js/signUp.js"></script>

  </head>

  <body>

    <div class="container">
      <div class="header">
        <nav>
          <ul class="nav nav-pills pull-right">
            <li role="presentation" ><a href="showHome">Home</a></li>
            <li role="presentation"><a href="#">Sign In</a></li>
            <li role="presentation" class="active"><a href="#">Sign Up</a></li>
          </ul>
        </nav>
        <h3 class="text-muted">Python Flask App</h3>
      </div>

      <div class="jumbotron">
        <h1>Bucket List App</h1>
        <form class="form-signin">
        <label for="inputName" class="sr-only">Name</label>
        <input type="name" name="inputName" id="inputName" class="form-control" placeholder="Name" required autofocus>
        <label for="inputEmail" class="sr-only">Email address</label>
        <input type="email" name="inputEmail" id="inputEmail" class="form-control" placeholder="Email address" required autofocus>
        <label for="inputPassword" class="sr-only">Password</label>
        <input type="password" name="inputPassword" id="inputPassword" class="form-control" placeholder="Password" required>

        <button id="btnSignUp" class="btn btn-lg btn-primary btn-block" type="button">Sign up</button>
      </form>
      </div>



      <footer class="footer">
        <p>&copy; Company 2015</p>
      </footer>

    </div>
  </body>
</html>

signUp.js

$(function(){
    $('#btnSignUp').click(function(){

        $.ajax({
            url: '/signUp',
            data: $('form').serialize(),
            type: 'POST',
            success: function(response){
                console.log(response);
            },
            error: function(error){
                console.log(error);
            }
        });
    });
});