Scratch
archived forums
#1 2010-05-17 22:42:21
Scratch Website Queries?!?
Someone posted this on my project
"why did it say this as a comment: 14 queries took 21 ms Nr Query Error Affected Num. rows Took (ms) 1 SELECT `Pcomment`.`project_id` FROM `pcomments` AS `Pcomment` WHERE `Pcomment`.`id` = 4115659 LIMIT 1 1 1 0 2 SELECT `Project`.`user_id`, `Project`.`locked` FROM `projects` AS `Project` WHERE `Project`.`id` = 1030499 LIMIT 1 1 1 0 3 SELECT `Pcomment`.*, `User`.`id`, `User`.`username`, `User`.`urlname`, `User`.`role`, `User`.`timestamp` FROM `pcomments` AS `Pcomment` LEFT JOIN `users` AS `User`"
Ok so im guessing that is your mysql queries to the database to fetch comments. This doesn't sound secure if someone just saw this- I mean If i knew your password I could hack the databases!
Unless this person is lying but this is so detailed.
Offline
#3 2010-05-18 08:45:53
Re: Scratch Website Queries?!?
I did not see it. A person commenting on my project did, Im guessing they loaded the page and this was in PLACE of a comment. Really weird tho, I think it was a bug. It does say query error but that is one sucky way to mysql_error it by echoing out all your queries I mean imagine if it echoed the DB name.
*I've never seen the "AS" query before lol
Offline
#5 2010-05-18 15:27:37
Re: Scratch Website Queries?!?
fullmoon wrote:
That is really odd. Maybe they were just doing some work on the database at the moment.
I completely agree. It was probably just a little bit of a temporary bug - maybe the browser didn't load the page properly (although that's really unlikely, considering MySQL queries are done on the Server's end of things) - so I'm guessing it was just a bit of database maintenence, like Fullmoon said. Or maybe their servers are messing up - uh-oh!
Offline