主頁 > 網(wǎng)站建設(shè) > 建站知識 > dedecms5.5/5.7 廣告管理提示Unknown column‘a(chǎn)d.clsid’

dedecms5.5/5.7 廣告管理提示Unknown column‘a(chǎn)d.clsid’

POST TIME:2020-04-10 20:15

自己的一個dedecms網(wǎng)站在升級5.7后,發(fā)現(xiàn)后臺廣告管理有錯誤,提示:

---------------------------------------------------------------------------------
Error page: /dede/ad_main.php

Error infos: Unknown column ‘ad.clsid’ in ‘on clause’

Error sql: SELECT COUNT(*) AS dd FROM `dede_myad` ad LEFT JOIN `dede_arctype` tp on tp.id=ad.typeid LEFT JOIN `dede_myadtype` ap on ap.id=ad.clsid WHERE 1=1 LIMIT 0,1;

DedeCMS Error Warning!

Technical Support: http://blog.rekfan.com

Error page: /dede/ad_main.php

Error infos: Unknown column ‘ad.clsid’ in ‘field list’

Error sql: SELECT ad.aid,ad.clsid,ad.tagname,tp.typename as typename,ad.adname,ad.timeset,ad.endtime,ap.typename as clsname FROM `dede_myad` ad LEFT JOIN `dede_arctype` tp on tp.id=ad.typeid LEFT JOIN `dede_myadtype` ap on ap.id=ad.clsid WHERE 1=1 ORDER BY ad.aid desc LIMIT 0,20
---------------------------------------------------------------------------------

官方的解釋說這是因?yàn)閿?shù)據(jù)庫myad缺少了clsid字段。

解決方法:

1.直接去進(jìn)入PhpMyAdmin中修改數(shù)據(jù)表,或
2.進(jìn)入『網(wǎng)站后臺』-『系統(tǒng)』-『SQL命令行工具 』執(zhí)行sql命令

ALTER TABLE `dede_myad` ADD COLUMN `clsid` int(10) NOT NULL DEFAULT 0 AFTER `aid`;



收縮
  • 微信客服
  • 微信二維碼
  • 電話咨詢

  • 400-1100-266