SMF Support > Converting to SMF

[SMF Converter] Vanilla 2

<< < (3/7) > >>

Oldiesmann:
Do either of you have guest posts on your forum? It pulls the poster name from the "name" column of the User table based on the ID of the member who made the post.

gravesend46:
I'm not sure. The forum was always set to registered members only as far as I recall, though it's not impossible there are guest posts I guess. Is there any easy way to check, I'm a bit of a MySQL/PHP novice.

Oldiesmann:
Run this query in phpMyAdmin. If it returns any rows, then we'll have to tweak the query in the converter some to handle situations where there is no user associated with a particular post.


--- Code: ---SELECT
t.DiscussionID AS id_topic, t.Announce AS is_sticky, t.CategoryID AS id_board, t.InsertUserID AS id_member_started, t.LastCommentUserID AS id_member_updated, t.body, t.CountComments AS num_replies, t.Closed AS locked, fm.name AS poster_name, fm.Email AS poster_email, t.DateInserted AS poster_time, t.name AS subject, fm.name AS modified_name, t.DateUpdated AS modified_time
FROM {$from_prefix}Discussion AS t
LEFT JOIN {$from_prefix}User AS fm ON (t.InsertUserID = fm.UserID)
WHERE fm.UserID IS NULL;
--- End code ---

Replace "{$from_prefix}" with the prefix of your vanilla tables.

kevl:
Hello,

I am getting this same error from thread:

http://www.simplemachines.org/community/index.php?topic=405111.0

Using this new converter.  I am stumped.

----------------------------------
Converting members...
Unsuccessful!
This query:

    SELECT
    m.UserID AS id_member, m.Name as member_name, m.DateFirstVisit AS date_registered,
    (m.CountDiscussions + m.CountComments) AS posts, m.DateLastActive AS last_login,
    CASE m.RoleID WHEN 4 THEN 1 ELSE 0 END AS id_group, m.Password AS passwd,
    CONCAT_WS(' ', m.FirstName, m.LastName) AS real_name, m.Email AS email_address,
    CASE m.UtilizeEmail WHEN 1 THEN 0 ELSE 1 END as hide_email, m.Picture AS avatar,
    m.RemoteIp AS member_ip, m.RemoteIp AS member_ip2, '' AS password_salt,
    '' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS message_labels,
    '' AS personal_text, '' AS time_format, '' AS usertitle, '' AS secret_question,
    '' AS secret_answer, '' AS validation_code, '' AS additional_groups, '' AS smiley_set
    FROM `*****_vanilla`.GDN_User AS m
    LIMIT 0, 500;

Caused the error:

    Unknown column 'm.RoleID' in 'field list'
----------------------

kevl:
OK got a little further -

Converting members... Successful.
Converting boards... Successful.
Converting topics... Successful.
Converting posts...Wrong value type sent to the database. Integer expected. (id_board)




--- Quote from: kevl on November 11, 2011, 05:35:53 PM ---Hello,

I am getting this same error from thread:

http://www.simplemachines.org/community/index.php?topic=405111.0

Using this new converter.  I am stumped.

----------------------------------
Converting members...
Unsuccessful!
This query:

    SELECT
    m.UserID AS id_member, m.Name as member_name, m.DateFirstVisit AS date_registered,
    (m.CountDiscussions + m.CountComments) AS posts, m.DateLastActive AS last_login,
    CASE m.RoleID WHEN 4 THEN 1 ELSE 0 END AS id_group, m.Password AS passwd,
    CONCAT_WS(' ', m.FirstName, m.LastName) AS real_name, m.Email AS email_address,
    CASE m.UtilizeEmail WHEN 1 THEN 0 ELSE 1 END as hide_email, m.Picture AS avatar,
    m.RemoteIp AS member_ip, m.RemoteIp AS member_ip2, '' AS password_salt,
    '' AS lngfile, '' AS buddy_list, '' AS pm_ignore_list, '' AS message_labels,
    '' AS personal_text, '' AS time_format, '' AS usertitle, '' AS secret_question,
    '' AS secret_answer, '' AS validation_code, '' AS additional_groups, '' AS smiley_set
    FROM `*****_vanilla`.GDN_User AS m
    LIMIT 0, 500;

Caused the error:

    Unknown column 'm.RoleID' in 'field list'
----------------------

--- End quote ---

Navigation

[0] Message Index

[#] Next page

[*] Previous page

Go to full version