Advertisement:

Author Topic: [SMF Converter] IPB 2.0.x  (Read 112337 times)

Offline sokoll

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] IPB 2.0.x
« Reply #20 on: September 17, 2008, 01:26:18 PM »
Hi!
What's new?

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,931
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.0.x
« Reply #21 on: September 17, 2008, 06:52:46 PM »
Does this one work
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline sokoll

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] IPB 2.0.x
« Reply #22 on: September 20, 2008, 01:34:37 AM »
Hi, sorry! I tested your sript, but it caused an error
I understood that it was a test base -  MySQL 5.0.45, but real one - phpMyAdmin 2.6.3-pl1 MySQL 3.23.58.
Could You help me in this case?

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,931
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.0.x
« Reply #23 on: September 20, 2008, 11:32:59 PM »
Where did you get the first one btw?

What errors are you getting?

I would highly recommend contacting your host and ask about MySQL version and possibly upgrading if they are using such an old version of MySQL (3.23.58). MySQL 4.x.x itself is no longer supported by MySQL AB and so is MySQL 3.x.x.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline sokoll

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] IPB 2.0.x
« Reply #24 on: September 23, 2008, 12:13:52 PM »
Hi, ok! What version MySQL will be better for this converter?

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,931
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.0.x
« Reply #25 on: September 23, 2008, 02:36:09 PM »
Personally I would recommend any MySQL 5 version (I am using the latest 5.0 release which is 5.0.51 5.0.67 I believe) as it is supported by the MySQL AB team and has improvements over the older versions, but even having any version of MySQL 4 would be better than what you currently have.

If you are going to upgrade MySQL, please make sure to read the MySQL documentation on upgrading and have backups incase the worse happens.
« Last Edit: September 23, 2008, 02:44:12 PM by SleePy »
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline sokoll

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] IPB 2.0.x
« Reply #26 on: September 27, 2008, 01:00:09 AM »
Hi, I backup Data Base hosts  MySQL (3.23.58) and restored at localhost ( MySQL 5.0.45). Started converter and it caused an error

"Сonverting...
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting personal messages (step 3)...Error in convert script - line 321!
Error in convert script - line 323!
Error in convert script - line 324!
Error in convert script - line 335!
Error in convert script - line 338!
Successful.
Converting topic notifications... Unsuccessful!
This query:
SELECT pm.ID_PM, m.mt_vid_folder AS folder
FROM `db_premacy`.smf_personal_messages AS pm
INNER JOIN `db_premacy`.ipb_message_topics AS m ON (m.mt_msg_id = pm.ID_PM)
WHERE m.mt_vid_folder = 'sent'
TRUNCATE `db_premacy`.smf_log_notify;
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 'TRUNCATE `db_premacy`.smf_log_notify' at line 5"

Please, give me some recommendations
 

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,931
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.0.x
« Reply #27 on: September 28, 2008, 05:32:59 PM »
Ooops forgot the closing ; on two queries.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline sokoll

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] IPB 2.0.x
« Reply #28 on: September 29, 2008, 10:22:31 AM »
Thank's, but it caused the next error:

"Converting...
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll logs... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting personal messages (step 3)... Successful.
Converting topic notifications... Successful.
Converting board notifications... Successful.
Converting moderators... Successful.
Converting yearly events... Successful.
Converting permissions... Unsuccessful!
This query:
INSERT INTO `db_premacy`.smf_membergroups
(ID_GROUP, groupName, maxMessages, onlineColor, stars)
VALUES
(7 + 3, SUBSTRING('Модераторы', 1, 255), 50, '', '');
Caused the error:

Duplicate entry '10' for key 1"


Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,931
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.0.x
« Reply #29 on: September 29, 2008, 06:49:57 PM »
Alright, hopefully this one gets it.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline sokoll

  • Newbie
  • *
  • Posts: 8
Re: [SMF Converter] IPB 2.0.x
« Reply #30 on: October 07, 2008, 12:13:59 PM »
Hi, thank you! Congratulations, you are  the best!
Converter is finished, but there are some errors. Look file.

Offline SleePy

  • Site Team Lead
  • SMF Master
  • *
  • Posts: 29,931
  • Gender: Male
  • Thats his happy face.
    • jdarwood007 on GitHub
    • @jdarwood on Twitter
    • SleePy Code - My personal site
Re: [SMF Converter] IPB 2.0.x
« Reply #31 on: October 07, 2008, 12:29:24 PM »
Well it appears that a few attachments and some avatars did not convert. If that isn't a worry to you then you can ignore those.

For the avatars not converting it looks like it is missing a setting that tells it where the avatars are uploaded.

For attachments it looks like the attachments path may be incorrect.
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:
GitHub

Offline mestresan

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 2.0.x
« Reply #32 on: August 21, 2010, 05:31:48 PM »
I am trying convert my invision 2.0.3 for SMF, but I receive message:

Converting...
Converting members...Wrong value type sent to the database. Date expected. (birthdate)


Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] IPB 2.0.x
« Reply #33 on: August 25, 2010, 07:10:13 PM »
Can you please make sure to use the last package for download on the Downloads > Converters page, for SMF 2.0 RC3? (or to confirm if you were using it)
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

Offline pk74

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] IPB 2.0.x
« Reply #34 on: September 04, 2011, 10:34:01 PM »
Trying to convert ipb 2.0.4 free hosted to SMF 2.0.

I downloaded the .sql backup of my ipb, imported it into a new database.  Downloaded SMF 2.0, installed it to the SAME db with the same user and perms.   Installed the convert files, created a custom conf_global.php, put it in the correct place, gave it the correct parameters, and the conversion starts...

except..

"Converting...
Converting members...Wrong value type sent to the database. Date expected. (birthdate)"

Any suggestions?

Offline rtil

  • Semi-Newbie
  • *
  • Posts: 51
Re: [SMF Converter] IPB 2.0.x
« Reply #35 on: September 05, 2011, 11:34:35 PM »
Trying to convert ipb 2.0.4 free hosted to SMF 2.0.

I downloaded the .sql backup of my ipb, imported it into a new database.  Downloaded SMF 2.0, installed it to the SAME db with the same user and perms.   Installed the convert files, created a custom conf_global.php, put it in the correct place, gave it the correct parameters, and the conversion starts...

except..

"Converting...
Converting members...Wrong value type sent to the database. Date expected. (birthdate)"

Any suggestions?
i get this as well. there are posts about this all over the forum with no real solution. i'm surprised a major error like this has persisted in the converters.

Offline WesternDigi

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] IPB 2.0.x
« Reply #36 on: May 11, 2017, 03:21:34 PM »
A year ago had to convert my IPB v2.0.* forum to new SMF 2.0.11 version.
It was very hard, but I did it  :D

Improvements I made:
1)Changed old domain "olddomain.org" to "newdomain.com" in every post(even pm).
2)Fixed attachment problem(converter couldnt find them).
3)Fixed all IPB-style links, like "index.php?showtopic=", "index.php?showforum=", "index.php?showuser=" to SMF-style.

Enjoy this script  ;)

P.S: I want to thank the converter.php authors for such a great work !