1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.2 MySql error when importing

Discussion in 'Installation, Upgrade, and Import Support' started by Earl, Jan 10, 2014.

  1. Earl

    Earl Member

    Im importing a large vbulleting 3.8 forum to xenforo 1.2

    importing script from the admincp showing no errors and smoothly increasing the percentage of import without any issues

    but when i checked the mysql error log i see large numebrs of errors like this

    Code:
    140110  8:26:14 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave. Statement: UPDATE xf_thread
                            INNER JOIN (
                                    SELECT thread_id, COUNT(*) AS total
                                    FROM xf_thread_view
                                    GROUP BY thread_id
                            ) AS xf_tv ON (xf_tv.thread_id = xf_thread.thread_id)
                            SET xf_thread.view_count = xf_thread.view_count + xf_tv.total
    140110  8:26:14 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statements writing to a table with an auto-increment column after selecting from another table are unsafe because the order in which rows are retrieved determines what (if any) rows will be written. This order cannot be predicted and may differ on master and the slave. Statement: UPDATE xf_attachment
                            INNER JOIN (
                                    SELECT attachment_id, COUNT(*) AS total
                                    FROM xf_attachment_view
                                    GROUP BY attachment_id
                            ) AS xf_av ON (xf_av.attachment_id = xf_attachment.attachment_id)
                            SET xf_attachment.view_count = xf_attachment.view_count + xf_av.total
    140110  8:26:15 [Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. INSERT... ON DUPLICATE KEY UPDATE  on a table with more than one UNIQUE KEY is unsafe Statement: INSERT INTO xf_deferred
                                    (execute_class, execute_data, unique_key, manual_execute, trigger_date)
                            VALUES
                                    ('Cron', 'a:0:{}', 'cron', '0', '1389360614')
                            ON DUPLICATE KEY UPDATE
                                    execute_class = VALUES(execute_class),
                                    execute_data = VALUES(execute_data),
                                    manual_execute = VALUES(manual_execute),
                                    trigger_date = VALUES(trigger_date)
    

    Here is the full error log file: http://pastebin.com/DgekSMpE

    Is it normal or is there any issue?
    Running
    mysql-5.5.35-1.el6.remi.x86_64 on centos 6.3
     
    Last edited: Jan 10, 2014
  2. Mike

    Mike XenForo Developer Staff Member

    Earl likes this.
  3. Earl

    Earl Member

    Last edited: Jan 10, 2014
  4. Mike

    Mike XenForo Developer Staff Member

    Correct.
     

Share This Page