Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

User login and restore

  • laura881
  • laura881's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 5 months ago #190133 by laura881
Replied by laura881 on topic User login and restore
i searched for "INSERT INTO" but couldnt found anything.

I get this result, when I search for a admin user which I created(I changed name to demo.name@domain.com):
Code:
698698  1       1       Demo Name  N       \N      \N      demo.name@domain.com   N               G       N       fruity  en              N       N       N       Y       3       N       N      NN       N       2019-10-21 09:09:50     0       N       N       N       Y       Y       N       N       N       N       demo.name@domain.com   \N                      15      Y       B       N      X\N      N       \N      \N      \N      \N      \N      Y       Y       0       0       N       N       \N      \N
2       Demo   $2y$10$2kasgEz5ZgtPq0RQ26q6u.Z1ZjpcbP9CiNlE64jJbEL.Pst/AVJm.    demo name  1       auto    demo.name@domain.com   default default default \N      1       2019-10-21 09:10:44.808071      \N
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 5 months ago - 4 years 5 months ago #190138 by DenisChenu
Replied by DenisChenu on topic User login and restore
Since you give really less information than asked (because just have this line explain NOTHING !

DenisChenu wrote: 2. lime_users table in restored DB

Since it's not a LimeSurvey issue (in my opinion)

I leave …

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Last edit: 4 years 5 months ago by DenisChenu.
The topic has been locked.
  • laura881
  • laura881's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 5 months ago #190139 by laura881
Replied by laura881 on topic User login and restore
here my Lime_users table in the restored DB:
Code:
public | lime_users                            | table | limesurvey
(46 rows)
 
limesurvey=# \d lime_users
                                           Table "public.lime_users"
        Column        |            Type             |                        Modifiers
----------------------+-----------------------------+----------------------------------------------------------
 uid                  | integer                     | not null default nextval('lime_users_uid_seq'::regclass)
 users_name           | character varying(64)       | not null default ''::character varying
 password             | text                        | not null
 full_name            | character varying(50)       | not null
 parent_id            | integer                     | not null
 lang                 | character varying(20)       |
 email                | character varying(192)      |
 htmleditormode       | character varying(7)        | default 'default'::character varying
 templateeditormode   | character varying(7)        | not null default 'default'::character varying
 questionselectormode | character varying(7)        | not null default 'default'::character varying
 one_time_pw          | text                        |
 dateformat           | integer                     | not null default 1
 created              | timestamp without time zone |
 modified             | timestamp without time zone |
Indexes:
    "lime_users_pkey" PRIMARY KEY, btree (uid)
    "lime_idx1_users" UNIQUE, btree (users_name)
    "lime_idx2_users" btree (email)
 
limesurvey=#
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
4 years 5 months ago #190166 by DenisChenu
Replied by DenisChenu on topic User login and restore
It's the definition , not the content …

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
  • laura881
  • laura881's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 5 months ago #190167 by laura881
Replied by laura881 on topic User login and restore
thx for your help
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose