Topic: Eblah 9.71 conversion issues

[SimplyScripts]

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

[SimplyScripts]

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

[vbgamer45]

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.

[SimplyScripts]

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

[SimplyScripts]

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?

[SimplyScripts]

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

[vbgamer45]

1054 is unknown olumn error in mysql
SMF 1.1.x or SMF 2.0.X?

[SimplyScripts]

I'm using SMF 2.0.17

[vbgamer45]

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)

[SimplyScripts]

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

[SimplyScripts]

Another error:

This query:
ALTER TABLE `simplysc_smf`.members
DROP PRIMARY KEY,
CHANGE COLUMN ID_MEMBER ID_MEMBER mediumint( unsigned NOT NULL default 0;
Caused the error:
1091

[SimplyScripts]

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( 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( unsigned NOT NULL default 0;
Caused the error:
1091

[vbgamer45]

Try removing this part DROP PRIMARY KEY,

[SimplyScripts]

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...