SMF Support > vBulletin

vb 4.2.5 to smf 2.o.15

(1/2) > >>

daveb47:
Getting this error when converting,any help appreciated
U
--- Quote ---nknown system variable 'SQL_MAX_JOIN_SIZE'
--- End quote ---

daveb47:
ok got past this by editing convert.php.

Now got another errorwhen converting

--- Code: ---Converting members... Successful.
Converting administrators... Successful.
Converting categories... Successful.
Converting boards... Successful.
Assigning boards to categories... Successful.
Converting topics... Unsuccessful!
This query:

    SELECT
    t.threadid AS id_topic, t.forumid AS id_board, t.sticky AS is_sticky,
    t.pollid AS id_poll, t.views AS num_views, t.postuserid AS id_member_started,
    CASE WHEN (ISNULL(ul.userid) OR TRIM(ul.userid) = '') THEN 0 ELSE ul.userid END AS id_member_updated,
    t.replycount AS num_replies,
    IF(t.open, 0, 1) AS locked, MIN(p.postid) AS id_first_msg,
    MAX(p.postid) AS id_last_msg
    FROM `scamsuk_vbull`.thread AS t
    INNER JOIN `scamsuk_vbull`.post AS p ON (p.threadid = t.threadid)
    LEFT JOIN `scamsuk_vbull`.user AS ul ON (ul.username = t.lastposter)
    GROUP BY t.threadid
    HAVING id_first_msg != 0
    AND id_last_msg != 0
    LIMIT 0, 500;

Caused the error:

    Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'scamsuk_vbull.ul.userid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
--- End code ---

Also passwords dont work & when trying to retrieve them i am getting error


--- Code: ---Invalid activation code
--- End code ---

daveb47:

--- Quote ---Also passwords dont work & when trying to retrieve them i am getting error

Code:

Invalid activation code
--- End quote ---

Now sorted this by copy/paste link in email

vbgamer45:
For

--- Quote ---"    Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'scamsuk_vbull.ul.userid' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"

--- End quote ---

If you have access to your mysql config in your my.cnf
Set
sql_mode=""
And restart MySQL

daveb47:
Do you mean "vbulletin4_to_smf"
or if not whre can i find mysql config in your my.cnf
  thanks

Navigation

[0] Message Index

[#] Next page

Go to full version