o8cms Error: Unknown column 'ccid51date' in 'field list'_其它cms教程-查字典教程网
o8cms Error: Unknown column 'ccid51date' in 'field list'
o8cms Error: Unknown column 'ccid51date' in 'field list'
发布时间:2016-12-24 来源:查字典编辑
摘要:08CMSInfo:MySQLQueryErrorSQL:UPDATEpcqc_archivesSETccid1='',ccid2='',c...

08CMS Info: MySQL Query Error

SQL: UPDATE pcqc_archives SET ccid1='',ccid2='',ccid6='',ccid8='',ccid9='',ccid10='',ccid11='',ccid12='',ccid13='',ccid15='',ccid16='',ccid20='',ccid21='',ccid22='',ccid23='',ccid27='',ccid28='',ccid29='',ccid51date='0',ccid52date='0',ccid54date='0',ccid55date='0',subject='2011款骏捷FSV新锐版风尚上市',author='pcqc',abstract='骏捷FSV是华晨以国际化水准打造的一款A级三厢车,曾荣获2009年上海车展自主品牌新车大奖的中华骏捷FSV主打科技与安全,由世界知名设计大师乔治亚罗主持设计,外观上不仅传承了中华轿车的家族脸谱,更将东西方美 ...',keywords='FSV,安全,系统,销售,设计',thumb='userfiles/image/20110716/161420444bbd1276ea9241.jpg#500#375',updatedate='1310797250' WHERE aid=207722

Error: Unknown column 'ccid51date' in 'field list'

<?php

define('M_NOUSER',1);

include_once './include/general.inc.php';

include_once M_ROOT.'./include/common.fun.php';

include_once M_ROOT.'./include/cache.fun.php';

include_once M_ROOT.'./include/admin.fun.php';

include_once M_ROOT.'./updatedata/update.fun.php';

@set_time_limit(0);

$wa = array(

51 => array (

'sortable' => '1',

'asmode' => '0',

'emode' => '2',

),

52 => array (

'sortable' => '1',

'asmode' => '0',

'emode' => '2',

),

53 => array (

'sortable' => '1',

'asmode' => '3',

'emode' => '0',

),

54 => array (

'sortable' => '0',

'asmode' => '0',

'emode' => '1',

),

55 => array (

'sortable' => '0',

'asmode' => '0',

'emode' => '1',

),

);

foreach($wa as $x => $y){

$na = stidsarr(1);

foreach($na as $k => $v) $db->query("ALTER TABLE {$tblprefix}".atbl($k,1)." ADD ccid$x smallint(6) unsigned NOT NULL default 0",'SILENT');

tbl_alterselect($y['asmode'],0,'ccid'.$x,'archives');

tbl_alter_emode($y['emode'],0,'ccid'.$x,'archives');

}

unlink(__FILE__);

?>

相关阅读
推荐文章
猜你喜欢
附近的人在看
推荐阅读
拓展阅读
  • 大家都在看
  • 小编推荐
  • 猜你喜欢
  • 最新其它cms学习
    热门其它cms学习
    CMS教程子分类