Error with respect to database

Resolved devansh1995
(@devansh1995)

5 years, 10 months ago

hello team .. my rankmath plugin isn’t working. It shows some error related to database tables. Please refer the log below and help asap –

) made by activate_plugin, do_action(‘activate_seo-by-rank-math/rank-math.php’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Installer->activation, RankMath\Installer->activate, RankMath\Installer->create_tables, dbDelta
KEY (redirection_id)
PRIMARY KEY (id),
is_redirected TINYINT(1) NOT NULL DEFAULT ‘0’,
object_type VARCHAR(10) NOT NULL DEFAULT ‘post’,
object_id BIGINT(20) UNSIGNED NOT NULL DEFAULT ‘0’,
redirection_id BIGINT(20) UNSIGNED NOT NULL,
from_url TEXT CHARACTER SET COLLATE _bin NOT NULL,
id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
obje’ at line 3 for query CREATE TABLE IF NOT EXISTS wzxtj_rank_math_redirections_cache (
redirection_id BIGINT(20) UNSIGNED NOT NULL,
[19-Jul-2020 05:12:43 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘COLLATE _bin NOT NULL,
) made by activate_plugin, do_action(‘activate_seo-by-rank-math/rank-math.php’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Installer->activation, RankMath\Installer->activate, RankMath\Installer->create_tables, dbDelta
KEY (status)
PRIMARY KEY (id),
last_accessed DATETIME NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
updated DATETIME NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
created DATETIME NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
status VARCHAR(25) NOT NULL DEFAULT ‘active’,
hits BIGINT(20) UNSIGNED NOT NULL DEFAULT ‘0’,
header_code SMALLINT(4) UNSIGNED NOT NULL,
url_to TEXT NOT NULL,
sources TEXT CHARACTER SET COLLATE _bin NOT NULL,
id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
header_code SMALLINT(4) UNS’ at line 3 for query CREATE TABLE IF NOT EXISTS wzxtj_rank_math_redirections (
url_to TEXT NOT NULL,
[19-Jul-2020 05:12:43 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘COLLATE _bin NOT NULL,
) made by activate_plugin, do_action(‘activate_seo-by-rank-math/rank-math.php’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Installer->activation, RankMath\Installer->activate, RankMath\Installer->create_tables, dbDelta
KEY (redirection_id)
PRIMARY KEY (id),
is_redirected TINYINT(1) NOT NULL DEFAULT ‘0’,
object_type VARCHAR(10) NOT NULL DEFAULT ‘post’,
object_id BIGINT(20) UNSIGNED NOT NULL DEFAULT ‘0’,
redirection_id BIGINT(20) UNSIGNED NOT NULL,
from_url TEXT CHARACTER SET COLLATE _bin NOT NULL,
id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
obje’ at line 3 for query CREATE TABLE IF NOT EXISTS wzxtj_rank_math_redirections_cache (
redirection_id BIGINT(20) UNSIGNED NOT NULL,
[19-Jul-2020 05:06:36 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘COLLATE _bin NOT NULL,
) made by activate_plugin, do_action(‘activate_seo-by-rank-math/rank-math.php’), WP_Hook->do_action, WP_Hook->apply_filters, RankMath\Installer->activation, RankMath\Installer->activate, RankMath\Installer->create_tables, dbDelta
KEY (status)
PRIMARY KEY (id),
last_accessed DATETIME NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
updated DATETIME NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
created DATETIME NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
status VARCHAR(25) NOT NULL DEFAULT ‘active’,
hits BIGINT(20) UNSIGNED NOT NULL DEFAULT ‘0’,
header_code SMALLINT(4) UNSIGNED NOT NULL,
url_to TEXT NOT NULL,
sources TEXT CHARACTER SET COLLATE _bin NOT NULL,
id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
header_code SMALLINT(4) UNS’ at line 3 for query CREATE TABLE IF NOT EXISTS wzxtj_rank_math_redirections (
url_to TEXT NOT NULL,
[19-Jul-2020 05:06:36 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘COLLATE _bin NOT NULL,
[19-Jul-2020 05:06:18 UTC] .htaccess does not contain default Really Simple SSL redirect
[19-Jul-2020 05:06:18 UTC] Mixed content fixer successfully detected
[19-Jul-2020 05:06:00 UTC] Mixed content fixer successfully detected
[19-Jul-2020 05:05:56 UTC] converting siteurl and homeurl to https
[19-Jul-2020 05:05:56 UTC] retrieving redirect rules
[19-Jul-2020 05:05:56 UTC] .htaccess does not contain default Really Simple SSL redirect
[19-Jul-2020 05:05:56 UTC] checking if .htaccess can or should be edited…
[19-Jul-2020 05:05:56 UTC] htaccess rules tested successfully.
[19-Jul-2020 05:05:56 UTC] test page url, enter in browser to check manually: https://castudyweb.com/wp-content/plugins/really-simple-ssl/testssl/cloudflare/ssl-test-page.html
[19-Jul-2020 05:05:56 UTC] testing htaccess rules…
[19-Jul-2020 05:05:56 UTC] SSL Configuration
[19-Jul-2020 05:05:56 UTC] SSL test page loaded successfully
[19-Jul-2020 05:05:56 UTC] test page url, enter in browser to check manually: https://castudyweb.com/wp-content/plugins/really-simple-ssl/ssl-test-page.php
[19-Jul-2020 05:05:56 UTC] retrieving redirect rules
[19-Jul-2020 05:05:55 UTC] Opening testpage to check server configuration: https://castudyweb.com/wp-content/plugins/really-simple-ssl/ssl-test-page.php
[19-Jul-2020 05:05:55 UTC] Detecting configuration
[19-Jul-2020 04:46:42 UTC] .htaccess does not contain default Really Simple SSL redirect
[19-Jul-2020 04:46:42 UTC] Mixed content fixer successfully detected
[19-Jul-2020 04:44:31 UTC] Mixed content fixer successfully detected
[19-Jul-2020 04:44:27 UTC] converting siteurl and homeurl to https
[19-Jul-2020 04:44:27 UTC] retrieving redirect rules
[19-Jul-2020 04:44:27 UTC] .htaccess does not contain default Really Simple SSL redirect
[19-Jul-2020 04:44:27 UTC] checking if .htaccess can or should be edited…
[19-Jul-2020 04:44:27 UTC] htaccess rules tested successfully.
[19-Jul-2020 04:44:27 UTC] test page url, enter in browser to check manually: https://castudyweb.com/wp-content/plugins/really-simple-ssl/testssl/cloudflare/ssl-test-page.html
[19-Jul-2020 04:44:26 UTC] testing htaccess rules…
[19-Jul-2020 04:44:26 UTC] SSL Configuration
[19-Jul-2020 04:44:26 UTC] SSL test page loaded successfully
[19-Jul-2020 04:44:26 UTC] test page url, enter in browser to check manually: https://castudyweb.com/wp-content/plugins/really-simple-ssl/ssl-test-page.php
[19-Jul-2020 04:44:25 UTC] Opening testpage to check server configuration: https://castudyweb.com/wp-content/plugins/really-simple-ssl/ssl-test-page.php
[19-Jul-2020 04:44:25 UTC] Detecting configuration
[19-Jul-2020 03:26:50 UTC] .htaccess does not contain default Really Simple SSL redirect
[19-Jul-2020 03:26:50 UTC] Mixed content fixer could not be detected: cURL error
[19-Jul-2020 03:25:54 UTC] Mixed content fixer could not be detected: cURL error
[19-Jul-2020 03:25:48 UTC] converting siteurl and homeurl to https
[19-Jul-2020 03:25:48 UTC] retrieving redirect rules
[19-Jul-2020 03:25:48 UTC] .htaccess does not contain default Really Simple SSL redirect
[19-Jul-2020 03:25:48 UTC] checking if .htaccess can or should be edited…
[19-Jul-2020 03:25:48 UTC] htaccess rules tested successfully.
[19-Jul-2020 03:25:48 UTC] test page url, enter in browser to check manually: https://castudyweb.com/wp-content/plugins/really-simple-ssl/testssl/cloudflare/ssl-test-page.html
[19-Jul-2020 03:25:48 UTC] testing htaccess rules…
[19-Jul-2020 03:25:48 UTC] SSL Configuration
[19-Jul-2020 03:25:47 UTC] Detecting configuration
[18-Jul-2020 20:58:06 UTC] PHP Warning: exec(): Unable to fork [/usr/syno/bin/gifsicle –version 2>&1] in /home3/castudyw/public_html/wp-content/plugins/ewww-image-optimizer/unique.php on line 1340
[18-Jul-2020 20:58:06 UTC] PHP Warning: exec(): Unable to fork [/usr/gnu/bin/gifsicle –version 2>&1] in /home3/castudyw/public_html/wp-content/plugins/ewww-image-optimizer/unique.php on line 1340
[18-Jul-2020 20:58:06 UTC] PHP Warning: exec(): Unable to fork [/usr/local/bin/gifsicle –version 2>&1] in /home3/castudyw/public_html/wp-content/plugins/ewww-image-optimizer/unique.php on line 1340

The page I need help with: [log in to see the link]

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

Plugin Author Rank Math SEO
(@rankmath)

5 years, 10 months ago

Hello @devansh1995

Thank you for contacting the support and sorry for any inconvenience that might have been caused due to that.

Can you please reinstall the plugin and see if that helps?

Looking forward to helping you.

Plugin Author Rank Math SEO
(@rankmath)

5 years, 10 months ago

Hello,

Assuming you are using the latest version of all the plugins, themes & WordPress and the issue is resolved, we are closing this topic.

If that is not the case, please feel free to open a new support topic or reply to this one and we will be more than happy to assist.

Thank you.

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

The topic ‘Error with respect to database’ is closed to new replies.