How to Solve #1067 – Invalid default value for ‘last_modified’

How to Solve #1067 – Invalid default value for ‘last_modified’

Today When I was going to restore WordPress Database through Phpmyadmin, I saw this notice.

SQL query:

CREATE TABLE `wp_stt2_meta` (

`post_id` INT( 20 ) ,
`meta_value` VARCHAR( 255 ) ,
`meta_count` INT( 20 ) DEFAULT '1',
PRIMARY KEY ( `post_id` , `meta_value` ) ,
UNIQUE `meta_value` ( `meta_value` )

)/*! engine=MyISAM */;

MySQL said: 

#1067 - Invalid default value for 'last_modified' 

Its a really frustrating, when something happen like this. I digg something and found the solution.

The Solution:

This happens, when you use the Plugin “SEO SearchTerms Tagging 2

The Solution is Simple. if you have functional wordpress site, Go to Plugins > Installed Plugins

1) Deactivate the plugin “SEO SearchTerms Tagging 2

2) Install “WP-DBManager” and activate it. Ignore the red notice if you get something in the header.

3) From Dashboard you can now have access to drop Database Tables. So From Dashboard go to

Database > Empty/Drop Table

4) Select the “wp_stt2_meta” as drop and click drop.

5) Create now a Database Backup without “wp_stt2_meta” table. and you can restore it now.

Dont be Selfish, Share this:

Leave a Reply

Your email address will not be published. Required fields are marked *