Course Database Table

[Sourn Rose]

Oneof the users gets this error immediately after clicking on Dashboard but the behavior for the other user is a bit different. That user is able to view the first page of the dashboard but when attempting to view the second page of courses, the same "cannot find record in database table course" message displays. I turned on debugging and display errors but nothing aside from that message is displayed.

I initially though this might be related to the "reminder" local plugin as I do get errors about a deprecated toursecatlib.php file on the screen prior to when Dashboard is clicked but deleting the "reminder" plugin and removing all contents from the server did not rectify the situation.

Also, several of the courses this user (a teacher) is enrolled in are invisible. When the user moves their mouse over "My Courses" only the visible courses are displayed but all courses are displayed in the My Courses side bar on the left of the page in the Boost and Boost Campus themes. This is odd behavior that is seemingly pointing me in the direction of the issue but I can't figure it out.

Now each of these topics will have lecture notes associated with them. Now the way I'm thinking is incase of Chapter 1 - "Introduction" - the notes are going to be associated with the topic "Basic Accounts". But in chapter 2 - "Income Statement" wont have any notes but "Depreciation" is going to have notes. Now since Chapter 3 "Career as Accountant" does not have any sub topics - the notes are going to be associated directly with it.

2) Secondly - given this data structure - if I wanted to pull all topics for a given course and display them in the chapter -> topic -> sub topic tree structure format. How would I do that. Should I just pull out all topics based on the course id and then in server side store them in data structures and organize them according to chapter/topic/subtopic wise or is there a cleaner way of doing it using sub queries.

Should I have another column that maintains the order like 1,2,3 and then if I want to insert something in between chapters 1 and 2 - insert it with a value 1.1 or something like that - can the same column be used for topics as well.

Your 2nd question is very interesting... It can be done using a recursive join.ie you can use a CTE(Common table expression) to recursively join the table to itself. While displaying it just use a level field denoting which level in the hierarchy it is in and order it something like

Just search for hierarchical data in sql...Since u use mysql and if you think u want to go for adjacency list or nested list here's an analysis. -list-vs-nested-sets-mysql/and also.... look at this question it explains a lot ->What are the options for storing hierarchical data in a relational database?

The design that you're using is known as the "linked list" model or "adjacency list" model. There are definitely some big drawbacks to it, such as the requirement to use recursion for a lot of queries.

Another option is to use the "nested sets" model. A Google search for "joe celko nested sets" should yield some articles on the subject. You can also read his book on the entire subject of modeling trees and hierarchies in relational data models. This method also has some drawbacks (updates, inserts, and deletes can be more complex).

I'd add a section_designator field to your Topics table. If it's a chapter, you can call it "Chapter 3". If you have a section in that chapter, you can call it "Section 4" in that topic, and then concatenate the section_designators from that and all of its parents to get the full hierarchy ("Chapter 3 Section 4").

You can do all of this with just one table for Chapters and Topics. You need 2 fields, order which simply keeps track of the ordering of the items and level which is how many levels of indentation you need.

The downside is you don't have any reference data around which topics belong to which other topics. But that information is computable. Also, you need to manage the order field whenever you modify a row.

My Moodle 3.8.2 is hosted on Bluehost (shared hosting plan). It was working fine until yesterday, then all of a sudden it has stopped working and all I see is the error above. Any suggestion? Have I missed anything?

Upload it to the root folder of your Moodle site (the same folder that contains files called config.php and pluginfile.php) then visit the URL .../fixup.php with your web browser. Hopefully, it will work, but I have to say this is just my best guess. It might be a good idea to set Debugging to developer level before running the script. Please take the moodle website folder backup.

I had this issue like 4 times, i've always fixed it by going to phpmyadmin and inserting a new category in mdl_course_categories, adding the id by hand(make sure is not created yet). Sometimes worked sometimes no so i tried with various id not created. Today i figured out(i guess) that my problems were happening because i had two moodles with the same moodledata directory so i think the files in this directory just overlap with the other moodle. In my case one moodle had the category_id 1 the other no (the moodle with the error) and adding a category with this id fixed the problem. so I deleted the new moodle that generate the error in the old one and installed with different moodledata directory. Im not an expert at all, im starting with this platform so ill apprecciate if someone correct me if im wrong.

Moodle implementations normally should have their own code, their own data directory, and their own database. With one data directory (in your case), caches were involved in your setup and the DB direct edits/additions were really a 'rabbit hole'.

No, I had different DB with completely different name and users. The only thing that was sharing was moodledata, beacause by default the web installer select moodledata outside of the directory and both moodles were at the same herarchy (if it make sense(?)). I created a moodledata2 outside of my directory of the moodle (for secure purpose).

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

I already took some SQL course and SQL server, now I know who to create a database, but I don't know who to export my data to a webpage? the available courses teach you who to create a database and how to manage the server, but I don't see courses teach you who to export your data from any table into a html page.

Will give you some great instruction on how to integrate databases with Python and web pages. There are likely Python specific prerequisites for some or most of those courses, but by the time you are done with them and the specific ones I listed you should have a good grasp on how everything works together.

Here on Treehouse your back-end language options would be things like Java, JavaScript, PHP, Python, Ruby, etc. Depending on which one(s) you know/what to learn will help to direct you towards the most appropriate track/courses as all of those languages may be used to obtain data from a SQL database and pass it onto a web server in some fashion.

Many thanks Ken. the Python language is on of my development study plan, but I did not start this language yet. I have good knowledge in javascript language. so what do you suggest? to start with python or js? and when I study python, then will I be able to display the sql query into the html?

Access the searchable CEP database at the button below to see if a specific course is transferable to another Oklahoma college or university. The database covers the academic years 2015-16 to current. Course equivalencies are determined by the academic year in which the course was finished or appeared on the transcript.

This site offers information about Oklahoma's 25 public colleges and universities, the benefits of higher education, college preparation, student financial aid, business support services, and other resources for students, parents, educators, employers and community partners.

All LearnDash data is stored within the same database used to run WordPress. LearnDash does not store or connect to any external data sources to retrieve or store data about users, courses, quizzes, etc.

The process for populating these tables works in addition to the existing course and quiz progress. This means that when a user completes a lesson, the first part of the transaction will update the existing user meta array item. Afterwards, a secondary step will update the activity database tables. Please note that in future versions of LearnDash we will remove the dependence on the user meta array completely.

I am currently working through the Build A Periodic Table course and am trying to get a green check by the " Your properties table should have a type_id foreign key column that references the type_id column from the types table. It should be an INT with the NOT NULL constraint"

This diagram details the shared rows in the reporting database tables. The relationship between the tables is used to define and return customized data reports. For example, the INTERNAL_HANDLE can be used to link the ACTIVITY_ACCUMULATOR table, the NAVIGATION_ITEM table, and the APPLICATION table. A report could be constructed around this relationship to show which items and tools users are accessing in a particular Course.

In some instances, the value in the data field is a number, such as _1_1 or _29_1. These are associated with an EVENT_TYPE of TAB_ACCESS or MODULE_ACCESS. The first number is an ID that references a tab or a module (the second number can be ignored).

The ID number that refers to a module can be found in the same manner. Scroll over the Maximize, Minimize, or Edit button associated with a module. The ID number will appear as part of the URL in the status bar. Please note that the Detach Module button returns a different ID number and should be ignored.

3a8082e126