[support] db errors by me

[Jason Flatt]

On Saturday 20 May 2006 04:09, dominick dreiser wrote:
>
> But now it would seem I have numberous problems importing the tables...
> tables such as forum, history such would seme to have numberous
> duplicate entries
> for the first fields of their tables.
>
> example :
>
> INSERT INTO `history` VALUES (3, 226, 1148071571);
> INSERT INTO `history` VALUES (3, 217, 1147792290);
> INSERT INTO `history` VALUES (3, 71, 1148072051);
> INSERT INTO `history` VALUES (3, 26, 1147990553);
> INSERT INTO `history` VALUES (3, 195, 1148049452);
> INSERT INTO `history` VALUES (3, 95, 1148050061);

For that table and column, that is normal. That first field is the user id, 
and there can be more than one entry per user.

> Is there any specific tool for drupal that can rebuild and import fields
> from a dump properly.

I don't know about that. Check the modules[0] and handbook[1]&[2] areas 
online.

> Using mysql or phpmyadmin just gives me "duplicate entries found".

For the history table? Can you just ignore or remove the duplicates?

[0] http://drupal.org/project/Modules
[1] http://drupal.org/node/258
[2] http://drupal.org/upgrade/

-- 
Jason Flatt
http://www.oadae.net/
Father of Six:  http://www.flattfamily.com/ (Joseph, 13; Cramer, 11; Travis, 
9; Angela; Harry, 5; and William, 12:04 am, 12-29-2005)
Linux User:     http://www.sourcemage.org/
Drupal Fanatic: http://drupal.org/