INSERT into wz__arctype (reid,topid,sortrank,typename,typedir,isdefault,defaultname,issend,channeltype,tempindex,templist,temparticle,modname,namerule,namerule2,ispart,corank,description,keywords,seotitle,moresite,siteurl,sitepath,ishidden,cross,crossid,content,smalltypes) VALUES(4,4,50,'合肥','{cmspath}/anhui/Hefei',1,'index.html',1,17,'{style}/index_city.htm','{style}/list_city.htm','{style}/article_city.htm','default','{typedir}/{pinyin}.html','{typedir}/list_{tid}_{page}.html',0,0,'','','',0,'','',0,0,'0','','')
提示1064错误: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 'cross,crossid,content,smalltypes) VALUES(4,4,50,'å
提示1064错误: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 'cross,crossid,content,smalltypes) VALUES(4,4,50,'å
跟表里对比一下
collation_database latin1_swedish_ci
collation_server latin1_swedish_ci
数据库编码
中文改了以后 还是会报错 #1064 - 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 'cross,crossid,content,smalltypes) VALUES(4,4,50,'ff','{cmspath}/anhui/Hefei',1,'' at line 1
写作 `cross`
以后数据库的表字段起名最好在字段上加 cn_列名 、这样不会关键字冲突
如果不想修改,请参考唠叨老大的例子使用。