TestLink

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

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

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

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

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

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

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

What is your MySQL version?

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

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

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?

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

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.

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