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/
