Re: Relations

You have encountered a game error. If the problem persists, mention it in the Bugs forum. Attach this information:

insert into _irc_messages(message) values('In Milky Way, Partaxian's will pop your cher (6646) has declard a non-aggression pact with WWF SUPERSTARS (6640).')



You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's will pop your cher (6646) has declard a non-aggression pact with WWF SUPER' at line 1

Is this the game or only me? Happens every time I sign a NAP.

Re: Relations

Does this prevent you from signing the NAP?  Or does it still go through.

Got a few bucks?  The Imperial Tip Jar is accepting contributions!

Re: Relations

Every time I sign a NAP

Re: Relations

using firefox if that has something to do with it..

Re: Relations

does the nap actually go through though?  or is this preventing you from signing naps

Got a few bucks?  The Imperial Tip Jar is accepting contributions!

Re: Relations

plenty people using FF who dont have an issue, try updating your browser or disable the addons

Colorado: even in the 11/01 war i made more hits.
Colorado: 447 blow jobs.
Big Gary:  Only a fool cannot admit when he's wrong...
AW:    i love rim jobs
RisingDown: I know you do

Re: Relations

have disabled all adons.. but yes I do sign them.. but it just looks so stupid every time.. like its not suppose to be there..

Re: Relations

@I like pie
What a dumb question you are asking. Why would it matter if it goes through or not?
The reason for this bug is so obvious a 10 yr old learning mysql would have spotted it:
The ' in Partaxian's closes the string and should not be allowed to be part of a fam name.
And you are a developer ? Really ?

Re: Relations

goldmmbr, what a dumb thing to assume you know why i'm asking.

it matters because of prioritization.  there are a lot of things to be fixed in IC and a lot of things to be looked at in general.  if this is preventing naps from being signed in any way then the urgency is much higher than if it is simply an error message.  if it simply an error message then this can wait a little bit longer.  yes it could be a simple 2 minute fix but if i stop to do every 2 minute fix i won't have time for anything else.

you see, i don't have all the time in the world. i have even less time this weekend because i am working on a tight deadline for my job where guess what, i work as a developer.

what's more is that this error in particular is exposing schema information which is less secure than i'd like.  if/when i do fix this problem i'm going to have to evaluate the error handling and decide what needs to be changed there and prioritize that as well.  there is more to a bug than simply fixing it.  there is also prioritization and time management.  any experienced programmer would recognize this when they see it

but yes, i am a developer.  really.  i've been in the field for over 10 years.  don't assume you know anything about my credentials because you don't.

Got a few bucks?  The Imperial Tip Jar is accepting contributions!

Re: Relations

You gave yourself a tag point out of spite pie? tongue

[13:43] <@RisingDown> never thought i'd say it, but TBO actually did something useful.
[13:43] <@arsy> dont let him see you say that
[13:43] <@RisingDown> oh shit
[13:43] * You were kicked from #room by arsy (kapow!)

Re: Relations

haha no, i think that was one of the mods.  they're used to getting shit from players so i gather that they are sympathizing with me here

Got a few bucks?  The Imperial Tip Jar is accepting contributions!

Re: Relations

Thats amazing.

I was debating on posting again as i have to again close my window after this and open and new one to go back into ic..

a real bug as opposed to this relations one big_smile

[13:43] <@RisingDown> never thought i'd say it, but TBO actually did something useful.
[13:43] <@arsy> dont let him see you say that
[13:43] <@RisingDown> oh shit
[13:43] * You were kicked from #room by arsy (kapow!)

Re: Relations

I've had that bug too, and no, it doesn't prevent a nap from being signed.

Good in nature, but evil by our own free will. Incestuously created by the will to kill

My IC-Wiki Page

Re: Relations

ic doesnt like firefox.  i get that bad link request message everytime i post in forum when using firefox even though it goes through

So I told the cop, "No YOU'RE driving under the influence... of being a JERK!"

http://www.youtube.com/watch?v=eFjjO_lhf9c

Re: Relations

What is there to evaluate and handle?
You cannot have a ' as a valid char.
Any experienced programmer would recognize that this should be of highest priority.
What if someone names his fam:  ') drop table X
Did you think about that when making your "smart" comeback?

Re: Relations

Pie is the best thing to happen to this game in years, stfu or gtfo!

~*✠ ]PW[ Forever ✠*~

Re: Relations

goldmmbr, what's up with the attitude?  First you assume I am asking for more details because I don't know what is causing this bug, and that I don't know what an unescaped string is.  Now you're assuming that I don't know what sql injection is.

Now, I can't go into too much detail because that would be a further security issue, but this particular risk is mitigated because of the way the family name and this query are processed.  Is it theoretically an injection issue?  Absolutely.  However, in its current state what you are describing is simply not possible.  I can't show you the code to explain why because you aren't a developer here.  Nor should I need to.

Does that mean it shouldn't be fixed?  Of course not.  This is still a problem and something I intend to look at.  But honestly, while your concern is a valid one, you are way out of your place here to tell any of us devs what we should be doing.  On top of that, you don't know anything about the actual code files so it is purely by assumption that you "know" what a high priority this should be.

Quit being so arrogant.  You don't know nearly as much as you think you do.

If you have concerns about something try expressing them in a positive, constructive manner.  There's no need to say "And you are a developer ? Really ?"  Honestly, how does that help anything?

Got a few bucks?  The Imperial Tip Jar is accepting contributions!

Re: Relations

Here here! Pie does more for this game than has been done in a long time. And goldmmbr, if you have an issue try expressing it positively, rather than being an arsehole!

Insanity and genius are closely related!
*** Eltie for mod! ***
Failing Lemming of Teachings and Australian Cop Orgies: Gwynedd

Re: Relations

Indeed.

~*✠ ]PW[ Forever ✠*~

20 (edited by Loth 21-Aug-2012 10:52:47)

Re: Relations

I think goldmembr just read a MySQL 101 book in his moms basement and now think he can be a smartass.

(he should just leave well enough alone)

Re: Relations

Political Advisor

"The war has been cancelled!"
You have encountered a game error. If the problem persists, mention it in the Bugs forum. Attach this information:

insert into _irc_messages(message) values('In Pinwheel,#### has cancelled the war with ####.')



You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's ####) has cancelled the war with ####.')' at line 1

also if you cancel war.....

More -=Retired=- then the other bitches tongue