(old website database) Collation:latin1_swedish_ci


I think the problem is the fact that the Collation is latin1_swedish_ci

I thought it was utf8_general_ci as a lot of sites that have middle eastern languages have been converted over to utf8_general_ci

Normally when compiling data from Joomla 10+ series export content assumes that it is not utf8_general_ci and will attempt to convert it over.

That's where the two function that were removed earlier come in.
But there seems to be something else a miss, it may be that it is an old version of MySQL that does not support utf8_general_ci.

Is the database and tables/fields all latin1_swedish_ci or a mixture?

Either way I think we need a new approach.
Could you please make sure that you have a backup of the old database.

Then if you could see if you can change the encoding/Collation over to utf8_general_ci This should help

Once the entire database is changed over try compiling again and see how it goes.

If that does no good another idea would be using the backup from the old site to try setting up a new test site on a local standalone server and try compiling from there.

Something like wamp for example.

The best way to go about that would be to create a Joomla 1.0.15 test site and replace the database with the old site database.

This way you will have the old site running under PHP5 and the latest version of MSQL etc and the old site is safe.

Please let me know what you think and we will go from there.