Upgrade 1.9.2 to 1.10 failure

[jberanek]

I tried to follow the readme file and upgrade mrbs from 1.9.2 to 1.10

i kept all settings on the db from 1.9.2 and installes only the new files in the web folder.

After this i tried to login with my db credetials it shows me following error:

Die Datenbank muss erweitert werden. Bitte erstellen Sie eine Sicherung/Kopie Ihrer Datenbank, bevor Sie fortfahren.

Aktualisierung auf Datenbankversion: 78
OK

Aktualisierung auf Datenbankversion: 79
OK

Aktualisierung auf Datenbankversion: 80
OK

Aktualisierung auf Datenbankversion: 81
OK

Uncaught exception 'Exception' in E:\Eigene_Projekte\XAMPP\htdocs\mrbs\web\upgrade\81\post.inc at line 33
Something is wrong with the table structure. Neither the column 'enable_registrant_limit' nor the column 'registrant_limit_enabled' exist. Please raise an MRBS Sourceforge Support Request ticket.
#0 E:\Eigene_Projekte\XAMPP\htdocs\mrbs\web\upgrade.inc(213): include()
#1 E:\Eigene_Projekte\XAMPP\htdocs\mrbs\web\upgrade.inc(237): MRBS\upgrade_database(false, '77', 82, Object(MRBS\DB_mysql))
#2 E:\Eigene_Projekte\XAMPP\htdocs\mrbs\web\upgrade.inc(101): MRBS\do_upgrade(Object(MRBS\DB_mysql))
#3 E:\Eigene_Projekte\XAMPP\htdocs\mrbs\web\defaultincludes.inc(33): require_once('E:\\Eigene_Proje...')
#4 E:\Eigene_Projekte\XAMPP\htdocs\mrbs\web\edit_entry.php(76): require('E:\\Eigene_Proje...')
#5 {main}

MRBS GET: Array
(
)
MRBS POST: Array
(
    [csrf_token] => 9be2a480b3a4f88b411d30c647528db96eabc49c2433e4e347797dc545e9930a
    [form_username] => mrbs
    [form_password] => mrbs-password
)
MRBS SESSION: Array
(
    [csrf_token] => 9be2a480b3a4f88b411d30c647528db96eabc49c2433e4e347797dc545e9930a
)

Oh je! Leider ist in MRBS ein fataler Fehler aufgetreten. Bitte konsultieren Sie Ihren Systemadministrator.

Reported by: haymaker6

Original Ticket: mrbs/support-requests/2497

[jberanek]

What does it mean?

Original comment by: haymaker6

[jberanek]

It means that there was something wrong with your 1.9.2 system for some reason. I would restore your backup and then can you post your entry table structure here?

Original comment by: campbell-m

[jberanek]

Ok, i restored the tables from my backup

here are some scrrenshots from mrbs_entry

Original comment by: haymaker6

Attachments: https://sourceforge.net/p/mrbs/support-requests/_discuss/thread/7244fea549/b748/attachment/mrbs.sql https://sourceforge.net/p/mrbs/support-requests/_discuss/thread/7244fea549/b748/attachment/mrbs3.jpg https://sourceforge.net/p/mrbs/support-requests/_discuss/thread/7244fea549/b748/attachment/mrbs4.jpg

[jberanek]

I'd run the following SQL and try the upgrade again:

ALTER TABLE mrbs_entry
  ADD COLUMN allow_registration       tinyint DEFAULT 0 NOT NULL,
  ADD COLUMN enable_registrant_limit  tinyint DEFAULT 1 NOT NULL,
  ADD COLUMN registrant_limit         int DEFAULT 0 NOT NULL;

Original comment by: campbell-m

[jberanek]

i couldnt find those columns in the original mrbs 1.9.2 backup

i added them kinda manually, seems to work now

thx

Original comment by: haymaker6