This is a read-only archive of the old Scratch 1.x Forums.
Try searching the current Scratch discussion forums.

#1 2008-06-25 10:15:43

Cyclone103
Scratcher
Registered: 2008-03-20
Posts: 500+

Massive Issue

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!


All your base are belong to us

Offline

 

#2 2008-06-25 10:16:54

Cyclone103
Scratcher
Registered: 2008-03-20
Posts: 500+

Re: Massive Issue

I am honestly worried. What if the site is never up and running again? What would I do in my spare time??


All your base are belong to us

Offline

 

#3 2008-06-25 10:25:36

Cyclone103
Scratcher
Registered: 2008-03-20
Posts: 500+

Re: Massive Issue

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.


All your base are belong to us

Offline

 

#4 2008-06-25 10:28:50

Cyclone103
Scratcher
Registered: 2008-03-20
Posts: 500+

Re: Massive Issue

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??


All your base are belong to us

Offline

 

#5 2008-06-25 10:29:59

Bluestribute
Scratcher
Registered: 2008-01-24
Posts: 1000+

Re: Massive Issue

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?


http://img247.imageshack.us/img247/1204/bluestributett4.jpg
That's my PSN ID. I know tons of COD4 glitches. Add me as your friend. Oh, and get a headset

Offline

 

#6 2008-06-25 10:30:21

Cyclone103
Scratcher
Registered: 2008-03-20
Posts: 500+

Re: Massive Issue

http://hanxu.scratch.mit.edu/ this is the actual blank link. WHAT IS A HANXU??????????????????????????????????????????????????????????????????????????????????????????????????


All your base are belong to us

Offline

 

#7 2008-06-25 10:31:23

Cyclone103
Scratcher
Registered: 2008-03-20
Posts: 500+

Re: Massive Issue

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???????


All your base are belong to us

Offline

 

#8 2008-06-25 10:34:55

Cyclone103
Scratcher
Registered: 2008-03-20
Posts: 500+

Re: Massive Issue

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)


All your base are belong to us

Offline

 

#9 2008-06-25 10:43:11

Bluestribute
Scratcher
Registered: 2008-01-24
Posts: 1000+

Re: Massive Issue

Thanks for the link. I'll put it in show and tell too


http://img247.imageshack.us/img247/1204/bluestributett4.jpg
That's my PSN ID. I know tons of COD4 glitches. Add me as your friend. Oh, and get a headset

Offline

 

#10 2008-06-25 10:53:43

axel600
Scratcher
Registered: 2007-10-13
Posts: 100+

Re: Massive Issue

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

 

#11 2008-06-25 11:02:49

Jman720
Scratcher
Registered: 2007-11-27
Posts: 1000+

Re: Massive Issue

Happened to me to.  It seems that someone may have hacked scratch.


Solve for x
2+3+2+(-9)+1x+2x=7

Offline

 

#12 2008-06-25 11:03:54

Cyclone103
Scratcher
Registered: 2008-03-20
Posts: 500+

Re: Massive Issue

I Am Scared!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


All your base are belong to us

Offline

 

#13 2008-06-25 11:06:18

Jman720
Scratcher
Registered: 2007-11-27
Posts: 1000+

Re: Massive Issue

It seems to not be having as much trouble now.


Solve for x
2+3+2+(-9)+1x+2x=7

Offline

 

#14 2008-06-25 11:09:26

Cyclone103
Scratcher
Registered: 2008-03-20
Posts: 500+

Re: Massive Issue

I noticed, but am still worried..


All your base are belong to us

Offline

 

#15 2008-06-25 11:20:52

coka
Scratcher
Registered: 2007-11-03
Posts: 1000+

Re: Massive Issue

I just came on forums NOW and it worked! no more problems!


http://i42.tinypic.com/2rot8c2.png

Offline

 

#16 2008-06-25 11:22:15

andresmh
Scratch Team at MIT
Registered: 2007-03-05
Posts: 1000+

Re: Massive Issue

Fixed.


Andres Monroy-Hernandez | Scratch Team at the MIT Media Lab
on identi.ca and  twitter

Offline

 

#17 2008-06-25 11:27:03

Bluestribute
Scratcher
Registered: 2008-01-24
Posts: 1000+

Re: Massive Issue

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


http://img247.imageshack.us/img247/1204/bluestributett4.jpg
That's my PSN ID. I know tons of COD4 glitches. Add me as your friend. Oh, and get a headset

Offline

 

#18 2008-06-25 11:27:13

Cyclone103
Scratcher
Registered: 2008-03-20
Posts: 500+

Re: Massive Issue

andresmh wrote:

Fixed.

Thanks so much!!!!!!!!!!!! I was VERY worried!


All your base are belong to us

Offline

 

#19 2008-06-25 17:40:54

andresmh
Scratch Team at MIT
Registered: 2007-03-05
Posts: 1000+

Re: Massive Issue

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!  big_smile

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.


Andres Monroy-Hernandez | Scratch Team at the MIT Media Lab
on identi.ca and  twitter

Offline

 

Board footer