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

#1 2008-03-14 06:49:47

Lanie
Scratcher
Registered: 2008-02-03
Posts: 1000+

Huge Huge Problem I Dont Know What To CAll It

Im getting this on the notification page, and when i delete a message from there it brings up more codes or whatever!

Nr    Query    Error    Affected    Num. rows    Took (ms)
1    SELECT `Notification`.`id`, `Notification`.`user_id`, `Notification`.`type`, `Notification`.`custom_message`, `Notification`.`status` FROM `notifications` AS `Notification` WHERE status='unread' AND user_id=75551 ORDER BY `id` DESC         4    4    174
2    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` FROM `users` AS `User` WHERE id = 75551 LIMIT 1        1    1    1
3    SELECT COUNT(*) AS count FROM `notifications` AS `Notification` WHERE user_id=75551 AND status='unread'         1    1    0
4    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` FROM `announcements` AS `Announcement` LEFT JOIN `users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) WHERE content != ''         1    1    1
5    SELECT COUNT(*) AS count FROM `announcements` AS `Announcement` LEFT JOIN `users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) WHERE content = ''         1    1    4
6    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` FROM `announcements` AS `Announcement` LEFT JOIN `users` AS `User` ON (`Announcement`.`user_id` = `User`.`id`) WHERE 1 = 1

Offline

 

#2 2008-03-14 06:57:58

Paddle2See
Scratch Team
Registered: 2007-10-27
Posts: 1000+

Re: Huge Huge Problem I Dont Know What To CAll It

Yeah, that's SQL database language.  It looks like somebody was running some diagnostics and left them on.  I've notified the team in Troubleshooting and also sent them an e-mail using Contact Us.  I got some sort of error from Contact Us so I'm not sure if that got through.


http://i39.tinypic.com/2nav6o7.gif

Offline

 

#3 2008-03-14 09:07:17

AnNoYeD
Scratcher
Registered: 2008-02-06
Posts: 19

Re: Huge Huge Problem I Dont Know What To CAll It

I was gonna make a thread about this. It's like they put the entire scratch website script I call it the 0010101 glitch.  tongue

Heres a screenie:
http://i29.tinypic.com/23rjxup.jpg


[image too big deleted by Scratch Team]
http://i188.photobucket.com/albums/z58/macrules_640/Weegee.png DON'T LOOK INTO HIS EYES... woops, too late ><

Offline

 

#4 2008-03-14 09:10:32

Bluekingice
Scratcher
Registered: 2007-12-25
Posts: 86

Re: Huge Huge Problem I Dont Know What To CAll It

Its happening to me too!


http://a2.cdn.gaiaonline.com/gaia/members/ava/28/c1/15af04d1c3c128_flip.png?
My GAIA Online avatar.

Offline

 

#5 2008-03-14 15:00:21

Lanie
Scratcher
Registered: 2008-02-03
Posts: 1000+

Re: Huge Huge Problem I Dont Know What To CAll It

Now its gone thanks Paddle2See for leaving them the message ^_^

Offline

 

Board footer