You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-user@portals.apache.org by Stefano Bianchi <st...@softeco.it> on 2007/01/10 13:10:34 UTC

Moving J1.6 db from MySQL 3.1 to MySQL 5.0

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: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org

Re: Moving J1.6 db from MySQL 3.1 to MySQL 5.0

Posted by Stefano Bianchi <st...@softeco.it>.
Dear all,
I partially fixed it by running MySQL in strict mode and setting 
jdbcCompliantTruncation to false.
Any comment anyway?
Thanks
S

----- Original Message ----- 
From: "Stefano Bianchi" <st...@softeco.it>
To: "JETSPEED Users List" <je...@portals.apache.org>
Sent: Wednesday, January 10, 2007 1:10 PM
Subject: Moving J1.6 db from MySQL 3.1 to MySQL 5.0


> 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: jetspeed-user-unsubscribe@portals.apache.org
> For additional commands, e-mail: jetspeed-user-help@portals.apache.org
>
>
> 




---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-user-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-user-help@portals.apache.org