Dear ALL,
I am trying to move an old J1.6 installation to a new host and I am getting
problems with db.
After exporting and reimporting with SQLYog the jetspeed db from MySQL 3.1
to MySQL 5.0 I get something like:
There has been an error!
org.apache.jetspeed.services.security.UserException: Failed to save user
object : Data truncation: Data too long for column 'OBJECTDATA' at row 1
and also
org.apache.jetspeed.services.security.UserException: Failed to retrieve user
'euoexp1': Cannot convert value '0000-00-00 00:00:00' from column 9 to
TIMESTAMP
I have checked and the contents in the db tables look different, e.g.
OBJECDATA changes and timestamp are stored differently...
Maybe it is just a MySQL issue (sorry), but has anyone successfully moved db
between such different MySQL version?
Any suggestion?
And as I am going to work on a new project, would a blank new installation
for J1.6 work on MySQL 5.0?
Thanks
S
Ing. Stefano Bianchi
Softeco Sismat S.p.A. - www.softeco.it
Via De Marini 1, WTC Tower
16149 GENOA (ITALY)
Tel. +39 010 6026 368
Fax +39 010 6026 350
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
