Hello is there any way to reset the fid orders ascending according to my forums ordered as now or i have to edit the database and do it one by one manually ?
No, and don’t try and do it manually either. Those IDs will be referenced in several places in other tables. There’s no point trying to have sequential IDs, it’s just a meaningless auto-incrementing row identifier to relate to data in other tables.