17DST→一起创造价值's Archiver

k.black 发表于 2007-12-21 20:35

论坛问卷 安装成功出现错误提示

论坛问卷 安装成功出现错误提示

官方下好插件 通过DAC安装  成功

进入论坛问卷出现错误提示
[quote]Discuz! info: MySQL Query Error

User: admin
Time: 2007-12-21 6:17pm
Script: /1/plugin.php

SQL: SELECT COUNT(*) FROM [Table]ques
Error: Table 'sql5.[Table]ques' doesn't exist
Errno.: 1146

Similar error report has beed dispatched to administrator before.[/quote]

习明 发表于 2007-12-22 01:11

数据库没有升级成功 手动升级一下试试 注意一下你的表名前缀 如果不是cdb_要把代码中的cdb_改为你的[code]DROP TABLE IF EXISTS `cdb_ques`;
CREATE TABLE `cdb_ques` (
`qid` int(10) unsigned NOT NULL auto_increment,
`subject` varchar(255) NOT NULL default '',
`dateline` int(10) NOT NULL default '0',
`uid` mediumint(8) NOT NULL default '0',
`username` varchar(255) NOT NULL default '',
`exp` int(10) NOT NULL default '0',
`person` mediumint(8) NOT NULL default '20',
`stop` tinyint(1) NOT NULL default '0',
`price` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`qid`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `cdb_quesoption`;
CREATE TABLE `cdb_quesoption` (
`id` int(10) unsigned NOT NULL auto_increment,
`qid` int(10) unsigned NOT NULL,
`type` text NOT NULL default '',
`check` mediumtext NOT NULL default '',
`question` mediumtext NOT NULL default '',
`key` mediumtext NOT NULL default '',
`open` tinyint(1) NOT NULL default '1',
`mark` mediumint(8) NOT NULL default '0',
`amust` tinyint(1) NOT NULL default '1',
`answeruser` mediumtext NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

DROP TABLE IF EXISTS `cdb_queslog`;
CREATE TABLE `cdb_queslog` (
`lid` int(10) unsigned NOT NULL auto_increment,
`uid` int(10) unsigned NOT NULL default '0',
`username` varchar(255) NOT NULL default '',
`dateline` int(10) NOT NULL default '0',
`qid` int(10) unsigned NOT NULL,
`id` int(10) unsigned NOT NULL default '0',
`answer` mediumtext NOT NULL default '',
`mark` mediumint(8) NOT NULL default '0',
  KEY  (`lid`)
) TYPE=MyISAM;[/code]

[[i] 本帖最后由 习明 于 2007-12-22 02:04 编辑 [/i]]

伊泽浩 发表于 2007-12-22 23:00

建议发布悬赏帖

页: [1]

Powered by Discuz! Archiver 7.0.0  © 2001-2009 Comsenz Inc.