To increase the maximum length of that field, you'll need to change it in two places:
- The dbscripts/xml/ojs_schema.xml descriptor, as you've done
- The live database, by executing:
- Code: Select all
ALTER TABLE article_comments CHANGE comment_title comment_title VARCHAR(255) NOT NULL;
Whenever you upgrade to a newer release, please make sure that this change is kept in the descriptor before
running the upgrade script, or you may truncate your comments.
The reason this is happening is probably that you're not using UTF-8 support in your database (as configured in config.inc.php). This causes mismatches in the lengths of strings containing accents and other special characters, depending on whether you ask PHP or MySQL for the length of that string. If possible, I'd suggest enabling UTF-8 support.
Public Knowledge Project Team