Possible ERROR in query SQL
DeadManxTx Mon, 09/15/2008 - 03:52
When i try to enter in my Bookmarks on FastDial's website appear this error:
user warning: 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 query: SELECT DISTINCT(node.nid), node.type AS node_type, node.title AS node_title, node.changed AS node_changed, users.name AS users_name, users.uid AS users_uid, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp, flag_types_bookmarks.type AS flag_types_bookmarks_type, flag_ops_bookmarks.uid AS flag_ops_bookmarks_ops FROM node node LEFT JOIN flag_content flag_content_bookmarks ON node.nid = flag_content_bookmarks.content_id AND flag_content_bookmarks.fid = '1' INNER JOIN users users ON node.uid = users.uid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN flag_types flag_types_bookmarks ON node.type = flag_types_bookmarks.type AND flag_types_bookmarks.fid = '1' LEFT JOIN flag_content flag_ops_bookmarks ON node.nid = flag_ops_bookmarks.content_id AND flag_ops_bookmarks.fid = '1' AND flag_ops_bookmarks.uid = '2677' INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'book_access') OR (na.gid = 2 AND na.realm = 'forum_access'))) AND ( (node.status = '1') AND (flag_content_bookmarks.uid IS NOT NULL) AND (flag_content_bookmarks.uid = 2677) ) ORDER BY node_comment_statistics_last_comment_timestamp DESC LIMIT 0, 25 in /home/userlogo/public_html/includes/database.mysql.inc on line 172.
Search logos
Search site
Navigation
User login
Online users
Active - 15 mins:
Comments
Re: Possible ERROR in query SQL
Submitted by chiaroscuro on Sun, 09/21/2008 - 07:02@DeadManxTx
Thanks for your post
this was also noted by bluedog here
Are you continuing to experience this problem ?
Re: Possible ERROR in query SQL
Submitted by Mafia_Penguin on Tue, 09/23/2008 - 20:28I'm getting this, too =[
user warning: 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 query: SELECT DISTINCT(node.nid), node.type AS node_type, node.title AS node_title, node.changed AS node_changed, users.name AS users_name, users.uid AS users_uid, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp, flag_types_bookmarks.type AS flag_types_bookmarks_type, flag_ops_bookmarks.uid AS flag_ops_bookmarks_ops FROM node node LEFT JOIN flag_content flag_content_bookmarks ON node.nid = flag_content_bookmarks.content_id AND flag_content_bookmarks.fid = '1' INNER JOIN users users ON node.uid = users.uid LEFT JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid LEFT JOIN flag_types flag_types_bookmarks ON node.type = flag_types_bookmarks.type AND flag_types_bookmarks.fid = '1' LEFT JOIN flag_content flag_ops_bookmarks ON node.nid = flag_ops_bookmarks.content_id AND flag_ops_bookmarks.fid = '1' AND flag_ops_bookmarks.uid = '514' INNER JOIN node_access na ON na.nid = node.nid WHERE (na.grant_view >= 1 AND ((na.gid = 0 AND na.realm = 'all') OR (na.gid = 2 AND na.realm = 'book_access') OR (na.gid = 3 AND na.realm = 'book_access') OR (na.gid = 6 AND na.realm = 'book_access') OR (na.gid = 2 AND na.realm = 'forum_access') OR (na.gid = 3 AND na.realm = 'forum_access') OR (na.gid = 6 AND na.realm = 'forum_access'))) AND ( (node.status = '1') AND (flag_content_bookmarks.uid IS NOT NULL) AND (flag_content_bookmarks.uid = 514) ) ORDER BY node_comment_statistics_last_comment_timestamp DESC LIMIT 0, 25 in /home/userlogo/public_html/includes/database.mysql.inc on line 172.
-----------------------------
Please make all logos transparent. Then everybody can choose their own colors.
Re: Possible ERROR in query SQL
Submitted by chiaroscuro on Wed, 09/24/2008 - 03:51@Mafia_Penguin
I'm getting this, too =[
Thanks for reporting this
Will get looked into.
Strange that this does not happen with all users.
Re: Possible ERROR in query SQL
Submitted by chiaroscuro on Wed, 09/24/2008 - 08:12@Mafia_Penguin
Update
Seems like there was a fault in the Bookmarks Module.
It is going to be replaced
Re: Possible ERROR in query SQL
Submitted by chiaroscuro on Thu, 09/25/2008 - 05:37@DeadManxTx
@Mafia_Penguin
update
New My Bookmarks module fitted
Should be working now
Previous saved bookmarks were unable to be retained.
I hope this does not cause too much inconvenience.