MartinLawrence Posted March 30, 2022 Share 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 Link to comment Share on other sites More sharing options...
Solution Marc Stridgen Posted March 31, 2022 Solution Share 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? Link to comment Share on other sites More sharing options...
MartinLawrence Posted March 31, 2022 Author Share 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. Link to comment Share on other sites More sharing options...
Marc Stridgen Posted April 1, 2022 Share 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 Link to comment Share on other sites More sharing options...
MartinLawrence Posted April 11, 2022 Author Share 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 Stridgen 1 Link to comment Share on other sites More sharing options...
MartinLawrence Posted April 18, 2022 Author Share 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. 💫 Link to comment Share on other sites More sharing options...
Marc Stridgen Posted April 18, 2022 Share 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. Link to comment Share on other sites More sharing options...
.thumb.png.72c24494603afd7a572d55d4a71e4af2.png)
Recommended Posts