Thanks
I read this : https://issues.apache.org/jira/browse/OPENMEETINGS-1218
What is the last version of OpenMeetings
Best regards
a+
phil
Le 15/07/2015 12:22, Maxim Solodovnik a écrit :
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]
<mailto:[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
