Missing records, or incomplete database upgrade 2.4 to 3.0

Moderator: crythias

Post Reply
patoil
Znuny newbie
Posts: 2
Joined: 28 Nov 2010, 18:04
Znuny Version: 3.0

Missing records, or incomplete database upgrade 2.4 to 3.0

Post by patoil »

After cloning my 2.4 otrs into a new VM and upgrading by using the RPM method (fedora), the system comes up apparently keeping all my config, but some It only shows old DB records including my user list. In the following output I`m showing my user list in both systems.
Why am I not getting all my data and how car I restore my 24. DB into a 3.0 system? Is there any DBUpgrade log file? I think I probably lost my complete DB during the upgrade.

New system 3.0
mysql> select * from users;
+----+----------------+------------------------------------+-------+------------+-------------+----------+---------------------+-----------+---------------------+-----------+
| id | login | pw | title | first_name | last_name | valid_id | create_time | create_by | change_time | change_by |
+----+----------------+------------------------------------+-------+------------+-------------+----------+---------------------+-----------+---------------------+-----------+
| 1 | root@localhost | $1$root@loc$vlRo2lnu2XO/R1.Pkv. | | Admin | OTRS | 1 | 2010-07-15 14:13:51 | 1 | 2010-07-15 19:29:51 | 2 |
| 2 | patoil | $1$patoil$FRz3Abxgr91OSQ6cjZRe | | Patricio | xx | 1 | 2010-07-15 16:10:26 | 1 | 2010-07-15 16:10:26 | 1 |
| 3 | andreal | $1$andreal$aZCk.LVtXstoYo5DNaa. | | Andrea | xx | 1 | 2010-07-15 19:03:39 | 2 | 2010-07-15 19:03:39 | 2 |
| 4 | oscard | $1$oscard$SfTsyKZvmgV1Uorj/HW0 | | Oscar | De xx | 1 | 2010-07-15 19:06:20 | 2 | 2010-07-15 19:06:20 | 2 |
| 5 | rubent | $1$rubent$wMtvis4tVGPZrCFGb3y9 | | Ruben | xx | 1 | 2010-07-15 19:07:22 | 2 | 2010-07-15 19:07:22 | 2 |
| 6 | fabiani | $1$fabiani$KsJUEeHyU4N5xQ5zXJJL | | Fabian | xx | 1 | 2010-07-15 19:07:57 | 2 | 2010-07-15 19:07:57 | 2 |
| 7 | mariop | $1$mariop$0CLDtG7nIi3ngWYydNL/ | | Mario | xx | 1 | 2010-07-22 10:44:31 | 4 | 2010-07-22 10:44:31 | 4 |
+----+----------------+------------------------------------+-------+------------+-------------+----------+---------------------+-----------+---------------------+-----------+
7 rows in set (0.00 sec)
Old system 2.4
mysql> select * from users;
+----+------------------+------------------------------------+------------+------------+-------------+----------+---------------------+-----------+---------------------+-----------+
| id | login | pw | salutation | first_name | last_name | valid_id | create_time | create_by | change_time | change_by |
+----+------------------+------------------------------------+------------+------------+-------------+----------+---------------------+-----------+---------------------+-----------+
| 1 | root@localhost | $1$root@loc$vlRo2lnu2XO/R1.Pkv.M | | Admin | OTRS | 1 | 2010-07-15 14:13:51 | 1 | 2010-07-15 19:29:51 | 2 |
| 2 | patoil | $1$patoil$FRz3Abxgr91OSQ6cjZRe | | Patricio | xx | 1 | 2010-07-15 16:10:26 | 1 | 2010-07-15 16:10:26 | 1 |
| 3 | andreal | $1$andreal$aZCk.LVtXstoYo5DNaaI | | Andrea | xx | 1 | 2010-07-15 19:03:39 | 2 | 2010-07-15 19:03:39 | 2 |
| 4 | oscard | $1$oscard$SfTsyKZvmgV1Uorj/HW0 | | Oscar | De xx | 1 | 2010-07-15 19:06:20 | 2 | 2010-07-15 19:06:20 | 2 |
| 5 | rubent | $1$rubent$wMtvis4tVGPZrCFGb3y9 | | Ruben | xx | 1 | 2010-07-15 19:07:22 | 2 | 2010-07-15 19:07:22 | 2 |
| 6 | fabiani | $1$fabiani$KsJUEeHyU4N5xQ5zXJJL | | Fabian | xx | 1 | 2010-07-15 19:07:57 | 2 | 2010-07-15 19:07:57 | 2 |
| 7 | mariop | $1$mariop$0CLDtG7nIi3ngWYydNLW | | Mario | xx | 1 | 2010-07-22 10:44:31 | 4 | 2010-07-22 10:44:31 | 4 |
| 8 | bruno.caldarella | $1$bruno.ca$RlkliwQo37/FYreUx4p9 | | Bruno | xx | 2 | 2010-10-12 07:15:13 | 2 | 2010-10-12 07:15:45 | 2 |
| 9 | eduardoa | $1$eanzello$uubrYu0DLL3nk7DOfiCH | Sr | Eduardo | xx | 1 | 2010-10-12 07:28:00 | 7 | 2010-10-20 08:53:09 | 7 |
| 10 | pablor | $1$pablor$Ll/buQpy8Im75CBMV3Ht | | Pablo | xx | 1 | 2010-10-14 05:02:53 | 2 | 2010-10-14 05:02:53 | 2 |
| 11 | cesark | $1$cesark$gNKtbdtaiCqVpxho9uF1 | | Cesar | xx | 1 | 2010-10-20 02:21:21 | 10 | 2010-10-20 02:21:21 | 10 |
| 12 | joseg | $1$joseg$YLR5EbAUNY0j4pKTQhdu | | Jose Luis | xx | 1 | 2010-10-28 15:04:03 | 10 | 2010-10-28 15:04:03 | 10 |
| 13 | facundoc | $1$facundoc$2NwBY8njISi59hvj6n6r | | Facundo | xx | 1 | 2010-10-28 15:04:45 | 10 | 2010-10-28 15:04:45 | 10 |
| 14 | marcosf | $1$marcosf$y.XmajMTnOYiIkvvSg6l | | Marcos | xx | 1 | 2010-10-28 15:39:49 | 10 | 2010-10-28 15:39:49 | 10 |
| 15 | pablok | $1$pablok$OyxBe5eL.icv/Yc0eMUW | | Pablo | xx | 1 | 2010-11-11 03:48:47 | 10 | 2010-11-11 03:48:47 | 10 |
+----+------------------+------------------------------------+------------+------------+-------------+----------+---------------------+-----------+---------------------+-----------+
15 rows in set (0.00 sec)
Post Reply