# Export Error : no such column: project\_id

**URL:** <https://community.vikunja.io/t/export-error-no-such-column-project-id/2227>\
**Category:** Bug\
**Created:** [4 April 2024 15:18 UTC](https://community.vikunja.io/t/export-error-no-such-column-project-id/2227 "2024-04-04T15:18:51Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ehvox](https://community.vikunja.io/letter_avatar_proxy/v4/letter/e/f475e1/32.png) [@Ehvox](https://community.vikunja.io/u/Ehvox)\
**Post date:** [4 April 2024 15:18 UTC](https://community.vikunja.io/t/export-error-no-such-column-project-id/2227/1 "2024-04-04T15:18:51Z")

</div>

Recently, I upgraded to the unstable version as I needed to import projects from Trello.  
However, upon attempting to perform an export, I encountered the following error messages:

==\> events.log \<==  
2024-04-04T16:46:46.108924467+02:00: ERROR ▶ [EVENTS] 19c4 Error occurred, retrying: no such column: project\_id, elapsed\_time=5.534030461s, retry\_no=5, max\_retries=5, wait\_time=3.051158905s

==\> standard.log \<==  
2024-04-04T16:46:46.111589336+02:00: ERROR ▶ events/func1 19ca Error while handling message 22e18c07-5fef-44fa-931e-0b7af3bd1b42, topic\_poisoned=user.export.requested, handler\_poisoned=user.export.requested.handle.user.data.export, subscriber\_poisoned=gochannel.GoChannel, reason\_poisoned=no such column: project\_id, payload={“user”:{“id”:1,“name”:“”,“username”:“ehvox”,“created”:“2024-04-04T14:34:43Z”,“updated”:“2024-04-04T14:42:01Z”}}

---

<div class="post-metadata">

**Author:** ![kolaente](https://community.vikunja.io/user_avatar/community.vikunja.io/kolaente/32/5_2.png) [@kolaente](https://community.vikunja.io/u/kolaente)\
**Post date:** [4 April 2024 16:07 UTC](https://community.vikunja.io/t/export-error-no-such-column-project-id/2227/2 "2024-04-04T16:07:42Z")

</div>

Which exact version is that? (In the frontend, click on your avatar top right, then “About”)

---

<div class="post-metadata">

**Author:** ![Ehvox](https://community.vikunja.io/letter_avatar_proxy/v4/letter/e/f475e1/32.png) [@Ehvox](https://community.vikunja.io/u/Ehvox)\
**Post date:** [5 April 2024 07:05 UTC](https://community.vikunja.io/t/export-error-no-such-column-project-id/2227/3 "2024-04-05T07:05:50Z")

</div>

Hey, sorry for the late answer, I was no longer in front of the machine.  
Im on the Version: v0.23.0+438-f0d695e789 running on Debian GNU/Linux 12 (bookworm)

---

<div class="post-metadata">

**Author:** ![Ehvox](https://community.vikunja.io/letter_avatar_proxy/v4/letter/e/f475e1/32.png) [@Ehvox](https://community.vikunja.io/u/Ehvox)\
**Post date:** [5 April 2024 08:25 UTC](https://community.vikunja.io/t/export-error-no-such-column-project-id/2227/4 "2024-04-05T08:25:07Z")

</div>

After examining it for a while, it seems that some columns in the database have been renamed from the v0.23.0 to the v0.23.0+438-f0d695e789 . Perhaps the export is attempting to reference ‘project\_id’ while it has been renamed to ‘project\_view\_id’.

 ![image](https://community.vikunja.io/uploads/default/original/2X/1/1ec853b7d6550ad71e92badeee0976736b042d01.png)

UPDATE: I manually added a ‘project\_id’ column to the database in the ‘buckets’ table, and the export worked correctly. And I was able to reimport it afterward.

---

<div class="post-metadata">

**Author:** ![kolaente](https://community.vikunja.io/user_avatar/community.vikunja.io/kolaente/32/5_2.png) [@kolaente](https://community.vikunja.io/u/kolaente)\
**Post date:** [6 April 2024 12:09 UTC](https://community.vikunja.io/t/export-error-no-such-column-project-id/2227/5 "2024-04-06T12:09:30Z")

</div>

> [@Ehvox](#):
>
> UPDATE: I manually added a ‘project\_id’ column to the database in the ‘buckets’ table, and the export worked correctly. And I was able to reimport it afterward.

Did the reimport contain all data?

---

<div class="post-metadata">

**Author:** ![Ehvox](https://community.vikunja.io/letter_avatar_proxy/v4/letter/e/f475e1/32.png) [@Ehvox](https://community.vikunja.io/u/Ehvox)\
**Post date:** [8 April 2024 06:27 UTC](https://community.vikunja.io/t/export-error-no-such-column-project-id/2227/6 "2024-04-08T06:27:57Z")

</div>

yes, it seems like it, the project is quite big and nothing seems to have changed.

---

<div class="post-metadata">

**Author:** ![kolaente](https://community.vikunja.io/user_avatar/community.vikunja.io/kolaente/32/5_2.png) [@kolaente](https://community.vikunja.io/u/kolaente)\
**Post date:** [13 April 2024 19:32 UTC](https://community.vikunja.io/t/export-error-no-such-column-project-id/2227/7 "2024-04-13T19:32:00Z")

</div>

This is now fixed in [ce1d7778c7](https://kolaente.dev/vikunja/vikunja/commit/ce1d7778c708778e541c57bacdd331336875180e), please check with the next unstable build (should be ready for deployment in ~45min, also on [try](https://try.vikunja.io)).

---

<div class="post-metadata">

**Author:** ![Ehvox](https://community.vikunja.io/letter_avatar_proxy/v4/letter/e/f475e1/32.png) [@Ehvox](https://community.vikunja.io/u/Ehvox)\
**Post date:** [15 April 2024 15:06 UTC](https://community.vikunja.io/t/export-error-no-such-column-project-id/2227/8 "2024-04-15T15:06:49Z")

</div>

Thanks a lot for the fix! Best of luck with the rest of the development.