you can edit user birthday with "real birthday date" in Admin->Users then age column will be filled with correct data "activatehash" should be NULL for the users created via admin and "not NULL" for the users were created via self-registering. NULL regdate is the cause of your backup errors (already fixed in latest 3.0.7 snapshot)
On Wed, Jul 15, 2015 at 4:17 PM, phil <[email protected]> wrote: > Hi > > I search always how pass the error when backup. > > I have (in database mariadb) on om306 om-users two fields age and regdate > > In the field age, for every user, I have the recording date : ex 2015-07-03 > 13:54:20.000000 > > in the regdate field I have NULL or the same date as age field : Do two > they have to be the same?, Let be the same date. > > For some users in the field : activehash, I have null, is it normal? > > Best regards > > phil > > sorry : I have a poor english > > Here a copy of om_user > > Résultat de la requête SQL > > *Client : * 127.0.0.1 > *Base de données : * open306 > *Généré le : * Mer 15 Juillet 2015 à 12:13 > *Généré par : * phpMyAdmin 4.1.4 / MySQL 5.6.15-log > *Requête SQL : * SELECT * FROM `om_user` ORDER BY `regdate` DESC LIMIT 0, > 25 ; > *Lignes : * 14 > id activatehash age deleted domain_id externalUserId externalUserType > firstname > forceTimeZoneCheck language_id lastlogin lastname lasttrans login owner_id > password pictureuri regdate resethash salutations_id sendSMS show_contact_data > show_contact_data_to_contacts starttime time_zone_id type updatetime > user_offers > user_searchs adresses_id sip_user_id > 9 f48acda6ee572f8af21b187463a6892b 2015-07-10 19:52:02.000000 0 *NULL* > *NULL* *NULL* jmi 0 4 2015-07-10 19:52:24.000000 massieu 0 jmi40 *NULL* > 46b2df2939a170182a167b954b8f84a6 *NULL* 2015-07-10 19:52:02.000000 *NULL* > 1 0 0 1 2015-07-10 19:52:02.000000 Europe/Paris user 2015-07-10 > 19:52:24.000000 > > 9 [->] *NULL* 8 0c53b89c231b528709d44f6f74f99e24 2015-07-08 > 21:17:28.000000 0 *NULL* *NULL* *NULL* pat_visiochatweb 0 4 2015-07-10 > 16:32:03.000000 pat_visiochatweb 0 pat_visiochatweb *NULL* > 736757318f80ed6e5e70e30a509480f9 *NULL* 2015-07-08 21:17:28.000000 *NULL* > 1 0 0 1 2015-07-08 21:17:28.000000 Europe/Paris user 2015-07-10 > 16:32:03.000000 > > 8 [->] *NULL* 4 9b55ec54a1dfd5ece9b826a9ddea1efa 2015-07-07 > 11:38:18.000000 0 *NULL* *NULL* *NULL* mary 0 4 2015-07-07 11:38:30.000000 > line 0 mary *NULL* 7a674153c63cff1ad7f0e261c369ab2c *NULL* 2015-07-07 > 11:38:18.000000 *NULL* 1 0 0 1 2015-07-07 11:38:18.000000 Europe/Paris > user 2015-07-07 12:47:56.000000 *NULL* *NULL* 4 [->] *NULL* 3 > 5106fa7973c6dbb74753984f699fbc3f 2015-07-06 18:51:17.000000 0 *NULL* > *NULL* *NULL* gigi 0 4 2015-07-06 19:00:25.000000 bisoire 0 gigi *NULL* > e96a5614decfacc1df1a87a05403e3ac *NULL* 2015-07-06 18:51:17.000000 *NULL* > 1 0 0 1 2015-07-06 18:51:17.000000 Europe/Paris user 2015-07-10 > 16:12:50.000000 *NULL* *NULL* 3 [->] *NULL* 2 > 4fae9e68f751273b391c750b3a7cd74a 2015-07-03 14:29:22.000000 0 *NULL* > *NULL* *NULL* patrick 0 4 2015-07-11 13:02:09.000000 bisoire 0 dodo *NULL* > 410a048ae7d74d017e761a5f2268f3dc profile.jpg 2015-07-03 14:29:22.000000 > *NULL* 1 0 0 1 2015-07-03 14:29:22.000000 Europe/Paris user 2015-07-11 > 13:02:09.000000 *NULL* *NULL* 2 [->] *NULL* 1 *NULL* 2015-07-03 > 13:54:20.000000 0 *NULL* *NULL* *NULL* Phil 0 4 2015-07-13 11:25:29.000000 > Lefebvre *NULL* phil64 *NULL* d0fc0b3e9b4e6e85c06fa4687921f481 profile.jpg > *NULL* *NULL* 1 0 0 0 2015-07-03 13:54:20.000000 Europe/Paris user 2015-07-13 > 11:25:29.000000 *NULL* *NULL* 1 [->] *NULL* 5 *NULL* 2015-07-07 > 12:23:24.000000 0 *NULL* *NULL* *NULL* pascal 0 4 2015-07-10 > 19:56:18.000000 cheylan *NULL* pascal13100 *NULL* > b59c67bf196a4758191e42f76670ceba *NULL* *NULL* *NULL* 1 0 0 0 2015-07-07 > 12:25:22.000000 Europe/Paris user 2015-07-10 19:56:18.000000 *NULL* *NULL* 5 > [->] *NULL* 6 *NULL* 2015-07-07 13:59:58.000000 0 *NULL* *NULL* *NULL* > *NULL* 0 4 *NULL* *NULL* *NULL* martine *NULL* > 4a7d1ed414474e4033ac29ccb8653d9b *NULL* *NULL* *NULL* 1 0 0 0 2015-07-07 > 14:03:43.000000 Europe/Paris user 2015-07-07 14:03:56.000000 *NULL* *NULL* 6 > [->] *NULL* 7 *NULL* 2015-07-07 14:40:58.000000 0 *NULL* *NULL* *NULL* > *NULL* 0 4 2015-07-12 16:42:18.000000 *NULL* *NULL* tablette *NULL* > 4a7d1ed414474e4033ac29ccb8653d9b *NULL* *NULL* *NULL* 1 0 0 0 2015-07-07 > 14:41:43.000000 Europe/Paris user 2015-07-12 16:42:18.000000 *NULL* *NULL* 7 > [->] *NULL* 10 *NULL* 2015-07-10 20:49:48.000000 0 *NULL* *NULL* *NULL* > wilfried 0 4 *NULL* riviere *NULL* wilfried *NULL* > eb9279982226a42afdf2860dbdc29b45 *NULL* *NULL* *NULL* 1 0 0 0 2015-07-10 > 20:55:54.000000 Europe/Paris user 2015-07-10 20:59:15.000000 *NULL* *NULL* 10 > [->] *NULL* 11 *NULL* 2015-07-11 12:30:01.000000 0 *NULL* *NULL* *NULL* > delphine 0 4 *NULL* baudis *NULL* delphine *NULL* > 4a7d1ed414474e4033ac29ccb8653d9b *NULL* *NULL* *NULL* 2 0 0 0 2015-07-11 > 12:32:14.000000 Europe/Paris user 2015-07-11 12:32:14.000000 *NULL* *NULL* 11 > [->] *NULL* 12 *NULL* 2015-07-11 12:32:32.000000 0 *NULL* *NULL* *NULL* > chantal 0 4 *NULL* haussaire-niquet *NULL* chantal *NULL* > 4a7d1ed414474e4033ac29ccb8653d9b *NULL* *NULL* *NULL* 2 0 0 0 2015-07-11 > 12:34:02.000000 Europe/Paris user 2015-07-11 12:34:02.000000 *NULL* *NULL* 12 > [->] *NULL* 13 *NULL* 2015-07-11 12:34:08.000000 0 *NULL* *NULL* *NULL* > thierry 0 4 *NULL* muraz *NULL* thierry *NULL* > 4a7d1ed414474e4033ac29ccb8653d9b *NULL* *NULL* *NULL* 1 0 0 0 2015-07-11 > 12:35:34.000000 Europe/Paris user 2015-07-11 12:35:34.000000 *NULL* *NULL* 13 > [->] *NULL* 14 *NULL* 2015-07-11 12:35:38.000000 0 *NULL* *NULL* *NULL* > christophe 0 4 *NULL* barone *NULL* christophe *NULL* > 4a7d1ed414474e4033ac29ccb8653d9b *NULL* *NULL* *NULL* 1 0 0 0 2015-07-11 > 12:37:06.000000 Europe/Paris user 2015-07-11 12:37:07.000000 *NULL* *NULL* 14 > [->] *NULL* > > > > -- WBR Maxim aka solomax
