坚守BOBLOG很多年,认为很小众,结果昨天被改文件了,估计程序有BUG想转EMLOG,用了你的转换程序报错,求指点 SQL语句执行错误:ALTER DATABASE emlog DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; DROP TABLE IF EXISTS emlog_blog; CREATE TABLE emlog_blog ( gid mediumint(8) unsigned NOT NULL auto_increment, title varchar(255) NOT NULL default '', date bigint(20) NOT NULL, content longtext NOT NULL, excerpt longtext NOT NULL, alias varchar(255), author int(10) NOT NULL default '1', sortid tinyint(3) NOT NULL default '-1', type varchar(20) NOT NULL default 'blog', views mediumint(8) unsigned NOT NULL default '0', comnum mediumint(8) unsigned NOT NULL default '0', tbcount mediumint(8) unsigned NOT NULL default '0', attnum mediumint(8) unsigned NOT NULL default '0', top enum('n','y') NOT NULL default 'n', hide enum('n','y') NOT NULL default 'n', allow_remark enum('n','y') NOT NULL default 'y', allow_tb enum('n','y') NOT NULL default 'y', password varchar(255) NOT NULL default '', PRIMARY KEY (gid) )ENGINE=MYISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS emlog_attachment; CREATE TABLE emlog_attachment ( aid smallint(5) unsigned NOT NULL auto_increment, blogid mediumint(8) unsigned NOT NULL default '0', filename varchar(255) NOT NULL default '', filesize int(10) NOT NULL default '0', filepath varchar(255) NOT NULL default '', addtime bigint(20) NOT NULL, PRIMARY KEY (aid), KEY blogid (blogid) )ENGINE=MYISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS emlog_comment; CREATE TABLE emlog_comment ( cid mediumint(8) unsigned NOT NULL auto_increment, gid mediumint(8) unsigned NOT NULL default '0', pid mediumint(8) unsigned NOT NULL default '0', date bigint(20) NOT NULL, poster varchar(20) NOT NULL default '', comment text NOT NULL, mail varchar(60) NOT NULL default '', url varchar(75) NOT NULL default '', ip varchar(128) NOT NULL default '', hide enum('n','y') NOT NULL default 'n', PRIMARY KEY (cid), KEY gid (gid) )ENGINE=MYISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS emlog_link; CREATE TABLE emlog_link ( id smallint(4) unsigned NOT NULL auto_increment, sitename varchar(30) NOT NULL default '', siteurl varchar(75) NOT NULL default '', description varchar(255) NOT NULL default '', taxis smallint(4) unsigned NOT NULL default '0', PRIMARY KEY (id) )ENGINE=MYISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS emlog_tag; CREATE TABLE emlog_tag ( tid mediumint(8) unsigned NOT NULL auto_increment, tagname varchar(60) NOT NULL default '', gid text NOT NULL, PRIMARY KEY (tid), KEY tagname (tagname) )ENGINE=MYISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS emlog_sort; CREATE TABLE emlog_sort ( sid tinyint(3) unsigned NOT NULL auto_increment, sortname varchar(255) NOT NULL default '', alias varchar(200) NOT NULL default '', taxis tinyint(3) NOT NULL default '0', PRIMARY KEY (sid) )ENGINE=MYISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS emlog_trackback; CREATE TABLE emlog_trackback ( tbid mediumint(8) unsigned NOT NULL auto_increment, gid mediumint(8) unsigned NOT NULL default '0', title varchar(255) NOT NULL default '', date bigint(20) NOT NULL, excerpt text NOT NULL, url varchar(255) NOT NULL default '', blog_name varchar(255) NOT NULL default '', ip varchar(16) NOT NULL default '', PRIMARY KEY (tbid), KEY gid (gid) )ENGINE=MYISAM DEFAULT CHARSET=utf8; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS emlog_blog; CREATE TABLE emlog_blog ( gid mediumint(8) un' at line 2
博主也是好久不更新了,慢慢也就忘记了吧
请问 /ampindex 生成正常。连接中的地址 /amp/xxx.html 自动跳转到正常页面。请问还应该设置什么吗?
我直接下载amp插件放到 /usr/plugin 目录下启用了。/ampindex 可以显示
@KLL
插件设置里面有一个 “是否只允许百度和谷歌的爬虫访问 AMP/MIP 页面”的选项,改为关闭就可以用浏览器访问了。
@Holmesian
我现在是2.1.2,转换程序好像是2.1,小版本号应该没数据结构上的区别才对,我看看有什么区别
坚守BOBLOG很多年,认为很小众,结果昨天被改文件了,估计程序有BUG想转EMLOG,用了你的转换程序报错,求指点
SQL语句执行错误:ALTER DATABASE emlog DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; DROP TABLE IF EXISTS emlog_blog; CREATE TABLE emlog_blog ( gid mediumint(8) unsigned NOT NULL auto_increment, title varchar(255) NOT NULL default '', date bigint(20) NOT NULL, content longtext NOT NULL, excerpt longtext NOT NULL, alias varchar(255), author int(10) NOT NULL default '1', sortid tinyint(3) NOT NULL default '-1', type varchar(20) NOT NULL default 'blog', views mediumint(8) unsigned NOT NULL default '0', comnum mediumint(8) unsigned NOT NULL default '0', tbcount mediumint(8) unsigned NOT NULL default '0', attnum mediumint(8) unsigned NOT NULL default '0', top enum('n','y') NOT NULL default 'n', hide enum('n','y') NOT NULL default 'n', allow_remark enum('n','y') NOT NULL default 'y', allow_tb enum('n','y') NOT NULL default 'y', password varchar(255) NOT NULL default '', PRIMARY KEY (gid) )ENGINE=MYISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS emlog_attachment; CREATE TABLE emlog_attachment ( aid smallint(5) unsigned NOT NULL auto_increment, blogid mediumint(8) unsigned NOT NULL default '0', filename varchar(255) NOT NULL default '', filesize int(10) NOT NULL default '0', filepath varchar(255) NOT NULL default '', addtime bigint(20) NOT NULL, PRIMARY KEY (aid), KEY blogid (blogid) )ENGINE=MYISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS emlog_comment; CREATE TABLE emlog_comment ( cid mediumint(8) unsigned NOT NULL auto_increment, gid mediumint(8) unsigned NOT NULL default '0', pid mediumint(8) unsigned NOT NULL default '0', date bigint(20) NOT NULL, poster varchar(20) NOT NULL default '', comment text NOT NULL, mail varchar(60) NOT NULL default '', url varchar(75) NOT NULL default '', ip varchar(128) NOT NULL default '', hide enum('n','y') NOT NULL default 'n', PRIMARY KEY (cid), KEY gid (gid) )ENGINE=MYISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS emlog_link; CREATE TABLE emlog_link ( id smallint(4) unsigned NOT NULL auto_increment, sitename varchar(30) NOT NULL default '', siteurl varchar(75) NOT NULL default '', description varchar(255) NOT NULL default '', taxis smallint(4) unsigned NOT NULL default '0', PRIMARY KEY (id) )ENGINE=MYISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS emlog_tag; CREATE TABLE emlog_tag ( tid mediumint(8) unsigned NOT NULL auto_increment, tagname varchar(60) NOT NULL default '', gid text NOT NULL, PRIMARY KEY (tid), KEY tagname (tagname) )ENGINE=MYISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS emlog_sort; CREATE TABLE emlog_sort ( sid tinyint(3) unsigned NOT NULL auto_increment, sortname varchar(255) NOT NULL default '', alias varchar(200) NOT NULL default '', taxis tinyint(3) NOT NULL default '0', PRIMARY KEY (sid) )ENGINE=MYISAM DEFAULT CHARSET=utf8; DROP TABLE IF EXISTS emlog_trackback; CREATE TABLE emlog_trackback ( tbid mediumint(8) unsigned NOT NULL auto_increment, gid mediumint(8) unsigned NOT NULL default '0', title varchar(255) NOT NULL default '', date bigint(20) NOT NULL, excerpt text NOT NULL, url varchar(255) NOT NULL default '', blog_name varchar(255) NOT NULL default '', ip varchar(16) NOT NULL default '', PRIMARY KEY (tbid), KEY gid (gid) )ENGINE=MYISAM DEFAULT CHARSET=utf8;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS emlog_blog; CREATE TABLE emlog_blog ( gid mediumint(8) un' at line 2
@小楼
这个脚本是很早之前写的,对应的boblog版本应该很老,所以sql语句出错了。
@Holmesian
我现在是2.1.2,转换程序好像是2.1,小版本号应该没数据结构上的区别才对,我看看有什么区别
你博客速度不错,用哪里的主机还是有什么特别的优化
@Heresy
主机用的阿里云,有少量优化。
请问现在let's encrypt 的ssl证书的OCSP失效了么? 我测试了
Version: 1 (0x0) Requestor List: Certificate ID: Hash Algorithm: sha1 Issuer Name Hash: 7EE66AE77123B3FCF8A220646C16A12D6071085D Issuer Key Hash: A84A6A63047DD45676D139B7A64565EFF3A8ECA1 Serial Number: 04D1F2A093F5345385775F0959AB47A5255Bopenssl ocsp -CAfile fullchain.cer -issuer ca.cer -certsite.cer -no_nonce -text -url ocsp.int-x3.letsencrypt.org
OCSP Request Data:
Error connecting BIO
Error querying OCSP responder
system library:connect:Connection timed out:bss_conn.c:246:host=ocsp.int-x3.letsencrypt.org:80
20073067:BIO routines:CONN_STATE:connect error:bss_conn.c:249:
貌似都不通,防火墙什么都是关闭的。
刚开始使用Typecho,用上好几个大佬造的轮子,感谢
您好:
我从网络【v2ex】上发现您的网站,是否可以交换一下友情链接?
我的网站【达达知识】最近刚刚建立,目前没有收录(百度,Google等搜索引擎),一个分享碎片知识的平台,任何知识碎片都能以某种方式让你的大脑更强大。网站内容任何人都可以发布或修改。
已做好你的网站【Holmesian Blog】链接,请访问我的网站首页,拉到底部检查。
如果需要更换链接文本,可以回复邮件通知我修改。
如果同意交换链接,请使用以下的【网站名称】和【网站地址】进行链接,并回复邮件通知一下。
网站名称:达达知识
网站地址:https://www.dadapush.com/
如果一周内,未收到回复,我会默认为不同意交换友情链接,撤销链接。
Szx's Blog过来逛逛
帮朋友找转ty的教程,逛到这里来,看了看可以动手试试了
我来留个爪子