By Danilo Stern-Sapad on

My first error is this: (Where is the increment value for this stored???)

user error: Duplicate entry '10' for key 1
query: INSERT INTO harrypotter.node_comment_statistics (nid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count) VALUES (10, 1127925720, NULL, 2, 0) in /home/wizards/includes/database.mysql.inc on line 66.

warning: Cannot modify header information - headers already sent by (output started at /home/wizards/includes/common.inc:384) in /home/wizards/includes/common.inc on line 192

My second error is:
I imported all my users, but now all of them don't have the authenticated user role enabled. Which table is this role stored in so that I can write a script that makes everyone authenticated?

Comments

jadwigo’s picture

jadwigo commented

check in your {users_roles} table, where rid is the role id and uid is obviously the user id

The role id is found in the {role} table (and is auto incremented)
The user id is in the {users} table (it is incremented by checking the value in {sequences} -> db_next_id() does that for you)

jeditdog’s picture

jeditdog commented

I'm having the same problem. If I just insert a bunch of uid=number rid=2 to catch up the table with where my users I'm importing are (about uid 55), will it cause any problems? because uid 5 - uid 30 will be users that do not exist.

thanks!

jeditdog’s picture

jeditdog commented

this update actually takes place in the sequences table on the same line as wehn the field 'name' = 'users_uid'

tuoermin’s picture

tuoermin commented

If you are using the contributions/tricks/phpbb2drupal/phpbb2drupal45.mysql script, then you will probabyl also encounter the following two problems

#
# Create a vocabulary (called "Forum")
#
DELETE FROM drupal_vocabulary WHERE nodes='forum';
INSERT INTO drupal_vocabulary (vid,name,description,help,relations,hierarchy,multiple,required,nodes,weight)

line 70: nodes should be replaced by module

#
# Create temporary tables for sorting topics and comments.
#

DROP TABLE IF EXISTS temp_posts;
CREATE TABLE temp_posts (
post_id mediumint(8) UNSIGNED NOT NULL auto_increment,
topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
forum_id smallint(5) UNSIGNED DEFAULT '0' NOT NULL,
poster_id mediumint(8) DEFAULT '0' NOT NULL,
post_time int(11) DEFAULT '0' NOT NULL,
post_edit_time int(11),
post_subject char(512), // char can have just 255 characters

line 128: char(512) should be replaced by blob

Danilo Stern-Sapad’s picture

Danilo Stern-Sapad commented

Oh no that first comment was all I needed. I edited the phpbb script to fit my needs, cause I did an import from postnuke. Thanks anyway.