Database error

  • Resolved ajtothec

    (@ajtothec)


    5 years, 11 months ago

    Hey guys,

    I get this error in the logs:
    [14-May-2020 02:31:47 UTC] WordPress database error Table ‘cxxx_cto.wp_4_cf_geo_seo_redirection’ doesn’t exist for query
    SELECT
    TRIM(url) AS url,
    TRIM(LOWER(country)) AS country,
    TRIM(LOWER(region)) AS region,
    TRIM(LOWER(city)) AS city,
    http_code AS http_code,
    only_once
    FROM
    wp_4_cf_geo_seo_redirection
    WHERE
    active = 1 AND (TRIM(LOWER(country)) = ‘united states’ OR TRIM(LOWER(country)) = ‘us’ OR TRIM(LOWER(region)) = ‘washington’ OR TRIM(LOWER(region)) = ‘wa’ OR TRIM(LOWER(city)) = ‘quincy’) made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, CF_Geoplugin_SEO_Redirection->wp_seo_redirection

    Any ideas?

Viewing 1 replies (of 1 total)
  • Plugin Author Ivijan-Stefan Stipic

    (@ivijanstefan)

    5 years, 11 months ago

    For the some reason custom MySQL table is not created what our plugin generates.

    That’s happen for the certain MySQL versions and please provide us your database version to we try find some good solution.

    One way you can do is to add table manually following this MySQL query:

    CREATE TABLE IF NOT EXISTS wp_4_cf_geo_seo_redirection (
  id int(11) NOT NULL,
  only_once tinyint(1) NOT NULL DEFAULT '0',
  country varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  region varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  city varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  url varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  http_code int(3) NOT NULL DEFAULT '302',
  active int(1) NOT NULL DEFAULT '1',
  date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

ALTER TABLE wp_4_cf_geo_seo_redirection
 ADD PRIMARY KEY (id);

ALTER TABLE wp_4_cf_geo_seo_redirection
MODIFY id int(1) NOT NULL AUTO_INCREMENT;

    Let me know if this solve the problem.

Viewing 1 replies (of 1 total)

The topic ‘Database error’ is closed to new replies.

Tags