You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by phil <pl...@free.fr> on 2015/07/15 12:17:17 UTC
internal error when backup
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/
Re: internal error when backup
Posted by Maxim Solodovnik <so...@gmail.com>.
latest released version is 3.0.6
latest available version 3.0.7-SNAPSHOT
On Wed, Jul 15, 2015 at 7:06 PM, phil <pl...@free.fr> wrote:
> 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 <pl...@free.fr> 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
>
>
>
--
WBR
Maxim aka solomax
Re: internal error when backup
Posted by phil <pl...@free.fr>.
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 <plefebvre@free.fr
> <ma...@free.fr>> 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
Re: internal error when backup
Posted by Maxim Solodovnik <so...@gmail.com>.
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 <pl...@free.fr> 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