Hi
What is nid and vid and how its created actually i have a site which is made by drupal. http://beta.intent.com

if their somebody add a blog i got two table where data will insert (cms_node,cms_node_revisions) with nid and vid till now i did not get how to created nid and vid and also dont know in which table data will effected except cms_node,cms_node_revisions

*cms is table prefix

please help me

Edited by: VeryMisunderstood; Moved thread to post installation forum

Comments

marcvangend’s picture

- search before you ask
- ask only once (no cross posting)
- choose the most appropriate forum for your question (post installation, in this case)
Thanks.

Arup Garai’s picture

Hey i am new in drupal i have searched but i did not get any result can you help me???

WorldFallz’s picture

Please stop cross posting-- you've now posted the exact same request 5 times in the last few hours. People will reply when and if they are able and desire to do so. Being new and not receiving an immediate reply are no excuses to spam the forums.

besides, all you've done is probably alienate the very people from whom you are requesting assistance.

===
"Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime." - Lao Tzu
"God helps those who help themselves." - Ben Franklin
"Search is your best friend." - Worldfallz

vm’s picture

All duplicated/crossposted threads have been removed.

Crossposting doesn't get answers any faster. If anything it lessens the chances that you get an answer at all.

hectorplus’s picture

If you are just asking what NID and VID is, they are 'node id' and 'vocabulary id', these are unique IDs that is given/created for a post/entry/blog.

Amigopost.com

Random posts by Hector M.

shanefjordan’s picture

In the tables referenced for this question, VID is the 'version id'. The nid and vid are stored in the sequences table and get updated as a node is created/updated. The vid allows multiple revisions of your nodes to be stored.

However, in the vocabulary tables, vid references to the 'vocabulary id' (I guess different id's really should have been used).

- Shane

Arup Garai’s picture

Many many Thanks for your reply.

Can you tell me the complete procedure to add a blog means if i want to add manually. In which tables i have to add(insert) data.
just can you tell me the whole procedure of adding a blog.

I want to add a blog from another application which blogs will shows in main site(my drupal site).

how can i generate nid and vid its auto incremented id ?

please help me

marcvangend’s picture

I advice you not to add nodes to the database manually. Especially if you're not a Drupal expert, mistakes are easy to make and difficult to fix. If you need to add node by other means than the add node form, you may want to consider the node import module (to import from csv files) or writing a custom script (examples can be found on the forum, don't have a link for you right now) which builds a node object and saves it.

iajay’s picture

It would be better that u install a node import module
and make a csv of the blogs and import the blogs
u can search for the modules
Ajay

Do visit me at http://www.iajay.com

Arup Garai’s picture

Ajay Thanks for reply

But my requirement is little bit different for my application has two type user one is facebook user who can access my site as facebook application and another one main user(from my drupal application) but data base is same so all post from facebook app and from main site will store in same database .

so i have to add data from any other application

please help me

shanefjordan’s picture

Do not write please help me at the end of every post, by posting here it is understood that you need assistance. Since it sounds like you cannot use one of the regular import modules, I would hope that you have experience in writing custom scripts and using databases (which I assume you do). My suggestion would be this:

- Create a clean Drupal installation
- Install the necessary modules that you will be using (Blog)
- Run a mysql dump
- Add a single blog enter and possible a comment to that blog entry
- Run a mysql dump
- Run a file compare utility
- Now you have the tables that were affected
- Build a script to read your data and insert it into the tables affected above

If you don't have experience in writing scripts and using databases, my suggestion would be to hire someone.

As far as not inserting directly into the tables.... I just did a conversion from one legacy CMS to Drupal and had to write scripts to convert the data and populate Drupal. Site is successfully running for approximately a month.

- Shane

gcassie’s picture

Instead of writing directly to the database, you're likely better off building up nodes in php code and then using node_save to write them to the DB. It catches all the fiddly bits that are easy to miss with direct DB writes.

http://api.drupal.org/api/function/node_save

Neil_in_Chicago’s picture

I need to do a simple lookup on some CCK values, so I'm combing the “documentation” looking for clues to the data structure logic.
This comment is the THIRD different explanation of the abbreviation "vid" that I've found, in only a few minutes of looking. (#1 is "version id", #2 is "view id".)
Yes, the original poster may be obnoxiously Doing It Wrong, but the drupal “documentation” was Doing It Wrong first.

. . . and if anyone has a link to the CCK data structure documentation, I'll buy them a beer, cookie, or any equivalent of personal preference!

gcassie’s picture

vid does indeed mean different things in different contexts.

i'd suggest the devel module if you haven't tried it yet: http://drupal.org/project/devel

you can inspect the node structure, and then mimic it to do what you need. it also ships with several very useful functions.

vm’s picture

couldn't someting of this nature be completed using aggregated feeds sent from one pulled into the other?