CBR Forum   Classifieds   News   Photo Gallery   Search   Member List   Timeslips   Contact   Sponsors   Register   Login  

RE: Words that cause problems...

  Printable Version
CBR >> Other >> CBR Forum Help & Suggestion Center >> RE: Words that cause problems... Page: <<   < prev  1 [2] 3 4   next >   >>
Login
Message << Older Topic   Newer Topic >>
RE: Words that cause problems... - 6/24/2008 6:31:22 PM   
chainstretcher



Posts: 4560
Joined: 11/5/2004
Status: offline
chainstretcher's photo gallery
Whoever said the site is possessed is the big weiner!!!  Sometimes it gives me the error then I post the same thing more spread out and it works.  If any of you break the rhyme and reason for our issues I''ll give you $100 outta my pocket ...

_____________________________

It's better to burn out ...
Than high side!

(in reply to reaper2022)
Post #: 16
RE: Words that cause problems... - 6/24/2008 7:17:23 PM   
rangerscott


Posts: 4102
Joined: 6/18/2007
From: Texas
Status: offline
"I think we should see other people"    Meaning, she''s already seeing someone else and what she really said was, "Get the **** away from me."


< Message edited by rangerscott -- 6/24/2008 7:32:22 PM >

(in reply to chainstretcher)
Post #: 17
RE: Words that cause problems... - 6/24/2008 7:21:04 PM   
ffingers



Posts: 2273
Joined: 6/1/2007
From: Chicago, IL (downtown)
Status: offline
ffingers's photo gallery
bwhahahahaha

_____________________________


See bike diary!

My Buddy = Hayden06f4i
Gamertag = ffingers

(in reply to rangerscott)
Post #: 18
RE: Words that cause problems... - 6/24/2008 7:26:22 PM   
rangerscott


Posts: 4102
Joined: 6/18/2007
From: Texas
Status: offline
We''re just friends.




(in reply to ffingers)
Post #: 19
RE: Words that cause problems... - 6/24/2008 7:29:00 PM   
HARDCORP 8654


Posts: 1427
Joined: 4/23/2007
Status: offline
HARDCORP 8654's photo gallery
Brandon are you smoking crack are just poking fun at the disadvantaged LOL

_____________________________


(in reply to rangerscott)
Post #: 20
RE: Words that cause problems... - 6/24/2008 7:34:26 PM   
rangerscott


Posts: 4102
Joined: 6/18/2007
From: Texas
Status: offline

(in reply to HARDCORP 8654)
Post #: 21
RE: Words that cause problems... - 6/24/2008 7:41:29 PM   
HARDCORP 8654


Posts: 1427
Joined: 4/23/2007
Status: offline
HARDCORP 8654's photo gallery
Brandon that does it voodoo, spirit and myself are on our way for the second intervention.  The first time it was the fat chicks and support your local single mothers thing, now it has escalated to this  lol

_____________________________


(in reply to rangerscott)
Post #: 22
RE: Words that cause problems... - 6/25/2008 4:53:59 AM   
woo545


Posts: 2372
Joined: 6/3/2007
Status: offline
quote:

ORIGINAL: chainstretcher

Whoever said the site is possessed is the big weiner!!!  Sometimes it gives me the error then I post the same thing more spread out and it works.  If any of you break the rhyme and reason for our issues I''''''''''''''''''''''''''''''''ll give you $100 outta my pocket ...


The problems seemed to hinge around SQL reserved words (there are a ton of them). For example a typical SQL statement might look like this:

S E L E C T
     *
F R O M
      tblForum AS f  W I T H ( N O  L O C K )
      I N N E R  J O I N tblMember AS m W I T H ( N O L O C K ) On f.MemberID = m.MemberID
W H E R E
      f.MessageID = 591968
O R D E R  BY
      tblForum.AddDate

I conjecture, that something is improperly modifying the text and causing these particular words to appear incorrectly to the SQL backend. Something else that leads to this conclusion is the conversion of the single quotation marks to 2 single quotation marks (not the double quote character). Single quotation marks are used to denote the beginning and ending of a string (in layman''''s terms). Basically the computer needs to know what needs to be treated as text and what is the actual programming code. Since single quotes are used for the text identifiers, then in order to get the single quote to actually appear in the text, you need to type the single quotes twice.

Again, without seeing the code, this only my best guess. I personally thing you should disable the profanity filter for now and see if things improve. Beyond that you might want to try toggling the quoted identifiers feature in SQL.

I or one of the other programmers on the forum can take a gander at the code, (but might not find the problem if it''''s in a compiled exe or dll).

Is postpro new?


< Message edited by woo545 -- 6/25/2008 5:04:10 AM >


_____________________________

Chugga chugga WOO WOO!!!

(in reply to chainstretcher)
Post #: 23
RE: Words that cause problems... - 6/25/2008 5:20:00 AM   
woot


Posts: 785
Joined: 7/24/2006
From: NS, Canada
Status: offline
woot's photo gallery
woo that''s been my finding as well... any post problem I''ve had has turned out to be an SQL reserved word. As you say - it''s probably related to anti-sql injection code...

_____________________________

2000 CBR 600 F4
Full M4,
-1,+2 520,
Speedohealer (-11.4%), AutoCom Pro, Garmin Nuvi 360 GPS/MP3, Cobra FRS/GMRS , Vortex sliders, mirrored windscreen, Cortech bags and Aux Fuse box.

Safety wired and ready to go

(in reply to woo545)
Post #: 24
RE: Words that cause problems... - 6/25/2008 6:05:47 AM   
OKIEZAC



Posts: 1997
Joined: 6/16/2007
From: Edmond, OK-Mammoth Lakes, CA- currently Ithaca, NY
Status: offline
OKIEZAC's photo gallery
why is this garbage not fixed yet?

_____________________________



No Worries...

(in reply to reaper2022)
Post #: 25
RE: Words that cause problems... - 6/25/2008 7:49:36 AM   
ffingers



Posts: 2273
Joined: 6/1/2007
From: Chicago, IL (downtown)
Status: offline
ffingers's photo gallery
well...i will interject as well and say that this is my finding as well....if i can find the word and remove it my post goes through fine...however...that being said...it doesn''t make sens why some people are not having issues when others do not...

in the morning yesterday one post that didn''t work, worked perfectly fine later that day...the posts were identical...it''s pretty odd..


_____________________________


See bike diary!

My Buddy = Hayden06f4i
Gamertag = ffingers

(in reply to OKIEZAC)
Post #: 26
RE: Words that cause problems... - 6/25/2008 8:16:00 AM   
Northernfirepower



Posts: 3112
Joined: 3/26/2007
From: Central Wisconsin
Status: offline
Northernfirepower's photo gallery
Well, I just wrote a huge post and had no issues for once! Is this a sign of good things to come...I hope?!?!

_____________________________

-2000 Yamaha XT225
-2001 Honda 400EX “Blam Blam”
-1997 Honda CBR600F3 “Skittles”
-2003 Honda CBR600F4i “Widow Maker”

My CBRForum Buddy
: REDD

(in reply to ffingers)
Post #: 27
RE: Words that cause problems... - 6/25/2008 8:37:12 AM   
crashkhanman



Posts: 1985
Joined: 8/18/2007
From: Radford/Fredericksburg
Status: offline
crashkhanman's photo gallery
+1 on SQL reserve words. Add them to the profanity filter...lol

When this is fixed...let''s have an offsite backup config. please.

< Message edited by crashkhanman -- 6/25/2008 8:57:15 AM >


_____________________________



CBRForum Buddy System:
  • Jaynd


    (in reply to Northernfirepower)
  • Post #: 28
    RE: Words that cause problems... - 7/14/2008 7:45:38 PM   
    Kewl Breeze


    Posts: 2114
    Joined: 8/9/2006
    From: ATL GA State Pen
    Status: offline

    quote:

    ORIGINAL: ffingers
    omit the periods - have to have them to post the word

    u.s.e

    w.h.i.l.e

    l.i.k.e

    h.a.v.i.n.g

    compare (sometimes)

    now some of these words work SOMETIMES...but if you are not able to post see if these words are there and change them...might help out...feel free to add to the list


    kicking back to top cuz W-HILE and LI-KE are kicking my ass and they didn''t used to in case others H-aving same problem need a reminder.

    (in reply to ffingers)
    Post #: 29
    RE: Words that cause problems... - 7/14/2008 7:48:31 PM   
    Nauree


    Posts: 2911
    Joined: 6/16/2007
    From: Ponchatoula, LA
    Status: offline
    reinstall or upgrade the message board?

    (in reply to Kewl Breeze)
    Post #: 30
    Login OR Register now to post a reply to this forum topic.
    Page:   <<   < prev  1 [2] 3 4   next >   >>

     
    CBR >> Other >> CBR Forum Help & Suggestion Center
    Jump to:

    Featured Sponsors
    Advertising Info

    Top 10 Posters
    voodoochyl7171
    doncollins6257
    tahoe sc5874
    rrasco5615
    pitsvtec5323
    d2vw14_205099
    tk954rr4914
    vpsophmore4727
    blue fox4575
    chainstretch4560

    New Vendors
    AMSOIL - Performance Oil Technology
    AMSOIL - Performance Oil Technology

    CBR Forum .com is not affiliated with or endorsed by Honda Motor Company.