Advertisement:
NameCheap

Author Topic: [SMF Converter] MyBB 1.6  (Read 91123 times)

Offline Char Aznable

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] MyBB 1.6
« Reply #100 on: November 09, 2011, 01:33:53 AM »
Here is the correct, 100% working, file for converting mybb 1.6.x to SMF 2.0
If you have a problem like slash before quotes  ie: dog\'s in boards, Use that queries:
Code: [Select]
UPDATE smf_boards SET description = REPLACE(description, '\\', '') WHERE description LIKE "%\\\\%";
UPDATE smf_boards SET name = REPLACE(name, '\\', '') WHERE name LIKE "%\\\\%";

If you ever have problems doing this, use this. It will work. Thanks a lot, guys. Great work.

Offline NerdGasm

  • Semi-Newbie
  • *
  • Posts: 19
Re: [SMF Converter] MyBB 1.6
« Reply #101 on: November 10, 2011, 02:07:06 AM »
I'm extremely frustrated at the moment.
I have been wanting to convert my MyBB 1.6 board to SMF 2.0.1.
Thought, neither converter will allow me.
All i keep receiving, even though the files ARE in the correct locations is;

Quote
This converter was unable to find SMF in the path you specified.
Please double check the path, and that it is already installed there.

Please help in any way possible! I need to get this done as soon as possible.

Offline HolyPhoenix

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] MyBB 1.6
« Reply #102 on: November 20, 2011, 01:56:17 AM »
Hi, I am attempting to get this to work with mybb 1.6.3. 

I had a problem with the birthday, but was able to get past it.  But now I am getting this error:
Code: [Select]
Converting posts (this may take some time)...
Successful.
Converting polls...The database value you're trying to insert does not exist: id_member

I looked in the smf database for polls and poll votes.  Both had id_member.  Any clues as to where I should head with this?

Offline pcfreak30

  • Newbie
  • *
  • Posts: 5
Re: [SMF Converter] MyBB 1.6
« Reply #103 on: November 27, 2011, 03:18:08 PM »
Hello, I am trying to convert to SMF for fun to see how it goes. There seems to be an issue with birthdays and the data-type. Not fully sure. I got around it by removing the sql statements, but its still a bug.

Code: [Select]
Wrong value type sent to the database. Date expected. (birthdate)
Now I am getting

 * Converting categories...
Duplicate entry '255' for key 'PRIMARY'

I tried adding

Code: [Select]
ORDER BY id_cat ASC
to

Code: [Select]
WHERE type = 'c' ORDER BY id_cat ASC;
But no dice.

I keep resetting the auto increase counter too.

Any help.

Offline Kryten15

  • Newbie
  • *
  • Posts: 6
Re: [SMF Converter] MyBB 1.6
« Reply #104 on: December 10, 2011, 05:51:29 AM »
Hello,

I've been trying to convert my forum as after a ton of issues from my last host and trying to get all the data I'm finally at the stage where I want to run the conversion tool. Unfortunately it keeps timing out after the initial page where it asks you for the information. It doesn't have a chance to get past step1.

At first I thought it was my firewall so I added some exceptions to see if that helped. It didn't and so I decided to use a USB modem which would bypass the firewall entirely (its built in the the network prior to my PC) but it still had the same problem.

At times it will come back saying that it had a Read Timeout.

Anyone able to help or give any suggestions?


EDIT: And or course, as soon as I post it gets past that part but times out when it pauses to stop it overloading. Now its timing out at the:

convert.php?step=1&substep=1&start=13500

section.
« Last Edit: December 10, 2011, 06:10:58 AM by Kryten15 »

Offline InsaneMustang

  • Jr. Member
  • **
  • Posts: 295
    • Bama Nation
Re: [SMF Converter] MyBB 1.6
« Reply #105 on: December 13, 2011, 03:20:44 PM »
I'm getting

Unknown column 'memberName' in 'field list'

Offline InsaneMustang

  • Jr. Member
  • **
  • Posts: 295
    • Bama Nation
Re: [SMF Converter] MyBB 1.6
« Reply #106 on: December 22, 2011, 10:48:28 AM »
help?

Offline nck0099

  • Newbie
  • *
  • Posts: 6
Re: [SMF Converter] MyBB 1.6
« Reply #107 on: December 24, 2011, 04:07:34 AM »
i m getting this error while converting

Code: [Select]
[b]Converting...
[/b]
Converting members...Duplicate entry '16777215' for key 'PRIMARY'

Offline alexandreperei

  • Semi-Newbie
  • *
  • Posts: 61
Re: [SMF Converter] MyBB 1.6
« Reply #108 on: December 27, 2011, 06:39:45 PM »
One simple question, i have to delete mybb files before use converter? And sql files?

Offline nck0099

  • Newbie
  • *
  • Posts: 6
Re: [SMF Converter] MyBB 1.6
« Reply #109 on: December 29, 2011, 04:44:54 AM »
One simple question, i have to delete mybb files before use converter? And sql files?
no

Offline Firari55

  • Newbie
  • *
  • Posts: 2
Re: [SMF Converter] MyBB 1.6
« Reply #110 on: February 11, 2012, 07:03:33 PM »
Birisi Şu Sistemin En Sağlamını Upload Etsin.

Offline eleweb

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] MyBB 1.6
« Reply #111 on: February 21, 2012, 10:36:01 AM »
 :'( i have this mistake

Code: [Select]
Sorry, the database connection information used in the specified installation of SMF cannot access the installation of MyBulletinBoard 1.6. This may either mean that the installation doesn't exist, or that the Database account used does not have permissions to access it.

The error that was received from the Database was: SELECT command denied to user 'prova_smf'@'localhost' for table 'mybb_users'

what does mean?

Offline Ashley S

  • Sr. Member
  • ****
  • Posts: 986
  • Gender: Male
    • @AsHWM on Twitter
    • AdminMB
Re: [SMF Converter] MyBB 1.6
« Reply #112 on: February 25, 2012, 11:49:47 AM »
No converter for SMF 2.0.2?

Offline Nibogo

  • SMF Hero
  • ******
  • Posts: 6,530
  • Gender: Male
    • smfpacks on Facebook
    • @smfpacks on Twitter
    • SMFPacks
Re: [SMF Converter] MyBB 1.6
« Reply #113 on: February 25, 2012, 02:30:08 PM »
No converter for SMF 2.0.2?

It should work just fine for 2.0.2, if not just convert to 2.0 and upgrade to 2.0.2

Offline iMadness

  • Semi-Newbie
  • *
  • Posts: 30
    • CodMedia Network
Re: [SMF Converter] MyBB 1.6
« Reply #114 on: March 24, 2012, 02:20:49 PM »
About:
Quote
Converting members...Wrong value type sent to the database. Date expected. (birthdate)

Can you please login in phpmyadmin, and run the following query:
Code: [Select]
SELECT birthday from [your_mybb_tables_prefix]users;
(please replace with your actual MyBB tables prefix.)

And attach the result here, or send to me in a PM?

Please note that it will display all the birth dates stored in your MyBB database (with no other user data or anything, only birth dates). If you are not comfortable with that, feel free not to.

I just ran a query, by the bottom in the top left.
Here's what I got (Same BDay issue)
http://i.imgur.com/waCHj.png

Offline ThomasJ

  • Jr. Member
  • **
  • Posts: 162
  • Gender: Male
  • I break stuff
Re: [SMF Converter] MyBB 1.6
« Reply #115 on: March 26, 2012, 04:38:46 AM »
I ran into the same BDay issue. Format was 1-1-1970 for all users with no bday explicitly set. Nulled out all bdays to get past that step. However that lead me directly into the next issue:

Code: [Select]
Converting polls...Wrong value type sent to the database. Integer expected. (expire_time)
Whoops! Did i break that?

Online NanoSector

  • Support Specialist
  • SMF Hero
  • *
  • Posts: 9,738
  • Gender: Male
    • rick2288 on Facebook
    • Yoshi2889 on GitHub
    • Test Server
Re: [SMF Converter] MyBB 1.6
« Reply #116 on: March 26, 2012, 09:00:42 AM »
Can you give me an example of a poll's expire_time value?
Probably it's not an UNIX timestamp which is all integer.

If it's something like "1-1-1970" I can do something about it.
My Mods / Mod Builder - A tool to easily create mods / Support team member

Offline ThomasJ

  • Jr. Member
  • **
  • Posts: 162
  • Gender: Male
  • I break stuff
Re: [SMF Converter] MyBB 1.6
« Reply #117 on: March 31, 2012, 08:52:33 PM »
From the sql
Code: [Select]
TRUNCATE {$to_prefix}polls;
TRUNCATE {$to_prefix}poll_choices;
TRUNCATE {$to_prefix}log_polls;

---* {$to_prefix}polls
SELECT
        p.pid AS id_poll, SUBSTRING(p.question, 1, 255) AS question, p.closed AS voting_locked,
        t.uid AS id_member,
        IF(p.timeout = 0, 0, p.dateline + p.timeout * 86400) AS expire_time,
        SUBSTRING(t.username, 1, 255) AS poster_name
FROM {$from_prefix}polls AS p
        LEFT JOIN {$from_prefix}threads AS t ON (t.tid = p.tid);
---*

So it's taking timeout and datline coloumns, which are bigint(30) and appear to be unix timestamps. I have no idea why it is failing as the entry's clearly are int's

example dateline
Code: [Select]
1094083328

example timeout
Code: [Select]
1094083328
Whoops! Did i break that?

Offline eleweb

  • Newbie
  • *
  • Posts: 3
Re: [SMF Converter] MyBB 1.6
« Reply #118 on: April 14, 2012, 10:04:58 AM »
HI, I'm use the suggerst of page 3 but I continue to have tis error

Code: [Select]
Converting posts (this may take some time)...The database value you're trying to insert does not exist: modified_name
how to fix it?

Offline serulin

  • Newbie
  • *
  • Posts: 1
Re: [SMF Converter] MyBB 1.6
« Reply #119 on: June 12, 2012, 12:06:16 AM »
Awesome thread guys, thanks for all the help! Had to go through and find each fix from people and add it to the sql, but in the end it worked! Just successfully converted mybb 1.6.7 to smf 2.0.2!!!