Flyspray - The bug killer!

  • Status Closed
  • Percent Complete
    100%
  • Task Type Bug Report
  • Category Backend/Core
  • Assigned To No-one
  • Operating System All
  • Severity High
  • Priority Low
  • Reported Version 0.9.9.7
  • Due in Version Undecided
  • Due Date Undecided
  • Votes
  • Private
Attached to Project: Flyspray - The bug killer!
Opened by Steven Tredinnick - 15.03.2013
Last edited by Jordan Mendler - 14.01.2015

FS#1850 - Installer not Creating first user

From Email Group

I recently set up FlySpray 0.9.9.7 to use as a simple trouble-ticket system to use for a club to which I belong. I like it a lot. I customized a few things by changing code (mainly, I wanted to remove some of the fields on the task form).

Then today I got the 1.0 development version via GIT, and installed it as a fresh system on another computer. I ran into a few problems:

The admin user id I entered in the setup form never appeared in the flypray_users table. I couldn't login with the super userid. I got around the problem by copying the records from my "production" system's users table. Now I can login.
In the login box at the top right, I get complaints about not finding allow_passwd, etc. Same when I created a new user. Figured out that I needed to add a couple of fields to the prefs table.

The task blocks this from closing
ID Project Summary Priority Severity Assigned To Progress
1849 Flyspray - The bug killer! FS#1849 - Installer Overhaul Low High
50%
Closed by  Jordan Mendler
14.01.2015 23:29
Reason for closing:  Fixed in devel
Steven Tredinnick commented on 15.03.2013 17:44

This seems to happen sometimes its not that the allow_passwd field is missing, it is that the install script is not processing anything after the create user line in the SQL fails... this fails silently with no error message, and is not even attempting a SQL call when looked at with SQL profiler.

Artur Kwiatkowski commented on 02.04.2013 15:02

Not only the _users table is empty, other empty (and they shouldnt) are:
- _groups
- _users_in_groups

I've dumped these three columns from my production and imported them into fresh installation of Flyspray (dev) and I can now log in.

Gobezu Sewu commented on 03.04.2013 11:12

In file setup\upgrade\1.0\flyspray-install.xml

groups should be:

  <query>INSERT INTO groups VALUES (DEFAULT, 'Admin', 'Members have unlimited access to all functionality.', 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 0,1, 1, 1, 1);</query>
  <query>INSERT INTO groups VALUES (DEFAULT, 'Developers', 'Global Developers for all projects', 0, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1,1,  0, 0,1);</query>
  <query>INSERT INTO groups VALUES (DEFAULT, 'Reporters', 'Open new tasks / add comments in all projects', 0, 0, 0, 1, 1, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0,  0, 0,1);</query>
  <query>INSERT INTO groups VALUES (DEFAULT, 'Basic', 'Members can login, relying upon Project permissions only', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0,0,  0, 0,1);</query>
  <query>INSERT INTO groups VALUES (DEFAULT, 'Pending', 'Users who are awaiting approval of their accounts.', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,  0, 0,0);</query>
  <query>INSERT INTO groups VALUES (DEFAULT, 'Project Managers', 'Permission to do anything related to the Default Project.', 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 1,  1, 1,1);</query>

projects should be
<query>INSERT INTO projects VALUES (DEFAULT, 'Default Project', 'CleanFS', 0, 'Welcome to your first Flyspray project! We hope that Flyspray provides you with many hours of increased productivity. If you have any issues, go to http://flyspray.org/support. You can customise this message by clicking the Manage Project link in the menu above...', 1, 'id category tasktype priority severity summary status progress', 'tasktype category severity priority status private assignedto reportedin dueversion duedate progress os votes', 1, 0, , , NULL, '0', NULL, NULL, , 'en', 0, 0, 0, NULL, 'index',0,0,'Undecided');</query> users should be
INSERT INTO users VALUES (DEFAULT, 'super', '1b3231655cebb7a1f783eddf27d254ca', 'Mr Super User', 'super@example.com', 'super@example.com', 0, 1, 1,
, '', 25, 0, 0, 0, 0, 0, 'en');

Êric Enold commented on 07.08.2013 18:05
Êric Enold commented on 07.08.2013 18:06

Submitted a pull-request to fix this: https://github.com/Flyspray/flyspray/pull/14

Loading...

Available keyboard shortcuts

Tasklist

Task Details

Task Editing