Software: Drupal
Version: 6.2
This is the official support topic for Drupal 6.2 converter. Use this topic to ask for support for this converter.
A big thanks goes to ThorstenE (http://www.simplemachines.org/community/index.php?action=profile;u=73029) for his help in creating the converter.
Changelog
drupal_migration.php
For the conversion to be able to complete, the drupal_migration.php file is required. You will need to modify this file to reflect your Database name and Database prefix (if specified). You can find this information in /sites/<site name>/settings.php in the variable "$db_url" and "$db_prefix"
convert.php
Use this convert.php (http://www.simplemachines.org/community/index.php?topic=140741.0) with the .sql file attached in this topic.
Does this allow you to migrate from Drupal to SMF or from SMF to Drupal?
From Drupal to SMF, not vica-versa :)
See Converting to SMF (http://docs.simplemachines.org/index.php?board=4.0;sort=subject) to know how to convert to SMF from other forum software.
good work! ;D
Hey,
thanks for the converter but theres just one issue. I have two different Drupal 6.2 forums that i need to convert to SMF. I have tried to use the converter but it overwrites the convert i did before.
Would it be possible to change the script so it add forums, topics, users and so on?
Tonny
You would have to convert it to two different SMF forums.
The .sql file has a path set to the default site. You would have to change this path to be the other drupal site you want to convert.
Just to make sure that you understand me.
What I want is to merge the two Drupal forums to one SMF forum. If thats not possible, would it be possible to merge two SMF forums?
Quote from: tonnyl on July 03, 2008, 02:37:20 PM
would it be possible to merge two SMF forums?
this is possible :) take a look at http://www.simplemachines.org/community/index.php?topic=188524.0
Hola there,
I'm trying to use these scripts with a 6.3 installation and the latest smf in the 1.1x branch, however the conversion script keeps returning "Unable to find the settings for Drupal 6.2 . Please double check the path and try again." even though I've specified the locations correctly
Both installations are in the same directory tree, and the databases are on the same sql server, with the SMF user having full access to the database.
Any suggestions?
two ideas:
- the pathes during conversion are absolute pathes like /home/www/user/forum... maybe you have entered relative pathes or URLs instead?
- have you downloaded the drupal_migration.php from the first post of this topic and placed in your drupal directory?
Looking worked but I got some warning:
Converting...
Converting members... Successful.
Converting categories...
Warning: Invalid argument supplied for foreach() in /home/www/virtual/my.com/htdocs/smf/convert.php(929) : eval()'d code on line 11
Successful.
Converting boards...
Warning: Invalid argument supplied for foreach() in /home/www/virtual/my.com/htdocs/smf/convert.php(929) : eval()'d code on line 11
Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting posts - Part 2(this may take some time)... Successful.
Converting attachments... Successful.
Converting avatars... Successful.
Recalculating forum statistics... Successful.
kerberos, is the result from the conversion OK or is there something missing?
Had some issues with escaping descriptions in the board categories. A problem with single-quotes. I ended up going into the DB and escaping the few instances of single quotes we had manually, so the job completed successfully. Just figured I'd post about it.
Quote from: TE on May 16, 2009, 08:19:10 AM
kerberos, is the result from the conversion OK or is there something missing?
overall worked but I'd to delete some categories.
Thank very much
Note:
I converted from drupal 6.5 to smf 1.1.8
Welcome to SMF :)
i'm trying to convert a drupal 6.16 site to SMF. as far as i can see from drupal, 6.16 is the current version. there doesn't appear to be a 6.2. at any rate i can't get the converter to work. it says it can't find the settings.php file, which is right on the path the converter specifies. any help would be most appreciated. thanks.
lannygoodman, you need the drupal_migration.php from the first message in this topic:
http://www.simplemachines.org/community/index.php?action=dlattach;topic=241557.0;attach=56931
QuoteFor the conversion to be able to complete, the drupal_migration.php file is required. You will need to modify this file to reflect your Database name and Database prefix (if specified). You can find this information in /sites/<site name>/settings.php in the variable "$db_url" and "$db_prefix"
Hi!
It's almost good converter but doesn't reflect private messages and topics number views. Is it any chance to include it?
Quote from: baluk on March 15, 2010, 10:28:49 AM
Hi!
It's almost good converter but doesn't reflect private messages and topics number views. Is it any chance to include it?
Is this a core feature of Drupal or is it an addon / modification?
Private messages it's an addon but it's not so important to me. Users if they would like to can move messages to the new forum by hand using copy and paste.
I think that number of topic views should be included into converter because it's very important information and shows what is popular.
I also noticed that converter has problem with topics that doesn't exist but information about them are stored in DB.
Another problem is that converter assigns to me autorship of some topics.
Haven't tested the converter for a while, I'll check it during the next days.. maybe I can fix some remaining bugs.
Thanks for looking into this very useful converter, TE. I'm very eagerly awaiting for your updates.
I downloaded and installed 6.2 specifically for this conversion, and then also tried to convert but this is the latest from a long list of errors and now i have no idea what to do to fix this:
Converting...
Converting members... Successful.
Converting categories...
Warning: Invalid argument supplied for foreach() in /home/user/public_html/test/convert.php(941) : eval()'d code on line 11
Successful.
Converting boards... Unsuccessful!
This query:
INSERT IGNORE INTO `user_test`.test_boards
(ID_BOARD, name, description, ID_PARENT, ID_CAT)
VALUES ('3' , 'I hope that's not what it looks like...' , '' , '0' , '0');
Caused the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's not what it looks like...' , '' , '0' , '0')' at line 3
Unfortunately, if you want to convert to the best alternative (SMF) this converter still does not work. Nobody cares to fix this? I guess not. :(
jeffreyfrog = spammer.
sharks> Obviously, the converter has a bug here. It should be using $smcFunc['db_escape_string']() on the 'name' string before inserting it.
Is that the only bug that stops your conversion from succeeding?
OT-- Hey, nice little bug... jeffreyfrog's link is active when you view it from his profile.
http://www.simplemachines.org/community/index.php?action=profile;area=showposts;u=255574
Obviously, this is unwanted, isn't it?
Thanks for your concern, Nao. I am currently reinstalling and converting my WordPress blog to Drupal to test your bug fixes in the converter.
I had given up hope as nobody seems active anymore, and deleted my Drupal blog.
Thanks again for being helpful. :)
Well, I'm only here because I'm extremely bored because I can't work because I've fixed most of the bugs I assigned to myself and now I'm supposed to wait until dozens of persons read my patches and confirm I can commit them but so far no one has taken a look at them. So, yeah, you could have waited even more for a fix... (I only fix bugs I see reported on the bug tracker, really.)
Technically, maybe the bug *was* discussed in the team boards. I wouldn't know, though, because I have yet to be made a team member. (Insert VERY LONG blank stare here.)
I understand your frustration Nao... Let's hope the SMF boss/es finish what they started, one day. I hope before 2011, we get to see SMF 2.0 Final.
Anyway, i have a Blogger blog, and i just finished importing all posts to WordPress 2.9.2 (3.0 Final was just released minutes ago!!) and now i'm going to import it to Drupal 6.2 (the old one released in 2008, used by this importer).
Maybe if you want to keep the boredom a bit far away, i can let you do this Drupal to SMF conversion? I'm not sure what you mean by the code changes above... I can PM you with my logins. I have tried this many many times but failed pathetically to produce anything in my SMF forum other than an erased category board and then nothing.
'kay, if it fails, send me your login stuff. Mostly phpMyAdmin will be useful.
The problem with 2.0 is that it's coming soonish, so there's added pressure on code quality. Perhaps a bit too much really... :-\
Here is what my latest conversion says:
Converting...
Converting members... Successful.
Converting categories...
Warning: Invalid argument supplied for foreach() in /home/sharks/site/forum/convert.php(941) : eval()'d code on line 11
Successful.
Converting boards... Unsuccessful!
This query:
INSERT IGNORE INTO `sharks_smf`.smf_boards
(ID_BOARD, name, description, ID_PARENT, ID_CAT)
VALUES ('3' , 'I hope that's not what it looks like...' , '' , '0' , '0');
Caused the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's not what it looks like...' , '' , '0' , '0')' at line 3
EDIT: PM sent. :)
Well the db_escape_string wasn't applied was it...?
Quote from: Nao on June 17, 2010, 05:14:14 PM
Well the db_escape_string wasn't applied was it...?
I have no idea. I haven't changed any of the code from anywhere. I just used the converter files attached in the first post of this thread.
I ran the converter only once, to see what would happen, and it generated the errors in my previous post. The same errors as it always does.
My blank SMF forum then turned out like it did, with no category title, and 2 boards, each with the titles of some of the post tags from my blog. No posts and no topics were carried over.
If you could edit the original converter files to include the necessary fixes, i could run it again and inform you of the results. Or if you want, you can do it, if you think it would go faster to test the code changes. :)
Quote from: sharks on June 17, 2010, 05:24:17 PM
I have no idea. I haven't changed any of the code from anywhere. I just used the converter files attached in the first post of this thread.
I looked into it... It's pure SMF1 code so I had to change it differently.
QuoteIf you could edit the original converter files to include the necessary fixes, i could run it again and inform you of the results. Or if you want, you can do it, if you think it would go faster to test the code changes. :)
See attachment. Obviously untested, but it should at least fix your current issue.
I have renamed your attachment from drupal.sql to drupal62_to_smf.sql and placed it in the SMF folder.
I ran it and this is the output:
Converting...
Converting members... Successful.
Converting categories...
Warning: Invalid argument supplied for foreach() in /home/sharks/site/forum/convert.php(941) : eval()'d code on line 11
Successful.
Converting boards...
Notice: Use of undefined constant name - assumed 'name' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant description - assumed 'description' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant name - assumed 'name' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant description - assumed 'description' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant name - assumed 'name' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant description - assumed 'description' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant name - assumed 'name' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant description - assumed 'description' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant name - assumed 'name' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant description - assumed 'description' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant name - assumed 'name' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant description - assumed 'description' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant name - assumed 'name' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant description - assumed 'description' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Warning: Invalid argument supplied for foreach() in /home/sharks/site/forum/convert.php(941) : eval()'d code on line 11
Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting posts - Part 2(this may take some time)... Successful.
Converting attachments... Unsuccessful!
This query:
SELECT u.nid AS ID_MSG, f.filename, f.filepath
FROM `sharks_drupal`.drupal_upload AS u
LEFT JOIN `sharks_drupal`.drupal_files AS f ON (u.fid = f.fid)
LIMIT 0, 500;
Caused the error:
Table 'sharks_drupal.drupal_upload' doesn't exist
I checked the SMF forum and it has created a new board for every different category from my WordPress blog, but there are 0 topics and 0 posts in all of them. Also, i have 5 members on my WordPress blog and it has only converted one member; admin.
In my script -- look for $row[name] and $row[description] and replace with $row['name'] and $row['description'], this will get you rid of the warnings.
As for the foreach() error, make sure you have at least one 'category'? Because that's the only thing that's being looped...
As for drupal_upload, well, is it certain that Drupal 6.2 creates that table? If not, try to find out how to create it.
I did what you asked, but i am stuck on how to create a new table with the proper number of columns, rows, etc. I Google'd for it but ultimately the conversion failed as i managed to create the table but the configuration of that table is flawed. I have no experience whatsoever with SQL:
Converting...
Converting members... Successful.
Converting categories...
Warning: Invalid argument supplied for foreach() in /home/sharks/site/forum/convert.php(941) : eval()'d code on line 11
Successful.
Converting boards...
Notice: Use of undefined constant name - assumed 'name' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant description - assumed 'description' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant name - assumed 'name' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant description - assumed 'description' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant name - assumed 'name' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant description - assumed 'description' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant name - assumed 'name' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant description - assumed 'description' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant name - assumed 'name' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant description - assumed 'description' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant name - assumed 'name' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant description - assumed 'description' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant name - assumed 'name' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Notice: Use of undefined constant description - assumed 'description' in /home/sharks/site/forum/convert.php(1109) : eval()'d code on line 6
Warning: Invalid argument supplied for foreach() in /home/sharks/site/forum/convert.php(941) : eval()'d code on line 11
Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting posts - Part 2(this may take some time)... Successful.
Converting attachments... Unsuccessful!
This query:
SELECT u.nid AS ID_MSG, f.filename, f.filepath
FROM `sharks_drupal`.drupal_upload AS u
LEFT JOIN `sharks_drupal`.drupal_files AS f ON (u.fid = f.fid)
LIMIT 0, 500;
Caused the error:
Unknown column 'u.nid' in 'field list'
Why are the 'name' errors still there? Did you actually apply my change or not...?
As for upload, just have two INT fields named 'nid' and 'fid', apparently...
Perhaps it's better if you could export the structure of your Drupal database: phpMyAdmin > select the drupal database > "export" tab > export all tables from Drupal, as "structure only", no data, into a file.
Then attach that file here.
It seems the converter expects the Drupal attachments to be in a table drupal_upload, when your installation may have something changed. Also, can you please tell (sorry if you did and I missed it, very on the run) what exact version of Drupal are you running?
@Nao I applied ALL the changes that you have said. But i have no idea how to create another table called "drupal_upload". Any simple instructions or sql query that i can just paste and run? I have attached your sql file as drupal.sql that i have modified according to what you told me.
@Norv My Drupal versions is 6.2 - it's the exact version that is used by this converter.
I have attached an export of my sql drupal structure only.
I wonder, does your Drupal have attached files (uploaded files)? Except avatars.
My Drupal installation has no attached files and no avatars. It was a blank and brand new 6.2 installation that has been filled with posts imported from my WordPress blog. All the converted posts display fine on the Drupal blog.
Perhaps you can try: (in the sql file)
/******************************************************************************/
--- Converting attachments...
/******************************************************************************/
---* {$to_prefix}attachments
---{
$no_add = true;
$file_hash = getAttachmentFilename(basename($row['filename']), $id_attach, null, true);
$physical_filename = $id_attach . '_' . $file_hash;
if (strlen($physical_filename) > 255)
return;
$oldfile = $_POST['path_from'] . '/' . $row['filepath'];
if (file_exists($oldfile) && copy($_POST['path_from'] . '/'.$row['filepath'], $attachmentUploadDir . '/' . $physical_filename))
{
@touch($attachmentUploadDir . '/' . $physical_filename, filemtime($row['filename']));
$rows[] = array(
'id_attach' => $id_attach,
'size' => filesize($attachmentUploadDir . '/' . $physical_filename),
'filename' => basename($row['filename']),
'file_hash' => $file_hash,
'id_msg' => $row['id_msg'],
'downloads' => 0,
);
$id_attach++;
}
---}
SELECT u.nid AS id_msg, f.filename, f.filepath
FROM {$from_prefix}upload AS u
LEFT JOIN {$from_prefix}files AS f ON (u.fid = f.fid);
---*
and remove it, at least for the time being.
I did exactly what you said and this is what i get:
Converting...
Converting members... Successful.
Converting categories...
Warning: Invalid argument supplied for foreach() in /home/sharks/site/forum/convert.php(941) : eval()'d code on line 11
Successful.
Converting boards...
Warning: Invalid argument supplied for foreach() in /home/sharks/site/forum/convert.php(941) : eval()'d code on line 11
Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting posts - Part 2(this may take some time)... Successful.
Converting avatars... Successful.
Recalculating forum statistics... Successful.
Now, i go to my forum, and... there are 0 posts and 0 topics!
There are only 2 improvements:
- Now, the category is still here, and has not been deleted. In all previous attempts, i had to do forum maintenance fixing, to recover the boards, as there was no category at all after running the converter, which i assume deleted the category, without affecting the boards it contained.
- All members have been converted from Drupal.
P.S. I had the serious impression that the posts were not being parsed, as i have over 4000 posts on Drupal and it took maybe 1.5 seconds for the whole conversion.
Could you please run Admin > forum maintenance > Recount all forum statistics?
I just ran those 2 options:
Find and repair any errors.
Recount all forum totals and statistics.
Both were successful (no problems found), and still 0 posts and 0 topics.
Ah, I just read your edited post, obviously they weren't done...
It seems the problems are here: (sql file)
$request = convert_query("
SELECT value
FROM {$from_prefix}variable
WHERE name ='forum_containers'
LIMIT 1");
This does not result in a list of categories, as the converter expects.
Could you please run in phpmyadmin: (on drupal db)
SELECT * FROM drupal_variable WHERE name LIKE 'forum';
and post the result here, if any.
Or, you could perhaps export only the table drupal_variable, both structure and data, into another file? Please, check the resulting file to make sure no confidential data rows are included (feel free to delete them if there are). Just in case, perhaps you could PM the contents of the file, to be sure no confidential data slip into public?
I ran the query exactly as you posted above.
This is the result:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0, 30' at line 2
SELECT *
FROM drupal_variable
WHERE name LIKE 'forum';
LIMIT 0 , 30
No... it seems you had a "LIMIT 0, 30" text remaining there, in the SQL code textarea. :)
Please run only with the query above in the box.
I think phpMyAdmin automatically adds the LIMIT thing, and probably doesn't remove the final semi-colon before that.
The solution is of course to remove the semi-colon.
@Norv i only ran the query in the code box as you said. There was/is no other text in the query box.
I removed the semi-colon as Nao suggested, and here is the result (no error this time):
MySQL returned an empty result set (i.e. zero rows). ( Query took 0.0004 sec )
SELECT *
FROM drupal_variable
WHERE name LIKE 'forum'
LIMIT 0 , 30
The converter is currently for drupal "forum" posts only, not for the normal drupal content (articles). That's why there wasn't converted anything.
So... Do i have to convert all my Drupal "story" type posts into "forum" type posts? Is there any easy way to do that? Right now i have over 4000 posts of the "story" type. In this situation, isn't it easier to modify a few lines in the converter to handle story types instead of forum types?
Perhaps it would be a good idea if you could try the second suggestion, making an export with the table drupal_variable, both structure and data. If you wish, you could PM it to me..., unless perhaps Nao could take a look at it.
(I will be offline for at least 14 hours soon.)
If you don't feel comfortable with doing so, that is okay, too, we can also look at a drupal installation, and see what is going on in that table. Not sure when, currently I don't have a local installation, nor database, at hand.
Hello.
I'm trying to move a Drupal forum to smf, and I have a problem, it tell me that there is a problem with one of the drupal user id (drupal uid are key and autoincrement), it toll me this:
Duplicate entry '11987' for key 'PRIMARY'
I'm looking around it to understand why it toll me that, and I don't find what happens with the conversion to find a problem with this.
Thanks
Oskar
LMAO. Unfortunately, Oskar, i have been waiting for someone to fix that Drupal coverter since ages!!
Wise advice: Give up now and save yourself the sorrow of knowing you're alone in this.
Oskar, have you tried to re-start the conversion from the beginning? If you still got the same error edit drupal_to_smf.sql and find:
---* {$to_prefix}members
Add after:
---{
$ignore = true;
---}
then restart the conversion.
sharks,
sorry to hear that but as I said before: I wrote the converter initially for a drupal forum conversion, not for an article conversion.
Since I'm no longer a member of the SMF team I have no intentions to rewrite my converters or create new ones.. Maybe someone from the current team members is able to help you.
Quote from: TE on July 06, 2010, 01:58:51 PM
Since I'm no longer a member of the SMF team I have no intentions to rewrite my converters or create new ones.. Maybe someone from the current team members is able to help you.
I personally have no interest in converters. The only one I could possibly work on is a WordPress converter, and possibly a MovableType converter, but even then, I'd need to have a reason to import one of these blogs (i.e., someone wants to move their blog to noisen and I find it a good challenge to implement.)
sharks, I think I asked you something on a WP topic and you didn't reply. (From memory.)
Quote from: Nao on July 06, 2010, 05:10:52 PM
sharks, I think I asked you something on a WP topic and you didn't reply. (From memory.)
Eh? I don't think that was a question from your other post. :D But i'll reply to it.
Hello Folks, As I'm a Drupal Developer, I'm building a module to move from Drupal to smf using the drupal apis, it's easy for my.
I hope to finish it, and have a 6.x version soon.
Oskar
Quote from: Oskar Calvo on July 07, 2010, 06:39:16 AM
Hello Folks, As I'm a Drupal Developer, I'm building a module to move from Drupal to smf using the drupal apis, it's easy for my.
I hope to finish it, and have a 6.x version soon.
Oskar
Thanks a lot for your endeavor and commitment, Oskar.
We all look forward to seeing your new project. :)
BTW, could you build your module so that it's compatible with SMF 1.1 primarily. I mean, compatibility with SMF 2.0 would also be good, but SMF 1.1 is the stable version, so it is preferred.
Hello, I'm trying to add the categories in the categories table.
But all the time tell me the same thing: Invalid query: Duplicate entry '255' for key 'PRIMARY'
function drupal2smf_move_cat (){
//make the conection to the dabatabase
$link = smf_db_connect();
//get drupal's categories
$container = variable_get('forum_containers', NULL);
if ($container){
//if there is containers we will make the cat of smf
foreach ($container as $tid){
//$tid -> is the tid of the forum containers, also are taxonomys.
// $output .= $tid.'<br>';
//we get the object of every category with the term_data information.
$term = taxonomy_get_term($tid);
if($link){
$insertar = mysql_query("INSERT IGNORE INTO `categories`
(ID_CAT, name, catorder)
VALUES ('$tid','$term->name','0');",
$link);
$output .= $tid.'/'.$term->name.'<br>';
if(!$insertar){
drupal_set_message('Invalid query: ' . mysql_error());
}//end check if there is problem with the insert
}//end inf there is db connetcions
}
}
$output .= '<br>Due to the smf forum structure now we don\'t migrate it yet';
return $output;
//cache_clear_all();
}
I mean, I don't use the same key,but seems that when I try to insert an ID_CAT, it try to insert 255
Thanks
Oskar
Quote from: sharks on July 07, 2010, 09:11:16 AM
BTW, could you build your module so that it's compatible with SMF 1.1 primarily. I mean, compatibility with SMF 2.0 would also be good, but SMF 1.1 is the stable version, so it is preferred.
It's not hard, I only need time, I hope my boss let me to make a debug of the module, but Drupal forum it's really easy, and know that I understand smf forum database (more or les), It should not be hard.
Oskar
Oskar, please take a look at: http://www.simplemachines.org/community/index.php?topic=274252.0#post_high_board_ids
Quote from: TE on July 07, 2010, 11:25:31 AM
Oskar, please take a look at: http://www.simplemachines.org/community/index.php?topic=274252.0#post_high_board_ids
I'm checking it and seems that I will need recount categories and recount boards.
Thanks.
Oskar
Hello I'll need help.
I'd ready a sanbox, so if some one want to help me I'd give access to a ftp acount to "change" something.
Now the problem is that I load the categories, and you can not see them.
Also I have move the boards, and they seems to have lost the categories.
If there is any function to load boards or categories, it will help me a lot.
Thanks,
Oskar.
I have around of the 85% of the work done.
Oskar
Quote from: Oskar Calvo on July 12, 2010, 07:36:29 AM
I have around of the 85% of the work done.
Oskar
Great job, Oskar. :)
Hello the module is almost 90% done.
But I have a few problems, the first I don't know how to put a spanish theme to check the spanish specials characters (in the database it works, but in the theme I see it strange characters).
I don't know why I'm not able to load a small part of the main home page:
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi20.photobucket.com%2Falbums%2Fb215%2Foskar123%2FCapturadepantalla2010-07-13alas1-1.png&hash=11b9e8c7399cad27b2626c0f1d8c91e60e4862f6)
But as can be see here
(https://www.simplemachines.org/community/proxy.php?request=http%3A%2F%2Fi20.photobucket.com%2Falbums%2Fb215%2Foskar123%2FCapturadepantalla2010-07-13alas1407.png&hash=667bdae31a12c86e7f3123a0925773a84e55e673) in the other part of the forum it's working well.
I need to update the module to let people to add it's ddbb, user ddbb, user pass and prefix
Oskar
I think it would be simpler and better if you just coded the converter for English only. And then release subsequent updates to make it compatible with other languages. Most people use only English in their forums, so it's a good idea to release it for the majority meanwhile.
Quote from: sharks on July 13, 2010, 07:29:57 PM
I think it would be simpler and better if you just coded the converter for English only. And then release subsequent updates to make it compatible with other languages. Most people use only English in their forums, so it's a good idea to release it for the majority meanwhile.
Hello Sharks, my Idea is to create a function that let people to choose if they want utf8 or not to move the information from one ddbb to another ddbb.
The main problem now is to find why is not print in the home the information of the last post (date) and the last author. There is any kind of cronjob in smf?
Oskar
Oskar, I've seen a lot of conversions where you'll need to run both:
-> Find and repair any errors
-> Recount all forum totals and statistics
in Admin -> Forum Maintenance
Before this shows successfully.
Thanks xenovanis.
I have "change" one smf theme so it can be use as iframe with drupal. I have comment some code so now it's not posible to login or log out using smf if there is a iframe of Drupal.
The module is near 95%, although I'm thinking in a version x.2 in witch the move of the cat from drupal to smf will through a temporal table.
Thanks
Oskar
To finish the smf theme I' like to know if there is anyway to get the base path or domain of the url.
I need to build a link to login, but as the Master will be Drupal, I need to login through Drupal, and if I get the base_path or domain I can built a link that will works in every Drupal+smf installation.
Thanks
Oskar
I have re-done some part of the module, I make 2 temporal tables, and them to create the new id to category and to boards.
I'd like to migrate the avatar, but I don't understand what it's save in the avatar field in the smf database.
and now I'm with the form to get the smf mysql server connections.
Thanks
Oskar
Quote from: Oskar Calvo on July 21, 2010, 08:58:10 AM
I'd like to migrate the avatar, but I don't understand what it's save in the avatar field in the smf database.
To what avatar field(s) are you referring?
-----
Thank you very much for the work you've been doing. It is very appreciated and I'm sure many people will think the same way!
Oskar Calvo, you have my gratitude, appreciation and respect for being the only one who is actually willing and able to fix this broken converter.
THANK YOU!
Quote from: Norv on July 21, 2010, 09:05:11 AM
To what avatar field(s) are you referring?
Hello Norv_link
I'm looking at members table to take a look at avatars field, but it's always empty. I have realize today that avatars information is stored in attachments table :0
Oskar
Quote from: sharks on July 21, 2010, 02:49:47 PM
Oskar Calvo, you have my gratitude, appreciation and respect for being the only one who is actually willing and able to fix this broken converter.
THANK YOU!
Thanks sharks, but you now that floss software work like this, some one need something, and when he/she finish with it share with the others.
I hope to upload it soon in drupal.org, I'm fighting now with the drupal's svn, it's my first time with it.
Oskar
Quote from: Oskar Calvo on July 22, 2010, 03:39:05 AM
Quote from: Norv on July 21, 2010, 09:05:11 AM
To what avatar field(s) are you referring?
Hello Norv_link
I'm looking at members table to take a look at avatars field, but it's always empty. I have realize today that avatars information is stored in attachments table :0
Oskar
Yes, you're right. :) The avatar
uploaded by the user is treated more like any attachment and it's stored in the attachments table, for member_id.
The avatar field in members table is used only in the other two cases:
- if the member chooses an avatar from the set available by default with SMF,
- or if he/she chooses an external avatar (and this external avatar is not downloaded to the forum's server, in which case we're basically in the case "uploaded by the user" again).
Here is a link to download, I'd would like that someone from smf test it, because I'm not sure it I have move all the information.
The strange thing is that in my computer it works great, in an internet server I move all the information, but the forum don't show it properly, seems that I loose information somewhere.
Please test it to find bug.
Thanks
Oskar
http://www.box.net/shared/oajlh4pd2o (http://www.box.net/shared/oajlh4pd2o)
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
error message
Converting...
Converting members...Duplicate entry '3499' for key 'PRIMARY'
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?
Thanks.
Error message:
Converting members... Successful.
Converting categories...Unknown column 'catorder' in 'field list'
Can you please tell, to what version of SMF are you converting?
Drupal version : Drupal 6.2
SMF version : SMF 2.0 RC3
I 'd downloaded the converter from this link;
http://download.simplemachines.org/?converters;software=drupal
http://download.simplemachines.org/index.php?thanks;filename=smf_2-0-rc3_drupal62_converter.tar.gz
Thanks.
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 :-\
check out the first post from this topic, you need the drupal_migration.php
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 = '';
the drupal_migration.php needs to be placed inside the Drupal folder..
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
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!
J3SUS,
which version of drupal do you use?
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.
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.
idem error
Converting...
Converting members... Successful.
Converting categories...Unknown column 'catorder' in 'field list'
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.
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
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.