CODEWITHSUNDEEP
pythonwebflask
Jake Ols
Jake Ols

Reputation: 2852

Flask 405 Error

I keep getting this error when trying to insert some simple text into a db. 

Method Not Allowed
The method is not allowed for the requested URL."

I'm moving from PHP to python so bear with me here.

The code is:

from flask import Flask, request, session, g, redirect, url_for, \
    abort, render_template, flash

from flask.ext.sqlalchemy import SQLAlchemy

app = Flask(__name__)
    app.config['SQLALCHEMY_DATABASE_URI'] = 'mysql://root:password@localhost/pythontest'
    db = SQLAlchemy(app)
    app = Flask(__name__)

@app.route('/justadded/')
def justadded():
    cur = g.db.execute('select TerminalError, TerminalSolution from Submissions order by id desc')
    entries = [dict(title=row[0], text=row[1]) for row in cur.fetchall()]
    return render_template('view_all.html', entries=entries)

@app.route('/new', methods= "POST")
def newsolution():
    if not request.method == 'POST':
        abort(401)
    g.db.execute('INSERT INTO Submissions (TerminalError, TerminalSolution, VALUES (?, ?)'
                [request.form['TerminalError'], request.form['TerminalSolution']])
    g.db.commit()
    flash('Succesful')
    return redirect(url_for('justadded'))




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

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

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

And the html code for the form is:

    <form action="/new" method="POST">
        <input name="TerminalError" id="searchbar" type="text"         placeholder="Paste Terminal error here...">
        <input name="TerminalSolution" id="searchbar" type="text" placeholder="Paste Terminal solution here...">
        <button type="submit" id="search" class="btn btn-primary">Contribute</button>
        </form>

Upvotes: 0

Views: 2875

Answers (1)

Miguel Grinberg
Miguel Grinberg

Reputation: 67479

The error has nothing to do with inserting data into the database, it's the methods argument of your /new route.

Instead of this:

@app.route('/new', methods= "POST")

do this:

@app.route('/new', methods= ["POST"])

The list of valid methods needs to be given as an array.

Upvotes: 5

Related Questions