News:

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

Main Menu

[SMF Converter] Fireboard 1.0.x

Started by SleePy, March 17, 2008, 12:28:51 AM

Previous topic - Next topic

SleePy

Software: Joomla
Version: 1.0.x

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

Changelog
! Fireboard Login Fix didn't account for old style logins
! Expanded the SMF salt to 50 characters for Joomla 1.5 passwords
! Avatars conversion was missing a quote and used incorrect path

Password Support
To be able to login again after you complete the conversion, You will simply need to apply the Fireboard_Login_Fix.tgz modification (attached below) via Package Manager.

Joomla 1.5 Users
For the converter script to work you will need to open your configuration.php file and at the very start after the <?php add return then these lines:

$config = new JConfig();
$mosConfig_db = $config->db;
$mosConfig_dbprefix = $config->dbprefix;


convert.php
Use this convert.php with the .sql file attached in this topic.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

forepro


Thanks for this tool.  :)

If I have a smf and I try to convert a Fb to my existing smf, what will happen to those duplicated usernames?  Take mine as an example, will there be something like a forepro (initially in smf) and a forepro2 (from FB)? And I assume the previous posts would be linked to the authors accordingly, right?

Sorry for the dumb question... I am new here.  ;D


shumisha

Hi there,

Thanks for the converter. Seems to work OK, though I had a couple of glitches, most of them I can live with:
1 - Avatar not transferred, there was a syntax error in eval code on line 1075
2 - Password seems to not be transferred properly. I did not apply your fix BEFORE doing the conversion, so I was unable to login and install it afterwards ! Anyway, I changed idgroup in the DB from 0 to 1, had a new password request emailed and I can log back in.
3 - Problem I can't live with : all single and double quotes are escaped now. My target SMF is using UTF-8 (installed through my host fantastico). Source is ISO8951. Could that be the problem ? should I try install using ISO on the target smf ?

Thanks for any pointer on the latter item!

Regards

ChrisFBBS

I am having trouble with this converter.  I keep getting this error "
The error MySQL gave was: No Database Selected" The password I am providing in convert.php is correct
www.freeblackberrystuff.com Blackberry neews plus... free blackberry themes free blackberry apps and free blackberry games

JazzMega

Hi all, I have a problem converting fireboard to SMF.

When I use the convert.php file with fireboard_to_smf.sql   it display this error:

Notice: Undefined variable: mosConfig_db in /...................../smf/convert.php(398) : eval()'d code on line 1

Notice: Undefined variable: mosConfig_dbprefix in /........................./smf/convert.php(398) : eval()'d code on line 1
Incorrect database name ''


Can you help me? thanks you very much

SleePy

Quote from: forepro on March 18, 2008, 10:51:00 AM

Thanks for this tool.  :)

If I have a smf and I try to convert a Fb to my existing smf, what will happen to those duplicated usernames?  Take mine as an example, will there be something like a forepro (initially in smf) and a forepro2 (from FB)? And I assume the previous posts would be linked to the authors accordingly, right?

Sorry for the dumb question... I am new here.  ;D

All previous user data from SMF will be deleted. The converter empties the tables before inserting data into them.

Quote from: shumisha on March 18, 2008, 01:25:11 PM
Hi there,

Thanks for the converter. Seems to work OK, though I had a couple of glitches, most of them I can live with:
1 - Avatar not transferred, there was a syntax error in eval code on line 1075
2 - Password seems to not be transferred properly. I did not apply your fix BEFORE doing the conversion, so I was unable to login and install it afterwards ! Anyway, I changed idgroup in the DB from 0 to 1, had a new password request emailed and I can log back in.
3 - Problem I can't live with : all single and double quotes are escaped now. My target SMF is using UTF-8 (installed through my host fantastico). Source is ISO8951. Could that be the problem ? should I try install using ISO on the target smf ?

Thanks for any pointer on the latter item!

Regards
1. Can you post the full error you are getting?

2. Are you running Joomla 1.0.15? The password fix was based off a 1.0.15 install. Joomla seems to put the password salt (which is longer than the SMF salt) and hashed password in the same field in the database. So the upgrader will alter your SMF members table and make the salt column bigger and then it attempts to split the password and salt appart by the separator. The login fix just makes it so SMF can find this new login method and upgrade it to its style.

3. Is that only on posts or everything (ie user signatures, fields, emails, etc).

Quote from: JazzMega on March 18, 2008, 08:52:03 PM
Hi all, I have a problem converting fireboard to SMF.

When I use the convert.php file with fireboard_to_smf.sql   it display this error:

Notice: Undefined variable: mosConfig_db in /...................../smf/convert.php(398) : eval()'d code on line 1

Notice: Undefined variable: mosConfig_dbprefix in /........................./smf/convert.php(398) : eval()'d code on line 1
Incorrect database name ''


Can you help me? thanks you very much

What version of Joomla are you using?
Did you point it to your root path of your joomla install where your configuration file is?
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

JazzMega

the version of joomla is 1.5.1.

yes.

Sorry for my bad english

Thanks you very much!

forepro

Quote from: SleePy on March 18, 2008, 09:47:00 PM

All previous user data from SMF will be deleted. The converter empties the tables before inserting data into them.

OK I see. Thanks for the clarification.

ChrisFBBS

Now I get that same error as posted above.
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /xxxxxxxxx/convert.php on line 780

Notice: Undefined variable: mosConfig_db in /xxxxxxx/convert.php(398) : eval()'d code on line 1

Notice: Undefined variable: mosConfig_dbprefix in /xxxxxxxxxx/convert.php(398) : eval()'d code on line 1
No Database Selected


I am using Fireboard 1.0.4and SMF 1.1.4

Thanks again for any help.
www.freeblackberrystuff.com Blackberry neews plus... free blackberry themes free blackberry apps and free blackberry games

SleePy

Quote from: JazzMega on March 18, 2008, 09:52:07 PM
the version of joomla is 1.5.1.

yes.

Sorry for my bad english

Thanks you very much!

I wasn't aware that this worked for Joomla 1.5. This was tested on Joomla 1.0.15..
Does Fireboard work with Joomla 1.5?
I can try to install it but if I remember right I had issues because it needed legacy mode to install fireboard 1.0 on joomla 1.5

Quote from: sheik28 on March 19, 2008, 12:36:09 AM
Now I get that same error as posted above.
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /xxxxxxxxx/convert.php on line 780

Notice: Undefined variable: mosConfig_db in /xxxxxxx/convert.php(398) : eval()'d code on line 1

Notice: Undefined variable: mosConfig_dbprefix in /xxxxxxxxxx/convert.php(398) : eval()'d code on line 1
No Database Selected


I am using Fireboard 1.0.4and SMF 1.1.4

Thanks again for any help.

What version of Joomla are you using?
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

ChrisFBBS

Joomla: 1.5.0 sorry I should have posted that.
www.freeblackberrystuff.com Blackberry neews plus... free blackberry themes free blackberry apps and free blackberry games

shumisha

Hi,

Quote1. Can you post the full error you are getting?
Unfortunately, I can't as I will have to redo a conversion. That will happen in the next couple of days, and I will report back

Quote2. Are you running Joomla 1.0.15? The password fix was based off a 1.0.15 install. Joomla seems to put the password salt (which is longer than the SMF salt) and hashed password in the same field in the database. So the upgrader will alter your SMF members table and make the salt column bigger and then it attempts to split the password and salt appart by the separator. The login fix just makes it so SMF can find this new login method and upgrade it to its style.
I am using J! 1.0.13. This is the version where the new password mechanism was introduced. Indeed, from that version on, a salt was added. This is stored as password_md5:salt in the previously existing password field. I can see a potential problem here because Joomla upgrades automatically the stored password to the new format upon first connection of a user. Say I was running 1.0.12, passwords are stored as md5 only. Then I upgrade to 1.0.13 or more. Whenever a user login for the first time after the upgrade, J1.0.13 sees that the password is stored as old format and adds the salt.
Consequence of this is that there are some passwords stored both way : users who have logged in since the upgrade have their password as md5(pass):salt. Users who have not logged in since the upgrade have their password as md5(pass) only. Do you / can you handle this ?

Quote3. Is that only on posts or everything (ie user signatures, fields, emails, etc).
I had a hard time finding a user with a quote in its signature, but I did and I can confirm they are escaped as well. I would not expect to find emails with single or double quote.

Hope this helps

JazzMega


Quote

I wasn't aware that this worked for Joomla 1.5. This was tested on Joomla 1.0.15..
Does Fireboard work with Joomla 1.5?
I can try to install it but if I remember right I had issues because it needed legacy mode to install fireboard 1.0 on joomla 1.5

Yes, you need enable the legacy mode to install fireboard 1.0 on joomla 1.5.

So, it is imposible to convert? Can I convert joomla 1.5 to 1.0.1...???

Thanks you very much!

SleePy

Quote from: shumisha on March 19, 2008, 04:06:44 AM
Hi,

Quote1. Can you post the full error you are getting?
Unfortunately, I can't as I will have to redo a conversion. That will happen in the next couple of days, and I will report back

Quote2. Are you running Joomla 1.0.15? The password fix was based off a 1.0.15 install. Joomla seems to put the password salt (which is longer than the SMF salt) and hashed password in the same field in the database. So the upgrader will alter your SMF members table and make the salt column bigger and then it attempts to split the password and salt appart by the separator. The login fix just makes it so SMF can find this new login method and upgrade it to its style.
I am using J! 1.0.13. This is the version where the new password mechanism was introduced. Indeed, from that version on, a salt was added. This is stored as password_md5:salt in the previously existing password field. I can see a potential problem here because Joomla upgrades automatically the stored password to the new format upon first connection of a user. Say I was running 1.0.12, passwords are stored as md5 only. Then I upgrade to 1.0.13 or more. Whenever a user login for the first time after the upgrade, J1.0.13 sees that the password is stored as old format and adds the salt.
Consequence of this is that there are some passwords stored both way : users who have logged in since the upgrade have their password as md5(pass):salt. Users who have not logged in since the upgrade have their password as md5(pass) only. Do you / can you handle this ?

Quote3. Is that only on posts or everything (ie user signatures, fields, emails, etc).
I had a hard time finding a user with a quote in its signature, but I did and I can confirm they are escaped as well. I would not expect to find emails with single or double quote.

Hope this helps

That would be helpful to know the error. The error may be foreign to some people, but script developers usually understand their meaning.

Can you test something?
Open LogInOut.php in your SMF Sources folder

Find:
        // Maybe they are using a hash from before the password fix.

Before that add this:
            $other_passwords[] = md5($_POST['passwrd']);

Are you able to login using the old joomla method now?


Quote from: JazzMega on March 19, 2008, 08:02:50 AM

Quote

I wasn't aware that this worked for Joomla 1.5. This was tested on Joomla 1.0.15..
Does Fireboard work with Joomla 1.5?
I can try to install it but if I remember right I had issues because it needed legacy mode to install fireboard 1.0 on joomla 1.5

Yes, you need enable the legacy mode to install fireboard 1.0 on joomla 1.5.

So, it is imposible to convert? Can I convert joomla 1.5 to 1.0.1... ???

Thanks you very much!

This wasn't tested on Joomla 1.5.. But I certainly can attempt to look at it tonight/tomorrow when I get some time.
Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

JazzMega

Quote

This wasn't tested on Joomla 1.5.. But I certainly can attempt to look at it tonight/tomorrow when I get some time.

ok, thanks! I´ll visit the community forums every day waiting you.

Best regards

forepro

Hi

I tried it on my local testing server, avatar errors look like this:

Converting avatars...
Parse error: parse error, unexpected '"' in W:\www\forum\convert.php(1075) : eval()'d code on line 6

I use J1.0.12,  FB 1.0.4
MySQL 4.1.14-nt
PHP 4.4.4

Another stupid question is, how could I login after conversion? I understand I need to install Fireboard_Login_Fix.tgz modification, but it seems like my admin account was also dropped so that I couldn't access package manager... ???

Any help would be appreciated!!

shumisha

Hi

Thanks forepro, this is exactly the error I am getting. Except I was not on a local machine but on a typical shared host unix box, with J 1.0.13, FB 1.0., MYSQL 5 and PHP 5.2
As for th elogin fix, I got caught like you, and I think what we need to do is install the fix BEFORE doing the convert!

If you have already done, using phpmyadmin, you can access the smf members table, locate your admin user and change the value in the IDGroup field from 0 to 1. That will put it back to being an admin
I'll await news from here about the quotes being escaped. Did you see that also ?

Regards

SleePy

oh geez, I missed a closing ' a function. I think this one should fix it.

As for the login fix, read my comment above about the edit. I think that will fix it for users that are using joomla before the 1.0.13 fix. If it does, I will add it into the patch that was made.

Jeremy D ~ Site Team / SMF Developer ~ GitHub Profile ~ Join us on IRC @ Libera.chat/#smf ~ Support the SMF Support team!

forepro

#18
Hi

@SleePy Yup! I was able to login after applying this change.

QuoteOpen LogInOut.php in your SMF Sources folder

Find:
// Maybe they are using a hash from before the password fix.
       
Before that add this:
$other_passwords[] = md5($_POST['passwrd']);
So I guess I don't need to install Fireboard_Login_Fix.tgz mod now. Is that right?
Thanks a lot!!

@shumisha

Right now I couldn't read the posts as they are all jargons after conversion. My local server doesn't seem to handle UTF-8 well. But I can definitely see things are being quoted in quote box. Can't read them though. I will try the new file for conversion on my host server later and let you know how it goes.

Hope this helps.  :)

edit: just realize you are mentioning single & double quotes... not quote box.  I can't read them now.. sorry!


ChrisFBBS

I still get that same error that I posted above.
www.freeblackberrystuff.com Blackberry neews plus... free blackberry themes free blackberry apps and free blackberry games

Advertisement: