← Back to SEO Extension Support
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
+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
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
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