ITL Broken?

[nitsky416]

Just tried to post a Trade Ref and got this error (I edited my IP out of it):

Error, insert query failed, give this to username:bartertown INSERT INTO itl ( r_subm_user_id, r_rec_user_id, r_subm_side, r_value, r_subm_name, r_subm_email, r_subm_state, r_subm_country, r_rec_name, r_rec_email, r_rec_state, r_rec_country, r_comments, r_subm_ip, r_date, del, r_trade_type, inputdate, r_trade_date ) VALUES ( 4750, 7288, 'trader', '$50.00', '', 'evan@at0m.org', '', '', 'Anton', 'nomoreauthority@yahoo.com', 'IL Illinois', 'United States of America', 'Just traded some Ork vehicles and SM Scouts for a couple of Chimeras, accessory sprues, and a Forge World Turret with Anton. An excellent trade, great communications and speedy shipping mean I\\'ll definitely trade again!', '128.211.241.XXX', '12/05/05 19:18:28 ', 0, 1, now(), now() )

[nitsky416]

After noticing the odd way the ' character was escaped out of the MySQL query, I edited it out of my comments and it appears to have gone through without a hitch.

[MagickalMemories]

You know... Someone had the same problem with me.
He tried to leave a positive ref. for me and it wouldn't take. When the ITL didn't accept it, he just thought it was down. Every time he tried, though, it was the same. Finally, he deleted the apostrophe and, Voila!

Eric

[TrademasterAdam]

I'm still trying to figure out what I hosed up but yes, it is the '[\b] character which is causing the headache. I'm still looking into it, until then, just take out the apostraphe and it should work no problem.

TrademasterAdam

[nitsky416]

Just from looking at it, it looks like whatever you're filtering it with double-escapes the '...

(captain obvious here I'm sure)

[gsmalcolmson]

I had the same problem. Seems a little silly that an apostrophe can cause such trouble.