By Antikx on

Hello,

Here is what I did:
Installed Drupal 4.7.X about a year ago. I made many tweaks to the drupal setup that made it impossible to upgrade without breaking everything.

Here's where I am:
http://drupal.org/node/77487

Here's where I want to go:
-clean 5.5 install
-only bring the user accounts across, the rest of the user submitted data I will manually enter into the new drupal install
-buy a big stick to put by my computer to remind me that I should do things right the first time or I'll club myself to death.

My question:
Can I do a clean Drupal 5.5 install then import the users table from my 4.7.X install?

⋅ Categories: Drupal 5.x

Comments

pwolanin’s picture

pwolanin commented

It's a question of mechanism.

There are a couple inport/export modules that might make this easy such as:

http://drupal.org/project/importexportapi

or something else in that category: http://drupal.org/project/Modules/category/64

It also looks like the structure of this table doesn't have significant changes between 4.7.x and 5.x:

http://cvs.drupal.org/viewvc.py/drupal/drupal/modules/system/system.inst...

only function system_update_1022() seem to touch it, so you could perhaps just use the same table and run the query in that update function.

---
Work: BioRAFT

Antikx’s picture

Antikx commented

Cool. thanks for the reply.
I did a quick comparison of the tables:

Drupal 5.5
==========
uid  	int(10)  	 	UNSIGNED  	No  	0  	 	  Browse   
name 	varchar(60) 	utf8_general_ci 		No 		
pass  	varchar(32)  	utf8_general_ci  	 
mail 	varchar(64) 	utf8_general_ci 		Yes 			
mode 	tinyint(4) 			No 	0 		Browse 	Change 
sort 	tinyint(4) 			Yes 	0 		Browse 	Change 
threshold 	tinyint(4) 			Yes 	0 		Browse 	Change 
theme 	varchar(255) 	utf8_general_ci 		No 		
signature 	varchar(255) 	utf8_general_ci 		No 		
created 	int(11) 			No 	0 		Browse 	Change 
access 	int(11) 			No 	0 		Browse 	Change 
login 	int(11) 			No 	0 		Browse 	Change 
status 	tinyint(4) 			No 	0 		Browse 	Change 
timezone 	varchar(8) 	utf8_general_ci 		Yes 	NULL 
language 	varchar(12) 	utf8_general_ci 		No 		
picture 	varchar(255) 	utf8_general_ci 		No 		
init 	varchar(64) 	utf8_general_ci 		Yes 			
data	longtext  	utf8_general_ci	No

 Drupal 4.7.X
============
uid  	int(10)  	 	UNSIGNED  	No  	0  	 	  Browse  
name 	varchar(60) 	utf8_general_ci 		No 		
pass 	varchar(32) 	utf8_general_ci 		No 		
mail 	varchar(64) 	utf8_general_ci 		Yes 			Browse 
mode 	tinyint(1) 			No 	0 		Browse 	Change 
sort 	tinyint(1) 			Yes 	0 		Browse 	Change 	Drop 
threshold 	tinyint(1) 			Yes 	0 		Browse 	Change 
theme 	varchar(255) 	utf8_general_ci 		No 		
signature 	varchar(255) 	utf8_general_ci 		No 		
created 	int(11) 			No 	0 		Browse 	Change 
access 	int(11) 			No 	0 		Browse 	Change 
login 	int(11) 			No 	0 		Browse 	Change 
status 	tinyint(4) 			No 	0 		Browse 	Change 
timezone 	varchar(8) 	utf8_general_ci 		Yes 	NULL 
language 	varchar(12) 	utf8_general_ci 		No 		
picture 	varchar(255) 	utf8_general_ci 		No 		
init 	varchar(64) 	utf8_general_ci 		Yes 			Browse 
data 	longtext 	utf8_general_ci 		Yes 	NULL

It appears all the fields are there for both but the type is different on mode, sort and threshold.

It looks like it should be pretty straight forward.

I'll report back after I try it and let you know how I made out.

Antikx’s picture

Antikx commented

OK, I dropped the table, imported the old one, then changed the length on the 3 rows that had longer values.
Looks like it works. Ya!

Antikx’s picture

Antikx commented

Now when people sign up for accounts it looks like the "counter" has started back at #2, so new accounts are overwriting old one.
that's a bad thing.
Can someone please tell me where this "counter" value is so that I can change it to the current usercount?
Or if I'm out to lunch please tell me,
Here's the error I see when signing up for a new accout:
user warning: Duplicate entry '2' for key 1 query: INSERT INTO users (name, mail, pass, init, status, uid, created) VALUES ('jimmyjoe', 'montanaq2@hotmail.com', '9cdba4b0e2085c1366bfdda9c029d620', 'montanaq2@hotmail.com', 1, 2, 1200331234) in /home/.zubov/antikx/tyrannozaurus.com/includes/database.mysql.inc on line 172.

Antikx’s picture

Antikx commented

I started new thread here: http://drupal.org/node/209927