SEO Extension

Provide SEO Extension to CMS Pages, Static Pages, Blog post with meta & open graph tags

Back to SEO Extension Support

Scott
Scott

There appears to be a problem with the down methods for this plugin while attempting to remove the plugin after removing the blog plugin. You should probably check for the existence of this column/table before attempting to remove it

SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'seo_title'; check that column/key exists (SQL: alter table `rainlab_blog_posts`)

Last updated

Steven Walker
Steven Walker

+1 on this one.

Probably due to having installed the blog plugin AFTER this SEO one. However Scott is totally right, checking for this column before attempting to remove would resolve this issue.

Edit: Just noticed how long ago this was posted (2 months!) and due to lack of reply from the creator I removed the plugin myself.

For those wondering how: Open up /plugins/anandpatel/seoextension/updates/create_blog_posts_table.php Within the down function make note of the columns listed. Check the SQL Database table for these columns and remove any found. Remove all of the code within the down() function. Remove plugin via backend.

Success!

Last updated

artfaulit26492
artfaulit26492

http://prntscr.com/hcwdqb - screenshot error. When I install the plugin, the old tables in the database are not overwritten...

"SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP 'seo_title'; check that column/key exists (SQL: alter table rainlab_blog_posts drop seo_title)" on line 666 of /home/g4g4f4gr5gh5/public_html/artfaul.net/vendor/laravel/framework/src/Illuminate/Database/Connection.php

Psharp
Psharp

Thanks Steven Walker, this solved my issue.

Steven Walker said:

+1 on this one.

Probably due to having installed the blog plugin AFTER this SEO one. However Scott is totally right, checking for this column before attempting to remove would resolve this issue.

Edit: Just noticed how long ago this was posted (2 months!) and due to lack of reply from the creator I removed the plugin myself.

For those wondering how: Open up /plugins/anandpatel/seoextension/updates/create_blog_posts_table.php Within the down function make note of the columns listed. Check the SQL Database table for these columns and remove any found. Remove all of the code within the down() function. Remove plugin via backend.

Success!

1-4 of 4