chenzhongping

我在菜单添加了一个下载更新的菜单，然后在菜单设置了下载器和布局以后。点击网页上的下载更新出来这个错误！看看怎么解决。谢谢！

Database error in weenCompany

Invalid SQL: SELECT f.fileid, f.currentversionid, fv.version, fv.filename, fv.filetype, fv.filesize, f.title, f.author, f.description, f.uniqueid, f.thumbnail, f.image, f.rating, f.dateadded, f.dateupdated, f.downloadcount, f.licensed
              FROM cws_m13_files f
              INNER JOIN cws_m13_file_versions fv ON fv.fileid = f.fileid AND fv.versionid = f.currentversionid
              INNER JOIN cws_m13_file_sections fs ON fs.fileid = f.fileid
                          WHERE f.datestart < NOW()
          AND (f.dateend = 0 OR f.dateend > NOW())
                  AND f.activated = '1'
                  AND (f.maxdownloads = 0
                                        OR (f.maxtype = 0 AND f.downloadcount < f.maxdownloads)
                                        OR (f.maxtype = 1 AND (SELECT COUNT(fileid) FROM cws_m13_file_downloads WHERE fileid = f.fileid AND username = '') < f.maxdownloads)) AND fs.sectionid = '1'
              ORDER BY IF ( dateupdated = 0, dateadded, dateupdated ) DESC LIMIT 0, 6
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 'SELECT COUNT(fileid) FROM cws_m13_file_downloads WHERE fileid =
Error number: 1064
Date: Tuesday 03rd of June 2008 10:49:02 AM
File: http://localhost/index.php

a阿文

估计是mysql数据库设置的问题，找个免费的虚拟空间，安装试试。