Does not create tables on activation.

  • Resolved Stonehenge Creations

    (@duisterdenhaag)


    3 years, 5 months ago

    I tried activating Yoast on WP MultiSite. If fails when activated network-wide or single site only.
    Upon activation (and deactivation) the debug.log is flooded with “table does not exist” errors. And indeed, the plugin does not create any table in my database.
    Unfortuantely the debug.log does not show the file and line (as is default), but only the namespaces.

    For example:
    WordPress database error Table 'XXXX.wp_yoast_indexable' doesn't exist for query UPDATEwp_yoast_indexableSETpermalink= NULL,permalink_hash= NULL made by do_action_ref_array('wpseo_permalink_structure_check'), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Watchers\Indexable_HomeUrl_Watcher->force_reset_permalinks, Yoast\WP\SEO\Integrations\Watchers\Indexable_HomeUrl_Watcher->reset_permalinks, Yoast\WP\SEO\Helpers\Indexable_Helper->reset_permalink_indexables, Yoast\WP\SEO\Repositories\Indexable_Repository->reset_permalink, Yoast\WP\Lib\ORM->update_many, Yoast\WP\Lib\ORM::execute

    I have cleared the options for each blog (looping through the prefixes) with a SQL query:
    SELECT * FROM {prefix}_options WHERE option_name LIKE '%wpseo%'

    Could you please tell me in which file I can find the method that should create the tables, so I can create them manually?

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support Maybellyne

    (@maybellyne)

    Hello,

    We are sorry about that WordPress database error. We think that resetting the indexing tables on your site should solve this issue. Can you please follow these steps and check if the errors are resolved?:

    – Make sure the Yoast SEO plugin is activated.
    – Install & activate the Yoast Test Helper plugin.
    – Go to Tools -> Yoast Test
    – Hit the “Reset indexables & migrations” button
    – Click the “Start processing and speed up your site now” button in SEO > Tools.

    Please note that, while the above instructions are safe, we always recommend having a current, full backup of your site for safety reasons.

    Do let us know how it goes.

    Thread Starter Stonehenge Creations

    (@duisterdenhaag)

    No, unfortunately that did not solve the issue.

    Could you please tell me in which file I can find the method that should create the tables, so I can create them manually?

    Plugin Support Maybellyne

    (@maybellyne)

    Sorry, that didn’t work out. For Yoast SEO to work, it needs to be able to create tables in your database. Yoast SEO will show you an error message when we are unable to create tables automatically.

    You don’t have to fix this yourself. Instead, you can ask your host to fix this for you. You can find how to handle this issue and an example of the email you can use to write to your web hosting in this help article: https://yoast.com/help/cannot-create-database-tables/.

    Thread Starter Stonehenge Creations

    (@duisterdenhaag)

    Yoast SEO will show you an error message when we are unable to create tables automatically.

    No, it does not… Only get a flood debug.log that the table does not exist.

    Please just point me to the correct file.

    Plugin Support Suwash

    (@suascat_wp)

    @duisterdenhaag

    As per the initial debug log info, it suggests that the table doesn’t exist or hasn’t been created with the right permissions or something similar. I understand you’ve already checked permissions but I really suspect something goes wrong with the creation of the database tables required for our indexation.

    Can you answer/check the following (again):

    – What are your current permissions for your database user?
    – Is the Yoast tables XXXX.wp_yoast_indexable created and visible when you check your database?

    We look forward to hearing from you.`

    Thread Starter Stonehenge Creations

    (@duisterdenhaag)

    I have all permissions and all other tables are being created without any hassle. The only ones that are not being created are those for Yoast.

    Since I asked the simple question multiple times and do not seem to get that answer, I will use a different SEO tool and close this unsolved topic.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Does not create tables on activation.’ is closed to new replies.