Advertisement:

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

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] MyBB 1.6
« Reply #20 on: November 23, 2010, 03:36:59 AM »
Find them attached in the first post please. I will add them to the site's downloads as well.
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 .Vapor

  • Jr. Member
  • **
  • Posts: 205
  • Gender: Male
  • PC gamer
    • Team Isolation
Re: [SMF Converter] MyBB 1.6
« Reply #21 on: November 28, 2010, 05:54:51 PM »
Hey mate
I tried to do the convert but it gave me this error:-
Code: [Select]
Converting members...Wrong value type sent to the database. Date expected. (birthdate)
What shall I do?

I am also receiving this error converting:
mybb 1.6
to
smf 2.0 rc4

Offline Bruno36

  • Full Member
  • ***
  • Posts: 570
  • Gender: Male
    • Scooter Chinois 4T
Re: [SMF Converter] MyBB 1.6
« Reply #22 on: November 29, 2010, 10:49:20 AM »
hello!
same error

Converting members...Wrong value type sent to the database. Date expected. (birthdate)
Bruno36 the French
SMF 2.0.9

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] MyBB 1.6
« Reply #23 on: November 30, 2010, 03:28:36 AM »
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.
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 Bruno36

  • Full Member
  • ***
  • Posts: 570
  • Gender: Male
    • Scooter Chinois 4T
Re: [SMF Converter] MyBB 1.6
« Reply #24 on: November 30, 2010, 03:31:49 AM »
Code: [Select]
SELECT birthday
FROM mybb_users;

LIMIT 0 , 30
Bruno36 the French
SMF 2.0.9

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] MyBB 1.6
« Reply #25 on: November 30, 2010, 04:18:05 AM »
When you executed that query, below it, on the page, phpmyadmin must have displayed the result. Could you please tell which are they?
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 Bruno36

  • Full Member
  • ***
  • Posts: 570
  • Gender: Male
    • Scooter Chinois 4T
Re: [SMF Converter] MyBB 1.6
« Reply #26 on: November 30, 2010, 05:59:50 AM »
#1064 - 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 '[mybb_users]users LIMIT 0, 30' at line 1
Bruno36 the French
SMF 2.0.9

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] MyBB 1.6
« Reply #27 on: November 30, 2010, 06:06:11 AM »
If your prefix is "mybb_", then please replace in the query "mybb_users", that is, please run:
Code: [Select]
SELECT birthday
FROM mybb_users;

It depends on what your actual prefix is - if you really have a table named "mybb_users" or it is named something else ending with "users".
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 Bruno36

  • Full Member
  • ***
  • Posts: 570
  • Gender: Male
    • Scooter Chinois 4T
Re: [SMF Converter] MyBB 1.6
« Reply #28 on: November 30, 2010, 06:20:45 AM »
yes my table is mybb_users
Bruno36 the French
SMF 2.0.9

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] MyBB 1.6
« Reply #29 on: November 30, 2010, 06:24:31 AM »
Then please use the query:
Code: [Select]
SELECT birthday
FROM mybb_users;
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 Bruno36

  • Full Member
  • ***
  • Posts: 570
  • Gender: Male
    • Scooter Chinois 4T
Re: [SMF Converter] MyBB 1.6
« Reply #30 on: November 30, 2010, 06:27:10 AM »
there are too many records to display
Affichage des enregistrements 0 - 29 (2 473 total, Traitement en 0.0002 sec.)
« Last Edit: November 30, 2010, 06:38:23 AM by Bruno36 »
Bruno36 the French
SMF 2.0.9

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] MyBB 1.6
« Reply #31 on: November 30, 2010, 08:06:55 AM »
Please, use the attached mybb16_to_smf.sql file instead.

Also, please upload the attached file in your Sources/Subs-Db-mysql.php. It would be best if you made a copy of your current Sources/Subs-Db-mysql.php file, and keep it. Then replace your file with the attached one.
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 Bruno36

  • Full Member
  • ***
  • Posts: 570
  • Gender: Male
    • Scooter Chinois 4T
Re: [SMF Converter] MyBB 1.6
« Reply #32 on: November 30, 2010, 08:49:20 AM »
Converting members...Wrong value type sent to the database. Date expected. (birthdate)  O:)
Bruno36 the French
SMF 2.0.9

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] MyBB 1.6
« Reply #33 on: November 30, 2010, 08:51:17 AM »
Oops.
Are you sure the new files are in the right directories? mybb16_to_smf.sql should be uploaded to SMF main directory, overwriting your previous file, and Subs-Db-mysql.php should be uploaded in your Sources directory.
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 Bruno36

  • Full Member
  • ***
  • Posts: 570
  • Gender: Male
    • Scooter Chinois 4T
Re: [SMF Converter] MyBB 1.6
« Reply #34 on: November 30, 2010, 08:55:21 AM »
Yes
Bruno36 the French
SMF 2.0.9

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] MyBB 1.6
« Reply #35 on: November 30, 2010, 09:02:19 AM »
I can't replicate it anymore. I used your dates in my test forum, got the same error, and have it fixed using these changes.

Can you please make sure that the file Subs-Db-mysql.php was indeed overwritten by your FTP client? Sometimes they may not overwrite all existing files. Same for the other.
Maybe it would be useful if you download them to check.

Also, can you please make sure you restart the conversion process completely, from running convert.php without any parameter in the URL, just http://your_smf_address/convert.php
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 Bruno36

  • Full Member
  • ***
  • Posts: 570
  • Gender: Male
    • Scooter Chinois 4T
Re: [SMF Converter] MyBB 1.6
« Reply #36 on: November 30, 2010, 09:22:09 AM »
Yes

Directory smf

Bruno36 the French
SMF 2.0.9

Offline NanoSector

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 10,471
  • Gender: Male
  • VC321xb47@aperture:~#
    • Yoshi2889 on GitHub
Re: [SMF Converter] MyBB 1.6
« Reply #37 on: November 30, 2010, 10:08:26 AM »
Yes

Directory smf
I can sees you has new mailz.

Anyways, I'm gonna try converting my test myBB forum.
My Mods / Mod Builder - A tool to easily create mods / Blog
"I've heard from a reliable source that the Answer is 42. But, still no word on what the question is."

Offline Bruno36

  • Full Member
  • ***
  • Posts: 570
  • Gender: Male
    • Scooter Chinois 4T
Re: [SMF Converter] MyBB 1.6
« Reply #38 on: December 08, 2010, 04:38:35 AM »
I still hold to the conversion
I stuck at the first step.  :-\
Bruno36 the French
SMF 2.0.9

Offline Norv

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 18,313
  • Blue Wolf
Re: [SMF Converter] MyBB 1.6
« Reply #39 on: December 08, 2010, 05:21:34 AM »
Can you please try using this file instead then?
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