[Imc-drupal-dev] node count big problem :)

[Sebastian]

kia ora koutou...

* John Axiak <john at imcmalta.org> [2006-07-14 19:12 +1200]:
> 
>     at imcmalta.org we upgraded from drupal 4.6 to 4.7 and in the 
> process our drupal counter was rested to 0. i.e. when someone posts a 
> new post it assigns it to node 1, 2, 3 instead of continuing at 354, 
> 355, 356, etc... has anyone got any idea how we can go about this 
> problem. I searched through some websites and all say that it has to do 
> something with the "nid" part in the node table. But I couldn't figure 
> out how and what is it related to the counter (except that I could see 
> an "increment +1" in the nid).
> 
>    does anyone know something about the nid part of the node table which 
> might help me correct this problem? Or, does anyone know where drupal 
> stores a total count for the nodes?

IIRC, you only need to issue

UPDATE `sequences` SET `id` = <yourid> WHERE `name` = 'nid';
UPDATE `sequences` SET `id` = <yourid> WHERE `name` = 'node_revisions_vid';

in your favourite sql administrator tool (i am not so sure about the
node_revisions_id).

hth,
 Sebastian

-- 
 _   ascii ribbon campaign     .oOo.   GCSd-s:+aC++ULB+++W++M+PS+++Y+
( )
 X   Agenda 23
/ \     - Soziale Zwietracht, Schrumpfen und Tradition
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://lists.indymedia.org/pipermail/imc-drupal-dev/attachments/20060714/26dbc213/attachment.pgp