Romania
Joined: Apr 24, 2014
Post Count: 625
Status:
Offline
[Solved] Modify forum user acount
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
The error message is: Error executing SQL in MemberDAOImplJDBC.updateSignature.
I was probably too optimistic.
---------------------------------------- A computer program does what you tell it to do, not what you want it to do. Murphy's Law When all else fails, read the instructions. Murphy's Law If you don't like "AS IS", DIY. Dorin's law
----------------------------------------
[Edit 1 times,
last edit by dorin at Jan 4, 2025, 4:02:10 PM]
Netherlands
Joined: Apr 8, 2022
Post Count: 1225
Status:
Offline
Re: Modify forum user acount
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.
---------------------------------------- Dodecagon.nl 950+ 3D models, manuals, and projects
Romania
Joined: Apr 24, 2014
Post Count: 625
Status:
Offline
Re: Modify forum user acount
Ok, I'll try again and I'll wait longer.
---------------------------------------- A computer program does what you tell it to do, not what you want it to do. Murphy's Law When all else fails, read the instructions. Murphy's Law If you don't like "AS IS", DIY. Dorin's law
Netherlands
Joined: Apr 8, 2022
Post Count: 1225
Status:
Offline
Re: Modify forum user acount
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.
---------------------------------------- Dodecagon.nl 950+ 3D models, manuals, and projects
Netherlands
Joined: Apr 8, 2022
Post Count: 1225
Status:
Offline
Re: Modify forum user acount
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
maxlength="??"
That's a beginners mistake.
---------------------------------------- Dodecagon.nl 950+ 3D models, manuals, and projects
----------------------------------------
[Edit 2 times,
last edit by Keet at Jan 4, 2025, 10:16:18 AM]
Romania
Joined: Apr 24, 2014
Post Count: 625
Status:
Offline
Re: Modify forum user acount
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!
---------------------------------------- A computer program does what you tell it to do, not what you want it to do. Murphy's Law When all else fails, read the instructions. Murphy's Law If you don't like "AS IS", DIY. Dorin's law
----------------------------------------
[Edit 1 times,
last edit by dorin at Jan 4, 2025, 4:03:29 PM]