wp_aioseo_cache – Errors – db

  • Resolved flecky

    (@flecky)


    3 months ago

    hello i get a few different error logs like that:

    FastCGI sent in stderr: “PHP message: WordPress database error Incorrect integer value: ” for column c0_musics.music_aioseo_cache.is_object at row 1 for query INSERT INTO music_aioseo_cache

    SET key = ‘db_schema’, value = ‘{\”music_aioseo_ai_insights_keyword_reports\”:[\”id\”,\”uuid\”,\”keyword\”,\”status\”,\”brands\”,\”brands_mentioned\”,\”results\”,\”created\”,\”updated\”],\”music_users\”:[\”ID\”,\”user_login\”,\”user_pass\”,\”user_nicename\”,\”user_email\”,\”user_url\”,\”user_registered\”,\”user_activation_key\”,\”user_status\”,\”display_name\”],\”music_amz_products\”:[\”id\”,\”post_id\”,\”post_parent\”,\”type\”,\”title\”,\”nb_assets\”,\”nb_assets_done\”,\”status\”],\”music_wc_category_lookup\”:[\”category_tree_id\”,\”category_id\”],\”music_wc_order_operational_data\”:[\”id\”,\”order_id\”,\”created_via\”,\”woocommerce_version\”,\”prices_include_tax\”,\”coupon_usages_are_counted\”,\”download_permission_granted\”,\”cart_hash\”,\”new_order_email_sent\”,\”order_key\”,\”order_stock_reduced\”,”

    the table is empty. i ´ve already createt a new music_aioseo_cache, but its not helping. also manually inserting doesent help.

    thank you

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Shivam Tyagi

    (@shivamtyagi)

    3 months ago

    Hi @flecky ,

    Thanks for sharing the full error log.

    This error usually happens when the aioseo_cache table schema doesn’t match what AIOSEO expects. In that case, even if the table exists, inserts can fail with errors like the one you’re seeing.

    Because this involves database schema, the best next step would be to have you reach out to us directly so we can guide you safely and confirm the correct structure for your install.

    Please contact us through our support form here (click on “submit our Basic Question form”):
    https://aioseo.com/contact/

    Once you submit the form, we’ll be happy to take a look and help you get this fixed.

    Thread Starter flecky

    (@flecky)

    3 months ago

    if someone else is looking up for this..

    this code fixed the entire bug in mysql. but its just a workaround.

    [mysqld]
    sql_mode = NO_ENGINE_SUBSTITUTION,ERROR_FOR_DIVISION_BY_ZERO

    then restart mysql.

    Plugin Support Shivam Tyagi

    (@shivamtyagi)

    3 months ago

    Hi @flecky,

    Thanks a lot for coming back and sharing this!

    Changing MySQL’s sql_mode can absolutely affect how strict MySQL is about inserts (for example when an empty string is inserted into an integer column), so it makes sense that this resolved the errors on your server.

    That said, just as a note for anyone else reading: updating the global MySQL sql_mode is more of a server-level workaround and may have side effects for other sites/apps using the same database server.

    In most cases, this error points to a schema/migration mismatch (where the aioseo_cache table structure doesn’t fully match what AIOSEO expects), so the recommended fix is still to confirm that the AIOSEO DB schema/migrations completed correctly.

    If anyone runs into this and needs help verifying the expected table structure safely, please reach out to us directly here (click on “submit our Basic Question form”):

    https://aioseo.com/contact/

    Thanks again for posting your solution — really appreciate you taking the time to help others!

Viewing 3 replies - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

Tags