The theory

A view is the result set of a stored query on the data, which the database users can query just as they would in a persistent database collection object.

Profile a site with Webprofiler

Using the Webprofiler, you can profile any Drupal 8 page analyzing both the performance and the internal structure of a website.


Install as any other Drupal module.
Webprofiler needs two javascript libraries to render the timeline and to syntax highlight collected queries:

Creating A list (for Alumni page)

Hi guys, hope you all well?

Im having a bit of trouble. What I want to do is create a page that has a list of people, as well as the date these people were at this particular organisation.
So essentially, a database. How Do I do this in Drupal? I need the use to have a form that they can just enter the name and date information, then on the site, display all the info in the database.
Also, the database must be printable.

Hope someone can help me?

Taxonomy upgrade extras: 

finding Drupal table after setting up

I use to see the flood table in Drupal database but after setting up the site in a difference PC, I can't find this table. I have checked the schema_information and find the flood but I still have a problem to find it in the site table list (without query).
I would appreciate if you tell me where can I find it or make it to show up in the database.

Taxonomy upgrade extras: 

PDOException: SQLSTATE[HY000] [2002] Can't connect to local MySQL server

If you're seeing PDOException: SQLSTATE[HY000] [2002] Can't connect to local MySQL server, it's because Drupal can't connect to the database server specified in your settings.php. There are two likely reasons for this:

Oracleism: Don't use AS for table aliases

In both MySQL and PostgreSQL, when giving tables aliases in the FROM clause, it is optional to use the AS keyword.

SELECT n.nid, u.uid, FROM {node} AS n LEFT JOIN {user} AS u ON n.uid = u.uid;

However, the Oracle database does not allow AS to be use in FROM or any JOINs.

SELECT n.nid, u.uid, FROM {node} n LEFT JOIN {user} u ON n.uid = u.uid;

Unfortunately, this makes finding the right alias for a table rather difficult.


Subscribe with RSS Subscribe to RSS - database