• myFAV.ES
  • Help Center
  • Tutorials
  • Extensions
  • Blogs

  

  • Logos
  • Logo Requests
  • Themes
  • Backgrounds
  • Forums
  • Contact
Home » Content » Deadmanxtx » 09152008 » Possible ERROR in query SQL

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.

  • Fast Dial
  • website
  • Grammatical Bug
  • General Bug
  • High
  • Fixed
  • Log in or register to post comments or vote.

Comments

chiaroscuro's picture

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 ?

  • log in or register to post comments
Mafia_Penguin's picture

Re: Possible ERROR in query SQL

Submitted by Mafia_Penguin on Tue, 09/23/2008 - 20:28

I'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.


  • log in or register to post comments
chiaroscuro's picture

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.

  • log in or register to post comments
chiaroscuro's picture

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

  • log in or register to post comments
chiaroscuro's picture

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.

  • log in or register to post comments

Search logos

Search site

Navigation

  • Blogs
  • Forums
  • Online users
  • Recent content

User login

  • Create new account
  • Request new password
 
  • Changelog
  • Latest releases
  • Important links
 
 
  • Changelog
  • Latest releases
  • Important links
  • Support Forum
 

Top Rated

  • google.com
  • youtube.com
  • fast dial folder
  • wikipedia.org
  • Firefox Black
  • fd folders, folders, folder
  • generic gaming logos
  • mail.google.com, gmail.com, googlemail.com
  • Carbon Fiber
  • iphone app style icon template
more

Recent Polls

  • What are you resolution of screen use
  • Which version of Fast Dial do you run?
  • How often do you visit Userlogos?
  • Which FD iPhone logo format do you find preferable
  • How many themes do you run in Fast Dial ?
more

Online users

There are currently 0 users online.
Active - 15 mins:
No registered users :(
  • Last 24 hours

Recent comments

  • seoo
    by: jameseoo
    5 hours 31 min ago
  • Yes, I am entirely agreed
    by: sijiv31759
    9 hours 57 min ago
  • I found this is an
    by: sijiv31759
    10 hours 35 min ago
  • Thank you for the update,
    by: sijiv31759
    11 hours 48 min ago
  • seooo
    by: jameseoo
    11 hours 51 min ago
  • I’m going to read this. I’ll
    by: sijiv31759
    12 hours 27 min ago
  • seo
    by: jameseoo
    13 hours 30 min ago
  • Wow, this is fascinating
    by: sijiv31759
    13 hours 35 min ago
more

Recent topics

  • Buy Fildena 50mg Tablets
  • List of bookmakers
  • Buy Caverta 50mg Online
  • Can you tell me where to buy a pendant?
  • Buy Iverheal 12mg tablets online
  • Make Your Partner Sexually Happy With Cenforce 120
  • Resumen de los Casinos en Argentina 2022
  • Buy Kamini Oral Jelly Online
more

Top contributors

User Total user points
Mafia_Penguin 912
Deva 552
gumanov 490
jumpordie 471
Karmody 457
macleod.mac 402
ingalls 354
spaljeni 310
zigzag 290
Rog 265
Sastre 256
famecky 159
x-b 152
danger83 147
1air2philou 143
more

2008-2017 userlogos.org. All logos/images belong to their respective owners. Contact administrator.

  • Logos
  • Logo Requests
  • Themes
  • Backgrounds
  • Forums
  • Contact