Introducing Quests: Tailored gamification & bridging in-person events with your community Mike Gitkos Yesterday at 12:39 PM1 day
Posted June 8, 20241 yr Although other end points are working, this end point does not: https://www.xxxxxxx.com/community/api/downloads/categories?key=xxxxxxxxxxxxxxxxxxxx This is the result: { "errorCode": "EX0", "errorMessage": "UNKNOWN_ERROR" } Permissions for the end point for this key are enabled. All other end points I have tested worked as expected, including downloads/categories/{id} Invision Community v4.7.5 Edited June 8, 20241 yr by Interferon
April 3Apr 3 Author On 6/8/2024 at 6:18 PM, Daniel F said:Do you see any logged errors in your system log? Yes!UnderflowException::0lang_not_exists__downloads_category_29What does this mean? 😵
April 3Apr 3 That’s caused by an orphaned file. Given how old the issue is, I’m not sure why and how it happened at all. You should be able to fix this by replacing the category in your DB with a valid one.
April 3Apr 3 Author 4 hours ago, Daniel F said:You should be able to fix this by replacing the category in your DB with a valid one.This sounds like an IPS tech support job, right? I have updated my access information in the client area. You may make the necessary fix for this. Edited April 3Apr 3 by Interferon
April 4Apr 4 Author On 4/3/2025 at 2:40 AM, Daniel F said:That’s caused by an orphaned file. Given how old the issue is, I’m not sure why and how it happened at all. You should be able to fix this by replacing the category in your DB with a valid one.I do not understand what this means. What should my next step be?
April 7Apr 7 On 4/4/2025 at 10:40 PM, Interferon said:I do not understand what this means. What should my next step be?Run this query to identify the broken records which have an invalid category. select * from downloads_files where file_cat not in ( select cid from downloads_categories )Then replace the not existing category value in the file_cat column with the ID of an existing category