I'm converting from Eblah 9.71 to SMF using eblah_to_smf.php
I'm getting an error:
++++++++++++
Converting members...Incorrect table definition; there can be only one auto column and it must be defined as a key
++++++++++++
Any help would be appreciated.
Don
I got a little farther down the road:
Converting membergroups... Successful.
Converting members...Invalid default value for 'id_member'
I tried changing the default value to null, 0 and 1, but it won't let me.
- Don
I am not familiar with Eblah what is the database structure for the members table for it? If not I would try removing the default value completely.
It's been a while and I'm starting from scratch. I'm getting, "Converting membergroups...The database value you're trying to insert does not exist: temp_members"
But it does exist - in smf_membergroups the value temp_members exists.
Any thoughts?
Don
I was able to clear the last error by deleting all the member groups except admin and moderator, now I get:
Duplicate entry '0' for key 'id_member'
But unable to set id_member to auto increment and have a default value of '0' MySql will not allow it.
Thoughts?
A little more progress
Converting membergroups... Unsuccessful!
This query:
REPLACE INTO `simplysc_smf`.membergroups
(ID_GROUP, groupName, onlineColor, minPosts, stars, tempMembers)
VALUES (1, SUBSTRING('Administrator', 1, 80), SUBSTRING('blue', 1, 20), 0, '', 'admin,Bert,me,LC,Mr._Blonde'),
(3, SUBSTRING('Board Moderator', 1, 80), SUBSTRING('', 1, 20), 0, '', '');
Caused the error:
1054
1054 is unknown olumn error in mysql
SMF 1.1.x or SMF 2.0.X?
I'm using SMF 2.0.17
This line needs to be changed
(ID_GROUP, groupName, onlineColor, minPosts, stars, tempMembers)
To
(ID_GROUP, group_name, online_color, min_posts, stars, temp_Members)
Thank you! That worked:
Converting...
Converting membergroups... Successful.
Converting members...
Not sure if anything is happening, tho. I'm going to leave it for a while.
Thanks, again,
Don
Another error:
This query:
ALTER TABLE `simplysc_smf`.members
DROP PRIMARY KEY,
CHANGE COLUMN ID_MEMBER ID_MEMBER mediumint(8) unsigned NOT NULL default 0;
Caused the error:
1091
I saw that ID_MEMBER was listed twice, so I removed it and reran and got:
This query:
ALTER TABLE `simplysc_smf`.members
DROP PRIMARY KEY,
CHANGE COLUMN ID_MEMBER mediumint(8) unsigned NOT NULL default 0;
Caused the error:
1064
which makes me think removing the extra ID_MEMBER was a mistake and re ran it to get to:
This query:
ALTER TABLE `simplysc_smf`.members
DROP PRIMARY KEY,
CHANGE COLUMN ID_MEMBER ID_MEMBER mediumint(8) unsigned NOT NULL default 0;
Caused the error:
1091
Try removing this part DROP PRIMARY KEY,
Removed DROP PRIMARY KEY,
At convert.php?step=1 it seems to stall. I checked MySQL and see that membergroups was converted, but when I check members MySQL returned an empty result set.
Converting...
Converting membergroups... Successful.
Converting members...