• Welcome to Simple Machines Community Forum. Please login or sign up.
December 06, 2021, 11:45:38 AM

News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord


[SMF Converter] e107 - 0.7.7

Started by JayBachatero, January 10, 2007, 01:26:50 PM

Previous topic - Next topic

Angpeu

truncate table `smf`.`smf_topics`
reapeat convert:
Converting topics... Unsuccessful!
This query:
INSERT INTO `smf`.smf_topics
(ID_TOPIC, isSticky, ID_BOARD, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_POLL, numReplies, numViews, locked)
.............
Caused the error:
Duplicate entry '36540' for key 1


JayBachatero

Seems like the $ignore is not working :(.  Are you using the convert.php from the other topic?  The link to it its on the first post.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Angpeu


JayBachatero

Ok I was looking at the wrong section.  It has the ignore now.  Try this one.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Angpeu

Converting...
Recalculating forum statistics... Successful.
Conversion Complete

Angpeu

numbers topics and post on new forum = old forum.

JayBachatero

Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Angpeu

success, but have many errors.
i need some time for full test after then i post full list errors.

First find it not right convert Child Boards. its placed on first level forum...

JayBachatero

I'll make a test install of e107 and try working with child boards.  I would appreciate it if you post the errors that you are getting.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

JayBachatero

Ok a question.  How do I add child boards?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Angpeu

On the forum admin click to planet icons (like the site icon on you profile)
:)

JayBachatero

Yea I found it after I posted :P.  Try this file and lets see what happens.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Angpeu

Converting boards... Unsuccessful!
This query:
INSERT INTO `smf`.smf_boards
....
Caused the error:
Duplicate entry '2' for key 1

JayBachatero

Can you send me a dump of the forum table so that I can run a test query here?
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert


Angpeu

forum names at windows-1251 charset.

JayBachatero

Before converting you changed SMF to UTF-8 right?

BTW I'm off to work so I won't be able to have a response for you till I get home tonight.
Follow me on Twitter

"HELP!!! I've fallen and I can't get up"
This moment has been brought to you by LifeAlert

Angpeu

no, im using windows-1251
dump on UTF8, because im use mysql 5.

jonjax

I have tried the above but still having problems and getting

Caused the error:

Unknown column 'ue.user_birthday' in 'field list'

Angpeu

Quote from: jonjax on January 11, 2007, 03:12:04 PM
I have tried the above but still having problems and getting

Caused the error:

Unknown column 'ue.user_birthday' in 'field list'

on e107 admin, turn on all extended user fields.

Advertisement: