[Solved] Modify forum user acount

[dorin]

1. As of this year, Romania is fully part of the Schengen area.
Until now, the Netherlands and Austria had something against us.
I felt treated like a second-class human being.
That's what my previous avatar means.
The context has changed. So:
2. I tried to change my avatar accordingly and complete my signature.
2.1 I can't upload and set my new avatar even I've respect the rules (60.000 bits)
2.2 I can't set my new signature:
A computer program does what you tell it to do, not what you want it to do. Murphy's Law (Greer's Third Law)
When all else fails, read the instructions. Murphy's Law
If you don't like "AS IS", DIY. Dorin's law
I receive

Code: Select all

The error message is: 
Error executing SQL in MemberDAOImplJDBC.updateSignature.

I was probably too optimistic.

[Keet]

Error executing SQL in MemberDAOImplJDBC.updateSignature.

I recently updated my signature and had no problem with it. (I only changed the signature, not the avatar.)
A SQL error is often a temporary problem so try again.

[dorin]

Ok, I'll try again and I'll wait longer.

[Keet]

You shouldn't have to wait longer. I just changed my signature again (changed "900+" to "950+") and as you can see it worked as expected.

[Daniels118]

Your signature is too long, try to shorten it [;)]

[Keet]

Your signature is too long, try to shorten it [;)]

That would be a serious flaw in the forum code. User input should always be verified before passing to a SQL query. Unfortunately the forum code is very, very old so nothing can be done about that.

Just checked the input form. You could enter a whole book in the textarea [:))]
Of course that can't be stored in the database, the textarea should have limited the number of characters to what can be stored.

... Checking the page source confirms the flaw: the textarea is missing

Code: Select all

maxlength="??"

That's a beginners mistake.

[dorin]

1. I'm sorry if I offense somebody!
Proof that I'm old and an impatient Balkan.
2. @Daniels118

Your signature is too long, try to shorten it

You've right! That was the problem!

Usually I try to respect the rules.
For signature I've don't sen any rule (number of characters, number of lines or number of characters per line)
Anyway, I considered solve.
Many thanks to all!