Hi Qiang:
On Thu, 23 Apr 2009, Qiang Wei wrote:
> To see what happened, we first used apt-show-versions to check the
> mysqldb version, it showed "python2.3-mysqldb/oldstable uptodate
> 1.2.1c2-1". We then went to the mysqldb site, got version 1.2.1_p2 and
> then manually installed it. However, running configure script still
> shows the same error message: 0.9.2 detected.
If you want to install MySQLdb from the upstream tarball, then be sure
to remove the Debian package first:
$ sudo dpkg --purge python2.3-mysqldb
and install the upstream tarball only afterwards.
> We finally decided to install a workable 0.99 ASAP instead of
> debugging 0.71.
Okay. Then you should check your table charset to see if it was defined
as UTF-8 in the past. If it was not, then you will have to convert your
tables to UTF-8, otherwise you would have problems with accented
letters.
To inspect your current table charset, do something like:
$ echo "SHOW CREATE TABLE collection\G;" | /opt/cds-invenio/bin/dbexec
If you need to convert tables to UTF-8, then I can advise you how later.
P.S. (Another option could be to dump your records from your v0.7.1
instance in the MARCXML format and bibupload them into a clean
fresh v0.99.1 install from scratch. This may be convenient if you
don't have very many records. But you would have to copy user and
baskets and download stats and other tables afterwards into the new
site anyway, if you want to preserve that history... depending on
your setup.)
Best regards
--
Tibor Simko ** CERN Document Server ** <http://cds.cern.ch/>
