Is something wrong with the Trade Refs?

[DavrosRTS]

Hi all, I tried posting feedback for a trade I just finished and it told me this...

Error, insert query failed, give this to username:TrademasterAdam
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 ( 136, 10752, 'trader', '$30.00', '', 'DavrosRTS@Hotmail.com', '', '', 'Mike O\\'Brien', 'mjobrien10@hotmail.com', 'OK Oklahoma', 'United States of America', 'I have the honour of posting the first Good Trade Ref for Mike. He is easy to work with, his items were packed and mailed with the greatest of care. E-mail responses were a little slow but trading with him is well worth the wait. An A-list Trader in my Book. ', '66.136.146.54', '04/03/07 14:41:05 ', 0, 1, now(), now() )

... I am computer stupid, so what in the Sweet Crispy Walnuts does this mean? Thanks All!

[Linrandir]

Copy that error message and PM it to Adam.

[MokMike]

It's a SQL statement, which is the language the database uses to manage data it stores. It is telling the SQL server to insert, or write a new record, to a table that is structured to hold trade reference information. Things like the amount, the persons involved etc. Common data that each trade transaction should have. First glance, I think the single quote in the last name might be the issue. I know i nthe installs of SQL I am used to ,you need to double up the quotes, so the database knows what you mean. Names are stored as varchars, or strings of characters and numbers, so you bracket them with single quotes so the DB knows when they begin and end.