AnsweredAssumed Answered

How to repair illegal file reference on documents (6.5.20 CE)

Question asked by Martin Wijnands on Feb 14, 2018

Sometime ago I created a document. (Could be on previous version due to automatic updates) 

 

When I click the document, it gives an error:

Called URL looks like this:

http://systhema.xs4all.nl/Sugar/index.php?entryPoint=download&id=9142631a-7008-fd26-4aa1-582b91594c78&type=Documents

When I query this on the database(

SELECT * FROM `documents` WHERE `id` = '9142631a-7008-fd26-4aa1-582b91594c78'), it gives 0 rows result which is consistent with the error.

 

But when I query this on the database using not the Id field but the document_revision_id it gives me the correct database entry. (Query used: SELECT * FROM `documents` WHERE `document_revision_id` = '9142631a-7008-fd26-4aa1-582b91594c78')

 

So somewhere down the line the Id and Revison_Id on the Tabel Documents is ****** up..........how to repair, none of our documents are accessable now!

Outcomes