• Welcome to Simple Machines Community Forum. Please login or sign up.
December 07, 2021, 06:57:25 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

Oldiesmann

Are you sure you enabled extended user fields? It should have added that table and the appropriate columns to the database when that feature was enabled. I've never used e107 so the only help I can provide at this point is telling you how to modify the converter to just import blank strings for those fields (which is all it would be doing anyway if you hadn't previously enabled that option).

Find
ue.user_birthday AS birthdate,
SUBSTRING(REPLACE(ue.user_homepage, 'http://', ''), 1, 255) AS website_title,
SUBSTRING(ue.user_homepage, 1, 255) AS website_url,
SUBSTRING(ue.user_location, 1, 255) AS location,
SUBSTRING(ue.user_icq, 1, 255) AS icq,
SUBSTRING(ue.user_aim, 1, 16) AS aim,
SUBSTRING(ue.user_msn, 1, 255) AS msn, u.user_hideemail AS hide_email,


Replace
'' AS birthdate,
'' AS website_title,
'' AS website_url,
'' AS location,
'' AS icq,
'' AS aim,
'' AS msn, u.user_hideemail AS hide_email,


Find and remove this line:
LEFT JOIN {$from_prefix}user_extended AS ue ON (ue.user_extended_id = u.user_id)
Michael Eshom
Cincy Space - now open!

robeitor

Hi,

modified all and i have the same error....   :(

The "extended user fields" are activated, i attached the screen shot.


Converting...
Converting ranks...Converting groups... Successful.
Converting members...Wrong value type sent to the database. Date expected. (birthdate)


Oldiesmann

Ok. This time it's SMF being picky about trying to insert a string into a date field. The good news is if you set the date low enough, SMF won't try to calculate their age.

So...

Find
'' AS birthdate

Replace
'0004-01-01' AS birthdate

That should fix your issue there.
Michael Eshom
Cincy Space - now open!

robeitor

November 07, 2013, 01:58:32 AM #283 Last Edit: November 07, 2013, 04:47:02 AM by robeitor
Hi,

This resolve the problem with the birthday, thanks!

Now, i have other error:

I suppose that is similar at the error of birthday¿?

Converting ranks...Converting groups... Successful.
Converting members... Unsuccessful!
This query:
SELECT
u.user_id AS id_member, SUBSTRING(u.user_loginname, 1, 80) AS member_name,
u.user_join AS date_registered, u.user_forums AS posts,
(CASE WHEN u.user_admin = 1 THEN 1 ELSE 0 END) AS id_group, u.user_lastvisit AS last_login,
SUBSTRING(u.user_name, 1, 255) AS real_name,
SUBSTRING(u.user_password, 1, 64) AS passwd,
SUBSTRING(u.user_email, 1, 255) AS email_address, 0 AS gender,
'0004-01-01' AS birthdate
'' AS website_title,
'' AS website_url,
'' AS location,
'' AS icq,
'' AS aim,
'' AS msn, u.user_hideemail AS hide_email,
SUBSTRING(u.user_signature, 1, 65534) AS signature,
CASE
WHEN SUBSTRING(u.user_timezone, 1, 1) = '+'
THEN SUBSTRING(u.user_timezone, 2)
ELSE u.user_timezone
END AS time_offset,
SUBSTRING(u.user_image, 1, 255) AS avatar,
SUBSTRING(u.user_customtitle, 1, 255) AS usertitle,
SUBSTRING(u.user_ip, 1, 255) AS member_ip,
SUBSTRING(u.user_ip, 1, 255) AS member_ip2, '' AS lngfile, '' AS buddy_list,
'' AS pm_ignore_list, '' AS message_labels, '' AS personal_text, '' AS yim,
'' AS time_format, '' AS secret_question, '' AS secret_answer, '' AS password_salt,
'' AS validation_code, '' AS additional_groups, '' AS smiley_set
FROM `trailadmin_cta`.e107_user AS u
WHERE u.user_id != 0
LIMIT 0, 500;
Caused the error:
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 ''' AS website_title,
'' AS website_url,
'' AS location,
'' AS icq,
' at line 9

mentalist

there's a missing comma (that line where you applied the mentioned fix):
'0004-01-01' AS birthdate -> '0004-01-01' AS birthdate,

robeitor

Hi!

Thats solved these problem.

The next error is about the  "Converting banned users..."

The error show a lot of lines like this:

Notice: Undefined variable: table in C:\xampp\htdocs\smf\convert.php on line 2648

Warning: Missing argument 1 for convert_insert_id(), called in C:\xampp\htdocs\smf\convert.php(1091) : eval()'d code on line 18 and defined in C:\xampp\htdocs\smf\convert.php on line 2643

Notice: Undefined variable: table in C:\xampp\htdocs\smf\convert.php on line 2648

Warning: Missing argument 1 for convert_insert_id(), called in C:\xampp\htdocs\smf\convert.php(1091) : eval()'d code on line 18 and defined in C:\xampp\htdocs\smf\convert.php on line 2643

Notice: Undefined variable: table in C:\xampp\htdocs\smf\convert.php on line 2648

Warning: Missing argument 1 for convert_insert_id(), called in C:\xampp\htdocs\smf\convert.php(1091) : eval()'d code on line 18 and defined in C:\xampp\htdocs\smf\convert.php on line 2643

Notice: Undefined variable: table in C:\xampp\htdocs\smf\convert.php on line 2648

Warning: Missing argument 1 for convert_insert_id(), called in C:\xampp\htdocs\smf\convert.php(1091) : eval()'d code on line 18 and defined in C:\xampp\htdocs\smf\convert.php on line 2643

Notice: Undefined variable: table in C:\xampp\htdocs\smf\convert.php on line 2648

Warning: Missing argument 1 for convert_insert_id(), called in C:\xampp\htdocs\smf\convert.php(1091) : eval()'d code on line 18 and defined in C:\xampp\htdocs\smf\convert.php on line 2643

Notice: Undefined variable: table in C:\xampp\htdocs\smf\convert.php on line 2648

Warning: Missing argument 1 for convert_insert_id(), called in C:\xampp\htdocs\smf\convert.php(1091) : eval()'d code on line 18 and defined in C:\xampp\htdocs\smf\convert.php on line 2643


and these at the final:

Notice: Undefined variable: table in C:\xampp\htdocs\smf\convert.php on line 2648
Unsuccessful!
This query:
INSERT INTO `smf`.smf_ban_items
(id_ban_group, ip_low1, ip_high1, ip_low2, ip_high2, ip_low3, ip_high3, ip_low4, ip_high4, email_address, hostname)
VALUES (1556, 59, 59, 60, 60, 11*, 11*, **, **, '', '');
Caused the error:
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 ' 11*, **, **, '', '')' at line 3



Advertisement: