That's the useful information that helps...
So a couple of things. One it would appear that probably need to convert the database to utf8/utf8mb4, though that may may/not correct the issue in total. Other things of "interest" would be the collation on the admin/catalog side as identified for the language being used at least on the admin side. E.g., is English being used for the admin or one of the other "foreign" languages? Another thing, is that as I recall (need to search a little more) I thought that with Hebrew, there was possibly some alternate effort needed. Not quite the same as Japanese or Russian, but similar... There is some guidance about what needed to be done differently within EP4 and/or one's server possibly 20 pages back? It was "recently" discussed and by recent in this case I mean within the last year...
It was discussed by an individual that has been busy updating/modifying code to support Japan so even looking up the Japanese language pack may find the individual and from there look at their posting history to see when/where posted to EP4 (or perhaps they are happily in receipt of this message and can pop in to provide some assistance though there is a "process" by which they may/may not see the message(s) right now.)
To me, what is curious though is that basically all languages use the "same" category names... I would have thought that there would have been more of a translation.
So, short summary, good to know that the database was "upgraded" using zc_install (hopefully did not run into issues that stopped updating of the configuration table which can be tested by attempting to update a configuration option of any setting, if there is a sql error then there is likely some additional "work" to be done/redone).
Next has to do with character encoding of the database and system. Then there is possibly some additional action to address languages; however, there is the discussion that creating a new CSV file has also exhibited a CSV delimiter issue... Again as an assumption, I believe the above provided data is from the CSV that was generated by EP4. The next thing to consider is if there is a "system" issue by generating a new CSV file directly (one line of data would be suggested in a single language) and attempting upload and import... Would suggest again posting the contents of that file here; however, this time please use the [CODE][/CODE] tags generated by pressing the # button in the message box while generating the post.


Reply With Quote
