pc77maikongjian

学习学习再学习。

hack000

Discuz! info: MySQL Query Error

User: Mr.HackCat
Time: 2008-1-20 9:23pm
Script: /bbs/plugin.php

SQL: SELECT u.* , m.username, i.imagename, i.endurance as dates FROM ([Table]images_user u, [Table]images_data i) LEFT JOIN [Table]members m ON m.uid = u.imagefrom WHERE u.userid = '1' AND u.dafaultuse = '1' AND i.sort=u.classid AND i.graphic=CONCAT(u.picid,'.gif') ORDER BY u.buydata
Error: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay
Errno.: 1104

Similar error report has beed dispatched to administrator before.


請問這樣子是發生什麼事情!!該如何解決

xiandan

Discuz! info: MySQL Query Error

Time: 2008-1-20 2:56pm
Script:

SQL: CREATE TABLE [Table]access ( uid mediumint(8) unsigned NOT NULL DEFAULT '0', fid smallint(6) unsigned NOT NULL DEFAULT '0', allowview tinyint(1) NOT NULL DEFAULT '0', allowpost tinyint(1) NOT NULL DEFAULT '0', allowreply tinyint(1) NOT NULL DEFAULT '0', allowgetattach tinyint(1) NOT NULL DEFAULT '0', allowpostattach tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (uid,fid)) ENGINE=MYISAM DEFAULT CHARSET=gbk
Error:
Errno.: 0

Similar error report has beed dispatched to administrator before.
这是怎么回事呢
安装到最后一步显示了上面的提示
希望老大回复下,谢谢了

intelligent

登陆退出的时候提示no found

intelligent

找了半天都没找到贴图按钮。要不然我就把图发上去让各位看看问题图像了

pktmandy

不错！留个记号