Jump to content

Does anyone have a schema for the custom databases?


Go to solution Solved by Marc,

Recommended Posts

Posted

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
Posted

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?

Posted
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.

Posted

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

  • 2 weeks later...
Posted
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.

Posted

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.  

💫

Posted
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.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...