Error in editing requirements

yclam · Post by **yclam** » Fri Nov 20, 2009 8:10 pm

Hello,
I am a new user to TestLink. I encountered the following error when I edit the requirements. I have no idea what cause this error.

ERROR ON exec_query() - database.class.php
1406 - Data too long for column 'scope' at row 1 - UPDATE requirements SET title='Hardware Interface', scope='

I looks that if I have long text inside the requirements, I will have this error. Any text length limitation in the requirements.

Any help will be appreciated!
Thank you.
YC

TurboPT · Post by **TurboPT** » Sat Nov 21, 2009 1:42 am

The 'scope' column is set as type 'text', and this can store up to 65,535 characters.

yclam · Post by **yclam** » Mon Nov 23, 2009 5:14 pm

Hello,
That means it is nothing wrong with the text length since I have only around 200 characters in 'scope' column.
Interesting is even if I did not make any change, I just clicked edit and then save without making any change. The same error message will still come out.

ERROR ON exec_query() - database.class.php
1406 - Data too long for column 'scope' at row 1 - UPDATE requirements SET title='Hardware Interface', scope='

Is this a known bug?
Thank you.

YC

gk1981 · Post by **gk1981** » Wed Nov 25, 2009 7:35 am

Looks like it cannot find the closing single quote for scope.

yclam · Post by **yclam** » Wed Nov 25, 2009 7:18 pm

Hello,
Sorry, "cannot find the closing single quote for scope", I don't know what this means. It is a text field and do I have to put any format character in.
As I said, I did not make any change. I just open it and save it without any change.
I am confusing what I can put into the scope and what I cannot?
Thank you.

YC

TurboPT · Post by **TurboPT** » Thu Nov 26, 2009 2:47 am

Can you check the events, and see if it might show the failed query? (or there might be more detail)

yclam · Post by **yclam** » Thu Nov 26, 2009 5:22 pm

Hello,
here is the details. When I click edit of my requirement, the edit window will come up, then I just hit save button.
it immediately came with

ERROR ON exec_query() - database.class.php
1406 - Data too long for column 'scope' at row 1 - UPDATE requirements SET title='Hardware Interface', scope='

and underneath it will have

\r\n

\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n\r\n\r\n\r\n
\r\n

\r\n

These kind of format characters around every line of my text.

At the bottom, it will show the error again.

', status='V', type='V', modifier_id=1, req_doc_id='Req-002', modification_ts='2009-11-26 18:18:41' WHERE id=10 Query failed: errorcode[1406] errormsg:Data too long for column 'scope' at row 1

This is not a random error. This is consistently happening. Am I doing something wrong. I am surprise noone has this kind of problem.

Thank you.

YC

TurboPT · Post by **TurboPT** » Fri Nov 27, 2009 3:50 am

What is your MySQL version?

Also, if you can, assuming the proper DB permissions, post what you get by issuing this MySQL command:

Code: Select all

show variables like 'character_set%'

yclam · Post by **yclam** » Fri Nov 27, 2009 5:42 pm

Hello,
I am using Easy PHP 5.2.10 and running on the same machine.
I also have MySQL 5.1 running on the same machine, but I don't think I am using it.
Thanks.

YC

TurboPT · Post by **TurboPT** » Fri Nov 27, 2009 9:48 pm

yclam wrote:Hello,
...I also have MySQL 5.1 running on the same machine, but I don't think I am using it.

So when you did the TestLink install, what database was used?

yclam · Post by **yclam** » Mon Nov 30, 2009 6:53 pm

Hello,
Yes, I used MySQL 5.1. Sorry to mislead you.
Her is what I get if I issue "show variables like 'character_set%'" command

character_set_client latin1
character_set_conneciton latin1
character_set_database latin1
character_set_filesystem binary
character_set_results latin1
character_set_server latin1
character_set_system utf8
character_set_dir C:\program Files\MySQL\MySQL Server 5.1\share\charsets\

Thanks,
YC

gk1981 · Post by **gk1981** » Tue Dec 01, 2009 1:03 am

Please check if you have any special characters in your Scope column. Even the innocent looking single quote (') or double quote (") can create problems if it is directly copy-pasted from excel or word. As you can see here "ABC" is different from “ABC”, if you get what I mean.

yclam · Post by **yclam** » Wed Dec 02, 2009 5:23 pm

Hello,
I have no special characters in my scope other than the bullet "•".
My point is even I did not make any change, I still had error when I saved it.
Why I was able to create it, but not to edit it again.
Thanks.

YC