PatrickRQ Posted October 31, 2022 Posted October 31, 2022 (edited) Hello, Recently I was cleaning up my custom customer fields and ended up with following issue under > System Info > Database: However, I do not have a custom field of ID 1, just 11, 15 and 16. Why system expects column to be added for field _1? can you point me where the info may be stored? My custom fields table looks as follows: and structure of nexus_customers Edited October 31, 2022 by PatrickRQ SeNioR- 1
Marc Posted October 31, 2022 Posted October 31, 2022 Before we continue, please could you clarify exactly what you were doing here? 37 minutes ago, PatrickRQ said: Recently I was cleaning up my custom customer fields
PatrickRQ Posted October 31, 2022 Author Posted October 31, 2022 I deleted few unused fields and duplicated one of them - not sure if you recall, I reported an issue around the case.
Jim M Posted October 31, 2022 Posted October 31, 2022 2 hours ago, PatrickRQ said: I deleted few unused fields and duplicated one of them - not sure if you recall, I reported an issue around the case. While I look at this, can I confirm the deletion was done via the software and not directly to the database?
PatrickRQ Posted October 31, 2022 Author Posted October 31, 2022 (edited) Yes, via software. I am wondering where it takes info from it needs field_1 column. Edited October 31, 2022 by PatrickRQ
Jim M Posted October 31, 2022 Posted October 31, 2022 We would need to look further into this for you, however the access details on file appear to be incorrect or missing. Could you please update these details by visiting your client area, selecting the relevant purchase, then clicking "Review/Update Access Information" under the "Stored Access Information" section. We look forward to further assisting you.
PatrickRQ Posted October 31, 2022 Author Posted October 31, 2022 Accessing my community is always problematic due to number of factors. By any chance you could point me out of what to check?
Marc Posted October 31, 2022 Posted October 31, 2022 I can tag our developers to see if anyone can point you in the right direction, but unfortutely this is not something I would be able to advise on personally. PatrickRQ 1
teraßyte Posted October 31, 2022 Posted October 31, 2022 (edited) The problem is that the custom field (with ID 1) is included in the nexus_customer table schema in \applications\nexus\data\schema.json. Once you delete the custom field the database checker marks it as a missing column. The code should be changed to add the field inside the installOther function in the Application.php file instead. Edited October 31, 2022 by teraßyte PatrickRQ 1
Recommended Posts