I have a problem with the data base tables

#649334
  • Resolved Anonymous
    Rank Math free

    I’m getting this error in my errorlog file
    2023/10/01 14:59:27 [error] 776#776: *27288 FastCGI sent in stderr: “PHP message: WordPress database error Table ‘sadaninvestment_com_eg_SfkAQpgV._Jawda_rank_math_analytics_objects’ doesn’t exist for query SELECT t2.object_id, SUM(impressions) AS traffic FROM _Jawda_rank_math_analytics_gsc AS t1
    Left JOIN _Jawda_rank_math_analytics_objects AS t2 ON t1.page=t2.page
    WHERE t2.object_id IN ( 6081, 6072, 5978, 5866, 6048, 5927, 6024, 5944, 5933, 5860, 5818, 5809, 5788, 5754, 5671, 5568, 5535, 5457, 5374, 5359, 5209, 5191, 4767, 3694, 4727, 3450, 2397, 2425, 3030, 2673, 2281 ) and t1.created BETWEEN Now() – interval 36 day and Now() – interval 3 day
    GROUP BY t2.object_id made by WP_List_Table->display, WP_List_Table->display_rows_or_placeholder, WP_Posts_List_Table->display_rows, WP_Posts_List_Table->_display_rows, WP_Posts_List_Table->single_row, WP_List_Table->single_row_columns, WP_Posts_List_Table->column_default, do_action(‘manage_projects_posts_custom_column’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Admin\Post_Columns->columns_conten

Viewing 1 replies (of 1 total)
  • Hello,

    Thank you for contacting Rank Math support and we are sorry to hear that you are having trouble with Rank Math. We appreciate your patience and cooperation as we try to resolve this issue for you.

    Please try the following and let us know if it helps:

    • Make sure that you have the latest version of Rank Math Free and PRO installed on your website. You can check the changelog here.
    • Go to WP Dashboard > Rank Math > Dashboard and select the Advanced Mode option. This will enable more features and settings for Rank Math.

      advanced mode

    • Go to WP Dashboard > Rank Math > Status & Tools > Database Tools and click the Re-create database Table button. This will create the necessary tables for Rank Math Analytics.

      re-create-analytics-tables

    • On the same page, click the Fix Collations button. This will check and fix any database collations issues that might affect Rank Math Analytics.

      fix-collations

    Please let us know if this helps or if you need further assistance. Thank you for choosing Rank Math.

    Hello,

    Since we did not hear back from you for 15 days, we are assuming that you found the solution. We are closing this support ticket.

    If you still need assistance or any other help, please feel free to open a new support ticket, and we will be more than happy to assist.

    Thank you.

Viewing 1 replies (of 1 total)

The ticket ‘I have a problem with the data base tables’ is closed to new replies.