Cannot view private files after updating to version 13 from version 12 (frappe.exceptions.DuplicateEntryError)

ERPNext
2

I solve this problem this way for anyone who is having the same trouble.

The issue is similar laid out by this post: Print Preview Error {{body}} - #11 by brian_pond.

This involves the current value in tabSeries and the current value of the blank entry in the same table.

This is the code I used to solve my problem. I logged into my database as root and ran these command.

SELECT name, current FROM tabSeries WHERE name like ‘AL%’
±-----±--------+
| name | current |
±-----±--------+
| AL- | 2127 |
±-----±--------+

select name, current from tabSeries;

±---------------±--------+
| name | current |
±---------------±--------+
| | 1228 |
| ACC-ASS-2020- | 6 |

SELECT name, current FROM {erpnext_database_name}.tabSeries WHERE name= ’ ';

update {erpnext_database_name}.tabSeries set current = 2128 where name= ’ ';

After updating the blank field value to higher than that of the AL series, everything now works fine.