庆(7-1)新概念插件 PPview(贴图中心) 1.0 By Oytktk(靖飒) 08-14更新

OK很好但有个问题哈哈不能连接到下拉彩单http://www.ucmafia.com/bbs

原帖由 leeleeang 于 2007-7-1 16:13 发表
Discuz! info: MySQL Query Error

User: lee
Time: 2007-7-1 4:13pm
Script: /plugin.php

SQL: SELECT pid FROM gallery WHERE aid=0 and fid IN (17) ORDER BY pid DESC
Error: Unknown column 'aid' ...

再次请教，我严格按照方式上传了文件的。。。检查两次了。。

给个卸载语句。。

需要后台的什么设置吗？？？

Discuz! info: MySQL Query Error

User: lee
Time: 2007-7-1 5:49pm
Script: /plugin.php

SQL: SELECT pid FROM [Table]gallery WHERE aid=0 and fid IN (17) ORDER BY pid DESC
Error: Unknown column 'aid' in 'where clause'
程序文件跟数据库有冲突，请使用正确的程序文件上传上去覆盖

Similar error report has beed dispatched to administrator before

原帖由 leeleeang 于 2007-7-1 17:49 发表
Discuz! info: MySQL Query Error

User: lee
Time: 2007-7-1 5:49pm
Script: /plugin.php

SQL: SELECT pid FROM gallery WHERE aid=0 and fid IN (17) ORDER BY pid DESC
Error: Unknown column 'aid' ...

樓主有補上了
再重新升級一次既可

CREATE TABLE `cdb_gallery` (
`gid` INT( 12 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`fid` INT( 6 ) NOT NULL ,
`aid` INT( 12 ) NOT NULL DEFAULT 0,
`tid` INT( 12 ) NOT NULL ,
`pid` INT( 15 ) NOT NULL ,
`typeid` INT( 6 ) NOT NULL ,
`authorid` INT( 16 ) NOT NULL ,
`author` VARCHAR( 18 ) NOT NULL ,
`readperm` INT( 5 ) NOT NULL ,
`price` INT( 5 ) NOT NULL ,
`subject` VARCHAR( 80 ) NOT NULL ,
`dateline` INT( 18 ) NOT NULL ,
`picture` VARCHAR( 200 ) NOT NULL ,
`views` INT( 15 ) NOT NULL
) ENGINE=MyISAM;

支持师傅来了，

升级错误，MySQL 提示: Table 'cdb_gallery' already exists ，请返回。

期待高手朋友帮忙。

原帖由 piyr11 于 2007-7-1 17:58 发表

樓主有補上了
再重新升級一次既可

谢谢。。搞定了。