Advertisement:

Author Topic: Eblah 9.71 conversion issues  (Read 5299 times)

Offline SimplyScripts

  • Semi-Newbie
  • *
  • Posts: 23
  • Gender: Male
    • @https://twitter.com/ on Twitter
    • SimplyScripts
Eblah 9.71 conversion issues
« on: March 12, 2020, 01:24:30 PM »
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.

Offline SimplyScripts

  • Semi-Newbie
  • *
  • Posts: 23
  • Gender: Male
    • @https://twitter.com/ on Twitter
    • SimplyScripts
Re: Eblah 9.71 conversion issues
« Reply #1 on: March 14, 2020, 08:10:45 PM »
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.

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 23,556
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Eblah 9.71 conversion issues
« Reply #2 on: March 14, 2020, 09:12:02 PM »
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

Offline SimplyScripts

  • Semi-Newbie
  • *
  • Posts: 23
  • Gender: Male
    • @https://twitter.com/ on Twitter
    • SimplyScripts
Re: Eblah 9.71 conversion issues
« Reply #3 on: December 05, 2020, 01:12:37 PM »
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.

Offline SimplyScripts

  • Semi-Newbie
  • *
  • Posts: 23
  • Gender: Male
    • @https://twitter.com/ on Twitter
    • SimplyScripts
Re: Eblah 9.71 conversion issues
« Reply #4 on: December 05, 2020, 08:08:32 PM »
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.

Offline SimplyScripts

  • Semi-Newbie
  • *
  • Posts: 23
  • Gender: Male
    • @https://twitter.com/ on Twitter
    • SimplyScripts
Re: Eblah 9.71 conversion issues
« Reply #5 on: December 05, 2020, 09:42:04 PM »
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.

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 23,556
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Eblah 9.71 conversion issues
« Reply #6 on: December 05, 2020, 10:58:54 PM »
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

Offline SimplyScripts

  • Semi-Newbie
  • *
  • Posts: 23
  • Gender: Male
    • @https://twitter.com/ on Twitter
    • SimplyScripts
Re: Eblah 9.71 conversion issues
« Reply #7 on: December 06, 2020, 10:33:10 AM »
I'm using SMF 2.0.17

No matter where you go, there you are.

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 23,556
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Eblah 9.71 conversion issues
« Reply #8 on: December 06, 2020, 11:33:20 AM »
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

Offline SimplyScripts

  • Semi-Newbie
  • *
  • Posts: 23
  • Gender: Male
    • @https://twitter.com/ on Twitter
    • SimplyScripts
Re: Eblah 9.71 conversion issues
« Reply #9 on: December 06, 2020, 12:58:11 PM »
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.

Offline SimplyScripts

  • Semi-Newbie
  • *
  • Posts: 23
  • Gender: Male
    • @https://twitter.com/ on Twitter
    • SimplyScripts
Re: Eblah 9.71 conversion issues
« Reply #10 on: December 06, 2020, 06:12:00 PM »
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.

Offline SimplyScripts

  • Semi-Newbie
  • *
  • Posts: 23
  • Gender: Male
    • @https://twitter.com/ on Twitter
    • SimplyScripts
Re: Eblah 9.71 conversion issues
« Reply #11 on: December 06, 2020, 06:21:31 PM »
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.

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 23,556
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Eblah 9.71 conversion issues
« Reply #12 on: December 06, 2020, 06:33:56 PM »
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

Offline SimplyScripts

  • Semi-Newbie
  • *
  • Posts: 23
  • Gender: Male
    • @https://twitter.com/ on Twitter
    • SimplyScripts
Re: Eblah 9.71 conversion issues
« Reply #13 on: December 07, 2020, 12:38:01 PM »
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.