News:

Wondering if this will always be free?  See why free is better.

Main Menu

[SMF Converter] Drupal 6.2

Started by SleePy, May 27, 2008, 05:05:28 PM

Previous topic - Next topic

drupal

Error message:

Quote('3707', 'felipe', 'felipe', '[email protected]', 'dgtrvy45yty45v6455yfvyt456vbhrhb', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', '0', '45345345345345', '', ''),
    ('3708', 'drayna', 'drayna', '[email protected]', 'vyt45ytvbrthb4565vtt45vt45tv45t', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '45345345345', '0', '345345345345', '', '');

Caused the error:

Duplicate entry '3499' for key 1

Try Again

drupal

error message

Converting...
Converting members...Duplicate entry '3499' for key 'PRIMARY'

Norv

Could you please try emptying your members table (empty, do not remove!), in phpmyadmin, then try again?

Or, try using a new fresh installation of SMF.

Please also make sure to use the converter package here: http://download.simplemachines.org/?converters;software=drupal and let us know if it still happens.

Also, what version of SMF are you using?
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github

drupal

Thanks.

Error message:

Converting members... Successful.
Converting categories...Unknown column 'catorder' in 'field list'

Norv

Can you please tell, to what version of SMF are you converting?
To-do lists are for deferral. The more things you write down the later they're done... until you have 100s of lists of things you don't do.

File a security report | Developers' Blog | Bug Tracker


Also known as Norv on D* | Norv N. on G+ | Norv on Github


Begy

Hi
I want convert drupal forum to SMF. My idea is convert this on my local server. But i can´t set rigt convertor. I have this set:
Path to SMF: C:\apache2triad\htdocs\TDM_forum
Path to Drupal 6.2 : C:\apache2triad\htdocs\TDM

but covertor displayed: Unable to find the settings for Drupal 6.2 . Please double check the path and try again.
I try set to drupal: C:\apache2triad\htdocs\TDM\sites\default and result is same  :-\

ThorstenE

check out the first post from this topic, you need the drupal_migration.php

Begy

Yes I used these files.

convert.php   from: http://download.simplemachines.org/index.php?thanks;filename=smf_1-1-11_drupal62_converter.zip
and
drupal62_to_smf.sql
drupal_migration.php
from: http://www.simplemachines.org/community/index.php?topic=241557.0

in drupal_migration.php i set
$drupal_database = 'tdm';
$drupal_prefix = '';

ThorstenE

the drupal_migration.php needs to be placed inside the Drupal folder..

Oskar Calvo

The module to move drupal forum to smf forum (smf 1.) can be downloaded from here:

http://github.com/oskarcalvo/drupal2smf/tree/6.x-1.x

Oskar

J3SUS

Converting topics... Unsuccessful!
This query:
SELECT
t.nid AS ID_TOPIC, f.tid AS ID_BOARD, t.sticky AS isSticky,
t.nid AS ID_FIRST_MSG,
IF (MAX(c.nid)>0, MAX(c.nid), t.nid) AS ID_LAST_MSG,
t.uid AS ID_MEMBER_STARTED,
IF (MAX(c.uid)>0, MAX(c.uid), t.uid) AS ID_MEMBER_UPDATED
FROM `drupal`.node AS t
INNER JOIN `drupal`.forum AS f ON (f.nid = t.nid)
LEFT JOIN `drupal`.comments AS c ON (c.nid = t.nid)
WHERE t.type='forum'
GROUP BY t.nid
LIMIT 0, 500;
Caused the error:

Table 'drupal.forum' doesn't exist


I need some help guys!

ThorstenE

J3SUS,
which version of drupal do you use?

ssace

#93
I am also getting this...


Converting members... Successful.
Converting categories...Unknown column 'catorder' in 'field list'


I am running Drupal 6.22.  I have the migrate.php file set up and in the Drupal root directory.  Any ideas please.

oldbastard

Quote from: ssace on August 31, 2011, 08:50:02 PM
I am also getting this...


Converting members... Successful.
Converting categories...Unknown column 'catorder' in 'field list'


I am running Drupal 6.22.  I have the migrate.php file set up and in the Drupal root directory.  Any ideas please.

Same error here.

ciberespia

idem error

Converting...
Converting members... Successful.
Converting categories...Unknown column 'catorder' in 'field list'

thiruvelan

Is is possible to used SMF converter drupal 6.2 to convert drupal 7.14 forum? I am interested to convert my drupal forum to simple machine forum, my forum is drupal 7.14 based. Anyone can please advice me in this regard. Thanks in advance for your valuable advice.

lenkeim

Hlo guys.
i need a bit help.
i have installed my old drupal forum and my new  smf forum  too, but i have a little bit issue with that,when i try to convert it.
Unknown system variable 'SQL_MAX_JOIN_SIZE'

and  nothing else,idont know what to do whit.

please help me.
thanks a lot.

yeah and merry xmas

ajamot

Here is updated drupal62_to_smf.sql file that shoud contain all the corrections needed, including support for the latest version of Drupal 6 (6.38). Succesfully tested on Drupal forum with over 7000 users and ~90000 posts.
You still need original convert.php and drupal_migration.php, adjusted to fit your server/databese settings.

Advertisement: