Error when entering results

[GoogleCodeExporter]

Running the tab off a network, this happened when someone was trying to enter 
the results from a different computer. It was a fresh install, using the GSD 
debate data, no alterations to the tab.

[wrapped: Could not execute query [Native Error: ERROR: relation "team_results" 
does not exist LINE 1: ...RE, team_results.WINNING_DEBATE_TEAM_XREF_ID FROM 
team_resul... ^] [User Info: SELECT team_results.DEBATE_TEAM_XREF_ID, 
team_results.TEAM_VOTE_COUNT, team_results.OPPONENT_DEBATE_TEAM_XREF_ID, 
team_results.OPPONENT_TEAM_VOTE_COUNT, team_results.MAJORITY_TEAM_SCORE, 
team_results.WINNING_DEBATE_TEAM_XREF_ID FROM team_results WHERE 
team_results.DEBATE_TEAM_XREF_ID=29]]

stack trace
at ()
in SF_SYMFONY_LIB_DIR/vendor/propel/util/BasePeer.php line 458 ...
            if ($stmt) $stmt->close();

            if ($criteria->isUseTransaction()) $con->rollback();

            Propel::log($e->getMessage(), Propel::LOG_ERR);

            throw new PropelException($e);

        }

        return $rs;

Original issue reported on code.google.com by logani...@gmail.com on 1 Jul 2011 at 3:24

Attachments:

• 3tab_error_entering_result.sql

[GoogleCodeExporter]

I didn't run views.xml .   the views.sql contains the queries used to aggregate 
results for a round. Just load that file and the errors will disappear

Original comment by logani...@gmail.com on 1 Jul 2011 at 3:59

[GoogleCodeExporter]

User did not load views.sql. Both the lib.model.schema.sql and views.sql.

Original comment by sut...@gmail.com on 1 Jul 2011 at 6:19

• Changed state: Invalid