After Upgrade to Version 3.2.0 (From CWIS Version 3.1.1) we have trouble to edit resource as the edit form don’t show information of all fields (Title and description missing) and the pull down list of Classification al incomplete. Seams that the retrieve of the data its incomplete and when we check the information it’s still there (browsing), but the edit form don’t show it.
Thank in advance
Kind regards
Regarding "Title and Description missing" -- Please visit 'Administration', then 'Metadata Field Ordering' on your site and verify that all your fields are listed. If they are, please check again on the Edit screen and see if the order matches that shown on Metadata Field Ordering.
Regarding the incomplete pull down list -- Is this a problem with the incremental search or the option list display of classifications? The software switches between the two based on the settings in the 'Resrouce Editing' section of Administration / Metadata Field Editor / NameOfYourClassificationField.
Also, are you using a custom CWIS interface? If so, have you customized StdPageStart, StdPageEnd, or EditResource?
Dear Chalpin Thanks for the answer.
We check 'Metadata Field Ordering' and all fields are listed and the order matches.
Regarding the incomplete pull down list (classifications, authors,..) it’s seams a problem with special characters, as our site it’s in Spanish and the missings fields are related to words with accents.
We using a custom CWIS interface, but only change some words to Spanish on StdPageStart, StdPageEnd, but EditResource we haven’t modify.
Thanks in advance
Can you try switching to the default interface and checking if that resolves the problem? Depending on how old your base versions of StdPageStart and StdPasgeEnd were, they could be missing some javascript necessary for the editing dropdowns. I'm presuming here that you're talking about the incremental search dropdown -- there is also an HTML Option list dropdown that may be used, depending on how you have configured your site. The Option List version wouldn't be affected by javascript includes.
As for special characters, these shouldn't be an issue. We're using UTF-8 encoding throughout the software as the default encoding, where accented characters are handled no differently than any other character. You might check your system configuration and verify that your site is configured to use UTF-8 encoding. UTF-8 is the default, but if at some point this was changed in your site configuration, it could cause accented characters to be displayed incorrectly.
Thanks for you help Chalpin
I try the recommendation but it doesn’t solve the problem - Sorry for trouble you .
For better understanding please find attach screen shots of the Edit Resource Form
Click edit first item
2° Missing Title an Description
3° Author field List of existing Authors incomplete
Regards
Pedro
Can you also include a screenshot of Metadata Field Ordering?
Oh! For your third item, you're not talking about the Edit Resource page or the dropdowns on it at all. You're talking about EditResourceSearchName, a completely separate page. Do you have a custom version of EditResourceSearchNames? In the default html for that page (interface/default/EditResourceSearchName.html) on line 25, we're using htmlspecialchars() to prepare vocabulary values for printing. PHP's documentation for htmlspecialchars() says that this will work as long as the data to be encoded and the output document share the same encoding -- Is it possible that your database is not stored in UTF-8? Or that your site's Default Character Encoding (under Administration / System Configuration / Advanced System Configuration) is not UTF-8?
Would you be willing to email me (chalpin@scout.wisc.edu) an SQL dump of your site's database? That would assist greatly in debugging the issue.
Thank you very much for you help.
Find attached screenshot of Metadata Field Ordering.
Do you have a custom version of EditResourceSearchNames? Answer NO
The Default Character Encoding it's set for ISO-8859-1
We just send am email with the SQL dump of our site's database
Regards
Pedro
Attached is a screenshot of what I see when I load the database you sent me into a copy of CWIS 3.2.0. As you can see, the accented characters are appearing correctly.
We both appear to be using Firefox, so it probably isn't a browser issue.
From the database you sent, you appear to be using PHP 5.5.26 and MySQL 5.1.56. Is that correct? I'm on a new MySQL than you are, but my PHP is at 5.3.3. I suspect that PHP has changed some of their character set handling in an unkind way between our two versions. I shall set up a new test server on PHP 5.5.26 and see if I can replicate the problem you are seeing.
I note that your database is in UTF-8 encoding, but your site is set at ISO-8859-1. PHP's documentation says that this can cause problems. I would suggest setting your site's character set to UTF-8, so that it matches your database. I don't know if it will fix this problem, but it will probably avoid other problems.
Thank you Chalpin.
Yes - our hosting (dreamhost) using PHP 5.5.26 and MySQL 5.1.56
We try setting our site's character set to UTF-8, but the problem remains.
We have incomplete pull down lists (classifications, authors,..) in the edit Resource form and it’s seams a problem with special characters, as our site it’s in Spanish and the missings fields of pull down list are related to words with accents.
It's ther any solutions for this problem? - Thanks in advance