本帖最后由 yndhzax 于 2010-11-4 08:53 编辑
- Discuz! Database Error
- The database has encountered a problem. Need Help?
- --------------------------------------------------------------------------------
- Error messages:
- [Type] 查询语句错误
- [1146] Table 'yndhzax.td_pm' doesn't exist
- [Query] INSERT INTO td_pm (tid,name,pm,jg,data,datab,sl) VALUES('601','1','111111111','111','2010-10-20 17:41:00','2010-10-21 17:41:00','111')
- Program messages:
- [Line: 0043]plugin.php(include)
- [Line: 0021]source\plugin\td776\td_pm.inc.php(DB::query)
复制代码
数据有点问题,大家研究一下,在后台设置好提交要拍卖的物品时候出现上述数据库错误,如何解决?大家研究一下,把这东西用起来
下面是29楼 wodiqiu 提供的一个修改代码,我已经测试,可以用了在根目录中找到forum.php文件,
1.找到 runhooks(); 在这句下面插入
require DISCUZ_ROOT.'./source/plugin/td776/body.inc.php';
2.打开模板文件template/default/forum/viewthread_node_body.htm
找到代码
div id=comment_$post[pid] class=cl cm
!--{if $_G['setting']['commentnumber'] && !empty($comments[$post[pid]])}--
在这两句代码前加入如下语句
!--{if $post['first'] && !$_G['forum_thread']['archiveid']}--
{eval include template('td776:pm');}
!--{/if}--
数据库安装
复制的代码到后台数据库是升级一下数据库。你安装的时候升级不成功。数据库里没有这两个表。
CREATE TABLE `pre_td_name` (
`id` MEDIUMINT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`uid` mediumint(8) unsigned NOT NULL default '0',
`tid` mediumint(8) unsigned NOT NULL default '0',
`name` VARCHAR( 50 ) NOT NULL,
`cj` mediumint(8) unsigned NOT NULL default '0',
`yj` mediumint(8) unsigned NOT NULL default '0',
`data` DATETIME NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
CREATE TABLE `pre_td_pm` (
`uid` mediumint(8) unsigned NOT NULL default '0',
`tid` mediumint(8) unsigned NOT NULL default '0',
`name` mediumint(8) unsigned NOT NULL default '0',
`pm` VARCHAR( 50 ) NOT NULL,
`jg` mediumint(8) unsigned NOT NULL default '0',
`data` DATETIME NOT NULL,
`datab` DATETIME NOT NULL,
`sl` mediumint(8) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
演示地址:http://www.disneylandparad.com/shop/forum.php?mod=viewthread&tid=1&extra=page%3D1
|