<p>Just downloaded revision 2740 using bzr as Thomas Groths chords branch now merged into the trunk, unfortunately is causing a crash, the traceback seems to be pointing towards a sql database issue related to been no projector.serial_no column in the sqlite database :-</p><p>Traceback (most recent call last):</p>
<p> File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1139, in execute_context</p>
<p> context)</p>
<p> File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute</p>
<p> cursor.execute(statement, parameters)</p>
<p>sqlite3.OperationalError: no such column: projector.serial_no</p>
<p><br></p>
<p>The above exception was the direct cause of the following exception:</p>
<p><br></p>
<p>Traceback (most recent call last):</p>
<p> File "openlp.py", line 44, in <module></p>
<p> main()</p>
<p> File "/home/user2/openlp/openlp/core/init.py", line 439, in main</p>
<p> sys.exit(application.run(qt_args))</p>
<p> File "/home/user2/openlp/openlp/core/init.py", line 143, in run</p>
<p> Registry().execute('bootstrap_post_set_up')</p>
<p> File "/home/user2/openlp/openlp/core/common/registry.py", line 137, in execute</p>
<p> result = function(*args, **kwargs)</p>
<p> File "/home/user2/openlp/openlp/core/ui/projector/manager.py", line 318, in bootstrap_post_set_up</p>
<p> self.load_projectors()</p>
<p> File "/home/user2/openlp/openlp/core/ui/projector/manager.py", line 791, in load_projectors</p>
<p> for item in self.projectordb.get_projector_all():</p>
<p> File "/home/user2/openlp/openlp/core/lib/projector/db.py", line 286, in get_projector_all</p>
<p> new_list = self.get_all_objects(Projector)</p>
<p> File "/home/user2/openlp/openlp/core/lib/db.py", line 378, in get_all_objects</p>
<p> return query.all()</p>
<p> File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 2613, in all</p>
<p> return list(self)</p>
<p> File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 2761, in iter</p>
<p> return self.execute_and_instances(context)</p>
<p> File "/usr/lib/python3/dist-packages/sqlalchemy/orm/query.py", line 2776, in execute_and_instances</p>
<p> result = conn.execute(querycontext.statement, self.params)</p>
<p> File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 914, in execute</p>
<p> return meth(self, multiparams, params)</p>
<p> File "/usr/lib/python3/dist-packages/sqlalchemy/sql/elements.py", line 323, in execute_on_connection</p>
<p> return connection.execute_clauseelement(self, multiparams, params)</p>
<p> File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement</p>
<p> compiled_sql, distilled_params</p>
<p> File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context</p>
<p> context)</p>
<p> File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception</p>
<p> exc_info</p>
<p> File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause</p>
<p> reraise(type(exception), exception, tb=exc_tb, cause=cause)</p>
<p> File "/usr/lib/python3/dist-packages/sqlalchemy/util/compat.py", line 185, in reraise</p>
<p> raise value.with_traceback(tb)</p>
<p> File "/usr/lib/python3/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context</p>
<p> context)</p>
<p> File "/usr/lib/python3/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute</p>
<p> cursor.execute(statement, parameters)</p>
<p>sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: projector.serial_no [SQL: 'SELECT projector.id AS projector_id, projector.ip AS projector_ip, projector.port AS projector_port, projector.pin AS projector_pin, projector.name AS projector_name, projector.location AS projector_location, projector.notes AS projector_notes, projector.pjlink_name AS projector_pjlink_name, projector.manufacturer AS projector_manufacturer, projector.model AS projector_model, projector.other AS projector_other, projector.sources AS projector_sources, projector.serial_no AS projector_serial_no, projector.sw_version AS projector_sw_version, projector.model_filter AS projector_model_filter, projector.model_lamp AS projector_model_lamp, projectorsource_1.id AS projectorsource_1_id, projectorsource_1.code AS projectorsource_1_code, projectorsource_1.text AS projectorsource_1_text, projectorsource_1.projector_id AS projectorsource_1_projector_id \nFROM projector LEFT OUTER JOIN projectorsource AS projectorsource_1 ON projector.id = projectorsource_1.projector_id ORDER BY projectorsource_1.code']</p>
<p><br></p>