Search options

Original:http://www.51happy365.com/forum/viewtopic.php?pid=16

Today, I helped a boy to convert phpwind 4.32 to discuz! 4.1. Then I got a problem.
It could convert all tables but table :'pw_members' because of some members' signatures which were overlength.
Here's the solution:

Launch phpmyadmin with browser frist. Go to the table that you'll modify then. After that, click "SQL" on the topmenu. Now, fill the contents that followed into the textbox and click "Go".
Finally, the questionable records would be listed, and you could modify them^^

SELECT * FROM `pw_members` WHERE length(signature) > 255 ;

Attention:

1.The structure of field 'signature' is "text". So, its length couldn't over 255.
2.You can also check some other records with this method.

PS:

For my limited English, I've done my best to express it. I fell sorry if you cannot figure out what I've posted however...