Error:SQLSTATE[42000]:

  • Resolved Local

    (@fullctrl)


    10 months, 3 weeks ago

    Hi,

    I have some problems importing fra Joomla to WP. I have exported the Joomla, and installed in on the same database with phpMyAdmin but I still can’t get the import to work as I get this error;

    [ERROR] Error:SQLSTATE[42000]: Syntax error or access violation: 1104 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

    I’ve chatted with my hosting and got this reply:
    ?
    The error is related to a SELECT query with a large number of rows, causing the SQL query to fail. This issue is associated with the plugin you use to import the database, which requires adjusting the configuration settings or script. Unfortunately, we are unable to assist further, as the database structure in Joomla is not precisely the same as in WordPress, even though both platforms use MySQL.?

    Can you help me?

Viewing 13 replies - 1 through 13 (of 13 total)
  • Plugin Author Kerfred

    (@kerfred)

    When does this message happen?

    Thread Starter Local

    (@fullctrl)

    When I’ve started the import, this is the message in the log:

    HTTP connection successful
    Importing categories…
    36 categories imported
    Importing posts…
    [ERROR] Error:SQLSTATE[42000]: Syntax error or access violation: 1104 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
    0 posts imported
    1 links category imported
    Importing web links…
    0 web links imported
    0 medias imported
    Don’t forget to modify internal links.
    IMPORT COMPLETED

    Plugin Author Kerfred

    (@kerfred)

    What is the value of MAX_JOIN_SIZE on your MySQL server?
    You can get it by running this SQL request on phpMyAdmin:

    SHOW?VARIABLES?LIKE?'max_join_size';
    Thread Starter Local

    (@fullctrl)

    max_join_size 67108864

    Plugin Author Kerfred

    (@kerfred)

    Try to type:

    SET MAX_JOIN_SIZE=18446744073709551615

    as a SQL request in phpMyAdmin. Then retry the import.

    Thread Starter Local

    (@fullctrl)

    I got a feedback from my hosting saying;

    MAX_JOIN_SIZE is a server-wide parameter and for that, it can’t be changed in a shared MySQL server which we have.

    Any other way for me to import the joomla?

    Plugin Author Kerfred

    (@kerfred)

    Another solution is to run the migration in local. In this case, you won’t have the limitations of the server.

    Here is the procedure for Windows: https://www.fredericgilles.net/migrate-wordpress-local-windows-server/ and for Mac: https://www.fredericgilles.net/how-to-migrate-to-wordpress-from-various-cms-on-a-mac-mamp-server/

    Thread Starter Local

    (@fullctrl)

    Hi, before I try the local migration, I tried another host (pressable).
    Now I have added the SQL files to the same database, but still get an error;

    [ERROR] Joomla tables not found. Please make sure you have entered the right Joomla database name and table prefix.

    But I use the prefix that’s in the database (I do have several), and the right database name..
    Any idea? ??

    • This reply was modified 10 months, 3 weeks ago by Local.
    Plugin Author Kerfred

    (@kerfred)

    If the Joomla tables are in the same database as WordPress, please double check the database name and prefix. And check that all tables are present.

    Thread Starter Local

    (@fullctrl)

    It was all correct, but in the end I ended up with a local migration. Thank you for a great “how-to”, made it so easy and saved me so much time!!

    Plugin Author Kerfred

    (@kerfred)

    You are welcome.

    Thread Starter Local

    (@fullctrl)

    And just a dummy question from a noob; now that I have migrated the Joomla to WordPress, and then exported from the local site to the “live-site” – can I delete the wordpress.test that is located in Wamp?

    Plugin Author Kerfred

    (@kerfred)

    Yes, you can do it safely.

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Error:SQLSTATE[42000]:’ is closed to new replies.