Coding newbie: internal server error when trying to run a flask web app with database connection

Question

I'm working on a simple flask web application. I've uploaded everything in order to execute the project on my webserver. Unfortunately it won't work (Error: Internal Server Error The server encountered an internal error and was unable to complete your request. Either the server is overloaded or there is an error in the application.) I've yet found anything that could help me.

This is my code

from flask import Flask, render_template, url_for, request,\
    redirect, g
from wtforms import Form, StringField, PasswordField, validators
import mysql.connector 
from werkzeug.security import generate_password_hash
from db.db_credentials import DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE  

class RegistrationForm(Form):
    username = StringField('Nutzernamen angeben', [validators.Length(min=4, max=50)])
    email = StringField('Email angeben', [validators.Length(min=6, max=255)])
    password = PasswordField('Password angeben',
            [validators.length(min=4, max=256), validators.DataRequired(), validators.EqualTo('confirmation', message='Passwörter müssen übereinstimmen')])
    confirmation = PasswordField('Passwort wiederholen')


app = Flask(__name__)

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


@app.route('/registration', methods=["GET", "POST"])
def register(): 
    form = RegistrationForm(request.form)
    username = form.username.data
    password = form.password.data
    email = form.email.data

    password = generate_password_hash(password)
    if request.method == "POST" and form.validate():
        assert isinstance(DB_DATABASE, tuple)
        g.con = mysql.connector.connect(host=DB_HOST, user=DB_USER, password=DB_PASSWORD,
                                        database=DB_DATABASE)
        cursor = g.con.cursor
        cursor.execute("INSERT INTO konten (username, password, email) VALUES {%s}, {%s}, {%s} ",
                       username, password, email)
        return redirect(url_for("login"))
    return render_template("register.html", form=form)

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

Include full stack trace in your post.

sushanth
– sushanth

2020-06-14 10:12:11 +00:00
Commented Jun 14, 2020 at 10:12 — sushanth
– sushanth, Commented Jun 14, 2020 at 10:12
Check the logs of the webserver.

Atharva Kadlag
– Atharva Kadlag

2020-06-14 11:01:17 +00:00
Commented Jun 14, 2020 at 11:01 — Atharva Kadlag
– Atharva Kadlag, Commented Jun 14, 2020 at 11:01

AnandhS · Accepted Answer · 2020-06-14 13:03:51Z

1

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

1.first you have to return a template.

2.My advice is to use sqlalchemy it will be very easy to sort the errors while connecting to database.

answered Jun 14, 2020 at 13:03

AnandhS

213 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Coding newbie: internal server error when trying to run a flask web app with database connection

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related