By jpolt on

Can anyone give the SQL command to display all the pages in my Drupal database?

⋅ Categories: Drupal 5.x

Comments

nevets’s picture

nevets commented

I guess it depends on what you are after. All paths are stored in the menu table in in the path field. But that only gives you paths, not all of which are pages and does list pages like node/1 or any other constructed path where the base is list in the menu table but the remaining parts handled by code. In addition if you are interested in aliases you want to look at the url_alias table.

jpolt’s picture

jpolt commented

I just was a simple example of displaying something from my Drupal database...

I'm absolutely stuck because there is some rogue php code in some block which prevents me from updating the website using Drupal itself, and I can't identifying which block it is using phpMyAdmin so would like to try issuing SQL commands to display various bits of content.

All I want, to get started, is to do something simple like display a list of links I've created.

nevets’s picture

nevets commented

You can fx the block problem using phpMyAdmin. From what you say this is block you added so try

UPDATE blocks SET status = 0 WHERE module = 'block'

If it is not a block created from the block admin page try

UPDATE blocks SET status = 0 WHERE module <> 'user'

In either case you will likely need to enable so blocks after you log back on.

jpolt’s picture

jpolt commented

I've fixed the problem now, although I had to use MySQL commands since phpMyAdmin kept coming up with the error:-

import.php Missing parameter: format

As as re-enabling the block goes, before I do I'd like to know what went wrong.

I just pasted the code from the instructions here into a block

http://www.dict.pl/integracja.jsp?lang=EN

Is there any way to put breakpoints in to step through this code?

nevets’s picture

nevets commented

All I see at the link above is HTML which while it might break your layout should not otherwise cause a problem.