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
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.
Offline
I was gonna make a thread about this. It's like they put the entire scratch website script I call it the 0010101 glitch.
Heres a screenie:
http://i29.tinypic.com/23rjxup.jpg
Offline
Its happening to me too!
Offline