The current repo belongs to Paused status, and some functions are restricted. For details, please refer to the description of repo status
168 Star 527 Fork 164

Kenvix / Tieba-Cloud-Sign
Paused

 / 详情

百度贴吧云签到 V4.8 (PHP 7.1.4) 在工作时发生致命的异常 @ 2017-04-17 16:04:05

Backlog
Opened this issue  
2017-04-17 16:07

消息:#10000 - MySQL 语句执行错误:
语句:CREATE TABLE IF NOT EXISTS tb_wmzz_zan ( id int(255) NOT NULL AUTO_INCREMENT , uid int(255) NOT NULL , num int(255) NULL DEFAULT 0 , lastdo date NOT NULL DEFAULT '0000-00-00' , PRIMARY KEY (id, uid), UNIQUE INDEX uid (uid) USING BTREE ) ENGINE=MyISAM DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci AUTO_INCREMENT=3 CHECKSUM=0 ROW_FORMAT=DYNAMIC DELAY_KEY_WRITE=0 ;
错误:#1067 - Invalid default value for 'lastdo'

文件 行 代码
/miku/wwwroot/tieba.hi.cn/lib/class.mysqli.php 120 [抛出异常]
/miku/wwwroot/tieba.hi.cn/plugins/Cloud_Click/Cloud_Click_callback.php 8 query
/miku/wwwroot/tieba.hi.cn/lib/plugins.php 33 callback_init
/miku/wwwroot/tieba.hi.cn/setting.php 27 activePlugin

Comments (4)

MikuSama created 任务

这个插件的安装脚本有问题,正常情况下不应该使用0000-00-00作为默认日期。这个和云签到本身无关。

不过这也和你的mysql环境有关,你的mysql开启了严格模式,所以0000-00-00被判定为无效日期。你可以在my.cnf中注释STRICT_TRANS_TABLES

详情参考stackoverflow上面的问题:http://stackoverflow.com/questions/36374335/error-in-mysql-when-setting-default-value-for-date-or-datetime

建议你给插件的repo也发一个issue。

@Howard Liu 这个情况我换php版本跟mysql版本就好了。但是还是有几个插件不兼容= =!

@Howard Liu 智者的点赞插件...

Sign in to comment

Status
Assignees
Milestones
Pull Requests
Successfully merging a pull request will close this issue.
Branches
Planed to start   -   Planed to end
-
Top level
Priority
参与者(4)
473042 fsgmhoward 1578924974 881708 mikushare 1578934779 298444 fyy99 1578919603
PHP
1
https://git.oschina.net/kenvix/Tieba-Cloud-Sign.git
git@git.oschina.net:kenvix/Tieba-Cloud-Sign.git
kenvix
Tieba-Cloud-Sign
Tieba-Cloud-Sign

Search

182229 41614e54 1850385 182230 7885ed45 1850385