Daniel,
Drupal stores the basic node info in the node table. The content for page is stored in the node_revisions table.
Let's suppose I create a new page, called "testtest", looking at the bottom of the node table, I see I have nid "114" with vid "117". The vid value is the current revision for that node.
Going to the node_revisions table, I will see the exact same entries for the nid and vid fields, but in this table I will see the body and teaser content also.
So node_revisions is for all versions of a node, including the current one!
Victor Kane http://awebfactory.com.ar
On Tue, Dec 16, 2008 at 9:20 AM, Daniel Carrera daniel.carrera@zmsl.comwrote:
I looked in 'nodes' and even 'node_revisions'. But I couldn't find the current text of the page. What I saw in node_revisions looked like previous copies of the pages.
Ultimately, what I'm trying to do is search a particular text string in all current pages.
I migrated a site to a different domain and I want to make sure that there are no links or images that point to the old domain. So I want to do a text search for the old domain in all current pages.
Daniel.
Victor Kane wrote:
Pages are stored as nodes in the database.
However, there are several tables involved since revisions for each node are involved also.
On Tue, Dec 16, 2008 at 8:42 AM, Daniel Carrera <daniel.carrera@zmsl.com mailto:daniel.carrera@zmsl.com> wrote:
Hello, I'm looking at the DB and I can't figure out where the page contentis
stored. Does anyone know? Daniel. -- [ Drupal support list | http://lists.drupal.org/ ]-- [ Drupal support list | http://lists.drupal.org/ ]