Search the Forums
Options
Keywords search:


Search in Forum...

Search within...

Match...

Antiquity...

Player messages...

8. AGoT Off Topic
All non Game of Thrones Topics may only be posted here
Moderator: FFG NateFFGAntonffgjafferFFGStuartGeckoGood_TravelerThe Spaniard Topics: 115 | Posts: 1387
Stupid SQL syntax errors while trying to update my profile?!
RJM
Published on 27 February 2009 - 12:32:48

So, I've been trying to edit my signature.  Nothing fancy, just a quote in plain text:

Sansa back away from him.  "You're awful."

"I'm honest.  It's the world that's awful..."  -The Hound

 

But every time I try and update, I get this freakin' error message, or one like it depending on how I tried to tweak the text:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[MySQL][ODBC 3.51 Driver][mysqld-5.0.67-community-nt]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 awful.&nbsp; The Hound<br /> </i></p>' where id_user=14969' at line 1

/edge_asp/edge_funciones.asp, line 85

 

Someone more computer savvy than myself, can you perhaps tell me what the heck I'm doing wrong or need to change to fix the problem?  I'm at my wit's end here over a stupid little signature block.  Thanks!

-Ryan J. Miller

Sansa backed away from him. "You`re awful."
"I`m honest. It`s the world that`s awful…" -The Hound

Page 1 of 1 (4 messages) 1
Reply #1 | Published on 28 February 2009 - 06:24:39

Sansa back away from him. "You are awful."
"I am honest. It is the world that is awful..." -The Hound
 

The  ´ is the problem. Try the above version and it should work.

 

Reply #2 | Published on 28 February 2009 - 11:53:32

Thanks!  Thats really weird, as I could swear in one of my versions I tried it sans '

Its seems to have worked though, and I'll just have to go ahead and leave it with some incorrect punctuation in order to preserve the "actual" quote as written.  ;-)

-Ryan J. Miller

Sansa backed away from him. "You`re awful."
"I`m honest. It`s the world that`s awful…" -The Hound

Reply #3 | Published on 28 February 2009 - 12:25:26

Also remember that there are two apostrophe-like characters on the keyboard: ` and '. If one doesn't work then try the other.

Reply #4 | Published on 28 February 2009 - 12:32:48

Good call, Perthius... Again, hadn't even thought of that.  And what do you know, it worked!  Regards.

-Ryan J. Miller

Sansa backed away from him. "You`re awful."
"I`m honest. It`s the world that`s awful…" -The Hound

Page 1 of 1 (4 messages) 1

© 2013 Fantasy Flight Publishing, Inc. Fantasy Flight Games and the FFG logo are ® of Fantasy Flight Publishing, Inc.  All rights reserved.
Privacy Policy | Terms of Use | Contact | User Support | Rules Questions | Help | RSS