我已使用将WordPress网站移动到Azure网站+Azure SQLdatabase abstraction plugin
迁移之后,我无法创建新帖子。当我单击保存草稿时,它会将我重定向到帖子页面,而我的帖子不会保存。错误为:
WordPress database error 22007 : [Microsoft][SQL Server Native Client 11.0][SQL Server]The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value.
for query INSERT INTO wp_posts (post_author,post_date,post_date_gmt,post_content,post_content_filtered,post_title,post_excerpt,post_status,post_type,comment_status,ping_status,post_password,post_name,to_ping,pinged,post_modified,post_modified_gmt,post_parent,menu_order,guid)
VALUES (540, N\'2014-08-01 08:52:44\', N\'0000-00-00 00:00:00\', N\'\', N\'\', N\'Auto Draft\', N\'\', N\'auto-draft\', N\'post\', N\'closed\', N\'closed\', N\'\', N\'\', N\'\', N\'\', N\'2014-08-01 08:52:44\', N\'0000-00-00 00:00:00\',0,0, N\'\')
made by wp_dashboard, do_meta_boxes, call_user_func, wp_dashboard_quick_press, get_default_post_to_edit, wp_insert_post, pdo_wpdb->query, pdo_wpdb->_post_query, pdo_wpdb->print_error
我已尝试解决
staticdeadlock 和
JohnieBraaf explained here, 没有运气:
我很难从“快速草稿”部分创建新帖子,但几分钟后,我意识到它更新了现有帖子。
你们中有谁使用过这个插件,并注意到它在任何特定的WordPress版本中都工作得更好吗?有谁遇到过同样的问题并找到了解决方案?
这是我的wp配置的一部分。php
/** Database Type. Defaults to mysql */
define(\'DB_TYPE\', \'pdo_sqlsrv\');
/** Database Charset to use in creating database tables. */
define(\'DB_CHARSET\', \'utf8\');
/** The Database Collate type. Don\'t change this if in doubt. */
define(\'DB_COLLATE\', \'\');