ComMotion - Error when I run CreateDb.sql

[billyshears314]

ComMotion - Error when I run CreateDb.sql

[nfamigletti]

I think I know what's causing your error. Whenever I change CreateDb.sql, I run it through my own psql before I push it to github, so hopefully I can make this work for you. I'm not at my own computer now, but I should be able to look into this within the hour.

On Apr 19, 2014, at 1:34 PM, billyshears314 wrote:

When I run CreateDb.sql with "psql -d commotion -a -f CreateDb.sql" to recreate the tables in my database, I get this error:
...
psql:sql/CreateDb.sql:215: ERROR: column "difficulty_id" of relation "users" does not exist
LINE 1: INSERT INTO users (id, username, password, difficulty_id) VA...

—
Reply to this email directly or view it on GitHub.

[ppegusii]

I don't have this error. It may be that there's a table left over from a previous version of the script and it needs to be manually dropped. I usually run "psql -d commotion -a -f sql/CreateDb.sql | grep -i error" to make sure I don't miss any error message that happen early in the script execution.

[billyshears314]

Thanks guys, I manually dropped all the tables and now it works fine when I run it.