| Page: 1 | Rating: Unrated [0] |
Whois Page
| Good [+1]Toggle ReplyLink» Screwhead replied on Sat Apr 21, 2007 @ 9:21am |
 Coolness: 685710 | top of the who's online page. First time I got:
MYSQL ERROR #0 : 0 SELECT DISTINCT (ip), used_on, country FROM stats_ips WHERE used_on > '2007-04-21 09:04:54' AND user_id = '0' AND ip NOT IN (SELECT ip FROM stats_ips WHERE used_on > '2007-04-21 09:04:54' AND user_id != '0') ORDER BY used_on DESC then on refresh the error # changed to 145: MYSQL ERROR #145 : 145 SELECT DISTINCT (ip), used_on, country FROM stats_ips WHERE used_on > '2007-04-21 09:06:01' AND user_id = '0' AND ip NOT IN (SELECT ip FROM stats_ips WHERE used_on > '2007-04-21 09:06:01' AND user_id != '0') ORDER BY used_on DESC |
| I'm feeling bleh right now.. | |
| Good [+1]Toggle ReplyLink» Nuclear replied on Sun Apr 22, 2007 @ 1:55pm |
 Coolness: 2604105 | This was fixed... |
| I'm feeling workaholic right now.. | |
| Good [+1]Toggle ReplyLink» neoform replied on Sun Apr 22, 2007 @ 3:30pm |
 Coolness: 339785 | "AND user_id != '0'"
when you use "!=" the key doesn't get used. |
| I'm feeling you up right now.. | |
| Good [+1]Toggle ReplyLink» Nuclear replied on Mon Apr 23, 2007 @ 12:17pm |
| Coolness: 2604105 | i'll change it to > 0 |
| I'm feeling workaholic right now.. | |
| Good [+1]Toggle ReplyLink» Screwhead replied on Mon May 7, 2007 @ 12:57pm |
| Coolness: 685710 | And again today!
MYSQL ERROR #145 : 145 SELECT DISTINCT (ip), used_on, country FROM stats_ips WHERE used_on > '2007-05-07 12:42:06' AND user_id = '0' AND ip NOT IN (SELECT ip FROM stats_ips WHERE used_on > '2007-05-07 12:42:06' AND user_id > '0') ORDER BY used_on DESC |
| I'm feeling warcracktastic right now.. | |
| Good [+1]Toggle ReplyLink» neoform replied on Mon May 7, 2007 @ 1:06pm |
| Coolness: 339785 | Originally Posted By SCREWHEAD
And again today! MYSQL ERROR #145 : 145 SELECT DISTINCT (ip), used_on, country FROM stats_ips WHERE used_on > '2007-05-07 12:42:06' AND user_id = '0' AND ip NOT IN (SELECT ip FROM stats_ips WHERE used_on > '2007-05-07 12:42:06' AND user_id > '0') ORDER BY used_on DESC You really gotta not show errors to the end user noah.. :P especially not show users your mysql queries.. |
| I'm feeling you up right now.. | |
| Good [+1]Toggle ReplyLink» Screwhead replied on Mon May 7, 2007 @ 1:08pm |
| Coolness: 685710 | zOMG HAXX TYME! |
| I'm feeling warcracktastic right now.. | |
| Good [+1]Toggle ReplyLink» neoform replied on Mon May 7, 2007 @ 1:17pm |
| Coolness: 339785 | nah, you can't hack that query since there aren't any user entered variables.. but in general, showing users the error they just caused is really bad.. |
| I'm feeling you up right now.. | |
| Good [+1]Toggle ReplyLink» Nuclear replied on Mon May 7, 2007 @ 1:22pm |
| Coolness: 2604105 | Yah well after the crash I didn't re-fix everything. |
| I'm feeling workaholic right now.. | |
| Good [+1]Toggle ReplyLink» neoform replied on Mon May 7, 2007 @ 1:42pm |
| Coolness: 339785 | so why not just show errors to admins only?
that's what i do.. |
| I'm feeling you up right now.. | |
| Good [+1]Toggle ReplyLink» Nuclear replied on Tue May 8, 2007 @ 12:13am |
| Coolness: 2604105 | yah i already changed it to do that... |
| I'm feeling workaholic right now.. | |
Whois Page
| Page: 1 |
[ Cumbre de Página ] |
Post A Reply |
You must be logged in to post a reply.
[ Cumbre de Página ] |
