Sorting an SQLite database

Question

In my app, I have a database with a table that contains several user made entries. Here's a simplified version of my SQLite database helper class:

public class DatabaseHelper extends SQLiteOpenHelper {
    public static final String DATABASE_NAME = "data.db";
    public static final String TABLE_NAME = "log";
    public static final String COL_1 = "ID"; //autoincrement in oncreate
    ...
    public static final String COL_12 = "NUMBER"; //set through getCount()

    public DatabaseHelper(Context context) {
        ...
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        ...
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        ...
    }

    public long getCount() {
        ...
    }

    public boolean insertData(...) {
        ...
    }

    public void update(long id, String param) {
        ...
    }

    public Cursor getAllData() {
        ...
    }

    //for when an entry is deleted and thus COL_12 numbering is not fixed
    public void consolidate() {
        SQLiteDatabase db = this.getWritableDatabase();
        db.execSQL("ALTER TABLE log ORDER BY NUMBER ASC");
    }
}

However, whenever I call myDb.consolidate(), my app crashes. From what I've read from other posts, this should work, but it only throws error code 1: missing database. Anyone know why? Any help is appreciated.