完美活动中心2.0 For D4 By 泡哥

4.10的.我有.哈哈.

原帖由 17小菜 于 2006-4-19 18:41 发表
数据库出现问题的解决办法

1、MySQl语句中condition替换为`condition`
2、把字段condition改为其他如accondition

ALTER TABLE `cdb_threads` CHANGE `condition` `accondition` TINYINT( 1 ) NOT NULL DEF ...

感谢,已搞定..

不小心活动关闭了,没法打开 了,不知道是不是BUG??

为什么老是提示活动报名已截止???就是刚发起的活动也 一样...非常郁闷..

活动确认名单       报名已截止，距活动结束还有 32 天 8 小时

泡哥，我的论坛安成功装了，但是不能发起活动，是因为那个选择发起论坛那里没有的选择啊，我在后台设置了也不行啊，希望你能快点回答我的问题，我先在这里谢谢了~~`
永远支持泡哥 ~~~~

泡哥，请回答一下问题啊。。。等着急用咧。。

Discuz! info: MySQL Query Error

User: chivas
Time: 2006-5-17 3:33am
Script: /plugin.php

SQL: SELECT COUNT(*) FROM cdb_threads WHERE upperlimit>0 and condition=1 and displayorder!=-1
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition=1 and displayorder!=-1' at line 1
Errno.: 1064

An error report has been dispatched to our administrator.

Discuz! info: MySQL Query Error

User: chivas
Time: 2006-5-17 3:36am
Script: /plugin.php

SQL: SELECT condition, activetime, subject, author, upperlimit, confirm, tid, fid, displayorder
FROM cdb_threads WHERE upperlimit>0 and author='chivas' and displayorder!=-1 ORDER BY tid DESC LIMIT 0, 15
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition, activetime, subject, author, upperlimit, confirm, tid
Errno.: 1064

Similar error report has beed dispatched to administrator before.

原帖由 17小菜 于 2006-4-19 18:41 发表
数据库出现问题的解决办法

1、MySQl语句中condition替换为`condition`
2、把字段condition改为其他如accondition

ALTER TABLE `cdb_threads` CHANGE `condition` `accondition` TINYINT( 1 ) NOT NULL DEF ...

Discuz! info: MySQL Query Error

User: chivas
Time: 2006-5-17 4:16am
Script: /post.php

SQL: INSERT INTO cdb_threads (fid, readperm, price, iconid, typeid, author, authorid, subject, dateline, lastpost, lastposter, displayorder, digest, blog, poll, attachment, moderated, activetime, acendtime, upperlimit, condition, confirm)
VALUES ('58', '0', '0', '21', '0', 'chivas', '1', '有人要买摄像头吗？？', '1147810562', '1147810562', 'chivas', '0', '0', '0', '0', '0', '0', '1150732800', '1155139200', '198', '1', '198')
Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'condition, confirm)
VALUES ('58', '0', '0', '21
Errno.: 1064

An error report has been dispatched to our administrator.