• WP 4.9.7
    I just purchased SEO Redirection Premium, installed, activated, went to Settings.

    These SQL errors are presented below.
    How do I fix this?

    WordPress database error: [Unknown column ‘cat’ in ‘where clause’]

    select count(*) as cnt from wp_WP_SEO_Redirection where cat=’link’ and grpID=1
    select count(*) as cnt from wp_WP_SEO_Redirection where cat=’link’ and grpID=2
    select count(*) as cnt from wp_WP_SEO_Redirection where cat=’link’ and grpID=3
    select count(*) as cnt from wp_WP_SEO_Redirection where cat=’link’ and blog=’1′ and redirect_from_type <> ‘Replace’ order by ID desc
    select ID, redirect_from, redirect_from_type, enabled, redirect_to, redirect_to_type, redirect_type, (SELECT count(ID) FROM wp_WP_SEO_Redirection_LOG where rfrom = redirect_from and rto = redirect_to ) as redirect_hits, (SELECT ctime FROM wp_WP_SEO_Redirection_LOG where rfrom = redirect_from and rto = redirect_to order by ctime desc limit 1) as redirect_last_access from wp_WP_SEO_Redirection where cat=’link’ and blog=’1′ and redirect_from_type <> ‘Replace’ order by ID desc limit 0,10

    WordPress database error: [Unknown column ‘blog’ in ‘where clause’]
    delete from wp_WP_SEO_404_links where blog=’1′ and link=’blog.sohnen-moe.com/’

    WordPress database error: [Unknown column ‘blog’ in ‘where clause’]
    select redirect_from from wp_WP_SEO_Redirection where blog=’1′ and redirect_from=’blog.sohnen-moe.com/’ and cat=’link’

    WordPress database error: [Unknown column ‘grpID’ in ‘field list’]
    insert into wp_WP_SEO_Redirection(enabled,grpID,redirect_from_type,redirect_from_folder_settings,redirect_from_subfolders,redirect_to_type,redirect_to_folder_settings,redirect_type,redirect_from,redirect_to,cat,regex,blog) values(‘1′,’1′,’EndWith’,’1′,’0′,’Page’,”,’301′,’blog.sohnen-moe.com/’,’/blog/’,’link’,’^.*blog\\.sohnen\\-moe\\.com\\/$’,’1′)

    • This topic was modified 7 years, 10 months ago by jimoe.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter jimoe

    (@jimoe)

    Later: I am extremely pissed off. Even after un-installing SEO Redirection, I was still presented with loads of SQL errors when loading any page of the site. I had to restore the site from backup to clear the mess.

    Moderator Jan Dembowski

    (@jdembowski)

    Forum Moderator and Brute Squad

    I just purchased SEO Redirection Premium,

    For pro or commercial product support please contact the author directly on their site. This includes any pre-sales topics as well.

    As the author is aware, commercial products are not supported in these forums. I am sure they will have no problem supporting you there.

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

The topic ‘SEO Premium install: SQL errors’ is closed to new replies.