Thanx for the reply,
I manually INSERTED all the whooping 10K lines of the dump myself. However now I have a funnier problem ... Plus none of the content for the frontpage , forum and such are showing anymore. They are in a moderation queue ..... all forum/content entries seem to be issued under the new username. And when I tried to edit the fields in content/queue list I get access denied you have no permissions... is there a way to reset all my premissions for all users. Creating and new permissions table does not seem to work.
best regards.
Jason Flatt wrote:
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/