• Welcome to Simple Machines Community Forum. Please login or sign up.

[SMF Converter] e107 - 0.7.7

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

Previous topic - Next topic

mcdemon

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

ThorstenE

you need to  enable extended fields in e107.
also go to e107 - admin area - Plugins - Plugin-Manager and install the plugins polls and private messenger (if not installed until yet)

mcdemon

i ebable all extended fields
error: Incorrect date value: '' for column 'birthdate' at row 1


mcdemon

i dont idiot
"ue.user_birthday AS birthdate," replased "''AS birthdate," & activated all extended fields
result:  Incorrect date value: '' for column 'birthdate' at row 1

ThorstenE

December 06, 2008, 07:42:22 AM #205 Last Edit: December 06, 2008, 07:47:18 AM by TE
please try the attached version..

which version of e017 are you wanting to convert?

mcdemon

0.7.14
new e107_to_smf.sql
result: Incorrect date value: '' for column 'birthdate' at row 1

ThorstenE

mhh, sounds like a MySQL issue with the locale settings..
try this version please..

mcdemon

Converting posts (this may take some time)... Successful.
Converting posts (step 2)... Unsuccessful!
This query:
UPDATE `smf`.smf_messages
SET subject = '[голосование] УсÑ,раиваеÑ, ли Ð'ас цвеÑ,овое решение в дизайне данного Ñ,,орума?'
WHERE ID_TOPIC = '833';
Caused the error:
Incorrect string value: '\xE2\x82\xAC\xC3\x91\xC6...' for column 'subject' at row 1

ThorstenE

is your SMF installed in UTF-8? both forums must use the same table collation in MySQL during the conversion.. please check the collation from the e107 installation. 

if it is set to a local character set you must install SMF with this character set (during install leave the UTF-8 checkbox unchecked).. if e107 is UTF-8 your SMF should also be installed with UTF-8 collation (checkbox during install enabled).

mcdemon

e107 - utf8
smf - utf8
in convert.php set utf8

result
Converting posts (this may take some time)... Successful.
Converting posts (step 2)... Unsuccessful!
This query:
UPDATE `smf`.smf_messages
SET subject = '[голосование] УсÑ,раиваеÑ, ли Ð'ас цвеÑ,овое решение в дизайне данного Ñ,,орума?'
WHERE ID_TOPIC = '833';
Caused the error:
Incorrect string value: '\xE2\x82\xAC\xC3\x91\xC6...' for column 'subject' at row 1

ThorstenE

mhh, not sure but maybe this helps:

e107 - utf8
smf - utf8
in convert.php NOT utf8

what character set /language is it?

mcdemon


ThorstenE

any difference when UTF-8 in convert.php is not selected?

mcdemon

   I try to understand myself ... There appears to be a problem with the coding ... Because the site are displayed perfectly, at phpmyadmin and the same is not understandable characters.

H.A


ThorstenE

there might be a special character like ' in your subjects (topic ID 833) or the subject is longer than 254 characters..
my main issue: I cannot read your charset so it's very diffucult to find the error..

Try the attached version please (254 characters problem schould be fixed)

Newbster

I have the following problem:

QuoteConverting...
Converting ranks...Converting groups... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts (this may take some time)... Successful.
Converting posts (step 2)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board access... Successful.
Converting moderators... Successful.
Converting banned users...
Fatal error: Cannot break/continue 1 level in /www/****.com******/htdocs/smf/convert.php(929) : eval()'d code on line 13

Most strange thing is that on the top there comes up the following:

QuoteWarning: set_time_limit() has been disabled for security reasons in /www/****.com******/htdocs/smf/convert.php on line 29

Actually I can't seem to find anything on the forum that hasn't been converted expect the avatars but I'm sure they can set it up themselves again.

ThorstenE


Newbster

No worries even moderators need breaks. :)

If converting all again does it affect the forum that is set-up at the moment? As I've already published the forum and people posted there last time the posts have been lost when I set it up for a test. Due to e107 being bit silly I already had manually hidden all emails of members lol.

But other than that I have to say that smf is great!


Advertisement: