Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Elon Report Posted March 30, 2022 Posted March 30, 2022 I am inserting one column into a custom database, leaving all other columns to default. They are in the database, but they are not showing in my page with the database attached. I'm sure there are some columns I need to change. Thanks! Martin
Solution Marc Posted March 31, 2022 Solution Posted March 31, 2022 We are unable to assist with changes directly in the database unfortunately. Is there a reason you are not using the interface to do this?
Elon Report Posted March 31, 2022 Author Posted March 31, 2022 12 hours ago, Marc Stridgen said: Is there a reason you are not using the interface to do this? Not sure what you mean. I created the database and fields with the interface. I have a log file I want to show on my forum. My code writes the log files to the database directly. 12 hours ago, Marc Stridgen said: We are unable to assist with changes directly in the database unfortunately. I will look into other methods to import the data directly then. Thank you.
Marc Posted April 1, 2022 Posted April 1, 2022 No problem. I would suggest using a separate table for your logs, and referencing the main table. It saves you then causing issues with the main database, which will likely correct "issues" each upgrade, and could well wipe your data on columns added manually
Elon Report Posted April 11, 2022 Author Posted April 11, 2022 On 4/1/2022 at 1:56 AM, Marc Stridgen said: No problem. I would suggest using a separate table for your logs, and referencing the main table. It saves you then causing issues with the main database, which will likely correct "issues" each upgrade, and could well wipe your data on columns added manually I create a custom database and the needed columns from the interface. I do not modify the table or column definitions - just read and write records. The log itself is the data for the table. Learning a lot... thanks. Marc 1
Elon Report Posted April 18, 2022 Author Posted April 18, 2022 Thought I would update in case anyone found this thread via a similar problem. Under System, Site Features I discovered the API, which will allow me to add records to the database without accessing it directly. 💫
Marc Posted April 18, 2022 Posted April 18, 2022 3 hours ago, MartinLawrence said: Thought I would update in case anyone found this thread via a similar problem. Under System, Site Features I discovered the API, which will allow me to add records to the database without accessing it directly. 💫 Ah, that would have been the answer to the question of why you were needing to add things directly. You were trying to add records 🙂 Glad you have what you need there.
Recommended Posts