Advertisement:

Author Topic: [SMF Converter] IPB 2.3.x  (Read 213211 times)

Offline quercus

  • Semi-Newbie
  • *
  • Posts: 17
Re: [SMF Converter] IPB 2.3.x
« Reply #140 on: September 17, 2012, 02:19:57 PM »
Getting there I think:
Converting settings...
Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in /home/hussars/public_html/forums2/Sources/Subs-Db-mysql.php on line 624
The database value you're trying to insert does not exist: variable

ThorstenE

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #141 on: September 17, 2012, 02:26:42 PM »
ok, let's try it without settings (just the forum name and some general information, nothing special)...

Offline quercus

  • Semi-Newbie
  • *
  • Posts: 17
Re: [SMF Converter] IPB 2.3.x
« Reply #142 on: September 19, 2012, 04:31:15 PM »
*Sigh*
Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71

Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71

Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71

Notice: Undefined index: signature in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 71
Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting smileys... Successful.
Converting attachments...
Notice: Use of undefined constant attachmentUploadDir - assumed 'attachmentUploadDir' in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 40

Warning: filesize() [function.filesize]: stat failed for attachmentUploadDir/35_e5a8e6067b12d75363b127c213bc3b2a1e11a16c in /home/hussars/public_html/forums2/convert.php(1254) : eval()'d code on line 40
Wrong value type sent to the database. Integer expected. (size)

ThorstenE

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #143 on: September 20, 2012, 02:39:24 PM »
next one, another two bugs fixed  ;)

Offline quercus

  • Semi-Newbie
  • *
  • Posts: 17
Re: [SMF Converter] IPB 2.3.x
« Reply #144 on: September 23, 2012, 11:04:51 AM »
Excellent - that seems to have finally (more or less) cracked it.
The bb code seems a bit messed up and there are lots of custom images and groups that need to be sorted out, but the basic forum has been converted.

Now I just need to figure out how the member groups, permissions and codes within SMF work!
By the way, I set up a custom bb code that allowed me to embed youtube videos into posts. Is this possible with SMF?

ThorstenE

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #145 on: September 23, 2012, 12:17:58 PM »
By the way, I set up a custom bb code that allowed me to embed youtube videos into posts. Is this possible with SMF?
Not my business but there are a couple of mods for embedding videos:
http://custom.simplemachines.org/mods/index.php?action=search;basic_search=youtube

Offline Nakto

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] IPB 2.3.x
« Reply #146 on: October 19, 2012, 01:02:17 PM »
By the way, I set up a custom bb code that allowed me to embed youtube videos into posts. Is this possible with SMF?
Not my business but there are a couple of mods for embedding videos:
http://custom.simplemachines.org/mods/index.php?action=search;basic_search=youtube
why when I update 2.3.6 to smf 2.0 users passwords is changed. it is not good

ThorstenE

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #147 on: October 19, 2012, 01:09:28 PM »
Nakto,
SMF and IPB are using different password encrytions but SMF should be able to read the old IPB passwords. At first time login the password will be updated to SMF's encryption.

Offline Nakto

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] IPB 2.3.x
« Reply #148 on: October 19, 2012, 03:42:28 PM »
sorry, but i don't understand you.
after convertation I can't login to my forum with my username and password. and nobody of my users too. what should we do?

ThorstenE

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #149 on: October 20, 2012, 02:21:02 AM »
sorry, but i don't understand you.
after convertation I can't login to my forum with my username and password. and nobody of my users too. what should we do?
no clue, maybe the password_salt in IPB has more than 5 characters..

added a modified version of the converter, please try the attached file.

Offline Nakto

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] IPB 2.3.x
« Reply #150 on: October 20, 2012, 09:27:12 AM »
Quote
maybe the password_salt in IPB has more than 5 characters..
yes, my pass have more 5 characters.

Quote
added a modified version of the converter,
without any changes

when i converted forum to smf , converter have a error :
Code: [Select]
Notice: Undefined variable: oldAvatarDir in /home/user566952/smf/convert.php(1254) : eval()'d code on line 58

Warning: copy(/av-124.jpg) [function.copy]: failed to open stream: No such file or directory in /home/user566952/smf/convert.php(1254) : eval()'d code on line 59
 Successful.
 Recalculating forum statistics... Successful.

Offline Nakto

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] IPB 2.3.x
« Reply #151 on: October 20, 2012, 09:39:42 AM »
maybe that can help you : in the table ibf_members_converge i I don't have field password_salt , there is only  а converge_id , converge_email , converge_joined , converge_pass_hash , converge_pass_salt

ThorstenE

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #152 on: October 21, 2012, 03:06:52 AM »
without any changes
You'd better checked my file:

Code: [Select]
ALTER TABLE {$to_prefix}members
CHANGE COLUMN passwd passwd varchar(64) NOT NULL default '',
CHANGE COLUMN password_salt password_salt varchar(64) NOT NULL default '';

maybe that can help you : in the table ibf_members_converge i I don't have field password_salt , there is only  а converge_id , converge_email , converge_joined , converge_pass_hash , converge_pass_salt
password_salt is a field in SMF (table smf_members)

Which charset / language is your forum?

Offline Nakto

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] IPB 2.3.x
« Reply #153 on: October 21, 2012, 04:44:09 AM »
Which charset / language is your forum?
IPB and SMF in win-1251 / english

ThorstenE

  • Guest
Re: [SMF Converter] IPB 2.3.x
« Reply #154 on: October 21, 2012, 01:52:15 PM »
win-1251 / english
That's most likely the reason.

I'm sorry, but you'll have to use the "forgotten password" link.

Offline Frank496

  • Newbie
  • *
  • Posts: 7
Re: [SMF Converter] IPB 2.3.x
« Reply #155 on: October 22, 2012, 12:02:18 AM »
I have an ipb sql database and an smf sql database combined as one.  I need to convert the ipb to smf but it seems to cause errors because of duplicate member ids.  Is there a way around this?

Offline R1cho

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] IPB 2.3.x
« Reply #156 on: December 06, 2012, 04:45:11 PM »
hi , where can i download the convert.php file? i tried clicking the link on your first post and i just keep going in circles clicking on links  :o

Offline 0djvu0

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 2.3.x
« Reply #157 on: April 01, 2014, 01:32:52 AM »
Hi,
i get this error: Unknown system variable 'SQL_MAX_JOIN_SIZE'
What to do? IPB 2.3.6 use XAMPP

Offline margarett

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 19,761
  • Gender: Male
Re: [SMF Converter] IPB 2.3.x
« Reply #158 on: April 01, 2014, 07:52:13 AM »
Are you using this converter?
http://download.simplemachines.org/index.php?thanks;filename=smf_2-0_invision23_converter.zip

In convert.php you should find:
Code: [Select]
// Attempt to allow big selects, only for mysql so far though.
if ($smcFunc['db_title'] == 'MySQL')
{
$results = $smcFunc['db_query']('', "SELECT @@SQL_BIG_SELECTS, @@SQL_MAX_JOIN_SIZE", 'security_override');
list($big_selects, $sql_max_join) = $smcFunc['db_fetch_row']($results);

// Only waste a query if its worth it.
if (empty($big_selects) || ($big_selects != 1 && $big_selects != '1'))
$smcFunc['db_query']('', "SET @@SQL_BIG_SELECTS = 1", 'security_override');

// Lets set MAX_JOIN_SIZE to something we should
if (empty($sql_max_join) || ($sql_max_join == '18446744073709551615' && $sql_max_join == '18446744073709551615'))
$smcFunc['db_query']('', "SET @@SQL_MAX_JOIN_SIZE = 18446744073709551615", 'security_override');
}
Remove it.
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

Quote
Over 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Offline martinmike2

  • Newbie
  • *
  • Posts: 4
Re: [SMF Converter] IPB 2.3.x
« Reply #159 on: September 18, 2014, 05:26:21 PM »
Followed the advice posted earlier in this thread and still getting errors.  Converting IP.Board 2.3.5 to SMF 2.0 using the converter available on the site.

the error is:

Converting calendar events...Error in convert script - line 550!
Error in convert script - line 551!
Wrong value type sent to the database. Date expected. (start_date)