[SMF Converter] Dragonfly CMS 9.2.x

ThorstenE · September 21, 2008, 08:34:09 AM

Software: Dragonfly CMS (Forum)
Version: 9.2.x

This is the official support topic for Dragonfly CMS converter. Use this topic to ask for support for this converter.

Note: This was tested on Dragonfly CMS 9.2.1 but should in theory work on other versions of Dragonfly if the database changes have not been to great.

Changelog

convert.php
Use this convert.php with the .sql file attached in this topic.

The_Rogue · September 22, 2008, 05:42:17 PM

When we tried to do the conversion after installing smf...the conversion basically duplicated the files into our dragonfly files and left our site useless with an error: Unable to connect to the DB.
It also did not convert any of the forum files to the smf installation. The SMF installation also became useless and gave the same error when trying to load the page. I don't know where we made an error or if this has been a problem with anyone else. Luckily we had the DB backedup and were able to do a restore.

SleePy · September 22, 2008, 09:47:35 PM

The converter does not alter any data in Dragonfly nor anything else.
It simply selects data from the other software and converts it to be inserted into the SMF database.

Are you sure both sites had the same exact error? SMF does throw different error messages when it gets a database error than what you explained.
It may be possible the converter was making to many selects and inserts than your host allowed in a period of time. You should ask your host about this.

ThorstenE · September 23, 2008, 01:45:01 AM

The only way to destroy your Dragonfly is to upload the SMF installation files into the same folder already used by the Dragonfly CMS. If you create a subfolder it's nearly impossible to destroy Dragonfly because

QuoteThe converter does not alter any data in Dragonfly nor anything else.

Example: from your browser it should look like this:
http://www.example.com (for Dragonfly)
http://www.example.com/smf (for SMF)

The_Rogue · September 23, 2008, 06:30:52 PM

I got it all fixed and have SMF installed as this path.

www.oursite.com/smf

I have the converter and the dragon to smf installed in that smf directory.

Now when I try to do the conversion it doesn't find our dragon fly.
this is the 2 paths it selected.

/hsphere/local/home/patientk/"oursite".com/smf

/hsphere/local/home/patientk/"oursite".com/smf <<< this one said it needed changing. So I changed the path to this:

/hsphere/local/home/patientk/equal-2-none.com/themes/dragonfly

this got me an error that says"Unable to find the settings for DragonFly 9.2. Please double check the path and try again."

I went into our file manager for the site and navigated to the dragonfly folder to get the correct path.

Does anyone have any suggestions on what I can do to check why it is saying the path isn't correct??

The_Rogue · September 23, 2008, 07:07:39 PM

A quick update. I got it installed and converted....but on my other sites with SMF I have a full installation...this one doesnt have all the available buttons at the top for navigation..........So I have no admin button....which means I cannot add mods or change the appearance of the forums and so on.

SleePy · September 23, 2008, 09:04:03 PM

I accidentally deleted my admin account, what do I do?

That doc should help you in the process of making your user account an admin user

Sport Twin · June 27, 2009, 06:59:20 PM

Dragonfly is surely dying so I would expect more of us to revisit this thread.

I managed to do the conversion but for some reason it didn't grab the member date registered info:

u.user_regdate AS dateRegistered

So now all of my members have a registered date of 1969-12-31.

Obviously I can grab a csv via phpMyAdmin but since I'm not real good with MySQL I'm wondering how I would go about importing that particular field and keep it coordinated with my users (over 9700).

I have my DF site locked down right now because of security issues... DF just isn't keeping up with the code, so I'd appreciate some help so I can get my forums back up and running on SMF.

Their DOB would be nice to have as well... I'll add that info.

Right now my info is in:

Table: nuke_users
Field: user_regdate
Field: dob

The field user_id probably needs to be referenced to keep things in order... I think.

Then my SMF 2.0 RC 1-1 is of course:

Table: smf_members
Field: date_registered
Field: birthdate

The the user ID field is id_member.

Again, my db is fully populated with members and their corresponding data and posts...just needs the registration date fixed.

Thanks,

Brad

ThorstenE · June 28, 2009, 02:11:05 AM

can you please check the format of dates in the field user_regdate from DragonFly via phpMyAdmin? Is this a timestamp (e.g. 112332233) or is it a normal date (2007-04-12)?

Sport Twin · June 28, 2009, 03:23:45 AM

DF is: Aug 28, 2000

U.S. style date.

I appreciate your help. I'm having to evaluate and convert on the fly. Right now I have various levels of functionality in phpBB2 and 3, SMF 2.0 and may try VB but I really am liking SMF.

The good news is that your script converted my attachments...there were quite a few, many supporting technical docs for the forums... that is VERY good and I really like SMF's thumbnail/attachment functions.

Now if I could just figure out how to convert my DF Coppermine galleries over to something... 1400 photos that I sure hate for my members to either lose or have to reupload. But one thing at a time.

Then it's on to my stories/news....

ThorstenE · June 28, 2009, 05:34:40 AM

You can use the Coppermine Gallery (standalone) and activate the Bridged-Mode for SMF or check SMG http://custom.simplemachines.org/mods/index.php?mod=1365 (there is a converter for CPG available)

for the dates:
in dragonfly9_to_smf.sql find:

Code Select

$row['signature'] = substr($row['signature'], 0, 65534);
add after:

Code Select

$calcdate = date_parse($row['dateRegistered']);
$row['dateRegistered'] = mktime(0, 0, $calcdate['day'], $calcdate['month'], $calcdate['year']);

Sport Twin · June 28, 2009, 09:18:52 AM

...and just rerun the sql file? I'll need to dump the existing db won't I?

What would it take to grab the dob while I'm at it?

I had SMG installed but am having problem with the user albums created by apache:

http://smf-media.com/community/index.php?topic=920.0

Haven't had any love yet on fixing that issue. The converter is for a standalone Coppermine install, unfortunately the DF fork is a module and quite a bit different, might could be made to work somehow but it is beyond me.

Thanks again for your help... I sure need it!

ThorstenE · June 28, 2009, 09:45:58 AM

after changing the date calculation (my post above) you have to re-run the entire conversion process (don't !! do it if your SMF is already productive).

SMG: I'm not familar with this modification and / or the CPG Conversion at all. You'll better ask the authors at: http://smf-media.com/

Sport Twin · June 28, 2009, 09:56:58 AM

I have everything locked down until I finish the conversion process so the data stays consistent.

Anyway to grab the dob data?

If you were in the U.S. i'd send wine, women and song....but I don't think the postal service would appreciate me shipping a singing drunk woman to Germany.... thanks again!

Sport Twin · June 28, 2009, 01:10:26 PM

I just can't get a break today....

Did the whole conversion process again but...

Date Registered: July 15, 2019, 05:00:00 PM

but should be Aug 28, 2000 for the particular user (me).

The SMF db shows 1563253200 in the dateRegistered field.

Hmmm... now looking at the DF db it shows 967438800 in user_regdate.

I see what happened. I am dealing with about 5 databases while converting and trying to see what works and what doesn't. I must have looked at the DF 9.0.5.0 db instead of the 9.2.1. The earlier version uses the normal date range while the new db uses 967438800.

My bad...

Sure hate to ask you to do this twice but could you edit and help me out again?

ThorstenE · June 28, 2009, 01:40:44 PM

967438800, that's a normal unix timestamp (same format as used by SMF) and no change is required (you don't need my changes from above).

Sport Twin · June 28, 2009, 02:07:40 PM

Doing the conversion now. That seems to be working ok. Not sure why it didn't the first time.

Thank you once again.

I'll send PayPal if I could get the DOB converted as well!

I'm will need to import my stories/news and categories at some point... whether it's a SMF portal, Joomla or WordPress... interested?

I have another site with fewer members and posts but well over 5500 news articles that are VERY important to me.

Thanks,

Brad

ThorstenE · June 28, 2009, 02:40:24 PM

Sorry, but I'm very busy at the moment and don't have the time to work on a new converter in the near future..

Sport Twin · June 28, 2009, 02:45:24 PM

Baahh... now it's not grabbing the attachments. The attachments table is empty... actually I have a backup db, maybe I'll try copying over that table and see what happens.

....and what does it take to get rid of the Verification image above on these forums... driving me nuts to post.

ThorstenE · June 28, 2009, 02:51:52 PM

Quote from: Sport Twin on June 28, 2009, 02:45:24 PM
....and what does it take to get rid of the Verification image above on these forums... driving me nuts to post.

sorry, that's our Anti-Spam protection (only for Users with less than 10 posts)

Sport Twin · June 28, 2009, 03:14:03 PM

Now I'm getting random errors in posts with attachments:

Duplicate entry '0' for key 'PRIMARY'
File: /home/buellman/domains/domain.com/public_html/forums/Sources/Display.php
Line: 1187

I can go maintain the attachments and every once in awhile it will find one and fix it then it will be broke again.

Any ideas?

Sport Twin · June 28, 2009, 03:34:00 PM

Copied over the attachments table from yesterday's backup, for the most part it's good now except for the random error above which kills that particular post when it happens.

Then I noticed it didn't capture the IP addresses, not a big deal but again I just copied over my db backup for the messages table and it's all good now.

Now, if I could just track down this error.

I ran the fix attachments script after I had already uploaded the attachment files ....can't see where that would do it.

SleePy · July 05, 2009, 05:11:42 PM

The primary key was missing for the attachments table. Simply going into phpmyadmin, viewing the attachments table structure and adding it back would of fixed this.

dlth · May 17, 2010, 11:52:53 PM

Converting members...Wrong value type sent to the database. Integer expected. (id_group)

I use Dragonfly 9 to SMF 2-0-rc3 and see this error

Norv · May 18, 2010, 05:18:08 AM

Hey there!

Please, try the attached file, instead of yours.
Note that it will need the avatars directory to be writable for PHP, in order to work properly (to copy your gallery avatars to SMF avatars). Writable for PHP typically means having permissions like 777, if Apache is run under some default user of his own, or 755 if Apache is run as your user.

cavey · May 27, 2010, 10:34:54 PM

Hello all,

Am trying to convert my dragonfly cms 9.2 to SMF. I managed to install 1.1.11 (the latest version) and got everything up and running and downloaded the convert and the new dragonfly9_to_smf.sql from the above, however when i try to convert my website i get the following instantly.

Can any one advice me what i am doing wrong? Thanks in advance!

Converting...
Converting ranks... Unsuccessful!
This query:

DELETE FROM `xxx_smf`.smf_membergroups
WHERE group_name LIKE 'phpBB %';

Caused the error:

Unknown column 'group_name' in 'where clause'

ThorstenE · May 28, 2010, 01:02:32 AM

I'm almost sure you are using the wrong converter files (2.0 Converter instead of the 1.1.x converter).. please download the 1.1.x converter and try it again..

cavey · May 28, 2010, 08:34:21 AM

Thank you TE, actually the converter version was correct but i think i used the wrong version of the sql file (should have used the one in the thread starter instead of the one a few posts above.)

Anyway problem is solved!

Thank you.

cavey · July 09, 2010, 12:45:26 PM

Hello again TE,

Am trying out a fresh install for SMF2.0 RC3 and when running the converter for dragonfly to SMF2.0 i came across this error. What does this refer to?

I can pull out and restore the backup for SMF1.0 but was wondering what went wrong?

Thanks again in advance!

Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)...Wrong value type sent to the database. Integer expected. (modified_time)

Norv · July 19, 2010, 04:18:18 PM

Please open in a code editor the file dragonfly9_to_smf.sql, and:

Code (find) Select


p.post_edit_time AS modified_time,

Code (replace) Select


IFNULL(p.post_edit_time, 0) AS modified_time,

Radek · November 09, 2010, 08:24:35 AM

Quote from: The_Rogue on September 23, 2008, 07:07:39 PM
A quick update. I got it installed and converted....but on my other sites with SMF I have a full installation...this one doesnt have all the available buttons at the top for navigation..........So I have no admin button....which means I cannot add mods or change the appearance of the forums and so on.

Could you tell how you solve it?
I have the same problem, i got two folders and i get the same text.

Thanks

ThorstenE · November 09, 2010, 04:46:41 PM

I accidentally deleted my admin account, what do I do?

Dylert · June 13, 2011, 08:53:25 AM

I have a Dragonfly CMS (DF) site and maybe I will move it SMF. I have made a test site with DF, and used the converter to convert it to SMF. It worked very well! Now I'm wondering if it is possible to move my Coppermine gallery as well? I have 6000 pictures in it, so I can't do it manually. I also have ForumsPro on my site....how do I move that??

Any suggestions?

Dylert · June 17, 2011, 03:18:34 PM

I have now started to convert my Dragonfly CMS site to SMF. First I converted my ForumsPro installation fo Forums, but when I use the smf-converter i get this error:

QuoteConverting topics...Duplicate entry '5978' for key 1

Does anybody know how to fix this? Is the error in the Dragonfly table or in the SMF-table?

I have also converted a new (fresh and clean) Dragonfly site with the SMF-converter and it worked perfect.

Secureas · December 26, 2012, 10:27:32 PM

I am looking at converting to SMF I was in the process when I got this error.

Converting ranks... Successful.
Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics...Wrong value type sent to the database. Integer expected. (id_member_updated)

Any help would be appreciated..

Thanks

Ok the previous problem is fixed now I am running into this and having a hard time understanding this one.

[27-Dec-2012 00:14:59] PHP Warning: array_combine() [<a href='function.array-combine'>function.array-combine</a>]: Both parameters should have an equal number of elements in /home/XXXXXX/public_html/smfbbs/Sources/Subs-Db-mysql.php on line 624
The database value you're trying to insert does not exist: int

Here is the result after a clean instal and not checking the utf8 option on the converter:

Converting...
Converting personal messages (step 2)...
Successful.
Converting topic notifications... Successful.
Converting board access... Successful.
Converting group access...
Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in /home/xxxxxxx/public_html/smfbbs/Sources/Subs-Db-mysql.php on line 624
The database value you're trying to insert does not exist: int

I have no db that is int?

Ok I have deleted the groups from my Dragonfly install and it seems to have gone a bit further now:

Converting personal messages (step 2)...
Successful.
Converting topic notifications... Successful.
Converting board access... Successful.
Converting group access... Successful.
Converting moderators... Successful.
Converting avatar gallery images... Successful.
Converting censored words... Successful.
Converting reserved names... Successful.
Converting attachment mod (if installed)...
Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in /home/secureas/public_html/smfbbs/Sources/Subs-Db-mysql.php on line 624
The database value you're trying to insert does not exist: int

More in the morning...

Thanks

Ok it's the next morning and still no progress, I repaired the DB and sychronized the attachments still hung up at this point:

Converting avatar gallery images... Successful.
Converting censored words... Successful.
Converting reserved names... Successful.
Converting attachment mod (if installed)...
Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in /home/secureas/public_html/smfbbs/Sources/Subs-Db-mysql.php on line 624
The database value you're trying to insert does not exist: int

Thanks

UPDATE: Ok got it figured out, I attached the update SQL file that worked for me.

Warwick Chapman · January 02, 2013, 08:09:55 AM

Happy holiday holas to you all

I am busy with test migration from Dragonfly CMS 9.2 to SMF. Because my SMF 2.x conversion failed, I have taken advice from various posts on this forum and started from SMF 1.1.x and tried to convert from there. However, the 1.x conversion is failing too complaining:

Converting topics... Unsuccessful!
....
Caused the error:
Duplicate entry '318197-18' for key 3

From what I can see this is the result of topics which were moved or merged. I have converted to phpBB 3 and it did so without complaint - so the source DB can't be horrific.

Any pointers?

News:

[SMF Converter] Dragonfly CMS 9.2.x

ThorstenE

ThorstenE

Sport Twin

ThorstenE

Sport Twin

ThorstenE

Sport Twin

ThorstenE

Sport Twin

Sport Twin

ThorstenE

Sport Twin

ThorstenE

Sport Twin

ThorstenE

Sport Twin

Sport Twin

ThorstenE

ThorstenE