Trying To Migrate In Django 1.9 -- Strange Sql Error "django.db.utils.operationalerror: Near ")": Syntax Error"

I don't have a clue what's causing this error. It appears to be a bug that there isn't a fix for. Could anyone tell give me a hint as to how I might get around this? It's frustr

Solution 1:

This appears to be the line that's causing the errror:

INSERTINTO "optilab_lasersubstrate" () SELECTFROM "optilab_lasersubstrate__old";

You are usually expected to have a list of columns in those parenthesis. Eg INSERT INTO "optilab_lasersubstrate" (col1,col2,etc) however the migration has produced a blank set! Similarly the SELECT FROM portion should read as SELECT col1,col2 FROM. By some strange set of events you appear to have managed to create a table with no columns!!

I see from your migration file that you are anyway dropping this table. So there isn't any reason to struggle with the RemoveField portion. It's code associated with the RemoveField that's causing the error. Change your migration as follows:

class Migration(migrations.Migration):

    dependencies = [
        ('optilab', '0005_test'),
    ]

    operations = [
        migrations.DeleteModel(
            name='LaserSubstrate',
        ),
        migrations.DeleteModel(
            name='WaveguideSubstrate',
        ),
    ]

Solution 2:

Edit base.py in the lines that breaks and update it to:

defexecute(self, query, params=None):
    if params isNone:
        if'()'notinstr(query):
            return Database.Cursor.execute(self, query)
    query = self.convert_query(query)
    if'()'notinstr(query):
        return Database.Cursor.execute(self, query, params)