Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-11160

Update to 3.0.11 fails - MySQL error.. (cross join too big)

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Won't Fix
    • Affects Version/s: 3.0.10
    • Fix Version/s: 3.0.15-RC1
    • Component/s: Update system
    • Labels:
      None
    • Environment:
      MySQL 5.1.63-0+squeeze1

      Description

      Our forum has around 1,2 million posts and 54 000 topics..

      I get the following error when trying to update from 3.0.10 to 3.0.11.


      Progress :: SQL ERROR [ mysqli ]

      The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay [1104]

      SQL

      SELECT p.msg_id FROM (phpbb3_privmsgs p) LEFT JOIN phpbb3_privmsgs_to t ON (p.msg_id = t.msg_id) WHERE t.user_id IS NULL LIMIT 500

      BACKTRACE

      FILE: [ROOT]/includes/db/mysqli.php
      LINE: 182
      CALL: dbal->sql_error()

      FILE: [ROOT]/includes/db/mysqli.php
      LINE: 224
      CALL: dbal_mysqli->sql_query()

      FILE: [ROOT]/includes/db/dbal.php
      LINE: 170
      CALL: dbal_mysqli->_sql_query_limit()

      FILE: [ROOT]/install/database_update.php
      LINE: 2083
      CALL: dbal->sql_query_limit()

      FILE: [ROOT]/install/database_update.php
      LINE: 414
      CALL: change_database_data()


      We use One.com as web hosting and they have the following limitations which they refuse to change:

      MAX_JOIN_SIZE = 33554432
      SQL_BIG_SELECTS = 0

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                CHItA CHItA
                Reporter:
                Riborg Riborg [X] (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: