• Welcome to Simple Machines Community Forum. Please login or sign up.
December 01, 2021, 11:28:43 AM

News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord


Eblah 9.71 conversion issues

Started by SimplyScripts, March 12, 2020, 01:24:30 PM

Previous topic - Next topic

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
No matter where you go, there you are.

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
No matter where you go, there you are.

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.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

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
No matter where you go, there you are.

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?
No matter where you go, there you are.

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
No matter where you go, there you are.

vbgamer45

1054 is unknown olumn error in mysql
SMF 1.1.x or SMF 2.0.X?
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

SimplyScripts

No matter where you go, there you are.

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)
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

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
No matter where you go, there you are.

SimplyScripts

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
No matter where you go, there you are.

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

No matter where you go, there you are.

vbgamer45

Try removing this part DROP PRIMARY KEY,
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

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...
No matter where you go, there you are.

Advertisement: