• 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

victorjohn

Hello all,

I too am getting the infamous u.user_birthday error.  I tried several attempts, each with a fresh SMF install on my test server, turning the extended user profiles on in e107, and even messing with editing the conversion .sql file (which I really have no business messing with due to lack of skill).

I am running SMF 1.1.4 and e107 0.7.8?  I am wiling to work to sort it out, but am having little luck knowing where to begin?

Anyone?

victorjohn

Also can someone help me to understand the bit of syntax involving the "u.whatever" contained in those statements??  What does the "u." stand for?  Is it short for the user extended field name?


JayBachatero

Follow me on Twitter

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

victorjohn

I've read that document before, or I wouldn't trouble you.  I still don't quite understand the syntax "u." in your converter file, but maybe I am totally missing something.  Either way it doesn't matter.  I am still quite stuck on the errors I am getting involving the extended user fields, and as such might not be able to go with SMF, which I would very much like to do, any suggestions?

JayBachatero

The u. part is an alias for the table name.  Example.

SELECT full_table_name.column1, full_table_name.column2
FROM full_table_name


You write

SELECT ftb.column1, ftp.column2
FROM full_table_name AS ftb


For everyone else here enabling the extended profile worked for them.  There might be something that you are doing wrong and it's not being enabled.
Follow me on Twitter

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


victorjohn

btw eres dominicano? soy boriqua.  que te vaya bien!

victorjohn

Quote from: JayBachatero on February 26, 2008, 01:21:57 PM
For everyone else here enabling the extended profile worked for them.  There might be something that you are doing wrong and it's not being enabled.

You are most likely right about that part!  :)

JayBachatero

Quote from: victorjohn on February 26, 2008, 02:27:04 PM
btw eres dominicano? soy boriqua.  que te vaya bien!
Si soy Dominicano ;).

Quote from: victorjohn on February 26, 2008, 02:27:57 PM
Quote from: JayBachatero on February 26, 2008, 01:21:57 PM
For everyone else here enabling the extended profile worked for them.  There might be something that you are doing wrong and it's not being enabled.

You are most likely right about that part!  :)
If you don't get it to week.  I'm going to setup e107 locally and see id I can enable them.  It's been a while since I mess with e107 so need to see how to do it.
Follow me on Twitter

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

slackerpunk

i've had issues with extended fields a while back when I ported from e107 and I found a solution I think given by Jay lemme see if I can still find it in a notepad or something... I used this converter to convert from e107 and it works flawlessly

DanielKvist

I have problem with characters. My forum is in swedish and your converter doesnt convert åäö propperly. Is there another one for international forums?

SleePy

When you installed SMF, did you set it to use UTF-8?
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

DanielKvist

Quote from: SleePy on May 07, 2008, 01:44:08 PM
When you installed SMF, did you set it to use UTF-8?


Dont remember. I try to reinstall it. But i think it said error when i wanted UTF-8... brb

DanielKvist

The current version of your database doesn't support the use of the UTF-8 character set. You can still install SMF without any problems, but only with UTF-8 support unchecked. If you would like to switch over to UTF-8 in the future (e.g. after the MySQL server of your forum has been upgraded to a version >= 4.1), you can convert your forum to UTF-8 through the admin panel.

-------------------------------------

The current version is 4.0.21 and i cant upgrade it. It's not a localhost. But in the old forum all swedish characters work fine...

SleePy

Most likely because they where using another charset or doing html entities to make it work.
Do you know what charset your other forum was? or if it was stored as html entities?

I would really suggest asking to get your mysql upgraded though. The MySQL Team recently dropped support for mysql 4 (the php team did the same as well recently for php4).
Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

DanielKvist

e107
Version v0.7.2

Install date
Friday 24 February 2006 - 14:37:50

Server
Apache/1.3.41 (Unix)

PHP Version
4.4.8

MySQL
4.0.21

Charset
utf-8

The weird thing is that it's utf-8 on the old one!?
Anyways php, mysql and apache are really old so I should try to make an upgrade. Just got the control of this forum, the old admin missbehaved so we had to take him away. And now im in charge and this is what I get :P

maple

having a little problem:

Converting members... Unsuccessful!
This query:
SELECT
u.user_id AS ID_MEMBER, SUBSTRING(u.user_name, 1, 80) AS memberName,
u.user_join AS dateRegistered, u.user_forums AS posts,
IF (u.user_admin = 1, 1, 0) AS ID_GROUP, u.user_lastvisit AS lastLogin,
SUBSTRING(u.user_name, 1, 255) AS realName,
SUBSTRING(u.user_password, 1, 64) AS passwd,
SUBSTRING(u.user_email, 1, 255) AS emailAddress, 0 AS gender,
u.user_birthday AS birthdate,
SUBSTRING(REPLACE(u.user_homepage, 'http://', ''), 1, 255) AS websiteTitle,
SUBSTRING(u.user_homepage, 1, 255) AS websiteUrl,
SUBSTRING(u.user_location, 1, 255) AS location,
SUBSTRING(u.user_icq, 1, 255) AS ICQ, SUBSTRING(u.user_aim, 1, 16) AS AIM,
SUBSTRING(u.user_msn, 1, 255) AS MSN, u.user_hideemail AS hideEmail,
SUBSTRING(u.user_signature, 1, 65534) AS signature,
IF(SUBSTRING(u.user_timezone, 1, 1) = '+', SUBSTRING(u.user_timezone, 2), u.user_timezone) AS timeOffset,
SUBSTRING(u.user_image, 1, 255) AS avatar,
SUBSTRING(u.user_customtitle, 1, 255) AS usertitle,
SUBSTRING(u.user_ip, 1, 255) AS memberIP, '' AS lngfile, '' AS buddy_list,
'' AS pm_ignore_list, '' AS messageLabels, '' AS personalText, '' AS YIM,
'' AS timeFormat, '' AS secretQuestion, '' AS secretAnswer,
'' AS validation_code, '' AS additionalGroups, '' AS smileySet,
'' AS passwordSalt, SUBSTRING(u.user_ip, 1, 255) AS memberIP2
FROM `afilms_e107`.e107_user AS u
WHERE u.user_id > 0
LIMIT 0, 500;
Caused the error:

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

birthday
[birthday]   No Members Members Members         
aim
[AIM Address]  No Members Members Members         
country
[Country]    No Members Members Members         
homepage
[Homepage]  No Members Members Members         
icq
[ICQ Number]  No Members Members Members         
language
[Language]    English  No Members Members Members         
location
[Location]  No Members Members Members         
msn
[MSN]  No Members Members Members         
yahoo
[Yahoo! Address]

followed what everyone said, and no change


maple

ok so i fixed everything, got the post and users over, now i get this when i try and make a new category:

Duplicate entry '255' for key 1
File: /home/cooldude/public_html/forum/Sources/Subs-Boards.php
Line: 1342

any ideas?

Tryed all the maint things already

SleePy

Quote from: SleePy on March 31, 2008, 11:37:32 PM
That error is saying that the max category ID that SMF allows by default has been reached. For some reason fireboard wants a category ID that is higher than 255..

You can fix it by doing this to your SMF database in phpMyAdmin (What is phpMyAdmin?). You may need to change smf_ to your database prefix if it is different.
ALTER TABLE smf_categories CHANGE id_cat id_cat smallint(6) UNSIGNED NOT NULL AUTO_INCREMENT   

Edit,
Oops, a Jay pointed out that tinyint only has a max of 255.. So we have to use smallint.

Jeremy D — Site Team / SMF Developer
Support the SMF Support team!
Profiles:GitHub
Join us on IRC Libera.chat/#smf

Advertisement: