vb 4.2.5 to smf 2.o.15

[daveb47]

Getting this error when converting,any help appreciated
U

nknown system variable 'SQL_MAX_JOIN_SIZE'

[daveb47]

ok got past this by editing convert.php.

Now got another errorwhen converting

Code Select Expand


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

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

Code Select Expand

Invalid activation code

[daveb47]

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

Code: [Select]

Invalid activation code

Now sorted this by copy/paste link in email

[vbgamer45]

For

"    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"

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

[vbgamer45]

No part of the MYSQL config
On your server on linux it is normally in /etc/my.cnf
Windows it is in my.ini

[daveb47]

Sorry to be a pain but my.conf doesnt contain
sql_mode=""
or do i just add this?

Code Select Expand

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysqld]
performance-schema=0
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
# sort_buffer_size = 2M
# read_rnd_buffer_size = 2M
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
innodb_buffer_pool_size=24117248
max_allowed_packet=268435456
open_files_limit=10000
innodb_file_per_table=1

[vbgamer45]

I would just add it.