News:

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

Main Menu

From eBlah 10.3.3 to SMF blues

Started by basssolo4u, January 20, 2008, 03:52:07 PM

Previous topic - Next topic

basssolo4u

Hello,
I really like SMF and decided to convert a forum from eblah 10.3.3 to the latest SMF. I moved the eblah files from the cgi-bin to the public_html and started convert.php

Each time I am unsuccessful running the covert. it gives me errors on conversion saying

Converting membergroups... Unsuccessful!
This query:

    ALTER TABLE `database_name`.smf_membergroups
    ADD COLUMN tempMembers longtext,
    ADD COLUMN tempID int NOT NULL default 0;

Caused the error:

    Duplicate column name 'tempID'
and or the other error I get when retying is


Converting membergroups... Unsuccessful!
This query:

    ALTER TABLE `database_name`.smf_membergroups
    ADD COLUMN tempMembers longtext,
    ADD COLUMN tempID int NOT NULL default 0;

Caused the error:

    Duplicate column name 'tempID'

ANY assistance would greaty be appreciated. I have tried deleting and adding entries through phpMyAdmin and can't seem to figure out what the problem is and how to remedy.

In advance I thank you for your response.
B -

Deaks

~~~~
Former SMF Project Manager
Former SMF Customizer

"For as lang as hunner o us is in life, in nae wey
will we thole the Soothron tae owergang us. In truth it isna for glory, or wealth, or
honours that we fecht, but for freedom alane, that nae honest cheil gies up but wi life
itsel."

Oldiesmann

It's giving you errors when you retry because the converter assumes that column isn't going to be there when it tries to add it the first time.

Go through the database and delete any columns with "temp" in their name, then try again.

Advertisement: