#512 Cannot upgrade 1.7.1 -> 1.9.2 (db error when submitting new events)

[Thomas S.]

Hell

I tried to upgrade from 1.7.1 to 1.9.2
-installed 1.9.2 and copied config.inc.php
-visited the ui and ran the upgrade (enter db credentials)

After that the ui looked fine, but when i wanted to create a new event, i got an error "The database is not available at the moment". In the MRBS logs (apache) i got

[Wed Oct 13 16:06:40.331727 2021] [php7:notice] [pid 12738] [client 149.217.48.74:52510] Uncaught exception 'MRBS\\DBException' in /var/www/html/mrbs-1.9.2/lib/MRBS/DB.php at line 109\nSQLSTATE[23000]: Integrity constraint violation: 1048 Column 'create_by' cannot be null\nSQL: INSERT INTO mrbs_entry (`start_time`, `end_time`, `entry_type`, `repeat_id`, `room_id`, `create_by`, `modified_by`, `name`, `type`, `description`, `status`, `ical_uid`, `ical_sequence`, `ical_recur_id`, `enable_registrant_limit`, `registrant_limit`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\nParams: Array\n(\n    [0] => 1634106600\n    [1] => 1634108400\n    [2] => 0\n    [3] => \n    [4] => 63\n    [5] => \n    [6] => \n    [7] => Test\n    [8] => I\n    [9] => Test\n    [10] => 0\n    [11] => MRBS-6166e7f050d63-061d9306@booking.mpimf-heidelberg.mpg.de\n    [12] => 0\n    [13] => \n    [14] => 1\n    [15] => 1\n)\n\n#0 /var/www/html/mrbs-1.9.2/mrbs_sql.inc(988): MRBS\\DB->command('INSERT INTO mrb...', Array)\n#1 /var/www/html/mrbs-1.9.2/mrbs_sql.inc(1017): MRBS\\mrbsCreateEntry('mrbs_entry', Array)\n#2 /var/www/html/mrbs-1.9.2/mrbs_sql.inc(2457): MRBS\\mrbsCreateSingleEntry(Array)\n#3 /var/www/html/mrbs-1.9.2/edit_entry_handler.php(765): MRBS\\mrbsMakeBookings(Array, NULL, false, NULL, NULL, true, 'series')\n#4 {main}\n\nMRBS GET: Array\n(\n)\nMRBS POST: Array\n(\n    [csrf_token] => 8b8f2617e0ce9402a96b21e9973a47aed67f343b10651d7d261a65b148a29961\n    [returl] => https://booking.mpimf-heidelberg.mpg.de/\n    [rep_id] => 0\n    [edit_type] => series\n    [name] => Test\n    [description] => Test\n    [start_date] => 2021-10-13\n    [start_seconds] => 30600\n    [end_date] => 2021-10-13\n    [end_seconds] => 32400\n    [area] => 19\n    [rooms] => Array\n        (\n            [0] => 63\n        )\n\n    [type] => I\n    [confirmed] => 1\n    [enable_registrant_limit] => on\n    [registrant_limit] => 1\n    [rep_type] => 0\n    [rep_day] => Array\n        (\n            [0] => 3\n        )\n\n    [month_type] => 0\n    [month_absolute] => 13\n    [month_relative_ord] => 2\n    [month_relative_day] => WE\n    [rep_interval] => 1\n    [rep_end_date] => 2021-10-13\n)\nMRBS SESSION: Array\n(\n    [csrf_token] => 8b8f2617e0ce9402a96b21e9973a47aed67f343b10651d7d261a65b148a29961\n    [user] => MRBS\\User Object\n        (\n            [username] => tstather\n            [display_name] => Thomas Stather\n            [email] => tstather@mr.mpg.de\n            [level] => 2\n        )\n\n)\n\n, referer: https://booking.mpimf-heidelberg.mpg.de/edit_entry.php?view=day&year=2021&month=10&day=13&area=19&room=63&hour=8&minute=30&returl=https%3A%2F%2Fbooking.mpimf-heidelberg.mpg.de%2F

How can i fix this issue?

Best,
Thomas

[Campbell Morrison]

Is there any reason that you didn't upgrade to 1.9.4? If it's what I think it is the problem is fixed in 1.9.4. If you can't upgrade to 1.9.4 for some reason then try setting

$auth['admin_can_only_book_for_self'] = true;

[Thomas S.]

Hi

I need the special functionality for role-based access
https://sourceforge.net/p/mrbs/support-requests/2314/?page=0
Your wrote

This is a feature that is under development at the moment. However it is far enough advanced (at least for LDAP authentication) that you could test it and see whether it does what you want. I recommend that you just use it in a test environment initially.

The development is in the roles branch and you can get the latest code by following the Download Snapshot link on that page.

But the branch doesn't exist anymore. Where can i get the functionality?

[Campbell Morrison]

We've moved from Mercurial to GitHub. The branch is still there, but now at https://github.com/meeting-room-booking-system/mrbs-code/tree/roles

[Thomas S.]

Ok thanks. Is it compatible with 1.9.4 or only with 1.9.2? If its only compatible with 1.9.2 i would have to upgrade but this is not psosible because of the error

[Campbell Morrison]

The branch is an enhancement of the latest code in the main branch, which is 1.9.4+. You should be able to use it to upgrade your 1.7.1 system (but take a copy of your 1.7.1 database and web folder first!).

[Thomas S.]

Hi

Yes, thanks. I was able to update to 1.9.4 and will now test the roles branch.

Best,
Thomas