sql - mysql current_timestamp issue in phpMyAdmin openshift db client -


when try execute query in openshift phpmyadmin client getting below error:

#1293 - incorrect table definition; there can 1 timestamp column current_timestamp in default or on update clause

when trying execute below query, getting above issue in openshift:

`created_dttm` timestamp not null default '0000-00-00 00:00:00', `modified_dttm` timestamp not null default current_timestamp on update current_timestamp, 

but in local have heidisql client working properly, both in openshift , local uses same mysql 5.1 version, don't know how fix this.


Comments

Popular posts from this blog

rest - Spring boot: Request method 'PUT' not supported -

php - Magento - Deleted Base url key -

symfony - imagine_filter() not generating the correct url in LiipImagineBundle -