7.2的论坛开通云平台后台每天都有一样的错误，怎么回事呢

MySQL        |60.28.189.100        11-11-22 14:35        my.php : 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 ') AND first = 1 AND invisible = '0'' at line 2 - SELECT * FROM cdb_posts
MySQL        |124.115.10.73        11-11-21 14:35        my.php : 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 ') AND first = 1 AND invisible = '0'' at line 2 - SELECT * FROM cdb_posts
MySQL        |113.108.12.103        11-11-20 14:35        my.php : 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 ') AND first = 1 AND invisible = '0'' at line 2 - SELECT * FROM cdb_posts
MySQL        |124.115.12.144        11-11-19 14:35        my.php : 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 ') AND first = 1 AND invisible = '0'' at line 2 - SELECT * FROM cdb_posts
MySQL        |113.108.12.107        11-11-18 14:34        my.php : 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 ') AND first = 1 AND invisible = '0'' at line 2 - SELECT * FROM cdb_posts
MySQL        |119.147.11.63        11-11-17 14:32        my.php : 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 ') AND first = 1 AND invisible = '0'' at line 2 - SELECT * FROM cdb_posts
MySQL        |124.115.10.78        11-11-16 14:31        my.php : 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 ') AND first = 1 AND invisible = '0'' at line 2 - SELECT * FROM cdb_posts
MySQL        |113.108.12.107        11-11-15 14:31        my.php : 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 ') AND first = 1 AND invisible = '0'' at line 2 - SELECT * FROM cdb_posts
MySQL        |113.108.12.123        11-11-14 14:31        my.php : 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 ') AND first = 1 AND invisible = '0'' at line 2 - SELECT * FROM cdb_posts
MySQL        |124.115.4.33        11-11-13 14:31        my.php : 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 ') AND first = 1 AND invisible = '0'' at line 2 - SELECT * FROM cdb_posts
MySQL        |124.115.11.139        11-11-13 14:30        my.php : 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 ') AND first = 1 AND invisible = '0'' at line 2 - SELECT * FROM cdb_posts
MySQL        |113.108.12.111        11-11-13 14:29        my.php : 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 ') AND first = 1 AND invisible = '0'' at line 2 - SELECT * FROM cdb_posts
MySQL        |124.115.4.217        11-11-13 14:29        my.php : 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 ') AND first = 1 AND invisible = '0'' at line 2 - SELECT * FROM cdb_posts

把你的 my.php文件给我，我给你检查槛车sql语句

otherbank 发表于 2011-11-22 18:27
把你的 my.php文件给我，我给你检查槛车sql语句

请问这个my.php具体指的是哪个？因为我发现网站有好几个“my.php”，分别为：
/my.php
/api/manyou/my.php
/api/my.php
另外怎么给你呢？

找到api\manyou\class\Search.php文件
搜索代码

1. $query = $db->query("SELECT * FROM {$tablepre}posts
   
2.                                                          WHERE tid IN (" . implode($tIds, ', ') . ") AND first = 1 AND invisible = '0'"
   
3.                                                    );

复制代码

在这句代码前面添加

1. file_put_contents('d.txt', "SELECT * FROM {$tablepre}posts
   
2.                                                          WHERE tid IN (" . implode($tIds, ', ') . ") AND first = 1 AND invisible = '0' \n\r", FILE_APPEND);

复制代码

然后隔断时间后看下api\manyou目录下是否有d.txt文件，贴一下文件的内容

已经照做 谢谢
如果d.txt有内容 我会第一时间贴上来

自从安装这个云平台后，除了网站后台经常报那个错误之外，网站经常每天不定时的出现w3wp.exe进程占用cpu%的情况，然后导致服务器卡死，必须重启才行

dongdong0925 发表于 2011-11-22 22:16
找到api\manyou\class\Search.php文件
搜索代码在这句代码前面添加然后隔断时间后看下api\manyou目录下是否 ...

按这个方法来，他经验比我丰富多了

baidubbs 发表于 2011-11-22 20:04
请问这个my.php具体指的是哪个？因为我发现网站有好几个“my.php”，分别为：
/my.php
/api/manyou/my. ...

解决方法看这个帖子

:L