Problem when uploading vulnerabilities

Community Edition
1

When I upload the burpsuite: I am getting the error:
There was a fatal error processing your upload:
SQLite3::ConstraintException: NOT NULL constraint failed: versions.item_id

Also when adding the Vulnerability manually, the error was popping up:

image
image1822×953 70.4 KB

2

Hi there! What sort of Dradis deployment is this, and which version? Which Burp file type is this (XML or HTML)? Do you get this for all new issues you create, or only this issue specifically?

3

Hi Christoffer,

I deployed the docker deployment and the version is “Dradis Community Edition v4.16.0“.

The uploaded file was burpsuite HTML file.

Yes whenever I am trying to upload the any issues manually(by pressing the ‘+’ on the top right corner of the issues page), it redirects to the error page.

let me know if you need any further details

4

Hi @swaroop ! Based on the error, it either seems that your instance is creating a version record with an empty item_id or the broken version record already exists.

To check, can you connect to your instance and run the following commands:

$ rails c
> PaperTrail::Version.where(item_id: nil)

Also, sharing the dradis logs around when you get the error will also help!

5

Hi aapomm,

the following is images of the command’s outputs:

image
image1920×297 26.1 KB

image
image1299×141 12.3 KB

Also, where can i get the log file?

6

@swaroop how did you install ruby? You’ll need to change your ruby version to 3.1.2 using something like rbenv: Setting up a Ruby environment for Dradis | Dradis Framework

Once that is resolved, you’ll need to run rails c as a separate command. Once you’re in the rails console, then run PaperTrail::Version.where(item_id: nil). We’ll get this resolved!

7

Hi, so i have uninstalled the docker and tried running the git version. So after some debugging I was able to run the command.

image
image1463×169 10.8 KB

8

Hi Team, so what’s the next step?

9

Hi @swaroop just to clarify, after setting up the git version of Dradis, you’re still getting the SQLite3::ConstraintException: NOT NULLerror, correct?

Apologies as we can’t seem to replicate the issue you’re seeing so more information would be helpful:

10

Hi all, so I have uninstalled and installed the Dradis again and notice the ruby version needed is 3.4.4 and not 3.1.2 (since the dependency issues) so by updating the ruby version locally using the rbenv solved the issue to an extent.
once again @aapomm, @Christoffer, @rachkor I thank you for your support.