# After updating from v0.13.2 to v0.13.3 - Unable to import content **URL:** \ **Category:** Support\ **Created:** [June 8, 2020, 6:31pm UTC](https://community.learningequality.org/t/after-updating-from-v0-13-2-to-v0-13-3-unable-to-import-content/1564 "2020-06-08T18:31:22Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Bryan\_Fisher](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.learningequality.org/bryan_fisher/32/160_2.png) [@Bryan\_Fisher](https://community.learningequality.org/u/Bryan_Fisher)\ **Post date:** [June 8, 2020, 6:31pm UTC](https://community.learningequality.org/t/after-updating-from-v0-13-2-to-v0-13-3-unable-to-import-content/1564/1 "2020-06-08T18:31:22Z")
Good day, I keep getting an error “Something went wrong” splash screen. Is there some that might have experienced the same issue with Postgresql: The above exception was the direct cause of the following exception: daemon.txt: Traceback (most recent call last): File “/usr/lib/python3/dist-packages/kolibri/core/tasks/worker.py”, line 71, in handle\_finished\_future result = future.result() File “/usr/lib/python3.5/concurrent/futures/\_base.py”, line 398, in result return self.\_\_get\_result() File “/usr/lib/python3.5/concurrent/futures/\_base.py”, line 357, in \_\_get\_result raise self.\_exception File “/usr/lib/python3.5/concurrent/futures/thread.py”, line 55, in run result = self.fn(\*self.args, \*\*self.kwargs) File “/usr/lib/python3/dist-packages/kolibri/core/tasks/worker.py”, line 216, in wrap return f(\*args, \*\*kwargs) File “/usr/lib/python3/dist-packages/kolibri/core/tasks/job.py”, line 178, in y result = func(\*args, \*\*kwargs) File “/usr/lib/python3/dist-packages/kolibri/dist/django/core/management/ **init**.py”, line 131, in call\_command return command.execute(\*args, \*\*defaults) File “/usr/lib/python3/dist-packages/kolibri/dist/django/core/management/base.py”, line 330, in execute output = self.handle(\*args, \*\*options) File “/usr/lib/python3/dist-packages/kolibri/core/tasks/management/commands/base.py”, line 110, in handle return self.handle\_async(\*args, \*\*options) File “/usr/lib/python3/dist-packages/kolibri/core/content/management/commands/importchannel.py”, line 213, in handle\_async options[“channel\_id”], options[“baseurl”], options[“no\_upgrade”] File “/usr/lib/python3/dist-packages/kolibri/core/content/management/commands/importchannel.py”, line 97, in download\_channel self.\_transfer(DOWNLOAD\_METHOD, channel\_id, baseurl, no\_upgrade=no\_upgrade) File “/usr/lib/python3/dist-packages/kolibri/core/content/management/commands/importchannel.py”, line 134, in \_transfer filetransfer, channel\_id, dest, no\_upgrade=no\_upgrade File “/usr/lib/python3/dist-packages/kolibri/core/content/management/commands/importchannel.py”, line 199, in \_start\_file\_transfer retry\_import(e, skip\_404=False) File “/usr/lib/python3/dist-packages/kolibri/core/content/utils/import\_export\_content.py”, line 159, in retry\_import raise e File “/usr/lib/python3/dist-packages/kolibri/core/content/management/commands/importchannel.py”, line 181, in \_start\_file\_transfer channel\_id, self.is\_cancelled File “/usr/lib/python3/dist-packages/kolibri/core/content/management/commands/importchannel.py”, line 30, in import\_channel\_by\_id channel\_id, cancel\_check=cancel\_check File “/usr/lib/python3/dist-packages/kolibri/core/content/utils/channel\_import.py”, line 800, in import\_channel\_from\_local\_db import\_ran = import\_manager.import\_channel\_data() File “/usr/lib/python3/dist-packages/kolibri/core/content/utils/channel\_import.py”, line 622, in import\_channel\_data raise e File “/usr/lib/python3/dist-packages/kolibri/core/content/utils/channel\_import.py”, line 610, in import\_channel\_data model, row\_mapper, table\_mapper, unflushed\_rows File “/usr/lib/python3/dist-packages/kolibri/core/content/utils/channel\_import.py”, line 431, in table\_import model, row\_mapper, table\_mapper, unflushed\_rows File “/usr/lib/python3/dist-packages/kolibri/core/content/utils/channel\_import.py”, line 387, in orm\_table\_import DestinationRecord, data\_to\_insert File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/orm/session.py”, line 2552, in bulk\_insert\_mappings return\_defaults, False, render\_nulls) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/orm/session.py”, line 2625, in \_bulk\_save\_mappings transaction.rollback(\_capture\_exception=True) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/util/langhelpers.py”, line 66, in **exit** compat.reraise(exc\_type, exc\_value, exc\_tb) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/util/compat.py”, line 249, in reraise raise value File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/orm/session.py”, line 2620, in \_bulk\_save\_mappings isstates, return\_defaults, render\_nulls) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/orm/persistence.py”, line 69, in \_bulk\_insert bookkeeping=return\_defaults) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/orm/persistence.py”, line 830, in \_emit\_insert\_statements execute(statement, multiparams) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/engine/base.py”, line 948, in execute return meth(self, multiparams, params) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/sql/elements.py”, line 269, in \_execute\_on\_connection return connection.\_execute\_clauseelement(self, multiparams, params) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/engine/base.py”, line 1060, in \_execute\_clauseelement compiled\_sql, distilled\_params File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/engine/base.py”, line 1200, in \_execute\_context context) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/engine/base.py”, line 1413, in \_handle\_dbapi\_exception exc\_info File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/util/compat.py”, line 265, in raise\_from\_cause reraise(type(exception), exception, tb=exc\_tb, cause=cause) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/util/compat.py”, line 248, in reraise raise value.with\_traceback(tb) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/engine/base.py”, line 1170, in \_execute\_context context) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/dialects/postgresql/psycopg2.py”, line 683, in do\_executemany cursor.executemany(statement, parameters) sqlalchemy.exc.IntegrityError: (psycopg2.IntegrityError) duplicate key value violates unique constraint “content\_contentnode\_pkey” DETAIL: Key (id)=(ad890dd2-5fe6-4101-b13c-abf7cea54a7b) already exists. [SQL: ‘INSERT INTO content\_contentnode (id, license\_name, license\_description, title, coach\_content, content\_id, channel\_id, description, sort\_order, license\_owner, author, kind, available, lft, rght, tree\_id, level, lang\_id, parent\_id) VALUES (%(id)s, %(license\_name)s, %(license\_description)s, %(title)s, %(coach\_content)s, %(content\_id)s, %(channel\_id)s, %(description)s, %(sort\_order)s, %(license\_owner)s, %(author)s, %(kind)s, %(available)s, %(lft)s, %(rght)s, %(tree\_id)s, %(level)s, %(lang\_id)s, %(parent\_id)s)’] [parameters: ({‘channel\_id’: ‘f1bc9f5895c0486992a6ab6e22b5633a’, ‘sort\_order’: 10.5, ‘content\_id’: ‘13a20c08c8764509b5d7ac5b08a3eaac’, ‘title’: ‘Grade 3’, ‘rght’: 205, ‘license\_description’: ‘The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.’, ‘license\_owner’: ‘’, ‘id’: ‘6af47406fa2b454f890a2cb99a53f03c’, ‘parent\_id’: ‘f1bc9f5895c0486992a6ab6e22b5633a’, ‘kind’: ‘topic’, ‘lang\_id’: ‘en’, ‘lft’: 2, ‘available’: False, ‘tree\_id’: 12, ‘description’: ‘’, ‘coach\_content’: False, ‘license\_name’: ‘CC BY’, ‘level’: 1, ‘author’: ‘’}, {‘channel\_id’: ‘f1bc9f5895c0486992a6ab6e22b5633a’, ‘sort\_order’: 21.0, ‘content\_id’: ‘b97141a5b83e4f068f04877729b64ec7’, ‘title’: ‘Grade 6’, ‘rght’: 291, ‘license\_description’: ‘The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.’, ‘license\_owner’: ‘’, ‘id’: ‘738d4e88980740dfa31772f50b1476e6’, ‘parent\_id’: ‘f1bc9f5895c0486992a6ab6e22b5633a’, ‘kind’: ‘topic’, ‘lang\_id’: ‘en’, ‘lft’: 206, ‘available’: False, ‘tree\_id’: 12, ‘description’: ‘’, ‘coach\_content’: False, ‘license\_name’: ‘CC BY’, ‘level’: 1, ‘author’: ‘’}, {‘channel\_id’: ‘f1bc9f5895c0486992a6ab6e22b5633a’, ‘sort\_order’: 21.5, ‘content\_id’: ‘2088ca4320f14f4d81b437aab909a9eb’, ‘title’: ‘Grade 11’, ‘rght’: 303, ‘license\_description’: ‘The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.’, ‘license\_owner’: ‘’, ‘id’: ‘bb0b41ac2ccf4f57b127e521d39746c2’, ‘parent\_id’: ‘f1bc9f5895c0486992a6ab6e22b5633a’, ‘kind’: ‘topic’, ‘lang\_id’: ‘en’, ‘lft’: 292, ‘available’: False, ‘tree\_id’: 12, ‘description’: ‘’, ‘coach\_content’: False, ‘license\_name’: ‘CC BY’, ‘level’: 1, ‘author’: ‘’}, {‘channel\_id’: ‘f1bc9f5895c0486992a6ab6e22b5633a’, ‘sort\_order’: 22.0, ‘content\_id’: ‘a77c8eaeafc4435b81a866fc53156fcb’, ‘title’: ‘Grade 12’, ‘rght’: 1385, ‘license\_description’: ‘The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.’, ‘license\_owner’: ‘’, ‘id’: ‘efcab5fb841046378ff997275db8fce9’, ‘parent\_id’: ‘f1bc9f5895c0486992a6ab6e22b5633a’, ‘kind’: ‘topic’, ‘lang\_id’: ‘en’, ‘lft’: 304, ‘available’: False, ‘tree\_id’: 12, ‘description’: ‘’, ‘coach\_content’: False, ‘license\_name’: ‘CC BY’, ‘level’: 1, ‘author’: ‘’}, {‘channel\_id’: ‘f1bc9f5895c0486992a6ab6e22b5633a’, ‘sort\_order’: 23.0, ‘content\_id’: ‘b88059f1ef744c76abdfaff0899ca034’, ‘title’: ‘Siyavula Textbooks’, ‘rght’: 1447, ‘license\_description’: ‘The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.’, ‘license\_owner’: ‘’, ‘id’: ‘321741a6fe444de586d8f766b5698daf’, ‘parent\_id’: ‘f1bc9f5895c0486992a6ab6e22b5633a’, ‘kind’: ‘topic’, ‘lang\_id’: ‘en’, ‘lft’: 1386, ‘available’: False, ‘tree\_id’: 12, ‘description’: ‘’, ‘coach\_content’: False, ‘license\_name’: ‘CC BY’, ‘level’: 1, ‘author’: ‘’}, {‘channel\_id’: ‘f1bc9f5895c0486992a6ab6e22b5633a’, ‘sort\_order’: 24.0, ‘content\_id’: ‘a2e978a44e6247729b088b4cc90c7eb9’, ‘title’: ‘Exam preparation guides’, ‘rght’: 1453, ‘license\_description’: ‘The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.’, ‘license\_owner’: ‘’, ‘id’: ‘440896acee5848e8b0663506ba377da6’, ‘parent\_id’: ‘f1bc9f5895c0486992a6ab6e22b5633a’, ‘kind’: ‘topic’, ‘lang\_id’: ‘en’, ‘lft’: 1448, ‘available’: False, ‘tree\_id’: 12, ‘description’: ‘How to create good study habits and deal with stress before exams.’, ‘coach\_content’: False, ‘license\_name’: ‘CC BY’, ‘level’: 1, ‘author’: ‘’}, {‘channel\_id’: ‘f1bc9f5895c0486992a6ab6e22b5633a’, ‘sort\_order’: 20.0, ‘content\_id’: ‘33662bd7f42349919a670a4beafa72c9’, ‘title’: ‘Question Papers’, ‘rght’: 112, ‘license\_description’: ‘The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.’, ‘license\_owner’: ‘’, ‘id’: ‘eac1cac89b724db6b95fa8f4a03cdb37’, ‘parent\_id’: ‘6af47406fa2b454f890a2cb99a53f03c’, ‘kind’: ‘topic’, ‘lang\_id’: ‘en’, ‘lft’: 3, ‘available’: False, ‘tree\_id’: 12, ‘description’: ‘’, ‘coach\_content’: False, ‘license\_name’: ‘CC BY’, ‘level’: 2, ‘author’: ‘’}, {‘channel\_id’: ‘f1bc9f5895c0486992a6ab6e22b5633a’, ‘sort\_order’: 21.0, ‘content\_id’: ‘68bbae0784a74a61a9f5943f92826992’, ‘title’: ‘Memoranda’, ‘rght’: 204, ‘license\_description’: ‘The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.’, ‘license\_owner’: ‘’, ‘id’: ‘042dfe05c7e443008b5fb9560b221a5e’, ‘parent\_id’: ‘6af47406fa2b454f890a2cb99a53f03c’, ‘kind’: ‘topic’, ‘lang\_id’: ‘en’, ‘lft’: 113, ‘available’: False, ‘tree\_id’: 12, ‘description’: ‘’, ‘coach\_content’: False, ‘license\_name’: ‘CC BY’, ‘level’: 2, ‘author’: ‘’} … displaying 10 of 726 total bound parameter sets … {‘channel\_id’: ‘f1bc9f5895c0486992a6ab6e22b5633a’, ‘sort\_order’: 22.0, ‘content\_id’: ‘b1377d214eb140d7bb370b23bcc86b0c’, ‘title’: ‘Geography P2 Nov 2016 Questions’, ‘rght’: 813, ‘license\_description’: ‘The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.’, ‘license\_owner’: ‘Dept of Basic Education RSA’, ‘id’: ‘7c4e8c4ef98d4607abcf9ac70c4c025c’, ‘parent\_id’: ‘daed211e5bac499aa0c2768aea5103db’, ‘kind’: ‘document’, ‘lang\_id’: ‘en’, ‘lft’: 812, ‘available’: False, ‘tree\_id’: 12, ‘description’: ‘’, ‘coach\_content’: False, ‘license\_name’: ‘CC BY’, ‘level’: 5, ‘author’: ‘DBE’}, {‘channel\_id’: ‘f1bc9f5895c0486992a6ab6e22b5633a’, ‘sort\_order’: 23.0, ‘content\_id’: ‘714af9b1de974e4c87e7a5f916d846a3’, ‘title’: ‘Geography P2 Nov 2016 Memo’, ‘rght’: 815, ‘license\_description’: ‘The Attribution License lets others distribute, remix, tweak, and build upon your work, even commercially, as long as they credit you for the original creation. This is the most accommodating of licenses offered. Recommended for maximum dissemination and use of licensed materials.’, ‘license\_owner’: ‘Dept of Basic Education RSA’, ‘id’: ‘d192a49c513a4effbce4666696df17fc’, ‘parent\_id’: ‘daed211e5bac499aa0c2768aea5103db’, ‘kind’: ‘document’, ‘lang\_id’: ‘en’, ‘lft’: 814, ‘available’: False, ‘tree\_id’: 12, ‘description’: ‘’, ‘coach\_content’: False, ‘license\_name’: ‘CC BY’, ‘level’: 5, ‘author’: ‘DBE’})] (Background on this error at: [http://sqlalche.me/e/gkpj](http://sqlalche.me/e/gkpj)) e[0m I have stopped kolibri and ran: "kolibri manage dbbackup and got the this error: INFO Initiating shutdown of Kolibri INFO Waiting for Kolibri to finish shutting down INFO Kolibri server has successfully been stopped. kolibri@kolibri:~$ kolibri manage dbbackup INFO Running Kolibri with the following settings: kolibri.deployment.default.settings.base INFO Invoking command dbbackup Traceback (most recent call last): File “/usr/bin/kolibri”, line 9, in load\_entry\_point(‘kolibri==0.13.3’, ‘console\_scripts’, ‘kolibri’)() File “/usr/lib/python3/dist-packages/kolibri/dist/click/core.py”, line 764, in **call** return self.main(\*args, \*\*kwargs) File “/usr/lib/python3/dist-packages/kolibri/dist/click/core.py”, line 717, in main rv = self.invoke(ctx) File “/usr/lib/python3/dist-packages/kolibri/dist/click/core.py”, line 1137, in invoke return \_process\_result(sub\_ctx.command.invoke(sub\_ctx)) File “/usr/lib/python3/dist-packages/kolibri/utils/cli.py”, line 244, in invoke return super(KolibriDjangoCommand, self).invoke(ctx) File “/usr/lib/python3/dist-packages/kolibri/dist/click/core.py”, line 956, in invoke return ctx.invoke(self.callback, \*\*ctx.params) File “/usr/lib/python3/dist-packages/kolibri/dist/click/core.py”, line 555, in invoke return callback(\*args, \*\*kwargs) File “/usr/lib/python3/dist-packages/kolibri/dist/click/decorators.py”, line 17, in new\_func return f(get\_current\_context(), \*args, \*\*kwargs) File “/usr/lib/python3/dist-packages/kolibri/utils/cli.py”, line 655, in manage execute\_from\_command\_line([“kolibri manage”] + ctx.args) File “/usr/lib/python3/dist-packages/kolibri/dist/django/core/management/ **init**.py”, line 364, in execute\_from\_command\_line utility.execute() File “/usr/lib/python3/dist-packages/kolibri/dist/django/core/management/ **init**.py”, line 356, in execute self.fetch\_command(subcommand).run\_from\_argv(self.argv) File “/usr/lib/python3/dist-packages/kolibri/dist/django/core/management/base.py”, line 283, in run\_from\_argv self.execute(\*args, \*\*cmd\_options) File “/usr/lib/python3/dist-packages/kolibri/dist/django/core/management/base.py”, line 330, in execute output = self.handle(\*args, \*\*options) File “/usr/lib/python3/dist-packages/kolibri/core/deviceadmin/management/commands/dbbackup.py”, line 56, in handle backup = dbbackup(kolibri. **version** , dest\_folder=dest\_folder) File “/usr/lib/python3/dist-packages/kolibri/core/deviceadmin/utils.py”, line 89, in dbbackup raise IncompatibleDatabase() kolibri.core.deviceadmin.utils.IncompatibleDatabase kolibri@kolibri:~$ sudo nano .kolibri/logs/daemon.txt [sudo] password for kolibri: kolibri@kolibri:~$ kolibri manage dbbackup INFO Running Kolibri with the following settings: kolibri.deployment.default.settings.base INFO Invoking command dbbackup Traceback (most recent call last): File “/usr/bin/kolibri”, line 9, in load\_entry\_point(‘kolibri==0.13.3’, ‘console\_scripts’, ‘kolibri’)() File “/usr/lib/python3/dist-packages/kolibri/dist/click/core.py”, line 764, in **call** return self.main(\*args, \*\*kwargs) File “/usr/lib/python3/dist-packages/kolibri/dist/click/core.py”, line 717, in main rv = self.invoke(ctx) File “/usr/lib/python3/dist-packages/kolibri/dist/click/core.py”, line 1137, in invoke return \_process\_result(sub\_ctx.command.invoke(sub\_ctx)) File “/usr/lib/python3/dist-packages/kolibri/utils/cli.py”, line 244, in invoke return super(KolibriDjangoCommand, self).invoke(ctx) File “/usr/lib/python3/dist-packages/kolibri/dist/click/core.py”, line 956, in invoke return ctx.invoke(self.callback, \*\*ctx.params) File “/usr/lib/python3/dist-packages/kolibri/dist/click/core.py”, line 555, in invoke return callback(\*args, \*\*kwargs) File “/usr/lib/python3/dist-packages/kolibri/dist/click/decorators.py”, line 17, in new\_func return f(get\_current\_context(), \*args, \*\*kwargs) File “/usr/lib/python3/dist-packages/kolibri/utils/cli.py”, line 655, in manage execute\_from\_command\_line([“kolibri manage”] + ctx.args) File “/usr/lib/python3/dist-packages/kolibri/dist/django/core/management/ **init**.py”, line 364, in execute\_from\_command\_line utility.execute() File “/usr/lib/python3/dist-packages/kolibri/dist/django/core/management/ **init**.py”, line 356, in execute self.fetch\_command(subcommand).run\_from\_argv(self.argv) File “/usr/lib/python3/dist-packages/kolibri/dist/django/core/management/base.py”, line 283, in run\_from\_argv self.execute(\*args, \*\*cmd\_options) File “/usr/lib/python3/dist-packages/kolibri/dist/django/core/management/base.py”, line 330, in execute output = self.handle(\*args, \*\*options) File “/usr/lib/python3/dist-packages/kolibri/core/deviceadmin/management/commands/dbbackup.py”, line 56, in handle backup = dbbackup(kolibri. **version** , dest\_folder=dest\_folder) File “/usr/lib/python3/dist-packages/kolibri/core/deviceadmin/utils.py”, line 89, in dbbackup raise IncompatibleDatabase() kolibri.core.deviceadmin.utils.IncompatibleDatabase Please let me know if there is a fix for this. Thanks so much. OS: Ubuntu 16.04 Kolibri version: v0.13.3 Kolibri-Sever: v.0.3.6 DB: Postgresl ---
**Author:** ![Bryan\_Fisher](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.learningequality.org/bryan_fisher/32/160_2.png) [@Bryan\_Fisher](https://community.learningequality.org/u/Bryan_Fisher)\ **Post date:** [June 8, 2020, 7:11pm UTC](https://community.learningequality.org/t/after-updating-from-v0-13-2-to-v0-13-3-unable-to-import-content/1564/2 "2020-06-08T19:11:50Z")
Good day, I have “Disconnected” the Postgresql DB. rebooted the server. stopped kolibri and ran command: kolibri manage migrate. Everything went “ok”. rebooted the server again but kolibri status indicated"“stopped(1)” And this is the error I’m experiencing: daemon.txt: ^[[37mINFO Starting Kolibri 0.13.3^[[0m ^[[37mINFO ENGINE Listening for SIGTERM.^[[0m ^[[37mINFO ENGINE Listening for SIGINT.^[[0m ^[[37mINFO ENGINE Listening for SIGHUP.^[[0m ^[[37mINFO ENGINE Listening for SIGUSR1.^[[0m ^[[37mINFO ENGINE Bus STARTING^[[0m ^[[31mERROR ENGINE Error in ‘start’ listener \\> Traceback (most recent call last): File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/engine/base.py”, line 1193, in \_execute\_context context) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/engine/default.py”, line 509, in do\_execute cursor.execute(statement, parameters) sqlite3.OperationalError: no such column: jobs.queue The above exception was the direct cause of the following exception: Traceback (most recent call last): File “/usr/lib/python3/dist-packages/kolibri/dist/cherrypy/process/wspbus.py”, line 230, in publish output.append(listener(\*args, \*\*kwargs)) File “/usr/lib/python3/dist-packages/kolibri/utils/server.py”, line 99, in start queue.empty() File “/usr/lib/python3/dist-packages/kolibri/core/tasks/queue.py”, line 97, in empty self.storage.clear(force=True, queue=self.name) File “/usr/lib/python3/dist-packages/kolibri/core/tasks/storage.py”, line 210, in clear q.delete(synchronize\_session=False) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/orm/query.py”, line 3346, in delete delete\_op.exec\_() File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/orm/persistence.py”, line 1326, in exec\_ self.\_do\_exec() File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/orm/persistence.py”, line 1518, in \_do\_exec self.\_execute\_stmt(delete\_stmt) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/orm/persistence.py”, line 1333, in \_execute\_stmt mapper=self.mapper) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/orm/session.py”, line 1176, in execute bind, close\_with\_result=True).execute(clause, params or {}) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/engine/base.py”, line 948, in execute return meth(self, multiparams, params) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/sql/elements.py”, line 269, in \_execute\_on\_connection return connection.\_execute\_clauseelement(self, multiparams, params) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/engine/base.py”, line 1060, in \_execute\_clauseelement compiled\_sql, distilled\_params File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/engine/base.py”, line 1200, in \_execute\_context context) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/engine/base.py”, line 1413, in \_handle\_dbapi\_exception exc\_info File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/util/compat.py”, line 265, in raise\_from\_cause reraise(type(exception), exception, tb=exc\_tb, cause=cause) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/util/compat.py”, line 248, in reraise raise value.with\_traceback(tb) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/engine/base.py”, line 1193, in \_execute\_context context) File “/usr/lib/python3/dist-packages/kolibri/dist/sqlalchemy/engine/default.py”, line 509, in do\_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) no such column: jobs.queue [parameters: (‘kolibri’,)] (Background on this error at: [http://sqlalche.me/e/e3q8](http://sqlalche.me/e/e3q8)) ^[[0m ^[[37mINFO ENGINE Serving on http://0.0.0.0:8080^[[0m ^[[31mERROR ENGINE Shutting down due to error in start listener: Traceback (most recent call last): File “/usr/lib/python3/dist-packages/kolibri/dist/cherrypy/process/wspbus.py”, line 268, in start self.publish(‘start’) File “/usr/lib/python3/dist-packages/kolibri/dist/cherrypy/process/wspbus.py”, line 248, in publish raise exc cherrypy.process.wspbus.ChannelFailures: OperationalError(’(sqlite3.OperationalError) no such column: jobs.queue’,) ^[[0m ^[[37mINFO ENGINE Bus STOPPING^[[0m ^[[37mINFO ENGINE HTTP Server cherrypy.\_cpwsgi\_server.CPWSGIServer((‘0.0.0.0’, 8080)) shut down^[[0m ^[[37mINFO ENGINE Bus STOPPED^[[0m ^[[37mINFO ENGINE Bus EXITING^[[0m ^[[37mINFO ENGINE Bus EXITED^[[0m not sure what i did wrong ☹ OS: Ubuntu 16.04 Kolibri version: v0.13.3 Kolibri-Sever: v.0.3.6 **DB: SQLite** ---
**Author:** ![Bryan\_Fisher](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.learningequality.org/bryan_fisher/32/160_2.png) [@Bryan\_Fisher](https://community.learningequality.org/u/Bryan_Fisher)\ **Post date:** [June 8, 2020, 9:24pm UTC](https://community.learningequality.org/t/after-updating-from-v0-13-2-to-v0-13-3-unable-to-import-content/1564/3 "2020-06-08T21:24:44Z")
Solution: Behavior: command: kolibri start output: INFO Kolibri running on: ``` http://172.18.0.2:8080/ http://127.0.0.1:8080/ ``` Checking the status: kolibri status Stopped (1) In the web browser: Web page not available. Login page does not come up. In stalled sqlite3; backed the DB, checked the integrity = “ok” Then followed these steps: sudo rm -R .kolibri/.data\_version (even though i did this during the first attempts to get it working, but did not work at the time) kolibri start completed all migrations successfully. Working again! Importing content in progress! Database: SQLite3 OS Ubuntu 16.04 Kolibri: v0.13.3 Kolibri-server: v0.3.6 I will test again with PostgreSQL some other time, i’m just glad i can continue to update this server! 🙂 ---
**Author:** ![cjackson](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.learningequality.org/cjackson/32/240_2.png) [@cjackson](https://community.learningequality.org/u/cjackson)\ **Post date:** [June 17, 2020, 8:12am UTC](https://community.learningequality.org/t/after-updating-from-v0-13-2-to-v0-13-3-unable-to-import-content/1564/4 "2020-06-17T08:12:17Z")
@Bryan_Fisher, @Ivan: I’m having the same problem! Happy (kind of) to know it is not just me. When I try to import content, I’m getting an error after I cancel from a hung process at the “Generating channel listing. This could take a few minutes” step to import. It just never generates a channel listing. Upon canceling, Kolibri goes to an error alert with the following: TypeError: An id must be specified My system: Version: 0.13.3 OS: Linux-4.19.69-v7±armv7l-with-debian-9.11 Python: 3.5.3 Installer: kolibri(apt) with kolibri-server Version: 0.3.8~beta2-0ubuntu1 Server: nginx/1.10.3 Database: /home/pi/.kolibri/db.sqlite3 Device name: raspberrypi Free disk space: 50 GB Server time: Wed Jun 17 2020 09:07:45 GMT+0100 (WAT) Server timezone: Africa/Douala Strangely, the device profile shows version 0.13.3, but the web interface shows 0.13.2. Start up of Kolibri produces the following errors: INFO Running Kolibri with the following settings: kolibri.deployment.default.settings.base Traceback (most recent call last): File “/usr/bin/kolibri”, line 9, in load\_entry\_point(‘kolibri==0.13.3’, ‘console\_scripts’, ‘kolibri’)() File “/usr/lib/python3/dist-packages/kolibri/dist/click/core.py”, line 764, in **call** return self.main(\*args, \*\*kwargs) File “/usr/lib/python3/dist-packages/kolibri/dist/click/core.py”, line 717, in main rv = self.invoke(ctx) File “/usr/lib/python3/dist-packages/kolibri/dist/click/core.py”, line 1137, in invoke return \_process\_result(sub\_ctx.command.invoke(sub\_ctx)) File “/usr/lib/python3/dist-packages/kolibri/utils/cli.py”, line 238, in invoke initialize() File “/usr/lib/python3/dist-packages/kolibri/utils/cli.py”, line 316, in initialize backup = dbbackup(version) File “/usr/lib/python3/dist-packages/kolibri/core/deviceadmin/utils.py”, line 111, in dbbackup for line in db.connections[“default”].connection.iterdump(): File “/usr/lib/python3.5/sqlite3/dump.py”, line 56, in \_iterdump for row in query\_res: sqlite3.OperationalError: Could not decode to UTF-8 column ‘‘INSERT INTO “logger\_attemptlog” VALUES(’||quote(“id”)||’,’||quote("\_morango\_dirty\_bit")||’,’||quote("\_morango\_source\_id")||’,’||quote("\_morango\_partition")||’,’||q However, it is running and accessible with the currently loaded content. Yet, one other point of strangeness is when running ‘kolibri status’ in the CLI, the following is the output. **pi@raspberrypi** : **~ $** kolibri status WARNING:root:No C Extensions available for this platform. Stopped (1) ---
**Author:** ![Bryan\_Fisher](https://yyz1.discourse-cdn.com/flex035/user_avatar/community.learningequality.org/bryan_fisher/32/160_2.png) [@Bryan\_Fisher](https://community.learningequality.org/u/Bryan_Fisher)\ **Post date:** [August 11, 2020, 10:32am UTC](https://community.learningequality.org/t/after-updating-from-v0-13-2-to-v0-13-3-unable-to-import-content/1564/5 "2020-08-11T10:32:56Z")
Hi @cjackson, Thank you for yourfeedback, much appreciated. Have you managed to overcome the importing issue yet?