ALL PROJECTS APPEAR TO BE FLAGGED, AND I KEEP GETTING LOGGED OFF!!!!!!!!!!!!!!! Here is an EXACT copy of what I see at the bottom of the screen. I know its long, and I apologize for that, but I feel it is important to let the Scratch team know: Nr Query Error Affected Num. rows Took (ms)
1 DESCRIBE `projects` 26 26 1
2 DESCRIBE `users` 28 28 1
3 DESCRIBE `gallery_projects` 4 4 1
4 DESCRIBE `galleries` 15 15 1
5 DESCRIBE `featured_projects` 3 3 1
6 DESCRIBE `clubbed_galleries` 3 3 0
7 DESCRIBE `user_stats` 3 3 1
8 DESCRIBE `themes` 7 7 1
9 DESCRIBE `featured_galleries` 3 3 0
10 DESCRIBE `tags` 3 3 1
11 DESCRIBE `notifications` 5 5 0
12 DESCRIBE `relationships` 5 5 0
13 DESCRIBE `pcomments` 10 10 1
14 DESCRIBE `gcomments` 9 9 1
15 DESCRIBE `gallery_memberships` 6 6 1
16 DESCRIBE `blocked_users` 5 5 0
17 DESCRIBE `announcements` 5 5 0
18 DESCRIBE `blocked_ips` 5 5 1
19 DESCRIBE `friend_requests` 5 5 0
20 SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`related_project_id`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `projects` AS `Project` LEFT JOIN `users` AS `User` ON (`Project`.`user_id` = `User`.`id`) WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND `Project`.`proj_visibility` = 'visible' ORDER BY `Project`.`created` DESC LIMIT 3 3 3 1
21 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (197231) 0 0 0
22 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (197230) 0 0 0
23 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (197229) 0 0 0
24 SELECT `FeaturedProject`.`id`, `FeaturedProject`.`project_id`, `FeaturedProject`.`timestamp`, `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`related_project_id`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes` FROM `featured_projects` AS `FeaturedProject` LEFT JOIN `projects` AS `Project` ON (`FeaturedProject`.`project_id` = `Project`.`id`) WHERE 1 = 1 ORDER BY `FeaturedProject`.`id` DESC LIMIT 3 3 3 1
25 SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`related_project_id`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes` FROM `projects` AS `Project` WHERE `Project`.`id` = 172824 1 1 4
26 SELECT `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `users` AS `User` WHERE `User`.`id` = 117746 1 1 0
27 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (172824) 5 5 0
28 SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`related_project_id`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes` FROM `projects` AS `Project` WHERE `Project`.`id` = 163995 1 1 1
29 SELECT `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `users` AS `User` WHERE `User`.`id` = 78057 1 1 0
30 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (163995) 13 13 0
31 SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`related_project_id`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes` FROM `projects` AS `Project` WHERE `Project`.`id` = 188879 1 1 1
32 SELECT `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `users` AS `User` WHERE `User`.`id` = 120280 1 1 0
33 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (188879) 4 4 0
34 SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`related_project_id`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `projects` AS `Project` LEFT JOIN `users` AS `User` ON (`Project`.`user_id` = `User`.`id`) WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND `Project`.`created` > now() - interval 14 day ORDER BY `Project`.`loveit` DESC LIMIT 3 3 3 50
35 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (191164) 1 1 0
36 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (186538) 22 22 0
37 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (190840) 17 17 2
38 SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`related_project_id`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `projects` AS `Project` LEFT JOIN `users` AS `User` ON (`Project`.`user_id` = `User`.`id`) WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND `Project`.`created` > now() - interval 10 day AND `Project`.`user_id` > 0 AND `Project`.`proj_visibility` = 'visible' ORDER BY `Project`.`views` DESC LIMIT 3 3 3 37
39 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (192811) 11 11 0
40 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (193552) 8 8 0
41 SELECT MAX(projects.id) AS maxid FROM projects 1 1 0
42 SELECT COUNT(*) AS count FROM `projects` AS `Project` LEFT JOIN `users` AS `User` ON (`Project`.`user_id` = `User`.`id`) WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND `Project`.`id` >= 174588 1 1 64
43 SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`related_project_id`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `projects` AS `Project` LEFT JOIN `users` AS `User` ON (`Project`.`user_id` = `User`.`id`) WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND `Project`.`id` >= 174588 ORDER BY `Project`.`id` ASC LIMIT 3 3 3 1
44 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (174588) 2 2 0
45 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (174589) 0 0 0
46 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (174592) 1 1 0
47 SELECT `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `users` AS `User` WHERE 1 = 1 ORDER BY `User`.`created` DESC LIMIT 4 4 4 0
48 SELECT `UserStat`.`id`, `UserStat`.`user_id`, `UserStat`.`lastin`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `user_stats` AS `UserStat` LEFT JOIN `users` AS `User` ON (`UserStat`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY `UserStat`.`lastin` DESC LIMIT 4 4 4 24
49 SELECT `FeaturedGallery`.`id`, `FeaturedGallery`.`timestamp`, `FeaturedGallery`.`gallery_id`, `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`type`, `Gallery`.`description`, `Gallery`.`user_id`, `Gallery`.`icon`, `Gallery`.`timestamp`, `Gallery`.`total_projects`, `Gallery`.`total_subscriptions`, `Gallery`.`changed`, `Gallery`.`created`, `Gallery`.`modified`, `Gallery`.`status`, `Gallery`.`visibility`, `Gallery`.`usage` FROM `featured_galleries` AS `FeaturedGallery` LEFT JOIN `galleries` AS `Gallery` ON (`FeaturedGallery`.`gallery_id` = `Gallery`.`id`) WHERE 1 = 1 ORDER BY `FeaturedGallery`.`id` DESC LIMIT 3 3 3 0
50 SELECT Tag.name, COUNT(Project.id) as tagcounter FROM projects Project JOIN project_tags tt ON Project.id = tt.project_id JOIN tags Tag ON tt.tag_id = Tag.id GROUP BY Tag.id ORDER BY tagcounter DESC LIMIT 30 30 30 1785
51 SELECT `ClubbedGallery`.`id`, `ClubbedGallery`.`gallery_id`, `ClubbedGallery`.`created_at`, `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`type`, `Gallery`.`description`, `Gallery`.`user_id`, `Gallery`.`icon`, `Gallery`.`timestamp`, `Gallery`.`total_projects`, `Gallery`.`total_subscriptions`, `Gallery`.`changed`, `Gallery`.`created`, `Gallery`.`modified`, `Gallery`.`status`, `Gallery`.`visibility`, `Gallery`.`usage` FROM `clubbed_galleries` AS `ClubbedGallery` LEFT JOIN `galleries` AS `Gallery` ON (`ClubbedGallery`.`gallery_id` = `Gallery`.`id`) WHERE 1 = 1 ORDER BY `ClubbedGallery`.`id` DESC LIMIT 1 1 1 0
52 SELECT COUNT(*) AS count FROM `projects` AS `Project` LEFT JOIN `users` AS `User` ON (`Project`.`user_id` = `User`.`id`) WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin') 1 1 568
53 SELECT COUNT(*) AS count FROM `users` AS `User` WHERE villager=0 1 1 0
54 SELECT project_id, COUNT(*) FROM `downloaders`,`projects` WHERE projects.created > now() - interval 14 day AND projects.id = downloaders.project_id AND proj_visibility = 'visible' GROUP BY project_id ORDER BY COUNT(*) DESC LIMIT 3 3 3 86
55 SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`related_project_id`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `projects` AS `Project` LEFT JOIN `users` AS `User` ON (`Project`.`user_id` = `User`.`id`) WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND `Project`.`id` = 188678 OR `Project`.`id` = 186848 OR `Project`.`id` = 190840 LIMIT 3 3 3 1
56 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (186848) 21 21 0
57 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (188678) 2 2 0
58 select sum(totalScripts) as totalscripts from projects 1 1 98
59 select sum(numberOfSprites) as totalsprites from projects 1 1 97
60 select count(distinct(user_id)) as totalcreators from projects where user_id 1 1 189
61 SELECT COUNT(*) AS count FROM `blocked_ips` AS `BlockedIp` LEFT JOIN `users` AS `User` ON (`BlockedIp`.`user_id` = `User`.`id`) WHERE ip = 2700967943 1 1 0
62 SELECT `Announcement`.`id`, `Announcement`.`user_id`, `Announcement`.`content`, `Announcement`.`timestamp`, `Announcement`.`isOn`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `announcements` AS `Announcement` LEFT JOIN `users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) WHERE content != '' 1 1 0
63 SELECT COUNT(*) AS count FROM `announcements` AS `Announcement` LEFT JOIN `users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) WHERE content = '' 1 1 0
64 SELECT `Announcement`.`id`, `Announcement`.`user_id`, `Announcement`.`content`, `Announcement`.`timestamp`, `Announcement`.`isOn`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `announcements` AS `Announcement` LEFT JOIN `users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) WHERE 1 = 1 3 3 0
65 SELECT COUNT(*) AS count FROM `friend_requests` AS `FriendRequest` LEFT JOIN `users` AS `User` ON (`FriendRequest`.`user_id` = `User`.`id`) WHERE `to_id` = 85629 AND `FriendRequest`.`status` = 'pending' 1 1 28
66 SELECT COUNT(*) AS count FROM `notifications` AS `Notification` WHERE user_id=85629 AND status='unread' 1 1 368
67 SELECT `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `users` AS `User` WHERE `User`.`id` = 85629 LIMIT 1
I AM SCARED!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! I hope this problem is solved!
Offline
I am honestly worried. What if the site is never up and running again? What would I do in my spare time??
Offline
It also lost all images for everything. What is wrong? I cannot see user avatars or even gallery images. Have I been banned? I have never done anything bad or inappropriate. I am truly worried.......Even if it is just a small bug, it might take me forever to find all my images again. I hope it gets fixed fast! I know I am probably not banned, but I am worried nonetheless.
Offline
Ok, I solved the issue. I was at www.hanxu.scratch.mit.edu which appears to be a parallel glitch world in which nothing exists. Try the site, it is pretty scary.....How the heck did I get there?????? I never went to hanxu, and what is a hanxu anyway??
Offline
Cyclone103 wrote:
Ok, I solved the issue. I was at www.hanxu.scratch.mit.edu which appears to be a parallel glitch world in which nothing exists. Try the site, it is pretty scary.....How the heck did I get there?????? I never went to hanxu, and what is a hanxu anyway??
What the? How'd Hanxu get there?
Offline
http://hanxu.scratch.mit.edu/ this is the actual blank link. WHAT IS A HANXU??????????????????????????????????????????????????????????????????????????????????????????????????
Offline
Bluestribute wrote:
Cyclone103 wrote:
Ok, I solved the issue. I was at www.hanxu.scratch.mit.edu which appears to be a parallel glitch world in which nothing exists. Try the site, it is pretty scary.....How the heck did I get there?????? I never went to hanxu, and what is a hanxu anyway??
What the? How'd Hanxu get there?
I dont know???????
Offline
Now, any page in the forums does the hanxu thing. I have decided to temporarily stop using the forums till this parallel world issue is resolved.........cause every time I go to the hanxu site, I have to delete that word to save my scratch. In order to make it simple, I am posting the actual link so I can get back more easily. www.scratch.mit.edu
Last edited by Cyclone103 (2008-06-25 10:36:37)
Offline
Thanks for the link. I'll put it in show and tell too
Offline
Cyclone103 wrote:
ALL PROJECTS APPEAR TO BE FLAGGED, AND I KEEP GETTING LOGGED OFF!!!!!!!!!!!!!!! Here is an EXACT copy of what I see at the bottom of the screen. I know its long, and I apologize for that, but I feel it is important to let the Scratch team know: Nr Query Error Affected Num. rows Took (ms)
1 DESCRIBE `projects` 26 26 1
2 DESCRIBE `users` 28 28 1
3 DESCRIBE `gallery_projects` 4 4 1
4 DESCRIBE `galleries` 15 15 1
5 DESCRIBE `featured_projects` 3 3 1
6 DESCRIBE `clubbed_galleries` 3 3 0
7 DESCRIBE `user_stats` 3 3 1
8 DESCRIBE `themes` 7 7 1
9 DESCRIBE `featured_galleries` 3 3 0
10 DESCRIBE `tags` 3 3 1
11 DESCRIBE `notifications` 5 5 0
12 DESCRIBE `relationships` 5 5 0
13 DESCRIBE `pcomments` 10 10 1
14 DESCRIBE `gcomments` 9 9 1
15 DESCRIBE `gallery_memberships` 6 6 1
16 DESCRIBE `blocked_users` 5 5 0
17 DESCRIBE `announcements` 5 5 0
18 DESCRIBE `blocked_ips` 5 5 1
19 DESCRIBE `friend_requests` 5 5 0
20 SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`related_project_id`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `projects` AS `Project` LEFT JOIN `users` AS `User` ON (`Project`.`user_id` = `User`.`id`) WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND `Project`.`proj_visibility` = 'visible' ORDER BY `Project`.`created` DESC LIMIT 3 3 3 1
21 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (197231) 0 0 0
22 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (197230) 0 0 0
23 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (197229) 0 0 0
24 SELECT `FeaturedProject`.`id`, `FeaturedProject`.`project_id`, `FeaturedProject`.`timestamp`, `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`related_project_id`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes` FROM `featured_projects` AS `FeaturedProject` LEFT JOIN `projects` AS `Project` ON (`FeaturedProject`.`project_id` = `Project`.`id`) WHERE 1 = 1 ORDER BY `FeaturedProject`.`id` DESC LIMIT 3 3 3 1
25 SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`related_project_id`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes` FROM `projects` AS `Project` WHERE `Project`.`id` = 172824 1 1 4
26 SELECT `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `users` AS `User` WHERE `User`.`id` = 117746 1 1 0
27 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (172824) 5 5 0
28 SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`related_project_id`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes` FROM `projects` AS `Project` WHERE `Project`.`id` = 163995 1 1 1
29 SELECT `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `users` AS `User` WHERE `User`.`id` = 78057 1 1 0
30 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (163995) 13 13 0
31 SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`related_project_id`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes` FROM `projects` AS `Project` WHERE `Project`.`id` = 188879 1 1 1
32 SELECT `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `users` AS `User` WHERE `User`.`id` = 120280 1 1 0
33 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (188879) 4 4 0
34 SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`related_project_id`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `projects` AS `Project` LEFT JOIN `users` AS `User` ON (`Project`.`user_id` = `User`.`id`) WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND `Project`.`created` > now() - interval 14 day ORDER BY `Project`.`loveit` DESC LIMIT 3 3 3 50
35 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (191164) 1 1 0
36 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (186538) 22 22 0
37 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (190840) 17 17 2
38 SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`related_project_id`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `projects` AS `Project` LEFT JOIN `users` AS `User` ON (`Project`.`user_id` = `User`.`id`) WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND `Project`.`created` > now() - interval 10 day AND `Project`.`user_id` > 0 AND `Project`.`proj_visibility` = 'visible' ORDER BY `Project`.`views` DESC LIMIT 3 3 3 37
39 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (192811) 11 11 0
40 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (193552) 8 8 0
41 SELECT MAX(projects.id) AS maxid FROM projects 1 1 0
42 SELECT COUNT(*) AS count FROM `projects` AS `Project` LEFT JOIN `users` AS `User` ON (`Project`.`user_id` = `User`.`id`) WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND `Project`.`id` >= 174588 1 1 64
43 SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`related_project_id`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `projects` AS `Project` LEFT JOIN `users` AS `User` ON (`Project`.`user_id` = `User`.`id`) WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND `Project`.`id` >= 174588 ORDER BY `Project`.`id` ASC LIMIT 3 3 3 1
44 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (174588) 2 2 0
45 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (174589) 0 0 0
46 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (174592) 1 1 0
47 SELECT `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `users` AS `User` WHERE 1 = 1 ORDER BY `User`.`created` DESC LIMIT 4 4 4 0
48 SELECT `UserStat`.`id`, `UserStat`.`user_id`, `UserStat`.`lastin`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `user_stats` AS `UserStat` LEFT JOIN `users` AS `User` ON (`UserStat`.`user_id` = `User`.`id`) WHERE 1 = 1 ORDER BY `UserStat`.`lastin` DESC LIMIT 4 4 4 24
49 SELECT `FeaturedGallery`.`id`, `FeaturedGallery`.`timestamp`, `FeaturedGallery`.`gallery_id`, `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`type`, `Gallery`.`description`, `Gallery`.`user_id`, `Gallery`.`icon`, `Gallery`.`timestamp`, `Gallery`.`total_projects`, `Gallery`.`total_subscriptions`, `Gallery`.`changed`, `Gallery`.`created`, `Gallery`.`modified`, `Gallery`.`status`, `Gallery`.`visibility`, `Gallery`.`usage` FROM `featured_galleries` AS `FeaturedGallery` LEFT JOIN `galleries` AS `Gallery` ON (`FeaturedGallery`.`gallery_id` = `Gallery`.`id`) WHERE 1 = 1 ORDER BY `FeaturedGallery`.`id` DESC LIMIT 3 3 3 0
50 SELECT Tag.name, COUNT(Project.id) as tagcounter FROM projects Project JOIN project_tags tt ON Project.id = tt.project_id JOIN tags Tag ON tt.tag_id = Tag.id GROUP BY Tag.id ORDER BY tagcounter DESC LIMIT 30 30 30 1785
51 SELECT `ClubbedGallery`.`id`, `ClubbedGallery`.`gallery_id`, `ClubbedGallery`.`created_at`, `Gallery`.`id`, `Gallery`.`name`, `Gallery`.`type`, `Gallery`.`description`, `Gallery`.`user_id`, `Gallery`.`icon`, `Gallery`.`timestamp`, `Gallery`.`total_projects`, `Gallery`.`total_subscriptions`, `Gallery`.`changed`, `Gallery`.`created`, `Gallery`.`modified`, `Gallery`.`status`, `Gallery`.`visibility`, `Gallery`.`usage` FROM `clubbed_galleries` AS `ClubbedGallery` LEFT JOIN `galleries` AS `Gallery` ON (`ClubbedGallery`.`gallery_id` = `Gallery`.`id`) WHERE 1 = 1 ORDER BY `ClubbedGallery`.`id` DESC LIMIT 1 1 1 0
52 SELECT COUNT(*) AS count FROM `projects` AS `Project` LEFT JOIN `users` AS `User` ON (`Project`.`user_id` = `User`.`id`) WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin') 1 1 568
53 SELECT COUNT(*) AS count FROM `users` AS `User` WHERE villager=0 1 1 0
54 SELECT project_id, COUNT(*) FROM `downloaders`,`projects` WHERE projects.created > now() - interval 14 day AND projects.id = downloaders.project_id AND proj_visibility = 'visible' GROUP BY project_id ORDER BY COUNT(*) DESC LIMIT 3 3 3 86
55 SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`related_project_id`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `projects` AS `Project` LEFT JOIN `users` AS `User` ON (`Project`.`user_id` = `User`.`id`) WHERE (proj_visibility='visible' OR proj_visibility='censbycomm' OR proj_visibility='censbyadmin')AND `Project`.`id` = 188678 OR `Project`.`id` = 186848 OR `Project`.`id` = 190840 LIMIT 3 3 3 1
56 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (186848) 21 21 0
57 SELECT `GalleryProject`.`id`, `GalleryProject`.`gallery_id`, `GalleryProject`.`project_id`, `GalleryProject`.`timestamp` FROM `gallery_projects` AS `GalleryProject` WHERE `GalleryProject`.`project_id` IN (188678) 2 2 0
58 select sum(totalScripts) as totalscripts from projects 1 1 98
59 select sum(numberOfSprites) as totalsprites from projects 1 1 97
60 select count(distinct(user_id)) as totalcreators from projects where user_id 1 1 189
61 SELECT COUNT(*) AS count FROM `blocked_ips` AS `BlockedIp` LEFT JOIN `users` AS `User` ON (`BlockedIp`.`user_id` = `User`.`id`) WHERE ip = 2700967943 1 1 0
62 SELECT `Announcement`.`id`, `Announcement`.`user_id`, `Announcement`.`content`, `Announcement`.`timestamp`, `Announcement`.`isOn`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `announcements` AS `Announcement` LEFT JOIN `users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) WHERE content != '' 1 1 0
63 SELECT COUNT(*) AS count FROM `announcements` AS `Announcement` LEFT JOIN `users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) WHERE content = '' 1 1 0
64 SELECT `Announcement`.`id`, `Announcement`.`user_id`, `Announcement`.`content`, `Announcement`.`timestamp`, `Announcement`.`isOn`, `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `announcements` AS `Announcement` LEFT JOIN `users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) WHERE 1 = 1 3 3 0
65 SELECT COUNT(*) AS count FROM `friend_requests` AS `FriendRequest` LEFT JOIN `users` AS `User` ON (`FriendRequest`.`user_id` = `User`.`id`) WHERE `to_id` = 85629 AND `FriendRequest`.`status` = 'pending' 1 1 28
66 SELECT COUNT(*) AS count FROM `notifications` AS `Notification` WHERE user_id=85629 AND status='unread' 1 1 368
67 SELECT `User`.`id`, `User`.`username`, `User`.`villager`, `User`.`firstname`, `User`.`lastname`, `User`.`gender`, `User`.`urlname`, `User`.`role`, `User`.`email`, `User`.`password`, `User`.`buddyicon`, `User`.`organization`, `User`.`city`, `User`.`created`, `User`.`timestamp`, `User`.`state`, `User`.`country`, `User`.`hearabout`, `User`.`interestsabout`, `User`.`comments`, `User`.`bmonth`, `User`.`byear`, `User`.`notify_pcomment`, `User`.`notify_gcomment`, `User`.`ipaddress`, `User`.`status`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `users` AS `User` WHERE `User`.`id` = 85629 LIMIT 1
I AM SCARED!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! I hope this problem is solved!
that is what happened to me!! i had no idea what was going on!!
Offline
I Am Scared!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Offline
I noticed, but am still worried..
Offline
andresmh wrote:
Fixed.
Though I noticed just now as I was using Firefox it still tries to connect to hanxu. It doesn't, but it still tries
Offline
andresmh wrote:
Fixed.
Thanks so much!!!!!!!!!!!! I was VERY worried!
Offline
OK. Since this problem is fixed I'm going to close this thread so people don't get confused and think that this is still not working. Big thanks to everyone for reporting errors, you're so helpful to the Scratch Team!!! I feel we have an army of testers!
In the future before posting a problem, check in the Troubleshooting forum to see if someone else has reported it and add your comment there instead of creating a new thread.
Offline