News:

SMF 2.1.2 has been released! Take it for a spin! Read more.

Main Menu

Trying to convert phpBB3 - SQL error

Started by skibike, November 19, 2014, 03:30:07 PM

Previous topic - Next topic

skibike

Okay so Im trying to do another Conversion from phpBB3 I get this SQL error. Im not having much joy and I abandoned it last time due to too many errors I faced having to resolve. If this happens again, I will finally lay it to rest and forget about SMF.

Any help?

Converting ranks... Successful.
Converting groups... Successful.
Converting members... Unsuccessful!
This query:
SELECT
u.user_id AS id_member, SUBSTRING(u.username, 1, 80) AS member_name,
SUBSTRING(u.username, 1, 255) AS real_name,
SUBSTRING(u.user_password, 1, 64) AS passwd, u.user_lastvisit AS last_login,
u.user_regdate AS date_registered,
SUBSTRING(u.user_from, 1, 255) AS location,
u.user_posts AS posts, IF(u.user_rank = 1, 1, IFNULL(mg.id_group, 0)) AS id_group,
u.user_new_privmsg AS instant_messages,
SUBSTRING(u.user_email, 1, 255) AS email_address,
u.user_unread_privmsg AS unread_messages,
SUBSTRING(u.user_msnm, 1, 255) AS msn,
SUBSTRING(u.user_aim, 1, 16) AS aim,
SUBSTRING(u.user_icq, 1, 255) AS icq,
SUBSTRING(u.user_yim, 1, 32) AS yim,
SUBSTRING(u.user_website, 1, 255) AS website_title,
SUBSTRING(u.user_website, 1, 255) AS website_url,
u.user_allow_viewonline AS show_online, u.user_timezone AS time_offset,
IF(u.user_allow_viewemail = 1, 0, 1) AS hide_email, u.user_avatar AS avatar,
REPLACE(u.user_sig, '\n', '<br />') AS signature,
u.user_sig_bbcode_uid AS signature_uid, u.user_avatar_type,
u.user_notify_pm AS pm_email_notify,
CASE u.user_inactive_reason WHEN 0 THEN 1 ELSE 0 END AS is_activated,
'' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS message_labels,
'' AS personal_text, '' AS time_format, '' AS usertitle, u.user_ip AS member_ip,
'' AS secret_question, '' AS secret_answer, '' AS validation_code,
'' AS additional_groups, '' AS smiley_set, '' AS password_salt,
u.user_ip AS member_ip2
FROM `juliegee_zforums`.phpbb_users AS u
LEFT JOIN `juliegee_zforums`.phpbb_ranks AS r ON (r.rank_id = u.user_rank AND r.rank_special = 1)
LEFT JOIN `juliegee_smfn1`.smf_membergroups AS mg ON (mg.group_name = CONCAT('phpBB ', r.rank_title))
WHERE u.group_id NOT IN (1, 6)
GROUP BY u.user_id
LIMIT 0, 500;
Caused the error:
Unknown column 'u.user_from' in 'field list'

margarett

Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair


margarett

Strange... There was a recent conversion
http://www.simplemachines.org/community/index.php?topic=527586.0

Yes, there were issues, but that didn't occur... Which phpBB version are you coming from?
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

skibike

Ahh, thats maybe why, as this is the new phpBB 3.1.1 version that was just released.

margarett

Well in that case it would be expected to have problems :P
Sorry, there is no functional converter yet...
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

skibike

So I took a version of my board from 3.0.12 and tried the converter and get this:
Converting...

Notice: Undefined index: convert_script in /home1/juliegee/public_html/SMF/convert.php on line 972

Warning: Invalid argument supplied for foreach() in /home1/juliegee/public_html/SMF/convert.php on line 975

Notice: Undefined index: convert_script in /home1/juliegee/public_html/SMF/convert.php on line 987
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in /home1/juliegee/public_html/SMF/convert.php on line 2494

Notice: Undefined variable: result in /home1/juliegee/public_html/SMF/convert.php on line 2495

Notice: Undefined index: db_fetch_assoc in /home1/juliegee/public_html/SMF/convert.php on line 1386

Fatal error: Function name must be a string in /home1/juliegee/public_html/SMF/convert.php on line 1386

Colin

The never ending nightmare of keeping convertors updated :\
"If everybody is thinking alike, then somebody is not thinking." - Gen. George S. Patton Jr.

Colin

skibike

I just dont understand why I run into so many different errors when trying to convert my phpBB board (3.0.12). I had a lot of issues with the last one (collation problems) and its not like I changed anything in phpAdmin, so I have a hard time understanding why the converter is failing with so many errors.

skibike

Okay, so after I did a re-install and convert, it worked this time.

margarett

:)

The reasons for the converter to fail are... A lot and varied :P
Se forem conduzir, não bebam. Se forem beber... CHAMEM-ME!!!! :D

QuoteOver 90% of all computer problems can be traced back to the interface between the keyboard and the chair

Herman's Mixen

if you have a good backup of your database, before you start using PHPBB 3.1.1 then you will probally convert that with the right converter to an good end ;)

have a feeling that your database stucture has been infected by 3.1.1

Met vriendelijke groet, The Burglar!

 House Mixes | Mixcloud | Any Intelligent fool can make things bigger, more complex, and more violent.
It takes a touch of genius - and a lot of courage - to move in the opposite direction. - Albert Einstein

Former Godfather of our dutch community ;)

Advertisement: