mersenneforum.org  

Go Back   mersenneforum.org > Great Internet Mersenne Prime Search > PrimeNet

Reply
 
Thread Tools
Old 2016-04-09, 13:58   #1
Thecmaster
 
"Arvid Björklin"
Apr 2016
Pitea, Sweden

10001102 Posts
Default Problem: creating a team, tried several times

Hi. I have big problems creating a team. I have tried several times, different hours, night and day. Always same response.

Warning: odbc_do(): SQL error: [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated., SQL state 22001 in SQLExecDirect in C:\inetpub\v5\v5server\0.95_database.inc.php on line 286
Error adding new team Swedesofprime. Please try again later.

I have searched on this forum for other threads only finding old threads about this problem. Please help.

I hope this is right part of the forum for this, if not feel free to move this thread.
And sorry for bad English.
/Arvid
Thecmaster is offline   Reply With Quote
Old 2016-04-09, 18:23   #2
Mark Rose
 
Mark Rose's Avatar
 
"/X\(‘-‘)/X\"
Jan 2013

2,953 Posts
Default

I'm sure Prime95, James, or Madpoo will see this thread soon and fix the issue.

Din engelska är battre än min svenska; det finns ingen anledning att be om ursäkt. Piteå verkade som en trevlig stad när jag passerade genom förra året på semester.
Mark Rose is offline   Reply With Quote
Old 2016-04-09, 22:56   #3
Thecmaster
 
"Arvid Björklin"
Apr 2016
Pitea, Sweden

2×5×7 Posts
Default

Ok, thanx. I can wait.

Quote:
Originally Posted by Mark Rose View Post
I'm sure Prime95, James, or Madpoo will see this thread soon and fix the issue.

Din engelska är battre än min svenska; det finns ingen anledning att be om ursäkt. Piteå verkade som en trevlig stad när jag passerade genom förra året på semester.
Tack Mark Rose. Din svenska är verkligen inte dålig. Om du passerar Piteå vid något annat tillfälle får du höra av dig så bjuder jag på kaffe.
Thecmaster is offline   Reply With Quote
Old 2016-04-10, 00:07   #4
Prime95
P90 years forever!
 
Prime95's Avatar
 
Aug 2002
Yeehaw, FL

11·719 Posts
Default

Quote:
Originally Posted by Thecmaster View Post
Hi. I have big problems creating a team.
The team description is limited to 50 characters.

The web form's team description field includes a size="50" descriptor which apparently does not limit the amount of data that can be typed. I'm not an HTML expert so I don't know what the proper solution is.
Prime95 is offline   Reply With Quote
Old 2016-04-10, 00:18   #5
science_man_88
 
science_man_88's Avatar
 
"Forget I exist"
Jul 2009
Dumbassville

26·131 Posts
Default

Quote:
Originally Posted by Prime95 View Post
The team description is limited to 50 characters.

The web form's team description field includes a size="50" descriptor which apparently does not limit the amount of data that can be typed. I'm not an HTML expert so I don't know what the proper solution is.
http://www.w3schools.com/tags/default.asp for input tags it says:

Quote:
size number Specifies the width, in characters, of an <input> element
so size=50 only specifies that the width of the input element is 50 characters:

what you want is
Quote:
maxlength number Specifies the maximum number of characters allowed in an <input> element
I believe.
science_man_88 is offline   Reply With Quote
Old 2016-04-10, 06:14   #6
Madpoo
Serpentine Vermin Jar
 
Madpoo's Avatar
 
Jul 2014

D0416 Posts
Default

Quote:
Originally Posted by Prime95 View Post
The team description is limited to 50 characters.

The web form's team description field includes a size="50" descriptor which apparently does not limit the amount of data that can be typed. I'm not an HTML expert so I don't know what the proper solution is.
I can take a look at it (unless James beats me to it).

Most inputs have constraints around it, and as noted, SQL did throw the error but it should have been caught earlier, thrown a friendly error to the user.
Madpoo is offline   Reply With Quote
Old 2016-04-10, 06:45   #7
Madpoo
Serpentine Vermin Jar
 
Madpoo's Avatar
 
Jul 2014

333210 Posts
Default

Quote:
Originally Posted by Madpoo View Post
I can take a look at it (unless James beats me to it).

Most inputs have constraints around it, and as noted, SQL did throw the error but it should have been caught earlier, thrown a friendly error to the user.
And... updated.

It gives me a thought that I should check the rest of the input forms for max length directives when appropriate.
Madpoo is offline   Reply With Quote
Old 2016-04-10, 12:08   #8
Thecmaster
 
"Arvid Björklin"
Apr 2016
Pitea, Sweden

2×5×7 Posts
Default

Thanx. Now it work just fine.
Thecmaster is offline   Reply With Quote
Old 2016-04-10, 12:38   #9
retina
Undefined
 
retina's Avatar
 
"The unspeakable one"
Jun 2006
My evil lair

23×283 Posts
Default

Quote:
Originally Posted by Madpoo View Post
It gives me a thought that I should check the rest of the input forms for max length directives when appropriate.
And of course do not trust the data sent from the client to conform to any set limits. Always check on the server that things are what one expects.

Did I hear someone say buffer overflow?
retina is offline   Reply With Quote
Old 2016-04-11, 08:14   #10
LaurV
Romulan Interpreter
 
LaurV's Avatar
 
"name field"
Jun 2011
Thailand

233658 Posts
Default

Quote:
Originally Posted by retina View Post
Did I hear someone say buffer overflow?
https://xkcd.com/327/
LaurV is offline   Reply With Quote
Reply

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a new hub for MF development activities Dubslow Lounge 36 2015-11-10 21:48
Problem: Can't create a team Fox_McCloud_123 Information & Answers 2 2012-05-04 23:25
Creating polynoms with Phi VolMike Factoring 0 2007-07-19 07:21
'Creating' numbers. victor Math 28 2006-01-05 10:53
Creating polls on Mersenneforum JuanTutors Forum Feedback 3 2004-10-03 00:51

All times are UTC. The time now is 08:22.


Sun Jul 3 08:22:48 UTC 2022 up 80 days, 6:24, 0 users, load averages: 0.64, 1.09, 1.23

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.

This forum has received and complied with 0 (zero) government requests for information.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.
A copy of the license is included in the FAQ.

≠ ± ∓ ÷ × · − √ ‰ ⊗ ⊕ ⊖ ⊘ ⊙ ≤ ≥ ≦ ≧ ≨ ≩ ≺ ≻ ≼ ≽ ⊏ ⊐ ⊑ ⊒ ² ³ °
∠ ∟ ° ≅ ~ ‖ ⟂ ⫛
≡ ≜ ≈ ∝ ∞ ≪ ≫ ⌊⌋ ⌈⌉ ∘ ∏ ∐ ∑ ∧ ∨ ∩ ∪ ⨀ ⊕ ⊗ 𝖕 𝖖 𝖗 ⊲ ⊳
∅ ∖ ∁ ↦ ↣ ∩ ∪ ⊆ ⊂ ⊄ ⊊ ⊇ ⊃ ⊅ ⊋ ⊖ ∈ ∉ ∋ ∌ ℕ ℤ ℚ ℝ ℂ ℵ ℶ ℷ ℸ 𝓟
¬ ∨ ∧ ⊕ → ← ⇒ ⇐ ⇔ ∀ ∃ ∄ ∴ ∵ ⊤ ⊥ ⊢ ⊨ ⫤ ⊣ … ⋯ ⋮ ⋰ ⋱
∫ ∬ ∭ ∮ ∯ ∰ ∇ ∆ δ ∂ ℱ ℒ ℓ
𝛢𝛼 𝛣𝛽 𝛤𝛾 𝛥𝛿 𝛦𝜀𝜖 𝛧𝜁 𝛨𝜂 𝛩𝜃𝜗 𝛪𝜄 𝛫𝜅 𝛬𝜆 𝛭𝜇 𝛮𝜈 𝛯𝜉 𝛰𝜊 𝛱𝜋 𝛲𝜌 𝛴𝜎𝜍 𝛵𝜏 𝛶𝜐 𝛷𝜙𝜑 𝛸𝜒 𝛹𝜓 𝛺𝜔