• 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

  • Sildenafil Citrate 100mg is
    by: alldaypill122
    2 weeks 5 days ago
  • Buy bimatoprost online is
    by: alldaypill122
    4 weeks 10 hours ago
  • Sildenafil Tablets 100mg is
    by: alldaypill122
    1 month 3 days ago
  • Order Cenforce 100mg dosage
    by: Cenforce100
    1 month 1 week ago
  • Sildenafil 50 mg Tablets are
    by: alldaypill122
    1 month 1 week ago
  • Review
    by: sortingseo
    1 month 2 weeks ago
  • Buy Cenforce D 160 Mg Online
    by: welloxpharmacy
    1 month 3 weeks ago
  • Cenforce 200 Mg Online From USA, UK
    by: welloxpharmacy
    1 month 3 weeks ago
more

Recent topics

  • What did we discover towards 2020 Bucs?
  • Ghosts of further than Twins experiencing baseball with no corporeal interference
  • Hitting freeagent market place towards fill Braveslargest specifications
  • It period in direction of split up the Cubshomerunorbust offense
  • Year evaluate: Wandy Peralta
  • Recreation 60 Gamethread: Pink Sox at Braves
  • Is the Excellent of Perform Compromised inside of 2020?
  • On Demand Doctor App Development Solutions
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 155
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