Scratch
archived forums
#1 2010-02-18 12:05:00
- steppenwulf
- Scratcher
- Registered: 2009-07-23
- Posts: 1000+
What is this D: Someone help please!
Okay so I'm minding my own buisness and I go to check my messages... I click on a message and I get this freaking long code thingy that I can't understand.
Then I click love-it on a project and it shows this...
SELECT `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`description`, `Project`.`rating`, `Project`.`views`, `Project`.`anonviews`, `Project`.`num_favoriters`, `Project`.`num_raters`, `Project`.`created`, `Project`.`modified`, `Project`.`timestamp`, `Project`.`loveit`, `Project`.`loveitsuniqueip`, `Project`.`num_bookmarks`, `Project`.`version`, `Project`.`flagit`, `Project`.`numberOfSprites`, `Project`.`totalScripts`, `Project`.`has_sound_blocks`, `Project`.`has_sensorboard_blocks`, `Project`.`related_project_id`, `Project`.`based_on_pid`, `Project`.`root_based_on_pid`, `Project`.`related_username`, `Project`.`proj_visibility`, `Project`.`vischangedbyid`, `Project`.`vischangedtime`, `Project`.`safe`, `Project`.`status`, `Project`.`locked`, `Project`.`remixes`, `Project`.`remixer`, `Project`.`upload_ip`, `Project`.`scratch_version_date`, `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`,
It's actually like 15 times longer than that, but I only copyied part of it. It's happening to a few other people too. What is this? D:
Look at this project, http://scratch.mit.edu/projects/PKMNtrainer/893682. Some people posted what they are getting too.
EDIT: I'm getting some long code thing whenever I click favorite, loveit, commentsor try to leave comments.
Last edited by steppenwulf (2010-02-18 12:09:56)
I'm graduating HS this April and going to college in the Fall.
Offline
#2 2010-02-18 12:06:11
- juststickman
- Scratcher
- Registered: 2009-05-31
- Posts: 1000+
Re: What is this D: Someone help please!
I got this when looking at the home page's bottom...
5 queries took 1 ms
Nr Query Error Affected Num. rows Took (ms)
1 SELECT COUNT(*) AS `count` FROM `blocked_ips` AS `BlockedIp` LEFT JOIN `users` AS `User` ON (`BlockedIp`.`user_id` = `User`.`id`) WHERE ip = 1589805176 1 1 1
2 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`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `announcements` AS `Announcement` LEFT JOIN `users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) WHERE content != '' 0 0 0
3 SELECT COUNT(*) AS `count` FROM `announcements` AS `Announcement` LEFT JOIN `users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) WHERE content = '' 1 1 0
4 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`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `users` AS `User` WHERE `User`.`id` = 302800 LIMIT 1 1 1 0
5 SELECT `AdminTag`.`id`, `AdminTag`.`user_id`, `AdminTag`.`tag_id`, `AdminTag`.`status`, `AdminTag`.`timestamp`, `Tag`.`id`, `Tag`.`name`, `Tag`.`timestamp`, `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`.`blocked_till`, `User`.`userpicext`, `User`.`userpic_suffix` FROM `admin_tags` AS `AdminTag` LEFT JOIN `tags` AS `Tag` ON (`AdminTag`.`tag_id` = `Tag`.`id`) LEFT JOIN `users` AS `User` ON (`AdminTag`.`user_id` = `User`.`id`) WHERE `AdminTag`.`status` = 'active' 7 7 0
Adresmh, did you mess up on something?
Last edited by juststickman (2010-02-18 12:06:39)
Offline
#3 2010-02-18 12:09:16
#4 2010-02-18 12:22:01
- steppenwulf
- Scratcher
- Registered: 2009-07-23
- Posts: 1000+
Re: What is this D: Someone help please!
I'm not sure about everyone else, but its fixed for me now.
I'm graduating HS this April and going to college in the Fall.
Offline
#5 2010-02-18 12:34:46
- Paddle2See
- Scratch Team
- Registered: 2007-10-27
- Posts: 1000+
Re: What is this D: Someone help please!
I've seen this before...I think what happened is that somebody forgot to turn of the debug code in the web application and you are seeing all the SQL statements that are executing. It's harmless.
Offline
#6 2010-02-18 12:35:20
- Lucario621
- Community Moderator
- Registered: 2007-10-03
- Posts: 1000+
Re: What is this D: Someone help please!
I saw it too D:
Offline
#7 2010-02-18 12:44:59
- Paddle2See
- Scratch Team
- Registered: 2007-10-27
- Posts: 1000+
Re: What is this D: Someone help please!
Don't worry...it's just debugging statements for the web application. One of the developers forgot to turn them off. They are harmless 
Offline
#8 2010-02-18 12:49:31
Re: What is this D: Someone help please!
Paddle2See wrote:
Don't worry...it's just debugging statements for the web application. One of the developers forgot to turn them off. They are harmless
But one just bit me... are you SURE they're harmless? lol
Anyway, I clicked on lots of stuff but nothing like that happened to me, so I'm guessing it's fixed now.
Offline
#9 2010-02-18 14:12:32
- juststickman
- Scratcher
- Registered: 2009-05-31
- Posts: 1000+
Re: What is this D: Someone help please!
Yup, it's fixed...
FOR NOW!
Last edited by juststickman (2010-02-18 14:12:40)
Offline
#10 2010-02-18 14:39:58
- RHY3756547
- Scratcher
- Registered: 2009-08-15
- Posts: 1000+
Re: What is this D: Someone help please!
juststickman wrote:
...FOR NOW!
-_-
Offline
#11 2010-02-18 14:41:52
Re: What is this D: Someone help please!
Paddle2See wrote:
I've seen this before...I think what happened is that somebody forgot to turn of the debug code in the web application and you are seeing all the SQL statements that are executing. It's harmless.
...or is it? This means that if you know where to hit, you now also know how to hit (I'm now talking about possible SQL injections).
Converting my Scratch projects to Python!
Offline